ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
890 rows where deaths = 20 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Piatt 293
- Jasper 152
- Hardin 53
- Johnson 42
- Champaign 41
- Edwards 40
- Stark 30
- Marshall 28
- Jackson 18
- Whiteside 17
- Schuyler 14
- Clinton 13
- Iroquois 12
- Clark 8
- Coles 8
- DeKalb 8
- Brown 7
- Hamilton 7
- Warren 7
- Jefferson 5
- Kendall 5
- McDonough 5
- Bond 4
- Clay 4
- Greene 4
- Jersey 4
- Jo Daviess 4
- Mercer 4
- Montgomery 4
- Boone 3
- …
state 1
- Illinois · 890 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500211 | 2500211 | 2022-05-13 | Hardin | Illinois | 17069 | 1059 | 20 |
2496953 | 2496953 | 2022-05-12 | Hardin | Illinois | 17069 | 1059 | 20 |
2493695 | 2493695 | 2022-05-11 | Hardin | Illinois | 17069 | 1059 | 20 |
2490437 | 2490437 | 2022-05-10 | Hardin | Illinois | 17069 | 1059 | 20 |
2487180 | 2487180 | 2022-05-09 | Hardin | Illinois | 17069 | 1057 | 20 |
2483922 | 2483922 | 2022-05-08 | Hardin | Illinois | 17069 | 1055 | 20 |
2480664 | 2480664 | 2022-05-07 | Hardin | Illinois | 17069 | 1055 | 20 |
2477406 | 2477406 | 2022-05-06 | Hardin | Illinois | 17069 | 1055 | 20 |
2474148 | 2474148 | 2022-05-05 | Hardin | Illinois | 17069 | 1054 | 20 |
2470891 | 2470891 | 2022-05-04 | Hardin | Illinois | 17069 | 1055 | 20 |
2467635 | 2467635 | 2022-05-03 | Hardin | Illinois | 17069 | 1054 | 20 |
2464380 | 2464380 | 2022-05-02 | Hardin | Illinois | 17069 | 1054 | 20 |
2461124 | 2461124 | 2022-05-01 | Hardin | Illinois | 17069 | 1054 | 20 |
2457868 | 2457868 | 2022-04-30 | Hardin | Illinois | 17069 | 1054 | 20 |
2454612 | 2454612 | 2022-04-29 | Hardin | Illinois | 17069 | 1054 | 20 |
2451356 | 2451356 | 2022-04-28 | Hardin | Illinois | 17069 | 1054 | 20 |
2448100 | 2448100 | 2022-04-27 | Hardin | Illinois | 17069 | 1054 | 20 |
2444844 | 2444844 | 2022-04-26 | Hardin | Illinois | 17069 | 1054 | 20 |
2441588 | 2441588 | 2022-04-25 | Hardin | Illinois | 17069 | 1054 | 20 |
2438332 | 2438332 | 2022-04-24 | Hardin | Illinois | 17069 | 1054 | 20 |
2435076 | 2435076 | 2022-04-23 | Hardin | Illinois | 17069 | 1054 | 20 |
2431820 | 2431820 | 2022-04-22 | Hardin | Illinois | 17069 | 1054 | 20 |
2428564 | 2428564 | 2022-04-21 | Hardin | Illinois | 17069 | 1054 | 20 |
2425308 | 2425308 | 2022-04-20 | Hardin | Illinois | 17069 | 1054 | 20 |
2422052 | 2422052 | 2022-04-19 | Hardin | Illinois | 17069 | 1054 | 20 |
2418796 | 2418796 | 2022-04-18 | Hardin | Illinois | 17069 | 1054 | 20 |
2415540 | 2415540 | 2022-04-17 | Hardin | Illinois | 17069 | 1054 | 20 |
2412284 | 2412284 | 2022-04-16 | Hardin | Illinois | 17069 | 1054 | 20 |
2409028 | 2409028 | 2022-04-15 | Hardin | Illinois | 17069 | 1054 | 20 |
2405772 | 2405772 | 2022-04-14 | Hardin | Illinois | 17069 | 1054 | 20 |
2402517 | 2402517 | 2022-04-13 | Hardin | Illinois | 17069 | 1054 | 20 |
2399262 | 2399262 | 2022-04-12 | Hardin | Illinois | 17069 | 1053 | 20 |
2396007 | 2396007 | 2022-04-11 | Hardin | Illinois | 17069 | 1053 | 20 |
2392751 | 2392751 | 2022-04-10 | Hardin | Illinois | 17069 | 1053 | 20 |
2389495 | 2389495 | 2022-04-09 | Hardin | Illinois | 17069 | 1053 | 20 |
2386240 | 2386240 | 2022-04-08 | Hardin | Illinois | 17069 | 1053 | 20 |
2382985 | 2382985 | 2022-04-07 | Hardin | Illinois | 17069 | 1053 | 20 |
2379730 | 2379730 | 2022-04-06 | Hardin | Illinois | 17069 | 1053 | 20 |
2376476 | 2376476 | 2022-04-05 | Hardin | Illinois | 17069 | 1053 | 20 |
2373224 | 2373224 | 2022-04-04 | Hardin | Illinois | 17069 | 1053 | 20 |
2369971 | 2369971 | 2022-04-03 | Hardin | Illinois | 17069 | 1053 | 20 |
2366718 | 2366718 | 2022-04-02 | Hardin | Illinois | 17069 | 1053 | 20 |
2363465 | 2363465 | 2022-04-01 | Hardin | Illinois | 17069 | 1053 | 20 |
2360211 | 2360211 | 2022-03-31 | Hardin | Illinois | 17069 | 1053 | 20 |
2356957 | 2356957 | 2022-03-30 | Hardin | Illinois | 17069 | 1053 | 20 |
2353704 | 2353704 | 2022-03-29 | Hardin | Illinois | 17069 | 1052 | 20 |
2350452 | 2350452 | 2022-03-28 | Hardin | Illinois | 17069 | 1052 | 20 |
2347199 | 2347199 | 2022-03-27 | Hardin | Illinois | 17069 | 1050 | 20 |
2343946 | 2343946 | 2022-03-26 | Hardin | Illinois | 17069 | 1050 | 20 |
2340693 | 2340693 | 2022-03-25 | Hardin | Illinois | 17069 | 1050 | 20 |
2337440 | 2337440 | 2022-03-24 | Hardin | Illinois | 17069 | 1050 | 20 |
2334186 | 2334186 | 2022-03-23 | Hardin | Illinois | 17069 | 1049 | 20 |
2330932 | 2330932 | 2022-03-22 | Hardin | Illinois | 17069 | 1049 | 20 |
2220338 | 2220338 | 2022-02-16 | Brown | Illinois | 17009 | 2359 | 20 |
2217087 | 2217087 | 2022-02-15 | Brown | Illinois | 17009 | 2359 | 20 |
2213836 | 2213836 | 2022-02-14 | Brown | Illinois | 17009 | 2355 | 20 |
2210584 | 2210584 | 2022-02-13 | Brown | Illinois | 17009 | 2343 | 20 |
2207331 | 2207331 | 2022-02-12 | Brown | Illinois | 17009 | 2343 | 20 |
2204078 | 2204078 | 2022-02-11 | Brown | Illinois | 17009 | 2343 | 20 |
2200825 | 2200825 | 2022-02-10 | Brown | Illinois | 17009 | 2343 | 20 |
2005731 | 2005731 | 2021-12-12 | Edwards | Illinois | 17047 | 1188 | 20 |
2002480 | 2002480 | 2021-12-11 | Edwards | Illinois | 17047 | 1188 | 20 |
1999230 | 1999230 | 2021-12-10 | Edwards | Illinois | 17047 | 1188 | 20 |
1995979 | 1995979 | 2021-12-09 | Edwards | Illinois | 17047 | 1183 | 20 |
1992728 | 1992728 | 2021-12-08 | Edwards | Illinois | 17047 | 1178 | 20 |
1992778 | 1992778 | 2021-12-08 | Piatt | Illinois | 17147 | 2493 | 20 |
1989477 | 1989477 | 2021-12-07 | Edwards | Illinois | 17047 | 1171 | 20 |
1989527 | 1989527 | 2021-12-07 | Piatt | Illinois | 17147 | 2464 | 20 |
1986227 | 1986227 | 2021-12-06 | Edwards | Illinois | 17047 | 1167 | 20 |
1986277 | 1986277 | 2021-12-06 | Piatt | Illinois | 17147 | 2439 | 20 |
1982977 | 1982977 | 2021-12-05 | Edwards | Illinois | 17047 | 1156 | 20 |
1983027 | 1983027 | 2021-12-05 | Piatt | Illinois | 17147 | 2394 | 20 |
1979727 | 1979727 | 2021-12-04 | Edwards | Illinois | 17047 | 1156 | 20 |
1979777 | 1979777 | 2021-12-04 | Piatt | Illinois | 17147 | 2394 | 20 |
1976477 | 1976477 | 2021-12-03 | Edwards | Illinois | 17047 | 1156 | 20 |
1976527 | 1976527 | 2021-12-03 | Piatt | Illinois | 17147 | 2394 | 20 |
1973228 | 1973228 | 2021-12-02 | Edwards | Illinois | 17047 | 1151 | 20 |
1973278 | 1973278 | 2021-12-02 | Piatt | Illinois | 17147 | 2367 | 20 |
1969978 | 1969978 | 2021-12-01 | Edwards | Illinois | 17047 | 1141 | 20 |
1970028 | 1970028 | 2021-12-01 | Piatt | Illinois | 17147 | 2342 | 20 |
1966728 | 1966728 | 2021-11-30 | Edwards | Illinois | 17047 | 1138 | 20 |
1966778 | 1966778 | 2021-11-30 | Piatt | Illinois | 17147 | 2321 | 20 |
1963476 | 1963476 | 2021-11-29 | Edwards | Illinois | 17047 | 1129 | 20 |
1963526 | 1963526 | 2021-11-29 | Piatt | Illinois | 17147 | 2295 | 20 |
1960225 | 1960225 | 2021-11-28 | Edwards | Illinois | 17047 | 1118 | 20 |
1960275 | 1960275 | 2021-11-28 | Piatt | Illinois | 17147 | 2250 | 20 |
1956974 | 1956974 | 2021-11-27 | Edwards | Illinois | 17047 | 1118 | 20 |
1957024 | 1957024 | 2021-11-27 | Piatt | Illinois | 17147 | 2250 | 20 |
1953723 | 1953723 | 2021-11-26 | Edwards | Illinois | 17047 | 1118 | 20 |
1953773 | 1953773 | 2021-11-26 | Piatt | Illinois | 17147 | 2250 | 20 |
1950472 | 1950472 | 2021-11-25 | Edwards | Illinois | 17047 | 1118 | 20 |
1950522 | 1950522 | 2021-11-25 | Piatt | Illinois | 17147 | 2250 | 20 |
1947221 | 1947221 | 2021-11-24 | Edwards | Illinois | 17047 | 1118 | 20 |
1947271 | 1947271 | 2021-11-24 | Piatt | Illinois | 17147 | 2250 | 20 |
1943970 | 1943970 | 2021-11-23 | Edwards | Illinois | 17047 | 1114 | 20 |
1944020 | 1944020 | 2021-11-23 | Piatt | Illinois | 17147 | 2230 | 20 |
1940720 | 1940720 | 2021-11-22 | Edwards | Illinois | 17047 | 1109 | 20 |
1940770 | 1940770 | 2021-11-22 | Piatt | Illinois | 17147 | 2211 | 20 |
1937470 | 1937470 | 2021-11-21 | Edwards | Illinois | 17047 | 1101 | 20 |
1937520 | 1937520 | 2021-11-21 | Piatt | Illinois | 17147 | 2159 | 20 |
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);