ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where deaths = 217 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2262014 | 2262014 | 2022-03-01 | Covington | Alabama | 1039 | 9235 | 217 |
2262017 | 2262017 | 2022-03-01 | Dale | Alabama | 1045 | 12430 | 217 |
2258763 | 2258763 | 2022-02-28 | Covington | Alabama | 1039 | 9234 | 217 |
2255512 | 2255512 | 2022-02-27 | Covington | Alabama | 1039 | 9234 | 217 |
2252261 | 2252261 | 2022-02-26 | Covington | Alabama | 1039 | 9233 | 217 |
2248995 | 2248995 | 2022-02-25 | Blount | Alabama | 1009 | 14734 | 217 |
2249010 | 2249010 | 2022-02-25 | Covington | Alabama | 1039 | 9228 | 217 |
2219793 | 2219793 | 2022-02-16 | Tallapoosa | Alabama | 1123 | 11216 | 217 |
2157939 | 2157939 | 2022-01-28 | Colbert | Alabama | 1033 | 14225 | 217 |
2154686 | 2154686 | 2022-01-27 | Colbert | Alabama | 1033 | 14225 | 217 |
2151433 | 2151433 | 2022-01-26 | Colbert | Alabama | 1033 | 14225 | 217 |
2148181 | 2148181 | 2022-01-25 | Colbert | Alabama | 1033 | 14225 | 217 |
2144929 | 2144929 | 2022-01-24 | Colbert | Alabama | 1033 | 14225 | 217 |
2141674 | 2141674 | 2022-01-23 | Colbert | Alabama | 1033 | 14134 | 217 |
2138418 | 2138418 | 2022-01-22 | Colbert | Alabama | 1033 | 13939 | 217 |
2135163 | 2135163 | 2022-01-21 | Colbert | Alabama | 1033 | 13579 | 217 |
2131911 | 2131911 | 2022-01-20 | Colbert | Alabama | 1033 | 13253 | 217 |
2128657 | 2128657 | 2022-01-19 | Colbert | Alabama | 1033 | 12922 | 217 |
2125404 | 2125404 | 2022-01-18 | Colbert | Alabama | 1033 | 12382 | 217 |
2122152 | 2122152 | 2022-01-17 | Colbert | Alabama | 1033 | 12300 | 217 |
2118900 | 2118900 | 2022-01-16 | Colbert | Alabama | 1033 | 12204 | 217 |
2115648 | 2115648 | 2022-01-15 | Colbert | Alabama | 1033 | 11076 | 217 |
2112396 | 2112396 | 2022-01-14 | Colbert | Alabama | 1033 | 11076 | 217 |
2109144 | 2109144 | 2022-01-13 | Colbert | Alabama | 1033 | 11076 | 217 |
2105893 | 2105893 | 2022-01-12 | Colbert | Alabama | 1033 | 11076 | 217 |
2102642 | 2102642 | 2022-01-11 | Colbert | Alabama | 1033 | 10942 | 217 |
2099391 | 2099391 | 2022-01-10 | Colbert | Alabama | 1033 | 10827 | 217 |
2096140 | 2096140 | 2022-01-09 | Colbert | Alabama | 1033 | 10749 | 217 |
2092888 | 2092888 | 2022-01-08 | Colbert | Alabama | 1033 | 10615 | 217 |
2089636 | 2089636 | 2022-01-07 | Colbert | Alabama | 1033 | 10546 | 217 |
1923884 | 1923884 | 2021-11-17 | Limestone | Alabama | 1083 | 16038 | 217 |
1920635 | 1920635 | 2021-11-16 | Limestone | Alabama | 1083 | 16031 | 217 |
1917385 | 1917385 | 2021-11-15 | Limestone | Alabama | 1083 | 16022 | 217 |
1914135 | 1914135 | 2021-11-14 | Limestone | Alabama | 1083 | 16017 | 217 |
1910885 | 1910885 | 2021-11-13 | Limestone | Alabama | 1083 | 16006 | 217 |
1907636 | 1907636 | 2021-11-12 | Limestone | Alabama | 1083 | 15982 | 217 |
1904387 | 1904387 | 2021-11-11 | Limestone | Alabama | 1083 | 15967 | 217 |
1901137 | 1901137 | 2021-11-10 | Limestone | Alabama | 1083 | 15918 | 217 |
1897887 | 1897887 | 2021-11-09 | Limestone | Alabama | 1083 | 15914 | 217 |
1657445 | 1657445 | 2021-08-27 | Cullman | Alabama | 1043 | 12097 | 217 |
1566491 | 1566491 | 2021-07-30 | Elmore | Alabama | 1051 | 10793 | 217 |
1563243 | 1563243 | 2021-07-29 | Elmore | Alabama | 1051 | 10793 | 217 |
1559995 | 1559995 | 2021-07-28 | Elmore | Alabama | 1051 | 10761 | 217 |
1556748 | 1556748 | 2021-07-27 | Elmore | Alabama | 1051 | 10727 | 217 |
1553501 | 1553501 | 2021-07-26 | Elmore | Alabama | 1051 | 10673 | 217 |
1550254 | 1550254 | 2021-07-25 | Elmore | Alabama | 1051 | 10654 | 217 |
1547007 | 1547007 | 2021-07-24 | Elmore | Alabama | 1051 | 10636 | 217 |
1543760 | 1543760 | 2021-07-23 | Elmore | Alabama | 1051 | 10614 | 217 |
1540512 | 1540512 | 2021-07-22 | Elmore | Alabama | 1051 | 10576 | 217 |
1537265 | 1537265 | 2021-07-21 | Elmore | Alabama | 1051 | 10559 | 217 |
1534017 | 1534017 | 2021-07-20 | Elmore | Alabama | 1051 | 10542 | 217 |
1180165 | 1180165 | 2021-04-02 | Marshall | Alabama | 1095 | 11877 | 217 |
1176918 | 1176918 | 2021-04-01 | Marshall | Alabama | 1095 | 11865 | 217 |
1173671 | 1173671 | 2021-03-31 | Marshall | Alabama | 1095 | 11854 | 217 |
1170424 | 1170424 | 2021-03-30 | Marshall | Alabama | 1095 | 11851 | 217 |
1167176 | 1167176 | 2021-03-29 | Marshall | Alabama | 1095 | 11842 | 217 |
1163928 | 1163928 | 2021-03-28 | Marshall | Alabama | 1095 | 11839 | 217 |
1160680 | 1160680 | 2021-03-27 | Marshall | Alabama | 1095 | 11839 | 217 |
1157432 | 1157432 | 2021-03-26 | Marshall | Alabama | 1095 | 11830 | 217 |
1150929 | 1150929 | 2021-03-24 | Lauderdale | Alabama | 1077 | 9065 | 217 |
1150938 | 1150938 | 2021-03-24 | Marshall | Alabama | 1095 | 11816 | 217 |
1147682 | 1147682 | 2021-03-23 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1144435 | 1144435 | 2021-03-22 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1141188 | 1141188 | 2021-03-21 | Lauderdale | Alabama | 1077 | 9024 | 217 |
1137942 | 1137942 | 2021-03-20 | Lauderdale | Alabama | 1077 | 9019 | 217 |
1134696 | 1134696 | 2021-03-19 | Lauderdale | Alabama | 1077 | 9007 | 217 |
1128210 | 1128210 | 2021-03-17 | Marshall | Alabama | 1095 | 11780 | 217 |
1124964 | 1124964 | 2021-03-16 | Marshall | Alabama | 1095 | 11769 | 217 |
1121718 | 1121718 | 2021-03-15 | Marshall | Alabama | 1095 | 11767 | 217 |
1118471 | 1118471 | 2021-03-14 | Marshall | Alabama | 1095 | 11514 | 217 |
1115224 | 1115224 | 2021-03-13 | Marshall | Alabama | 1095 | 11510 | 217 |
998381 | 998381 | 2021-02-05 | Morgan | Alabama | 1103 | 13174 | 217 |
969118 | 969118 | 2021-01-27 | Baldwin | Alabama | 1003 | 17629 | 217 |
962672 | 962672 | 2021-01-25 | Madison | Alabama | 1089 | 28413 | 217 |
959427 | 959427 | 2021-01-24 | Madison | Alabama | 1089 | 28310 | 217 |
956181 | 956181 | 2021-01-23 | Madison | Alabama | 1089 | 28158 | 217 |
421389 | 421389 | 2020-08-11 | Mobile | Alabama | 1097 | 10673 | 217 |
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);