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