ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17019 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947207 | 1947207 | 2021-11-24 | Champaign | Illinois | 17019 | 29225 | 212 |
1943956 | 1943956 | 2021-11-23 | Champaign | Illinois | 17019 | 29129 | 212 |
1940706 | 1940706 | 2021-11-22 | Champaign | Illinois | 17019 | 29033 | 211 |
1937456 | 1937456 | 2021-11-21 | Champaign | Illinois | 17019 | 28789 | 211 |
1934206 | 1934206 | 2021-11-20 | Champaign | Illinois | 17019 | 28789 | 211 |
1930955 | 1930955 | 2021-11-19 | Champaign | Illinois | 17019 | 28789 | 211 |
1927704 | 1927704 | 2021-11-18 | Champaign | Illinois | 17019 | 28669 | 211 |
1924454 | 1924454 | 2021-11-17 | Champaign | Illinois | 17019 | 28539 | 211 |
1921205 | 1921205 | 2021-11-16 | Champaign | Illinois | 17019 | 28453 | 211 |
1917955 | 1917955 | 2021-11-15 | Champaign | Illinois | 17019 | 28383 | 211 |
1914705 | 1914705 | 2021-11-14 | Champaign | Illinois | 17019 | 28184 | 209 |
1911455 | 1911455 | 2021-11-13 | Champaign | Illinois | 17019 | 28184 | 209 |
1908206 | 1908206 | 2021-11-12 | Champaign | Illinois | 17019 | 28184 | 209 |
1904957 | 1904957 | 2021-11-11 | Champaign | Illinois | 17019 | 28002 | 208 |
1901707 | 1901707 | 2021-11-10 | Champaign | Illinois | 17019 | 28002 | 208 |
1898457 | 1898457 | 2021-11-09 | Champaign | Illinois | 17019 | 27909 | 208 |
1895207 | 1895207 | 2021-11-08 | Champaign | Illinois | 17019 | 27829 | 207 |
1891957 | 1891957 | 2021-11-07 | Champaign | Illinois | 17019 | 27680 | 207 |
1888707 | 1888707 | 2021-11-06 | Champaign | Illinois | 17019 | 27680 | 207 |
1885457 | 1885457 | 2021-11-05 | Champaign | Illinois | 17019 | 27680 | 207 |
1882208 | 1882208 | 2021-11-04 | Champaign | Illinois | 17019 | 27606 | 206 |
1878959 | 1878959 | 2021-11-03 | Champaign | Illinois | 17019 | 27508 | 206 |
1875710 | 1875710 | 2021-11-02 | Champaign | Illinois | 17019 | 27453 | 206 |
1872461 | 1872461 | 2021-11-01 | Champaign | Illinois | 17019 | 27407 | 206 |
1869212 | 1869212 | 2021-10-31 | Champaign | Illinois | 17019 | 27318 | 206 |
1865963 | 1865963 | 2021-10-30 | Champaign | Illinois | 17019 | 27318 | 206 |
1862714 | 1862714 | 2021-10-29 | Champaign | Illinois | 17019 | 27318 | 206 |
1859465 | 1859465 | 2021-10-28 | Champaign | Illinois | 17019 | 27262 | 206 |
1856216 | 1856216 | 2021-10-27 | Champaign | Illinois | 17019 | 27218 | 206 |
1852967 | 1852967 | 2021-10-26 | Champaign | Illinois | 17019 | 27178 | 206 |
1849718 | 1849718 | 2021-10-25 | Champaign | Illinois | 17019 | 27150 | 205 |
1846468 | 1846468 | 2021-10-24 | Champaign | Illinois | 17019 | 27087 | 205 |
1843218 | 1843218 | 2021-10-23 | Champaign | Illinois | 17019 | 27087 | 205 |
1839968 | 1839968 | 2021-10-22 | Champaign | Illinois | 17019 | 27087 | 205 |
1836719 | 1836719 | 2021-10-21 | Champaign | Illinois | 17019 | 27034 | 205 |
1833470 | 1833470 | 2021-10-20 | Champaign | Illinois | 17019 | 26998 | 205 |
1830221 | 1830221 | 2021-10-19 | Champaign | Illinois | 17019 | 26960 | 205 |
1826972 | 1826972 | 2021-10-18 | Champaign | Illinois | 17019 | 26931 | 204 |
1823723 | 1823723 | 2021-10-17 | Champaign | Illinois | 17019 | 26859 | 204 |
1820474 | 1820474 | 2021-10-16 | Champaign | Illinois | 17019 | 26859 | 204 |
1817225 | 1817225 | 2021-10-15 | Champaign | Illinois | 17019 | 26859 | 204 |
1813977 | 1813977 | 2021-10-14 | Champaign | Illinois | 17019 | 26817 | 203 |
1810728 | 1810728 | 2021-10-13 | Champaign | Illinois | 17019 | 26786 | 203 |
1807479 | 1807479 | 2021-10-12 | Champaign | Illinois | 17019 | 26734 | 201 |
1804228 | 1804228 | 2021-10-11 | Champaign | Illinois | 17019 | 26580 | 200 |
1800979 | 1800979 | 2021-10-10 | Champaign | Illinois | 17019 | 26580 | 200 |
1797730 | 1797730 | 2021-10-09 | Champaign | Illinois | 17019 | 26580 | 200 |
1794481 | 1794481 | 2021-10-08 | Champaign | Illinois | 17019 | 26580 | 200 |
1791233 | 1791233 | 2021-10-07 | Champaign | Illinois | 17019 | 26537 | 197 |
1787984 | 1787984 | 2021-10-06 | Champaign | Illinois | 17019 | 26497 | 197 |
1784735 | 1784735 | 2021-10-05 | Champaign | Illinois | 17019 | 26460 | 197 |
1781486 | 1781486 | 2021-10-04 | Champaign | Illinois | 17019 | 26382 | 197 |
1778236 | 1778236 | 2021-10-03 | Champaign | Illinois | 17019 | 26288 | 196 |
1774986 | 1774986 | 2021-10-02 | Champaign | Illinois | 17019 | 26288 | 196 |
1771736 | 1771736 | 2021-10-01 | Champaign | Illinois | 17019 | 26288 | 196 |
1768487 | 1768487 | 2021-09-30 | Champaign | Illinois | 17019 | 26246 | 196 |
1765238 | 1765238 | 2021-09-29 | Champaign | Illinois | 17019 | 26189 | 195 |
1761989 | 1761989 | 2021-09-28 | Champaign | Illinois | 17019 | 26130 | 195 |
1758741 | 1758741 | 2021-09-27 | Champaign | Illinois | 17019 | 26090 | 194 |
1755493 | 1755493 | 2021-09-26 | Champaign | Illinois | 17019 | 25967 | 192 |
1752245 | 1752245 | 2021-09-25 | Champaign | Illinois | 17019 | 25967 | 192 |
1748996 | 1748996 | 2021-09-24 | Champaign | Illinois | 17019 | 25967 | 192 |
1745746 | 1745746 | 2021-09-23 | Champaign | Illinois | 17019 | 25923 | 191 |
1742497 | 1742497 | 2021-09-22 | Champaign | Illinois | 17019 | 25862 | 190 |
1739248 | 1739248 | 2021-09-21 | Champaign | Illinois | 17019 | 25788 | 190 |
1735999 | 1735999 | 2021-09-20 | Champaign | Illinois | 17019 | 25754 | 190 |
1732749 | 1732749 | 2021-09-19 | Champaign | Illinois | 17019 | 25601 | 190 |
1729499 | 1729499 | 2021-09-18 | Champaign | Illinois | 17019 | 25601 | 190 |
1726249 | 1726249 | 2021-09-17 | Champaign | Illinois | 17019 | 25601 | 190 |
1723000 | 1723000 | 2021-09-16 | Champaign | Illinois | 17019 | 25553 | 190 |
1719751 | 1719751 | 2021-09-15 | Champaign | Illinois | 17019 | 25478 | 190 |
1716503 | 1716503 | 2021-09-14 | Champaign | Illinois | 17019 | 25413 | 188 |
1713257 | 1713257 | 2021-09-13 | Champaign | Illinois | 17019 | 25337 | 187 |
1710010 | 1710010 | 2021-09-12 | Champaign | Illinois | 17019 | 25187 | 186 |
1706763 | 1706763 | 2021-09-11 | Champaign | Illinois | 17019 | 25187 | 186 |
1703515 | 1703515 | 2021-09-10 | Champaign | Illinois | 17019 | 25187 | 186 |
1700265 | 1700265 | 2021-09-09 | Champaign | Illinois | 17019 | 25072 | 184 |
1697016 | 1697016 | 2021-09-08 | Champaign | Illinois | 17019 | 24953 | 183 |
1693768 | 1693768 | 2021-09-07 | Champaign | Illinois | 17019 | 24846 | 183 |
1690519 | 1690519 | 2021-09-06 | Champaign | Illinois | 17019 | 24598 | 182 |
1687269 | 1687269 | 2021-09-05 | Champaign | Illinois | 17019 | 24598 | 182 |
1684019 | 1684019 | 2021-09-04 | Champaign | Illinois | 17019 | 24598 | 182 |
1680768 | 1680768 | 2021-09-03 | Champaign | Illinois | 17019 | 24598 | 182 |
1677520 | 1677520 | 2021-09-02 | Champaign | Illinois | 17019 | 24436 | 182 |
1674273 | 1674273 | 2021-09-01 | Champaign | Illinois | 17019 | 24317 | 180 |
1671024 | 1671024 | 2021-08-31 | Champaign | Illinois | 17019 | 24149 | 180 |
1667777 | 1667777 | 2021-08-30 | Champaign | Illinois | 17019 | 24037 | 180 |
1664530 | 1664530 | 2021-08-29 | Champaign | Illinois | 17019 | 23763 | 180 |
1661282 | 1661282 | 2021-08-28 | Champaign | Illinois | 17019 | 23763 | 180 |
1658034 | 1658034 | 2021-08-27 | Champaign | Illinois | 17019 | 23763 | 180 |
1654786 | 1654786 | 2021-08-26 | Champaign | Illinois | 17019 | 23667 | 180 |
1651539 | 1651539 | 2021-08-25 | Champaign | Illinois | 17019 | 23596 | 177 |
1648290 | 1648290 | 2021-08-24 | Champaign | Illinois | 17019 | 23486 | 175 |
1645042 | 1645042 | 2021-08-23 | Champaign | Illinois | 17019 | 23418 | 175 |
1641793 | 1641793 | 2021-08-22 | Champaign | Illinois | 17019 | 23169 | 174 |
1638543 | 1638543 | 2021-08-21 | Champaign | Illinois | 17019 | 23169 | 174 |
1635293 | 1635293 | 2021-08-20 | Champaign | Illinois | 17019 | 23169 | 174 |
1632043 | 1632043 | 2021-08-19 | Champaign | Illinois | 17019 | 23071 | 172 |
1628796 | 1628796 | 2021-08-18 | Champaign | Illinois | 17019 | 23028 | 172 |
1625549 | 1625549 | 2021-08-17 | Champaign | Illinois | 17019 | 22883 | 172 |
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);