ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lac qui Parle" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110493 | 2110493 | 2022-01-13 | Lac qui Parle | Minnesota | 27073 | 1404 | 26 |
2107242 | 2107242 | 2022-01-12 | Lac qui Parle | Minnesota | 27073 | 1400 | 26 |
2103991 | 2103991 | 2022-01-11 | Lac qui Parle | Minnesota | 27073 | 1393 | 26 |
2100740 | 2100740 | 2022-01-10 | Lac qui Parle | Minnesota | 27073 | 1375 | 26 |
2097489 | 2097489 | 2022-01-09 | Lac qui Parle | Minnesota | 27073 | 1371 | 26 |
2094237 | 2094237 | 2022-01-08 | Lac qui Parle | Minnesota | 27073 | 1371 | 26 |
2090985 | 2090985 | 2022-01-07 | Lac qui Parle | Minnesota | 27073 | 1371 | 26 |
2087734 | 2087734 | 2022-01-06 | Lac qui Parle | Minnesota | 27073 | 1366 | 26 |
2084482 | 2084482 | 2022-01-05 | Lac qui Parle | Minnesota | 27073 | 1354 | 26 |
2081230 | 2081230 | 2022-01-04 | Lac qui Parle | Minnesota | 27073 | 1351 | 26 |
2077978 | 2077978 | 2022-01-03 | Lac qui Parle | Minnesota | 27073 | 1341 | 26 |
2074727 | 2074727 | 2022-01-02 | Lac qui Parle | Minnesota | 27073 | 1341 | 26 |
2071476 | 2071476 | 2022-01-01 | Lac qui Parle | Minnesota | 27073 | 1341 | 26 |
2068225 | 2068225 | 2021-12-31 | Lac qui Parle | Minnesota | 27073 | 1341 | 26 |
2064974 | 2064974 | 2021-12-30 | Lac qui Parle | Minnesota | 27073 | 1341 | 26 |
2061724 | 2061724 | 2021-12-29 | Lac qui Parle | Minnesota | 27073 | 1335 | 26 |
2058475 | 2058475 | 2021-12-28 | Lac qui Parle | Minnesota | 27073 | 1334 | 26 |
2055226 | 2055226 | 2021-12-27 | Lac qui Parle | Minnesota | 27073 | 1326 | 26 |
2051976 | 2051976 | 2021-12-26 | Lac qui Parle | Minnesota | 27073 | 1320 | 26 |
2048726 | 2048726 | 2021-12-25 | Lac qui Parle | Minnesota | 27073 | 1320 | 26 |
2045476 | 2045476 | 2021-12-24 | Lac qui Parle | Minnesota | 27073 | 1320 | 26 |
2042226 | 2042226 | 2021-12-23 | Lac qui Parle | Minnesota | 27073 | 1320 | 26 |
2038977 | 2038977 | 2021-12-22 | Lac qui Parle | Minnesota | 27073 | 1313 | 26 |
2035727 | 2035727 | 2021-12-21 | Lac qui Parle | Minnesota | 27073 | 1307 | 26 |
2032477 | 2032477 | 2021-12-20 | Lac qui Parle | Minnesota | 27073 | 1303 | 26 |
2029226 | 2029226 | 2021-12-19 | Lac qui Parle | Minnesota | 27073 | 1293 | 26 |
2025975 | 2025975 | 2021-12-18 | Lac qui Parle | Minnesota | 27073 | 1293 | 26 |
2022724 | 2022724 | 2021-12-17 | Lac qui Parle | Minnesota | 27073 | 1293 | 26 |
2019473 | 2019473 | 2021-12-16 | Lac qui Parle | Minnesota | 27073 | 1292 | 26 |
2016223 | 2016223 | 2021-12-15 | Lac qui Parle | Minnesota | 27073 | 1285 | 26 |
2012972 | 2012972 | 2021-12-14 | Lac qui Parle | Minnesota | 27073 | 1280 | 26 |
2009721 | 2009721 | 2021-12-13 | Lac qui Parle | Minnesota | 27073 | 1271 | 26 |
2006470 | 2006470 | 2021-12-12 | Lac qui Parle | Minnesota | 27073 | 1266 | 26 |
2003219 | 2003219 | 2021-12-11 | Lac qui Parle | Minnesota | 27073 | 1266 | 26 |
1999969 | 1999969 | 2021-12-10 | Lac qui Parle | Minnesota | 27073 | 1266 | 26 |
1996718 | 1996718 | 2021-12-09 | Lac qui Parle | Minnesota | 27073 | 1263 | 26 |
1993467 | 1993467 | 2021-12-08 | Lac qui Parle | Minnesota | 27073 | 1260 | 26 |
1990216 | 1990216 | 2021-12-07 | Lac qui Parle | Minnesota | 27073 | 1253 | 26 |
1986966 | 1986966 | 2021-12-06 | Lac qui Parle | Minnesota | 27073 | 1245 | 25 |
1983716 | 1983716 | 2021-12-05 | Lac qui Parle | Minnesota | 27073 | 1244 | 25 |
1980466 | 1980466 | 2021-12-04 | Lac qui Parle | Minnesota | 27073 | 1244 | 25 |
1977216 | 1977216 | 2021-12-03 | Lac qui Parle | Minnesota | 27073 | 1244 | 25 |
1973966 | 1973966 | 2021-12-02 | Lac qui Parle | Minnesota | 27073 | 1235 | 25 |
1970717 | 1970717 | 2021-12-01 | Lac qui Parle | Minnesota | 27073 | 1230 | 25 |
1967467 | 1967467 | 2021-11-30 | Lac qui Parle | Minnesota | 27073 | 1221 | 25 |
1964215 | 1964215 | 2021-11-29 | Lac qui Parle | Minnesota | 27073 | 1208 | 25 |
1960964 | 1960964 | 2021-11-28 | Lac qui Parle | Minnesota | 27073 | 1200 | 25 |
1957713 | 1957713 | 2021-11-27 | Lac qui Parle | Minnesota | 27073 | 1200 | 25 |
1954462 | 1954462 | 2021-11-26 | Lac qui Parle | Minnesota | 27073 | 1200 | 25 |
1951211 | 1951211 | 2021-11-25 | Lac qui Parle | Minnesota | 27073 | 1194 | 25 |
1947960 | 1947960 | 2021-11-24 | Lac qui Parle | Minnesota | 27073 | 1194 | 25 |
1944709 | 1944709 | 2021-11-23 | Lac qui Parle | Minnesota | 27073 | 1184 | 25 |
1941458 | 1941458 | 2021-11-22 | Lac qui Parle | Minnesota | 27073 | 1171 | 25 |
1938208 | 1938208 | 2021-11-21 | Lac qui Parle | Minnesota | 27073 | 1167 | 25 |
1934958 | 1934958 | 2021-11-20 | Lac qui Parle | Minnesota | 27073 | 1167 | 25 |
1931708 | 1931708 | 2021-11-19 | Lac qui Parle | Minnesota | 27073 | 1167 | 25 |
1928457 | 1928457 | 2021-11-18 | Lac qui Parle | Minnesota | 27073 | 1164 | 25 |
1925207 | 1925207 | 2021-11-17 | Lac qui Parle | Minnesota | 27073 | 1158 | 25 |
1921958 | 1921958 | 2021-11-16 | Lac qui Parle | Minnesota | 27073 | 1152 | 25 |
1918708 | 1918708 | 2021-11-15 | Lac qui Parle | Minnesota | 27073 | 1143 | 25 |
1915458 | 1915458 | 2021-11-14 | Lac qui Parle | Minnesota | 27073 | 1129 | 25 |
1912208 | 1912208 | 2021-11-13 | Lac qui Parle | Minnesota | 27073 | 1129 | 25 |
1908958 | 1908958 | 2021-11-12 | Lac qui Parle | Minnesota | 27073 | 1129 | 25 |
1905709 | 1905709 | 2021-11-11 | Lac qui Parle | Minnesota | 27073 | 1109 | 25 |
1902460 | 1902460 | 2021-11-10 | Lac qui Parle | Minnesota | 27073 | 1103 | 25 |
1899210 | 1899210 | 2021-11-09 | Lac qui Parle | Minnesota | 27073 | 1100 | 25 |
1895960 | 1895960 | 2021-11-08 | Lac qui Parle | Minnesota | 27073 | 1093 | 25 |
1892710 | 1892710 | 2021-11-07 | Lac qui Parle | Minnesota | 27073 | 1083 | 25 |
1889460 | 1889460 | 2021-11-06 | Lac qui Parle | Minnesota | 27073 | 1083 | 25 |
1886210 | 1886210 | 2021-11-05 | Lac qui Parle | Minnesota | 27073 | 1083 | 25 |
1882961 | 1882961 | 2021-11-04 | Lac qui Parle | Minnesota | 27073 | 1071 | 25 |
1879712 | 1879712 | 2021-11-03 | Lac qui Parle | Minnesota | 27073 | 1063 | 25 |
1876463 | 1876463 | 2021-11-02 | Lac qui Parle | Minnesota | 27073 | 1055 | 25 |
1873214 | 1873214 | 2021-11-01 | Lac qui Parle | Minnesota | 27073 | 1045 | 25 |
1869965 | 1869965 | 2021-10-31 | Lac qui Parle | Minnesota | 27073 | 1017 | 25 |
1866716 | 1866716 | 2021-10-30 | Lac qui Parle | Minnesota | 27073 | 1017 | 25 |
1863467 | 1863467 | 2021-10-29 | Lac qui Parle | Minnesota | 27073 | 1017 | 25 |
1860218 | 1860218 | 2021-10-28 | Lac qui Parle | Minnesota | 27073 | 1017 | 25 |
1856969 | 1856969 | 2021-10-27 | Lac qui Parle | Minnesota | 27073 | 1004 | 25 |
1853720 | 1853720 | 2021-10-26 | Lac qui Parle | Minnesota | 27073 | 1003 | 24 |
1850471 | 1850471 | 2021-10-25 | Lac qui Parle | Minnesota | 27073 | 996 | 24 |
1847221 | 1847221 | 2021-10-24 | Lac qui Parle | Minnesota | 27073 | 985 | 24 |
1843971 | 1843971 | 2021-10-23 | Lac qui Parle | Minnesota | 27073 | 985 | 24 |
1840721 | 1840721 | 2021-10-22 | Lac qui Parle | Minnesota | 27073 | 985 | 24 |
1837472 | 1837472 | 2021-10-21 | Lac qui Parle | Minnesota | 27073 | 983 | 24 |
1834223 | 1834223 | 2021-10-20 | Lac qui Parle | Minnesota | 27073 | 979 | 24 |
1830974 | 1830974 | 2021-10-19 | Lac qui Parle | Minnesota | 27073 | 975 | 24 |
1827725 | 1827725 | 2021-10-18 | Lac qui Parle | Minnesota | 27073 | 957 | 24 |
1824476 | 1824476 | 2021-10-17 | Lac qui Parle | Minnesota | 27073 | 950 | 24 |
1821227 | 1821227 | 2021-10-16 | Lac qui Parle | Minnesota | 27073 | 950 | 24 |
1817978 | 1817978 | 2021-10-15 | Lac qui Parle | Minnesota | 27073 | 950 | 24 |
1814729 | 1814729 | 2021-10-14 | Lac qui Parle | Minnesota | 27073 | 947 | 24 |
1811481 | 1811481 | 2021-10-13 | Lac qui Parle | Minnesota | 27073 | 942 | 24 |
1808232 | 1808232 | 2021-10-12 | Lac qui Parle | Minnesota | 27073 | 942 | 24 |
1804981 | 1804981 | 2021-10-11 | Lac qui Parle | Minnesota | 27073 | 932 | 24 |
1801732 | 1801732 | 2021-10-10 | Lac qui Parle | Minnesota | 27073 | 928 | 24 |
1798483 | 1798483 | 2021-10-09 | Lac qui Parle | Minnesota | 27073 | 928 | 24 |
1795234 | 1795234 | 2021-10-08 | Lac qui Parle | Minnesota | 27073 | 928 | 24 |
1791985 | 1791985 | 2021-10-07 | Lac qui Parle | Minnesota | 27073 | 927 | 24 |
1788736 | 1788736 | 2021-10-06 | Lac qui Parle | Minnesota | 27073 | 921 | 24 |
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);