ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,357 rows where date = "2020-04-03" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Georgia 148
- Texas 145
- Virginia 108
- Indiana 86
- North Carolina 86
- Tennessee 86
- Mississippi 78
- Kentucky 76
- Missouri 76
- Ohio 75
- Michigan 70
- Alabama 65
- Illinois 65
- Iowa 65
- Pennsylvania 63
- Arkansas 62
- Louisiana 62
- Florida 61
- New York 59
- Minnesota 57
- Oklahoma 55
- Colorado 54
- Wisconsin 54
- California 53
- Kansas 47
- South Carolina 46
- Washington 37
- South Dakota 31
- West Virginia 31
- Idaho 30
- …
fips >30
county >30
- Unknown 31
- Washington 29
- Franklin 21
- Jefferson 20
- Lincoln 19
- Jackson 18
- Madison 16
- Montgomery 16
- Union 14
- Clay 13
- Marion 13
- Carroll 12
- Monroe 12
- Warren 12
- Greene 11
- Clark 10
- Crawford 10
- Douglas 10
- Fayette 10
- Grant 10
- Adams 9
- Henry 9
- Johnson 9
- Lawrence 9
- Lee 9
- Marshall 9
- Morgan 9
- Wayne 9
- Benton 8
- Clinton 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28397 | 28397 | 2020-04-03 | Autauga | Alabama | 1001 | 12 | 0 |
28398 | 28398 | 2020-04-03 | Baldwin | Alabama | 1003 | 28 | 1 |
28399 | 28399 | 2020-04-03 | Barbour | Alabama | 1005 | 1 | 0 |
28400 | 28400 | 2020-04-03 | Bibb | Alabama | 1007 | 4 | 0 |
28401 | 28401 | 2020-04-03 | Blount | Alabama | 1009 | 9 | 0 |
28402 | 28402 | 2020-04-03 | Bullock | Alabama | 1011 | 2 | 0 |
28403 | 28403 | 2020-04-03 | Butler | Alabama | 1013 | 1 | 0 |
28404 | 28404 | 2020-04-03 | Calhoun | Alabama | 1015 | 20 | 0 |
28405 | 28405 | 2020-04-03 | Chambers | Alabama | 1017 | 81 | 5 |
28406 | 28406 | 2020-04-03 | Cherokee | Alabama | 1019 | 5 | 0 |
28407 | 28407 | 2020-04-03 | Chilton | Alabama | 1021 | 15 | 0 |
28408 | 28408 | 2020-04-03 | Choctaw | Alabama | 1023 | 4 | 0 |
28409 | 28409 | 2020-04-03 | Clarke | Alabama | 1025 | 3 | 0 |
28410 | 28410 | 2020-04-03 | Clay | Alabama | 1027 | 8 | 0 |
28411 | 28411 | 2020-04-03 | Cleburne | Alabama | 1029 | 7 | 0 |
28412 | 28412 | 2020-04-03 | Coffee | Alabama | 1031 | 6 | 0 |
28413 | 28413 | 2020-04-03 | Colbert | Alabama | 1033 | 5 | 0 |
28414 | 28414 | 2020-04-03 | Conecuh | Alabama | 1035 | 1 | 0 |
28415 | 28415 | 2020-04-03 | Coosa | Alabama | 1037 | 6 | 0 |
28416 | 28416 | 2020-04-03 | Covington | Alabama | 1039 | 4 | 0 |
28417 | 28417 | 2020-04-03 | Crenshaw | Alabama | 1041 | 1 | 0 |
28418 | 28418 | 2020-04-03 | Cullman | Alabama | 1043 | 15 | 1 |
28419 | 28419 | 2020-04-03 | Dale | Alabama | 1045 | 1 | 0 |
28420 | 28420 | 2020-04-03 | Dallas | Alabama | 1047 | 7 | 0 |
28421 | 28421 | 2020-04-03 | DeKalb | Alabama | 1049 | 10 | 0 |
28422 | 28422 | 2020-04-03 | Elmore | Alabama | 1051 | 19 | 0 |
28423 | 28423 | 2020-04-03 | Escambia | Alabama | 1053 | 2 | 0 |
28424 | 28424 | 2020-04-03 | Etowah | Alabama | 1055 | 21 | 2 |
28425 | 28425 | 2020-04-03 | Fayette | Alabama | 1057 | 1 | 0 |
28426 | 28426 | 2020-04-03 | Franklin | Alabama | 1059 | 5 | 0 |
28427 | 28427 | 2020-04-03 | Greene | Alabama | 1063 | 5 | 0 |
28428 | 28428 | 2020-04-03 | Hale | Alabama | 1065 | 3 | 0 |
28429 | 28429 | 2020-04-03 | Henry | Alabama | 1067 | 2 | 0 |
28430 | 28430 | 2020-04-03 | Houston | Alabama | 1069 | 12 | 1 |
28431 | 28431 | 2020-04-03 | Jackson | Alabama | 1071 | 12 | 1 |
28432 | 28432 | 2020-04-03 | Jefferson | Alabama | 1073 | 369 | 6 |
28433 | 28433 | 2020-04-03 | Lamar | Alabama | 1075 | 1 | 0 |
28434 | 28434 | 2020-04-03 | Lauderdale | Alabama | 1077 | 14 | 2 |
28435 | 28435 | 2020-04-03 | Lawrence | Alabama | 1079 | 4 | 0 |
28436 | 28436 | 2020-04-03 | Lee | Alabama | 1081 | 99 | 3 |
28437 | 28437 | 2020-04-03 | Limestone | Alabama | 1083 | 30 | 0 |
28438 | 28438 | 2020-04-03 | Lowndes | Alabama | 1085 | 2 | 0 |
28439 | 28439 | 2020-04-03 | Macon | Alabama | 1087 | 5 | 0 |
28440 | 28440 | 2020-04-03 | Madison | Alabama | 1089 | 123 | 1 |
28441 | 28441 | 2020-04-03 | Marengo | Alabama | 1091 | 8 | 0 |
28442 | 28442 | 2020-04-03 | Marion | Alabama | 1093 | 16 | 2 |
28443 | 28443 | 2020-04-03 | Marshall | Alabama | 1095 | 17 | 0 |
28444 | 28444 | 2020-04-03 | Mobile | Alabama | 1097 | 103 | 5 |
28445 | 28445 | 2020-04-03 | Monroe | Alabama | 1099 | 5 | 0 |
28446 | 28446 | 2020-04-03 | Montgomery | Alabama | 1101 | 61 | 1 |
28447 | 28447 | 2020-04-03 | Morgan | Alabama | 1103 | 24 | 0 |
28448 | 28448 | 2020-04-03 | Pickens | Alabama | 1107 | 11 | 0 |
28449 | 28449 | 2020-04-03 | Pike | Alabama | 1109 | 10 | 0 |
28450 | 28450 | 2020-04-03 | Randolph | Alabama | 1111 | 10 | 1 |
28451 | 28451 | 2020-04-03 | Russell | Alabama | 1113 | 4 | 0 |
28452 | 28452 | 2020-04-03 | Shelby | Alabama | 1117 | 115 | 4 |
28453 | 28453 | 2020-04-03 | St. Clair | Alabama | 1115 | 23 | 0 |
28454 | 28454 | 2020-04-03 | Sumter | Alabama | 1119 | 7 | 0 |
28455 | 28455 | 2020-04-03 | Talladega | Alabama | 1121 | 12 | 0 |
28456 | 28456 | 2020-04-03 | Tallapoosa | Alabama | 1123 | 20 | 1 |
28457 | 28457 | 2020-04-03 | Tuscaloosa | Alabama | 1125 | 41 | 0 |
28458 | 28458 | 2020-04-03 | Walker | Alabama | 1127 | 49 | 0 |
28459 | 28459 | 2020-04-03 | Washington | Alabama | 1129 | 5 | 1 |
28460 | 28460 | 2020-04-03 | Wilcox | Alabama | 1131 | 6 | 0 |
28461 | 28461 | 2020-04-03 | Winston | Alabama | 1133 | 3 | 0 |
28462 | 28462 | 2020-04-03 | Anchorage | Alaska | 2020 | 73 | 2 |
28463 | 28463 | 2020-04-03 | Fairbanks North Star Borough | Alaska | 2090 | 42 | 0 |
28464 | 28464 | 2020-04-03 | Juneau City and Borough | Alaska | 2110 | 11 | 0 |
28465 | 28465 | 2020-04-03 | Kenai Peninsula Borough | Alaska | 2122 | 10 | 0 |
28466 | 28466 | 2020-04-03 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
28467 | 28467 | 2020-04-03 | Matanuska-Susitna Borough | Alaska | 2170 | 4 | 0 |
28468 | 28468 | 2020-04-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
28469 | 28469 | 2020-04-03 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
28470 | 28470 | 2020-04-03 | Apache | Arizona | 4001 | 17 | 0 |
28471 | 28471 | 2020-04-03 | Cochise | Arizona | 4003 | 5 | 0 |
28472 | 28472 | 2020-04-03 | Coconino | Arizona | 4005 | 126 | 8 |
28473 | 28473 | 2020-04-03 | Gila | Arizona | 4007 | 2 | 0 |
28474 | 28474 | 2020-04-03 | Graham | Arizona | 4009 | 2 | 0 |
28475 | 28475 | 2020-04-03 | Greenlee | Arizona | 4011 | 1 | 0 |
28476 | 28476 | 2020-04-03 | La Paz | Arizona | 4012 | 2 | 0 |
28477 | 28477 | 2020-04-03 | Maricopa | Arizona | 4013 | 1049 | 17 |
28478 | 28478 | 2020-04-03 | Mohave | Arizona | 4015 | 9 | 0 |
28479 | 28479 | 2020-04-03 | Navajo | Arizona | 4017 | 148 | 1 |
28480 | 28480 | 2020-04-03 | Pima | Arizona | 4019 | 280 | 11 |
28481 | 28481 | 2020-04-03 | Pinal | Arizona | 4021 | 77 | 0 |
28482 | 28482 | 2020-04-03 | Santa Cruz | Arizona | 4023 | 3 | 0 |
28483 | 28483 | 2020-04-03 | Unknown | Arizona | 0 | 4 | |
28484 | 28484 | 2020-04-03 | Yavapai | Arizona | 4025 | 35 | 0 |
28485 | 28485 | 2020-04-03 | Yuma | Arizona | 4027 | 13 | 0 |
28486 | 28486 | 2020-04-03 | Arkansas | Arkansas | 5001 | 1 | 0 |
28487 | 28487 | 2020-04-03 | Ashley | Arkansas | 5003 | 4 | 0 |
28488 | 28488 | 2020-04-03 | Baxter | Arkansas | 5005 | 3 | 0 |
28489 | 28489 | 2020-04-03 | Benton | Arkansas | 5007 | 41 | 0 |
28490 | 28490 | 2020-04-03 | Boone | Arkansas | 5009 | 3 | 0 |
28491 | 28491 | 2020-04-03 | Bradley | Arkansas | 5011 | 4 | 0 |
28492 | 28492 | 2020-04-03 | Carroll | Arkansas | 5015 | 1 | 0 |
28493 | 28493 | 2020-04-03 | Chicot | Arkansas | 5017 | 2 | 0 |
28494 | 28494 | 2020-04-03 | Clark | Arkansas | 5019 | 27 | 0 |
28495 | 28495 | 2020-04-03 | Cleburne | Arkansas | 5023 | 65 | 3 |
28496 | 28496 | 2020-04-03 | Cleveland | Arkansas | 5025 | 4 | 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);