ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 572 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Minnesota · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1902501 | 1902501 | 2021-11-10 | Traverse | Minnesota | 27155 | 572 | 6 |
1811507 | 1811507 | 2021-10-13 | Red Lake | Minnesota | 27125 | 572 | 8 |
1632812 | 1632812 | 2021-08-19 | Norman | Minnesota | 27107 | 572 | 9 |
1626307 | 1626307 | 2021-08-17 | Mahnomen | Minnesota | 27087 | 572 | 9 |
1623060 | 1623060 | 2021-08-16 | Mahnomen | Minnesota | 27087 | 572 | 9 |
1541890 | 1541890 | 2021-07-22 | Unknown | Minnesota | 572 | 93 | |
1405552 | 1405552 | 2021-06-10 | Unknown | Minnesota | 572 | 93 | |
1285403 | 1285403 | 2021-05-04 | Lincoln | Minnesota | 27081 | 572 | 3 |
1239984 | 1239984 | 2021-04-20 | Unknown | Minnesota | 572 | 78 | |
1145802 | 1145802 | 2021-03-22 | Unknown | Minnesota | 572 | 68 | |
921799 | 921799 | 2021-01-12 | Koochiching | Minnesota | 27071 | 572 | 10 |
918554 | 918554 | 2021-01-11 | Koochiching | Minnesota | 27071 | 572 | 10 |
798470 | 798470 | 2020-12-05 | Jackson | Minnesota | 27063 | 572 | 1 |
792009 | 792009 | 2020-12-03 | Pope | Minnesota | 27121 | 572 | 1 |
655768 | 655768 | 2020-10-22 | Watonwan | Minnesota | 27165 | 572 | 4 |
652523 | 652523 | 2020-10-21 | Watonwan | Minnesota | 27165 | 572 | 4 |
607027 | 607027 | 2020-10-07 | Beltrami | Minnesota | 27007 | 572 | 5 |
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);