ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "Lac qui Parle", deaths = 25 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);