ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 308 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Alabama · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2249015 | 2249015 | 2022-02-25 | DeKalb | Alabama | 1049 | 18534 | 308 |
2249031 | 2249031 | 2022-02-25 | Lee | Alabama | 1081 | 37497 | 308 |
2245764 | 2245764 | 2022-02-24 | DeKalb | Alabama | 1049 | 18518 | 308 |
2170967 | 2170967 | 2022-02-01 | Elmore | Alabama | 1051 | 22136 | 308 |
2167714 | 2167714 | 2022-01-31 | Elmore | Alabama | 1051 | 22052 | 308 |
2164459 | 2164459 | 2022-01-30 | Elmore | Alabama | 1051 | 21817 | 308 |
2161204 | 2161204 | 2022-01-29 | Elmore | Alabama | 1051 | 21654 | 308 |
2053883 | 2053883 | 2021-12-27 | Cullman | Alabama | 1043 | 16665 | 308 |
2050633 | 2050633 | 2021-12-26 | Cullman | Alabama | 1043 | 16654 | 308 |
2047383 | 2047383 | 2021-12-25 | Cullman | Alabama | 1043 | 16649 | 308 |
2044133 | 2044133 | 2021-12-24 | Cullman | Alabama | 1043 | 16620 | 308 |
2040884 | 2040884 | 2021-12-23 | Cullman | Alabama | 1043 | 16591 | 308 |
2037634 | 2037634 | 2021-12-22 | Cullman | Alabama | 1043 | 16552 | 308 |
1995392 | 1995392 | 2021-12-09 | Lauderdale | Alabama | 1077 | 15170 | 308 |
1992141 | 1992141 | 2021-12-08 | Lauderdale | Alabama | 1077 | 15151 | 308 |
1988890 | 1988890 | 2021-12-07 | Lauderdale | Alabama | 1077 | 15126 | 308 |
1722440 | 1722440 | 2021-09-16 | Morgan | Alabama | 1103 | 19140 | 308 |
1306763 | 1306763 | 2021-05-11 | Baldwin | Alabama | 1003 | 21154 | 308 |
1303517 | 1303517 | 2021-05-10 | Baldwin | Alabama | 1003 | 21135 | 308 |
1300270 | 1300270 | 2021-05-09 | Baldwin | Alabama | 1003 | 21131 | 308 |
1297023 | 1297023 | 2021-05-08 | Baldwin | Alabama | 1003 | 21123 | 308 |
618715 | 618715 | 2020-10-11 | Mobile | Alabama | 1097 | 13954 | 308 |
615473 | 615473 | 2020-10-10 | Mobile | Alabama | 1097 | 13920 | 308 |
612232 | 612232 | 2020-10-09 | Mobile | Alabama | 1097 | 13871 | 308 |
608990 | 608990 | 2020-10-08 | Mobile | Alabama | 1097 | 13829 | 308 |
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);