ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 96 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
662199 | 662199 | 2020-10-24 | Grant | Minnesota | 27051 | 96 | 4 |
616833 | 616833 | 2020-10-10 | Wilkin | Minnesota | 27167 | 96 | 3 |
539005 | 539005 | 2020-09-16 | Fillmore | Minnesota | 27045 | 96 | 0 |
539018 | 539018 | 2020-09-16 | Koochiching | Minnesota | 27071 | 96 | 3 |
539058 | 539058 | 2020-09-16 | Swift | Minnesota | 27151 | 96 | 1 |
535781 | 535781 | 2020-09-15 | Koochiching | Minnesota | 27071 | 96 | 3 |
535821 | 535821 | 2020-09-15 | Swift | Minnesota | 27151 | 96 | 1 |
532538 | 532538 | 2020-09-14 | Houston | Minnesota | 27055 | 96 | 0 |
532546 | 532546 | 2020-09-14 | Koochiching | Minnesota | 27071 | 96 | 3 |
532586 | 532586 | 2020-09-14 | Swift | Minnesota | 27151 | 96 | 1 |
529310 | 529310 | 2020-09-13 | Koochiching | Minnesota | 27071 | 96 | 3 |
526074 | 526074 | 2020-09-12 | Koochiching | Minnesota | 27071 | 96 | 3 |
522838 | 522838 | 2020-09-11 | Koochiching | Minnesota | 27071 | 96 | 3 |
496987 | 496987 | 2020-09-03 | Pennington | Minnesota | 27113 | 96 | 1 |
490495 | 490495 | 2020-09-01 | Jackson | Minnesota | 27063 | 96 | 1 |
487262 | 487262 | 2020-08-31 | Jackson | Minnesota | 27063 | 96 | 1 |
467881 | 467881 | 2020-08-25 | Meeker | Minnesota | 27093 | 96 | 2 |
458214 | 458214 | 2020-08-22 | Rock | Minnesota | 27133 | 96 | 0 |
448485 | 448485 | 2020-08-19 | Faribault | Minnesota | 27043 | 96 | 0 |
445259 | 445259 | 2020-08-18 | Faribault | Minnesota | 27043 | 96 | 0 |
442033 | 442033 | 2020-08-17 | Faribault | Minnesota | 27043 | 96 | 0 |
435567 | 435567 | 2020-08-15 | Brown | Minnesota | 27015 | 96 | 2 |
390487 | 390487 | 2020-08-01 | Chippewa | Minnesota | 27023 | 96 | 1 |
364765 | 364765 | 2020-07-24 | Becker | Minnesota | 27005 | 96 | 0 |
361585 | 361585 | 2020-07-23 | Isanti | Minnesota | 27059 | 96 | 0 |
358409 | 358409 | 2020-07-22 | Polk | Minnesota | 27119 | 96 | 3 |
351976 | 351976 | 2020-07-20 | Itasca | Minnesota | 27061 | 96 | 12 |
351995 | 351995 | 2020-07-20 | Murray | Minnesota | 27101 | 96 | 0 |
345575 | 345575 | 2020-07-18 | Itasca | Minnesota | 27061 | 96 | 12 |
339157 | 339157 | 2020-07-16 | Carlton | Minnesota | 27017 | 96 | 0 |
335961 | 335961 | 2020-07-15 | Carlton | Minnesota | 27017 | 96 | 0 |
332768 | 332768 | 2020-07-14 | Carlton | Minnesota | 27017 | 96 | 0 |
323223 | 323223 | 2020-07-11 | Dodge | Minnesota | 27039 | 96 | 0 |
316894 | 316894 | 2020-07-09 | McLeod | Minnesota | 27085 | 96 | 0 |
257052 | 257052 | 2020-06-20 | Pine | Minnesota | 27115 | 96 | 0 |
253932 | 253932 | 2020-06-19 | Pine | Minnesota | 27115 | 96 | 0 |
250817 | 250817 | 2020-06-18 | Pine | Minnesota | 27115 | 96 | 0 |
247705 | 247705 | 2020-06-17 | Pine | Minnesota | 27115 | 96 | 0 |
244592 | 244592 | 2020-06-16 | Pine | Minnesota | 27115 | 96 | 0 |
241481 | 241481 | 2020-06-15 | Pine | Minnesota | 27115 | 96 | 0 |
238372 | 238372 | 2020-06-14 | Pine | Minnesota | 27115 | 96 | 0 |
232180 | 232180 | 2020-06-12 | Unknown | Minnesota | 96 | 31 | |
232185 | 232185 | 2020-06-12 | Watonwan | Minnesota | 27165 | 96 | 0 |
229015 | 229015 | 2020-06-11 | Cottonwood | Minnesota | 27033 | 96 | 0 |
192066 | 192066 | 2020-05-30 | Unknown | Minnesota | 96 | 10 | |
140535 | 140535 | 2020-05-13 | St. Louis | Minnesota | 27137 | 96 | 12 |
137541 | 137541 | 2020-05-12 | St. Louis | Minnesota | 27137 | 96 | 12 |
134551 | 134551 | 2020-05-11 | St. Louis | Minnesota | 27137 | 96 | 12 |
36741 | 36741 | 2020-04-06 | Olmsted | Minnesota | 27109 | 96 | 2 |
36745 | 36745 | 2020-04-06 | Ramsey | Minnesota | 27123 | 96 | 3 |
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);