ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 210 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1028904 | 1028904 | 2021-02-14 | Lake of the Woods | Minnesota | 27077 | 210 | 1 |
1025658 | 1025658 | 2021-02-13 | Lake of the Woods | Minnesota | 27077 | 210 | 1 |
743308 | 743308 | 2020-11-18 | Mahnomen | Minnesota | 27087 | 210 | 3 |
714103 | 714103 | 2020-11-09 | Koochiching | Minnesota | 27071 | 210 | 5 |
691406 | 691406 | 2020-11-02 | Lincoln | Minnesota | 27081 | 210 | 0 |
665450 | 665450 | 2020-10-25 | Jackson | Minnesota | 27063 | 210 | 1 |
626540 | 626540 | 2020-10-13 | Renville | Minnesota | 27129 | 210 | 10 |
620019 | 620019 | 2020-10-11 | Hubbard | Minnesota | 27057 | 210 | 1 |
590821 | 590821 | 2020-10-02 | Brown | Minnesota | 27015 | 210 | 2 |
535766 | 535766 | 2020-09-15 | Douglas | Minnesota | 27041 | 210 | 1 |
532527 | 532527 | 2020-09-14 | Cottonwood | Minnesota | 27033 | 210 | 0 |
532540 | 532540 | 2020-09-14 | Isanti | Minnesota | 27059 | 210 | 0 |
516339 | 516339 | 2020-09-09 | Carlton | Minnesota | 27017 | 210 | 1 |
513105 | 513105 | 2020-09-08 | Carlton | Minnesota | 27017 | 210 | 1 |
509873 | 509873 | 2020-09-07 | Carlton | Minnesota | 27017 | 210 | 1 |
435584 | 435584 | 2020-08-15 | Goodhue | Minnesota | 27049 | 210 | 9 |
429151 | 429151 | 2020-08-13 | Martin | Minnesota | 27091 | 210 | 5 |
406597 | 406597 | 2020-08-06 | Le Sueur | Minnesota | 27079 | 210 | 1 |
195067 | 195067 | 2020-05-31 | Carver | Minnesota | 27019 | 210 | 2 |
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);