ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Dakota" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175541 | 2175541 | 2022-02-02 | Dakota | Minnesota | 27037 | 103513 | 716 |
2172288 | 2172288 | 2022-02-01 | Dakota | Minnesota | 27037 | 102589 | 712 |
2169035 | 2169035 | 2022-01-31 | Dakota | Minnesota | 27037 | 101450 | 710 |
2165780 | 2165780 | 2022-01-30 | Dakota | Minnesota | 27037 | 100180 | 708 |
2162525 | 2162525 | 2022-01-29 | Dakota | Minnesota | 27037 | 100180 | 708 |
2159270 | 2159270 | 2022-01-28 | Dakota | Minnesota | 27037 | 100180 | 708 |
2156016 | 2156016 | 2022-01-27 | Dakota | Minnesota | 27037 | 99313 | 708 |
2152763 | 2152763 | 2022-01-26 | Dakota | Minnesota | 27037 | 97065 | 704 |
2149511 | 2149511 | 2022-01-25 | Dakota | Minnesota | 27037 | 96143 | 703 |
2146259 | 2146259 | 2022-01-24 | Dakota | Minnesota | 27037 | 94165 | 701 |
2143004 | 2143004 | 2022-01-23 | Dakota | Minnesota | 27037 | 93218 | 699 |
2139749 | 2139749 | 2022-01-22 | Dakota | Minnesota | 27037 | 93218 | 699 |
2136493 | 2136493 | 2022-01-21 | Dakota | Minnesota | 27037 | 93218 | 699 |
2133241 | 2133241 | 2022-01-20 | Dakota | Minnesota | 27037 | 90900 | 697 |
2129988 | 2129988 | 2022-01-19 | Dakota | Minnesota | 27037 | 89854 | 690 |
2126734 | 2126734 | 2022-01-18 | Dakota | Minnesota | 27037 | 87368 | 688 |
2123482 | 2123482 | 2022-01-17 | Dakota | Minnesota | 27037 | 86475 | 687 |
2120230 | 2120230 | 2022-01-16 | Dakota | Minnesota | 27037 | 86475 | 687 |
2116978 | 2116978 | 2022-01-15 | Dakota | Minnesota | 27037 | 86475 | 687 |
2113727 | 2113727 | 2022-01-14 | Dakota | Minnesota | 27037 | 86475 | 687 |
2110475 | 2110475 | 2022-01-13 | Dakota | Minnesota | 27037 | 85520 | 685 |
2107224 | 2107224 | 2022-01-12 | Dakota | Minnesota | 27037 | 84138 | 682 |
2103973 | 2103973 | 2022-01-11 | Dakota | Minnesota | 27037 | 83520 | 680 |
2100722 | 2100722 | 2022-01-10 | Dakota | Minnesota | 27037 | 81177 | 676 |
2097471 | 2097471 | 2022-01-09 | Dakota | Minnesota | 27037 | 80169 | 674 |
2094219 | 2094219 | 2022-01-08 | Dakota | Minnesota | 27037 | 80169 | 674 |
2090967 | 2090967 | 2022-01-07 | Dakota | Minnesota | 27037 | 80169 | 674 |
2087716 | 2087716 | 2022-01-06 | Dakota | Minnesota | 27037 | 79580 | 673 |
2084464 | 2084464 | 2022-01-05 | Dakota | Minnesota | 27037 | 78859 | 665 |
2081212 | 2081212 | 2022-01-04 | Dakota | Minnesota | 27037 | 78475 | 662 |
2077960 | 2077960 | 2022-01-03 | Dakota | Minnesota | 27037 | 77054 | 658 |
2074709 | 2074709 | 2022-01-02 | Dakota | Minnesota | 27037 | 76390 | 655 |
2071458 | 2071458 | 2022-01-01 | Dakota | Minnesota | 27037 | 76390 | 655 |
2068207 | 2068207 | 2021-12-31 | Dakota | Minnesota | 27037 | 76390 | 655 |
2064956 | 2064956 | 2021-12-30 | Dakota | Minnesota | 27037 | 76390 | 655 |
2061706 | 2061706 | 2021-12-29 | Dakota | Minnesota | 27037 | 75737 | 653 |
2058457 | 2058457 | 2021-12-28 | Dakota | Minnesota | 27037 | 75393 | 647 |
2055208 | 2055208 | 2021-12-27 | Dakota | Minnesota | 27037 | 74574 | 643 |
2051958 | 2051958 | 2021-12-26 | Dakota | Minnesota | 27037 | 74141 | 637 |
2048708 | 2048708 | 2021-12-25 | Dakota | Minnesota | 27037 | 74141 | 637 |
2045458 | 2045458 | 2021-12-24 | Dakota | Minnesota | 27037 | 74141 | 637 |
2042208 | 2042208 | 2021-12-23 | Dakota | Minnesota | 27037 | 74141 | 637 |
2038959 | 2038959 | 2021-12-22 | Dakota | Minnesota | 27037 | 73849 | 635 |
2035709 | 2035709 | 2021-12-21 | Dakota | Minnesota | 27037 | 73590 | 628 |
2032459 | 2032459 | 2021-12-20 | Dakota | Minnesota | 27037 | 73012 | 627 |
2029208 | 2029208 | 2021-12-19 | Dakota | Minnesota | 27037 | 72728 | 626 |
2025957 | 2025957 | 2021-12-18 | Dakota | Minnesota | 27037 | 72728 | 626 |
2022706 | 2022706 | 2021-12-17 | Dakota | Minnesota | 27037 | 72728 | 626 |
2019455 | 2019455 | 2021-12-16 | Dakota | Minnesota | 27037 | 72430 | 621 |
2016205 | 2016205 | 2021-12-15 | Dakota | Minnesota | 27037 | 72095 | 619 |
2012954 | 2012954 | 2021-12-14 | Dakota | Minnesota | 27037 | 71948 | 617 |
2009703 | 2009703 | 2021-12-13 | Dakota | Minnesota | 27037 | 71190 | 615 |
2006452 | 2006452 | 2021-12-12 | Dakota | Minnesota | 27037 | 70918 | 611 |
2003201 | 2003201 | 2021-12-11 | Dakota | Minnesota | 27037 | 70918 | 611 |
1999951 | 1999951 | 2021-12-10 | Dakota | Minnesota | 27037 | 70918 | 611 |
1996700 | 1996700 | 2021-12-09 | Dakota | Minnesota | 27037 | 70543 | 603 |
1993449 | 1993449 | 2021-12-08 | Dakota | Minnesota | 27037 | 70191 | 601 |
1990198 | 1990198 | 2021-12-07 | Dakota | Minnesota | 27037 | 69982 | 596 |
1986948 | 1986948 | 2021-12-06 | Dakota | Minnesota | 27037 | 68992 | 595 |
1983698 | 1983698 | 2021-12-05 | Dakota | Minnesota | 27037 | 68505 | 591 |
1980448 | 1980448 | 2021-12-04 | Dakota | Minnesota | 27037 | 68505 | 591 |
1977198 | 1977198 | 2021-12-03 | Dakota | Minnesota | 27037 | 68505 | 591 |
1973948 | 1973948 | 2021-12-02 | Dakota | Minnesota | 27037 | 68081 | 589 |
1970699 | 1970699 | 2021-12-01 | Dakota | Minnesota | 27037 | 67683 | 587 |
1967449 | 1967449 | 2021-11-30 | Dakota | Minnesota | 27037 | 67355 | 574 |
1964197 | 1964197 | 2021-11-29 | Dakota | Minnesota | 27037 | 66342 | 574 |
1960946 | 1960946 | 2021-11-28 | Dakota | Minnesota | 27037 | 66032 | 572 |
1957695 | 1957695 | 2021-11-27 | Dakota | Minnesota | 27037 | 66032 | 572 |
1954444 | 1954444 | 2021-11-26 | Dakota | Minnesota | 27037 | 66032 | 572 |
1951193 | 1951193 | 2021-11-25 | Dakota | Minnesota | 27037 | 65596 | 566 |
1947942 | 1947942 | 2021-11-24 | Dakota | Minnesota | 27037 | 65596 | 566 |
1944691 | 1944691 | 2021-11-23 | Dakota | Minnesota | 27037 | 65275 | 564 |
1941440 | 1941440 | 2021-11-22 | Dakota | Minnesota | 27037 | 64444 | 563 |
1938190 | 1938190 | 2021-11-21 | Dakota | Minnesota | 27037 | 64054 | 561 |
1934940 | 1934940 | 2021-11-20 | Dakota | Minnesota | 27037 | 64054 | 561 |
1931690 | 1931690 | 2021-11-19 | Dakota | Minnesota | 27037 | 64054 | 561 |
1928439 | 1928439 | 2021-11-18 | Dakota | Minnesota | 27037 | 63624 | 560 |
1925189 | 1925189 | 2021-11-17 | Dakota | Minnesota | 27037 | 63247 | 560 |
1921940 | 1921940 | 2021-11-16 | Dakota | Minnesota | 27037 | 62978 | 559 |
1918690 | 1918690 | 2021-11-15 | Dakota | Minnesota | 27037 | 62203 | 558 |
1915440 | 1915440 | 2021-11-14 | Dakota | Minnesota | 27037 | 61869 | 558 |
1912190 | 1912190 | 2021-11-13 | Dakota | Minnesota | 27037 | 61869 | 558 |
1908940 | 1908940 | 2021-11-12 | Dakota | Minnesota | 27037 | 61869 | 558 |
1905691 | 1905691 | 2021-11-11 | Dakota | Minnesota | 27037 | 61538 | 557 |
1902442 | 1902442 | 2021-11-10 | Dakota | Minnesota | 27037 | 61163 | 556 |
1899192 | 1899192 | 2021-11-09 | Dakota | Minnesota | 27037 | 60791 | 555 |
1895942 | 1895942 | 2021-11-08 | Dakota | Minnesota | 27037 | 60327 | 554 |
1892692 | 1892692 | 2021-11-07 | Dakota | Minnesota | 27037 | 60004 | 550 |
1889442 | 1889442 | 2021-11-06 | Dakota | Minnesota | 27037 | 60004 | 550 |
1886192 | 1886192 | 2021-11-05 | Dakota | Minnesota | 27037 | 60004 | 550 |
1882943 | 1882943 | 2021-11-04 | Dakota | Minnesota | 27037 | 59801 | 546 |
1879694 | 1879694 | 2021-11-03 | Dakota | Minnesota | 27037 | 59586 | 542 |
1876445 | 1876445 | 2021-11-02 | Dakota | Minnesota | 27037 | 59395 | 535 |
1873196 | 1873196 | 2021-11-01 | Dakota | Minnesota | 27037 | 58895 | 534 |
1869947 | 1869947 | 2021-10-31 | Dakota | Minnesota | 27037 | 58163 | 534 |
1866698 | 1866698 | 2021-10-30 | Dakota | Minnesota | 27037 | 58163 | 534 |
1863449 | 1863449 | 2021-10-29 | Dakota | Minnesota | 27037 | 58163 | 534 |
1860200 | 1860200 | 2021-10-28 | Dakota | Minnesota | 27037 | 57930 | 533 |
1856951 | 1856951 | 2021-10-27 | Dakota | Minnesota | 27037 | 57778 | 529 |
1853702 | 1853702 | 2021-10-26 | Dakota | Minnesota | 27037 | 57663 | 527 |
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);