ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 180 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1629527 | 1629527 | 2021-08-18 | Cook | Minnesota | 27031 | 180 | 0 |
934783 | 934783 | 2021-01-16 | Lake of the Woods | Minnesota | 27077 | 180 | 1 |
707664 | 707664 | 2020-11-07 | Wilkin | Minnesota | 27167 | 180 | 4 |
642731 | 642731 | 2020-10-18 | Houston | Minnesota | 27055 | 180 | 1 |
639489 | 639489 | 2020-10-17 | Kanabec | Minnesota | 27065 | 180 | 10 |
584396 | 584396 | 2020-09-30 | Redwood | Minnesota | 27127 | 180 | 5 |
571377 | 571377 | 2020-09-26 | Cass | Minnesota | 27021 | 180 | 4 |
561724 | 561724 | 2020-09-23 | Wabasha | Minnesota | 27157 | 180 | 0 |
555178 | 555178 | 2020-09-21 | Brown | Minnesota | 27015 | 180 | 2 |
555250 | 555250 | 2020-09-21 | Wabasha | Minnesota | 27157 | 180 | 0 |
538994 | 538994 | 2020-09-16 | Chippewa | Minnesota | 27023 | 180 | 1 |
529332 | 529332 | 2020-09-13 | Pine | Minnesota | 27115 | 180 | 0 |
477588 | 477588 | 2020-08-28 | Pipestone | Minnesota | 27117 | 180 | 9 |
467894 | 467894 | 2020-08-25 | Polk | Minnesota | 27119 | 180 | 4 |
445319 | 445319 | 2020-08-18 | Waseca | Minnesota | 27161 | 180 | 1 |
435576 | 435576 | 2020-08-15 | Cottonwood | Minnesota | 27033 | 180 | 0 |
432350 | 432350 | 2020-08-14 | Cottonwood | Minnesota | 27033 | 180 | 0 |
400201 | 400201 | 2020-08-04 | Unknown | Minnesota | 180 | 40 | |
396987 | 396987 | 2020-08-03 | Unknown | Minnesota | 180 | 40 | |
384044 | 384044 | 2020-07-30 | Beltrami | Minnesota | 27007 | 180 | 0 |
335996 | 335996 | 2020-07-15 | Martin | Minnesota | 27091 | 180 | 5 |
307408 | 307408 | 2020-07-06 | St. Louis | Minnesota | 27137 | 180 | 15 |
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);