ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110470 | 2110470 | 2022-01-13 | Clay | Minnesota | 27027 | 14278 | 114 |
2107219 | 2107219 | 2022-01-12 | Clay | Minnesota | 27027 | 14125 | 114 |
2103968 | 2103968 | 2022-01-11 | Clay | Minnesota | 27027 | 13931 | 114 |
2100717 | 2100717 | 2022-01-10 | Clay | Minnesota | 27027 | 13661 | 114 |
2097466 | 2097466 | 2022-01-09 | Clay | Minnesota | 27027 | 13556 | 114 |
2094214 | 2094214 | 2022-01-08 | Clay | Minnesota | 27027 | 13556 | 114 |
2090962 | 2090962 | 2022-01-07 | Clay | Minnesota | 27027 | 13556 | 114 |
2087711 | 2087711 | 2022-01-06 | Clay | Minnesota | 27027 | 13478 | 114 |
2084459 | 2084459 | 2022-01-05 | Clay | Minnesota | 27027 | 13410 | 114 |
2081207 | 2081207 | 2022-01-04 | Clay | Minnesota | 27027 | 13343 | 114 |
2077955 | 2077955 | 2022-01-03 | Clay | Minnesota | 27027 | 13227 | 113 |
2074704 | 2074704 | 2022-01-02 | Clay | Minnesota | 27027 | 13171 | 113 |
2071453 | 2071453 | 2022-01-01 | Clay | Minnesota | 27027 | 13171 | 113 |
2068202 | 2068202 | 2021-12-31 | Clay | Minnesota | 27027 | 13171 | 113 |
2064951 | 2064951 | 2021-12-30 | Clay | Minnesota | 27027 | 13171 | 113 |
2061701 | 2061701 | 2021-12-29 | Clay | Minnesota | 27027 | 13125 | 113 |
2058452 | 2058452 | 2021-12-28 | Clay | Minnesota | 27027 | 13080 | 113 |
2055203 | 2055203 | 2021-12-27 | Clay | Minnesota | 27027 | 13014 | 113 |
2051953 | 2051953 | 2021-12-26 | Clay | Minnesota | 27027 | 12977 | 111 |
2048703 | 2048703 | 2021-12-25 | Clay | Minnesota | 27027 | 12977 | 111 |
2045453 | 2045453 | 2021-12-24 | Clay | Minnesota | 27027 | 12977 | 111 |
2042203 | 2042203 | 2021-12-23 | Clay | Minnesota | 27027 | 12977 | 111 |
2038954 | 2038954 | 2021-12-22 | Clay | Minnesota | 27027 | 12955 | 111 |
2035704 | 2035704 | 2021-12-21 | Clay | Minnesota | 27027 | 12903 | 111 |
2032454 | 2032454 | 2021-12-20 | Clay | Minnesota | 27027 | 12818 | 111 |
2029203 | 2029203 | 2021-12-19 | Clay | Minnesota | 27027 | 12773 | 111 |
2025952 | 2025952 | 2021-12-18 | Clay | Minnesota | 27027 | 12773 | 111 |
2022701 | 2022701 | 2021-12-17 | Clay | Minnesota | 27027 | 12773 | 111 |
2019450 | 2019450 | 2021-12-16 | Clay | Minnesota | 27027 | 12731 | 111 |
2016200 | 2016200 | 2021-12-15 | Clay | Minnesota | 27027 | 12680 | 111 |
2012949 | 2012949 | 2021-12-14 | Clay | Minnesota | 27027 | 12606 | 111 |
2009698 | 2009698 | 2021-12-13 | Clay | Minnesota | 27027 | 12528 | 111 |
2006447 | 2006447 | 2021-12-12 | Clay | Minnesota | 27027 | 12489 | 111 |
2003196 | 2003196 | 2021-12-11 | Clay | Minnesota | 27027 | 12489 | 111 |
1999946 | 1999946 | 2021-12-10 | Clay | Minnesota | 27027 | 12489 | 111 |
1996695 | 1996695 | 2021-12-09 | Clay | Minnesota | 27027 | 12423 | 111 |
1993444 | 1993444 | 2021-12-08 | Clay | Minnesota | 27027 | 12390 | 110 |
1990193 | 1990193 | 2021-12-07 | Clay | Minnesota | 27027 | 12359 | 110 |
1986943 | 1986943 | 2021-12-06 | Clay | Minnesota | 27027 | 12286 | 110 |
1983693 | 1983693 | 2021-12-05 | Clay | Minnesota | 27027 | 12219 | 108 |
1980443 | 1980443 | 2021-12-04 | Clay | Minnesota | 27027 | 12219 | 108 |
1977193 | 1977193 | 2021-12-03 | Clay | Minnesota | 27027 | 12219 | 108 |
1973943 | 1973943 | 2021-12-02 | Clay | Minnesota | 27027 | 12183 | 107 |
1970694 | 1970694 | 2021-12-01 | Clay | Minnesota | 27027 | 12104 | 105 |
1967444 | 1967444 | 2021-11-30 | Clay | Minnesota | 27027 | 12033 | 104 |
1964192 | 1964192 | 2021-11-29 | Clay | Minnesota | 27027 | 11948 | 104 |
1960941 | 1960941 | 2021-11-28 | Clay | Minnesota | 27027 | 11923 | 103 |
1957690 | 1957690 | 2021-11-27 | Clay | Minnesota | 27027 | 11923 | 103 |
1954439 | 1954439 | 2021-11-26 | Clay | Minnesota | 27027 | 11923 | 103 |
1951188 | 1951188 | 2021-11-25 | Clay | Minnesota | 27027 | 11865 | 102 |
1947937 | 1947937 | 2021-11-24 | Clay | Minnesota | 27027 | 11865 | 102 |
1944686 | 1944686 | 2021-11-23 | Clay | Minnesota | 27027 | 11817 | 102 |
1941435 | 1941435 | 2021-11-22 | Clay | Minnesota | 27027 | 11708 | 102 |
1938185 | 1938185 | 2021-11-21 | Clay | Minnesota | 27027 | 11602 | 101 |
1934935 | 1934935 | 2021-11-20 | Clay | Minnesota | 27027 | 11602 | 101 |
1931685 | 1931685 | 2021-11-19 | Clay | Minnesota | 27027 | 11602 | 101 |
1928434 | 1928434 | 2021-11-18 | Clay | Minnesota | 27027 | 11573 | 101 |
1925184 | 1925184 | 2021-11-17 | Clay | Minnesota | 27027 | 11527 | 101 |
1921935 | 1921935 | 2021-11-16 | Clay | Minnesota | 27027 | 11449 | 100 |
1918685 | 1918685 | 2021-11-15 | Clay | Minnesota | 27027 | 11374 | 100 |
1915435 | 1915435 | 2021-11-14 | Clay | Minnesota | 27027 | 11303 | 100 |
1912185 | 1912185 | 2021-11-13 | Clay | Minnesota | 27027 | 11303 | 100 |
1908935 | 1908935 | 2021-11-12 | Clay | Minnesota | 27027 | 11303 | 100 |
1905686 | 1905686 | 2021-11-11 | Clay | Minnesota | 27027 | 11207 | 100 |
1902437 | 1902437 | 2021-11-10 | Clay | Minnesota | 27027 | 11153 | 100 |
1899187 | 1899187 | 2021-11-09 | Clay | Minnesota | 27027 | 11068 | 100 |
1895937 | 1895937 | 2021-11-08 | Clay | Minnesota | 27027 | 10966 | 100 |
1892687 | 1892687 | 2021-11-07 | Clay | Minnesota | 27027 | 10900 | 100 |
1889437 | 1889437 | 2021-11-06 | Clay | Minnesota | 27027 | 10900 | 100 |
1886187 | 1886187 | 2021-11-05 | Clay | Minnesota | 27027 | 10900 | 100 |
1882938 | 1882938 | 2021-11-04 | Clay | Minnesota | 27027 | 10838 | 99 |
1879689 | 1879689 | 2021-11-03 | Clay | Minnesota | 27027 | 10761 | 99 |
1876440 | 1876440 | 2021-11-02 | Clay | Minnesota | 27027 | 10717 | 99 |
1873191 | 1873191 | 2021-11-01 | Clay | Minnesota | 27027 | 10630 | 99 |
1869942 | 1869942 | 2021-10-31 | Clay | Minnesota | 27027 | 10507 | 99 |
1866693 | 1866693 | 2021-10-30 | Clay | Minnesota | 27027 | 10507 | 99 |
1863444 | 1863444 | 2021-10-29 | Clay | Minnesota | 27027 | 10507 | 99 |
1860195 | 1860195 | 2021-10-28 | Clay | Minnesota | 27027 | 10432 | 99 |
1856946 | 1856946 | 2021-10-27 | Clay | Minnesota | 27027 | 10394 | 99 |
1853697 | 1853697 | 2021-10-26 | Clay | Minnesota | 27027 | 10349 | 99 |
1850448 | 1850448 | 2021-10-25 | Clay | Minnesota | 27027 | 10275 | 99 |
1847198 | 1847198 | 2021-10-24 | Clay | Minnesota | 27027 | 10253 | 99 |
1843948 | 1843948 | 2021-10-23 | Clay | Minnesota | 27027 | 10253 | 99 |
1840698 | 1840698 | 2021-10-22 | Clay | Minnesota | 27027 | 10253 | 99 |
1837449 | 1837449 | 2021-10-21 | Clay | Minnesota | 27027 | 10235 | 99 |
1834200 | 1834200 | 2021-10-20 | Clay | Minnesota | 27027 | 10180 | 99 |
1830951 | 1830951 | 2021-10-19 | Clay | Minnesota | 27027 | 10160 | 98 |
1827702 | 1827702 | 2021-10-18 | Clay | Minnesota | 27027 | 10117 | 98 |
1824453 | 1824453 | 2021-10-17 | Clay | Minnesota | 27027 | 10065 | 98 |
1821204 | 1821204 | 2021-10-16 | Clay | Minnesota | 27027 | 10065 | 98 |
1817955 | 1817955 | 2021-10-15 | Clay | Minnesota | 27027 | 10065 | 98 |
1814706 | 1814706 | 2021-10-14 | Clay | Minnesota | 27027 | 10010 | 98 |
1811458 | 1811458 | 2021-10-13 | Clay | Minnesota | 27027 | 9961 | 98 |
1808209 | 1808209 | 2021-10-12 | Clay | Minnesota | 27027 | 9934 | 98 |
1804958 | 1804958 | 2021-10-11 | Clay | Minnesota | 27027 | 9823 | 98 |
1801709 | 1801709 | 2021-10-10 | Clay | Minnesota | 27027 | 9798 | 98 |
1798460 | 1798460 | 2021-10-09 | Clay | Minnesota | 27027 | 9798 | 98 |
1795211 | 1795211 | 2021-10-08 | Clay | Minnesota | 27027 | 9798 | 98 |
1791962 | 1791962 | 2021-10-07 | Clay | Minnesota | 27027 | 9748 | 98 |
1788713 | 1788713 | 2021-10-06 | Clay | Minnesota | 27027 | 9702 | 98 |
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);