ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 27099 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110506 | 2110506 | 2022-01-13 | Mower | Minnesota | 27099 | 8984 | 58 |
2107255 | 2107255 | 2022-01-12 | Mower | Minnesota | 27099 | 8890 | 58 |
2104004 | 2104004 | 2022-01-11 | Mower | Minnesota | 27099 | 8720 | 58 |
2100753 | 2100753 | 2022-01-10 | Mower | Minnesota | 27099 | 8456 | 58 |
2097502 | 2097502 | 2022-01-09 | Mower | Minnesota | 27099 | 8365 | 58 |
2094250 | 2094250 | 2022-01-08 | Mower | Minnesota | 27099 | 8365 | 58 |
2090998 | 2090998 | 2022-01-07 | Mower | Minnesota | 27099 | 8365 | 58 |
2087747 | 2087747 | 2022-01-06 | Mower | Minnesota | 27099 | 8307 | 58 |
2084495 | 2084495 | 2022-01-05 | Mower | Minnesota | 27099 | 8252 | 56 |
2081243 | 2081243 | 2022-01-04 | Mower | Minnesota | 27099 | 8211 | 56 |
2077991 | 2077991 | 2022-01-03 | Mower | Minnesota | 27099 | 7992 | 55 |
2074740 | 2074740 | 2022-01-02 | Mower | Minnesota | 27099 | 7941 | 55 |
2071489 | 2071489 | 2022-01-01 | Mower | Minnesota | 27099 | 7941 | 55 |
2068238 | 2068238 | 2021-12-31 | Mower | Minnesota | 27099 | 7941 | 55 |
2064987 | 2064987 | 2021-12-30 | Mower | Minnesota | 27099 | 7941 | 55 |
2061737 | 2061737 | 2021-12-29 | Mower | Minnesota | 27099 | 7898 | 54 |
2058488 | 2058488 | 2021-12-28 | Mower | Minnesota | 27099 | 7883 | 53 |
2055239 | 2055239 | 2021-12-27 | Mower | Minnesota | 27099 | 7814 | 53 |
2051989 | 2051989 | 2021-12-26 | Mower | Minnesota | 27099 | 7802 | 53 |
2048739 | 2048739 | 2021-12-25 | Mower | Minnesota | 27099 | 7802 | 53 |
2045489 | 2045489 | 2021-12-24 | Mower | Minnesota | 27099 | 7802 | 53 |
2042239 | 2042239 | 2021-12-23 | Mower | Minnesota | 27099 | 7802 | 53 |
2038990 | 2038990 | 2021-12-22 | Mower | Minnesota | 27099 | 7788 | 53 |
2035740 | 2035740 | 2021-12-21 | Mower | Minnesota | 27099 | 7774 | 52 |
2032490 | 2032490 | 2021-12-20 | Mower | Minnesota | 27099 | 7726 | 51 |
2029239 | 2029239 | 2021-12-19 | Mower | Minnesota | 27099 | 7700 | 50 |
2025988 | 2025988 | 2021-12-18 | Mower | Minnesota | 27099 | 7700 | 50 |
2022737 | 2022737 | 2021-12-17 | Mower | Minnesota | 27099 | 7700 | 50 |
2019486 | 2019486 | 2021-12-16 | Mower | Minnesota | 27099 | 7686 | 50 |
2016236 | 2016236 | 2021-12-15 | Mower | Minnesota | 27099 | 7668 | 50 |
2012985 | 2012985 | 2021-12-14 | Mower | Minnesota | 27099 | 7660 | 50 |
2009734 | 2009734 | 2021-12-13 | Mower | Minnesota | 27099 | 7591 | 50 |
2006483 | 2006483 | 2021-12-12 | Mower | Minnesota | 27099 | 7567 | 50 |
2003232 | 2003232 | 2021-12-11 | Mower | Minnesota | 27099 | 7567 | 50 |
1999982 | 1999982 | 2021-12-10 | Mower | Minnesota | 27099 | 7567 | 50 |
1996731 | 1996731 | 2021-12-09 | Mower | Minnesota | 27099 | 7549 | 50 |
1993480 | 1993480 | 2021-12-08 | Mower | Minnesota | 27099 | 7526 | 50 |
1990229 | 1990229 | 2021-12-07 | Mower | Minnesota | 27099 | 7513 | 50 |
1986979 | 1986979 | 2021-12-06 | Mower | Minnesota | 27099 | 7438 | 49 |
1983729 | 1983729 | 2021-12-05 | Mower | Minnesota | 27099 | 7400 | 49 |
1980479 | 1980479 | 2021-12-04 | Mower | Minnesota | 27099 | 7400 | 49 |
1977229 | 1977229 | 2021-12-03 | Mower | Minnesota | 27099 | 7400 | 49 |
1973979 | 1973979 | 2021-12-02 | Mower | Minnesota | 27099 | 7363 | 49 |
1970730 | 1970730 | 2021-12-01 | Mower | Minnesota | 27099 | 7334 | 49 |
1967480 | 1967480 | 2021-11-30 | Mower | Minnesota | 27099 | 7312 | 49 |
1964228 | 1964228 | 2021-11-29 | Mower | Minnesota | 27099 | 7237 | 49 |
1960977 | 1960977 | 2021-11-28 | Mower | Minnesota | 27099 | 7213 | 49 |
1957726 | 1957726 | 2021-11-27 | Mower | Minnesota | 27099 | 7213 | 49 |
1954475 | 1954475 | 2021-11-26 | Mower | Minnesota | 27099 | 7213 | 49 |
1951224 | 1951224 | 2021-11-25 | Mower | Minnesota | 27099 | 7202 | 47 |
1947973 | 1947973 | 2021-11-24 | Mower | Minnesota | 27099 | 7202 | 47 |
1944722 | 1944722 | 2021-11-23 | Mower | Minnesota | 27099 | 7186 | 46 |
1941471 | 1941471 | 2021-11-22 | Mower | Minnesota | 27099 | 7119 | 46 |
1938221 | 1938221 | 2021-11-21 | Mower | Minnesota | 27099 | 7110 | 46 |
1934971 | 1934971 | 2021-11-20 | Mower | Minnesota | 27099 | 7110 | 46 |
1931721 | 1931721 | 2021-11-19 | Mower | Minnesota | 27099 | 7110 | 46 |
1928470 | 1928470 | 2021-11-18 | Mower | Minnesota | 27099 | 7073 | 46 |
1925220 | 1925220 | 2021-11-17 | Mower | Minnesota | 27099 | 7055 | 46 |
1921971 | 1921971 | 2021-11-16 | Mower | Minnesota | 27099 | 7036 | 46 |
1918721 | 1918721 | 2021-11-15 | Mower | Minnesota | 27099 | 6980 | 46 |
1915471 | 1915471 | 2021-11-14 | Mower | Minnesota | 27099 | 6957 | 46 |
1912221 | 1912221 | 2021-11-13 | Mower | Minnesota | 27099 | 6957 | 46 |
1908971 | 1908971 | 2021-11-12 | Mower | Minnesota | 27099 | 6957 | 46 |
1905722 | 1905722 | 2021-11-11 | Mower | Minnesota | 27099 | 6928 | 46 |
1902473 | 1902473 | 2021-11-10 | Mower | Minnesota | 27099 | 6906 | 45 |
1899223 | 1899223 | 2021-11-09 | Mower | Minnesota | 27099 | 6883 | 45 |
1895973 | 1895973 | 2021-11-08 | Mower | Minnesota | 27099 | 6848 | 45 |
1892723 | 1892723 | 2021-11-07 | Mower | Minnesota | 27099 | 6822 | 45 |
1889473 | 1889473 | 2021-11-06 | Mower | Minnesota | 27099 | 6822 | 45 |
1886223 | 1886223 | 2021-11-05 | Mower | Minnesota | 27099 | 6822 | 45 |
1882974 | 1882974 | 2021-11-04 | Mower | Minnesota | 27099 | 6793 | 45 |
1879725 | 1879725 | 2021-11-03 | Mower | Minnesota | 27099 | 6763 | 44 |
1876476 | 1876476 | 2021-11-02 | Mower | Minnesota | 27099 | 6752 | 43 |
1873227 | 1873227 | 2021-11-01 | Mower | Minnesota | 27099 | 6699 | 42 |
1869978 | 1869978 | 2021-10-31 | Mower | Minnesota | 27099 | 6612 | 42 |
1866729 | 1866729 | 2021-10-30 | Mower | Minnesota | 27099 | 6612 | 42 |
1863480 | 1863480 | 2021-10-29 | Mower | Minnesota | 27099 | 6612 | 42 |
1860231 | 1860231 | 2021-10-28 | Mower | Minnesota | 27099 | 6581 | 42 |
1856982 | 1856982 | 2021-10-27 | Mower | Minnesota | 27099 | 6566 | 41 |
1853733 | 1853733 | 2021-10-26 | Mower | Minnesota | 27099 | 6563 | 41 |
1850484 | 1850484 | 2021-10-25 | Mower | Minnesota | 27099 | 6475 | 41 |
1847234 | 1847234 | 2021-10-24 | Mower | Minnesota | 27099 | 6455 | 41 |
1843984 | 1843984 | 2021-10-23 | Mower | Minnesota | 27099 | 6455 | 41 |
1840734 | 1840734 | 2021-10-22 | Mower | Minnesota | 27099 | 6455 | 41 |
1837485 | 1837485 | 2021-10-21 | Mower | Minnesota | 27099 | 6454 | 40 |
1834236 | 1834236 | 2021-10-20 | Mower | Minnesota | 27099 | 6428 | 40 |
1830987 | 1830987 | 2021-10-19 | Mower | Minnesota | 27099 | 6422 | 40 |
1827738 | 1827738 | 2021-10-18 | Mower | Minnesota | 27099 | 6353 | 40 |
1824489 | 1824489 | 2021-10-17 | Mower | Minnesota | 27099 | 6317 | 40 |
1821240 | 1821240 | 2021-10-16 | Mower | Minnesota | 27099 | 6317 | 40 |
1817991 | 1817991 | 2021-10-15 | Mower | Minnesota | 27099 | 6317 | 40 |
1814742 | 1814742 | 2021-10-14 | Mower | Minnesota | 27099 | 6289 | 40 |
1811494 | 1811494 | 2021-10-13 | Mower | Minnesota | 27099 | 6269 | 39 |
1808245 | 1808245 | 2021-10-12 | Mower | Minnesota | 27099 | 6252 | 39 |
1804994 | 1804994 | 2021-10-11 | Mower | Minnesota | 27099 | 6178 | 39 |
1801745 | 1801745 | 2021-10-10 | Mower | Minnesota | 27099 | 6137 | 39 |
1798496 | 1798496 | 2021-10-09 | Mower | Minnesota | 27099 | 6137 | 39 |
1795247 | 1795247 | 2021-10-08 | Mower | Minnesota | 27099 | 6137 | 39 |
1791998 | 1791998 | 2021-10-07 | Mower | Minnesota | 27099 | 6103 | 39 |
1788749 | 1788749 | 2021-10-06 | Mower | Minnesota | 27099 | 6067 | 39 |
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);