ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where deaths = 153 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Alabama · 71 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310816 | 2310816 | 2022-03-16 | Lawrence | Alabama | 1079 | 7620 | 153 |
2307563 | 2307563 | 2022-03-15 | Lawrence | Alabama | 1079 | 7619 | 153 |
2304312 | 2304312 | 2022-03-14 | Lawrence | Alabama | 1079 | 7616 | 153 |
2301060 | 2301060 | 2022-03-13 | Lawrence | Alabama | 1079 | 7611 | 153 |
2297808 | 2297808 | 2022-03-12 | Lawrence | Alabama | 1079 | 7611 | 153 |
2294556 | 2294556 | 2022-03-11 | Lawrence | Alabama | 1079 | 7611 | 153 |
2291304 | 2291304 | 2022-03-10 | Lawrence | Alabama | 1079 | 7610 | 153 |
2288052 | 2288052 | 2022-03-09 | Lawrence | Alabama | 1079 | 7605 | 153 |
2284800 | 2284800 | 2022-03-08 | Lawrence | Alabama | 1079 | 7602 | 153 |
2281548 | 2281548 | 2022-03-07 | Lawrence | Alabama | 1079 | 7601 | 153 |
2278264 | 2278264 | 2022-03-06 | Chambers | Alabama | 1017 | 8437 | 153 |
2275011 | 2275011 | 2022-03-05 | Chambers | Alabama | 1017 | 8437 | 153 |
2271758 | 2271758 | 2022-03-04 | Chambers | Alabama | 1017 | 8437 | 153 |
2268506 | 2268506 | 2022-03-03 | Chambers | Alabama | 1017 | 8435 | 153 |
2268537 | 2268537 | 2022-03-03 | Lawrence | Alabama | 1079 | 7583 | 153 |
2265253 | 2265253 | 2022-03-02 | Chambers | Alabama | 1017 | 8434 | 153 |
2262003 | 2262003 | 2022-03-01 | Chambers | Alabama | 1017 | 8433 | 153 |
2248999 | 2248999 | 2022-02-25 | Chambers | Alabama | 1017 | 8426 | 153 |
2245748 | 2245748 | 2022-02-24 | Chambers | Alabama | 1017 | 8425 | 153 |
2216508 | 2216508 | 2022-02-15 | Escambia | Alabama | 1053 | 9897 | 153 |
2213257 | 2213257 | 2022-02-14 | Escambia | Alabama | 1053 | 9890 | 153 |
2210004 | 2210004 | 2022-02-13 | Escambia | Alabama | 1053 | 9887 | 153 |
2206751 | 2206751 | 2022-02-12 | Escambia | Alabama | 1053 | 9877 | 153 |
2203498 | 2203498 | 2022-02-11 | Escambia | Alabama | 1053 | 9872 | 153 |
2200244 | 2200244 | 2022-02-10 | Escambia | Alabama | 1053 | 9861 | 153 |
2196990 | 2196990 | 2022-02-09 | Escambia | Alabama | 1053 | 9845 | 153 |
2193735 | 2193735 | 2022-02-08 | Escambia | Alabama | 1053 | 9830 | 153 |
2190482 | 2190482 | 2022-02-07 | Escambia | Alabama | 1053 | 9768 | 153 |
2187229 | 2187229 | 2022-02-06 | Escambia | Alabama | 1053 | 9752 | 153 |
2183976 | 2183976 | 2022-02-05 | Escambia | Alabama | 1053 | 9752 | 153 |
2180724 | 2180724 | 2022-02-04 | Escambia | Alabama | 1053 | 9726 | 153 |
1722404 | 1722404 | 2021-09-16 | Coffee | Alabama | 1031 | 8598 | 153 |
1722408 | 1722408 | 2021-09-16 | Covington | Alabama | 1039 | 6265 | 153 |
1719160 | 1719160 | 2021-09-15 | Covington | Alabama | 1039 | 6214 | 153 |
1715912 | 1715912 | 2021-09-14 | Covington | Alabama | 1039 | 6159 | 153 |
1712666 | 1712666 | 2021-09-13 | Covington | Alabama | 1039 | 6133 | 153 |
1709419 | 1709419 | 2021-09-12 | Covington | Alabama | 1039 | 6115 | 153 |
1706172 | 1706172 | 2021-09-11 | Covington | Alabama | 1039 | 6101 | 153 |
1702924 | 1702924 | 2021-09-10 | Covington | Alabama | 1039 | 6066 | 153 |
1673679 | 1673679 | 2021-09-01 | Colbert | Alabama | 1033 | 7744 | 153 |
1670431 | 1670431 | 2021-08-31 | Colbert | Alabama | 1033 | 7687 | 153 |
1375000 | 1375000 | 2021-06-01 | Tallapoosa | Alabama | 1123 | 4078 | 153 |
1371755 | 1371755 | 2021-05-31 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1368509 | 1368509 | 2021-05-30 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1365263 | 1365263 | 2021-05-29 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1362017 | 1362017 | 2021-05-28 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1358771 | 1358771 | 2021-05-27 | Tallapoosa | Alabama | 1123 | 4076 | 153 |
1355525 | 1355525 | 2021-05-26 | Tallapoosa | Alabama | 1123 | 4070 | 153 |
1352279 | 1352279 | 2021-05-25 | Tallapoosa | Alabama | 1123 | 4067 | 153 |
1348995 | 1348995 | 2021-05-24 | Dallas | Alabama | 1047 | 3586 | 153 |
1345747 | 1345747 | 2021-05-23 | Dallas | Alabama | 1047 | 3586 | 153 |
1342499 | 1342499 | 2021-05-22 | Dallas | Alabama | 1047 | 3584 | 153 |
1339251 | 1339251 | 2021-05-21 | Dallas | Alabama | 1047 | 3582 | 153 |
1336004 | 1336004 | 2021-05-20 | Dallas | Alabama | 1047 | 3581 | 153 |
1332757 | 1332757 | 2021-05-19 | Dallas | Alabama | 1047 | 3575 | 153 |
1332795 | 1332795 | 2021-05-19 | Tallapoosa | Alabama | 1123 | 4053 | 153 |
1329510 | 1329510 | 2021-05-18 | Dallas | Alabama | 1047 | 3573 | 153 |
1329548 | 1329548 | 2021-05-18 | Tallapoosa | Alabama | 1123 | 4052 | 153 |
1326264 | 1326264 | 2021-05-17 | Dallas | Alabama | 1047 | 3569 | 153 |
1326302 | 1326302 | 2021-05-17 | Tallapoosa | Alabama | 1123 | 4044 | 153 |
1323018 | 1323018 | 2021-05-16 | Dallas | Alabama | 1047 | 3569 | 153 |
1323056 | 1323056 | 2021-05-16 | Tallapoosa | Alabama | 1123 | 4044 | 153 |
1319772 | 1319772 | 2021-05-15 | Dallas | Alabama | 1047 | 3568 | 153 |
1319810 | 1319810 | 2021-05-15 | Tallapoosa | Alabama | 1123 | 4044 | 153 |
1316524 | 1316524 | 2021-05-14 | Dallas | Alabama | 1047 | 3564 | 153 |
1076265 | 1076265 | 2021-03-01 | Lee | Alabama | 1081 | 14967 | 153 |
1073019 | 1073019 | 2021-02-28 | Lee | Alabama | 1081 | 14961 | 153 |
1069773 | 1069773 | 2021-02-27 | Lee | Alabama | 1081 | 14950 | 153 |
1037337 | 1037337 | 2021-02-17 | Talladega | Alabama | 1121 | 7326 | 153 |
793913 | 793913 | 2020-12-04 | Madison | Alabama | 1089 | 14521 | 153 |
790668 | 790668 | 2020-12-03 | Madison | Alabama | 1089 | 14215 | 153 |
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);