Librarians: librarians-by-msa.csv

Table actions

This table contains data behind the story Where Are America’s Librarians?

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

373 rows

✎ View and edit SQL

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 ** ** ** **
3 3 PR Aguadilla-Isabela-San Sebastian, PR 160 4.4 3.727 3.62
4 4 PR Ponce, PR 180 3.6 3.434 3.34
5 5 PR San German-Cabo Rojo, PR 50 0.2 2.679 2.6
6 6 PR Mayaguez, PR 80 1.4 2.563 2.49
7 7 KY Owensboro, KY 100 34 2.099 2.04
8 8 NY Nassau-Suffolk, NY Metropolitan Division 2530 6.6 2.05 1.99
9 9 MD Bethesda-Rockville-Frederick, MD Metropolitan Division 1140 19.1 2.036 1.98
10 10 CT New Haven, CT 550 9 2.01 1.95
11 11 MA Haverhill-North Andover-Amesbury, MA-NH NECTA Division 160 6 1.985 1.93
12 12 FL Tallahassee, FL 310 3 1.975 1.92
13 13 NC Durham-Chapel Hill, NC 540 1.7 1.962 1.91
14 14 NY Ithaca, NY 100 33.7 1.954 1.9
15 15 DE Dover, DE 120 42.6 1.952 1.9
16 16 MO St. Joseph, MO-KS 100 12.6 1.942 1.89
17 17 FL Gainesville, FL 220 9.1 1.805 1.75
18 18 NY Poughkeepsie-Newburgh-Middletown, NY 440 10.3 1.802 1.75
19 19 IA Iowa City, IA 160 45.5 1.792 1.74
20 20 KS Lawrence, KS 80 11.7 1.754 1.7
21 21 MA Worcester, MA-CT 420 6.9 1.73 1.68
22 22 ND Grand Forks, ND-MN 90 2.8 1.716 1.67
23 23 IN Anderson, IN 60 15.4 1.7 1.65
24 24 KS Manhattan, KS 80 7.4 1.68 1.63
25 25 MA Springfield, MA-CT 480 9.1 1.67 1.62
26 26 FL Ocala, FL 150 40.7 1.667 1.62
27 27 AL Auburn-Opelika, AL 80 6.7 1.658 1.61
28 28 CA Madera-Chowchilla, CA 60 30.1 1.655 1.61
29 29 OH Dayton, OH 610 29.7 1.652 1.6
30 30 SC Sumter, SC 60 17 1.644 1.6
31 31 WI Sheboygan, WI 90 16.8 1.613 1.57
32 32 OK Lawton, OK 70 23.4 1.612 1.57
33 33 IL Bloomington-Normal, IL 140 9.6 1.608 1.56
34 34 NY Kingston, NY 90 8.1 1.607 1.56
35 35 KS Topeka, KS 170 10 1.604 1.56
36 36 KY Bowling Green, KY 90 6.8 1.58 1.53
37 37 MD Salisbury, MD 80 2.1 1.569 1.52
38 38 GA Athens-Clarke County, GA 120 5.1 1.556 1.51
39 39 AR Jonesboro, AR 80 3.8 1.539 1.49
40 40 NY Albany-Schenectady-Troy, NY 660 5.1 1.538 1.49
41 41 IN Muncie, IN 70 4.3 1.524 1.48
42 42 VA Lynchburg, VA 150 18.2 1.515 1.47
43 43 CT Norwich-New London, CT-RI 190 11.2 1.513 1.47
44 44 MI Niles-Benton Harbor, MI 90 22.9 1.508 1.46
45 45 TX McAllen-Edinburg-Mission, TX 350 3 1.5 1.46
46 46 TN Kingsport-Bristol-Bristol, TN-VA 170 16 1.5 1.46
47 47 CT Hartford-West Hartford-East Hartford, CT 830 8.1 1.486 1.44
48 48 MS Jackson, MS 370 7.7 1.477 1.43
49 49 NY Glens Falls, NY 80 6.7 1.466 1.42
50 50 PA Johnstown, PA 80 8.9 1.465 1.42
51 51 WI Madison, WI 500 5.6 1.463 1.42
52 52 NC Fayetteville, NC 180 6.9 1.461 1.42
53 53 PR San Juan-Caguas-Guaynabo, PR 1050 1.5 1.459 1.42
54 54 MA Pittsfield, MA 50 13.9 1.454 1.41
55 55 MA Boston-Cambridge-Quincy, MA NECTA Division 2540 2.3 1.452 1.41
56 56 NC Burlington, NC 80 8.3 1.452 1.41
57 57 NY Syracuse, NY 440 6.8 1.447 1.41
58 58 WA Olympia, WA 140 17.6 1.446 1.4
59 59 MI Ann Arbor, MI 290 9 1.437 1.4
60 60 IN Bloomington, IN 100 3.6 1.429 1.39
61 61 LA Alexandria, LA 90 18.9 1.421 1.38
62 62 IL Peoria, IL 260 29 1.413 1.37
63 63 MD Cumberland, MD-WV 50 18.4 1.411 1.37
64 64 DC Washington-Arlington-Alexandria, DC-VA-MD-WV Metropolitan Division 3340 2.4 1.409 1.37
65 65 NY Rochester, NY 700 4.4 1.407 1.37
66 66 SC Columbia, SC 480 2.5 1.397 1.36
67 67 NJ Edison-New Brunswick, NJ Metropolitan Division 1370 18.2 1.391 1.35
68 68 CT Waterbury, CT 90 10.8 1.39 1.35
69 69 IN South Bend-Mishawaka, IN-MI 170 5.4 1.385 1.34
70 70 NH Rochester-Dover, NH-ME 70 16.6 1.377 1.34
71 71 CO Greeley, CO 120 5.3 1.376 1.34
72 72 MS Pascagoula, MS 70 18.4 1.375 1.34
73 73 NY Utica-Rome, NY 170 13.5 1.372 1.33
74 74 FL Palm Bay-Melbourne-Titusville, FL 260 6 1.363 1.32
75 75 MO Jefferson City, MO 100 13.6 1.36 1.32
76 76 IL Lake County-Kenosha County, IL-WI Metropolitan Division 510 20.5 1.35 1.31
77 77 ND Bismarck, ND 90 13.6 1.34 1.3
78 78 MA Leominster-Fitchburg-Gardner, MA 60 31.7 1.332 1.29
79 79 OR Corvallis, OR 40 6.8 1.327 1.29
80 80 OH Canton-Massillon, OH 220 8.7 1.325 1.29
81 81 WI Fond du Lac, WI 60 12.2 1.324 1.29
82 82 FL Deltona-Daytona Beach-Ormond Beach, FL 200 12.2 1.319 1.28
83 83 ME Bangor, ME 80 10.4 1.319 1.28
84 84 RI Providence-Fall River-Warwick, RI-MA 710 5 1.315 1.28
85 85 LA Monroe, LA 100 4 1.308 1.27
86 86 GA Rome, GA 50 25 1.304 1.27
87 87 CT Bridgeport-Stamford-Norwalk, CT 540 5.6 1.295 1.26
88 88 NJ Trenton-Ewing, NJ 280 15.6 1.29 1.25
89 89 CT Danbury, CT 90 20.4 1.284 1.25
90 90 PA State College, PA 80 10.6 1.283 1.25
91 91 WV Morgantown, WV 80 7.2 1.278 1.24
92 92 PA Pittsburgh, PA 1440 9.4 1.275 1.24
93 93 VA Virginia Beach-Norfolk-Newport News, VA-NC 920 8.9 1.272 1.24
94 94 ME Portland-South Portland-Biddeford, ME 250 6.6 1.272 1.24
95 95 IL Kankakee-Bradley, IL 50 37.5 1.271 1.23
96 96 TN Morristown, TN 60 9.6 1.269 1.23
97 97 SC Anderson, SC 80 12 1.268 1.23
98 98 MA Barnstable Town, MA 120 9 1.267 1.23
99 99 SC Greenville-Mauldin-Easley, SC 380 8.6 1.266 1.23
100 100 NH Nashua, NH-MA NECTA Division 170 5.8 1.266 1.23

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "librarians/librarians-by-msa" (
"prim_state" TEXT,
  "area_name" TEXT,
  "tot_emp" TEXT,
  "emp_prse" TEXT,
  "jobs_1000" TEXT,
  "loc_quotient" TEXT
);