ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
182 rows where deaths = 84 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370033 | 2370033 | 2022-04-03 | Wayne | Illinois | 17191 | 5286 | 84 |
2366780 | 2366780 | 2022-04-02 | Wayne | Illinois | 17191 | 5286 | 84 |
2363527 | 2363527 | 2022-04-01 | Wayne | Illinois | 17191 | 5286 | 84 |
2360273 | 2360273 | 2022-03-31 | Wayne | Illinois | 17191 | 5285 | 84 |
2357019 | 2357019 | 2022-03-30 | Wayne | Illinois | 17191 | 5285 | 84 |
2353766 | 2353766 | 2022-03-29 | Wayne | Illinois | 17191 | 5286 | 84 |
2350514 | 2350514 | 2022-03-28 | Wayne | Illinois | 17191 | 5286 | 84 |
2347261 | 2347261 | 2022-03-27 | Wayne | Illinois | 17191 | 5286 | 84 |
2344008 | 2344008 | 2022-03-26 | Wayne | Illinois | 17191 | 5286 | 84 |
2340755 | 2340755 | 2022-03-25 | Wayne | Illinois | 17191 | 5286 | 84 |
2337502 | 2337502 | 2022-03-24 | Wayne | Illinois | 17191 | 5286 | 84 |
2334248 | 2334248 | 2022-03-23 | Wayne | Illinois | 17191 | 5285 | 84 |
2330994 | 2330994 | 2022-03-22 | Wayne | Illinois | 17191 | 5285 | 84 |
2327742 | 2327742 | 2022-03-21 | Wayne | Illinois | 17191 | 5285 | 84 |
2324489 | 2324489 | 2022-03-20 | Wayne | Illinois | 17191 | 5281 | 84 |
2321235 | 2321235 | 2022-03-19 | Wayne | Illinois | 17191 | 5281 | 84 |
2317981 | 2317981 | 2022-03-18 | Wayne | Illinois | 17191 | 5281 | 84 |
2314728 | 2314728 | 2022-03-17 | Wayne | Illinois | 17191 | 5278 | 84 |
2311473 | 2311473 | 2022-03-16 | Warren | Illinois | 17187 | 3981 | 84 |
2311475 | 2311475 | 2022-03-16 | Wayne | Illinois | 17191 | 5278 | 84 |
2308220 | 2308220 | 2022-03-15 | Warren | Illinois | 17187 | 3978 | 84 |
2304969 | 2304969 | 2022-03-14 | Warren | Illinois | 17187 | 3979 | 84 |
2301717 | 2301717 | 2022-03-13 | Warren | Illinois | 17187 | 3978 | 84 |
2298465 | 2298465 | 2022-03-12 | Warren | Illinois | 17187 | 3978 | 84 |
2295213 | 2295213 | 2022-03-11 | Warren | Illinois | 17187 | 3978 | 84 |
2291961 | 2291961 | 2022-03-10 | Warren | Illinois | 17187 | 3978 | 84 |
2288709 | 2288709 | 2022-03-09 | Warren | Illinois | 17187 | 3977 | 84 |
2285458 | 2285458 | 2022-03-08 | Warren | Illinois | 17187 | 3977 | 84 |
2282206 | 2282206 | 2022-03-07 | Warren | Illinois | 17187 | 3979 | 84 |
2278953 | 2278953 | 2022-03-06 | Warren | Illinois | 17187 | 3977 | 84 |
2275700 | 2275700 | 2022-03-05 | Warren | Illinois | 17187 | 3977 | 84 |
2272447 | 2272447 | 2022-03-04 | Warren | Illinois | 17187 | 3977 | 84 |
2269195 | 2269195 | 2022-03-03 | Warren | Illinois | 17187 | 3977 | 84 |
2265942 | 2265942 | 2022-03-02 | Warren | Illinois | 17187 | 3976 | 84 |
2210621 | 2210621 | 2022-02-13 | Jersey | Illinois | 17083 | 6107 | 84 |
2207368 | 2207368 | 2022-02-12 | Jersey | Illinois | 17083 | 6107 | 84 |
2204115 | 2204115 | 2022-02-11 | Jersey | Illinois | 17083 | 6107 | 84 |
2200862 | 2200862 | 2022-02-10 | Jersey | Illinois | 17083 | 6107 | 84 |
2197608 | 2197608 | 2022-02-09 | Jersey | Illinois | 17083 | 6090 | 84 |
2194354 | 2194354 | 2022-02-08 | Jersey | Illinois | 17083 | 6082 | 84 |
2191100 | 2191100 | 2022-02-07 | Jersey | Illinois | 17083 | 6077 | 84 |
2087033 | 2087033 | 2022-01-06 | McDonough | Illinois | 17109 | 5056 | 84 |
2083781 | 2083781 | 2022-01-05 | McDonough | Illinois | 17109 | 4960 | 84 |
2080529 | 2080529 | 2022-01-04 | McDonough | Illinois | 17109 | 4903 | 84 |
2077277 | 2077277 | 2022-01-03 | McDonough | Illinois | 17109 | 4825 | 84 |
2074026 | 2074026 | 2022-01-02 | McDonough | Illinois | 17109 | 4742 | 84 |
2070775 | 2070775 | 2022-01-01 | McDonough | Illinois | 17109 | 4742 | 84 |
2067524 | 2067524 | 2021-12-31 | McDonough | Illinois | 17109 | 4742 | 84 |
2064273 | 2064273 | 2021-12-30 | McDonough | Illinois | 17109 | 4742 | 84 |
2061023 | 2061023 | 2021-12-29 | McDonough | Illinois | 17109 | 4660 | 84 |
1960239 | 1960239 | 2021-11-28 | Iroquois | Illinois | 17075 | 4544 | 84 |
1956988 | 1956988 | 2021-11-27 | Iroquois | Illinois | 17075 | 4544 | 84 |
1953737 | 1953737 | 2021-11-26 | Iroquois | Illinois | 17075 | 4544 | 84 |
1950486 | 1950486 | 2021-11-25 | Iroquois | Illinois | 17075 | 4544 | 84 |
1947235 | 1947235 | 2021-11-24 | Iroquois | Illinois | 17075 | 4544 | 84 |
1943984 | 1943984 | 2021-11-23 | Iroquois | Illinois | 17075 | 4530 | 84 |
1940734 | 1940734 | 2021-11-22 | Iroquois | Illinois | 17075 | 4510 | 84 |
1859528 | 1859528 | 2021-10-28 | Perry | Illinois | 17145 | 4370 | 84 |
1856279 | 1856279 | 2021-10-27 | Perry | Illinois | 17145 | 4365 | 84 |
1853030 | 1853030 | 2021-10-26 | Perry | Illinois | 17145 | 4359 | 84 |
1849781 | 1849781 | 2021-10-25 | Perry | Illinois | 17145 | 4350 | 84 |
1846531 | 1846531 | 2021-10-24 | Perry | Illinois | 17145 | 4339 | 84 |
1843281 | 1843281 | 2021-10-23 | Perry | Illinois | 17145 | 4339 | 84 |
1840031 | 1840031 | 2021-10-22 | Perry | Illinois | 17145 | 4339 | 84 |
1836738 | 1836738 | 2021-10-21 | Fulton | Illinois | 17057 | 5273 | 84 |
1836782 | 1836782 | 2021-10-21 | Perry | Illinois | 17145 | 4337 | 84 |
1833489 | 1833489 | 2021-10-20 | Fulton | Illinois | 17057 | 5269 | 84 |
1833533 | 1833533 | 2021-10-20 | Perry | Illinois | 17145 | 4332 | 84 |
1830240 | 1830240 | 2021-10-19 | Fulton | Illinois | 17057 | 5259 | 84 |
1830284 | 1830284 | 2021-10-19 | Perry | Illinois | 17145 | 4329 | 84 |
1827035 | 1827035 | 2021-10-18 | Perry | Illinois | 17145 | 4323 | 84 |
1823786 | 1823786 | 2021-10-17 | Perry | Illinois | 17145 | 4303 | 84 |
1820537 | 1820537 | 2021-10-16 | Perry | Illinois | 17145 | 4303 | 84 |
1817288 | 1817288 | 2021-10-15 | Perry | Illinois | 17145 | 4303 | 84 |
1804286 | 1804286 | 2021-10-11 | Montgomery | Illinois | 17135 | 4813 | 84 |
1801037 | 1801037 | 2021-10-10 | Montgomery | Illinois | 17135 | 4813 | 84 |
1797788 | 1797788 | 2021-10-09 | Montgomery | Illinois | 17135 | 4813 | 84 |
1794539 | 1794539 | 2021-10-08 | Montgomery | Illinois | 17135 | 4813 | 84 |
1791291 | 1791291 | 2021-10-07 | Montgomery | Illinois | 17135 | 4808 | 84 |
1788042 | 1788042 | 2021-10-06 | Montgomery | Illinois | 17135 | 4805 | 84 |
1788056 | 1788056 | 2021-10-06 | Saline | Illinois | 17165 | 4260 | 84 |
1784793 | 1784793 | 2021-10-05 | Montgomery | Illinois | 17135 | 4798 | 84 |
1784807 | 1784807 | 2021-10-05 | Saline | Illinois | 17165 | 4251 | 84 |
1781558 | 1781558 | 2021-10-04 | Saline | Illinois | 17165 | 4244 | 84 |
1778308 | 1778308 | 2021-10-03 | Saline | Illinois | 17165 | 4223 | 84 |
1775058 | 1775058 | 2021-10-02 | Saline | Illinois | 17165 | 4223 | 84 |
1771808 | 1771808 | 2021-10-01 | Saline | Illinois | 17165 | 4223 | 84 |
1768559 | 1768559 | 2021-09-30 | Saline | Illinois | 17165 | 4207 | 84 |
1765310 | 1765310 | 2021-09-29 | Saline | Illinois | 17165 | 4190 | 84 |
1700287 | 1700287 | 2021-09-09 | Grundy | Illinois | 17063 | 6788 | 84 |
1697038 | 1697038 | 2021-09-08 | Grundy | Illinois | 17063 | 6755 | 84 |
1693790 | 1693790 | 2021-09-07 | Grundy | Illinois | 17063 | 6732 | 84 |
1690541 | 1690541 | 2021-09-06 | Grundy | Illinois | 17063 | 6663 | 84 |
1687291 | 1687291 | 2021-09-05 | Grundy | Illinois | 17063 | 6663 | 84 |
1684041 | 1684041 | 2021-09-04 | Grundy | Illinois | 17063 | 6663 | 84 |
1680790 | 1680790 | 2021-09-03 | Grundy | Illinois | 17063 | 6663 | 84 |
1677542 | 1677542 | 2021-09-02 | Grundy | Illinois | 17063 | 6623 | 84 |
1677549 | 1677549 | 2021-09-02 | Jackson | Illinois | 17077 | 6930 | 84 |
1674295 | 1674295 | 2021-09-01 | Grundy | Illinois | 17063 | 6614 | 84 |
1674302 | 1674302 | 2021-09-01 | Jackson | Illinois | 17077 | 6871 | 84 |
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);