ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where deaths = 295 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Illinois · 68 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2425283 | 2425283 | 2022-04-20 | Champaign | Illinois | 17019 | 64315 | 295 |
2422027 | 2422027 | 2022-04-19 | Champaign | Illinois | 17019 | 64151 | 295 |
2418771 | 2418771 | 2022-04-18 | Champaign | Illinois | 17019 | 63978 | 295 |
2415515 | 2415515 | 2022-04-17 | Champaign | Illinois | 17019 | 63786 | 295 |
2412259 | 2412259 | 2022-04-16 | Champaign | Illinois | 17019 | 63786 | 295 |
2409003 | 2409003 | 2022-04-15 | Champaign | Illinois | 17019 | 63786 | 295 |
2405747 | 2405747 | 2022-04-14 | Champaign | Illinois | 17019 | 63646 | 295 |
2402492 | 2402492 | 2022-04-13 | Champaign | Illinois | 17019 | 63459 | 295 |
2399237 | 2399237 | 2022-04-12 | Champaign | Illinois | 17019 | 63243 | 295 |
2395982 | 2395982 | 2022-04-11 | Champaign | Illinois | 17019 | 63028 | 295 |
2392726 | 2392726 | 2022-04-10 | Champaign | Illinois | 17019 | 62825 | 295 |
2389470 | 2389470 | 2022-04-09 | Champaign | Illinois | 17019 | 62825 | 295 |
2386215 | 2386215 | 2022-04-08 | Champaign | Illinois | 17019 | 62825 | 295 |
2382960 | 2382960 | 2022-04-07 | Champaign | Illinois | 17019 | 62736 | 295 |
2379705 | 2379705 | 2022-04-06 | Champaign | Illinois | 17019 | 62673 | 295 |
2376451 | 2376451 | 2022-04-05 | Champaign | Illinois | 17019 | 62587 | 295 |
2373199 | 2373199 | 2022-04-04 | Champaign | Illinois | 17019 | 62502 | 295 |
2369946 | 2369946 | 2022-04-03 | Champaign | Illinois | 17019 | 62416 | 295 |
2366693 | 2366693 | 2022-04-02 | Champaign | Illinois | 17019 | 62416 | 295 |
2363440 | 2363440 | 2022-04-01 | Champaign | Illinois | 17019 | 62416 | 295 |
2360186 | 2360186 | 2022-03-31 | Champaign | Illinois | 17019 | 62370 | 295 |
2356932 | 2356932 | 2022-03-30 | Champaign | Illinois | 17019 | 62295 | 295 |
2353679 | 2353679 | 2022-03-29 | Champaign | Illinois | 17019 | 62216 | 295 |
2350427 | 2350427 | 2022-03-28 | Champaign | Illinois | 17019 | 62122 | 295 |
2347174 | 2347174 | 2022-03-27 | Champaign | Illinois | 17019 | 62067 | 295 |
2343921 | 2343921 | 2022-03-26 | Champaign | Illinois | 17019 | 62067 | 295 |
2340668 | 2340668 | 2022-03-25 | Champaign | Illinois | 17019 | 62067 | 295 |
2337415 | 2337415 | 2022-03-24 | Champaign | Illinois | 17019 | 62030 | 295 |
2334161 | 2334161 | 2022-03-23 | Champaign | Illinois | 17019 | 61980 | 295 |
2330907 | 2330907 | 2022-03-22 | Champaign | Illinois | 17019 | 61936 | 295 |
2327655 | 2327655 | 2022-03-21 | Champaign | Illinois | 17019 | 61887 | 295 |
2324402 | 2324402 | 2022-03-20 | Champaign | Illinois | 17019 | 61821 | 295 |
2321148 | 2321148 | 2022-03-19 | Champaign | Illinois | 17019 | 61821 | 295 |
2317894 | 2317894 | 2022-03-18 | Champaign | Illinois | 17019 | 61821 | 295 |
2314641 | 2314641 | 2022-03-17 | Champaign | Illinois | 17019 | 61799 | 295 |
2311388 | 2311388 | 2022-03-16 | Champaign | Illinois | 17019 | 61790 | 295 |
2308135 | 2308135 | 2022-03-15 | Champaign | Illinois | 17019 | 61777 | 295 |
2304884 | 2304884 | 2022-03-14 | Champaign | Illinois | 17019 | 61756 | 295 |
2301632 | 2301632 | 2022-03-13 | Champaign | Illinois | 17019 | 61731 | 295 |
2298380 | 2298380 | 2022-03-12 | Champaign | Illinois | 17019 | 61731 | 295 |
2295128 | 2295128 | 2022-03-11 | Champaign | Illinois | 17019 | 61731 | 295 |
2291876 | 2291876 | 2022-03-10 | Champaign | Illinois | 17019 | 61718 | 295 |
2129307 | 2129307 | 2022-01-19 | McLean | Illinois | 17113 | 42264 | 295 |
2126053 | 2126053 | 2022-01-18 | McLean | Illinois | 17113 | 41652 | 295 |
2096781 | 2096781 | 2022-01-09 | Macon | Illinois | 17115 | 22196 | 295 |
2093529 | 2093529 | 2022-01-08 | Macon | Illinois | 17115 | 22196 | 295 |
2090277 | 2090277 | 2022-01-07 | Macon | Illinois | 17115 | 22196 | 295 |
2051259 | 2051259 | 2021-12-26 | Kankakee | Illinois | 17091 | 21495 | 295 |
2048009 | 2048009 | 2021-12-25 | Kankakee | Illinois | 17091 | 21495 | 295 |
2044759 | 2044759 | 2021-12-24 | Kankakee | Illinois | 17091 | 21495 | 295 |
2041510 | 2041510 | 2021-12-23 | Kankakee | Illinois | 17091 | 21495 | 295 |
1690592 | 1690592 | 2021-09-06 | Sangamon | Illinois | 17167 | 23063 | 295 |
1687342 | 1687342 | 2021-09-05 | Sangamon | Illinois | 17167 | 23063 | 295 |
1684092 | 1684092 | 2021-09-04 | Sangamon | Illinois | 17167 | 23063 | 295 |
1680841 | 1680841 | 2021-09-03 | Sangamon | Illinois | 17167 | 23063 | 295 |
1291178 | 1291178 | 2021-05-06 | LaSalle | Illinois | 17099 | 12369 | 295 |
1258751 | 1258751 | 2021-04-26 | Tazewell | Illinois | 17179 | 16345 | 295 |
1258753 | 1258753 | 2021-04-26 | Unknown | Illinois | 0 | 295 | |
1255504 | 1255504 | 2021-04-25 | Tazewell | Illinois | 17179 | 16328 | 295 |
1255506 | 1255506 | 2021-04-25 | Unknown | Illinois | 0 | 295 | |
1249010 | 1249010 | 2021-04-23 | Tazewell | Illinois | 17179 | 16247 | 295 |
1148306 | 1148306 | 2021-03-23 | McHenry | Illinois | 17111 | 25225 | 295 |
1145059 | 1145059 | 2021-03-22 | McHenry | Illinois | 17111 | 25187 | 295 |
1141812 | 1141812 | 2021-03-21 | McHenry | Illinois | 17111 | 25160 | 295 |
1138566 | 1138566 | 2021-03-20 | McHenry | Illinois | 17111 | 25149 | 295 |
1132073 | 1132073 | 2021-03-18 | McHenry | Illinois | 17111 | 25061 | 295 |
1128825 | 1128825 | 2021-03-17 | McHenry | Illinois | 17111 | 24992 | 295 |
222193 | 222193 | 2020-06-09 | Will | Illinois | 17197 | 5961 | 295 |
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);