ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 144 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2268544 | 2268544 | 2022-03-03 | Marion | Alabama | 1093 | 7983 | 144 |
2265291 | 2265291 | 2022-03-02 | Marion | Alabama | 1093 | 7984 | 144 |
2262041 | 2262041 | 2022-03-01 | Marion | Alabama | 1093 | 7973 | 144 |
2197003 | 2197003 | 2022-02-09 | Lawrence | Alabama | 1079 | 7327 | 144 |
2193739 | 2193739 | 2022-02-08 | Geneva | Alabama | 1061 | 6017 | 144 |
2193748 | 2193748 | 2022-02-08 | Lawrence | Alabama | 1079 | 7302 | 144 |
2190486 | 2190486 | 2022-02-07 | Geneva | Alabama | 1061 | 5986 | 144 |
2190495 | 2190495 | 2022-02-07 | Lawrence | Alabama | 1079 | 7285 | 144 |
2187233 | 2187233 | 2022-02-06 | Geneva | Alabama | 1061 | 5957 | 144 |
2187242 | 2187242 | 2022-02-06 | Lawrence | Alabama | 1079 | 7261 | 144 |
2183980 | 2183980 | 2022-02-05 | Geneva | Alabama | 1061 | 5957 | 144 |
2183989 | 2183989 | 2022-02-05 | Lawrence | Alabama | 1079 | 7261 | 144 |
2180728 | 2180728 | 2022-02-04 | Geneva | Alabama | 1061 | 5948 | 144 |
2180737 | 2180737 | 2022-02-04 | Lawrence | Alabama | 1079 | 7248 | 144 |
2177486 | 2177486 | 2022-02-03 | Lawrence | Alabama | 1079 | 7158 | 144 |
2174233 | 2174233 | 2022-02-02 | Lawrence | Alabama | 1079 | 7158 | 144 |
1985628 | 1985628 | 2021-12-06 | Escambia | Alabama | 1053 | 6969 | 144 |
1982378 | 1982378 | 2021-12-05 | Escambia | Alabama | 1053 | 6968 | 144 |
1979128 | 1979128 | 2021-12-04 | Escambia | Alabama | 1053 | 6967 | 144 |
1975878 | 1975878 | 2021-12-03 | Escambia | Alabama | 1053 | 6962 | 144 |
1972629 | 1972629 | 2021-12-02 | Escambia | Alabama | 1053 | 6961 | 144 |
1923851 | 1923851 | 2021-11-17 | Chambers | Alabama | 1017 | 5785 | 144 |
1907603 | 1907603 | 2021-11-12 | Chambers | Alabama | 1017 | 5803 | 144 |
1904354 | 1904354 | 2021-11-11 | Chambers | Alabama | 1017 | 5800 | 144 |
1901104 | 1901104 | 2021-11-10 | Chambers | Alabama | 1017 | 5795 | 144 |
1897854 | 1897854 | 2021-11-09 | Chambers | Alabama | 1017 | 5794 | 144 |
1894604 | 1894604 | 2021-11-08 | Chambers | Alabama | 1017 | 5791 | 144 |
1891354 | 1891354 | 2021-11-07 | Chambers | Alabama | 1017 | 5790 | 144 |
1888104 | 1888104 | 2021-11-06 | Chambers | Alabama | 1017 | 5789 | 144 |
1884854 | 1884854 | 2021-11-05 | Chambers | Alabama | 1017 | 5785 | 144 |
1881605 | 1881605 | 2021-11-04 | Chambers | Alabama | 1017 | 5782 | 144 |
1878356 | 1878356 | 2021-11-03 | Chambers | Alabama | 1017 | 5785 | 144 |
1875107 | 1875107 | 2021-11-02 | Chambers | Alabama | 1017 | 5787 | 144 |
1806868 | 1806868 | 2021-10-12 | Autauga | Alabama | 1001 | 9858 | 144 |
1803617 | 1803617 | 2021-10-11 | Autauga | Alabama | 1001 | 9851 | 144 |
1800368 | 1800368 | 2021-10-10 | Autauga | Alabama | 1001 | 9850 | 144 |
1797119 | 1797119 | 2021-10-09 | Autauga | Alabama | 1001 | 9843 | 144 |
1793870 | 1793870 | 2021-10-08 | Autauga | Alabama | 1001 | 9839 | 144 |
1790621 | 1790621 | 2021-10-07 | Autauga | Alabama | 1001 | 9826 | 144 |
1758140 | 1758140 | 2021-09-27 | Chilton | Alabama | 1021 | 6395 | 144 |
1754892 | 1754892 | 2021-09-26 | Chilton | Alabama | 1021 | 6385 | 144 |
1751644 | 1751644 | 2021-09-25 | Chilton | Alabama | 1021 | 6372 | 144 |
1667172 | 1667172 | 2021-08-30 | Blount | Alabama | 1009 | 8530 | 144 |
1663924 | 1663924 | 2021-08-29 | Blount | Alabama | 1009 | 8512 | 144 |
1660676 | 1660676 | 2021-08-28 | Blount | Alabama | 1009 | 8482 | 144 |
1176932 | 1176932 | 2021-04-01 | Tallapoosa | Alabama | 1123 | 3848 | 144 |
1173685 | 1173685 | 2021-03-31 | Tallapoosa | Alabama | 1123 | 3847 | 144 |
1170438 | 1170438 | 2021-03-30 | Tallapoosa | Alabama | 1123 | 3846 | 144 |
1167190 | 1167190 | 2021-03-29 | Tallapoosa | Alabama | 1123 | 3845 | 144 |
1163942 | 1163942 | 2021-03-28 | Tallapoosa | Alabama | 1123 | 3842 | 144 |
1160694 | 1160694 | 2021-03-27 | Tallapoosa | Alabama | 1123 | 3842 | 144 |
1157446 | 1157446 | 2021-03-26 | Tallapoosa | Alabama | 1123 | 3843 | 144 |
1150952 | 1150952 | 2021-03-24 | Tallapoosa | Alabama | 1123 | 3843 | 144 |
1147705 | 1147705 | 2021-03-23 | Tallapoosa | Alabama | 1123 | 3834 | 144 |
1144458 | 1144458 | 2021-03-22 | Tallapoosa | Alabama | 1123 | 3832 | 144 |
1141211 | 1141211 | 2021-03-21 | Tallapoosa | Alabama | 1123 | 3832 | 144 |
1137965 | 1137965 | 2021-03-20 | Tallapoosa | Alabama | 1123 | 3830 | 144 |
1134719 | 1134719 | 2021-03-19 | Tallapoosa | Alabama | 1123 | 3828 | 144 |
1131471 | 1131471 | 2021-03-18 | Tallapoosa | Alabama | 1123 | 3826 | 144 |
1128186 | 1128186 | 2021-03-17 | Dallas | Alabama | 1047 | 3490 | 144 |
1121694 | 1121694 | 2021-03-15 | Dallas | Alabama | 1047 | 3495 | 144 |
1118447 | 1118447 | 2021-03-14 | Dallas | Alabama | 1047 | 3442 | 144 |
1115200 | 1115200 | 2021-03-13 | Dallas | Alabama | 1047 | 3444 | 144 |
978899 | 978899 | 2021-01-30 | Marshall | Alabama | 1095 | 10714 | 144 |
975654 | 975654 | 2021-01-29 | Marshall | Alabama | 1095 | 10714 | 144 |
969175 | 969175 | 2021-01-27 | St. Clair | Alabama | 1115 | 7985 | 144 |
389207 | 389207 | 2020-08-01 | Montgomery | Alabama | 1101 | 6189 | 144 |
385990 | 385990 | 2020-07-31 | Montgomery | Alabama | 1101 | 6139 | 144 |
321941 | 321941 | 2020-07-11 | Mobile | Alabama | 1097 | 4778 | 144 |
290266 | 290266 | 2020-07-01 | Jefferson | Alabama | 1073 | 4436 | 144 |
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);