ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where deaths = 50 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2288665 | 2288665 | 2022-03-09 | Lawrence | Illinois | 17101 | 5479 | 50 |
2285414 | 2285414 | 2022-03-08 | Lawrence | Illinois | 17101 | 5478 | 50 |
2282162 | 2282162 | 2022-03-07 | Lawrence | Illinois | 17101 | 5480 | 50 |
2278909 | 2278909 | 2022-03-06 | Lawrence | Illinois | 17101 | 5475 | 50 |
2275656 | 2275656 | 2022-03-05 | Lawrence | Illinois | 17101 | 5475 | 50 |
2272403 | 2272403 | 2022-03-04 | Lawrence | Illinois | 17101 | 5475 | 50 |
2269151 | 2269151 | 2022-03-03 | Lawrence | Illinois | 17101 | 5473 | 50 |
2265898 | 2265898 | 2022-03-02 | Lawrence | Illinois | 17101 | 5472 | 50 |
2262647 | 2262647 | 2022-03-01 | Lawrence | Illinois | 17101 | 5469 | 50 |
2259396 | 2259396 | 2022-02-28 | Lawrence | Illinois | 17101 | 5469 | 50 |
2256145 | 2256145 | 2022-02-27 | Lawrence | Illinois | 17101 | 5464 | 50 |
2252894 | 2252894 | 2022-02-26 | Lawrence | Illinois | 17101 | 5464 | 50 |
2249643 | 2249643 | 2022-02-25 | Lawrence | Illinois | 17101 | 5464 | 50 |
2246392 | 2246392 | 2022-02-24 | Lawrence | Illinois | 17101 | 5465 | 50 |
2243141 | 2243141 | 2022-02-23 | Lawrence | Illinois | 17101 | 5462 | 50 |
2239890 | 2239890 | 2022-02-22 | Lawrence | Illinois | 17101 | 5457 | 50 |
2236639 | 2236639 | 2022-02-21 | Lawrence | Illinois | 17101 | 5446 | 50 |
2233388 | 2233388 | 2022-02-20 | Lawrence | Illinois | 17101 | 5446 | 50 |
2230137 | 2230137 | 2022-02-19 | Lawrence | Illinois | 17101 | 5446 | 50 |
2226886 | 2226886 | 2022-02-18 | Lawrence | Illinois | 17101 | 5446 | 50 |
2223635 | 2223635 | 2022-02-17 | Lawrence | Illinois | 17101 | 5435 | 50 |
2220384 | 2220384 | 2022-02-16 | Lawrence | Illinois | 17101 | 5431 | 50 |
2210649 | 2210649 | 2022-02-13 | Moultrie | Illinois | 17139 | 3999 | 50 |
2210677 | 2210677 | 2022-02-13 | White | Illinois | 17193 | 4272 | 50 |
2207396 | 2207396 | 2022-02-12 | Moultrie | Illinois | 17139 | 3999 | 50 |
2207424 | 2207424 | 2022-02-12 | White | Illinois | 17193 | 4272 | 50 |
2204143 | 2204143 | 2022-02-11 | Moultrie | Illinois | 17139 | 3999 | 50 |
2204171 | 2204171 | 2022-02-11 | White | Illinois | 17193 | 4272 | 50 |
2200890 | 2200890 | 2022-02-10 | Moultrie | Illinois | 17139 | 3999 | 50 |
2200918 | 2200918 | 2022-02-10 | White | Illinois | 17193 | 4272 | 50 |
2197636 | 2197636 | 2022-02-09 | Moultrie | Illinois | 17139 | 3989 | 50 |
2197664 | 2197664 | 2022-02-09 | White | Illinois | 17193 | 4264 | 50 |
2194382 | 2194382 | 2022-02-08 | Moultrie | Illinois | 17139 | 3972 | 50 |
2194410 | 2194410 | 2022-02-08 | White | Illinois | 17193 | 4241 | 50 |
2191128 | 2191128 | 2022-02-07 | Moultrie | Illinois | 17139 | 3967 | 50 |
2191156 | 2191156 | 2022-02-07 | White | Illinois | 17193 | 4230 | 50 |
2187875 | 2187875 | 2022-02-06 | Moultrie | Illinois | 17139 | 3947 | 50 |
2187903 | 2187903 | 2022-02-06 | White | Illinois | 17193 | 4217 | 50 |
2184622 | 2184622 | 2022-02-05 | Moultrie | Illinois | 17139 | 3947 | 50 |
2184650 | 2184650 | 2022-02-05 | White | Illinois | 17193 | 4217 | 50 |
2181370 | 2181370 | 2022-02-04 | Moultrie | Illinois | 17139 | 3947 | 50 |
2181398 | 2181398 | 2022-02-04 | White | Illinois | 17193 | 4217 | 50 |
2178119 | 2178119 | 2022-02-03 | Moultrie | Illinois | 17139 | 3940 | 50 |
2174866 | 2174866 | 2022-02-02 | Moultrie | Illinois | 17139 | 3940 | 50 |
2171613 | 2171613 | 2022-02-01 | Moultrie | Illinois | 17139 | 3922 | 50 |
2168360 | 2168360 | 2022-01-31 | Moultrie | Illinois | 17139 | 3905 | 50 |
2165105 | 2165105 | 2022-01-30 | Moultrie | Illinois | 17139 | 3864 | 50 |
2161850 | 2161850 | 2022-01-29 | Moultrie | Illinois | 17139 | 3864 | 50 |
2158595 | 2158595 | 2022-01-28 | Moultrie | Illinois | 17139 | 3864 | 50 |
2155341 | 2155341 | 2022-01-27 | Moultrie | Illinois | 17139 | 3835 | 50 |
2152088 | 2152088 | 2022-01-26 | Moultrie | Illinois | 17139 | 3803 | 50 |
2132517 | 2132517 | 2022-01-20 | Douglas | Illinois | 17041 | 5638 | 50 |
2129264 | 2129264 | 2022-01-19 | Douglas | Illinois | 17041 | 5511 | 50 |
2126010 | 2126010 | 2022-01-18 | Douglas | Illinois | 17041 | 5260 | 50 |
2122758 | 2122758 | 2022-01-17 | Douglas | Illinois | 17041 | 5082 | 50 |
2119506 | 2119506 | 2022-01-16 | Douglas | Illinois | 17041 | 5082 | 50 |
2116254 | 2116254 | 2022-01-15 | Douglas | Illinois | 17041 | 5082 | 50 |
2113003 | 2113003 | 2022-01-14 | Douglas | Illinois | 17041 | 5082 | 50 |
2109764 | 2109764 | 2022-01-13 | Hancock | Illinois | 17067 | 3598 | 50 |
1960213 | 1960213 | 2021-11-28 | Clark | Illinois | 17023 | 2906 | 50 |
1956962 | 1956962 | 2021-11-27 | Clark | Illinois | 17023 | 2906 | 50 |
1953711 | 1953711 | 2021-11-26 | Clark | Illinois | 17023 | 2906 | 50 |
1950460 | 1950460 | 2021-11-25 | Clark | Illinois | 17023 | 2906 | 50 |
1947209 | 1947209 | 2021-11-24 | Clark | Illinois | 17023 | 2906 | 50 |
1943958 | 1943958 | 2021-11-23 | Clark | Illinois | 17023 | 2897 | 50 |
1940708 | 1940708 | 2021-11-22 | Clark | Illinois | 17023 | 2886 | 50 |
1937458 | 1937458 | 2021-11-21 | Clark | Illinois | 17023 | 2871 | 50 |
1934208 | 1934208 | 2021-11-20 | Clark | Illinois | 17023 | 2871 | 50 |
1930957 | 1930957 | 2021-11-19 | Clark | Illinois | 17023 | 2871 | 50 |
1927706 | 1927706 | 2021-11-18 | Clark | Illinois | 17023 | 2867 | 50 |
1924456 | 1924456 | 2021-11-17 | Clark | Illinois | 17023 | 2858 | 50 |
1921207 | 1921207 | 2021-11-16 | Clark | Illinois | 17023 | 2846 | 50 |
1917957 | 1917957 | 2021-11-15 | Clark | Illinois | 17023 | 2841 | 50 |
1914707 | 1914707 | 2021-11-14 | Clark | Illinois | 17023 | 2822 | 50 |
1911457 | 1911457 | 2021-11-13 | Clark | Illinois | 17023 | 2822 | 50 |
1908208 | 1908208 | 2021-11-12 | Clark | Illinois | 17023 | 2822 | 50 |
1904959 | 1904959 | 2021-11-11 | Clark | Illinois | 17023 | 2788 | 50 |
1901709 | 1901709 | 2021-11-10 | Clark | Illinois | 17023 | 2788 | 50 |
1898459 | 1898459 | 2021-11-09 | Clark | Illinois | 17023 | 2776 | 50 |
1895209 | 1895209 | 2021-11-08 | Clark | Illinois | 17023 | 2757 | 50 |
1891959 | 1891959 | 2021-11-07 | Clark | Illinois | 17023 | 2743 | 50 |
1888709 | 1888709 | 2021-11-06 | Clark | Illinois | 17023 | 2743 | 50 |
1885459 | 1885459 | 2021-11-05 | Clark | Illinois | 17023 | 2743 | 50 |
1882210 | 1882210 | 2021-11-04 | Clark | Illinois | 17023 | 2731 | 50 |
1878961 | 1878961 | 2021-11-03 | Clark | Illinois | 17023 | 2718 | 50 |
1823799 | 1823799 | 2021-10-17 | Shelby | Illinois | 17173 | 3431 | 50 |
1820550 | 1820550 | 2021-10-16 | Shelby | Illinois | 17173 | 3431 | 50 |
1817301 | 1817301 | 2021-10-15 | Shelby | Illinois | 17173 | 3431 | 50 |
1814053 | 1814053 | 2021-10-14 | Shelby | Illinois | 17173 | 3418 | 50 |
1732830 | 1732830 | 2021-09-19 | Union | Illinois | 17181 | 2938 | 50 |
1729580 | 1729580 | 2021-09-18 | Union | Illinois | 17181 | 2938 | 50 |
1726330 | 1726330 | 2021-09-17 | Union | Illinois | 17181 | 2938 | 50 |
1716524 | 1716524 | 2021-09-14 | Greene | Illinois | 17061 | 1962 | 50 |
1713278 | 1713278 | 2021-09-13 | Greene | Illinois | 17061 | 1945 | 50 |
1710031 | 1710031 | 2021-09-12 | Greene | Illinois | 17061 | 1929 | 50 |
1710060 | 1710060 | 2021-09-12 | Mason | Illinois | 17125 | 1917 | 50 |
1706784 | 1706784 | 2021-09-11 | Greene | Illinois | 17061 | 1929 | 50 |
1706813 | 1706813 | 2021-09-11 | Mason | Illinois | 17125 | 1917 | 50 |
1703536 | 1703536 | 2021-09-10 | Greene | Illinois | 17061 | 1929 | 50 |
1703565 | 1703565 | 2021-09-10 | Mason | Illinois | 17125 | 1917 | 50 |
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);