ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where deaths = 220 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2281531 | 2281531 | 2022-03-07 | Dale | Alabama | 1045 | 12433 | 220 |
2278275 | 2278275 | 2022-03-06 | Covington | Alabama | 1039 | 9246 | 220 |
2275022 | 2275022 | 2022-03-05 | Covington | Alabama | 1039 | 9246 | 220 |
2271769 | 2271769 | 2022-03-04 | Covington | Alabama | 1039 | 9246 | 220 |
2265249 | 2265249 | 2022-03-02 | Blount | Alabama | 1009 | 14786 | 220 |
2245801 | 2245801 | 2022-02-24 | Tallapoosa | Alabama | 1123 | 11281 | 220 |
2242550 | 2242550 | 2022-02-23 | Tallapoosa | Alabama | 1123 | 11270 | 220 |
2239299 | 2239299 | 2022-02-22 | Tallapoosa | Alabama | 1123 | 11262 | 220 |
2236048 | 2236048 | 2022-02-21 | Tallapoosa | Alabama | 1123 | 11254 | 220 |
2232797 | 2232797 | 2022-02-20 | Tallapoosa | Alabama | 1123 | 11253 | 220 |
2229546 | 2229546 | 2022-02-19 | Tallapoosa | Alabama | 1123 | 11248 | 220 |
2167712 | 2167712 | 2022-01-31 | Dallas | Alabama | 1047 | 7813 | 220 |
2164457 | 2164457 | 2022-01-30 | Dallas | Alabama | 1047 | 7770 | 220 |
2161202 | 2161202 | 2022-01-29 | Dallas | Alabama | 1047 | 7735 | 220 |
1985643 | 1985643 | 2021-12-06 | Limestone | Alabama | 1083 | 16206 | 220 |
1982393 | 1982393 | 2021-12-05 | Limestone | Alabama | 1083 | 16200 | 220 |
1979143 | 1979143 | 2021-12-04 | Limestone | Alabama | 1083 | 16195 | 220 |
1975893 | 1975893 | 2021-12-03 | Limestone | Alabama | 1083 | 16192 | 220 |
1972644 | 1972644 | 2021-12-02 | Limestone | Alabama | 1083 | 16178 | 220 |
1969394 | 1969394 | 2021-12-01 | Limestone | Alabama | 1083 | 16165 | 220 |
1764667 | 1764667 | 2021-09-29 | Lee | Alabama | 1081 | 22805 | 220 |
1761418 | 1761418 | 2021-09-28 | Lee | Alabama | 1081 | 22751 | 220 |
1758170 | 1758170 | 2021-09-27 | Lee | Alabama | 1081 | 22712 | 220 |
1754922 | 1754922 | 2021-09-26 | Lee | Alabama | 1081 | 22680 | 220 |
1751674 | 1751674 | 2021-09-25 | Lee | Alabama | 1081 | 22590 | 220 |
1722413 | 1722413 | 2021-09-16 | DeKalb | Alabama | 1049 | 11788 | 220 |
1719165 | 1719165 | 2021-09-15 | DeKalb | Alabama | 1049 | 11705 | 220 |
1715917 | 1715917 | 2021-09-14 | DeKalb | Alabama | 1049 | 11653 | 220 |
1712671 | 1712671 | 2021-09-13 | DeKalb | Alabama | 1049 | 11568 | 220 |
1709424 | 1709424 | 2021-09-12 | DeKalb | Alabama | 1049 | 11550 | 220 |
1706177 | 1706177 | 2021-09-11 | DeKalb | Alabama | 1049 | 11531 | 220 |
1676931 | 1676931 | 2021-09-02 | Cullman | Alabama | 1043 | 12626 | 220 |
1602227 | 1602227 | 2021-08-10 | Elmore | Alabama | 1051 | 11333 | 220 |
1598979 | 1598979 | 2021-08-09 | Elmore | Alabama | 1051 | 11275 | 220 |
1595730 | 1595730 | 2021-08-08 | Elmore | Alabama | 1051 | 11187 | 220 |
1592481 | 1592481 | 2021-08-07 | Elmore | Alabama | 1051 | 11187 | 220 |
1589232 | 1589232 | 2021-08-06 | Elmore | Alabama | 1051 | 11139 | 220 |
1585983 | 1585983 | 2021-08-05 | Elmore | Alabama | 1051 | 11078 | 220 |
1582733 | 1582733 | 2021-08-04 | Elmore | Alabama | 1051 | 11006 | 220 |
1241874 | 1241874 | 2021-04-21 | Marshall | Alabama | 1095 | 12022 | 220 |
1238627 | 1238627 | 2021-04-20 | Marshall | Alabama | 1095 | 12015 | 220 |
1235380 | 1235380 | 2021-04-19 | Marshall | Alabama | 1095 | 12012 | 220 |
1232132 | 1232132 | 2021-04-18 | Marshall | Alabama | 1095 | 12009 | 220 |
1228884 | 1228884 | 2021-04-17 | Marshall | Alabama | 1095 | 12007 | 220 |
1225636 | 1225636 | 2021-04-16 | Marshall | Alabama | 1095 | 11995 | 220 |
1222389 | 1222389 | 2021-04-15 | Marshall | Alabama | 1095 | 11988 | 220 |
1219141 | 1219141 | 2021-04-14 | Marshall | Alabama | 1095 | 11982 | 220 |
1102250 | 1102250 | 2021-03-09 | Shelby | Alabama | 1117 | 22337 | 220 |
1063301 | 1063301 | 2021-02-25 | St. Clair | Alabama | 1115 | 8783 | 220 |
1060056 | 1060056 | 2021-02-24 | St. Clair | Alabama | 1115 | 8771 | 220 |
1011365 | 1011365 | 2021-02-09 | Morgan | Alabama | 1103 | 13285 | 220 |
1008119 | 1008119 | 2021-02-08 | Morgan | Alabama | 1103 | 13272 | 220 |
1004873 | 1004873 | 2021-02-07 | Morgan | Alabama | 1103 | 13250 | 220 |
1001627 | 1001627 | 2021-02-06 | Morgan | Alabama | 1103 | 13217 | 220 |
991872 | 991872 | 2021-02-03 | Houston | Alabama | 1069 | 9578 | 220 |
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);