ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,762 rows where date = "2020-04-18" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 194
- Georgia 158
- Virginia 125
- Kentucky 107
- Missouri 96
- Illinois 94
- North Carolina 93
- Tennessee 93
- Indiana 92
- Ohio 87
- Iowa 83
- Mississippi 81
- Michigan 80
- Minnesota 75
- Arkansas 72
- Florida 68
- Kansas 68
- Oklahoma 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- Wisconsin 65
- New York 59
- Colorado 57
- California 53
- Nebraska 51
- West Virginia 48
- South Carolina 46
- South Dakota 40
- Washington 39
- …
fips >30
county >30
- Unknown 30
- Washington 30
- Jefferson 25
- Franklin 24
- Jackson 22
- Lincoln 21
- Madison 19
- Marion 17
- Montgomery 17
- Union 17
- Clay 16
- Monroe 15
- Greene 14
- Warren 14
- Wayne 13
- Carroll 12
- Johnson 12
- Polk 12
- Crawford 11
- Fayette 11
- Grant 11
- Lee 11
- Morgan 11
- Adams 10
- Clark 10
- Douglas 10
- Hamilton 10
- Henry 10
- Lake 10
- Lawrence 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
67365 | 67365 | 2020-04-18 | Autauga | Alabama | 1001 | 25 | 2 |
67366 | 67366 | 2020-04-18 | Baldwin | Alabama | 1003 | 109 | 2 |
67367 | 67367 | 2020-04-18 | Barbour | Alabama | 1005 | 18 | 0 |
67368 | 67368 | 2020-04-18 | Bibb | Alabama | 1007 | 26 | 0 |
67369 | 67369 | 2020-04-18 | Blount | Alabama | 1009 | 20 | 0 |
67370 | 67370 | 2020-04-18 | Bullock | Alabama | 1011 | 9 | 0 |
67371 | 67371 | 2020-04-18 | Butler | Alabama | 1013 | 13 | 0 |
67372 | 67372 | 2020-04-18 | Calhoun | Alabama | 1015 | 66 | 2 |
67373 | 67373 | 2020-04-18 | Chambers | Alabama | 1017 | 240 | 11 |
67374 | 67374 | 2020-04-18 | Cherokee | Alabama | 1019 | 12 | 0 |
67375 | 67375 | 2020-04-18 | Chilton | Alabama | 1021 | 39 | 0 |
67376 | 67376 | 2020-04-18 | Choctaw | Alabama | 1023 | 14 | 0 |
67377 | 67377 | 2020-04-18 | Clarke | Alabama | 1025 | 24 | 0 |
67378 | 67378 | 2020-04-18 | Clay | Alabama | 1027 | 17 | 0 |
67379 | 67379 | 2020-04-18 | Cleburne | Alabama | 1029 | 12 | 0 |
67380 | 67380 | 2020-04-18 | Coffee | Alabama | 1031 | 56 | 0 |
67381 | 67381 | 2020-04-18 | Colbert | Alabama | 1033 | 15 | 1 |
67382 | 67382 | 2020-04-18 | Conecuh | Alabama | 1035 | 10 | 0 |
67383 | 67383 | 2020-04-18 | Coosa | Alabama | 1037 | 22 | 1 |
67384 | 67384 | 2020-04-18 | Covington | Alabama | 1039 | 21 | 1 |
67385 | 67385 | 2020-04-18 | Crenshaw | Alabama | 1041 | 6 | 0 |
67386 | 67386 | 2020-04-18 | Cullman | Alabama | 1043 | 42 | 0 |
67387 | 67387 | 2020-04-18 | Dale | Alabama | 1045 | 17 | 0 |
67388 | 67388 | 2020-04-18 | Dallas | Alabama | 1047 | 22 | 2 |
67389 | 67389 | 2020-04-18 | DeKalb | Alabama | 1049 | 40 | 2 |
67390 | 67390 | 2020-04-18 | Elmore | Alabama | 1051 | 58 | 1 |
67391 | 67391 | 2020-04-18 | Escambia | Alabama | 1053 | 12 | 0 |
67392 | 67392 | 2020-04-18 | Etowah | Alabama | 1055 | 93 | 7 |
67393 | 67393 | 2020-04-18 | Fayette | Alabama | 1057 | 4 | 0 |
67394 | 67394 | 2020-04-18 | Franklin | Alabama | 1059 | 17 | 0 |
67395 | 67395 | 2020-04-18 | Geneva | Alabama | 1061 | 4 | 0 |
67396 | 67396 | 2020-04-18 | Greene | Alabama | 1063 | 29 | 0 |
67397 | 67397 | 2020-04-18 | Hale | Alabama | 1065 | 23 | 1 |
67398 | 67398 | 2020-04-18 | Henry | Alabama | 1067 | 17 | 0 |
67399 | 67399 | 2020-04-18 | Houston | Alabama | 1069 | 63 | 2 |
67400 | 67400 | 2020-04-18 | Jackson | Alabama | 1071 | 38 | 2 |
67401 | 67401 | 2020-04-18 | Jefferson | Alabama | 1073 | 673 | 25 |
67402 | 67402 | 2020-04-18 | Lamar | Alabama | 1075 | 8 | 0 |
67403 | 67403 | 2020-04-18 | Lauderdale | Alabama | 1077 | 23 | 4 |
67404 | 67404 | 2020-04-18 | Lawrence | Alabama | 1079 | 9 | 0 |
67405 | 67405 | 2020-04-18 | Lee | Alabama | 1081 | 306 | 14 |
67406 | 67406 | 2020-04-18 | Limestone | Alabama | 1083 | 40 | 0 |
67407 | 67407 | 2020-04-18 | Lowndes | Alabama | 1085 | 27 | 0 |
67408 | 67408 | 2020-04-18 | Macon | Alabama | 1087 | 24 | 2 |
67409 | 67409 | 2020-04-18 | Madison | Alabama | 1089 | 197 | 4 |
67410 | 67410 | 2020-04-18 | Marengo | Alabama | 1091 | 25 | 1 |
67411 | 67411 | 2020-04-18 | Marion | Alabama | 1093 | 60 | 5 |
67412 | 67412 | 2020-04-18 | Marshall | Alabama | 1095 | 139 | 4 |
67413 | 67413 | 2020-04-18 | Mobile | Alabama | 1097 | 638 | 25 |
67414 | 67414 | 2020-04-18 | Monroe | Alabama | 1099 | 8 | 0 |
67415 | 67415 | 2020-04-18 | Montgomery | Alabama | 1101 | 217 | 3 |
67416 | 67416 | 2020-04-18 | Morgan | Alabama | 1103 | 45 | 0 |
67417 | 67417 | 2020-04-18 | Perry | Alabama | 1105 | 9 | 0 |
67418 | 67418 | 2020-04-18 | Pickens | Alabama | 1107 | 33 | 0 |
67419 | 67419 | 2020-04-18 | Pike | Alabama | 1109 | 34 | 0 |
67420 | 67420 | 2020-04-18 | Randolph | Alabama | 1111 | 51 | 3 |
67421 | 67421 | 2020-04-18 | Russell | Alabama | 1113 | 42 | 0 |
67422 | 67422 | 2020-04-18 | Shelby | Alabama | 1117 | 257 | 7 |
67423 | 67423 | 2020-04-18 | St. Clair | Alabama | 1115 | 53 | 0 |
67424 | 67424 | 2020-04-18 | Sumter | Alabama | 1119 | 35 | 0 |
67425 | 67425 | 2020-04-18 | Talladega | Alabama | 1121 | 44 | 1 |
67426 | 67426 | 2020-04-18 | Tallapoosa | Alabama | 1123 | 180 | 11 |
67427 | 67427 | 2020-04-18 | Tuscaloosa | Alabama | 1125 | 141 | 0 |
67428 | 67428 | 2020-04-18 | Walker | Alabama | 1127 | 83 | 0 |
67429 | 67429 | 2020-04-18 | Washington | Alabama | 1129 | 15 | 1 |
67430 | 67430 | 2020-04-18 | Wilcox | Alabama | 1131 | 45 | 0 |
67431 | 67431 | 2020-04-18 | Winston | Alabama | 1133 | 9 | 0 |
67432 | 67432 | 2020-04-18 | Anchorage | Alaska | 2020 | 151 | 4 |
67433 | 67433 | 2020-04-18 | Bethel Census Area | Alaska | 2050 | 1 | 0 |
67434 | 67434 | 2020-04-18 | Fairbanks North Star Borough | Alaska | 2090 | 79 | 2 |
67435 | 67435 | 2020-04-18 | Juneau City and Borough | Alaska | 2110 | 24 | 0 |
67436 | 67436 | 2020-04-18 | Kenai Peninsula Borough | Alaska | 2122 | 18 | 0 |
67437 | 67437 | 2020-04-18 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
67438 | 67438 | 2020-04-18 | Kodiak Island Borough | Alaska | 2150 | 1 | 0 |
67439 | 67439 | 2020-04-18 | Matanuska-Susitna Borough | Alaska | 2170 | 17 | 1 |
67440 | 67440 | 2020-04-18 | Nome Census Area | Alaska | 2180 | 1 | 0 |
67441 | 67441 | 2020-04-18 | Petersburg Borough | Alaska | 2195 | 1 | 0 |
67442 | 67442 | 2020-04-18 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
67443 | 67443 | 2020-04-18 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
67444 | 67444 | 2020-04-18 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
67445 | 67445 | 2020-04-18 | Apache | Arizona | 4001 | 169 | 4 |
67446 | 67446 | 2020-04-18 | Cochise | Arizona | 4003 | 22 | 0 |
67447 | 67447 | 2020-04-18 | Coconino | Arizona | 4005 | 314 | 29 |
67448 | 67448 | 2020-04-18 | Gila | Arizona | 4007 | 7 | 0 |
67449 | 67449 | 2020-04-18 | Graham | Arizona | 4009 | 2 | 0 |
67450 | 67450 | 2020-04-18 | Greenlee | Arizona | 4011 | 2 | 0 |
67451 | 67451 | 2020-04-18 | La Paz | Arizona | 4012 | 5 | 1 |
67452 | 67452 | 2020-04-18 | Maricopa | Arizona | 4013 | 2491 | 70 |
67453 | 67453 | 2020-04-18 | Mohave | Arizona | 4015 | 52 | 2 |
67454 | 67454 | 2020-04-18 | Navajo | Arizona | 4017 | 452 | 11 |
67455 | 67455 | 2020-04-18 | Pima | Arizona | 4019 | 856 | 56 |
67456 | 67456 | 2020-04-18 | Pinal | Arizona | 4021 | 235 | 6 |
67457 | 67457 | 2020-04-18 | Santa Cruz | Arizona | 4023 | 16 | 0 |
67458 | 67458 | 2020-04-18 | Yavapai | Arizona | 4025 | 72 | 1 |
67459 | 67459 | 2020-04-18 | Yuma | Arizona | 4027 | 24 | 1 |
67460 | 67460 | 2020-04-18 | Arkansas | Arkansas | 5001 | 2 | 0 |
67461 | 67461 | 2020-04-18 | Ashley | Arkansas | 5003 | 11 | 0 |
67462 | 67462 | 2020-04-18 | Baxter | Arkansas | 5005 | 5 | 0 |
67463 | 67463 | 2020-04-18 | Benton | Arkansas | 5007 | 62 | 0 |
67464 | 67464 | 2020-04-18 | Boone | Arkansas | 5009 | 3 | 0 |
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);