ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
419 rows where deaths = 48 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314639 | 2314639 | 2022-03-17 | Carroll | Illinois | 17015 | 4233 | 48 |
2311386 | 2311386 | 2022-03-16 | Carroll | Illinois | 17015 | 4230 | 48 |
2308133 | 2308133 | 2022-03-15 | Carroll | Illinois | 17015 | 4229 | 48 |
2304882 | 2304882 | 2022-03-14 | Carroll | Illinois | 17015 | 4228 | 48 |
2301630 | 2301630 | 2022-03-13 | Carroll | Illinois | 17015 | 4227 | 48 |
2298378 | 2298378 | 2022-03-12 | Carroll | Illinois | 17015 | 4227 | 48 |
2295126 | 2295126 | 2022-03-11 | Carroll | Illinois | 17015 | 4227 | 48 |
2291874 | 2291874 | 2022-03-10 | Carroll | Illinois | 17015 | 4225 | 48 |
2288622 | 2288622 | 2022-03-09 | Carroll | Illinois | 17015 | 4225 | 48 |
2285371 | 2285371 | 2022-03-08 | Carroll | Illinois | 17015 | 4221 | 48 |
2282119 | 2282119 | 2022-03-07 | Carroll | Illinois | 17015 | 4220 | 48 |
2278866 | 2278866 | 2022-03-06 | Carroll | Illinois | 17015 | 4206 | 48 |
2275613 | 2275613 | 2022-03-05 | Carroll | Illinois | 17015 | 4206 | 48 |
2272360 | 2272360 | 2022-03-04 | Carroll | Illinois | 17015 | 4206 | 48 |
2269108 | 2269108 | 2022-03-03 | Carroll | Illinois | 17015 | 4204 | 48 |
2265855 | 2265855 | 2022-03-02 | Carroll | Illinois | 17015 | 4199 | 48 |
2262604 | 2262604 | 2022-03-01 | Carroll | Illinois | 17015 | 4200 | 48 |
2178067 | 2178067 | 2022-02-03 | Cumberland | Illinois | 17035 | 3245 | 48 |
2174814 | 2174814 | 2022-02-02 | Cumberland | Illinois | 17035 | 3245 | 48 |
2171561 | 2171561 | 2022-02-01 | Cumberland | Illinois | 17035 | 3220 | 48 |
2168308 | 2168308 | 2022-01-31 | Cumberland | Illinois | 17035 | 3191 | 48 |
2168388 | 2168388 | 2022-01-31 | White | Illinois | 17193 | 4128 | 48 |
2142329 | 2142329 | 2022-01-23 | Moultrie | Illinois | 17139 | 3652 | 48 |
2139074 | 2139074 | 2022-01-22 | Moultrie | Illinois | 17139 | 3652 | 48 |
2135818 | 2135818 | 2022-01-21 | Moultrie | Illinois | 17139 | 3652 | 48 |
2132566 | 2132566 | 2022-01-20 | Moultrie | Illinois | 17139 | 3606 | 48 |
2129294 | 2129294 | 2022-01-19 | Lawrence | Illinois | 17101 | 4547 | 48 |
2129313 | 2129313 | 2022-01-19 | Moultrie | Illinois | 17139 | 3566 | 48 |
2126040 | 2126040 | 2022-01-18 | Lawrence | Illinois | 17101 | 4475 | 48 |
2126059 | 2126059 | 2022-01-18 | Moultrie | Illinois | 17139 | 3519 | 48 |
2122788 | 2122788 | 2022-01-17 | Lawrence | Illinois | 17101 | 4334 | 48 |
2122807 | 2122807 | 2022-01-17 | Moultrie | Illinois | 17139 | 3410 | 48 |
2119536 | 2119536 | 2022-01-16 | Lawrence | Illinois | 17101 | 4334 | 48 |
2119555 | 2119555 | 2022-01-16 | Moultrie | Illinois | 17139 | 3410 | 48 |
2116284 | 2116284 | 2022-01-15 | Lawrence | Illinois | 17101 | 4334 | 48 |
2116303 | 2116303 | 2022-01-15 | Moultrie | Illinois | 17139 | 3410 | 48 |
2113033 | 2113033 | 2022-01-14 | Lawrence | Illinois | 17101 | 4334 | 48 |
2113052 | 2113052 | 2022-01-14 | Moultrie | Illinois | 17139 | 3410 | 48 |
2109781 | 2109781 | 2022-01-13 | Lawrence | Illinois | 17101 | 4275 | 48 |
2109800 | 2109800 | 2022-01-13 | Moultrie | Illinois | 17139 | 3367 | 48 |
2106530 | 2106530 | 2022-01-12 | Lawrence | Illinois | 17101 | 4226 | 48 |
2100011 | 2100011 | 2022-01-10 | Hancock | Illinois | 17067 | 3504 | 48 |
2096747 | 2096747 | 2022-01-09 | Douglas | Illinois | 17041 | 4538 | 48 |
2096760 | 2096760 | 2022-01-09 | Hancock | Illinois | 17067 | 3459 | 48 |
2093495 | 2093495 | 2022-01-08 | Douglas | Illinois | 17041 | 4538 | 48 |
2093508 | 2093508 | 2022-01-08 | Hancock | Illinois | 17067 | 3459 | 48 |
2090243 | 2090243 | 2022-01-07 | Douglas | Illinois | 17041 | 4538 | 48 |
2090256 | 2090256 | 2022-01-07 | Hancock | Illinois | 17067 | 3459 | 48 |
2086992 | 2086992 | 2022-01-06 | Douglas | Illinois | 17041 | 4470 | 48 |
2038231 | 2038231 | 2021-12-22 | Crawford | Illinois | 17033 | 3790 | 48 |
2034981 | 2034981 | 2021-12-21 | Crawford | Illinois | 17033 | 3762 | 48 |
2031731 | 2031731 | 2021-12-20 | Crawford | Illinois | 17033 | 3740 | 48 |
2028480 | 2028480 | 2021-12-19 | Crawford | Illinois | 17033 | 3714 | 48 |
2025229 | 2025229 | 2021-12-18 | Crawford | Illinois | 17033 | 3714 | 48 |
2021978 | 2021978 | 2021-12-17 | Crawford | Illinois | 17033 | 3714 | 48 |
1869214 | 1869214 | 2021-10-31 | Clark | Illinois | 17023 | 2697 | 48 |
1865965 | 1865965 | 2021-10-30 | Clark | Illinois | 17023 | 2697 | 48 |
1862716 | 1862716 | 2021-10-29 | Clark | Illinois | 17023 | 2697 | 48 |
1859467 | 1859467 | 2021-10-28 | Clark | Illinois | 17023 | 2692 | 48 |
1856218 | 1856218 | 2021-10-27 | Clark | Illinois | 17023 | 2687 | 48 |
1852969 | 1852969 | 2021-10-26 | Clark | Illinois | 17023 | 2680 | 48 |
1849720 | 1849720 | 2021-10-25 | Clark | Illinois | 17023 | 2672 | 48 |
1846470 | 1846470 | 2021-10-24 | Clark | Illinois | 17023 | 2669 | 48 |
1843220 | 1843220 | 2021-10-23 | Clark | Illinois | 17023 | 2669 | 48 |
1839970 | 1839970 | 2021-10-22 | Clark | Illinois | 17023 | 2669 | 48 |
1836721 | 1836721 | 2021-10-21 | Clark | Illinois | 17023 | 2665 | 48 |
1833472 | 1833472 | 2021-10-20 | Clark | Illinois | 17023 | 2657 | 48 |
1830223 | 1830223 | 2021-10-19 | Clark | Illinois | 17023 | 2653 | 48 |
1826974 | 1826974 | 2021-10-18 | Clark | Illinois | 17023 | 2652 | 48 |
1810804 | 1810804 | 2021-10-13 | Shelby | Illinois | 17173 | 3396 | 48 |
1807555 | 1807555 | 2021-10-12 | Shelby | Illinois | 17173 | 3375 | 48 |
1804304 | 1804304 | 2021-10-11 | Shelby | Illinois | 17173 | 3341 | 48 |
1801055 | 1801055 | 2021-10-10 | Shelby | Illinois | 17173 | 3341 | 48 |
1797806 | 1797806 | 2021-10-09 | Shelby | Illinois | 17173 | 3341 | 48 |
1794557 | 1794557 | 2021-10-08 | Shelby | Illinois | 17173 | 3341 | 48 |
1791309 | 1791309 | 2021-10-07 | Shelby | Illinois | 17173 | 3330 | 48 |
1784786 | 1784786 | 2021-10-05 | Massac | Illinois | 17127 | 2083 | 48 |
1781537 | 1781537 | 2021-10-04 | Massac | Illinois | 17127 | 2071 | 48 |
1778287 | 1778287 | 2021-10-03 | Massac | Illinois | 17127 | 2052 | 48 |
1775037 | 1775037 | 2021-10-02 | Massac | Illinois | 17127 | 2052 | 48 |
1771787 | 1771787 | 2021-10-01 | Massac | Illinois | 17127 | 2052 | 48 |
1768538 | 1768538 | 2021-09-30 | Massac | Illinois | 17127 | 2043 | 48 |
1765289 | 1765289 | 2021-09-29 | Massac | Illinois | 17127 | 2035 | 48 |
1710091 | 1710091 | 2021-09-12 | Union | Illinois | 17181 | 2892 | 48 |
1706844 | 1706844 | 2021-09-11 | Union | Illinois | 17181 | 2892 | 48 |
1703596 | 1703596 | 2021-09-10 | Union | Illinois | 17181 | 2892 | 48 |
1700346 | 1700346 | 2021-09-09 | Union | Illinois | 17181 | 2887 | 48 |
1697097 | 1697097 | 2021-09-08 | Union | Illinois | 17181 | 2871 | 48 |
1664533 | 1664533 | 2021-08-29 | Clay | Illinois | 17025 | 1938 | 48 |
1664551 | 1664551 | 2021-08-29 | Greene | Illinois | 17061 | 1799 | 48 |
1661285 | 1661285 | 2021-08-28 | Clay | Illinois | 17025 | 1938 | 48 |
1661303 | 1661303 | 2021-08-28 | Greene | Illinois | 17061 | 1799 | 48 |
1658037 | 1658037 | 2021-08-27 | Clay | Illinois | 17025 | 1938 | 48 |
1658055 | 1658055 | 2021-08-27 | Greene | Illinois | 17061 | 1799 | 48 |
1654789 | 1654789 | 2021-08-26 | Clay | Illinois | 17025 | 1921 | 48 |
1654807 | 1654807 | 2021-08-26 | Greene | Illinois | 17061 | 1775 | 48 |
1651542 | 1651542 | 2021-08-25 | Clay | Illinois | 17025 | 1909 | 48 |
1651560 | 1651560 | 2021-08-25 | Greene | Illinois | 17061 | 1757 | 48 |
1648293 | 1648293 | 2021-08-24 | Clay | Illinois | 17025 | 1866 | 48 |
1648311 | 1648311 | 2021-08-24 | Greene | Illinois | 17061 | 1746 | 48 |
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);