ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
380 rows where deaths = 28 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Henderson 31
- Edwards 28
- Moultrie 25
- Rock Island 25
- Jasper 23
- Stark 23
- Hamilton 15
- Champaign 14
- Massac 12
- Marshall 10
- Piatt 9
- Schuyler 9
- Union 9
- Peoria 8
- Sangamon 7
- Carroll 6
- Coles 6
- Fayette 6
- Kendall 6
- Macon 6
- Warren 6
- Jo Daviess 5
- Kankakee 5
- Monroe 5
- Randolph 5
- Douglas 4
- Hancock 4
- Jersey 4
- Johnson 4
- McDonough 4
- …
state 1
- Illinois · 380 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500212 | 2500212 | 2022-05-13 | Henderson | Illinois | 17071 | 1166 | 28 |
2496954 | 2496954 | 2022-05-12 | Henderson | Illinois | 17071 | 1165 | 28 |
2493696 | 2493696 | 2022-05-11 | Henderson | Illinois | 17071 | 1163 | 28 |
2490438 | 2490438 | 2022-05-10 | Henderson | Illinois | 17071 | 1160 | 28 |
2487181 | 2487181 | 2022-05-09 | Henderson | Illinois | 17071 | 1158 | 28 |
2483923 | 2483923 | 2022-05-08 | Henderson | Illinois | 17071 | 1156 | 28 |
2480665 | 2480665 | 2022-05-07 | Henderson | Illinois | 17071 | 1156 | 28 |
2477407 | 2477407 | 2022-05-06 | Henderson | Illinois | 17071 | 1156 | 28 |
2474149 | 2474149 | 2022-05-05 | Henderson | Illinois | 17071 | 1156 | 28 |
2470892 | 2470892 | 2022-05-04 | Henderson | Illinois | 17071 | 1154 | 28 |
2467636 | 2467636 | 2022-05-03 | Henderson | Illinois | 17071 | 1153 | 28 |
2464381 | 2464381 | 2022-05-02 | Henderson | Illinois | 17071 | 1153 | 28 |
2461125 | 2461125 | 2022-05-01 | Henderson | Illinois | 17071 | 1153 | 28 |
2457869 | 2457869 | 2022-04-30 | Henderson | Illinois | 17071 | 1153 | 28 |
2454613 | 2454613 | 2022-04-29 | Henderson | Illinois | 17071 | 1153 | 28 |
2451357 | 2451357 | 2022-04-28 | Henderson | Illinois | 17071 | 1153 | 28 |
2448101 | 2448101 | 2022-04-27 | Henderson | Illinois | 17071 | 1153 | 28 |
2444845 | 2444845 | 2022-04-26 | Henderson | Illinois | 17071 | 1154 | 28 |
2441589 | 2441589 | 2022-04-25 | Henderson | Illinois | 17071 | 1153 | 28 |
2438333 | 2438333 | 2022-04-24 | Henderson | Illinois | 17071 | 1153 | 28 |
2435077 | 2435077 | 2022-04-23 | Henderson | Illinois | 17071 | 1153 | 28 |
2431821 | 2431821 | 2022-04-22 | Henderson | Illinois | 17071 | 1153 | 28 |
2428565 | 2428565 | 2022-04-21 | Henderson | Illinois | 17071 | 1152 | 28 |
2425309 | 2425309 | 2022-04-20 | Henderson | Illinois | 17071 | 1151 | 28 |
2422053 | 2422053 | 2022-04-19 | Henderson | Illinois | 17071 | 1148 | 28 |
2418797 | 2418797 | 2022-04-18 | Henderson | Illinois | 17071 | 1148 | 28 |
2415541 | 2415541 | 2022-04-17 | Henderson | Illinois | 17071 | 1148 | 28 |
2412285 | 2412285 | 2022-04-16 | Henderson | Illinois | 17071 | 1148 | 28 |
2409029 | 2409029 | 2022-04-15 | Henderson | Illinois | 17071 | 1148 | 28 |
2405773 | 2405773 | 2022-04-14 | Henderson | Illinois | 17071 | 1148 | 28 |
2402518 | 2402518 | 2022-04-13 | Henderson | Illinois | 17071 | 1148 | 28 |
2311418 | 2311418 | 2022-03-16 | Jasper | Illinois | 17079 | 2670 | 28 |
2308165 | 2308165 | 2022-03-15 | Jasper | Illinois | 17079 | 2670 | 28 |
2304914 | 2304914 | 2022-03-14 | Jasper | Illinois | 17079 | 2670 | 28 |
2301646 | 2301646 | 2022-03-13 | Edwards | Illinois | 17047 | 1750 | 28 |
2301662 | 2301662 | 2022-03-13 | Jasper | Illinois | 17079 | 2670 | 28 |
2298394 | 2298394 | 2022-03-12 | Edwards | Illinois | 17047 | 1750 | 28 |
2298410 | 2298410 | 2022-03-12 | Jasper | Illinois | 17079 | 2670 | 28 |
2295142 | 2295142 | 2022-03-11 | Edwards | Illinois | 17047 | 1750 | 28 |
2295158 | 2295158 | 2022-03-11 | Jasper | Illinois | 17079 | 2670 | 28 |
2291890 | 2291890 | 2022-03-10 | Edwards | Illinois | 17047 | 1749 | 28 |
2291906 | 2291906 | 2022-03-10 | Jasper | Illinois | 17079 | 2670 | 28 |
2288638 | 2288638 | 2022-03-09 | Edwards | Illinois | 17047 | 1748 | 28 |
2288654 | 2288654 | 2022-03-09 | Jasper | Illinois | 17079 | 2670 | 28 |
2285387 | 2285387 | 2022-03-08 | Edwards | Illinois | 17047 | 1748 | 28 |
2285403 | 2285403 | 2022-03-08 | Jasper | Illinois | 17079 | 2668 | 28 |
2285437 | 2285437 | 2022-03-08 | Piatt | Illinois | 17147 | 4358 | 28 |
2282135 | 2282135 | 2022-03-07 | Edwards | Illinois | 17047 | 1748 | 28 |
2282151 | 2282151 | 2022-03-07 | Jasper | Illinois | 17079 | 2668 | 28 |
2282185 | 2282185 | 2022-03-07 | Piatt | Illinois | 17147 | 4356 | 28 |
2278882 | 2278882 | 2022-03-06 | Edwards | Illinois | 17047 | 1745 | 28 |
2278898 | 2278898 | 2022-03-06 | Jasper | Illinois | 17079 | 2668 | 28 |
2278932 | 2278932 | 2022-03-06 | Piatt | Illinois | 17147 | 4352 | 28 |
2275629 | 2275629 | 2022-03-05 | Edwards | Illinois | 17047 | 1745 | 28 |
2275645 | 2275645 | 2022-03-05 | Jasper | Illinois | 17079 | 2668 | 28 |
2275679 | 2275679 | 2022-03-05 | Piatt | Illinois | 17147 | 4352 | 28 |
2272376 | 2272376 | 2022-03-04 | Edwards | Illinois | 17047 | 1745 | 28 |
2272392 | 2272392 | 2022-03-04 | Jasper | Illinois | 17079 | 2668 | 28 |
2272426 | 2272426 | 2022-03-04 | Piatt | Illinois | 17147 | 4352 | 28 |
2269124 | 2269124 | 2022-03-03 | Edwards | Illinois | 17047 | 1761 | 28 |
2269140 | 2269140 | 2022-03-03 | Jasper | Illinois | 17079 | 2668 | 28 |
2269174 | 2269174 | 2022-03-03 | Piatt | Illinois | 17147 | 4347 | 28 |
2265871 | 2265871 | 2022-03-02 | Edwards | Illinois | 17047 | 1763 | 28 |
2265887 | 2265887 | 2022-03-02 | Jasper | Illinois | 17079 | 2667 | 28 |
2265921 | 2265921 | 2022-03-02 | Piatt | Illinois | 17147 | 4343 | 28 |
2262620 | 2262620 | 2022-03-01 | Edwards | Illinois | 17047 | 1763 | 28 |
2262636 | 2262636 | 2022-03-01 | Jasper | Illinois | 17079 | 2667 | 28 |
2262670 | 2262670 | 2022-03-01 | Piatt | Illinois | 17147 | 4343 | 28 |
2259369 | 2259369 | 2022-02-28 | Edwards | Illinois | 17047 | 1763 | 28 |
2259385 | 2259385 | 2022-02-28 | Jasper | Illinois | 17079 | 2666 | 28 |
2259419 | 2259419 | 2022-02-28 | Piatt | Illinois | 17147 | 4339 | 28 |
2256118 | 2256118 | 2022-02-27 | Edwards | Illinois | 17047 | 1764 | 28 |
2256134 | 2256134 | 2022-02-27 | Jasper | Illinois | 17079 | 2665 | 28 |
2252867 | 2252867 | 2022-02-26 | Edwards | Illinois | 17047 | 1764 | 28 |
2252883 | 2252883 | 2022-02-26 | Jasper | Illinois | 17079 | 2665 | 28 |
2249616 | 2249616 | 2022-02-25 | Edwards | Illinois | 17047 | 1764 | 28 |
2249632 | 2249632 | 2022-02-25 | Jasper | Illinois | 17079 | 2665 | 28 |
2246365 | 2246365 | 2022-02-24 | Edwards | Illinois | 17047 | 1774 | 28 |
2246381 | 2246381 | 2022-02-24 | Jasper | Illinois | 17079 | 2663 | 28 |
2243114 | 2243114 | 2022-02-23 | Edwards | Illinois | 17047 | 1776 | 28 |
2243130 | 2243130 | 2022-02-23 | Jasper | Illinois | 17079 | 2661 | 28 |
2239863 | 2239863 | 2022-02-22 | Edwards | Illinois | 17047 | 1775 | 28 |
2239879 | 2239879 | 2022-02-22 | Jasper | Illinois | 17079 | 2660 | 28 |
2239933 | 2239933 | 2022-02-22 | Wabash | Illinois | 17185 | 3747 | 28 |
2236612 | 2236612 | 2022-02-21 | Edwards | Illinois | 17047 | 1767 | 28 |
2233361 | 2233361 | 2022-02-20 | Edwards | Illinois | 17047 | 1767 | 28 |
2230110 | 2230110 | 2022-02-19 | Edwards | Illinois | 17047 | 1767 | 28 |
2226859 | 2226859 | 2022-02-18 | Edwards | Illinois | 17047 | 1767 | 28 |
2223608 | 2223608 | 2022-02-17 | Edwards | Illinois | 17047 | 1767 | 28 |
2220357 | 2220357 | 2022-02-16 | Edwards | Illinois | 17047 | 1765 | 28 |
2217106 | 2217106 | 2022-02-15 | Edwards | Illinois | 17047 | 1763 | 28 |
2213855 | 2213855 | 2022-02-14 | Edwards | Illinois | 17047 | 1762 | 28 |
2178133 | 2178133 | 2022-02-03 | Schuyler | Illinois | 17169 | 1905 | 28 |
2174880 | 2174880 | 2022-02-02 | Schuyler | Illinois | 17169 | 1905 | 28 |
2171627 | 2171627 | 2022-02-01 | Schuyler | Illinois | 17169 | 1911 | 28 |
2168374 | 2168374 | 2022-01-31 | Schuyler | Illinois | 17169 | 1895 | 28 |
2165119 | 2165119 | 2022-01-30 | Schuyler | Illinois | 17169 | 1875 | 28 |
2161864 | 2161864 | 2022-01-29 | Schuyler | Illinois | 17169 | 1875 | 28 |
2158609 | 2158609 | 2022-01-28 | Schuyler | Illinois | 17169 | 1875 | 28 |
2155355 | 2155355 | 2022-01-27 | Schuyler | Illinois | 17169 | 1862 | 28 |
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);