Librarians: librarians-by-msa.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
373 rows sorted by prim_state
This data as json, copyable, CSV (advanced)
Link | rowid | prim_state ▼ | area_name | tot_emp | emp_prse | jobs_1000 | loc_quotient |
---|---|---|---|---|---|---|---|
231 | 231 | AK | Fairbanks, AK | 30 | 0 | 0.955 | 0.93 |
255 | 255 | AK | Anchorage, AK | 160 | 1.8 | 0.888 | 0.86 |
27 | 27 | AL | Auburn-Opelika, AL | 80 | 6.7 | 1.658 | 1.61 |
122 | 122 | AL | Anniston-Oxford, AL | 50 | 13.8 | 1.175 | 1.14 |
138 | 138 | AL | Montgomery, AL | 180 | 3.9 | 1.128 | 1.1 |
147 | 147 | AL | Tuscaloosa, AL | 100 | 20.3 | 1.102 | 1.07 |
182 | 182 | AL | Gadsden, AL | 40 | 12.4 | 1.029 | 1 |
221 | 221 | AL | Mobile, AL | 160 | 22.8 | 0.968 | 0.94 |
264 | 264 | AL | Decatur, AL | 50 | 17.2 | 0.868 | 0.84 |
271 | 271 | AL | Huntsville, AL | 180 | 10.8 | 0.843 | 0.82 |
273 | 273 | AL | Dothan, AL | 50 | 8.9 | 0.839 | 0.82 |
319 | 319 | AL | Birmingham-Hoover, AL | 360 | 10.6 | 0.736 | 0.72 |
332 | 332 | AL | Florence-Muscle Shoals, AL | 30 | 28.3 | 0.669 | 0.65 |
39 | 39 | AR | Jonesboro, AR | 80 | 3.8 | 1.539 | 1.49 |
129 | 129 | AR | Fort Smith, AR-OK | 130 | 7.4 | 1.161 | 1.13 |
137 | 137 | AR | Little Rock-North Little Rock-Conway, AR | 380 | 9.3 | 1.129 | 1.1 |
156 | 156 | AR | Fayetteville-Springdale-Rogers, AR-MO | 230 | 3.6 | 1.086 | 1.06 |
238 | 238 | AR | Pine Bluff, AR | 30 | 3 | 0.935 | 0.91 |
150 | 150 | AZ | Prescott, AZ | 60 | 32.8 | 1.096 | 1.06 |
212 | 212 | AZ | Flagstaff, AZ | 60 | 7.7 | 0.984 | 0.96 |
296 | 296 | AZ | Tucson, AZ | 280 | 5.4 | 0.792 | 0.77 |
356 | 356 | AZ | Yuma, AZ | 30 | 20.4 | 0.54 | 0.52 |
359 | 359 | AZ | Phoenix-Mesa-Glendale, AZ | 950 | 5.5 | 0.531 | 0.52 |
28 | 28 | CA | Madera-Chowchilla, CA | 60 | 30.1 | 1.655 | 1.61 |
154 | 154 | CA | Yuba City, CA | 40 | 23.8 | 1.089 | 1.06 |
168 | 168 | CA | San Francisco-San Mateo-Redwood City, CA Metropolitan Division | 1100 | 5.1 | 1.05 | 1.02 |
213 | 213 | CA | Santa Cruz-Watsonville, CA | 80 | 8.3 | 0.98 | 0.95 |
223 | 223 | CA | Merced, CA | 60 | 31.1 | 0.966 | 0.94 |
256 | 256 | CA | Sacramento--Arden-Arcade--Roseville, CA | 740 | 20.6 | 0.884 | 0.86 |
307 | 307 | CA | Salinas, CA | 120 | 31.1 | 0.76 | 0.74 |
309 | 309 | CA | Oakland-Fremont-Hayward, CA Metropolitan Division | 760 | 16.3 | 0.754 | 0.73 |
313 | 313 | CA | San Jose-Sunnyvale-Santa Clara, CA | 700 | 12.5 | 0.748 | 0.73 |
335 | 335 | CA | San Luis Obispo-Paso Robles, CA | 70 | 25.6 | 0.663 | 0.64 |
337 | 337 | CA | Stockton, CA | 130 | 19 | 0.661 | 0.64 |
339 | 339 | CA | El Centro, CA | 30 | 12.7 | 0.65 | 0.63 |
343 | 343 | CA | Los Angeles-Long Beach-Glendale, CA Metropolitan Division | 2530 | 5.9 | 0.638 | 0.62 |
344 | 344 | CA | Santa Barbara-Santa Maria-Goleta, CA | 100 | 30.7 | 0.606 | 0.59 |
350 | 350 | CA | Fresno, CA | 180 | 24.4 | 0.573 | 0.56 |
354 | 354 | CA | Vallejo-Fairfield, CA | 70 | 11.2 | 0.549 | 0.53 |
358 | 358 | CA | Napa, CA | 40 | 28.4 | 0.533 | 0.52 |
363 | 363 | CA | Santa Rosa-Petaluma, CA | 90 | 21.1 | 0.509 | 0.49 |
364 | 364 | CA | San Diego-Carlsbad-San Marcos, CA | 650 | 6.6 | 0.506 | 0.49 |
366 | 366 | CA | Chico, CA | 30 | 28.3 | 0.49 | 0.48 |
368 | 368 | CA | Riverside-San Bernardino-Ontario, CA | 550 | 19 | 0.459 | 0.45 |
369 | 369 | CA | Oxnard-Thousand Oaks-Ventura, CA | 120 | 7.8 | 0.415 | 0.4 |
370 | 370 | CA | Santa Ana-Anaheim-Irvine, CA Metropolitan Division | 570 | 7 | 0.392 | 0.38 |
371 | 371 | CA | Modesto, CA | 60 | 30.1 | 0.359 | 0.35 |
372 | 372 | CA | Bakersfield-Delano, CA | 90 | 9.8 | 0.304 | 0.3 |
71 | 71 | CO | Greeley, CO | 120 | 5.3 | 1.376 | 1.34 |
153 | 153 | CO | Boulder, CO | 180 | 4.8 | 1.091 | 1.06 |
158 | 158 | CO | Fort Collins-Loveland, CO | 150 | 1 | 1.079 | 1.05 |
211 | 211 | CO | Colorado Springs, CO | 240 | 3.9 | 0.987 | 0.96 |
234 | 234 | CO | Pueblo, CO | 50 | 1.1 | 0.952 | 0.92 |
279 | 279 | CO | Denver-Aurora-Broomfield, CO | 1050 | 2.4 | 0.822 | 0.8 |
333 | 333 | CO | Grand Junction, CO | 40 | 7.3 | 0.668 | 0.65 |
10 | 10 | CT | New Haven, CT | 550 | 9 | 2.01 | 1.95 |
43 | 43 | CT | Norwich-New London, CT-RI | 190 | 11.2 | 1.513 | 1.47 |
47 | 47 | CT | Hartford-West Hartford-East Hartford, CT | 830 | 8.1 | 1.486 | 1.44 |
68 | 68 | CT | Waterbury, CT | 90 | 10.8 | 1.39 | 1.35 |
87 | 87 | CT | Bridgeport-Stamford-Norwalk, CT | 540 | 5.6 | 1.295 | 1.26 |
89 | 89 | CT | Danbury, CT | 90 | 20.4 | 1.284 | 1.25 |
64 | 64 | DC | Washington-Arlington-Alexandria, DC-VA-MD-WV Metropolitan Division | 3340 | 2.4 | 1.409 | 1.37 |
15 | 15 | DE | Dover, DE | 120 | 42.6 | 1.952 | 1.9 |
157 | 157 | DE | Wilmington, DE-MD-NJ Metropolitan Division | 350 | 5.6 | 1.081 | 1.05 |
12 | 12 | FL | Tallahassee, FL | 310 | 3 | 1.975 | 1.92 |
17 | 17 | FL | Gainesville, FL | 220 | 9.1 | 1.805 | 1.75 |
26 | 26 | FL | Ocala, FL | 150 | 40.7 | 1.667 | 1.62 |
74 | 74 | FL | Palm Bay-Melbourne-Titusville, FL | 260 | 6 | 1.363 | 1.32 |
82 | 82 | FL | Deltona-Daytona Beach-Ormond Beach, FL | 200 | 12.2 | 1.319 | 1.28 |
164 | 164 | FL | West Palm Beach-Boca Raton-Boynton Beach, FL Metropolitan Division | 560 | 4 | 1.065 | 1.03 |
194 | 194 | FL | Lakeland-Winter Haven, FL | 200 | 3.4 | 1.007 | 0.98 |
205 | 205 | FL | Pensacola-Ferry Pass-Brent, FL | 150 | 4.6 | 0.994 | 0.97 |
253 | 253 | FL | Panama City-Lynn Haven-Panama City Beach, FL | 60 | 2.5 | 0.893 | 0.87 |
269 | 269 | FL | Sebastian-Vero Beach, FL | 40 | 2.5 | 0.848 | 0.82 |
277 | 277 | FL | Jacksonville, FL | 490 | 10 | 0.827 | 0.8 |
292 | 292 | FL | Tampa-St. Petersburg-Clearwater, FL | 920 | 5.4 | 0.798 | 0.77 |
300 | 300 | FL | North Port-Bradenton-Sarasota, FL | 190 | 4.2 | 0.784 | 0.76 |
301 | 301 | FL | Fort Lauderdale-Pompano Beach-Deerfield Beach, FL Metropolitan Division | 570 | 5.8 | 0.781 | 0.76 |
317 | 317 | FL | Port St. Lucie, FL | 90 | 6.1 | 0.737 | 0.72 |
323 | 323 | FL | Naples-Marco Island, FL | 90 | 1.6 | 0.722 | 0.7 |
334 | 334 | FL | Miami-Miami Beach-Kendall, FL Metropolitan Division | 680 | 6.8 | 0.663 | 0.64 |
345 | 345 | FL | Orlando-Kissimmee-Sanford, FL | 630 | 1.9 | 0.605 | 0.59 |
352 | 352 | FL | Cape Coral-Fort Myers, FL | 120 | 22.2 | 0.562 | 0.55 |
38 | 38 | GA | Athens-Clarke County, GA | 120 | 5.1 | 1.556 | 1.51 |
86 | 86 | GA | Rome, GA | 50 | 25 | 1.304 | 1.27 |
115 | 115 | GA | Albany, GA | 70 | 13.9 | 1.202 | 1.17 |
189 | 189 | GA | Augusta-Richmond County, GA-SC | 210 | 6.6 | 1.015 | 0.99 |
196 | 196 | GA | Warner Robins, GA | 60 | 10.6 | 1.005 | 0.98 |
208 | 208 | GA | Gainesville, GA | 70 | 6.9 | 0.989 | 0.96 |
215 | 215 | GA | Atlanta-Sandy Springs-Marietta, GA | 2250 | 6.6 | 0.975 | 0.95 |
267 | 267 | GA | Savannah, GA | 130 | 12.1 | 0.858 | 0.83 |
268 | 268 | GA | Brunswick, GA | 30 | 9.4 | 0.849 | 0.82 |
280 | 280 | GA | Macon, GA | 80 | 15.8 | 0.822 | 0.8 |
314 | 314 | GA | Columbus, GA-AL | 80 | 14.1 | 0.741 | 0.72 |
326 | 326 | GA | Dalton, GA | 40 | 15.2 | 0.712 | 0.69 |
328 | 328 | GA | Valdosta, GA | 30 | 10.3 | 0.691 | 0.67 |
160 | 160 | HI | Honolulu, HI | 470 | 3.1 | 1.068 | 1.04 |
19 | 19 | IA | Iowa City, IA | 160 | 45.5 | 1.792 | 1.74 |
179 | 179 | IA | Davenport-Moline-Rock Island, IA-IL | 190 | 15.3 | 1.031 | 1 |
209 | 209 | IA | Sioux City, IA-NE-SD | 70 | 18.3 | 0.988 | 0.96 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "librarians/librarians-by-msa" ( "prim_state" TEXT, "area_name" TEXT, "tot_emp" TEXT, "emp_prse" TEXT, "jobs_1000" TEXT, "loc_quotient" TEXT );