ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 27003 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110458 | 2110458 | 2022-01-13 | Anoka | Minnesota | 27003 | 79046 | 708 |
2107207 | 2107207 | 2022-01-12 | Anoka | Minnesota | 27003 | 78044 | 705 |
2103956 | 2103956 | 2022-01-11 | Anoka | Minnesota | 27003 | 77421 | 699 |
2100705 | 2100705 | 2022-01-10 | Anoka | Minnesota | 27003 | 75708 | 694 |
2097454 | 2097454 | 2022-01-09 | Anoka | Minnesota | 27003 | 74918 | 688 |
2094202 | 2094202 | 2022-01-08 | Anoka | Minnesota | 27003 | 74918 | 688 |
2090950 | 2090950 | 2022-01-07 | Anoka | Minnesota | 27003 | 74918 | 688 |
2087699 | 2087699 | 2022-01-06 | Anoka | Minnesota | 27003 | 74431 | 686 |
2084447 | 2084447 | 2022-01-05 | Anoka | Minnesota | 27003 | 73980 | 684 |
2081195 | 2081195 | 2022-01-04 | Anoka | Minnesota | 27003 | 73615 | 678 |
2077943 | 2077943 | 2022-01-03 | Anoka | Minnesota | 27003 | 72285 | 678 |
2074692 | 2074692 | 2022-01-02 | Anoka | Minnesota | 27003 | 71618 | 676 |
2071441 | 2071441 | 2022-01-01 | Anoka | Minnesota | 27003 | 71618 | 676 |
2068190 | 2068190 | 2021-12-31 | Anoka | Minnesota | 27003 | 71618 | 676 |
2064939 | 2064939 | 2021-12-30 | Anoka | Minnesota | 27003 | 71618 | 676 |
2061689 | 2061689 | 2021-12-29 | Anoka | Minnesota | 27003 | 71207 | 670 |
2058440 | 2058440 | 2021-12-28 | Anoka | Minnesota | 27003 | 70860 | 660 |
2055191 | 2055191 | 2021-12-27 | Anoka | Minnesota | 27003 | 70230 | 660 |
2051941 | 2051941 | 2021-12-26 | Anoka | Minnesota | 27003 | 70003 | 657 |
2048691 | 2048691 | 2021-12-25 | Anoka | Minnesota | 27003 | 70003 | 657 |
2045441 | 2045441 | 2021-12-24 | Anoka | Minnesota | 27003 | 70003 | 657 |
2042191 | 2042191 | 2021-12-23 | Anoka | Minnesota | 27003 | 70003 | 657 |
2038942 | 2038942 | 2021-12-22 | Anoka | Minnesota | 27003 | 69778 | 649 |
2035692 | 2035692 | 2021-12-21 | Anoka | Minnesota | 27003 | 69548 | 641 |
2032442 | 2032442 | 2021-12-20 | Anoka | Minnesota | 27003 | 69009 | 635 |
2029191 | 2029191 | 2021-12-19 | Anoka | Minnesota | 27003 | 68767 | 632 |
2025940 | 2025940 | 2021-12-18 | Anoka | Minnesota | 27003 | 68767 | 632 |
2022689 | 2022689 | 2021-12-17 | Anoka | Minnesota | 27003 | 68767 | 632 |
2019438 | 2019438 | 2021-12-16 | Anoka | Minnesota | 27003 | 68528 | 629 |
2016188 | 2016188 | 2021-12-15 | Anoka | Minnesota | 27003 | 68216 | 628 |
2012937 | 2012937 | 2021-12-14 | Anoka | Minnesota | 27003 | 68092 | 622 |
2009686 | 2009686 | 2021-12-13 | Anoka | Minnesota | 27003 | 67444 | 618 |
2006435 | 2006435 | 2021-12-12 | Anoka | Minnesota | 27003 | 67206 | 615 |
2003184 | 2003184 | 2021-12-11 | Anoka | Minnesota | 27003 | 67206 | 615 |
1999934 | 1999934 | 2021-12-10 | Anoka | Minnesota | 27003 | 67206 | 615 |
1996683 | 1996683 | 2021-12-09 | Anoka | Minnesota | 27003 | 66862 | 611 |
1993432 | 1993432 | 2021-12-08 | Anoka | Minnesota | 27003 | 66615 | 605 |
1990181 | 1990181 | 2021-12-07 | Anoka | Minnesota | 27003 | 66370 | 596 |
1986931 | 1986931 | 2021-12-06 | Anoka | Minnesota | 27003 | 65423 | 593 |
1983681 | 1983681 | 2021-12-05 | Anoka | Minnesota | 27003 | 64961 | 589 |
1980431 | 1980431 | 2021-12-04 | Anoka | Minnesota | 27003 | 64961 | 589 |
1977181 | 1977181 | 2021-12-03 | Anoka | Minnesota | 27003 | 64961 | 589 |
1973931 | 1973931 | 2021-12-02 | Anoka | Minnesota | 27003 | 64523 | 585 |
1970682 | 1970682 | 2021-12-01 | Anoka | Minnesota | 27003 | 64112 | 577 |
1967432 | 1967432 | 2021-11-30 | Anoka | Minnesota | 27003 | 63852 | 570 |
1964180 | 1964180 | 2021-11-29 | Anoka | Minnesota | 27003 | 62843 | 570 |
1960929 | 1960929 | 2021-11-28 | Anoka | Minnesota | 27003 | 62513 | 568 |
1957678 | 1957678 | 2021-11-27 | Anoka | Minnesota | 27003 | 62513 | 568 |
1954427 | 1954427 | 2021-11-26 | Anoka | Minnesota | 27003 | 62513 | 568 |
1951176 | 1951176 | 2021-11-25 | Anoka | Minnesota | 27003 | 62204 | 564 |
1947925 | 1947925 | 2021-11-24 | Anoka | Minnesota | 27003 | 62204 | 564 |
1944674 | 1944674 | 2021-11-23 | Anoka | Minnesota | 27003 | 61887 | 563 |
1941423 | 1941423 | 2021-11-22 | Anoka | Minnesota | 27003 | 61024 | 560 |
1938173 | 1938173 | 2021-11-21 | Anoka | Minnesota | 27003 | 60691 | 557 |
1934923 | 1934923 | 2021-11-20 | Anoka | Minnesota | 27003 | 60691 | 557 |
1931673 | 1931673 | 2021-11-19 | Anoka | Minnesota | 27003 | 60691 | 557 |
1928422 | 1928422 | 2021-11-18 | Anoka | Minnesota | 27003 | 60302 | 556 |
1925172 | 1925172 | 2021-11-17 | Anoka | Minnesota | 27003 | 60017 | 556 |
1921923 | 1921923 | 2021-11-16 | Anoka | Minnesota | 27003 | 59792 | 548 |
1918673 | 1918673 | 2021-11-15 | Anoka | Minnesota | 27003 | 59074 | 546 |
1915423 | 1915423 | 2021-11-14 | Anoka | Minnesota | 27003 | 58722 | 546 |
1912173 | 1912173 | 2021-11-13 | Anoka | Minnesota | 27003 | 58722 | 546 |
1908923 | 1908923 | 2021-11-12 | Anoka | Minnesota | 27003 | 58722 | 546 |
1905674 | 1905674 | 2021-11-11 | Anoka | Minnesota | 27003 | 58364 | 544 |
1902425 | 1902425 | 2021-11-10 | Anoka | Minnesota | 27003 | 58053 | 543 |
1899175 | 1899175 | 2021-11-09 | Anoka | Minnesota | 27003 | 57687 | 537 |
1895925 | 1895925 | 2021-11-08 | Anoka | Minnesota | 27003 | 57216 | 535 |
1892675 | 1892675 | 2021-11-07 | Anoka | Minnesota | 27003 | 56920 | 531 |
1889425 | 1889425 | 2021-11-06 | Anoka | Minnesota | 27003 | 56920 | 531 |
1886175 | 1886175 | 2021-11-05 | Anoka | Minnesota | 27003 | 56920 | 531 |
1882926 | 1882926 | 2021-11-04 | Anoka | Minnesota | 27003 | 56748 | 531 |
1879677 | 1879677 | 2021-11-03 | Anoka | Minnesota | 27003 | 56515 | 529 |
1876428 | 1876428 | 2021-11-02 | Anoka | Minnesota | 27003 | 56299 | 528 |
1873179 | 1873179 | 2021-11-01 | Anoka | Minnesota | 27003 | 55887 | 529 |
1869930 | 1869930 | 2021-10-31 | Anoka | Minnesota | 27003 | 55176 | 527 |
1866681 | 1866681 | 2021-10-30 | Anoka | Minnesota | 27003 | 55176 | 527 |
1863432 | 1863432 | 2021-10-29 | Anoka | Minnesota | 27003 | 55176 | 527 |
1860183 | 1860183 | 2021-10-28 | Anoka | Minnesota | 27003 | 54947 | 526 |
1856934 | 1856934 | 2021-10-27 | Anoka | Minnesota | 27003 | 54793 | 524 |
1853685 | 1853685 | 2021-10-26 | Anoka | Minnesota | 27003 | 54651 | 523 |
1850436 | 1850436 | 2021-10-25 | Anoka | Minnesota | 27003 | 54212 | 521 |
1847186 | 1847186 | 2021-10-24 | Anoka | Minnesota | 27003 | 54052 | 520 |
1843936 | 1843936 | 2021-10-23 | Anoka | Minnesota | 27003 | 54052 | 520 |
1840686 | 1840686 | 2021-10-22 | Anoka | Minnesota | 27003 | 54052 | 520 |
1837437 | 1837437 | 2021-10-21 | Anoka | Minnesota | 27003 | 53854 | 520 |
1834188 | 1834188 | 2021-10-20 | Anoka | Minnesota | 27003 | 53701 | 520 |
1830939 | 1830939 | 2021-10-19 | Anoka | Minnesota | 27003 | 53591 | 515 |
1827690 | 1827690 | 2021-10-18 | Anoka | Minnesota | 27003 | 53221 | 514 |
1824441 | 1824441 | 2021-10-17 | Anoka | Minnesota | 27003 | 53010 | 513 |
1821192 | 1821192 | 2021-10-16 | Anoka | Minnesota | 27003 | 53010 | 513 |
1817943 | 1817943 | 2021-10-15 | Anoka | Minnesota | 27003 | 53010 | 513 |
1814694 | 1814694 | 2021-10-14 | Anoka | Minnesota | 27003 | 52797 | 511 |
1811446 | 1811446 | 2021-10-13 | Anoka | Minnesota | 27003 | 52591 | 511 |
1808197 | 1808197 | 2021-10-12 | Anoka | Minnesota | 27003 | 52429 | 509 |
1804946 | 1804946 | 2021-10-11 | Anoka | Minnesota | 27003 | 51930 | 509 |
1801697 | 1801697 | 2021-10-10 | Anoka | Minnesota | 27003 | 51677 | 506 |
1798448 | 1798448 | 2021-10-09 | Anoka | Minnesota | 27003 | 51677 | 506 |
1795199 | 1795199 | 2021-10-08 | Anoka | Minnesota | 27003 | 51677 | 506 |
1791950 | 1791950 | 2021-10-07 | Anoka | Minnesota | 27003 | 51437 | 502 |
1788701 | 1788701 | 2021-10-06 | Anoka | Minnesota | 27003 | 51283 | 501 |
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);