ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
280 rows where deaths = 57 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Fayette 44
- Massac 31
- Shelby 23
- Pike 21
- Greene 20
- LaSalle 14
- Edgar 12
- Hancock 12
- Mason 8
- Wayne 7
- Clark 6
- Crawford 6
- Warren 6
- Jefferson 5
- McDonough 5
- Adams 4
- Coles 4
- Champaign 3
- Christian 3
- Fulton 3
- Kane 3
- Livingston 3
- Macoupin 3
- Sangamon 3
- Stephenson 3
- Tazewell 3
- Williamson 3
- Douglas 2
- Effingham 2
- Kendall 2
- …
state 1
- Illinois · 280 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2334182 | 2334182 | 2022-03-23 | Greene | Illinois | 17061 | 3589 | 57 |
2330928 | 2330928 | 2022-03-22 | Greene | Illinois | 17061 | 3588 | 57 |
2330931 | 2330931 | 2022-03-22 | Hancock | Illinois | 17067 | 4367 | 57 |
2327676 | 2327676 | 2022-03-21 | Greene | Illinois | 17061 | 3588 | 57 |
2327679 | 2327679 | 2022-03-21 | Hancock | Illinois | 17067 | 4364 | 57 |
2324423 | 2324423 | 2022-03-20 | Greene | Illinois | 17061 | 3586 | 57 |
2324426 | 2324426 | 2022-03-20 | Hancock | Illinois | 17067 | 4364 | 57 |
2321169 | 2321169 | 2022-03-19 | Greene | Illinois | 17061 | 3586 | 57 |
2321172 | 2321172 | 2022-03-19 | Hancock | Illinois | 17067 | 4364 | 57 |
2317915 | 2317915 | 2022-03-18 | Greene | Illinois | 17061 | 3586 | 57 |
2317918 | 2317918 | 2022-03-18 | Hancock | Illinois | 17067 | 4364 | 57 |
2314662 | 2314662 | 2022-03-17 | Greene | Illinois | 17061 | 3586 | 57 |
2314665 | 2314665 | 2022-03-17 | Hancock | Illinois | 17067 | 4364 | 57 |
2311409 | 2311409 | 2022-03-16 | Greene | Illinois | 17061 | 3584 | 57 |
2311412 | 2311412 | 2022-03-16 | Hancock | Illinois | 17067 | 4365 | 57 |
2308156 | 2308156 | 2022-03-15 | Greene | Illinois | 17061 | 3584 | 57 |
2308159 | 2308159 | 2022-03-15 | Hancock | Illinois | 17067 | 4363 | 57 |
2304905 | 2304905 | 2022-03-14 | Greene | Illinois | 17061 | 3581 | 57 |
2304908 | 2304908 | 2022-03-14 | Hancock | Illinois | 17067 | 4362 | 57 |
2301653 | 2301653 | 2022-03-13 | Greene | Illinois | 17061 | 3580 | 57 |
2301656 | 2301656 | 2022-03-13 | Hancock | Illinois | 17067 | 4361 | 57 |
2298401 | 2298401 | 2022-03-12 | Greene | Illinois | 17061 | 3580 | 57 |
2298404 | 2298404 | 2022-03-12 | Hancock | Illinois | 17067 | 4361 | 57 |
2295149 | 2295149 | 2022-03-11 | Greene | Illinois | 17061 | 3580 | 57 |
2295152 | 2295152 | 2022-03-11 | Hancock | Illinois | 17067 | 4361 | 57 |
2291897 | 2291897 | 2022-03-10 | Greene | Illinois | 17061 | 3580 | 57 |
2288645 | 2288645 | 2022-03-09 | Greene | Illinois | 17061 | 3580 | 57 |
2285394 | 2285394 | 2022-03-08 | Greene | Illinois | 17061 | 3580 | 57 |
2282142 | 2282142 | 2022-03-07 | Greene | Illinois | 17061 | 3579 | 57 |
2278889 | 2278889 | 2022-03-06 | Greene | Illinois | 17061 | 3579 | 57 |
2275636 | 2275636 | 2022-03-05 | Greene | Illinois | 17061 | 3579 | 57 |
2272383 | 2272383 | 2022-03-04 | Greene | Illinois | 17061 | 3579 | 57 |
2239856 | 2239856 | 2022-02-22 | Crawford | Illinois | 17033 | 6121 | 57 |
2236600 | 2236600 | 2022-02-21 | Clark | Illinois | 17023 | 4769 | 57 |
2236605 | 2236605 | 2022-02-21 | Crawford | Illinois | 17033 | 6106 | 57 |
2233349 | 2233349 | 2022-02-20 | Clark | Illinois | 17023 | 4769 | 57 |
2233354 | 2233354 | 2022-02-20 | Crawford | Illinois | 17033 | 6106 | 57 |
2230098 | 2230098 | 2022-02-19 | Clark | Illinois | 17023 | 4769 | 57 |
2230103 | 2230103 | 2022-02-19 | Crawford | Illinois | 17033 | 6106 | 57 |
2226847 | 2226847 | 2022-02-18 | Clark | Illinois | 17023 | 4769 | 57 |
2226852 | 2226852 | 2022-02-18 | Crawford | Illinois | 17033 | 6106 | 57 |
2223596 | 2223596 | 2022-02-17 | Clark | Illinois | 17023 | 4760 | 57 |
2223601 | 2223601 | 2022-02-17 | Crawford | Illinois | 17033 | 6098 | 57 |
2220345 | 2220345 | 2022-02-16 | Clark | Illinois | 17023 | 4746 | 57 |
2217103 | 2217103 | 2022-02-15 | Douglas | Illinois | 17041 | 6384 | 57 |
2213852 | 2213852 | 2022-02-14 | Douglas | Illinois | 17041 | 6380 | 57 |
2126049 | 2126049 | 2022-01-18 | Mason | Illinois | 17125 | 3308 | 57 |
2122797 | 2122797 | 2022-01-17 | Mason | Illinois | 17125 | 3192 | 57 |
2119545 | 2119545 | 2022-01-16 | Mason | Illinois | 17125 | 3192 | 57 |
2116293 | 2116293 | 2022-01-15 | Mason | Illinois | 17125 | 3192 | 57 |
2113042 | 2113042 | 2022-01-14 | Mason | Illinois | 17125 | 3192 | 57 |
2109790 | 2109790 | 2022-01-13 | Mason | Illinois | 17125 | 3153 | 57 |
2106539 | 2106539 | 2022-01-12 | Mason | Illinois | 17125 | 3083 | 57 |
2103288 | 2103288 | 2022-01-11 | Mason | Illinois | 17125 | 3029 | 57 |
2080558 | 2080558 | 2022-01-04 | Union | Illinois | 17181 | 3727 | 57 |
2077306 | 2077306 | 2022-01-03 | Union | Illinois | 17181 | 3689 | 57 |
2061047 | 2061047 | 2021-12-29 | Shelby | Illinois | 17173 | 4388 | 57 |
2057798 | 2057798 | 2021-12-28 | Shelby | Illinois | 17173 | 4371 | 57 |
2054549 | 2054549 | 2021-12-27 | Shelby | Illinois | 17173 | 4352 | 57 |
2051299 | 2051299 | 2021-12-26 | Shelby | Illinois | 17173 | 4314 | 57 |
2048049 | 2048049 | 2021-12-25 | Shelby | Illinois | 17173 | 4314 | 57 |
2044799 | 2044799 | 2021-12-24 | Shelby | Illinois | 17173 | 4314 | 57 |
2041550 | 2041550 | 2021-12-23 | Shelby | Illinois | 17173 | 4314 | 57 |
2038300 | 2038300 | 2021-12-22 | Shelby | Illinois | 17173 | 4294 | 57 |
2035050 | 2035050 | 2021-12-21 | Shelby | Illinois | 17173 | 4269 | 57 |
2031800 | 2031800 | 2021-12-20 | Shelby | Illinois | 17173 | 4249 | 57 |
2028549 | 2028549 | 2021-12-19 | Shelby | Illinois | 17173 | 4193 | 57 |
2025298 | 2025298 | 2021-12-18 | Shelby | Illinois | 17173 | 4193 | 57 |
2022047 | 2022047 | 2021-12-17 | Shelby | Illinois | 17173 | 4193 | 57 |
2018796 | 2018796 | 2021-12-16 | Shelby | Illinois | 17173 | 4171 | 57 |
2015546 | 2015546 | 2021-12-15 | Shelby | Illinois | 17173 | 4141 | 57 |
2012295 | 2012295 | 2021-12-14 | Shelby | Illinois | 17173 | 4121 | 57 |
2009044 | 2009044 | 2021-12-13 | Shelby | Illinois | 17173 | 4109 | 57 |
2005793 | 2005793 | 2021-12-12 | Shelby | Illinois | 17173 | 4068 | 57 |
2002542 | 2002542 | 2021-12-11 | Shelby | Illinois | 17173 | 4068 | 57 |
1999292 | 1999292 | 2021-12-10 | Shelby | Illinois | 17173 | 4068 | 57 |
1996016 | 1996016 | 2021-12-09 | Massac | Illinois | 17127 | 2413 | 57 |
1996041 | 1996041 | 2021-12-09 | Shelby | Illinois | 17173 | 4059 | 57 |
1992765 | 1992765 | 2021-12-08 | Massac | Illinois | 17127 | 2392 | 57 |
1992790 | 1992790 | 2021-12-08 | Shelby | Illinois | 17173 | 4039 | 57 |
1989514 | 1989514 | 2021-12-07 | Massac | Illinois | 17127 | 2385 | 57 |
1989539 | 1989539 | 2021-12-07 | Shelby | Illinois | 17173 | 4006 | 57 |
1986264 | 1986264 | 2021-12-06 | Massac | Illinois | 17127 | 2365 | 57 |
1983014 | 1983014 | 2021-12-05 | Massac | Illinois | 17127 | 2349 | 57 |
1979764 | 1979764 | 2021-12-04 | Massac | Illinois | 17127 | 2349 | 57 |
1976514 | 1976514 | 2021-12-03 | Massac | Illinois | 17127 | 2349 | 57 |
1973265 | 1973265 | 2021-12-02 | Massac | Illinois | 17127 | 2337 | 57 |
1970015 | 1970015 | 2021-12-01 | Massac | Illinois | 17127 | 2325 | 57 |
1966765 | 1966765 | 2021-11-30 | Massac | Illinois | 17127 | 2317 | 57 |
1963513 | 1963513 | 2021-11-29 | Massac | Illinois | 17127 | 2303 | 57 |
1960262 | 1960262 | 2021-11-28 | Massac | Illinois | 17127 | 2287 | 57 |
1957011 | 1957011 | 2021-11-27 | Massac | Illinois | 17127 | 2287 | 57 |
1953760 | 1953760 | 2021-11-26 | Massac | Illinois | 17127 | 2287 | 57 |
1950509 | 1950509 | 2021-11-25 | Massac | Illinois | 17127 | 2287 | 57 |
1947258 | 1947258 | 2021-11-24 | Massac | Illinois | 17127 | 2287 | 57 |
1944007 | 1944007 | 2021-11-23 | Massac | Illinois | 17127 | 2282 | 57 |
1940757 | 1940757 | 2021-11-22 | Massac | Illinois | 17127 | 2278 | 57 |
1937507 | 1937507 | 2021-11-21 | Massac | Illinois | 17127 | 2277 | 57 |
1934257 | 1934257 | 2021-11-20 | Massac | Illinois | 17127 | 2277 | 57 |
1931006 | 1931006 | 2021-11-19 | Massac | Illinois | 17127 | 2277 | 57 |
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);