ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 221 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
county 10
- Marshall 9
- Coffee 6
- Blount 4
- Montgomery 4
- Tallapoosa 4
- Jackson 2
- Mobile 1
- Shelby 1
- St. Clair 1
- Tuscaloosa 1
state 1
- Alabama · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278260 | 2278260 | 2022-03-06 | Blount | Alabama | 1009 | 14803 | 221 |
2275007 | 2275007 | 2022-03-05 | Blount | Alabama | 1009 | 14803 | 221 |
2271754 | 2271754 | 2022-03-04 | Blount | Alabama | 1009 | 14803 | 221 |
2268502 | 2268502 | 2022-03-03 | Blount | Alabama | 1009 | 14799 | 221 |
2265260 | 2265260 | 2022-03-02 | Coffee | Alabama | 1031 | 13303 | 221 |
2262010 | 2262010 | 2022-03-01 | Coffee | Alabama | 1031 | 13301 | 221 |
2258759 | 2258759 | 2022-02-28 | Coffee | Alabama | 1031 | 13296 | 221 |
2258805 | 2258805 | 2022-02-28 | Tallapoosa | Alabama | 1123 | 11296 | 221 |
2255508 | 2255508 | 2022-02-27 | Coffee | Alabama | 1031 | 13295 | 221 |
2255554 | 2255554 | 2022-02-27 | Tallapoosa | Alabama | 1123 | 11296 | 221 |
2252257 | 2252257 | 2022-02-26 | Coffee | Alabama | 1031 | 13293 | 221 |
2252303 | 2252303 | 2022-02-26 | Tallapoosa | Alabama | 1123 | 11294 | 221 |
2249006 | 2249006 | 2022-02-25 | Coffee | Alabama | 1031 | 13290 | 221 |
2249052 | 2249052 | 2022-02-25 | Tallapoosa | Alabama | 1123 | 11288 | 221 |
2245775 | 2245775 | 2022-02-24 | Jackson | Alabama | 1071 | 14876 | 221 |
2242524 | 2242524 | 2022-02-23 | Jackson | Alabama | 1071 | 14872 | 221 |
1271097 | 1271097 | 2021-04-30 | Marshall | Alabama | 1095 | 12147 | 221 |
1267850 | 1267850 | 2021-04-29 | Marshall | Alabama | 1095 | 12129 | 221 |
1264603 | 1264603 | 2021-04-28 | Marshall | Alabama | 1095 | 12112 | 221 |
1261356 | 1261356 | 2021-04-27 | Marshall | Alabama | 1095 | 12094 | 221 |
1258109 | 1258109 | 2021-04-26 | Marshall | Alabama | 1095 | 12085 | 221 |
1254862 | 1254862 | 2021-04-25 | Marshall | Alabama | 1095 | 12082 | 221 |
1251615 | 1251615 | 2021-04-24 | Marshall | Alabama | 1095 | 12077 | 221 |
1248368 | 1248368 | 2021-04-23 | Marshall | Alabama | 1095 | 12064 | 221 |
1245121 | 1245121 | 2021-04-22 | Marshall | Alabama | 1095 | 12043 | 221 |
1105496 | 1105496 | 2021-03-10 | Shelby | Alabama | 1117 | 22377 | 221 |
1066546 | 1066546 | 2021-02-26 | St. Clair | Alabama | 1115 | 8799 | 221 |
901029 | 901029 | 2021-01-06 | Tuscaloosa | Alabama | 1125 | 19485 | 221 |
725766 | 725766 | 2020-11-13 | Montgomery | Alabama | 1101 | 11449 | 221 |
722523 | 722523 | 2020-11-12 | Montgomery | Alabama | 1101 | 11375 | 221 |
719280 | 719280 | 2020-11-11 | Montgomery | Alabama | 1101 | 11287 | 221 |
716037 | 716037 | 2020-11-10 | Montgomery | Alabama | 1101 | 11225 | 221 |
424610 | 424610 | 2020-08-12 | Mobile | Alabama | 1097 | 10763 | 221 |
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);