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 emp_prse
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 | ** | ** | ** | ** |
106 | 106 | VA | Harrisonburg, VA | 70 | 0 | 1.241 | 1.21 |
171 | 171 | LA | Lake Charles, LA | 90 | 0 | 1.045 | 1.01 |
231 | 231 | AK | Fairbanks, AK | 30 | 0 | 0.955 | 0.93 |
243 | 243 | WY | Cheyenne, WY | 40 | 0 | 0.922 | 0.9 |
360 | 360 | TX | Odessa, TX | 40 | 0 | 0.522 | 0.51 |
5 | 5 | PR | San German-Cabo Rojo, PR | 50 | 0.2 | 2.679 | 2.6 |
329 | 329 | NV | Reno-Sparks, NV | 130 | 0.3 | 0.69 | 0.67 |
158 | 158 | CO | Fort Collins-Loveland, CO | 150 | 1 | 1.079 | 1.05 |
365 | 365 | NV | Las Vegas-Paradise, NV | 410 | 1 | 0.492 | 0.48 |
173 | 173 | SD | Rapid City, SD | 60 | 1.1 | 1.039 | 1.01 |
234 | 234 | CO | Pueblo, CO | 50 | 1.1 | 0.952 | 0.92 |
261 | 261 | LA | Shreveport-Bossier City, LA | 150 | 1.1 | 0.871 | 0.85 |
6 | 6 | PR | Mayaguez, PR | 80 | 1.4 | 2.563 | 2.49 |
53 | 53 | PR | San Juan-Caguas-Guaynabo, PR | 1050 | 1.5 | 1.459 | 1.42 |
323 | 323 | FL | Naples-Marco Island, FL | 90 | 1.6 | 0.722 | 0.7 |
13 | 13 | NC | Durham-Chapel Hill, NC | 540 | 1.7 | 1.962 | 1.91 |
222 | 222 | TX | San Antonio-New Braunfels, TX | 860 | 1.8 | 0.967 | 0.94 |
255 | 255 | AK | Anchorage, AK | 160 | 1.8 | 0.888 | 0.86 |
345 | 345 | FL | Orlando-Kissimmee-Sanford, FL | 630 | 1.9 | 0.605 | 0.59 |
35 | 35 | KS | Topeka, KS | 170 | 10 | 1.604 | 1.56 |
277 | 277 | FL | Jacksonville, FL | 490 | 10 | 0.827 | 0.8 |
304 | 304 | WV | Huntington-Ashland, WV-KY-OH | 80 | 10 | 0.777 | 0.75 |
177 | 177 | WI | Janesville, WI | 60 | 10.1 | 1.035 | 1 |
155 | 155 | NJ | Camden, NJ Metropolitan Division | 550 | 10.2 | 1.088 | 1.06 |
188 | 188 | IN | Indianapolis-Carmel, IN | 930 | 10.2 | 1.024 | 0.99 |
199 | 199 | MA | Lowell-Billerica-Chelmsford, MA-NH NECTA Division | 120 | 10.2 | 1.003 | 0.97 |
216 | 216 | PA | Reading, PA | 160 | 10.2 | 0.972 | 0.94 |
308 | 308 | TX | Corpus Christi, TX | 140 | 10.2 | 0.755 | 0.73 |
18 | 18 | NY | Poughkeepsie-Newburgh-Middletown, NY | 440 | 10.3 | 1.802 | 1.75 |
151 | 151 | IL | Chicago-Joliet-Naperville, IL Metropolitan Division | 4050 | 10.3 | 1.094 | 1.06 |
247 | 247 | IA | Ames, IA | 40 | 10.3 | 0.902 | 0.88 |
328 | 328 | GA | Valdosta, GA | 30 | 10.3 | 0.691 | 0.67 |
83 | 83 | ME | Bangor, ME | 80 | 10.4 | 1.319 | 1.28 |
90 | 90 | PA | State College, PA | 80 | 10.6 | 1.283 | 1.25 |
123 | 123 | TN | Jackson, TN | 70 | 10.6 | 1.174 | 1.14 |
167 | 167 | MA | Framingham, MA NECTA Division | 170 | 10.6 | 1.056 | 1.03 |
196 | 196 | GA | Warner Robins, GA | 60 | 10.6 | 1.005 | 0.98 |
319 | 319 | AL | Birmingham-Hoover, AL | 360 | 10.6 | 0.736 | 0.72 |
68 | 68 | CT | Waterbury, CT | 90 | 10.8 | 1.39 | 1.35 |
258 | 258 | OH | Akron, OH | 280 | 10.8 | 0.88 | 0.85 |
271 | 271 | AL | Huntsville, AL | 180 | 10.8 | 0.843 | 0.82 |
141 | 141 | VA | Roanoke, VA | 170 | 11.1 | 1.118 | 1.09 |
43 | 43 | CT | Norwich-New London, CT-RI | 190 | 11.2 | 1.513 | 1.47 |
197 | 197 | TX | Sherman-Denison, TX | 40 | 11.2 | 1.004 | 0.98 |
291 | 291 | TX | Longview, TX | 80 | 11.2 | 0.801 | 0.78 |
354 | 354 | CA | Vallejo-Fairfield, CA | 70 | 11.2 | 0.549 | 0.53 |
239 | 239 | TN | Johnson City, TN | 70 | 11.3 | 0.929 | 0.9 |
240 | 240 | ID | Boise City-Nampa, ID | 250 | 11.4 | 0.927 | 0.9 |
259 | 259 | TN | Chattanooga, TN-GA | 200 | 11.4 | 0.873 | 0.85 |
355 | 355 | MI | Flint, MI | 70 | 11.4 | 0.541 | 0.53 |
135 | 135 | WI | La Crosse, WI-MN | 80 | 11.5 | 1.136 | 1.1 |
114 | 114 | TX | Killeen-Temple-Fort Hood, TX | 160 | 11.6 | 1.211 | 1.18 |
118 | 118 | OH | Toledo, OH | 350 | 11.6 | 1.19 | 1.16 |
342 | 342 | PA | York-Hanover, PA | 110 | 11.6 | 0.645 | 0.63 |
20 | 20 | KS | Lawrence, KS | 80 | 11.7 | 1.754 | 1.7 |
353 | 353 | WI | Eau Claire, WI | 40 | 11.7 | 0.553 | 0.54 |
236 | 236 | IA | Waterloo-Cedar Falls, IA | 90 | 11.9 | 0.95 | 0.92 |
97 | 97 | SC | Anderson, SC | 80 | 12 | 1.268 | 1.23 |
267 | 267 | GA | Savannah, GA | 130 | 12.1 | 0.858 | 0.83 |
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 |
130 | 130 | TX | Abilene, TX | 70 | 12.4 | 1.155 | 1.12 |
182 | 182 | AL | Gadsden, AL | 40 | 12.4 | 1.029 | 1 |
293 | 293 | MI | Lansing-East Lansing, MI | 160 | 12.4 | 0.797 | 0.77 |
313 | 313 | CA | San Jose-Sunnyvale-Santa Clara, CA | 700 | 12.5 | 0.748 | 0.73 |
16 | 16 | MO | St. Joseph, MO-KS | 100 | 12.6 | 1.942 | 1.89 |
339 | 339 | CA | El Centro, CA | 30 | 12.7 | 0.65 | 0.63 |
283 | 283 | OH | Youngstown-Warren-Boardman, OH-PA | 180 | 13 | 0.811 | 0.79 |
112 | 112 | WV | Parkersburg-Marietta-Vienna, WV-OH | 80 | 13.1 | 1.215 | 1.18 |
145 | 145 | NC | Winston-Salem, NC | 230 | 13.1 | 1.111 | 1.08 |
120 | 120 | NJ | Newark-Union, NJ-PA Metropolitan Division | 1130 | 13.2 | 1.179 | 1.15 |
254 | 254 | PA | Harrisburg-Carlisle, PA | 270 | 13.2 | 0.891 | 0.87 |
159 | 159 | MI | Monroe, MI | 40 | 13.3 | 1.075 | 1.04 |
263 | 263 | OH | Sandusky, OH | 30 | 13.3 | 0.871 | 0.85 |
305 | 305 | WV | Charleston, WV | 110 | 13.3 | 0.774 | 0.75 |
73 | 73 | NY | Utica-Rome, NY | 170 | 13.5 | 1.372 | 1.33 |
104 | 104 | OH | Cleveland-Elyria-Mentor, OH | 1250 | 13.5 | 1.241 | 1.21 |
75 | 75 | MO | Jefferson City, MO | 100 | 13.6 | 1.36 | 1.32 |
77 | 77 | ND | Bismarck, ND | 90 | 13.6 | 1.34 | 1.3 |
347 | 347 | WI | Oshkosh-Neenah, WI | 50 | 13.7 | 0.594 | 0.58 |
122 | 122 | AL | Anniston-Oxford, AL | 50 | 13.8 | 1.175 | 1.14 |
310 | 310 | IA | Des Moines-West Des Moines, IA | 250 | 13.8 | 0.75 | 0.73 |
54 | 54 | MA | Pittsfield, MA | 50 | 13.9 | 1.454 | 1.41 |
115 | 115 | GA | Albany, GA | 70 | 13.9 | 1.202 | 1.17 |
169 | 169 | PA | Scranton--Wilkes-Barre, PA | 260 | 13.9 | 1.05 | 1.02 |
220 | 220 | TX | Fort Worth-Arlington, TX Metropolitan Division | 880 | 13.9 | 0.969 | 0.94 |
162 | 162 | MO | Cape Girardeau-Jackson, MO-IL | 40 | 14.1 | 1.068 | 1.04 |
252 | 252 | MO | Joplin, MO | 70 | 14.1 | 0.895 | 0.87 |
314 | 314 | GA | Columbus, GA-AL | 80 | 14.1 | 0.741 | 0.72 |
321 | 321 | IL | Rockford, IL | 110 | 14.1 | 0.735 | 0.71 |
362 | 362 | MI | Grand Rapids-Wyoming, MI | 210 | 14.2 | 0.516 | 0.5 |
312 | 312 | PA | Williamsport, PA | 40 | 14.5 | 0.749 | 0.73 |
224 | 224 | IN | Gary, IN Metropolitan Division | 260 | 14.6 | 0.964 | 0.94 |
172 | 172 | MA | Peabody, MA NECTA Division | 110 | 14.7 | 1.04 | 1.01 |
202 | 202 | KS | Wichita, KS | 280 | 15.1 | 0.998 | 0.97 |
237 | 237 | IA | Cedar Rapids, IA | 130 | 15.1 | 0.949 | 0.92 |
116 | 116 | IL | Decatur, IL | 60 | 15.2 | 1.198 | 1.16 |
326 | 326 | GA | Dalton, GA | 40 | 15.2 | 0.712 | 0.69 |
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 );