ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where deaths = 119 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2265251 | 2265251 | 2022-03-02 | Butler | Alabama | 1013 | 5037 | 119 |
2262001 | 2262001 | 2022-03-01 | Butler | Alabama | 1013 | 5037 | 119 |
2258750 | 2258750 | 2022-02-28 | Butler | Alabama | 1013 | 5035 | 119 |
2255499 | 2255499 | 2022-02-27 | Butler | Alabama | 1013 | 5035 | 119 |
2252248 | 2252248 | 2022-02-26 | Butler | Alabama | 1013 | 5035 | 119 |
2213285 | 2213285 | 2022-02-14 | Pike | Alabama | 1109 | 7341 | 119 |
2210032 | 2210032 | 2022-02-13 | Pike | Alabama | 1109 | 7338 | 119 |
2206779 | 2206779 | 2022-02-12 | Pike | Alabama | 1109 | 7333 | 119 |
2203526 | 2203526 | 2022-02-11 | Pike | Alabama | 1109 | 7320 | 119 |
2200272 | 2200272 | 2022-02-10 | Pike | Alabama | 1109 | 7295 | 119 |
2197018 | 2197018 | 2022-02-09 | Pike | Alabama | 1109 | 7242 | 119 |
2193763 | 2193763 | 2022-02-08 | Pike | Alabama | 1109 | 7228 | 119 |
2190510 | 2190510 | 2022-02-07 | Pike | Alabama | 1109 | 7204 | 119 |
2187257 | 2187257 | 2022-02-06 | Pike | Alabama | 1109 | 7176 | 119 |
2184004 | 2184004 | 2022-02-05 | Pike | Alabama | 1109 | 7176 | 119 |
2180752 | 2180752 | 2022-02-04 | Pike | Alabama | 1109 | 7164 | 119 |
1719141 | 1719141 | 2021-09-15 | Autauga | Alabama | 1001 | 9371 | 119 |
1715893 | 1715893 | 2021-09-14 | Autauga | Alabama | 1001 | 9351 | 119 |
1712647 | 1712647 | 2021-09-13 | Autauga | Alabama | 1001 | 9317 | 119 |
1709400 | 1709400 | 2021-09-12 | Autauga | Alabama | 1001 | 9287 | 119 |
1706153 | 1706153 | 2021-09-11 | Autauga | Alabama | 1001 | 9246 | 119 |
1702905 | 1702905 | 2021-09-10 | Autauga | Alabama | 1001 | 9207 | 119 |
1699655 | 1699655 | 2021-09-09 | Autauga | Alabama | 1001 | 9145 | 119 |
1696406 | 1696406 | 2021-09-08 | Autauga | Alabama | 1001 | 9108 | 119 |
1693158 | 1693158 | 2021-09-07 | Autauga | Alabama | 1001 | 9063 | 119 |
1689909 | 1689909 | 2021-09-06 | Autauga | Alabama | 1001 | 9048 | 119 |
1686659 | 1686659 | 2021-09-05 | Autauga | Alabama | 1001 | 9012 | 119 |
1683409 | 1683409 | 2021-09-04 | Autauga | Alabama | 1001 | 8959 | 119 |
1680158 | 1680158 | 2021-09-03 | Autauga | Alabama | 1001 | 8909 | 119 |
1676910 | 1676910 | 2021-09-02 | Autauga | Alabama | 1001 | 8873 | 119 |
1657434 | 1657434 | 2021-08-27 | Chilton | Alabama | 1021 | 5507 | 119 |
1654186 | 1654186 | 2021-08-26 | Chilton | Alabama | 1021 | 5445 | 119 |
1650940 | 1650940 | 2021-08-25 | Chilton | Alabama | 1021 | 5343 | 119 |
1647691 | 1647691 | 2021-08-24 | Chilton | Alabama | 1021 | 5343 | 119 |
1644442 | 1644442 | 2021-08-23 | Chilton | Alabama | 1021 | 5343 | 119 |
1641192 | 1641192 | 2021-08-22 | Chilton | Alabama | 1021 | 5322 | 119 |
1637942 | 1637942 | 2021-08-21 | Chilton | Alabama | 1021 | 5304 | 119 |
1634692 | 1634692 | 2021-08-20 | Chilton | Alabama | 1021 | 5238 | 119 |
1631444 | 1631444 | 2021-08-19 | Chilton | Alabama | 1021 | 5202 | 119 |
1628197 | 1628197 | 2021-08-18 | Chilton | Alabama | 1021 | 5166 | 119 |
1602237 | 1602237 | 2021-08-10 | Jackson | Alabama | 1071 | 7565 | 119 |
1598989 | 1598989 | 2021-08-09 | Jackson | Alabama | 1071 | 7539 | 119 |
1595740 | 1595740 | 2021-08-08 | Jackson | Alabama | 1071 | 7521 | 119 |
1592491 | 1592491 | 2021-08-07 | Jackson | Alabama | 1071 | 7521 | 119 |
1589229 | 1589229 | 2021-08-06 | Dale | Alabama | 1045 | 5935 | 119 |
1589242 | 1589242 | 2021-08-06 | Jackson | Alabama | 1071 | 7497 | 119 |
1585980 | 1585980 | 2021-08-05 | Dale | Alabama | 1045 | 5877 | 119 |
1391185 | 1391185 | 2021-06-06 | Covington | Alabama | 1039 | 4226 | 119 |
1387940 | 1387940 | 2021-06-05 | Covington | Alabama | 1039 | 4226 | 119 |
1384695 | 1384695 | 2021-06-04 | Covington | Alabama | 1039 | 4226 | 119 |
1381449 | 1381449 | 2021-06-03 | Covington | Alabama | 1039 | 4223 | 119 |
1378204 | 1378204 | 2021-06-02 | Covington | Alabama | 1039 | 4221 | 119 |
1374958 | 1374958 | 2021-06-01 | Covington | Alabama | 1039 | 4218 | 119 |
1371713 | 1371713 | 2021-05-31 | Covington | Alabama | 1039 | 4217 | 119 |
1368467 | 1368467 | 2021-05-30 | Covington | Alabama | 1039 | 4217 | 119 |
1365221 | 1365221 | 2021-05-29 | Covington | Alabama | 1039 | 4217 | 119 |
1361975 | 1361975 | 2021-05-28 | Covington | Alabama | 1039 | 4217 | 119 |
1358729 | 1358729 | 2021-05-27 | Covington | Alabama | 1039 | 4212 | 119 |
1355483 | 1355483 | 2021-05-26 | Covington | Alabama | 1039 | 4206 | 119 |
1352237 | 1352237 | 2021-05-25 | Covington | Alabama | 1039 | 4192 | 119 |
1348991 | 1348991 | 2021-05-24 | Covington | Alabama | 1039 | 4176 | 119 |
1345743 | 1345743 | 2021-05-23 | Covington | Alabama | 1039 | 4176 | 119 |
1342495 | 1342495 | 2021-05-22 | Covington | Alabama | 1039 | 4175 | 119 |
1339247 | 1339247 | 2021-05-21 | Covington | Alabama | 1039 | 4174 | 119 |
1336000 | 1336000 | 2021-05-20 | Covington | Alabama | 1039 | 4170 | 119 |
1316516 | 1316516 | 2021-05-14 | Coffee | Alabama | 1031 | 5546 | 119 |
1313270 | 1313270 | 2021-05-13 | Coffee | Alabama | 1031 | 5524 | 119 |
1310023 | 1310023 | 2021-05-12 | Coffee | Alabama | 1031 | 5521 | 119 |
1306777 | 1306777 | 2021-05-11 | Coffee | Alabama | 1031 | 5519 | 119 |
1303531 | 1303531 | 2021-05-10 | Coffee | Alabama | 1031 | 5512 | 119 |
1300284 | 1300284 | 2021-05-09 | Coffee | Alabama | 1031 | 5511 | 119 |
1297037 | 1297037 | 2021-05-08 | Coffee | Alabama | 1031 | 5509 | 119 |
1293791 | 1293791 | 2021-05-07 | Coffee | Alabama | 1031 | 5506 | 119 |
1180126 | 1180126 | 2021-04-02 | Chambers | Alabama | 1017 | 3489 | 119 |
1079486 | 1079486 | 2021-03-02 | Colbert | Alabama | 1033 | 5993 | 119 |
988652 | 988652 | 2021-02-02 | Talladega | Alabama | 1121 | 6883 | 119 |
949694 | 949694 | 2021-01-21 | Marshall | Alabama | 1095 | 10322 | 119 |
946452 | 946452 | 2021-01-20 | Morgan | Alabama | 1103 | 12389 | 119 |
774406 | 774406 | 2020-11-28 | Calhoun | Alabama | 1015 | 6301 | 119 |
771161 | 771161 | 2020-11-27 | Calhoun | Alabama | 1015 | 6240 | 119 |
767915 | 767915 | 2020-11-26 | Calhoun | Alabama | 1015 | 6215 | 119 |
599276 | 599276 | 2020-10-05 | Tuscaloosa | Alabama | 1125 | 9219 | 119 |
596033 | 596033 | 2020-10-04 | Tuscaloosa | Alabama | 1125 | 9194 | 119 |
592791 | 592791 | 2020-10-03 | Tuscaloosa | Alabama | 1125 | 9131 | 119 |
589551 | 589551 | 2020-10-02 | Tuscaloosa | Alabama | 1125 | 9099 | 119 |
563622 | 563622 | 2020-09-24 | Tuscaloosa | Alabama | 1125 | 7496 | 119 |
243283 | 243283 | 2020-06-16 | Jefferson | Alabama | 1073 | 2636 | 119 |
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);