ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where deaths = 384 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- St. Clair 6
- Lauderdale 4
- Jefferson 2
- Mobile 1
state 1
- Alabama · 13 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2327082 | 2327082 | 2022-03-21 | Lauderdale | Alabama | 1077 | 24039 | 384 |
2323829 | 2323829 | 2022-03-20 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2320575 | 2320575 | 2022-03-19 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2317321 | 2317321 | 2022-03-18 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2223041 | 2223041 | 2022-02-17 | St. Clair | Alabama | 1115 | 24800 | 384 |
2219790 | 2219790 | 2022-02-16 | St. Clair | Alabama | 1115 | 24782 | 384 |
2216540 | 2216540 | 2022-02-15 | St. Clair | Alabama | 1115 | 24751 | 384 |
2213289 | 2213289 | 2022-02-14 | St. Clair | Alabama | 1115 | 24696 | 384 |
2210036 | 2210036 | 2022-02-13 | St. Clair | Alabama | 1115 | 24676 | 384 |
2206783 | 2206783 | 2022-02-12 | St. Clair | Alabama | 1115 | 24659 | 384 |
810142 | 810142 | 2020-12-09 | Mobile | Alabama | 1097 | 21480 | 384 |
683587 | 683587 | 2020-10-31 | Jefferson | Alabama | 1073 | 24285 | 384 |
680344 | 680344 | 2020-10-30 | Jefferson | Alabama | 1073 | 24088 | 384 |
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);