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 tot_emp
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 | ** | ** | ** | ** |
7 | 7 | KY | Owensboro, KY | 100 | 34 | 2.099 | 2.04 |
14 | 14 | NY | Ithaca, NY | 100 | 33.7 | 1.954 | 1.9 |
16 | 16 | MO | St. Joseph, MO-KS | 100 | 12.6 | 1.942 | 1.89 |
60 | 60 | IN | Bloomington, IN | 100 | 3.6 | 1.429 | 1.39 |
75 | 75 | MO | Jefferson City, MO | 100 | 13.6 | 1.36 | 1.32 |
85 | 85 | LA | Monroe, LA | 100 | 4 | 1.308 | 1.27 |
113 | 113 | TN | Clarksville, TN-KY | 100 | 7.7 | 1.212 | 1.18 |
126 | 126 | IN | Lafayette, IN | 100 | 44.5 | 1.171 | 1.14 |
144 | 144 | MO | Columbia, MO | 100 | 16.8 | 1.112 | 1.08 |
147 | 147 | AL | Tuscaloosa, AL | 100 | 20.3 | 1.102 | 1.07 |
166 | 166 | MN | St. Cloud, MN | 100 | 7.7 | 1.06 | 1.03 |
204 | 204 | MS | Gulfport-Biloxi, MS | 100 | 6.3 | 0.995 | 0.97 |
206 | 206 | IL | Springfield, IL | 100 | 18.5 | 0.993 | 0.96 |
214 | 214 | TX | Waco, TX | 100 | 4.6 | 0.978 | 0.95 |
232 | 232 | MD | Hagerstown-Martinsburg, MD-WV | 100 | 6 | 0.954 | 0.93 |
274 | 274 | SC | Spartanburg, SC | 100 | 6.5 | 0.838 | 0.81 |
306 | 306 | MI | Kalamazoo-Portage, MI | 100 | 19 | 0.764 | 0.74 |
311 | 311 | NC | Wilmington, NC | 100 | 5.9 | 0.749 | 0.73 |
315 | 315 | SD | Sioux Falls, SD | 100 | 2.7 | 0.739 | 0.72 |
344 | 344 | CA | Santa Barbara-Santa Maria-Goleta, CA | 100 | 30.7 | 0.606 | 0.59 |
349 | 349 | IN | Evansville, IN-KY | 100 | 4.4 | 0.576 | 0.56 |
181 | 181 | MO | Kansas City, MO-KS | 1020 | 7.9 | 1.03 | 1 |
53 | 53 | PR | San Juan-Caguas-Guaynabo, PR | 1050 | 1.5 | 1.459 | 1.42 |
279 | 279 | CO | Denver-Aurora-Broomfield, CO | 1050 | 2.4 | 0.822 | 0.8 |
121 | 121 | MA | Brockton-Bridgewater-Easton, MA NECTA Division | 110 | 6.9 | 1.178 | 1.14 |
128 | 128 | IL | Champaign-Urbana, IL | 110 | 15.6 | 1.164 | 1.13 |
133 | 133 | VA | Charlottesville, VA | 110 | 7.2 | 1.139 | 1.11 |
172 | 172 | MA | Peabody, MA NECTA Division | 110 | 14.7 | 1.04 | 1.01 |
175 | 175 | TX | Amarillo, TX | 110 | 5.6 | 1.038 | 1.01 |
246 | 246 | MN | Duluth, MN-WI | 110 | 21 | 0.916 | 0.89 |
295 | 295 | NJ | Atlantic City-Hammonton, NJ | 110 | 7.8 | 0.795 | 0.77 |
305 | 305 | WV | Charleston, WV | 110 | 13.3 | 0.774 | 0.75 |
321 | 321 | IL | Rockford, IL | 110 | 14.1 | 0.735 | 0.71 |
342 | 342 | PA | York-Hanover, PA | 110 | 11.6 | 0.645 | 0.63 |
168 | 168 | CA | San Francisco-San Mateo-Redwood City, CA Metropolitan Division | 1100 | 5.1 | 1.05 | 1.02 |
120 | 120 | NJ | Newark-Union, NJ-PA Metropolitan Division | 1130 | 13.2 | 1.179 | 1.15 |
9 | 9 | MD | Bethesda-Rockville-Frederick, MD Metropolitan Division | 1140 | 19.1 | 2.036 | 1.98 |
15 | 15 | DE | Dover, DE | 120 | 42.6 | 1.952 | 1.9 |
38 | 38 | GA | Athens-Clarke County, GA | 120 | 5.1 | 1.556 | 1.51 |
71 | 71 | CO | Greeley, CO | 120 | 5.3 | 1.376 | 1.34 |
98 | 98 | MA | Barnstable Town, MA | 120 | 9 | 1.267 | 1.23 |
131 | 131 | NH | Manchester, NH | 120 | 7.1 | 1.145 | 1.11 |
134 | 134 | NY | Binghamton, NY | 120 | 4 | 1.138 | 1.11 |
191 | 191 | VT | Burlington-South Burlington, VT | 120 | 19 | 1.011 | 0.98 |
199 | 199 | MA | Lowell-Billerica-Chelmsford, MA-NH NECTA Division | 120 | 10.2 | 1.003 | 0.97 |
225 | 225 | ND | Fargo, ND-MN | 120 | 7.3 | 0.964 | 0.94 |
249 | 249 | TX | Lubbock, TX | 120 | 4 | 0.896 | 0.87 |
290 | 290 | LA | Lafayette, LA | 120 | 3.1 | 0.801 | 0.78 |
307 | 307 | CA | Salinas, CA | 120 | 31.1 | 0.76 | 0.74 |
352 | 352 | FL | Cape Coral-Fort Myers, FL | 120 | 22.2 | 0.562 | 0.55 |
369 | 369 | CA | Oxnard-Thousand Oaks-Ventura, CA | 120 | 7.8 | 0.415 | 0.4 |
104 | 104 | OH | Cleveland-Elyria-Mentor, OH | 1250 | 13.5 | 1.241 | 1.21 |
129 | 129 | AR | Fort Smith, AR-OK | 130 | 7.4 | 1.161 | 1.13 |
237 | 237 | IA | Cedar Rapids, IA | 130 | 15.1 | 0.949 | 0.92 |
241 | 241 | OR | Eugene-Springfield, OR | 130 | 9.2 | 0.926 | 0.9 |
267 | 267 | GA | Savannah, GA | 130 | 12.1 | 0.858 | 0.83 |
289 | 289 | WI | Green Bay, WI | 130 | 16.5 | 0.803 | 0.78 |
298 | 298 | NE | Lincoln, NE | 130 | 2 | 0.786 | 0.76 |
329 | 329 | NV | Reno-Sparks, NV | 130 | 0.3 | 0.69 | 0.67 |
337 | 337 | CA | Stockton, CA | 130 | 19 | 0.661 | 0.64 |
187 | 187 | MO | St. Louis, MO-IL | 1320 | 5.7 | 1.024 | 0.99 |
67 | 67 | NJ | Edison-New Brunswick, NJ Metropolitan Division | 1370 | 18.2 | 1.391 | 1.35 |
33 | 33 | IL | Bloomington-Normal, IL | 140 | 9.6 | 1.608 | 1.56 |
58 | 58 | WA | Olympia, WA | 140 | 17.6 | 1.446 | 1.4 |
203 | 203 | OR | Salem, OR | 140 | 8.8 | 0.995 | 0.97 |
218 | 218 | NC | Hickory-Lenoir-Morganton, NC | 140 | 6.1 | 0.971 | 0.94 |
242 | 242 | TX | Beaumont-Port Arthur, TX | 140 | 8.3 | 0.925 | 0.9 |
308 | 308 | TX | Corpus Christi, TX | 140 | 10.2 | 0.755 | 0.73 |
340 | 340 | PA | Lancaster, PA | 140 | 15.4 | 0.649 | 0.63 |
92 | 92 | PA | Pittsburgh, PA | 1440 | 9.4 | 1.275 | 1.24 |
284 | 284 | MN | Minneapolis-St. Paul-Bloomington, MN-WI | 1450 | 4.8 | 0.81 | 0.79 |
195 | 195 | WA | Seattle-Bellevue-Everett, WA Metropolitan Division | 1460 | 5.3 | 1.005 | 0.98 |
26 | 26 | FL | Ocala, FL | 150 | 40.7 | 1.667 | 1.62 |
42 | 42 | VA | Lynchburg, VA | 150 | 18.2 | 1.515 | 1.47 |
158 | 158 | CO | Fort Collins-Loveland, CO | 150 | 1 | 1.079 | 1.05 |
205 | 205 | FL | Pensacola-Ferry Pass-Brent, FL | 150 | 4.6 | 0.994 | 0.97 |
261 | 261 | LA | Shreveport-Bossier City, LA | 150 | 1.1 | 0.871 | 0.85 |
322 | 322 | IN | Fort Wayne, IN | 150 | 4.9 | 0.733 | 0.71 |
111 | 111 | MD | Baltimore-Towson, MD | 1560 | 3.9 | 1.218 | 1.18 |
3 | 3 | PR | Aguadilla-Isabela-San Sebastian, PR | 160 | 4.4 | 3.727 | 3.62 |
11 | 11 | MA | Haverhill-North Andover-Amesbury, MA-NH NECTA Division | 160 | 6 | 1.985 | 1.93 |
19 | 19 | IA | Iowa City, IA | 160 | 45.5 | 1.792 | 1.74 |
109 | 109 | TX | Brownsville-Harlingen, TX | 160 | 2.8 | 1.223 | 1.19 |
114 | 114 | TX | Killeen-Temple-Fort Hood, TX | 160 | 11.6 | 1.211 | 1.18 |
216 | 216 | PA | Reading, PA | 160 | 10.2 | 0.972 | 0.94 |
221 | 221 | AL | Mobile, AL | 160 | 22.8 | 0.968 | 0.94 |
255 | 255 | AK | Anchorage, AK | 160 | 1.8 | 0.888 | 0.86 |
293 | 293 | MI | Lansing-East Lansing, MI | 160 | 12.4 | 0.797 | 0.77 |
299 | 299 | TX | Dallas-Plano-Irving, TX Metropolitan Division | 1680 | 4.6 | 0.784 | 0.76 |
35 | 35 | KS | Topeka, KS | 170 | 10 | 1.604 | 1.56 |
46 | 46 | TN | Kingsport-Bristol-Bristol, TN-VA | 170 | 16 | 1.5 | 1.46 |
69 | 69 | IN | South Bend-Mishawaka, IN-MI | 170 | 5.4 | 1.385 | 1.34 |
73 | 73 | NY | Utica-Rome, NY | 170 | 13.5 | 1.372 | 1.33 |
100 | 100 | NH | Nashua, NH-MA NECTA Division | 170 | 5.8 | 1.266 | 1.23 |
141 | 141 | VA | Roanoke, VA | 170 | 11.1 | 1.118 | 1.09 |
167 | 167 | MA | Framingham, MA NECTA Division | 170 | 10.6 | 1.056 | 1.03 |
4 | 4 | PR | Ponce, PR | 180 | 3.6 | 3.434 | 3.34 |
52 | 52 | NC | Fayetteville, NC | 180 | 6.9 | 1.461 | 1.42 |
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 );