ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 595 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1824474 | 1824474 | 2021-10-17 | Kittson | Minnesota | 27069 | 595 | 22 |
1821225 | 1821225 | 2021-10-16 | Kittson | Minnesota | 27069 | 595 | 22 |
1817976 | 1817976 | 2021-10-15 | Kittson | Minnesota | 27069 | 595 | 22 |
1678290 | 1678290 | 2021-09-02 | Norman | Minnesota | 27107 | 595 | 9 |
1652297 | 1652297 | 2021-08-25 | Mahnomen | Minnesota | 27087 | 595 | 9 |
1626343 | 1626343 | 2021-08-17 | Unknown | Minnesota | 595 | 93 | |
1606818 | 1606818 | 2021-08-11 | Lincoln | Minnesota | 27081 | 595 | 3 |
1603569 | 1603569 | 2021-08-10 | Lincoln | Minnesota | 27081 | 595 | 3 |
1587310 | 1587310 | 2021-08-05 | Grant | Minnesota | 27051 | 595 | 8 |
1584059 | 1584059 | 2021-08-04 | Grant | Minnesota | 27051 | 595 | 8 |
1580810 | 1580810 | 2021-08-03 | Grant | Minnesota | 27051 | 595 | 8 |
1577561 | 1577561 | 2021-08-02 | Grant | Minnesota | 27051 | 595 | 8 |
1574313 | 1574313 | 2021-08-01 | Grant | Minnesota | 27051 | 595 | 8 |
1571065 | 1571065 | 2021-07-31 | Grant | Minnesota | 27051 | 595 | 8 |
1567817 | 1567817 | 2021-07-30 | Grant | Minnesota | 27051 | 595 | 8 |
1564569 | 1564569 | 2021-07-29 | Grant | Minnesota | 27051 | 595 | 8 |
1561321 | 1561321 | 2021-07-28 | Grant | Minnesota | 27051 | 595 | 8 |
1558073 | 1558073 | 2021-07-27 | Grant | Minnesota | 27051 | 595 | 8 |
1554826 | 1554826 | 2021-07-26 | Grant | Minnesota | 27051 | 595 | 8 |
1551579 | 1551579 | 2021-07-25 | Grant | Minnesota | 27051 | 595 | 8 |
1548332 | 1548332 | 2021-07-24 | Grant | Minnesota | 27051 | 595 | 8 |
1545085 | 1545085 | 2021-07-23 | Grant | Minnesota | 27051 | 595 | 8 |
1541837 | 1541837 | 2021-07-22 | Grant | Minnesota | 27051 | 595 | 8 |
1535343 | 1535343 | 2021-07-20 | Grant | Minnesota | 27051 | 595 | 8 |
1486640 | 1486640 | 2021-07-05 | Grant | Minnesota | 27051 | 595 | 8 |
1483394 | 1483394 | 2021-07-04 | Grant | Minnesota | 27051 | 595 | 8 |
1480148 | 1480148 | 2021-07-03 | Grant | Minnesota | 27051 | 595 | 8 |
1476901 | 1476901 | 2021-07-02 | Grant | Minnesota | 27051 | 595 | 8 |
1295106 | 1295106 | 2021-05-07 | Big Stone | Minnesota | 27011 | 595 | 4 |
941270 | 941270 | 2021-01-18 | Koochiching | Minnesota | 27071 | 595 | 10 |
814707 | 814707 | 2020-12-10 | Marshall | Minnesota | 27089 | 595 | 11 |
804960 | 804960 | 2020-12-07 | Jackson | Minnesota | 27063 | 595 | 1 |
782265 | 782265 | 2020-11-30 | Murray | Minnesota | 27101 | 595 | 3 |
380893 | 380893 | 2020-07-29 | Sherburne | Minnesota | 27141 | 595 | 6 |
332793 | 332793 | 2020-07-14 | Kandiyohi | Minnesota | 27067 | 595 | 1 |
329606 | 329606 | 2020-07-13 | Kandiyohi | Minnesota | 27067 | 595 | 1 |
313689 | 313689 | 2020-07-08 | Clay | Minnesota | 27027 | 595 | 38 |
266444 | 266444 | 2020-06-23 | Scott | Minnesota | 27139 | 595 | 4 |
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);