ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "St. Clair" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174883 | 2174883 | 2022-02-02 | St. Clair | Illinois | 17163 | 66540 | 735 |
2171630 | 2171630 | 2022-02-01 | St. Clair | Illinois | 17163 | 66351 | 735 |
2168377 | 2168377 | 2022-01-31 | St. Clair | Illinois | 17163 | 66152 | 733 |
2165122 | 2165122 | 2022-01-30 | St. Clair | Illinois | 17163 | 65480 | 732 |
2161867 | 2161867 | 2022-01-29 | St. Clair | Illinois | 17163 | 65480 | 732 |
2158612 | 2158612 | 2022-01-28 | St. Clair | Illinois | 17163 | 65480 | 732 |
2155358 | 2155358 | 2022-01-27 | St. Clair | Illinois | 17163 | 65171 | 731 |
2152105 | 2152105 | 2022-01-26 | St. Clair | Illinois | 17163 | 64696 | 726 |
2148853 | 2148853 | 2022-01-25 | St. Clair | Illinois | 17163 | 64421 | 723 |
2145601 | 2145601 | 2022-01-24 | St. Clair | Illinois | 17163 | 64123 | 720 |
2142346 | 2142346 | 2022-01-23 | St. Clair | Illinois | 17163 | 62883 | 715 |
2139091 | 2139091 | 2022-01-22 | St. Clair | Illinois | 17163 | 62883 | 715 |
2135835 | 2135835 | 2022-01-21 | St. Clair | Illinois | 17163 | 62883 | 715 |
2132583 | 2132583 | 2022-01-20 | St. Clair | Illinois | 17163 | 62254 | 711 |
2129330 | 2129330 | 2022-01-19 | St. Clair | Illinois | 17163 | 61593 | 709 |
2126076 | 2126076 | 2022-01-18 | St. Clair | Illinois | 17163 | 61043 | 707 |
2122824 | 2122824 | 2022-01-17 | St. Clair | Illinois | 17163 | 58573 | 701 |
2119572 | 2119572 | 2022-01-16 | St. Clair | Illinois | 17163 | 58573 | 701 |
2116320 | 2116320 | 2022-01-15 | St. Clair | Illinois | 17163 | 58573 | 701 |
2113069 | 2113069 | 2022-01-14 | St. Clair | Illinois | 17163 | 58573 | 701 |
2109817 | 2109817 | 2022-01-13 | St. Clair | Illinois | 17163 | 57808 | 700 |
2106566 | 2106566 | 2022-01-12 | St. Clair | Illinois | 17163 | 56896 | 698 |
2103315 | 2103315 | 2022-01-11 | St. Clair | Illinois | 17163 | 56010 | 696 |
2100064 | 2100064 | 2022-01-10 | St. Clair | Illinois | 17163 | 55298 | 696 |
2096813 | 2096813 | 2022-01-09 | St. Clair | Illinois | 17163 | 53280 | 694 |
2093561 | 2093561 | 2022-01-08 | St. Clair | Illinois | 17163 | 53280 | 694 |
2090309 | 2090309 | 2022-01-07 | St. Clair | Illinois | 17163 | 53280 | 694 |
2087058 | 2087058 | 2022-01-06 | St. Clair | Illinois | 17163 | 52383 | 693 |
2083806 | 2083806 | 2022-01-05 | St. Clair | Illinois | 17163 | 51562 | 693 |
2080554 | 2080554 | 2022-01-04 | St. Clair | Illinois | 17163 | 50712 | 688 |
2077302 | 2077302 | 2022-01-03 | St. Clair | Illinois | 17163 | 50183 | 685 |
2074051 | 2074051 | 2022-01-02 | St. Clair | Illinois | 17163 | 48021 | 681 |
2070800 | 2070800 | 2022-01-01 | St. Clair | Illinois | 17163 | 48021 | 681 |
2067549 | 2067549 | 2021-12-31 | St. Clair | Illinois | 17163 | 48021 | 681 |
2064298 | 2064298 | 2021-12-30 | St. Clair | Illinois | 17163 | 48021 | 681 |
2061048 | 2061048 | 2021-12-29 | St. Clair | Illinois | 17163 | 47313 | 681 |
2057799 | 2057799 | 2021-12-28 | St. Clair | Illinois | 17163 | 47039 | 679 |
2054550 | 2054550 | 2021-12-27 | St. Clair | Illinois | 17163 | 46031 | 678 |
2051300 | 2051300 | 2021-12-26 | St. Clair | Illinois | 17163 | 46031 | 675 |
2048050 | 2048050 | 2021-12-25 | St. Clair | Illinois | 17163 | 46031 | 675 |
2044800 | 2044800 | 2021-12-24 | St. Clair | Illinois | 17163 | 46031 | 675 |
2041551 | 2041551 | 2021-12-23 | St. Clair | Illinois | 17163 | 46031 | 675 |
2038301 | 2038301 | 2021-12-22 | St. Clair | Illinois | 17163 | 45761 | 674 |
2035051 | 2035051 | 2021-12-21 | St. Clair | Illinois | 17163 | 45637 | 673 |
2031801 | 2031801 | 2021-12-20 | St. Clair | Illinois | 17163 | 45493 | 671 |
2028550 | 2028550 | 2021-12-19 | St. Clair | Illinois | 17163 | 45103 | 670 |
2025299 | 2025299 | 2021-12-18 | St. Clair | Illinois | 17163 | 45103 | 670 |
2022048 | 2022048 | 2021-12-17 | St. Clair | Illinois | 17163 | 45103 | 670 |
2018797 | 2018797 | 2021-12-16 | St. Clair | Illinois | 17163 | 44930 | 668 |
2015547 | 2015547 | 2021-12-15 | St. Clair | Illinois | 17163 | 44711 | 667 |
2012296 | 2012296 | 2021-12-14 | St. Clair | Illinois | 17163 | 44453 | 667 |
2009045 | 2009045 | 2021-12-13 | St. Clair | Illinois | 17163 | 44453 | 666 |
2005794 | 2005794 | 2021-12-12 | St. Clair | Illinois | 17163 | 44043 | 664 |
2002543 | 2002543 | 2021-12-11 | St. Clair | Illinois | 17163 | 44043 | 664 |
1999293 | 1999293 | 2021-12-10 | St. Clair | Illinois | 17163 | 44043 | 664 |
1996042 | 1996042 | 2021-12-09 | St. Clair | Illinois | 17163 | 43880 | 664 |
1992791 | 1992791 | 2021-12-08 | St. Clair | Illinois | 17163 | 43663 | 664 |
1989540 | 1989540 | 2021-12-07 | St. Clair | Illinois | 17163 | 43374 | 663 |
1986290 | 1986290 | 2021-12-06 | St. Clair | Illinois | 17163 | 43374 | 663 |
1983040 | 1983040 | 2021-12-05 | St. Clair | Illinois | 17163 | 42995 | 663 |
1979790 | 1979790 | 2021-12-04 | St. Clair | Illinois | 17163 | 42995 | 663 |
1976540 | 1976540 | 2021-12-03 | St. Clair | Illinois | 17163 | 42995 | 663 |
1973291 | 1973291 | 2021-12-02 | St. Clair | Illinois | 17163 | 42836 | 663 |
1970041 | 1970041 | 2021-12-01 | St. Clair | Illinois | 17163 | 42651 | 663 |
1966791 | 1966791 | 2021-11-30 | St. Clair | Illinois | 17163 | 42537 | 662 |
1963539 | 1963539 | 2021-11-29 | St. Clair | Illinois | 17163 | 42442 | 662 |
1960288 | 1960288 | 2021-11-28 | St. Clair | Illinois | 17163 | 42040 | 662 |
1957037 | 1957037 | 2021-11-27 | St. Clair | Illinois | 17163 | 42040 | 662 |
1953786 | 1953786 | 2021-11-26 | St. Clair | Illinois | 17163 | 42040 | 662 |
1950535 | 1950535 | 2021-11-25 | St. Clair | Illinois | 17163 | 42040 | 662 |
1947284 | 1947284 | 2021-11-24 | St. Clair | Illinois | 17163 | 42040 | 662 |
1944033 | 1944033 | 2021-11-23 | St. Clair | Illinois | 17163 | 41967 | 662 |
1940783 | 1940783 | 2021-11-22 | St. Clair | Illinois | 17163 | 41880 | 662 |
1937533 | 1937533 | 2021-11-21 | St. Clair | Illinois | 17163 | 41721 | 660 |
1934283 | 1934283 | 2021-11-20 | St. Clair | Illinois | 17163 | 41721 | 660 |
1931032 | 1931032 | 2021-11-19 | St. Clair | Illinois | 17163 | 41721 | 660 |
1927781 | 1927781 | 2021-11-18 | St. Clair | Illinois | 17163 | 41607 | 660 |
1924531 | 1924531 | 2021-11-17 | St. Clair | Illinois | 17163 | 41493 | 659 |
1921282 | 1921282 | 2021-11-16 | St. Clair | Illinois | 17163 | 41416 | 657 |
1918032 | 1918032 | 2021-11-15 | St. Clair | Illinois | 17163 | 41337 | 656 |
1914782 | 1914782 | 2021-11-14 | St. Clair | Illinois | 17163 | 41021 | 654 |
1911532 | 1911532 | 2021-11-13 | St. Clair | Illinois | 17163 | 41021 | 654 |
1908283 | 1908283 | 2021-11-12 | St. Clair | Illinois | 17163 | 41021 | 654 |
1905034 | 1905034 | 2021-11-11 | St. Clair | Illinois | 17163 | 41021 | 654 |
1901784 | 1901784 | 2021-11-10 | St. Clair | Illinois | 17163 | 41021 | 654 |
1898534 | 1898534 | 2021-11-09 | St. Clair | Illinois | 17163 | 40943 | 652 |
1895284 | 1895284 | 2021-11-08 | St. Clair | Illinois | 17163 | 40911 | 652 |
1892034 | 1892034 | 2021-11-07 | St. Clair | Illinois | 17163 | 40798 | 651 |
1888784 | 1888784 | 2021-11-06 | St. Clair | Illinois | 17163 | 40798 | 651 |
1885534 | 1885534 | 2021-11-05 | St. Clair | Illinois | 17163 | 40798 | 651 |
1882285 | 1882285 | 2021-11-04 | St. Clair | Illinois | 17163 | 40747 | 650 |
1879036 | 1879036 | 2021-11-03 | St. Clair | Illinois | 17163 | 40690 | 650 |
1875787 | 1875787 | 2021-11-02 | St. Clair | Illinois | 17163 | 40633 | 649 |
1872538 | 1872538 | 2021-11-01 | St. Clair | Illinois | 17163 | 40603 | 649 |
1869289 | 1869289 | 2021-10-31 | St. Clair | Illinois | 17163 | 40499 | 649 |
1866040 | 1866040 | 2021-10-30 | St. Clair | Illinois | 17163 | 40499 | 649 |
1862791 | 1862791 | 2021-10-29 | St. Clair | Illinois | 17163 | 40499 | 649 |
1859542 | 1859542 | 2021-10-28 | St. Clair | Illinois | 17163 | 40461 | 649 |
1856293 | 1856293 | 2021-10-27 | St. Clair | Illinois | 17163 | 40423 | 646 |
1853044 | 1853044 | 2021-10-26 | St. Clair | Illinois | 17163 | 40396 | 646 |
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);