ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 436 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1788738 | 1788738 | 2021-10-06 | Lake of the Woods | Minnesota | 27077 | 436 | 4 |
1204215 | 1204215 | 2021-04-09 | Kittson | Minnesota | 27069 | 436 | 22 |
1058121 | 1058121 | 2021-02-23 | Mahnomen | Minnesota | 27087 | 436 | 7 |
1041901 | 1041901 | 2021-02-18 | Norman | Minnesota | 27107 | 436 | 8 |
847164 | 847164 | 2020-12-20 | Lincoln | Minnesota | 27081 | 436 | 1 |
843918 | 843918 | 2020-12-19 | Lincoln | Minnesota | 27081 | 436 | 1 |
798475 | 798475 | 2020-12-05 | Lac qui Parle | Minnesota | 27073 | 436 | 4 |
769265 | 769265 | 2020-11-26 | Jackson | Minnesota | 27063 | 436 | 1 |
766019 | 766019 | 2020-11-25 | Jackson | Minnesota | 27063 | 436 | 1 |
740051 | 740051 | 2020-11-17 | Kanabec | Minnesota | 27065 | 436 | 11 |
733579 | 733579 | 2020-11-15 | Murray | Minnesota | 27101 | 436 | 3 |
697918 | 697918 | 2020-11-04 | Roseau | Minnesota | 27135 | 436 | 0 |
539022 | 539022 | 2020-09-16 | Le Sueur | Minnesota | 27079 | 436 | 3 |
490537 | 490537 | 2020-09-01 | Steele | Minnesota | 27147 | 436 | 2 |
480813 | 480813 | 2020-08-29 | Nicollet | Minnesota | 27103 | 436 | 15 |
451733 | 451733 | 2020-08-20 | Lyon | Minnesota | 27083 | 436 | 3 |
451768 | 451768 | 2020-08-20 | Todd | Minnesota | 27153 | 436 | 2 |
448540 | 448540 | 2020-08-19 | Todd | Minnesota | 27153 | 436 | 2 |
445314 | 445314 | 2020-08-18 | Todd | Minnesota | 27153 | 436 | 2 |
396980 | 396980 | 2020-08-03 | St. Louis | Minnesota | 27137 | 436 | 19 |
198195 | 198195 | 2020-06-01 | Scott | Minnesota | 27139 | 436 | 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);