ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,246 rows where date = "2020-11-15" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 253
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 94
- Indiana 92
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 64
- California 58
- New York 58
- Montana 56
- West Virginia 55
- …
fips >30
county >30
- Washington 31
- Unknown 27
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 15
- Greene 14
- Warren 14
- Carroll 13
- Adams 12
- Clark 12
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Calhoun 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732204 | 732204 | 2020-11-15 | Autauga | Alabama | 1001 | 2456 | 36 |
732205 | 732205 | 2020-11-15 | Baldwin | Alabama | 1003 | 7646 | 84 |
732206 | 732206 | 2020-11-15 | Barbour | Alabama | 1005 | 1128 | 9 |
732207 | 732207 | 2020-11-15 | Bibb | Alabama | 1007 | 986 | 17 |
732208 | 732208 | 2020-11-15 | Blount | Alabama | 1009 | 2549 | 34 |
732209 | 732209 | 2020-11-15 | Bullock | Alabama | 1011 | 677 | 19 |
732210 | 732210 | 2020-11-15 | Butler | Alabama | 1013 | 1087 | 41 |
732211 | 732211 | 2020-11-15 | Calhoun | Alabama | 1015 | 5608 | 77 |
732212 | 732212 | 2020-11-15 | Chambers | Alabama | 1017 | 1570 | 48 |
732213 | 732213 | 2020-11-15 | Cherokee | Alabama | 1019 | 908 | 15 |
732214 | 732214 | 2020-11-15 | Chilton | Alabama | 1021 | 2078 | 36 |
732215 | 732215 | 2020-11-15 | Choctaw | Alabama | 1023 | 411 | 12 |
732216 | 732216 | 2020-11-15 | Clarke | Alabama | 1025 | 1503 | 18 |
732217 | 732217 | 2020-11-15 | Clay | Alabama | 1027 | 850 | 13 |
732218 | 732218 | 2020-11-15 | Cleburne | Alabama | 1029 | 669 | 11 |
732219 | 732219 | 2020-11-15 | Coffee | Alabama | 1031 | 2170 | 14 |
732220 | 732220 | 2020-11-15 | Colbert | Alabama | 1033 | 2736 | 38 |
732221 | 732221 | 2020-11-15 | Conecuh | Alabama | 1035 | 645 | 14 |
732222 | 732222 | 2020-11-15 | Coosa | Alabama | 1037 | 269 | 3 |
732223 | 732223 | 2020-11-15 | Covington | Alabama | 1039 | 2039 | 32 |
732224 | 732224 | 2020-11-15 | Crenshaw | Alabama | 1041 | 675 | 30 |
732225 | 732225 | 2020-11-15 | Cullman | Alabama | 1043 | 3701 | 30 |
732226 | 732226 | 2020-11-15 | Dale | Alabama | 1045 | 2175 | 54 |
732227 | 732227 | 2020-11-15 | Dallas | Alabama | 1047 | 2062 | 28 |
732228 | 732228 | 2020-11-15 | DeKalb | Alabama | 1049 | 4209 | 34 |
732229 | 732229 | 2020-11-15 | Elmore | Alabama | 1051 | 3648 | 61 |
732230 | 732230 | 2020-11-15 | Escambia | Alabama | 1053 | 1881 | 31 |
732231 | 732231 | 2020-11-15 | Etowah | Alabama | 1055 | 5348 | 61 |
732232 | 732232 | 2020-11-15 | Fayette | Alabama | 1057 | 735 | 15 |
732233 | 732233 | 2020-11-15 | Franklin | Alabama | 1059 | 2336 | 33 |
732234 | 732234 | 2020-11-15 | Geneva | Alabama | 1061 | 1101 | 8 |
732235 | 732235 | 2020-11-15 | Greene | Alabama | 1063 | 375 | 17 |
732236 | 732236 | 2020-11-15 | Hale | Alabama | 1065 | 873 | 30 |
732237 | 732237 | 2020-11-15 | Henry | Alabama | 1067 | 815 | 6 |
732238 | 732238 | 2020-11-15 | Houston | Alabama | 1069 | 4761 | 37 |
732239 | 732239 | 2020-11-15 | Jackson | Alabama | 1071 | 2719 | 23 |
732240 | 732240 | 2020-11-15 | Jefferson | Alabama | 1073 | 27884 | 461 |
732241 | 732241 | 2020-11-15 | Lamar | Alabama | 1075 | 584 | 7 |
732242 | 732242 | 2020-11-15 | Lauderdale | Alabama | 1077 | 3298 | 51 |
732243 | 732243 | 2020-11-15 | Lawrence | Alabama | 1079 | 1076 | 35 |
732244 | 732244 | 2020-11-15 | Lee | Alabama | 1081 | 7212 | 65 |
732245 | 732245 | 2020-11-15 | Limestone | Alabama | 1083 | 3653 | 41 |
732246 | 732246 | 2020-11-15 | Lowndes | Alabama | 1085 | 760 | 29 |
732247 | 732247 | 2020-11-15 | Macon | Alabama | 1087 | 654 | 20 |
732248 | 732248 | 2020-11-15 | Madison | Alabama | 1089 | 11305 | 118 |
732249 | 732249 | 2020-11-15 | Marengo | Alabama | 1091 | 1132 | 24 |
732250 | 732250 | 2020-11-15 | Marion | Alabama | 1093 | 1276 | 32 |
732251 | 732251 | 2020-11-15 | Marshall | Alabama | 1095 | 5330 | 53 |
732252 | 732252 | 2020-11-15 | Mobile | Alabama | 1097 | 18524 | 339 |
732253 | 732253 | 2020-11-15 | Monroe | Alabama | 1099 | 732 | 10 |
732254 | 732254 | 2020-11-15 | Montgomery | Alabama | 1101 | 11596 | 224 |
732255 | 732255 | 2020-11-15 | Morgan | Alabama | 1103 | 5400 | 41 |
732256 | 732256 | 2020-11-15 | Perry | Alabama | 1105 | 639 | 6 |
732257 | 732257 | 2020-11-15 | Pickens | Alabama | 1107 | 1073 | 18 |
732258 | 732258 | 2020-11-15 | Pike | Alabama | 1109 | 1494 | 14 |
732259 | 732259 | 2020-11-15 | Randolph | Alabama | 1111 | 950 | 20 |
732260 | 732260 | 2020-11-15 | Russell | Alabama | 1113 | 2073 | 3 |
732261 | 732261 | 2020-11-15 | Shelby | Alabama | 1117 | 9011 | 73 |
732262 | 732262 | 2020-11-15 | St. Clair | Alabama | 1115 | 3736 | 55 |
732263 | 732263 | 2020-11-15 | Sumter | Alabama | 1119 | 533 | 21 |
732264 | 732264 | 2020-11-15 | Talladega | Alabama | 1121 | 3171 | 41 |
732265 | 732265 | 2020-11-15 | Tallapoosa | Alabama | 1123 | 1604 | 88 |
732266 | 732266 | 2020-11-15 | Tuscaloosa | Alabama | 1125 | 11810 | 148 |
732267 | 732267 | 2020-11-15 | Walker | Alabama | 1127 | 3294 | 96 |
732268 | 732268 | 2020-11-15 | Washington | Alabama | 1129 | 875 | 12 |
732269 | 732269 | 2020-11-15 | Wilcox | Alabama | 1131 | 606 | 12 |
732270 | 732270 | 2020-11-15 | Winston | Alabama | 1133 | 1138 | 22 |
732271 | 732271 | 2020-11-15 | Aleutians East Borough | Alaska | 2013 | 21 | 0 |
732272 | 732272 | 2020-11-15 | Aleutians West Census Area | Alaska | 2016 | 105 | 0 |
732273 | 732273 | 2020-11-15 | Anchorage | Alaska | 2020 | 12305 | 59 |
732274 | 732274 | 2020-11-15 | Bethel Census Area | Alaska | 2050 | 906 | 1 |
732275 | 732275 | 2020-11-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 133 | 0 |
732276 | 732276 | 2020-11-15 | Denali Borough | Alaska | 2068 | 38 | 0 |
732277 | 732277 | 2020-11-15 | Dillingham Census Area | Alaska | 2070 | 80 | 0 |
732278 | 732278 | 2020-11-15 | Fairbanks North Star Borough | Alaska | 2090 | 2877 | 17 |
732279 | 732279 | 2020-11-15 | Haines Borough | Alaska | 2100 | 16 | 0 |
732280 | 732280 | 2020-11-15 | Juneau City and Borough | Alaska | 2110 | 734 | 2 |
732281 | 732281 | 2020-11-15 | Kenai Peninsula Borough | Alaska | 2122 | 1741 | 3 |
732282 | 732282 | 2020-11-15 | Ketchikan Gateway Borough | Alaska | 2130 | 171 | 0 |
732283 | 732283 | 2020-11-15 | Kodiak Island Borough | Alaska | 2150 | 170 | 0 |
732284 | 732284 | 2020-11-15 | Kusilvak Census Area | Alaska | 2158 | 353 | 0 |
732285 | 732285 | 2020-11-15 | Matanuska-Susitna Borough | Alaska | 2170 | 2316 | 5 |
732286 | 732286 | 2020-11-15 | Nome Census Area | Alaska | 2180 | 165 | 0 |
732287 | 732287 | 2020-11-15 | North Slope Borough | Alaska | 2185 | 375 | 0 |
732288 | 732288 | 2020-11-15 | Northwest Arctic Borough | Alaska | 2188 | 307 | 0 |
732289 | 732289 | 2020-11-15 | Petersburg Borough | Alaska | 2195 | 20 | 0 |
732290 | 732290 | 2020-11-15 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 44 | 1 |
732291 | 732291 | 2020-11-15 | Sitka City and Borough | Alaska | 2220 | 131 | 0 |
732292 | 732292 | 2020-11-15 | Skagway Municipality | Alaska | 2230 | 7 | 0 |
732293 | 732293 | 2020-11-15 | Southeast Fairbanks Census Area | Alaska | 2240 | 155 | 1 |
732294 | 732294 | 2020-11-15 | Unknown | Alaska | 104 | 0 | |
732295 | 732295 | 2020-11-15 | Valdez-Cordova Census Area | Alaska | 2261 | 216 | 1 |
732296 | 732296 | 2020-11-15 | Wrangell City and Borough | Alaska | 2275 | 20 | 0 |
732297 | 732297 | 2020-11-15 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 41 | 0 |
732298 | 732298 | 2020-11-15 | Yukon-Koyukuk Census Area | Alaska | 2290 | 137 | 2 |
732299 | 732299 | 2020-11-15 | Apache | Arizona | 4001 | 4391 | 189 |
732300 | 732300 | 2020-11-15 | Cochise | Arizona | 4003 | 2705 | 77 |
732301 | 732301 | 2020-11-15 | Coconino | Arizona | 4005 | 6318 | 159 |
732302 | 732302 | 2020-11-15 | Gila | Arizona | 4007 | 2362 | 78 |
732303 | 732303 | 2020-11-15 | Graham | Arizona | 4009 | 1675 | 32 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);