ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-04-14 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
56458 | 56458 | 2020-04-14 | Autauga | Alabama | 1001 | 23 | 1 |
56459 | 56459 | 2020-04-14 | Baldwin | Alabama | 1003 | 87 | 2 |
56460 | 56460 | 2020-04-14 | Barbour | Alabama | 1005 | 11 | 0 |
56461 | 56461 | 2020-04-14 | Bibb | Alabama | 1007 | 17 | 0 |
56462 | 56462 | 2020-04-14 | Blount | Alabama | 1009 | 16 | 0 |
56463 | 56463 | 2020-04-14 | Bullock | Alabama | 1011 | 8 | 0 |
56464 | 56464 | 2020-04-14 | Butler | Alabama | 1013 | 8 | 0 |
56465 | 56465 | 2020-04-14 | Calhoun | Alabama | 1015 | 62 | 0 |
56466 | 56466 | 2020-04-14 | Chambers | Alabama | 1017 | 216 | 10 |
56467 | 56467 | 2020-04-14 | Cherokee | Alabama | 1019 | 9 | 0 |
56468 | 56468 | 2020-04-14 | Chilton | Alabama | 1021 | 33 | 0 |
56469 | 56469 | 2020-04-14 | Choctaw | Alabama | 1023 | 12 | 0 |
56470 | 56470 | 2020-04-14 | Clarke | Alabama | 1025 | 21 | 0 |
56471 | 56471 | 2020-04-14 | Clay | Alabama | 1027 | 14 | 0 |
56472 | 56472 | 2020-04-14 | Cleburne | Alabama | 1029 | 12 | 0 |
56473 | 56473 | 2020-04-14 | Coffee | Alabama | 1031 | 36 | 0 |
56474 | 56474 | 2020-04-14 | Colbert | Alabama | 1033 | 11 | 1 |
56475 | 56475 | 2020-04-14 | Conecuh | Alabama | 1035 | 5 | 0 |
56476 | 56476 | 2020-04-14 | Coosa | Alabama | 1037 | 18 | 1 |
56477 | 56477 | 2020-04-14 | Covington | Alabama | 1039 | 16 | 0 |
56478 | 56478 | 2020-04-14 | Crenshaw | Alabama | 1041 | 3 | 0 |
56479 | 56479 | 2020-04-14 | Cullman | Alabama | 1043 | 40 | 1 |
56480 | 56480 | 2020-04-14 | Dale | Alabama | 1045 | 12 | 0 |
56481 | 56481 | 2020-04-14 | Dallas | Alabama | 1047 | 17 | 0 |
56482 | 56482 | 2020-04-14 | DeKalb | Alabama | 1049 | 29 | 0 |
56483 | 56483 | 2020-04-14 | Elmore | Alabama | 1051 | 43 | 0 |
56484 | 56484 | 2020-04-14 | Escambia | Alabama | 1053 | 10 | 0 |
56485 | 56485 | 2020-04-14 | Etowah | Alabama | 1055 | 78 | 7 |
56486 | 56486 | 2020-04-14 | Fayette | Alabama | 1057 | 4 | 0 |
56487 | 56487 | 2020-04-14 | Franklin | Alabama | 1059 | 12 | 1 |
56488 | 56488 | 2020-04-14 | Geneva | Alabama | 1061 | 1 | 0 |
56489 | 56489 | 2020-04-14 | Greene | Alabama | 1063 | 18 | 0 |
56490 | 56490 | 2020-04-14 | Hale | Alabama | 1065 | 17 | 0 |
56491 | 56491 | 2020-04-14 | Henry | Alabama | 1067 | 14 | 0 |
56492 | 56492 | 2020-04-14 | Houston | Alabama | 1069 | 52 | 2 |
56493 | 56493 | 2020-04-14 | Jackson | Alabama | 1071 | 29 | 2 |
56494 | 56494 | 2020-04-14 | Jefferson | Alabama | 1073 | 620 | 16 |
56495 | 56495 | 2020-04-14 | Lamar | Alabama | 1075 | 7 | 0 |
56496 | 56496 | 2020-04-14 | Lauderdale | Alabama | 1077 | 22 | 4 |
56497 | 56497 | 2020-04-14 | Lawrence | Alabama | 1079 | 8 | 0 |
56498 | 56498 | 2020-04-14 | Lee | Alabama | 1081 | 265 | 11 |
56499 | 56499 | 2020-04-14 | Limestone | Alabama | 1083 | 37 | 0 |
56500 | 56500 | 2020-04-14 | Lowndes | Alabama | 1085 | 19 | 0 |
56501 | 56501 | 2020-04-14 | Macon | Alabama | 1087 | 19 | 2 |
56502 | 56502 | 2020-04-14 | Madison | Alabama | 1089 | 191 | 3 |
56503 | 56503 | 2020-04-14 | Marengo | Alabama | 1091 | 23 | 1 |
56504 | 56504 | 2020-04-14 | Marion | Alabama | 1093 | 58 | 4 |
56505 | 56505 | 2020-04-14 | Marshall | Alabama | 1095 | 104 | 2 |
56506 | 56506 | 2020-04-14 | Mobile | Alabama | 1097 | 509 | 17 |
56507 | 56507 | 2020-04-14 | Monroe | Alabama | 1099 | 7 | 1 |
56508 | 56508 | 2020-04-14 | Montgomery | Alabama | 1101 | 161 | 5 |
56509 | 56509 | 2020-04-14 | Morgan | Alabama | 1103 | 41 | 0 |
56510 | 56510 | 2020-04-14 | Perry | Alabama | 1105 | 7 | 0 |
56511 | 56511 | 2020-04-14 | Pickens | Alabama | 1107 | 24 | 0 |
56512 | 56512 | 2020-04-14 | Pike | Alabama | 1109 | 22 | 0 |
56513 | 56513 | 2020-04-14 | Randolph | Alabama | 1111 | 45 | 4 |
56514 | 56514 | 2020-04-14 | Russell | Alabama | 1113 | 30 | 0 |
56515 | 56515 | 2020-04-14 | Shelby | Alabama | 1117 | 235 | 7 |
56516 | 56516 | 2020-04-14 | St. Clair | Alabama | 1115 | 45 | 0 |
56517 | 56517 | 2020-04-14 | Sumter | Alabama | 1119 | 26 | 0 |
56518 | 56518 | 2020-04-14 | Talladega | Alabama | 1121 | 38 | 1 |
56519 | 56519 | 2020-04-14 | Tallapoosa | Alabama | 1123 | 123 | 7 |
56520 | 56520 | 2020-04-14 | Tuscaloosa | Alabama | 1125 | 122 | 0 |
56521 | 56521 | 2020-04-14 | Walker | Alabama | 1127 | 84 | 0 |
56522 | 56522 | 2020-04-14 | Washington | Alabama | 1129 | 12 | 1 |
56523 | 56523 | 2020-04-14 | Wilcox | Alabama | 1131 | 31 | 0 |
56524 | 56524 | 2020-04-14 | Winston | Alabama | 1133 | 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);