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 area_name
This data as json, copyable, CSV (advanced)
Link | rowid | prim_state | area_name ▼ | tot_emp | emp_prse | jobs_1000 | loc_quotient |
---|---|---|---|---|---|---|---|
130 | 130 | TX | Abilene, TX | 70 | 12.4 | 1.155 | 1.12 |
3 | 3 | PR | Aguadilla-Isabela-San Sebastian, PR | 160 | 4.4 | 3.727 | 3.62 |
258 | 258 | OH | Akron, OH | 280 | 10.8 | 0.88 | 0.85 |
115 | 115 | GA | Albany, GA | 70 | 13.9 | 1.202 | 1.17 |
40 | 40 | NY | Albany-Schenectady-Troy, NY | 660 | 5.1 | 1.538 | 1.49 |
341 | 341 | NM | Albuquerque, NM | 240 | 6.8 | 0.645 | 0.63 |
61 | 61 | LA | Alexandria, LA | 90 | 18.9 | 1.421 | 1.38 |
245 | 245 | PA | Allentown-Bethlehem-Easton, PA-NJ | 310 | 9.4 | 0.916 | 0.89 |
175 | 175 | TX | Amarillo, TX | 110 | 5.6 | 1.038 | 1.01 |
247 | 247 | IA | Ames, IA | 40 | 10.3 | 0.902 | 0.88 |
255 | 255 | AK | Anchorage, AK | 160 | 1.8 | 0.888 | 0.86 |
23 | 23 | IN | Anderson, IN | 60 | 15.4 | 1.7 | 1.65 |
97 | 97 | SC | Anderson, SC | 80 | 12 | 1.268 | 1.23 |
59 | 59 | MI | Ann Arbor, MI | 290 | 9 | 1.437 | 1.4 |
122 | 122 | AL | Anniston-Oxford, AL | 50 | 13.8 | 1.175 | 1.14 |
367 | 367 | WI | Appleton, WI | 60 | 19.6 | 0.488 | 0.47 |
178 | 178 | NC | Asheville, NC | 180 | 4.8 | 1.033 | 1 |
38 | 38 | GA | Athens-Clarke County, GA | 120 | 5.1 | 1.556 | 1.51 |
215 | 215 | GA | Atlanta-Sandy Springs-Marietta, GA | 2250 | 6.6 | 0.975 | 0.95 |
295 | 295 | NJ | Atlantic City-Hammonton, NJ | 110 | 7.8 | 0.795 | 0.77 |
27 | 27 | AL | Auburn-Opelika, AL | 80 | 6.7 | 1.658 | 1.61 |
189 | 189 | GA | Augusta-Richmond County, GA-SC | 210 | 6.6 | 1.015 | 0.99 |
185 | 185 | TX | Austin-Round Rock-San Marcos, TX | 880 | 5.4 | 1.026 | 1 |
372 | 372 | CA | Bakersfield-Delano, CA | 90 | 9.8 | 0.304 | 0.3 |
111 | 111 | MD | Baltimore-Towson, MD | 1560 | 3.9 | 1.218 | 1.18 |
83 | 83 | ME | Bangor, ME | 80 | 10.4 | 1.319 | 1.28 |
98 | 98 | MA | Barnstable Town, MA | 120 | 9 | 1.267 | 1.23 |
146 | 146 | LA | Baton Rouge, LA | 410 | 3.2 | 1.105 | 1.07 |
320 | 320 | MI | Battle Creek, MI | 40 | 9.3 | 0.736 | 0.72 |
242 | 242 | TX | Beaumont-Port Arthur, TX | 140 | 8.3 | 0.925 | 0.9 |
318 | 318 | WA | Bellingham, WA | 60 | 16.2 | 0.737 | 0.72 |
9 | 9 | MD | Bethesda-Rockville-Frederick, MD Metropolitan Division | 1140 | 19.1 | 2.036 | 1.98 |
219 | 219 | MT | Billings, MT | 80 | 7.9 | 0.97 | 0.94 |
134 | 134 | NY | Binghamton, NY | 120 | 4 | 1.138 | 1.11 |
319 | 319 | AL | Birmingham-Hoover, AL | 360 | 10.6 | 0.736 | 0.72 |
77 | 77 | ND | Bismarck, ND | 90 | 13.6 | 1.34 | 1.3 |
142 | 142 | VA | Blacksburg-Christiansburg-Radford, VA | 70 | 9.9 | 1.117 | 1.09 |
60 | 60 | IN | Bloomington, IN | 100 | 3.6 | 1.429 | 1.39 |
33 | 33 | IL | Bloomington-Normal, IL | 140 | 9.6 | 1.608 | 1.56 |
240 | 240 | ID | Boise City-Nampa, ID | 250 | 11.4 | 0.927 | 0.9 |
55 | 55 | MA | Boston-Cambridge-Quincy, MA NECTA Division | 2540 | 2.3 | 1.452 | 1.41 |
153 | 153 | CO | Boulder, CO | 180 | 4.8 | 1.091 | 1.06 |
36 | 36 | KY | Bowling Green, KY | 90 | 6.8 | 1.58 | 1.53 |
282 | 282 | WA | Bremerton-Silverdale, WA | 60 | 4.9 | 0.812 | 0.79 |
87 | 87 | CT | Bridgeport-Stamford-Norwalk, CT | 540 | 5.6 | 1.295 | 1.26 |
121 | 121 | MA | Brockton-Bridgewater-Easton, MA NECTA Division | 110 | 6.9 | 1.178 | 1.14 |
109 | 109 | TX | Brownsville-Harlingen, TX | 160 | 2.8 | 1.223 | 1.19 |
268 | 268 | GA | Brunswick, GA | 30 | 9.4 | 0.849 | 0.82 |
210 | 210 | NY | Buffalo-Niagara Falls, NY | 530 | 9.1 | 0.987 | 0.96 |
56 | 56 | NC | Burlington, NC | 80 | 8.3 | 1.452 | 1.41 |
191 | 191 | VT | Burlington-South Burlington, VT | 120 | 19 | 1.011 | 0.98 |
155 | 155 | NJ | Camden, NJ Metropolitan Division | 550 | 10.2 | 1.088 | 1.06 |
80 | 80 | OH | Canton-Massillon, OH | 220 | 8.7 | 1.325 | 1.29 |
352 | 352 | FL | Cape Coral-Fort Myers, FL | 120 | 22.2 | 0.562 | 0.55 |
162 | 162 | MO | Cape Girardeau-Jackson, MO-IL | 40 | 14.1 | 1.068 | 1.04 |
237 | 237 | IA | Cedar Rapids, IA | 130 | 15.1 | 0.949 | 0.92 |
128 | 128 | IL | Champaign-Urbana, IL | 110 | 15.6 | 1.164 | 1.13 |
305 | 305 | WV | Charleston, WV | 110 | 13.3 | 0.774 | 0.75 |
192 | 192 | SC | Charleston-North Charleston-Summerville, SC | 300 | 3.2 | 1.009 | 0.98 |
207 | 207 | NC | Charlotte-Gastonia-Rock Hill, NC-SC | 870 | 2.2 | 0.989 | 0.96 |
133 | 133 | VA | Charlottesville, VA | 110 | 7.2 | 1.139 | 1.11 |
259 | 259 | TN | Chattanooga, TN-GA | 200 | 11.4 | 0.873 | 0.85 |
243 | 243 | WY | Cheyenne, WY | 40 | 0 | 0.922 | 0.9 |
151 | 151 | IL | Chicago-Joliet-Naperville, IL Metropolitan Division | 4050 | 10.3 | 1.094 | 1.06 |
366 | 366 | CA | Chico, CA | 30 | 28.3 | 0.49 | 0.48 |
217 | 217 | OH | Cincinnati-Middletown, OH-KY-IN | 970 | 6 | 0.971 | 0.94 |
113 | 113 | TN | Clarksville, TN-KY | 100 | 7.7 | 1.212 | 1.18 |
103 | 103 | TN | Cleveland, TN | 50 | 8.1 | 1.243 | 1.21 |
104 | 104 | OH | Cleveland-Elyria-Mentor, OH | 1250 | 13.5 | 1.241 | 1.21 |
348 | 348 | ID | Coeur d'Alene, ID | 30 | 17.9 | 0.586 | 0.57 |
233 | 233 | TX | College Station-Bryan, TX | 90 | 26.5 | 0.953 | 0.93 |
211 | 211 | CO | Colorado Springs, CO | 240 | 3.9 | 0.987 | 0.96 |
144 | 144 | MO | Columbia, MO | 100 | 16.8 | 1.112 | 1.08 |
66 | 66 | SC | Columbia, SC | 480 | 2.5 | 1.397 | 1.36 |
314 | 314 | GA | Columbus, GA-AL | 80 | 14.1 | 0.741 | 0.72 |
244 | 244 | OH | Columbus, OH | 860 | 23.5 | 0.917 | 0.89 |
308 | 308 | TX | Corpus Christi, TX | 140 | 10.2 | 0.755 | 0.73 |
79 | 79 | OR | Corvallis, OR | 40 | 6.8 | 1.327 | 1.29 |
63 | 63 | MD | Cumberland, MD-WV | 50 | 18.4 | 1.411 | 1.37 |
299 | 299 | TX | Dallas-Plano-Irving, TX Metropolitan Division | 1680 | 4.6 | 0.784 | 0.76 |
326 | 326 | GA | Dalton, GA | 40 | 15.2 | 0.712 | 0.69 |
89 | 89 | CT | Danbury, CT | 90 | 20.4 | 1.284 | 1.25 |
235 | 235 | VA | Danville, VA | 40 | 24 | 0.951 | 0.92 |
179 | 179 | IA | Davenport-Moline-Rock Island, IA-IL | 190 | 15.3 | 1.031 | 1 |
29 | 29 | OH | Dayton, OH | 610 | 29.7 | 1.652 | 1.6 |
264 | 264 | AL | Decatur, AL | 50 | 17.2 | 0.868 | 0.84 |
116 | 116 | IL | Decatur, IL | 60 | 15.2 | 1.198 | 1.16 |
82 | 82 | FL | Deltona-Daytona Beach-Ormond Beach, FL | 200 | 12.2 | 1.319 | 1.28 |
279 | 279 | CO | Denver-Aurora-Broomfield, CO | 1050 | 2.4 | 0.822 | 0.8 |
310 | 310 | IA | Des Moines-West Des Moines, IA | 250 | 13.8 | 0.75 | 0.73 |
338 | 338 | MI | Detroit-Livonia-Dearborn, MI Metropolitan Division | 460 | 8.9 | 0.651 | 0.63 |
273 | 273 | AL | Dothan, AL | 50 | 8.9 | 0.839 | 0.82 |
15 | 15 | DE | Dover, DE | 120 | 42.6 | 1.952 | 1.9 |
297 | 297 | IA | Dubuque, IA | 50 | 9.4 | 0.791 | 0.77 |
246 | 246 | MN | Duluth, MN-WI | 110 | 21 | 0.916 | 0.89 |
13 | 13 | NC | Durham-Chapel Hill, NC | 540 | 1.7 | 1.962 | 1.91 |
353 | 353 | WI | Eau Claire, WI | 40 | 11.7 | 0.553 | 0.54 |
67 | 67 | NJ | Edison-New Brunswick, NJ Metropolitan Division | 1370 | 18.2 | 1.391 | 1.35 |
339 | 339 | CA | El Centro, CA | 30 | 12.7 | 0.65 | 0.63 |
107 | 107 | TX | El Paso, TX | 350 | 6.1 | 1.234 | 1.2 |
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 );