ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Unknown" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- …
state 1
- Minnesota · 679 ✖
fips 1
- - 679
county 1
- Unknown · 679 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175601 | 2175601 | 2022-02-02 | Unknown | Minnesota | 7131 | 150 | |
2172348 | 2172348 | 2022-02-01 | Unknown | Minnesota | 13025 | 150 | |
2169095 | 2169095 | 2022-01-31 | Unknown | Minnesota | 9322 | 150 | |
2165840 | 2165840 | 2022-01-30 | Unknown | Minnesota | 13066 | 150 | |
2162585 | 2162585 | 2022-01-29 | Unknown | Minnesota | 13066 | 150 | |
2159330 | 2159330 | 2022-01-28 | Unknown | Minnesota | 13066 | 150 | |
2156076 | 2156076 | 2022-01-27 | Unknown | Minnesota | 9939 | 150 | |
2152823 | 2152823 | 2022-01-26 | Unknown | Minnesota | 18569 | 140 | |
2149571 | 2149571 | 2022-01-25 | Unknown | Minnesota | 15836 | 140 | |
2146319 | 2146319 | 2022-01-24 | Unknown | Minnesota | 7265 | 140 | |
2143064 | 2143064 | 2022-01-23 | Unknown | Minnesota | 6213 | 140 | |
2139809 | 2139809 | 2022-01-22 | Unknown | Minnesota | 6213 | 140 | |
2136553 | 2136553 | 2022-01-21 | Unknown | Minnesota | 6213 | 140 | |
2133301 | 2133301 | 2022-01-20 | Unknown | Minnesota | 15048 | 140 | |
2130048 | 2130048 | 2022-01-19 | Unknown | Minnesota | 15907 | 140 | |
2126794 | 2126794 | 2022-01-18 | Unknown | Minnesota | 4275 | 140 | |
2123542 | 2123542 | 2022-01-17 | Unknown | Minnesota | 3629 | 140 | |
2120290 | 2120290 | 2022-01-16 | Unknown | Minnesota | 3629 | 140 | |
2117038 | 2117038 | 2022-01-15 | Unknown | Minnesota | 3629 | 140 | |
2113787 | 2113787 | 2022-01-14 | Unknown | Minnesota | 3629 | 140 | |
2110535 | 2110535 | 2022-01-13 | Unknown | Minnesota | 3366 | 140 | |
2107284 | 2107284 | 2022-01-12 | Unknown | Minnesota | 5694 | 140 | |
2104033 | 2104033 | 2022-01-11 | Unknown | Minnesota | 3552 | 140 | |
2100782 | 2100782 | 2022-01-10 | Unknown | Minnesota | 734 | 140 | |
2097531 | 2097531 | 2022-01-09 | Unknown | Minnesota | 707 | 140 | |
2094279 | 2094279 | 2022-01-08 | Unknown | Minnesota | 707 | 140 | |
2091027 | 2091027 | 2022-01-07 | Unknown | Minnesota | 707 | 140 | |
2087776 | 2087776 | 2022-01-06 | Unknown | Minnesota | 707 | 140 | |
2084524 | 2084524 | 2022-01-05 | Unknown | Minnesota | 714 | 140 | |
2081272 | 2081272 | 2022-01-04 | Unknown | Minnesota | 772 | 140 | |
2078020 | 2078020 | 2022-01-03 | Unknown | Minnesota | 765 | 140 | |
2074769 | 2074769 | 2022-01-02 | Unknown | Minnesota | 764 | 140 | |
2071518 | 2071518 | 2022-01-01 | Unknown | Minnesota | 764 | 140 | |
2068267 | 2068267 | 2021-12-31 | Unknown | Minnesota | 764 | 140 | |
2065016 | 2065016 | 2021-12-30 | Unknown | Minnesota | 764 | 140 | |
2061766 | 2061766 | 2021-12-29 | Unknown | Minnesota | 734 | 134 | |
2058517 | 2058517 | 2021-12-28 | Unknown | Minnesota | 743 | 134 | |
2055268 | 2055268 | 2021-12-27 | Unknown | Minnesota | 686 | 134 | |
2052018 | 2052018 | 2021-12-26 | Unknown | Minnesota | 693 | 134 | |
2048768 | 2048768 | 2021-12-25 | Unknown | Minnesota | 693 | 134 | |
2045518 | 2045518 | 2021-12-24 | Unknown | Minnesota | 693 | 134 | |
2042268 | 2042268 | 2021-12-23 | Unknown | Minnesota | 693 | 134 | |
2039019 | 2039019 | 2021-12-22 | Unknown | Minnesota | 708 | 124 | |
2035769 | 2035769 | 2021-12-21 | Unknown | Minnesota | 736 | 124 | |
2032519 | 2032519 | 2021-12-20 | Unknown | Minnesota | 703 | 124 | |
2029268 | 2029268 | 2021-12-19 | Unknown | Minnesota | 693 | 124 | |
2026017 | 2026017 | 2021-12-18 | Unknown | Minnesota | 693 | 124 | |
2022766 | 2022766 | 2021-12-17 | Unknown | Minnesota | 693 | 124 | |
2019515 | 2019515 | 2021-12-16 | Unknown | Minnesota | 683 | 124 | |
2016265 | 2016265 | 2021-12-15 | Unknown | Minnesota | 695 | 124 | |
2013014 | 2013014 | 2021-12-14 | Unknown | Minnesota | 701 | 124 | |
2009763 | 2009763 | 2021-12-13 | Unknown | Minnesota | 685 | 124 | |
2006512 | 2006512 | 2021-12-12 | Unknown | Minnesota | 679 | 124 | |
2003261 | 2003261 | 2021-12-11 | Unknown | Minnesota | 679 | 124 | |
2000011 | 2000011 | 2021-12-10 | Unknown | Minnesota | 679 | 124 | |
1996760 | 1996760 | 2021-12-09 | Unknown | Minnesota | 683 | 124 | |
1993509 | 1993509 | 2021-12-08 | Unknown | Minnesota | 669 | 124 | |
1990258 | 1990258 | 2021-12-07 | Unknown | Minnesota | 706 | 124 | |
1987008 | 1987008 | 2021-12-06 | Unknown | Minnesota | 685 | 124 | |
1983758 | 1983758 | 2021-12-05 | Unknown | Minnesota | 687 | 124 | |
1980508 | 1980508 | 2021-12-04 | Unknown | Minnesota | 687 | 124 | |
1977258 | 1977258 | 2021-12-03 | Unknown | Minnesota | 687 | 124 | |
1974008 | 1974008 | 2021-12-02 | Unknown | Minnesota | 693 | 124 | |
1970759 | 1970759 | 2021-12-01 | Unknown | Minnesota | 669 | 124 | |
1967509 | 1967509 | 2021-11-30 | Unknown | Minnesota | 753 | 124 | |
1964257 | 1964257 | 2021-11-29 | Unknown | Minnesota | 676 | 124 | |
1961006 | 1961006 | 2021-11-28 | Unknown | Minnesota | 696 | 124 | |
1957755 | 1957755 | 2021-11-27 | Unknown | Minnesota | 696 | 124 | |
1954504 | 1954504 | 2021-11-26 | Unknown | Minnesota | 696 | 124 | |
1951253 | 1951253 | 2021-11-25 | Unknown | Minnesota | 674 | 124 | |
1948002 | 1948002 | 2021-11-24 | Unknown | Minnesota | 674 | 124 | |
1944751 | 1944751 | 2021-11-23 | Unknown | Minnesota | 711 | 124 | |
1941500 | 1941500 | 2021-11-22 | Unknown | Minnesota | 672 | 124 | |
1938250 | 1938250 | 2021-11-21 | Unknown | Minnesota | 670 | 124 | |
1935000 | 1935000 | 2021-11-20 | Unknown | Minnesota | 670 | 124 | |
1931750 | 1931750 | 2021-11-19 | Unknown | Minnesota | 670 | 124 | |
1928499 | 1928499 | 2021-11-18 | Unknown | Minnesota | 663 | 124 | |
1925249 | 1925249 | 2021-11-17 | Unknown | Minnesota | 676 | 124 | |
1922000 | 1922000 | 2021-11-16 | Unknown | Minnesota | 725 | 124 | |
1918750 | 1918750 | 2021-11-15 | Unknown | Minnesota | 698 | 124 | |
1915500 | 1915500 | 2021-11-14 | Unknown | Minnesota | 669 | 124 | |
1912250 | 1912250 | 2021-11-13 | Unknown | Minnesota | 669 | 124 | |
1909000 | 1909000 | 2021-11-12 | Unknown | Minnesota | 669 | 124 | |
1905751 | 1905751 | 2021-11-11 | Unknown | Minnesota | 685 | 124 | |
1902502 | 1902502 | 2021-11-10 | Unknown | Minnesota | 684 | 124 | |
1899252 | 1899252 | 2021-11-09 | Unknown | Minnesota | 684 | 124 | |
1896002 | 1896002 | 2021-11-08 | Unknown | Minnesota | 678 | 124 | |
1892752 | 1892752 | 2021-11-07 | Unknown | Minnesota | 692 | 124 | |
1889502 | 1889502 | 2021-11-06 | Unknown | Minnesota | 692 | 124 | |
1886252 | 1886252 | 2021-11-05 | Unknown | Minnesota | 692 | 124 | |
1883003 | 1883003 | 2021-11-04 | Unknown | Minnesota | 676 | 124 | |
1879754 | 1879754 | 2021-11-03 | Unknown | Minnesota | 665 | 124 | |
1876505 | 1876505 | 2021-11-02 | Unknown | Minnesota | 670 | 124 | |
1873256 | 1873256 | 2021-11-01 | Unknown | Minnesota | 654 | 125 | |
1870007 | 1870007 | 2021-10-31 | Unknown | Minnesota | 652 | 124 | |
1866758 | 1866758 | 2021-10-30 | Unknown | Minnesota | 652 | 124 | |
1863509 | 1863509 | 2021-10-29 | Unknown | Minnesota | 652 | 124 | |
1860260 | 1860260 | 2021-10-28 | Unknown | Minnesota | 662 | 124 | |
1857011 | 1857011 | 2021-10-27 | Unknown | Minnesota | 652 | 124 | |
1853762 | 1853762 | 2021-10-26 | Unknown | Minnesota | 678 | 124 |
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);