ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 304 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Illinois · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2285456 | 2285456 | 2022-03-08 | Vermilion | Illinois | 17183 | 27830 | 304 |
2282204 | 2282204 | 2022-03-07 | Vermilion | Illinois | 17183 | 27827 | 304 |
2278951 | 2278951 | 2022-03-06 | Vermilion | Illinois | 17183 | 27824 | 304 |
2275698 | 2275698 | 2022-03-05 | Vermilion | Illinois | 17183 | 27824 | 304 |
2272445 | 2272445 | 2022-03-04 | Vermilion | Illinois | 17183 | 27824 | 304 |
2269193 | 2269193 | 2022-03-03 | Vermilion | Illinois | 17183 | 27810 | 304 |
2265940 | 2265940 | 2022-03-02 | Vermilion | Illinois | 17183 | 27811 | 304 |
2262689 | 2262689 | 2022-03-01 | Vermilion | Illinois | 17183 | 27809 | 304 |
2259438 | 2259438 | 2022-02-28 | Vermilion | Illinois | 17183 | 27795 | 304 |
2256187 | 2256187 | 2022-02-27 | Vermilion | Illinois | 17183 | 27777 | 304 |
2252936 | 2252936 | 2022-02-26 | Vermilion | Illinois | 17183 | 27777 | 304 |
2249685 | 2249685 | 2022-02-25 | Vermilion | Illinois | 17183 | 27777 | 304 |
2246434 | 2246434 | 2022-02-24 | Vermilion | Illinois | 17183 | 27771 | 304 |
2129298 | 2129298 | 2022-01-19 | Macon | Illinois | 17115 | 26451 | 304 |
2126044 | 2126044 | 2022-01-18 | Macon | Illinois | 17115 | 26093 | 304 |
2080513 | 2080513 | 2022-01-04 | Kankakee | Illinois | 17091 | 23371 | 304 |
1424271 | 1424271 | 2021-06-16 | LaSalle | Illinois | 17099 | 12772 | 304 |
1421023 | 1421023 | 2021-06-15 | LaSalle | Illinois | 17099 | 12768 | 304 |
1417778 | 1417778 | 2021-06-14 | LaSalle | Illinois | 17099 | 12767 | 304 |
1414532 | 1414532 | 2021-06-13 | LaSalle | Illinois | 17099 | 12766 | 304 |
1411287 | 1411287 | 2021-06-12 | LaSalle | Illinois | 17099 | 12763 | 304 |
1242489 | 1242489 | 2021-04-21 | McHenry | Illinois | 17111 | 27207 | 304 |
1239242 | 1239242 | 2021-04-20 | McHenry | Illinois | 17111 | 27125 | 304 |
1235995 | 1235995 | 2021-04-19 | McHenry | Illinois | 17111 | 27059 | 304 |
1232748 | 1232748 | 2021-04-18 | McHenry | Illinois | 17111 | 26999 | 304 |
1229499 | 1229499 | 2021-04-17 | McHenry | Illinois | 17111 | 26929 | 304 |
1226251 | 1226251 | 2021-04-16 | McHenry | Illinois | 17111 | 26844 | 304 |
1223004 | 1223004 | 2021-04-15 | McHenry | Illinois | 17111 | 26737 | 304 |
950327 | 950327 | 2021-01-21 | Rock Island | Illinois | 17161 | 12027 | 304 |
947081 | 947081 | 2021-01-20 | Rock Island | Illinois | 17161 | 11977 | 304 |
817270 | 817270 | 2020-12-11 | St. Clair | Illinois | 17163 | 17589 | 304 |
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);