ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 103 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
873099 | 873099 | 2020-12-28 | Cook | Minnesota | 27031 | 103 | 0 |
658973 | 658973 | 2020-10-23 | Marshall | Minnesota | 27089 | 103 | 1 |
645988 | 645988 | 2020-10-19 | Lake | Minnesota | 27075 | 103 | 0 |
613513 | 613513 | 2020-10-09 | Big Stone | Minnesota | 27011 | 103 | 0 |
603781 | 603781 | 2020-10-06 | Aitkin | Minnesota | 27001 | 103 | 1 |
587633 | 587633 | 2020-10-01 | Pope | Minnesota | 27121 | 103 | 0 |
571395 | 571395 | 2020-09-26 | Hubbard | Minnesota | 27057 | 103 | 1 |
571441 | 571441 | 2020-09-26 | Stevens | Minnesota | 27149 | 103 | 1 |
558448 | 558448 | 2020-09-22 | Lincoln | Minnesota | 27081 | 103 | 0 |
548726 | 548726 | 2020-09-19 | Kanabec | Minnesota | 27065 | 103 | 8 |
548729 | 548729 | 2020-09-19 | Koochiching | Minnesota | 27071 | 103 | 3 |
529331 | 529331 | 2020-09-13 | Pennington | Minnesota | 27113 | 103 | 1 |
526070 | 526070 | 2020-09-12 | Jackson | Minnesota | 27063 | 103 | 1 |
522867 | 522867 | 2020-09-11 | Renville | Minnesota | 27129 | 103 | 6 |
509921 | 509921 | 2020-09-07 | Pennington | Minnesota | 27113 | 103 | 1 |
484007 | 484007 | 2020-08-30 | Cass | Minnesota | 27021 | 103 | 3 |
484063 | 484063 | 2020-08-30 | Rock | Minnesota | 27133 | 103 | 0 |
480772 | 480772 | 2020-08-29 | Cass | Minnesota | 27021 | 103 | 3 |
477576 | 477576 | 2020-08-28 | Meeker | Minnesota | 27093 | 103 | 2 |
454927 | 454927 | 2020-08-21 | Brown | Minnesota | 27015 | 103 | 2 |
448512 | 448512 | 2020-08-19 | Morrison | Minnesota | 27097 | 103 | 1 |
448543 | 448543 | 2020-08-19 | Wabasha | Minnesota | 27157 | 103 | 0 |
438833 | 438833 | 2020-08-16 | Morrison | Minnesota | 27097 | 103 | 1 |
413009 | 413009 | 2020-08-08 | Chippewa | Minnesota | 27023 | 103 | 1 |
355178 | 355178 | 2020-07-21 | Itasca | Minnesota | 27061 | 103 | 12 |
355197 | 355197 | 2020-07-21 | Murray | Minnesota | 27101 | 103 | 0 |
351954 | 351954 | 2020-07-20 | Carlton | Minnesota | 27017 | 103 | 0 |
339206 | 339206 | 2020-07-16 | Pipestone | Minnesota | 27117 | 103 | 5 |
329617 | 329617 | 2020-07-13 | McLeod | Minnesota | 27085 | 103 | 0 |
326431 | 326431 | 2020-07-12 | McLeod | Minnesota | 27085 | 103 | 0 |
316862 | 316862 | 2020-07-09 | Chisago | Minnesota | 27025 | 103 | 1 |
307376 | 307376 | 2020-07-06 | Le Sueur | Minnesota | 27079 | 103 | 1 |
304227 | 304227 | 2020-07-05 | Pine | Minnesota | 27115 | 103 | 0 |
301063 | 301063 | 2020-07-04 | Pine | Minnesota | 27115 | 103 | 0 |
297900 | 297900 | 2020-07-03 | Pine | Minnesota | 27115 | 103 | 0 |
294742 | 294742 | 2020-07-02 | Pine | Minnesota | 27115 | 103 | 0 |
291588 | 291588 | 2020-07-01 | Pine | Minnesota | 27115 | 103 | 0 |
143471 | 143471 | 2020-05-14 | Carver | Minnesota | 27019 | 103 | 1 |
63090 | 63090 | 2020-04-16 | Dakota | Minnesota | 27037 | 103 | 4 |
60368 | 60368 | 2020-04-15 | Dakota | Minnesota | 27037 | 103 | 5 |
57658 | 57658 | 2020-04-14 | Dakota | Minnesota | 27037 | 103 | 5 |
39250 | 39250 | 2020-04-07 | Olmsted | Minnesota | 27109 | 103 | 2 |
10112 | 10112 | 2020-03-24 | Hennepin | Minnesota | 27053 | 103 | 0 |
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);