ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 561 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426017 | 2426017 | 2022-04-20 | Cook | Minnesota | 27031 | 561 | 4 |
2422761 | 2422761 | 2022-04-19 | Cook | Minnesota | 27031 | 561 | 4 |
2055228 | 2055228 | 2021-12-27 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2051978 | 2051978 | 2021-12-26 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2048728 | 2048728 | 2021-12-25 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2045478 | 2045478 | 2021-12-24 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2042228 | 2042228 | 2021-12-23 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
1278895 | 1278895 | 2021-05-02 | Grant | Minnesota | 27051 | 561 | 8 |
1275648 | 1275648 | 2021-05-01 | Grant | Minnesota | 27051 | 561 | 8 |
1246440 | 1246440 | 2021-04-22 | Lincoln | Minnesota | 27081 | 561 | 3 |
1243193 | 1243193 | 2021-04-21 | Lincoln | Minnesota | 27081 | 561 | 3 |
1239946 | 1239946 | 2021-04-20 | Lincoln | Minnesota | 27081 | 561 | 2 |
1155543 | 1155543 | 2021-03-25 | Unknown | Minnesota | 561 | 78 | |
847160 | 847160 | 2020-12-20 | Lac qui Parle | Minnesota | 27073 | 561 | 13 |
778990 | 778990 | 2020-11-29 | Faribault | Minnesota | 27043 | 561 | 2 |
710835 | 710835 | 2020-11-08 | Chippewa | Minnesota | 27023 | 561 | 4 |
701123 | 701123 | 2020-11-05 | Hubbard | Minnesota | 27057 | 561 | 7 |
668692 | 668692 | 2020-10-26 | Isanti | Minnesota | 27059 | 561 | 5 |
665421 | 665421 | 2020-10-25 | Becker | Minnesota | 27005 | 561 | 4 |
269543 | 269543 | 2020-06-24 | Kandiyohi | Minnesota | 27067 | 561 | 1 |
266410 | 266410 | 2020-06-23 | Kandiyohi | Minnesota | 27067 | 561 | 1 |
257063 | 257063 | 2020-06-20 | Scott | Minnesota | 27139 | 561 | 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);