ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
340 rows where deaths = 91 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jersey 39
- Christian 35
- Ogle 35
- Montgomery 33
- Lee 29
- Livingston 24
- Bureau 20
- Logan 19
- Effingham 12
- Franklin 12
- Boone 11
- Coles 9
- Monroe 7
- Fayette 6
- Perry 6
- Fulton 5
- Woodford 5
- Iroquois 4
- Clinton 3
- Kendall 3
- Macoupin 3
- Madison 3
- McHenry 3
- Vermilion 3
- Kankakee 2
- Williamson 2
- Champaign 1
- LaSalle 1
- McLean 1
- Morgan 1
- …
state 1
- Illinois · 340 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500218 | 2500218 | 2022-05-13 | Jersey | Illinois | 17083 | 6320 | 91 |
2496960 | 2496960 | 2022-05-12 | Jersey | Illinois | 17083 | 6314 | 91 |
2493702 | 2493702 | 2022-05-11 | Jersey | Illinois | 17083 | 6310 | 91 |
2490444 | 2490444 | 2022-05-10 | Jersey | Illinois | 17083 | 6307 | 91 |
2487187 | 2487187 | 2022-05-09 | Jersey | Illinois | 17083 | 6299 | 91 |
2483929 | 2483929 | 2022-05-08 | Jersey | Illinois | 17083 | 6292 | 91 |
2480671 | 2480671 | 2022-05-07 | Jersey | Illinois | 17083 | 6292 | 91 |
2477413 | 2477413 | 2022-05-06 | Jersey | Illinois | 17083 | 6292 | 91 |
2474155 | 2474155 | 2022-05-05 | Jersey | Illinois | 17083 | 6286 | 91 |
2470898 | 2470898 | 2022-05-04 | Jersey | Illinois | 17083 | 6283 | 91 |
2467642 | 2467642 | 2022-05-03 | Jersey | Illinois | 17083 | 6282 | 91 |
2464387 | 2464387 | 2022-05-02 | Jersey | Illinois | 17083 | 6277 | 91 |
2461131 | 2461131 | 2022-05-01 | Jersey | Illinois | 17083 | 6272 | 91 |
2457875 | 2457875 | 2022-04-30 | Jersey | Illinois | 17083 | 6272 | 91 |
2454619 | 2454619 | 2022-04-29 | Jersey | Illinois | 17083 | 6272 | 91 |
2451363 | 2451363 | 2022-04-28 | Jersey | Illinois | 17083 | 6270 | 91 |
2448107 | 2448107 | 2022-04-27 | Jersey | Illinois | 17083 | 6264 | 91 |
2444851 | 2444851 | 2022-04-26 | Jersey | Illinois | 17083 | 6262 | 91 |
2441595 | 2441595 | 2022-04-25 | Jersey | Illinois | 17083 | 6256 | 91 |
2438339 | 2438339 | 2022-04-24 | Jersey | Illinois | 17083 | 6251 | 91 |
2435083 | 2435083 | 2022-04-23 | Jersey | Illinois | 17083 | 6251 | 91 |
2431827 | 2431827 | 2022-04-22 | Jersey | Illinois | 17083 | 6251 | 91 |
2428571 | 2428571 | 2022-04-21 | Jersey | Illinois | 17083 | 6248 | 91 |
2425315 | 2425315 | 2022-04-20 | Jersey | Illinois | 17083 | 6243 | 91 |
2422059 | 2422059 | 2022-04-19 | Jersey | Illinois | 17083 | 6239 | 91 |
2418803 | 2418803 | 2022-04-18 | Jersey | Illinois | 17083 | 6236 | 91 |
2415547 | 2415547 | 2022-04-17 | Jersey | Illinois | 17083 | 6231 | 91 |
2412291 | 2412291 | 2022-04-16 | Jersey | Illinois | 17083 | 6231 | 91 |
2409035 | 2409035 | 2022-04-15 | Jersey | Illinois | 17083 | 6231 | 91 |
2405779 | 2405779 | 2022-04-14 | Jersey | Illinois | 17083 | 6229 | 91 |
2402524 | 2402524 | 2022-04-13 | Jersey | Illinois | 17083 | 6227 | 91 |
2399269 | 2399269 | 2022-04-12 | Jersey | Illinois | 17083 | 6226 | 91 |
2396014 | 2396014 | 2022-04-11 | Jersey | Illinois | 17083 | 6225 | 91 |
2392758 | 2392758 | 2022-04-10 | Jersey | Illinois | 17083 | 6221 | 91 |
2389502 | 2389502 | 2022-04-09 | Jersey | Illinois | 17083 | 6221 | 91 |
2386247 | 2386247 | 2022-04-08 | Jersey | Illinois | 17083 | 6221 | 91 |
2382992 | 2382992 | 2022-04-07 | Jersey | Illinois | 17083 | 6218 | 91 |
2379737 | 2379737 | 2022-04-06 | Jersey | Illinois | 17083 | 6216 | 91 |
2376483 | 2376483 | 2022-04-05 | Jersey | Illinois | 17083 | 6212 | 91 |
2165061 | 2165061 | 2022-01-30 | Fayette | Illinois | 17051 | 6682 | 91 |
2161806 | 2161806 | 2022-01-29 | Fayette | Illinois | 17051 | 6682 | 91 |
2158551 | 2158551 | 2022-01-28 | Fayette | Illinois | 17051 | 6682 | 91 |
2155297 | 2155297 | 2022-01-27 | Fayette | Illinois | 17051 | 6640 | 91 |
2152044 | 2152044 | 2022-01-26 | Fayette | Illinois | 17051 | 6599 | 91 |
2148792 | 2148792 | 2022-01-25 | Fayette | Illinois | 17051 | 6521 | 91 |
2122791 | 2122791 | 2022-01-17 | Logan | Illinois | 17107 | 7760 | 91 |
2119539 | 2119539 | 2022-01-16 | Logan | Illinois | 17107 | 7760 | 91 |
2116287 | 2116287 | 2022-01-15 | Logan | Illinois | 17107 | 7760 | 91 |
2113036 | 2113036 | 2022-01-14 | Logan | Illinois | 17107 | 7760 | 91 |
2109784 | 2109784 | 2022-01-13 | Logan | Illinois | 17107 | 7624 | 91 |
2106533 | 2106533 | 2022-01-12 | Logan | Illinois | 17107 | 7412 | 91 |
2103282 | 2103282 | 2022-01-11 | Logan | Illinois | 17107 | 7294 | 91 |
2100031 | 2100031 | 2022-01-10 | Logan | Illinois | 17107 | 7204 | 91 |
2096780 | 2096780 | 2022-01-09 | Logan | Illinois | 17107 | 6791 | 91 |
2093528 | 2093528 | 2022-01-08 | Logan | Illinois | 17107 | 6791 | 91 |
2090276 | 2090276 | 2022-01-07 | Logan | Illinois | 17107 | 6791 | 91 |
2087025 | 2087025 | 2022-01-06 | Logan | Illinois | 17107 | 6662 | 91 |
2083773 | 2083773 | 2022-01-05 | Logan | Illinois | 17107 | 6498 | 91 |
2080521 | 2080521 | 2022-01-04 | Logan | Illinois | 17107 | 6443 | 91 |
2080540 | 2080540 | 2022-01-04 | Perry | Illinois | 17145 | 5043 | 91 |
2077269 | 2077269 | 2022-01-03 | Logan | Illinois | 17107 | 6377 | 91 |
2077283 | 2077283 | 2022-01-03 | Montgomery | Illinois | 17135 | 6279 | 91 |
2077288 | 2077288 | 2022-01-03 | Perry | Illinois | 17145 | 4962 | 91 |
2074018 | 2074018 | 2022-01-02 | Logan | Illinois | 17107 | 6221 | 91 |
2074032 | 2074032 | 2022-01-02 | Montgomery | Illinois | 17135 | 6169 | 91 |
2074037 | 2074037 | 2022-01-02 | Perry | Illinois | 17145 | 4871 | 91 |
2070767 | 2070767 | 2022-01-01 | Logan | Illinois | 17107 | 6221 | 91 |
2070781 | 2070781 | 2022-01-01 | Montgomery | Illinois | 17135 | 6169 | 91 |
2070786 | 2070786 | 2022-01-01 | Perry | Illinois | 17145 | 4871 | 91 |
2067516 | 2067516 | 2021-12-31 | Logan | Illinois | 17107 | 6221 | 91 |
2067530 | 2067530 | 2021-12-31 | Montgomery | Illinois | 17135 | 6169 | 91 |
2067535 | 2067535 | 2021-12-31 | Perry | Illinois | 17145 | 4871 | 91 |
2064265 | 2064265 | 2021-12-30 | Logan | Illinois | 17107 | 6221 | 91 |
2064279 | 2064279 | 2021-12-30 | Montgomery | Illinois | 17135 | 6169 | 91 |
2064284 | 2064284 | 2021-12-30 | Perry | Illinois | 17145 | 4871 | 91 |
2061029 | 2061029 | 2021-12-29 | Montgomery | Illinois | 17135 | 6096 | 91 |
2057780 | 2057780 | 2021-12-28 | Montgomery | Illinois | 17135 | 6044 | 91 |
2054531 | 2054531 | 2021-12-27 | Montgomery | Illinois | 17135 | 5984 | 91 |
2051251 | 2051251 | 2021-12-26 | Iroquois | Illinois | 17075 | 5231 | 91 |
2051281 | 2051281 | 2021-12-26 | Montgomery | Illinois | 17135 | 5908 | 91 |
2048001 | 2048001 | 2021-12-25 | Iroquois | Illinois | 17075 | 5231 | 91 |
2048031 | 2048031 | 2021-12-25 | Montgomery | Illinois | 17135 | 5908 | 91 |
2044751 | 2044751 | 2021-12-24 | Iroquois | Illinois | 17075 | 5231 | 91 |
2044781 | 2044781 | 2021-12-24 | Montgomery | Illinois | 17135 | 5908 | 91 |
2041502 | 2041502 | 2021-12-23 | Iroquois | Illinois | 17075 | 5231 | 91 |
2041532 | 2041532 | 2021-12-23 | Montgomery | Illinois | 17135 | 5908 | 91 |
2038282 | 2038282 | 2021-12-22 | Montgomery | Illinois | 17135 | 5868 | 91 |
2035032 | 2035032 | 2021-12-21 | Montgomery | Illinois | 17135 | 5843 | 91 |
2031782 | 2031782 | 2021-12-20 | Montgomery | Illinois | 17135 | 5809 | 91 |
2028531 | 2028531 | 2021-12-19 | Montgomery | Illinois | 17135 | 5758 | 91 |
2025280 | 2025280 | 2021-12-18 | Montgomery | Illinois | 17135 | 5758 | 91 |
2022029 | 2022029 | 2021-12-17 | Montgomery | Illinois | 17135 | 5758 | 91 |
2018778 | 2018778 | 2021-12-16 | Montgomery | Illinois | 17135 | 5739 | 91 |
2015528 | 2015528 | 2021-12-15 | Montgomery | Illinois | 17135 | 5702 | 91 |
2012277 | 2012277 | 2021-12-14 | Montgomery | Illinois | 17135 | 5675 | 91 |
2009026 | 2009026 | 2021-12-13 | Montgomery | Illinois | 17135 | 5639 | 91 |
2005775 | 2005775 | 2021-12-12 | Montgomery | Illinois | 17135 | 5591 | 91 |
2002524 | 2002524 | 2021-12-11 | Montgomery | Illinois | 17135 | 5591 | 91 |
1999274 | 1999274 | 2021-12-10 | Montgomery | Illinois | 17135 | 5591 | 91 |
1996023 | 1996023 | 2021-12-09 | Montgomery | Illinois | 17135 | 5555 | 91 |
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);