Librarians: librarians-by-msa.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
373 rows
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | prim_state | area_name | tot_emp | emp_prse | jobs_1000 | loc_quotient |
---|---|---|---|---|---|---|---|
101 | 101 | VA | Richmond, VA | 770 | 3.6 | 1.265 | 1.23 |
102 | 102 | NC | Raleigh-Cary, NC | 670 | 9.6 | 1.258 | 1.22 |
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 |
105 | 105 | MO | Springfield, MO | 230 | 18.8 | 1.241 | 1.21 |
106 | 106 | VA | Harrisonburg, VA | 70 | 0 | 1.241 | 1.21 |
107 | 107 | TX | El Paso, TX | 350 | 6.1 | 1.234 | 1.2 |
108 | 108 | NC | Greenville, NC | 90 | 8.4 | 1.229 | 1.19 |
109 | 109 | TX | Brownsville-Harlingen, TX | 160 | 2.8 | 1.223 | 1.19 |
110 | 110 | ID | Pocatello, ID | 40 | 8 | 1.221 | 1.19 |
111 | 111 | MD | Baltimore-Towson, MD | 1560 | 3.9 | 1.218 | 1.18 |
112 | 112 | WV | Parkersburg-Marietta-Vienna, WV-OH | 80 | 13.1 | 1.215 | 1.18 |
113 | 113 | TN | Clarksville, TN-KY | 100 | 7.7 | 1.212 | 1.18 |
114 | 114 | TX | Killeen-Temple-Fort Hood, TX | 160 | 11.6 | 1.211 | 1.18 |
115 | 115 | GA | Albany, GA | 70 | 13.9 | 1.202 | 1.17 |
116 | 116 | IL | Decatur, IL | 60 | 15.2 | 1.198 | 1.16 |
117 | 117 | KY | Lexington-Fayette, KY | 300 | 5.1 | 1.192 | 1.16 |
118 | 118 | OH | Toledo, OH | 350 | 11.6 | 1.19 | 1.16 |
119 | 119 | UT | Logan, UT-ID | 60 | 20.1 | 1.183 | 1.15 |
120 | 120 | NJ | Newark-Union, NJ-PA Metropolitan Division | 1130 | 13.2 | 1.179 | 1.15 |
121 | 121 | MA | Brockton-Bridgewater-Easton, MA NECTA Division | 110 | 6.9 | 1.178 | 1.14 |
122 | 122 | AL | Anniston-Oxford, AL | 50 | 13.8 | 1.175 | 1.14 |
123 | 123 | TN | Jackson, TN | 70 | 10.6 | 1.174 | 1.14 |
124 | 124 | MS | Hattiesburg, MS | 70 | 8 | 1.173 | 1.14 |
125 | 125 | NC | Rocky Mount, NC | 60 | 5.4 | 1.173 | 1.14 |
126 | 126 | IN | Lafayette, IN | 100 | 44.5 | 1.171 | 1.14 |
127 | 127 | WA | Spokane, WA | 230 | 4.5 | 1.17 | 1.14 |
128 | 128 | IL | Champaign-Urbana, IL | 110 | 15.6 | 1.164 | 1.13 |
129 | 129 | AR | Fort Smith, AR-OK | 130 | 7.4 | 1.161 | 1.13 |
130 | 130 | TX | Abilene, TX | 70 | 12.4 | 1.155 | 1.12 |
131 | 131 | NH | Manchester, NH | 120 | 7.1 | 1.145 | 1.11 |
132 | 132 | NC | Greensboro-High Point, NC | 390 | 4.1 | 1.139 | 1.11 |
133 | 133 | VA | Charlottesville, VA | 110 | 7.2 | 1.139 | 1.11 |
134 | 134 | NY | Binghamton, NY | 120 | 4 | 1.138 | 1.11 |
135 | 135 | WI | La Crosse, WI-MN | 80 | 11.5 | 1.136 | 1.1 |
136 | 136 | WA | Yakima, WA | 90 | 4.2 | 1.132 | 1.1 |
137 | 137 | AR | Little Rock-North Little Rock-Conway, AR | 380 | 9.3 | 1.129 | 1.1 |
138 | 138 | AL | Montgomery, AL | 180 | 3.9 | 1.128 | 1.1 |
139 | 139 | IN | Terre Haute, IN | 70 | 9.1 | 1.124 | 1.09 |
140 | 140 | NJ | Ocean City, NJ | 40 | 18.8 | 1.124 | 1.09 |
141 | 141 | VA | Roanoke, VA | 170 | 11.1 | 1.118 | 1.09 |
142 | 142 | VA | Blacksburg-Christiansburg-Radford, VA | 70 | 9.9 | 1.117 | 1.09 |
143 | 143 | TX | Wichita Falls, TX | 60 | 4.1 | 1.116 | 1.08 |
144 | 144 | MO | Columbia, MO | 100 | 16.8 | 1.112 | 1.08 |
145 | 145 | NC | Winston-Salem, NC | 230 | 13.1 | 1.111 | 1.08 |
146 | 146 | LA | Baton Rouge, LA | 410 | 3.2 | 1.105 | 1.07 |
147 | 147 | AL | Tuscaloosa, AL | 100 | 20.3 | 1.102 | 1.07 |
148 | 148 | ME | Lewiston-Auburn, ME | 50 | 21.3 | 1.102 | 1.07 |
149 | 149 | MA | New Bedford, MA | 70 | 29.9 | 1.1 | 1.07 |
150 | 150 | AZ | Prescott, AZ | 60 | 32.8 | 1.096 | 1.06 |
151 | 151 | IL | Chicago-Joliet-Naperville, IL Metropolitan Division | 4050 | 10.3 | 1.094 | 1.06 |
152 | 152 | WA | Tacoma, WA Metropolitan Division | 290 | 6.6 | 1.093 | 1.06 |
153 | 153 | CO | Boulder, CO | 180 | 4.8 | 1.091 | 1.06 |
154 | 154 | CA | Yuba City, CA | 40 | 23.8 | 1.089 | 1.06 |
155 | 155 | NJ | Camden, NJ Metropolitan Division | 550 | 10.2 | 1.088 | 1.06 |
156 | 156 | AR | Fayetteville-Springdale-Rogers, AR-MO | 230 | 3.6 | 1.086 | 1.06 |
157 | 157 | DE | Wilmington, DE-MD-NJ Metropolitan Division | 350 | 5.6 | 1.081 | 1.05 |
158 | 158 | CO | Fort Collins-Loveland, CO | 150 | 1 | 1.079 | 1.05 |
159 | 159 | MI | Monroe, MI | 40 | 13.3 | 1.075 | 1.04 |
160 | 160 | HI | Honolulu, HI | 470 | 3.1 | 1.068 | 1.04 |
161 | 161 | SC | Florence, SC | 90 | 4.6 | 1.068 | 1.04 |
162 | 162 | MO | Cape Girardeau-Jackson, MO-IL | 40 | 14.1 | 1.068 | 1.04 |
163 | 163 | NM | Santa Fe, NM | 60 | 5 | 1.067 | 1.04 |
164 | 164 | FL | West Palm Beach-Boca Raton-Boynton Beach, FL Metropolitan Division | 560 | 4 | 1.065 | 1.03 |
165 | 165 | VA | Winchester, VA-WV | 60 | 45.2 | 1.062 | 1.03 |
166 | 166 | MN | St. Cloud, MN | 100 | 7.7 | 1.06 | 1.03 |
167 | 167 | MA | Framingham, MA NECTA Division | 170 | 10.6 | 1.056 | 1.03 |
168 | 168 | CA | San Francisco-San Mateo-Redwood City, CA Metropolitan Division | 1100 | 5.1 | 1.05 | 1.02 |
169 | 169 | PA | Scranton--Wilkes-Barre, PA | 260 | 13.9 | 1.05 | 1.02 |
170 | 170 | NE | Omaha-Council Bluffs, NE-IA | 480 | 5 | 1.049 | 1.02 |
171 | 171 | LA | Lake Charles, LA | 90 | 0 | 1.045 | 1.01 |
172 | 172 | MA | Peabody, MA NECTA Division | 110 | 14.7 | 1.04 | 1.01 |
173 | 173 | SD | Rapid City, SD | 60 | 1.1 | 1.039 | 1.01 |
174 | 174 | NY | New York-White Plains-Wayne, NY-NJ Metropolitan Division | 5440 | 5.9 | 1.038 | 1.01 |
175 | 175 | TX | Amarillo, TX | 110 | 5.6 | 1.038 | 1.01 |
176 | 176 | KY | Elizabethtown, KY | 50 | 4.9 | 1.037 | 1.01 |
177 | 177 | WI | Janesville, WI | 60 | 10.1 | 1.035 | 1 |
178 | 178 | NC | Asheville, NC | 180 | 4.8 | 1.033 | 1 |
179 | 179 | IA | Davenport-Moline-Rock Island, IA-IL | 190 | 15.3 | 1.031 | 1 |
180 | 180 | IN | Kokomo, IN | 40 | 4.8 | 1.031 | 1 |
181 | 181 | MO | Kansas City, MO-KS | 1020 | 7.9 | 1.03 | 1 |
182 | 182 | AL | Gadsden, AL | 40 | 12.4 | 1.029 | 1 |
183 | 183 | PA | Philadelphia, PA Metropolitan Division | 1890 | 7 | 1.028 | 1 |
184 | 184 | OK | Oklahoma City, OK | 610 | 16.1 | 1.028 | 1 |
185 | 185 | TX | Austin-Round Rock-San Marcos, TX | 880 | 5.4 | 1.026 | 1 |
186 | 186 | UT | Provo-Orem, UT | 190 | 7.6 | 1.025 | 1 |
187 | 187 | MO | St. Louis, MO-IL | 1320 | 5.7 | 1.024 | 0.99 |
188 | 188 | IN | Indianapolis-Carmel, IN | 930 | 10.2 | 1.024 | 0.99 |
189 | 189 | GA | Augusta-Richmond County, GA-SC | 210 | 6.6 | 1.015 | 0.99 |
190 | 190 | TN | Nashville-Davidson--Murfreesboro--Franklin, TN | 800 | 3.9 | 1.014 | 0.99 |
191 | 191 | VT | Burlington-South Burlington, VT | 120 | 19 | 1.011 | 0.98 |
192 | 192 | SC | Charleston-North Charleston-Summerville, SC | 300 | 3.2 | 1.009 | 0.98 |
193 | 193 | MT | Missoula, MT | 60 | 6.6 | 1.009 | 0.98 |
194 | 194 | FL | Lakeland-Winter Haven, FL | 200 | 3.4 | 1.007 | 0.98 |
195 | 195 | WA | Seattle-Bellevue-Everett, WA Metropolitan Division | 1460 | 5.3 | 1.005 | 0.98 |
196 | 196 | GA | Warner Robins, GA | 60 | 10.6 | 1.005 | 0.98 |
197 | 197 | TX | Sherman-Denison, TX | 40 | 11.2 | 1.004 | 0.98 |
198 | 198 | NC | Goldsboro, NC | 40 | 16.8 | 1.004 | 0.97 |
199 | 199 | MA | Lowell-Billerica-Chelmsford, MA-NH NECTA Division | 120 | 10.2 | 1.003 | 0.97 |
200 | 200 | MN | Mankato-North Mankato, MN | 50 | 32 | 1.002 | 0.97 |
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 );