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 loc_quotient
This data as json, copyable, CSV (advanced)
Link | rowid | prim_state | area_name | tot_emp | emp_prse | jobs_1000 | loc_quotient ▼ |
---|---|---|---|---|---|---|---|
1 | 1 | OH | Springfield, OH | ** | ** | ** | ** |
2 | 2 | WA | Mount Vernon-Anacortes, WA | ** | ** | ** | ** |
373 | 373 | UT | Ogden-Clearfield, UT | 30 | 15.5 | 0.163 | 0.16 |
372 | 372 | CA | Bakersfield-Delano, CA | 90 | 9.8 | 0.304 | 0.3 |
371 | 371 | CA | Modesto, CA | 60 | 30.1 | 0.359 | 0.35 |
370 | 370 | CA | Santa Ana-Anaheim-Irvine, CA Metropolitan Division | 570 | 7 | 0.392 | 0.38 |
369 | 369 | CA | Oxnard-Thousand Oaks-Ventura, CA | 120 | 7.8 | 0.415 | 0.4 |
368 | 368 | CA | Riverside-San Bernardino-Ontario, CA | 550 | 19 | 0.459 | 0.45 |
367 | 367 | WI | Appleton, WI | 60 | 19.6 | 0.488 | 0.47 |
365 | 365 | NV | Las Vegas-Paradise, NV | 410 | 1 | 0.492 | 0.48 |
366 | 366 | CA | Chico, CA | 30 | 28.3 | 0.49 | 0.48 |
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 |
362 | 362 | MI | Grand Rapids-Wyoming, MI | 210 | 14.2 | 0.516 | 0.5 |
360 | 360 | TX | Odessa, TX | 40 | 0 | 0.522 | 0.51 |
361 | 361 | NM | Las Cruces, NM | 40 | 9 | 0.521 | 0.51 |
356 | 356 | AZ | Yuma, AZ | 30 | 20.4 | 0.54 | 0.52 |
357 | 357 | MI | Warren-Troy-Farmington Hills, MI Metropolitan Division | 600 | 8.6 | 0.538 | 0.52 |
358 | 358 | CA | Napa, CA | 40 | 28.4 | 0.533 | 0.52 |
359 | 359 | AZ | Phoenix-Mesa-Glendale, AZ | 950 | 5.5 | 0.531 | 0.52 |
354 | 354 | CA | Vallejo-Fairfield, CA | 70 | 11.2 | 0.549 | 0.53 |
355 | 355 | MI | Flint, MI | 70 | 11.4 | 0.541 | 0.53 |
353 | 353 | WI | Eau Claire, WI | 40 | 11.7 | 0.553 | 0.54 |
351 | 351 | UT | Salt Lake City, UT | 370 | 7.5 | 0.567 | 0.55 |
352 | 352 | FL | Cape Coral-Fort Myers, FL | 120 | 22.2 | 0.562 | 0.55 |
349 | 349 | IN | Evansville, IN-KY | 100 | 4.4 | 0.576 | 0.56 |
350 | 350 | CA | Fresno, CA | 180 | 24.4 | 0.573 | 0.56 |
348 | 348 | ID | Coeur d'Alene, ID | 30 | 17.9 | 0.586 | 0.57 |
346 | 346 | IN | Elkhart-Goshen, IN | 70 | 5.6 | 0.599 | 0.58 |
347 | 347 | WI | Oshkosh-Neenah, WI | 50 | 13.7 | 0.594 | 0.58 |
344 | 344 | CA | Santa Barbara-Santa Maria-Goleta, CA | 100 | 30.7 | 0.606 | 0.59 |
345 | 345 | FL | Orlando-Kissimmee-Sanford, FL | 630 | 1.9 | 0.605 | 0.59 |
343 | 343 | CA | Los Angeles-Long Beach-Glendale, CA Metropolitan Division | 2530 | 5.9 | 0.638 | 0.62 |
338 | 338 | MI | Detroit-Livonia-Dearborn, MI Metropolitan Division | 460 | 8.9 | 0.651 | 0.63 |
339 | 339 | CA | El Centro, CA | 30 | 12.7 | 0.65 | 0.63 |
340 | 340 | PA | Lancaster, PA | 140 | 15.4 | 0.649 | 0.63 |
341 | 341 | NM | Albuquerque, NM | 240 | 6.8 | 0.645 | 0.63 |
342 | 342 | PA | York-Hanover, PA | 110 | 11.6 | 0.645 | 0.63 |
334 | 334 | FL | Miami-Miami Beach-Kendall, FL Metropolitan Division | 680 | 6.8 | 0.663 | 0.64 |
335 | 335 | CA | San Luis Obispo-Paso Robles, CA | 70 | 25.6 | 0.663 | 0.64 |
336 | 336 | WI | Racine, WI | 50 | 16.1 | 0.663 | 0.64 |
337 | 337 | CA | Stockton, CA | 130 | 19 | 0.661 | 0.64 |
332 | 332 | AL | Florence-Muscle Shoals, AL | 30 | 28.3 | 0.669 | 0.65 |
333 | 333 | CO | Grand Junction, CO | 40 | 7.3 | 0.668 | 0.65 |
331 | 331 | TX | Texarkana-Texarkana, TX-AR | 40 | 9.2 | 0.679 | 0.66 |
328 | 328 | GA | Valdosta, GA | 30 | 10.3 | 0.691 | 0.67 |
329 | 329 | NV | Reno-Sparks, NV | 130 | 0.3 | 0.69 | 0.67 |
330 | 330 | WI | Wausau, WI | 40 | 21.5 | 0.686 | 0.67 |
327 | 327 | NM | Farmington, NM | 40 | 4.2 | 0.703 | 0.68 |
325 | 325 | PA | Erie, PA | 90 | 18.6 | 0.712 | 0.69 |
326 | 326 | GA | Dalton, GA | 40 | 15.2 | 0.712 | 0.69 |
323 | 323 | FL | Naples-Marco Island, FL | 90 | 1.6 | 0.722 | 0.7 |
324 | 324 | MI | Saginaw-Saginaw Township North, MI | 60 | 16.3 | 0.716 | 0.7 |
321 | 321 | IL | Rockford, IL | 110 | 14.1 | 0.735 | 0.71 |
322 | 322 | IN | Fort Wayne, IN | 150 | 4.9 | 0.733 | 0.71 |
314 | 314 | GA | Columbus, GA-AL | 80 | 14.1 | 0.741 | 0.72 |
315 | 315 | SD | Sioux Falls, SD | 100 | 2.7 | 0.739 | 0.72 |
316 | 316 | NJ | Vineland-Millville-Bridgeton, NJ | 40 | 5 | 0.739 | 0.72 |
317 | 317 | FL | Port St. Lucie, FL | 90 | 6.1 | 0.737 | 0.72 |
318 | 318 | WA | Bellingham, WA | 60 | 16.2 | 0.737 | 0.72 |
319 | 319 | AL | Birmingham-Hoover, AL | 360 | 10.6 | 0.736 | 0.72 |
320 | 320 | MI | Battle Creek, MI | 40 | 9.3 | 0.736 | 0.72 |
308 | 308 | TX | Corpus Christi, TX | 140 | 10.2 | 0.755 | 0.73 |
309 | 309 | CA | Oakland-Fremont-Hayward, CA Metropolitan Division | 760 | 16.3 | 0.754 | 0.73 |
310 | 310 | IA | Des Moines-West Des Moines, IA | 250 | 13.8 | 0.75 | 0.73 |
311 | 311 | NC | Wilmington, NC | 100 | 5.9 | 0.749 | 0.73 |
312 | 312 | PA | Williamsport, PA | 40 | 14.5 | 0.749 | 0.73 |
313 | 313 | CA | San Jose-Sunnyvale-Santa Clara, CA | 700 | 12.5 | 0.748 | 0.73 |
306 | 306 | MI | Kalamazoo-Portage, MI | 100 | 19 | 0.764 | 0.74 |
307 | 307 | CA | Salinas, CA | 120 | 31.1 | 0.76 | 0.74 |
303 | 303 | WI | Milwaukee-Waukesha-West Allis, WI | 630 | 4.6 | 0.777 | 0.75 |
304 | 304 | WV | Huntington-Ashland, WV-KY-OH | 80 | 10 | 0.777 | 0.75 |
305 | 305 | WV | Charleston, WV | 110 | 13.3 | 0.774 | 0.75 |
298 | 298 | NE | Lincoln, NE | 130 | 2 | 0.786 | 0.76 |
299 | 299 | TX | Dallas-Plano-Irving, TX Metropolitan Division | 1680 | 4.6 | 0.784 | 0.76 |
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 |
302 | 302 | IN | Michigan City-La Porte, IN | 30 | 32.7 | 0.779 | 0.76 |
292 | 292 | FL | Tampa-St. Petersburg-Clearwater, FL | 920 | 5.4 | 0.798 | 0.77 |
293 | 293 | MI | Lansing-East Lansing, MI | 160 | 12.4 | 0.797 | 0.77 |
294 | 294 | TX | Tyler, TX | 70 | 8.2 | 0.797 | 0.77 |
295 | 295 | NJ | Atlantic City-Hammonton, NJ | 110 | 7.8 | 0.795 | 0.77 |
296 | 296 | AZ | Tucson, AZ | 280 | 5.4 | 0.792 | 0.77 |
297 | 297 | IA | Dubuque, IA | 50 | 9.4 | 0.791 | 0.77 |
285 | 285 | TX | Houston-Sugar Land-Baytown, TX | 2230 | 2.4 | 0.808 | 0.78 |
286 | 286 | LA | New Orleans-Metairie-Kenner, LA | 420 | 3.7 | 0.805 | 0.78 |
287 | 287 | OK | Tulsa, OK | 340 | 4.8 | 0.805 | 0.78 |
288 | 288 | KY | Louisville-Jefferson County, KY-IN | 490 | 3.7 | 0.803 | 0.78 |
289 | 289 | WI | Green Bay, WI | 130 | 16.5 | 0.803 | 0.78 |
290 | 290 | LA | Lafayette, LA | 120 | 3.1 | 0.801 | 0.78 |
291 | 291 | TX | Longview, TX | 80 | 11.2 | 0.801 | 0.78 |
281 | 281 | OH | Mansfield, OH | 40 | 17.7 | 0.816 | 0.79 |
282 | 282 | WA | Bremerton-Silverdale, WA | 60 | 4.9 | 0.812 | 0.79 |
283 | 283 | OH | Youngstown-Warren-Boardman, OH-PA | 180 | 13 | 0.811 | 0.79 |
284 | 284 | MN | Minneapolis-St. Paul-Bloomington, MN-WI | 1450 | 4.8 | 0.81 | 0.79 |
277 | 277 | FL | Jacksonville, FL | 490 | 10 | 0.827 | 0.8 |
278 | 278 | MA | Taunton-Norton-Raynham, MA NECTA Division | 40 | 3.7 | 0.827 | 0.8 |
279 | 279 | CO | Denver-Aurora-Broomfield, CO | 1050 | 2.4 | 0.822 | 0.8 |
280 | 280 | GA | Macon, GA | 80 | 15.8 | 0.822 | 0.8 |
274 | 274 | SC | Spartanburg, SC | 100 | 6.5 | 0.838 | 0.81 |
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 );