ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 401 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 |
---|---|---|---|---|---|---|---|
1671818 | 1671818 | 2021-08-31 | Traverse | Minnesota | 27155 | 401 | 5 |
1473692 | 1473692 | 2021-07-01 | Red Lake | Minnesota | 27125 | 401 | 7 |
1470446 | 1470446 | 2021-06-30 | Red Lake | Minnesota | 27125 | 401 | 7 |
1467201 | 1467201 | 2021-06-29 | Red Lake | Minnesota | 27125 | 401 | 7 |
1463956 | 1463956 | 2021-06-28 | Red Lake | Minnesota | 27125 | 401 | 7 |
1460711 | 1460711 | 2021-06-27 | Red Lake | Minnesota | 27125 | 401 | 7 |
1457466 | 1457466 | 2021-06-26 | Red Lake | Minnesota | 27125 | 401 | 7 |
1454221 | 1454221 | 2021-06-25 | Red Lake | Minnesota | 27125 | 401 | 7 |
1450976 | 1450976 | 2021-06-24 | Red Lake | Minnesota | 27125 | 401 | 7 |
1447730 | 1447730 | 2021-06-23 | Red Lake | Minnesota | 27125 | 401 | 7 |
1444485 | 1444485 | 2021-06-22 | Red Lake | Minnesota | 27125 | 401 | 7 |
1441240 | 1441240 | 2021-06-21 | Red Lake | Minnesota | 27125 | 401 | 7 |
1437994 | 1437994 | 2021-06-20 | Red Lake | Minnesota | 27125 | 401 | 7 |
1434747 | 1434747 | 2021-06-19 | Red Lake | Minnesota | 27125 | 401 | 7 |
1431500 | 1431500 | 2021-06-18 | Red Lake | Minnesota | 27125 | 401 | 7 |
1428255 | 1428255 | 2021-06-17 | Red Lake | Minnesota | 27125 | 401 | 7 |
1425010 | 1425010 | 2021-06-16 | Red Lake | Minnesota | 27125 | 401 | 7 |
1421762 | 1421762 | 2021-06-15 | Red Lake | Minnesota | 27125 | 401 | 7 |
1418517 | 1418517 | 2021-06-14 | Red Lake | Minnesota | 27125 | 401 | 7 |
1415272 | 1415272 | 2021-06-13 | Red Lake | Minnesota | 27125 | 401 | 7 |
1412026 | 1412026 | 2021-06-12 | Red Lake | Minnesota | 27125 | 401 | 7 |
1408781 | 1408781 | 2021-06-11 | Red Lake | Minnesota | 27125 | 401 | 7 |
1405536 | 1405536 | 2021-06-10 | Red Lake | Minnesota | 27125 | 401 | 7 |
1402290 | 1402290 | 2021-06-09 | Red Lake | Minnesota | 27125 | 401 | 7 |
1399045 | 1399045 | 2021-06-08 | Red Lake | Minnesota | 27125 | 401 | 7 |
1395799 | 1395799 | 2021-06-07 | Red Lake | Minnesota | 27125 | 401 | 7 |
1392553 | 1392553 | 2021-06-06 | Red Lake | Minnesota | 27125 | 401 | 7 |
1389308 | 1389308 | 2021-06-05 | Red Lake | Minnesota | 27125 | 401 | 7 |
1386063 | 1386063 | 2021-06-04 | Red Lake | Minnesota | 27125 | 401 | 7 |
1382818 | 1382818 | 2021-06-03 | Red Lake | Minnesota | 27125 | 401 | 7 |
1379572 | 1379572 | 2021-06-02 | Red Lake | Minnesota | 27125 | 401 | 7 |
1376327 | 1376327 | 2021-06-01 | Red Lake | Minnesota | 27125 | 401 | 7 |
1373081 | 1373081 | 2021-05-31 | Red Lake | Minnesota | 27125 | 401 | 7 |
1369836 | 1369836 | 2021-05-30 | Red Lake | Minnesota | 27125 | 401 | 7 |
1366590 | 1366590 | 2021-05-29 | Red Lake | Minnesota | 27125 | 401 | 7 |
1363344 | 1363344 | 2021-05-28 | Red Lake | Minnesota | 27125 | 401 | 7 |
1360097 | 1360097 | 2021-05-27 | Red Lake | Minnesota | 27125 | 401 | 7 |
736796 | 736796 | 2020-11-16 | Faribault | Minnesota | 27043 | 401 | 0 |
727091 | 727091 | 2020-11-13 | Murray | Minnesota | 27101 | 401 | 3 |
717328 | 717328 | 2020-11-10 | Cottonwood | Minnesota | 27033 | 401 | 0 |
691432 | 691432 | 2020-11-02 | Rock | Minnesota | 27133 | 401 | 6 |
662221 | 662221 | 2020-10-24 | Mille Lacs | Minnesota | 27095 | 401 | 15 |
519611 | 519611 | 2020-09-10 | McLeod | Minnesota | 27085 | 401 | 1 |
500204 | 500204 | 2020-09-04 | Le Sueur | Minnesota | 27079 | 401 | 2 |
487254 | 487254 | 2020-08-31 | Freeborn | Minnesota | 27047 | 401 | 1 |
471138 | 471138 | 2020-08-26 | Steele | Minnesota | 27147 | 401 | 2 |
371221 | 371221 | 2020-07-26 | Lyon | Minnesota | 27083 | 401 | 3 |
310581 | 310581 | 2020-07-07 | Todd | Minnesota | 27153 | 401 | 2 |
307413 | 307413 | 2020-07-06 | Todd | Minnesota | 27153 | 401 | 2 |
304246 | 304246 | 2020-07-05 | Todd | Minnesota | 27153 | 401 | 2 |
260207 | 260207 | 2020-06-21 | Wright | Minnesota | 27171 | 401 | 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);