ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
212 rows where deaths = 117 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 30
county 30
- Morgan 52
- Clinton 25
- Iroquois 19
- Macoupin 18
- Lee 11
- Livingston 8
- Marion 8
- McHenry 7
- DeKalb 6
- Effingham 6
- Fulton 5
- Monroe 5
- Woodford 5
- Adams 4
- Christian 4
- Jefferson 4
- Champaign 3
- Franklin 3
- Vermilion 3
- Williamson 3
- Boone 2
- Rock Island 2
- Stephenson 2
- Coles 1
- Grundy 1
- Macon 1
- Madison 1
- Peoria 1
- St. Clair 1
- Whiteside 1
state 1
- Illinois · 212 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461127 | 2461127 | 2022-05-01 | Iroquois | Illinois | 17075 | 7230 | 117 |
2457871 | 2457871 | 2022-04-30 | Iroquois | Illinois | 17075 | 7230 | 117 |
2454615 | 2454615 | 2022-04-29 | Iroquois | Illinois | 17075 | 7230 | 117 |
2451359 | 2451359 | 2022-04-28 | Iroquois | Illinois | 17075 | 7218 | 117 |
2448103 | 2448103 | 2022-04-27 | Iroquois | Illinois | 17075 | 7217 | 117 |
2444847 | 2444847 | 2022-04-26 | Iroquois | Illinois | 17075 | 7212 | 117 |
2441591 | 2441591 | 2022-04-25 | Iroquois | Illinois | 17075 | 7210 | 117 |
2438335 | 2438335 | 2022-04-24 | Iroquois | Illinois | 17075 | 7202 | 117 |
2435079 | 2435079 | 2022-04-23 | Iroquois | Illinois | 17075 | 7202 | 117 |
2431823 | 2431823 | 2022-04-22 | Iroquois | Illinois | 17075 | 7202 | 117 |
2428567 | 2428567 | 2022-04-21 | Iroquois | Illinois | 17075 | 7198 | 117 |
2425311 | 2425311 | 2022-04-20 | Iroquois | Illinois | 17075 | 7197 | 117 |
2422055 | 2422055 | 2022-04-19 | Iroquois | Illinois | 17075 | 7194 | 117 |
2418799 | 2418799 | 2022-04-18 | Iroquois | Illinois | 17075 | 7195 | 117 |
2415543 | 2415543 | 2022-04-17 | Iroquois | Illinois | 17075 | 7192 | 117 |
2412287 | 2412287 | 2022-04-16 | Iroquois | Illinois | 17075 | 7192 | 117 |
2409031 | 2409031 | 2022-04-15 | Iroquois | Illinois | 17075 | 7192 | 117 |
2405775 | 2405775 | 2022-04-14 | Iroquois | Illinois | 17075 | 7191 | 117 |
2402520 | 2402520 | 2022-04-13 | Iroquois | Illinois | 17075 | 7186 | 117 |
2308177 | 2308177 | 2022-03-15 | Lee | Illinois | 17103 | 8729 | 117 |
2304926 | 2304926 | 2022-03-14 | Lee | Illinois | 17103 | 8728 | 117 |
2301674 | 2301674 | 2022-03-13 | Lee | Illinois | 17103 | 8723 | 117 |
2298422 | 2298422 | 2022-03-12 | Lee | Illinois | 17103 | 8723 | 117 |
2295170 | 2295170 | 2022-03-11 | Lee | Illinois | 17103 | 8723 | 117 |
2291918 | 2291918 | 2022-03-10 | Lee | Illinois | 17103 | 8722 | 117 |
2288666 | 2288666 | 2022-03-09 | Lee | Illinois | 17103 | 8718 | 117 |
2285415 | 2285415 | 2022-03-08 | Lee | Illinois | 17103 | 8715 | 117 |
2282163 | 2282163 | 2022-03-07 | Lee | Illinois | 17103 | 8713 | 117 |
2217134 | 2217134 | 2022-02-15 | Lee | Illinois | 17103 | 8597 | 117 |
2213883 | 2213883 | 2022-02-14 | Lee | Illinois | 17103 | 8581 | 117 |
2197570 | 2197570 | 2022-02-09 | Boone | Illinois | 17007 | 13410 | 117 |
2194316 | 2194316 | 2022-02-08 | Boone | Illinois | 17007 | 13390 | 117 |
2168319 | 2168319 | 2022-01-31 | Fulton | Illinois | 17057 | 9488 | 117 |
2168357 | 2168357 | 2022-01-31 | Monroe | Illinois | 17133 | 9080 | 117 |
2168393 | 2168393 | 2022-01-31 | Woodford | Illinois | 17203 | 9879 | 117 |
2165064 | 2165064 | 2022-01-30 | Fulton | Illinois | 17057 | 9233 | 117 |
2165102 | 2165102 | 2022-01-30 | Monroe | Illinois | 17133 | 8989 | 117 |
2165138 | 2165138 | 2022-01-30 | Woodford | Illinois | 17203 | 9778 | 117 |
2161809 | 2161809 | 2022-01-29 | Fulton | Illinois | 17057 | 9233 | 117 |
2161847 | 2161847 | 2022-01-29 | Monroe | Illinois | 17133 | 8989 | 117 |
2161883 | 2161883 | 2022-01-29 | Woodford | Illinois | 17203 | 9778 | 117 |
2158554 | 2158554 | 2022-01-28 | Fulton | Illinois | 17057 | 9233 | 117 |
2158592 | 2158592 | 2022-01-28 | Monroe | Illinois | 17133 | 8989 | 117 |
2158628 | 2158628 | 2022-01-28 | Woodford | Illinois | 17203 | 9778 | 117 |
2155300 | 2155300 | 2022-01-27 | Fulton | Illinois | 17057 | 9197 | 117 |
2155338 | 2155338 | 2022-01-27 | Monroe | Illinois | 17133 | 8921 | 117 |
2155374 | 2155374 | 2022-01-27 | Woodford | Illinois | 17203 | 9709 | 117 |
2132510 | 2132510 | 2022-01-20 | Clinton | Illinois | 17027 | 10770 | 117 |
2129257 | 2129257 | 2022-01-19 | Clinton | Illinois | 17027 | 10639 | 117 |
2126003 | 2126003 | 2022-01-18 | Clinton | Illinois | 17027 | 10480 | 117 |
2126021 | 2126021 | 2022-01-18 | Grundy | Illinois | 17063 | 11532 | 117 |
2122748 | 2122748 | 2022-01-17 | Christian | Illinois | 17021 | 8182 | 117 |
2122751 | 2122751 | 2022-01-17 | Clinton | Illinois | 17027 | 10171 | 117 |
2119496 | 2119496 | 2022-01-16 | Christian | Illinois | 17021 | 8182 | 117 |
2119499 | 2119499 | 2022-01-16 | Clinton | Illinois | 17027 | 10171 | 117 |
2116244 | 2116244 | 2022-01-15 | Christian | Illinois | 17021 | 8182 | 117 |
2116247 | 2116247 | 2022-01-15 | Clinton | Illinois | 17027 | 10171 | 117 |
2112993 | 2112993 | 2022-01-14 | Christian | Illinois | 17021 | 8182 | 117 |
2112996 | 2112996 | 2022-01-14 | Clinton | Illinois | 17027 | 10171 | 117 |
2109744 | 2109744 | 2022-01-13 | Clinton | Illinois | 17027 | 10035 | 117 |
2106493 | 2106493 | 2022-01-12 | Clinton | Illinois | 17027 | 9817 | 117 |
2103242 | 2103242 | 2022-01-11 | Clinton | Illinois | 17027 | 9692 | 117 |
2099991 | 2099991 | 2022-01-10 | Clinton | Illinois | 17027 | 9492 | 117 |
2096740 | 2096740 | 2022-01-09 | Clinton | Illinois | 17027 | 9146 | 117 |
2093488 | 2093488 | 2022-01-08 | Clinton | Illinois | 17027 | 9146 | 117 |
2090236 | 2090236 | 2022-01-07 | Clinton | Illinois | 17027 | 9146 | 117 |
2086985 | 2086985 | 2022-01-06 | Clinton | Illinois | 17027 | 9021 | 117 |
2083733 | 2083733 | 2022-01-05 | Clinton | Illinois | 17027 | 8840 | 117 |
2080481 | 2080481 | 2022-01-04 | Clinton | Illinois | 17027 | 8680 | 117 |
2077229 | 2077229 | 2022-01-03 | Clinton | Illinois | 17027 | 8453 | 117 |
2073978 | 2073978 | 2022-01-02 | Clinton | Illinois | 17027 | 8266 | 117 |
2070727 | 2070727 | 2022-01-01 | Clinton | Illinois | 17027 | 8266 | 117 |
2067476 | 2067476 | 2021-12-31 | Clinton | Illinois | 17027 | 8266 | 117 |
2064225 | 2064225 | 2021-12-30 | Clinton | Illinois | 17027 | 8266 | 117 |
2060975 | 2060975 | 2021-12-29 | Clinton | Illinois | 17027 | 8155 | 117 |
2057726 | 2057726 | 2021-12-28 | Clinton | Illinois | 17027 | 8115 | 117 |
2054477 | 2054477 | 2021-12-27 | Clinton | Illinois | 17027 | 8048 | 117 |
1986256 | 1986256 | 2021-12-06 | Livingston | Illinois | 17105 | 6521 | 117 |
1983006 | 1983006 | 2021-12-05 | Livingston | Illinois | 17105 | 6421 | 117 |
1979756 | 1979756 | 2021-12-04 | Livingston | Illinois | 17105 | 6421 | 117 |
1976506 | 1976506 | 2021-12-03 | Livingston | Illinois | 17105 | 6421 | 117 |
1973257 | 1973257 | 2021-12-02 | Livingston | Illinois | 17105 | 6406 | 117 |
1970007 | 1970007 | 2021-12-01 | Livingston | Illinois | 17105 | 6348 | 117 |
1966757 | 1966757 | 2021-11-30 | Livingston | Illinois | 17105 | 6325 | 117 |
1963505 | 1963505 | 2021-11-29 | Livingston | Illinois | 17105 | 6303 | 117 |
1960226 | 1960226 | 2021-11-28 | Effingham | Illinois | 17049 | 7073 | 117 |
1956975 | 1956975 | 2021-11-27 | Effingham | Illinois | 17049 | 7073 | 117 |
1953724 | 1953724 | 2021-11-26 | Effingham | Illinois | 17049 | 7073 | 117 |
1950473 | 1950473 | 2021-11-25 | Effingham | Illinois | 17049 | 7073 | 117 |
1947222 | 1947222 | 2021-11-24 | Effingham | Illinois | 17049 | 7073 | 117 |
1943971 | 1943971 | 2021-11-23 | Effingham | Illinois | 17049 | 7039 | 117 |
1905036 | 1905036 | 2021-11-11 | Stephenson | Illinois | 17177 | 6336 | 117 |
1901786 | 1901786 | 2021-11-10 | Stephenson | Illinois | 17177 | 6336 | 117 |
1788002 | 1788002 | 2021-10-06 | Franklin | Illinois | 17055 | 7155 | 117 |
1784753 | 1784753 | 2021-10-05 | Franklin | Illinois | 17055 | 7149 | 117 |
1781504 | 1781504 | 2021-10-04 | Franklin | Illinois | 17055 | 7142 | 117 |
1765243 | 1765243 | 2021-09-29 | Coles | Illinois | 17029 | 7515 | 117 |
1765297 | 1765297 | 2021-09-29 | Morgan | Illinois | 17137 | 5087 | 117 |
1762048 | 1762048 | 2021-09-28 | Morgan | Illinois | 17137 | 5081 | 117 |
1758800 | 1758800 | 2021-09-27 | Morgan | Illinois | 17137 | 5073 | 117 |
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);