ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 482 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2165777 | 2165777 | 2022-01-30 | Cook | Minnesota | 27031 | 482 | 2 |
2162522 | 2162522 | 2022-01-29 | Cook | Minnesota | 27031 | 482 | 2 |
2159267 | 2159267 | 2022-01-28 | Cook | Minnesota | 27031 | 482 | 2 |
1856971 | 1856971 | 2021-10-27 | Lake of the Woods | Minnesota | 27077 | 482 | 4 |
1853722 | 1853722 | 2021-10-26 | Lake of the Woods | Minnesota | 27077 | 482 | 4 |
1801773 | 1801773 | 2021-10-10 | Traverse | Minnesota | 27155 | 482 | 5 |
1798524 | 1798524 | 2021-10-09 | Traverse | Minnesota | 27155 | 482 | 5 |
1795275 | 1795275 | 2021-10-08 | Traverse | Minnesota | 27155 | 482 | 5 |
1291889 | 1291889 | 2021-05-06 | Kittson | Minnesota | 27069 | 482 | 22 |
1285397 | 1285397 | 2021-05-04 | Kittson | Minnesota | 27069 | 482 | 22 |
1197726 | 1197726 | 2021-04-07 | Mahnomen | Minnesota | 27087 | 482 | 7 |
1054858 | 1054858 | 2021-02-22 | Grant | Minnesota | 27051 | 482 | 8 |
1045118 | 1045118 | 2021-02-19 | Grant | Minnesota | 27051 | 482 | 8 |
1009473 | 1009473 | 2021-02-08 | Unknown | Minnesota | 482 | 68 | |
938030 | 938030 | 2021-01-17 | Lincoln | Minnesota | 27081 | 482 | 1 |
934785 | 934785 | 2021-01-16 | Lincoln | Minnesota | 27081 | 482 | 1 |
856937 | 856937 | 2020-12-23 | Unknown | Minnesota | 482 | 60 | |
817945 | 817945 | 2020-12-11 | Koochiching | Minnesota | 27071 | 482 | 6 |
759558 | 759558 | 2020-11-23 | Pope | Minnesota | 27121 | 482 | 0 |
753037 | 753037 | 2020-11-21 | Kanabec | Minnesota | 27065 | 482 | 11 |
733556 | 733556 | 2020-11-15 | Houston | Minnesota | 27055 | 482 | 2 |
539066 | 539066 | 2020-09-16 | Watonwan | Minnesota | 27165 | 482 | 4 |
213572 | 213572 | 2020-06-06 | Mower | Minnesota | 27099 | 482 | 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);