ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
573 rows where deaths = 18 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Hamilton 131
- Gallatin 44
- Hardin 35
- Brown 31
- Johnson 30
- Menard 28
- Montgomery 23
- Pulaski 18
- LaSalle 17
- DeKalb 14
- Wabash 14
- Morgan 12
- Richland 10
- Union 10
- Clark 9
- Edwards 9
- De Witt 8
- Boone 7
- Jackson 7
- McLean 7
- Piatt 7
- Saline 7
- Whiteside 7
- Grundy 6
- Woodford 6
- Champaign 5
- Iroquois 4
- Marshall 4
- Rock Island 4
- Stephenson 4
- …
state 1
- Illinois · 573 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500206 | 2500206 | 2022-05-13 | Gallatin | Illinois | 17059 | 1415 | 18 |
2496948 | 2496948 | 2022-05-12 | Gallatin | Illinois | 17059 | 1415 | 18 |
2493690 | 2493690 | 2022-05-11 | Gallatin | Illinois | 17059 | 1414 | 18 |
2490432 | 2490432 | 2022-05-10 | Gallatin | Illinois | 17059 | 1412 | 18 |
2487175 | 2487175 | 2022-05-09 | Gallatin | Illinois | 17059 | 1411 | 18 |
2483917 | 2483917 | 2022-05-08 | Gallatin | Illinois | 17059 | 1410 | 18 |
2480659 | 2480659 | 2022-05-07 | Gallatin | Illinois | 17059 | 1410 | 18 |
2477401 | 2477401 | 2022-05-06 | Gallatin | Illinois | 17059 | 1410 | 18 |
2474143 | 2474143 | 2022-05-05 | Gallatin | Illinois | 17059 | 1410 | 18 |
2470886 | 2470886 | 2022-05-04 | Gallatin | Illinois | 17059 | 1410 | 18 |
2467630 | 2467630 | 2022-05-03 | Gallatin | Illinois | 17059 | 1408 | 18 |
2464375 | 2464375 | 2022-05-02 | Gallatin | Illinois | 17059 | 1408 | 18 |
2461119 | 2461119 | 2022-05-01 | Gallatin | Illinois | 17059 | 1408 | 18 |
2457863 | 2457863 | 2022-04-30 | Gallatin | Illinois | 17059 | 1408 | 18 |
2454607 | 2454607 | 2022-04-29 | Gallatin | Illinois | 17059 | 1408 | 18 |
2451351 | 2451351 | 2022-04-28 | Gallatin | Illinois | 17059 | 1407 | 18 |
2448095 | 2448095 | 2022-04-27 | Gallatin | Illinois | 17059 | 1407 | 18 |
2444839 | 2444839 | 2022-04-26 | Gallatin | Illinois | 17059 | 1407 | 18 |
2441583 | 2441583 | 2022-04-25 | Gallatin | Illinois | 17059 | 1407 | 18 |
2438327 | 2438327 | 2022-04-24 | Gallatin | Illinois | 17059 | 1407 | 18 |
2435071 | 2435071 | 2022-04-23 | Gallatin | Illinois | 17059 | 1407 | 18 |
2431815 | 2431815 | 2022-04-22 | Gallatin | Illinois | 17059 | 1407 | 18 |
2428559 | 2428559 | 2022-04-21 | Gallatin | Illinois | 17059 | 1407 | 18 |
2425303 | 2425303 | 2022-04-20 | Gallatin | Illinois | 17059 | 1407 | 18 |
2422047 | 2422047 | 2022-04-19 | Gallatin | Illinois | 17059 | 1407 | 18 |
2418791 | 2418791 | 2022-04-18 | Gallatin | Illinois | 17059 | 1408 | 18 |
2415535 | 2415535 | 2022-04-17 | Gallatin | Illinois | 17059 | 1408 | 18 |
2412279 | 2412279 | 2022-04-16 | Gallatin | Illinois | 17059 | 1408 | 18 |
2409023 | 2409023 | 2022-04-15 | Gallatin | Illinois | 17059 | 1408 | 18 |
2405767 | 2405767 | 2022-04-14 | Gallatin | Illinois | 17059 | 1407 | 18 |
2402512 | 2402512 | 2022-04-13 | Gallatin | Illinois | 17059 | 1407 | 18 |
2399257 | 2399257 | 2022-04-12 | Gallatin | Illinois | 17059 | 1406 | 18 |
2396002 | 2396002 | 2022-04-11 | Gallatin | Illinois | 17059 | 1406 | 18 |
2392746 | 2392746 | 2022-04-10 | Gallatin | Illinois | 17059 | 1407 | 18 |
2389490 | 2389490 | 2022-04-09 | Gallatin | Illinois | 17059 | 1407 | 18 |
2386235 | 2386235 | 2022-04-08 | Gallatin | Illinois | 17059 | 1407 | 18 |
2382980 | 2382980 | 2022-04-07 | Gallatin | Illinois | 17059 | 1407 | 18 |
2379725 | 2379725 | 2022-04-06 | Gallatin | Illinois | 17059 | 1407 | 18 |
2376471 | 2376471 | 2022-04-05 | Gallatin | Illinois | 17059 | 1406 | 18 |
2373219 | 2373219 | 2022-04-04 | Gallatin | Illinois | 17059 | 1406 | 18 |
2369966 | 2369966 | 2022-04-03 | Gallatin | Illinois | 17059 | 1406 | 18 |
2366713 | 2366713 | 2022-04-02 | Gallatin | Illinois | 17059 | 1406 | 18 |
2363460 | 2363460 | 2022-04-01 | Gallatin | Illinois | 17059 | 1406 | 18 |
2360206 | 2360206 | 2022-03-31 | Gallatin | Illinois | 17059 | 1406 | 18 |
2314708 | 2314708 | 2022-03-17 | Pulaski | Illinois | 17153 | 1718 | 18 |
2311455 | 2311455 | 2022-03-16 | Pulaski | Illinois | 17153 | 1718 | 18 |
2308202 | 2308202 | 2022-03-15 | Pulaski | Illinois | 17153 | 1718 | 18 |
2304951 | 2304951 | 2022-03-14 | Pulaski | Illinois | 17153 | 1718 | 18 |
2301699 | 2301699 | 2022-03-13 | Pulaski | Illinois | 17153 | 1718 | 18 |
2298447 | 2298447 | 2022-03-12 | Pulaski | Illinois | 17153 | 1718 | 18 |
2295195 | 2295195 | 2022-03-11 | Pulaski | Illinois | 17153 | 1718 | 18 |
2291943 | 2291943 | 2022-03-10 | Pulaski | Illinois | 17153 | 1717 | 18 |
2288691 | 2288691 | 2022-03-09 | Pulaski | Illinois | 17153 | 1717 | 18 |
2285440 | 2285440 | 2022-03-08 | Pulaski | Illinois | 17153 | 1717 | 18 |
2282188 | 2282188 | 2022-03-07 | Pulaski | Illinois | 17153 | 1716 | 18 |
2278935 | 2278935 | 2022-03-06 | Pulaski | Illinois | 17153 | 1715 | 18 |
2275682 | 2275682 | 2022-03-05 | Pulaski | Illinois | 17153 | 1715 | 18 |
2272429 | 2272429 | 2022-03-04 | Pulaski | Illinois | 17153 | 1715 | 18 |
2269177 | 2269177 | 2022-03-03 | Pulaski | Illinois | 17153 | 1714 | 18 |
2265924 | 2265924 | 2022-03-02 | Pulaski | Illinois | 17153 | 1713 | 18 |
2262673 | 2262673 | 2022-03-01 | Pulaski | Illinois | 17153 | 1713 | 18 |
2259422 | 2259422 | 2022-02-28 | Pulaski | Illinois | 17153 | 1712 | 18 |
2217117 | 2217117 | 2022-02-15 | Hardin | Illinois | 17069 | 1036 | 18 |
2213866 | 2213866 | 2022-02-14 | Hardin | Illinois | 17069 | 1034 | 18 |
2210614 | 2210614 | 2022-02-13 | Hardin | Illinois | 17069 | 1031 | 18 |
2207361 | 2207361 | 2022-02-12 | Hardin | Illinois | 17069 | 1031 | 18 |
2204108 | 2204108 | 2022-02-11 | Hardin | Illinois | 17069 | 1031 | 18 |
2200855 | 2200855 | 2022-02-10 | Hardin | Illinois | 17069 | 1031 | 18 |
2197601 | 2197601 | 2022-02-09 | Hardin | Illinois | 17069 | 1024 | 18 |
2194347 | 2194347 | 2022-02-08 | Hardin | Illinois | 17069 | 1019 | 18 |
2191093 | 2191093 | 2022-02-07 | Hardin | Illinois | 17069 | 1018 | 18 |
2187840 | 2187840 | 2022-02-06 | Hardin | Illinois | 17069 | 1017 | 18 |
2184587 | 2184587 | 2022-02-05 | Hardin | Illinois | 17069 | 1017 | 18 |
2181335 | 2181335 | 2022-02-04 | Hardin | Illinois | 17069 | 1017 | 18 |
2178084 | 2178084 | 2022-02-03 | Hardin | Illinois | 17069 | 1012 | 18 |
2174831 | 2174831 | 2022-02-02 | Hardin | Illinois | 17069 | 1012 | 18 |
2171578 | 2171578 | 2022-02-01 | Hardin | Illinois | 17069 | 1007 | 18 |
2168325 | 2168325 | 2022-01-31 | Hardin | Illinois | 17069 | 1002 | 18 |
2165070 | 2165070 | 2022-01-30 | Hardin | Illinois | 17069 | 981 | 18 |
2161815 | 2161815 | 2022-01-29 | Hardin | Illinois | 17069 | 981 | 18 |
2158560 | 2158560 | 2022-01-28 | Hardin | Illinois | 17069 | 981 | 18 |
2155306 | 2155306 | 2022-01-27 | Hardin | Illinois | 17069 | 967 | 18 |
2152053 | 2152053 | 2022-01-26 | Hardin | Illinois | 17069 | 958 | 18 |
2148801 | 2148801 | 2022-01-25 | Hardin | Illinois | 17069 | 942 | 18 |
2145549 | 2145549 | 2022-01-24 | Hardin | Illinois | 17069 | 928 | 18 |
2142294 | 2142294 | 2022-01-23 | Hardin | Illinois | 17069 | 900 | 18 |
2139039 | 2139039 | 2022-01-22 | Hardin | Illinois | 17069 | 900 | 18 |
2135783 | 2135783 | 2022-01-21 | Hardin | Illinois | 17069 | 900 | 18 |
2132531 | 2132531 | 2022-01-20 | Hardin | Illinois | 17069 | 893 | 18 |
2129278 | 2129278 | 2022-01-19 | Hardin | Illinois | 17069 | 891 | 18 |
2126024 | 2126024 | 2022-01-18 | Hardin | Illinois | 17069 | 876 | 18 |
2122772 | 2122772 | 2022-01-17 | Hardin | Illinois | 17069 | 853 | 18 |
2119520 | 2119520 | 2022-01-16 | Hardin | Illinois | 17069 | 853 | 18 |
2116268 | 2116268 | 2022-01-15 | Hardin | Illinois | 17069 | 853 | 18 |
2113017 | 2113017 | 2022-01-14 | Hardin | Illinois | 17069 | 853 | 18 |
2109765 | 2109765 | 2022-01-13 | Hardin | Illinois | 17069 | 844 | 18 |
2106514 | 2106514 | 2022-01-12 | Hardin | Illinois | 17069 | 835 | 18 |
2018715 | 2018715 | 2021-12-16 | Brown | Illinois | 17009 | 1175 | 18 |
2015465 | 2015465 | 2021-12-15 | Brown | Illinois | 17009 | 1171 | 18 |
2012214 | 2012214 | 2021-12-14 | Brown | Illinois | 17009 | 1170 | 18 |
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);