ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where deaths = 278 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Alabama · 49 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2291306 | 2291306 | 2022-03-10 | Limestone | Alabama | 1083 | 24757 | 278 |
2076637 | 2076637 | 2022-01-03 | DeKalb | Alabama | 1049 | 13621 | 278 |
2073386 | 2073386 | 2022-01-02 | DeKalb | Alabama | 1049 | 13607 | 278 |
2070135 | 2070135 | 2022-01-01 | DeKalb | Alabama | 1049 | 13538 | 278 |
2066884 | 2066884 | 2021-12-31 | DeKalb | Alabama | 1049 | 13538 | 278 |
2063634 | 2063634 | 2021-12-30 | DeKalb | Alabama | 1049 | 13460 | 278 |
2060384 | 2060384 | 2021-12-29 | DeKalb | Alabama | 1049 | 13400 | 278 |
1780896 | 1780896 | 2021-10-04 | Cullman | Alabama | 1043 | 14965 | 278 |
1777646 | 1777646 | 2021-10-03 | Cullman | Alabama | 1043 | 14938 | 278 |
1774396 | 1774396 | 2021-10-02 | Cullman | Alabama | 1043 | 14923 | 278 |
1745173 | 1745173 | 2021-09-23 | Lauderdale | Alabama | 1077 | 13395 | 278 |
1741924 | 1741924 | 2021-09-22 | Lauderdale | Alabama | 1077 | 13298 | 278 |
1696463 | 1696463 | 2021-09-08 | Shelby | Alabama | 1117 | 33642 | 278 |
1391229 | 1391229 | 2021-06-06 | Walker | Alabama | 1127 | 7310 | 278 |
1387984 | 1387984 | 2021-06-05 | Walker | Alabama | 1127 | 7310 | 278 |
1384739 | 1384739 | 2021-06-04 | Walker | Alabama | 1127 | 7310 | 278 |
1381493 | 1381493 | 2021-06-03 | Walker | Alabama | 1127 | 7306 | 278 |
1378248 | 1378248 | 2021-06-02 | Walker | Alabama | 1127 | 7304 | 278 |
1375002 | 1375002 | 2021-06-01 | Walker | Alabama | 1127 | 7296 | 278 |
1371757 | 1371757 | 2021-05-31 | Walker | Alabama | 1127 | 7284 | 278 |
1368511 | 1368511 | 2021-05-30 | Walker | Alabama | 1127 | 7284 | 278 |
1365265 | 1365265 | 2021-05-29 | Walker | Alabama | 1127 | 7284 | 278 |
1362019 | 1362019 | 2021-05-28 | Walker | Alabama | 1127 | 7284 | 278 |
1358773 | 1358773 | 2021-05-27 | Walker | Alabama | 1127 | 7283 | 278 |
1332797 | 1332797 | 2021-05-19 | Walker | Alabama | 1127 | 7263 | 278 |
1329550 | 1329550 | 2021-05-18 | Walker | Alabama | 1127 | 7263 | 278 |
1326304 | 1326304 | 2021-05-17 | Walker | Alabama | 1127 | 7261 | 278 |
1323058 | 1323058 | 2021-05-16 | Walker | Alabama | 1127 | 7261 | 278 |
1319812 | 1319812 | 2021-05-15 | Walker | Alabama | 1127 | 7260 | 278 |
1271101 | 1271101 | 2021-04-30 | Morgan | Alabama | 1103 | 14229 | 278 |
1271113 | 1271113 | 2021-04-30 | Walker | Alabama | 1127 | 7200 | 278 |
1267866 | 1267866 | 2021-04-29 | Walker | Alabama | 1127 | 7199 | 278 |
1264619 | 1264619 | 2021-04-28 | Walker | Alabama | 1127 | 7190 | 278 |
1261372 | 1261372 | 2021-04-27 | Walker | Alabama | 1127 | 7184 | 278 |
1258125 | 1258125 | 2021-04-26 | Walker | Alabama | 1127 | 7176 | 278 |
1254878 | 1254878 | 2021-04-25 | Walker | Alabama | 1127 | 7175 | 278 |
1251631 | 1251631 | 2021-04-24 | Walker | Alabama | 1127 | 7170 | 278 |
1248384 | 1248384 | 2021-04-23 | Walker | Alabama | 1127 | 7167 | 278 |
1225623 | 1225623 | 2021-04-16 | Houston | Alabama | 1069 | 10404 | 278 |
1222376 | 1222376 | 2021-04-15 | Houston | Alabama | 1069 | 10402 | 278 |
1219128 | 1219128 | 2021-04-14 | Houston | Alabama | 1069 | 10395 | 278 |
1215880 | 1215880 | 2021-04-13 | Houston | Alabama | 1069 | 10381 | 278 |
1212633 | 1212633 | 2021-04-12 | Houston | Alabama | 1069 | 10383 | 278 |
1209384 | 1209384 | 2021-04-11 | Houston | Alabama | 1069 | 10380 | 278 |
1206136 | 1206136 | 2021-04-10 | Houston | Alabama | 1069 | 10379 | 278 |
1053513 | 1053513 | 2021-02-22 | Calhoun | Alabama | 1015 | 13017 | 278 |
1050266 | 1050266 | 2021-02-21 | Calhoun | Alabama | 1015 | 12940 | 278 |
1047019 | 1047019 | 2021-02-20 | Calhoun | Alabama | 1015 | 12915 | 278 |
450408 | 450408 | 2020-08-20 | Jefferson | Alabama | 1073 | 14782 | 278 |
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);