ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Anoka" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175524 | 2175524 | 2022-02-02 | Anoka | Minnesota | 27003 | 93601 | 740 |
2172271 | 2172271 | 2022-02-01 | Anoka | Minnesota | 27003 | 92959 | 738 |
2169018 | 2169018 | 2022-01-31 | Anoka | Minnesota | 27003 | 91790 | 735 |
2165763 | 2165763 | 2022-01-30 | Anoka | Minnesota | 27003 | 90713 | 731 |
2162508 | 2162508 | 2022-01-29 | Anoka | Minnesota | 27003 | 90713 | 731 |
2159253 | 2159253 | 2022-01-28 | Anoka | Minnesota | 27003 | 90713 | 731 |
2155999 | 2155999 | 2022-01-27 | Anoka | Minnesota | 27003 | 89932 | 728 |
2152746 | 2152746 | 2022-01-26 | Anoka | Minnesota | 27003 | 88284 | 725 |
2149494 | 2149494 | 2022-01-25 | Anoka | Minnesota | 27003 | 87451 | 722 |
2146242 | 2146242 | 2022-01-24 | Anoka | Minnesota | 27003 | 85617 | 721 |
2142987 | 2142987 | 2022-01-23 | Anoka | Minnesota | 27003 | 84799 | 719 |
2139732 | 2139732 | 2022-01-22 | Anoka | Minnesota | 27003 | 84799 | 719 |
2136476 | 2136476 | 2022-01-21 | Anoka | Minnesota | 27003 | 84799 | 719 |
2133224 | 2133224 | 2022-01-20 | Anoka | Minnesota | 27003 | 83444 | 718 |
2129971 | 2129971 | 2022-01-19 | Anoka | Minnesota | 27003 | 82638 | 715 |
2126717 | 2126717 | 2022-01-18 | Anoka | Minnesota | 27003 | 80505 | 712 |
2123465 | 2123465 | 2022-01-17 | Anoka | Minnesota | 27003 | 79802 | 710 |
2120213 | 2120213 | 2022-01-16 | Anoka | Minnesota | 27003 | 79802 | 710 |
2116961 | 2116961 | 2022-01-15 | Anoka | Minnesota | 27003 | 79802 | 710 |
2113710 | 2113710 | 2022-01-14 | Anoka | Minnesota | 27003 | 79802 | 710 |
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 |
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);