ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,242 rows where date = "2020-11-03" 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 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 95
- Nebraska 93
- 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
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Unknown 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 |
---|---|---|---|---|---|---|---|
693283 | 693283 | 2020-11-03 | Autauga | Alabama | 1001 | 2197 | 31 |
693284 | 693284 | 2020-11-03 | Baldwin | Alabama | 1003 | 6995 | 74 |
693285 | 693285 | 2020-11-03 | Barbour | Alabama | 1005 | 1074 | 9 |
693286 | 693286 | 2020-11-03 | Bibb | Alabama | 1007 | 890 | 15 |
693287 | 693287 | 2020-11-03 | Blount | Alabama | 1009 | 2162 | 25 |
693288 | 693288 | 2020-11-03 | Bullock | Alabama | 1011 | 657 | 17 |
693289 | 693289 | 2020-11-03 | Butler | Alabama | 1013 | 1029 | 41 |
693290 | 693290 | 2020-11-03 | Calhoun | Alabama | 1015 | 4951 | 65 |
693291 | 693291 | 2020-11-03 | Chambers | Alabama | 1017 | 1428 | 47 |
693292 | 693292 | 2020-11-03 | Cherokee | Alabama | 1019 | 808 | 15 |
693293 | 693293 | 2020-11-03 | Chilton | Alabama | 1021 | 1962 | 33 |
693294 | 693294 | 2020-11-03 | Choctaw | Alabama | 1023 | 396 | 12 |
693295 | 693295 | 2020-11-03 | Clarke | Alabama | 1025 | 1409 | 17 |
693296 | 693296 | 2020-11-03 | Clay | Alabama | 1027 | 785 | 13 |
693297 | 693297 | 2020-11-03 | Cleburne | Alabama | 1029 | 590 | 9 |
693298 | 693298 | 2020-11-03 | Coffee | Alabama | 1031 | 1893 | 11 |
693299 | 693299 | 2020-11-03 | Colbert | Alabama | 1033 | 2336 | 32 |
693300 | 693300 | 2020-11-03 | Conecuh | Alabama | 1035 | 584 | 13 |
693301 | 693301 | 2020-11-03 | Coosa | Alabama | 1037 | 228 | 3 |
693302 | 693302 | 2020-11-03 | Covington | Alabama | 1039 | 1895 | 30 |
693303 | 693303 | 2020-11-03 | Crenshaw | Alabama | 1041 | 626 | 30 |
693304 | 693304 | 2020-11-03 | Cullman | Alabama | 1043 | 2915 | 25 |
693305 | 693305 | 2020-11-03 | Dale | Alabama | 1045 | 1955 | 52 |
693306 | 693306 | 2020-11-03 | Dallas | Alabama | 1047 | 1924 | 27 |
693307 | 693307 | 2020-11-03 | DeKalb | Alabama | 1049 | 3721 | 30 |
693308 | 693308 | 2020-11-03 | Elmore | Alabama | 1051 | 3342 | 59 |
693309 | 693309 | 2020-11-03 | Escambia | Alabama | 1053 | 1785 | 31 |
693310 | 693310 | 2020-11-03 | Etowah | Alabama | 1055 | 4578 | 54 |
693311 | 693311 | 2020-11-03 | Fayette | Alabama | 1057 | 616 | 15 |
693312 | 693312 | 2020-11-03 | Franklin | Alabama | 1059 | 2192 | 32 |
693313 | 693313 | 2020-11-03 | Geneva | Alabama | 1061 | 985 | 7 |
693314 | 693314 | 2020-11-03 | Greene | Alabama | 1063 | 351 | 17 |
693315 | 693315 | 2020-11-03 | Hale | Alabama | 1065 | 801 | 30 |
693316 | 693316 | 2020-11-03 | Henry | Alabama | 1067 | 757 | 6 |
693317 | 693317 | 2020-11-03 | Houston | Alabama | 1069 | 4341 | 35 |
693318 | 693318 | 2020-11-03 | Jackson | Alabama | 1071 | 2363 | 19 |
693319 | 693319 | 2020-11-03 | Jefferson | Alabama | 1073 | 24754 | 388 |
693320 | 693320 | 2020-11-03 | Lamar | Alabama | 1075 | 533 | 7 |
693321 | 693321 | 2020-11-03 | Lauderdale | Alabama | 1077 | 2798 | 43 |
693322 | 693322 | 2020-11-03 | Lawrence | Alabama | 1079 | 958 | 33 |
693323 | 693323 | 2020-11-03 | Lee | Alabama | 1081 | 6749 | 65 |
693324 | 693324 | 2020-11-03 | Limestone | Alabama | 1083 | 3166 | 34 |
693325 | 693325 | 2020-11-03 | Lowndes | Alabama | 1085 | 733 | 29 |
693326 | 693326 | 2020-11-03 | Macon | Alabama | 1087 | 572 | 21 |
693327 | 693327 | 2020-11-03 | Madison | Alabama | 1089 | 9893 | 101 |
693328 | 693328 | 2020-11-03 | Marengo | Alabama | 1091 | 1069 | 24 |
693329 | 693329 | 2020-11-03 | Marion | Alabama | 1093 | 1150 | 31 |
693330 | 693330 | 2020-11-03 | Marshall | Alabama | 1095 | 4618 | 53 |
693331 | 693331 | 2020-11-03 | Mobile | Alabama | 1097 | 17406 | 323 |
693332 | 693332 | 2020-11-03 | Monroe | Alabama | 1099 | 674 | 10 |
693333 | 693333 | 2020-11-03 | Montgomery | Alabama | 1101 | 10814 | 211 |
693334 | 693334 | 2020-11-03 | Morgan | Alabama | 1103 | 4594 | 37 |
693335 | 693335 | 2020-11-03 | Perry | Alabama | 1105 | 606 | 6 |
693336 | 693336 | 2020-11-03 | Pickens | Alabama | 1107 | 944 | 18 |
693337 | 693337 | 2020-11-03 | Pike | Alabama | 1109 | 1399 | 14 |
693338 | 693338 | 2020-11-03 | Randolph | Alabama | 1111 | 871 | 16 |
693339 | 693339 | 2020-11-03 | Russell | Alabama | 1113 | 2006 | 3 |
693340 | 693340 | 2020-11-03 | Shelby | Alabama | 1117 | 7870 | 70 |
693341 | 693341 | 2020-11-03 | St. Clair | Alabama | 1115 | 3298 | 46 |
693342 | 693342 | 2020-11-03 | Sumter | Alabama | 1119 | 489 | 21 |
693343 | 693343 | 2020-11-03 | Talladega | Alabama | 1121 | 2843 | 38 |
693344 | 693344 | 2020-11-03 | Tallapoosa | Alabama | 1123 | 1419 | 87 |
693345 | 693345 | 2020-11-03 | Tuscaloosa | Alabama | 1125 | 10844 | 145 |
693346 | 693346 | 2020-11-03 | Walker | Alabama | 1127 | 2992 | 95 |
693347 | 693347 | 2020-11-03 | Washington | Alabama | 1129 | 779 | 12 |
693348 | 693348 | 2020-11-03 | Wilcox | Alabama | 1131 | 579 | 12 |
693349 | 693349 | 2020-11-03 | Winston | Alabama | 1133 | 988 | 13 |
693350 | 693350 | 2020-11-03 | Aleutians East Borough | Alaska | 2013 | 16 | 0 |
693351 | 693351 | 2020-11-03 | Aleutians West Census Area | Alaska | 2016 | 101 | 0 |
693352 | 693352 | 2020-11-03 | Anchorage | Alaska | 2020 | 8871 | 50 |
693353 | 693353 | 2020-11-03 | Bethel Census Area | Alaska | 2050 | 523 | 1 |
693354 | 693354 | 2020-11-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 115 | 0 |
693355 | 693355 | 2020-11-03 | Denali Borough | Alaska | 2068 | 32 | 0 |
693356 | 693356 | 2020-11-03 | Dillingham Census Area | Alaska | 2070 | 62 | 0 |
693357 | 693357 | 2020-11-03 | Fairbanks North Star Borough | Alaska | 2090 | 2382 | 16 |
693358 | 693358 | 2020-11-03 | Haines Borough | Alaska | 2100 | 14 | 0 |
693359 | 693359 | 2020-11-03 | Juneau City and Borough | Alaska | 2110 | 603 | 2 |
693360 | 693360 | 2020-11-03 | Kenai Peninsula Borough | Alaska | 2122 | 1149 | 2 |
693361 | 693361 | 2020-11-03 | Ketchikan Gateway Borough | Alaska | 2130 | 91 | 0 |
693362 | 693362 | 2020-11-03 | Kodiak Island Borough | Alaska | 2150 | 124 | 0 |
693363 | 693363 | 2020-11-03 | Kusilvak Census Area | Alaska | 2158 | 278 | 0 |
693364 | 693364 | 2020-11-03 | Matanuska-Susitna Borough | Alaska | 2170 | 1621 | 3 |
693365 | 693365 | 2020-11-03 | Nome Census Area | Alaska | 2180 | 142 | 0 |
693366 | 693366 | 2020-11-03 | North Slope Borough | Alaska | 2185 | 281 | 0 |
693367 | 693367 | 2020-11-03 | Northwest Arctic Borough | Alaska | 2188 | 273 | 0 |
693368 | 693368 | 2020-11-03 | Petersburg Borough | Alaska | 2195 | 18 | 0 |
693369 | 693369 | 2020-11-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 34 | 1 |
693370 | 693370 | 2020-11-03 | Sitka City and Borough | Alaska | 2220 | 82 | 0 |
693371 | 693371 | 2020-11-03 | Skagway Municipality | Alaska | 2230 | 7 | 0 |
693372 | 693372 | 2020-11-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 91 | 1 |
693373 | 693373 | 2020-11-03 | Unknown | Alaska | 71 | 0 | |
693374 | 693374 | 2020-11-03 | Valdez-Cordova Census Area | Alaska | 2261 | 178 | 1 |
693375 | 693375 | 2020-11-03 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
693376 | 693376 | 2020-11-03 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 37 | 0 |
693377 | 693377 | 2020-11-03 | Yukon-Koyukuk Census Area | Alaska | 2290 | 124 | 2 |
693378 | 693378 | 2020-11-03 | Apache | Arizona | 4001 | 4042 | 174 |
693379 | 693379 | 2020-11-03 | Cochise | Arizona | 4003 | 2260 | 75 |
693380 | 693380 | 2020-11-03 | Coconino | Arizona | 4005 | 5470 | 149 |
693381 | 693381 | 2020-11-03 | Gila | Arizona | 4007 | 2034 | 72 |
693382 | 693382 | 2020-11-03 | Graham | Arizona | 4009 | 1307 | 31 |
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);