ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 353 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
state 1
- Alabama · 29 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278316 | 2278316 | 2022-03-06 | Talladega | Alabama | 1121 | 22132 | 353 |
2275063 | 2275063 | 2022-03-05 | Talladega | Alabama | 1121 | 22132 | 353 |
2271810 | 2271810 | 2022-03-04 | Talladega | Alabama | 1121 | 22132 | 353 |
2219770 | 2219770 | 2022-02-16 | Lauderdale | Alabama | 1077 | 23672 | 353 |
2216529 | 2216529 | 2022-02-15 | Marshall | Alabama | 1095 | 26953 | 353 |
1917402 | 1917402 | 2021-11-15 | St. Clair | Alabama | 1115 | 16779 | 353 |
1914152 | 1914152 | 2021-11-14 | St. Clair | Alabama | 1115 | 16772 | 353 |
1910902 | 1910902 | 2021-11-13 | St. Clair | Alabama | 1115 | 16763 | 353 |
1858911 | 1858911 | 2021-10-28 | Shelby | Alabama | 1117 | 37832 | 353 |
1735422 | 1735422 | 2021-09-20 | Houston | Alabama | 1069 | 16274 | 353 |
1732172 | 1732172 | 2021-09-19 | Houston | Alabama | 1069 | 16202 | 353 |
1728922 | 1728922 | 2021-09-18 | Houston | Alabama | 1069 | 16139 | 353 |
1332761 | 1332761 | 2021-05-19 | Etowah | Alabama | 1055 | 13936 | 353 |
1329514 | 1329514 | 2021-05-18 | Etowah | Alabama | 1055 | 13938 | 353 |
1326268 | 1326268 | 2021-05-17 | Etowah | Alabama | 1055 | 13927 | 353 |
1323022 | 1323022 | 2021-05-16 | Etowah | Alabama | 1055 | 13925 | 353 |
1319776 | 1319776 | 2021-05-15 | Etowah | Alabama | 1055 | 13918 | 353 |
1316528 | 1316528 | 2021-05-14 | Etowah | Alabama | 1055 | 13890 | 353 |
1313282 | 1313282 | 2021-05-13 | Etowah | Alabama | 1055 | 13861 | 353 |
1310035 | 1310035 | 2021-05-12 | Etowah | Alabama | 1055 | 13849 | 353 |
1306789 | 1306789 | 2021-05-11 | Etowah | Alabama | 1055 | 13843 | 353 |
1303543 | 1303543 | 2021-05-10 | Etowah | Alabama | 1055 | 13834 | 353 |
1300296 | 1300296 | 2021-05-09 | Etowah | Alabama | 1055 | 13831 | 353 |
1297049 | 1297049 | 2021-05-08 | Etowah | Alabama | 1055 | 13826 | 353 |
1293803 | 1293803 | 2021-05-07 | Etowah | Alabama | 1055 | 13819 | 353 |
1290557 | 1290557 | 2021-05-06 | Etowah | Alabama | 1055 | 13813 | 353 |
995128 | 995128 | 2021-02-04 | Madison | Alabama | 1089 | 30305 | 353 |
605735 | 605735 | 2020-10-07 | Jefferson | Alabama | 1073 | 20938 | 353 |
602493 | 602493 | 2020-10-06 | Jefferson | Alabama | 1073 | 20842 | 353 |
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);