ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 18 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
675163 | 675163 | 2020-10-28 | Cook | Minnesota | 27031 | 18 | 0 |
629754 | 629754 | 2020-10-14 | Kittson | Minnesota | 27069 | 18 | 0 |
529313 | 529313 | 2020-09-13 | Lake of the Woods | Minnesota | 27077 | 18 | 1 |
526077 | 526077 | 2020-09-12 | Lake of the Woods | Minnesota | 27077 | 18 | 1 |
493734 | 493734 | 2020-09-02 | Lac qui Parle | Minnesota | 27073 | 18 | 0 |
477544 | 477544 | 2020-08-28 | Clearwater | Minnesota | 27029 | 18 | 0 |
474311 | 474311 | 2020-08-27 | Clearwater | Minnesota | 27029 | 18 | 0 |
471079 | 471079 | 2020-08-26 | Clearwater | Minnesota | 27029 | 18 | 0 |
467849 | 467849 | 2020-08-25 | Clearwater | Minnesota | 27029 | 18 | 0 |
429181 | 429181 | 2020-08-13 | Stevens | Minnesota | 27149 | 18 | 0 |
425957 | 425957 | 2020-08-12 | Stevens | Minnesota | 27149 | 18 | 0 |
422735 | 422735 | 2020-08-11 | Stevens | Minnesota | 27149 | 18 | 0 |
419513 | 419513 | 2020-08-10 | Stevens | Minnesota | 27149 | 18 | 0 |
416292 | 416292 | 2020-08-09 | Stevens | Minnesota | 27149 | 18 | 0 |
413072 | 413072 | 2020-08-08 | Stevens | Minnesota | 27149 | 18 | 0 |
403377 | 403377 | 2020-08-05 | Lake | Minnesota | 27075 | 18 | 0 |
400160 | 400160 | 2020-08-04 | Lake | Minnesota | 27075 | 18 | 0 |
396946 | 396946 | 2020-08-03 | Lake | Minnesota | 27075 | 18 | 0 |
374434 | 374434 | 2020-07-27 | Mahnomen | Minnesota | 27087 | 18 | 1 |
371222 | 371222 | 2020-07-26 | Mahnomen | Minnesota | 27087 | 18 | 1 |
367998 | 367998 | 2020-07-25 | Hubbard | Minnesota | 27057 | 18 | 0 |
358392 | 358392 | 2020-07-22 | Mahnomen | Minnesota | 27087 | 18 | 1 |
355189 | 355189 | 2020-07-21 | Mahnomen | Minnesota | 27087 | 18 | 1 |
351987 | 351987 | 2020-07-20 | Mahnomen | Minnesota | 27087 | 18 | 1 |
345545 | 345545 | 2020-07-18 | Aitkin | Minnesota | 27001 | 18 | 0 |
345624 | 345624 | 2020-07-18 | Wadena | Minnesota | 27159 | 18 | 0 |
342345 | 342345 | 2020-07-17 | Aitkin | Minnesota | 27001 | 18 | 0 |
342350 | 342350 | 2020-07-17 | Big Stone | Minnesota | 27011 | 18 | 0 |
342424 | 342424 | 2020-07-17 | Wadena | Minnesota | 27159 | 18 | 0 |
339149 | 339149 | 2020-07-16 | Aitkin | Minnesota | 27001 | 18 | 0 |
339154 | 339154 | 2020-07-16 | Big Stone | Minnesota | 27011 | 18 | 0 |
339181 | 339181 | 2020-07-16 | Kanabec | Minnesota | 27065 | 18 | 1 |
339228 | 339228 | 2020-07-16 | Wadena | Minnesota | 27159 | 18 | 0 |
335958 | 335958 | 2020-07-15 | Big Stone | Minnesota | 27011 | 18 | 0 |
335985 | 335985 | 2020-07-15 | Kanabec | Minnesota | 27065 | 18 | 1 |
336032 | 336032 | 2020-07-15 | Wadena | Minnesota | 27159 | 18 | 0 |
332765 | 332765 | 2020-07-14 | Big Stone | Minnesota | 27011 | 18 | 0 |
332792 | 332792 | 2020-07-14 | Kanabec | Minnesota | 27065 | 18 | 1 |
332839 | 332839 | 2020-07-14 | Wadena | Minnesota | 27159 | 18 | 0 |
329578 | 329578 | 2020-07-13 | Big Stone | Minnesota | 27011 | 18 | 0 |
329605 | 329605 | 2020-07-13 | Kanabec | Minnesota | 27065 | 18 | 1 |
329652 | 329652 | 2020-07-13 | Wadena | Minnesota | 27159 | 18 | 0 |
310541 | 310541 | 2020-07-07 | Koochiching | Minnesota | 27071 | 18 | 1 |
307400 | 307400 | 2020-07-06 | Redwood | Minnesota | 27127 | 18 | 0 |
304233 | 304233 | 2020-07-05 | Redwood | Minnesota | 27127 | 18 | 0 |
301069 | 301069 | 2020-07-04 | Redwood | Minnesota | 27127 | 18 | 0 |
297906 | 297906 | 2020-07-03 | Redwood | Minnesota | 27127 | 18 | 0 |
269562 | 269562 | 2020-06-24 | Norman | Minnesota | 27107 | 18 | 0 |
269573 | 269573 | 2020-06-24 | Renville | Minnesota | 27129 | 18 | 1 |
266429 | 266429 | 2020-06-23 | Norman | Minnesota | 27107 | 18 | 0 |
266440 | 266440 | 2020-06-23 | Renville | Minnesota | 27129 | 18 | 1 |
263303 | 263303 | 2020-06-22 | Norman | Minnesota | 27107 | 18 | 0 |
260174 | 260174 | 2020-06-21 | Norman | Minnesota | 27107 | 18 | 0 |
257048 | 257048 | 2020-06-20 | Norman | Minnesota | 27107 | 18 | 0 |
253928 | 253928 | 2020-06-19 | Norman | Minnesota | 27107 | 18 | 0 |
250813 | 250813 | 2020-06-18 | Norman | Minnesota | 27107 | 18 | 0 |
250844 | 250844 | 2020-06-18 | Wilkin | Minnesota | 27167 | 18 | 3 |
247701 | 247701 | 2020-06-17 | Norman | Minnesota | 27107 | 18 | 0 |
232111 | 232111 | 2020-06-12 | Brown | Minnesota | 27015 | 18 | 2 |
229007 | 229007 | 2020-06-11 | Brown | Minnesota | 27015 | 18 | 2 |
216620 | 216620 | 2020-06-07 | Brown | Minnesota | 27015 | 18 | 2 |
213546 | 213546 | 2020-06-06 | Fillmore | Minnesota | 27045 | 18 | 1 |
210444 | 210444 | 2020-06-05 | Beltrami | Minnesota | 27007 | 18 | 0 |
207363 | 207363 | 2020-06-04 | Beltrami | Minnesota | 27007 | 18 | 0 |
207437 | 207437 | 2020-06-04 | Wabasha | Minnesota | 27157 | 18 | 0 |
204282 | 204282 | 2020-06-03 | Beltrami | Minnesota | 27007 | 18 | 0 |
204356 | 204356 | 2020-06-03 | Wabasha | Minnesota | 27157 | 18 | 0 |
201279 | 201279 | 2020-06-02 | Wabasha | Minnesota | 27157 | 18 | 0 |
198206 | 198206 | 2020-06-01 | Wabasha | Minnesota | 27157 | 18 | 0 |
195078 | 195078 | 2020-05-31 | Faribault | Minnesota | 27043 | 18 | 0 |
195131 | 195131 | 2020-05-31 | Swift | Minnesota | 27151 | 18 | 0 |
195135 | 195135 | 2020-05-31 | Wabasha | Minnesota | 27157 | 18 | 0 |
192010 | 192010 | 2020-05-30 | Faribault | Minnesota | 27043 | 18 | 0 |
192063 | 192063 | 2020-05-30 | Swift | Minnesota | 27151 | 18 | 0 |
192067 | 192067 | 2020-05-30 | Wabasha | Minnesota | 27157 | 18 | 0 |
188999 | 188999 | 2020-05-29 | Swift | Minnesota | 27151 | 18 | 0 |
158552 | 158552 | 2020-05-19 | McLeod | Minnesota | 27085 | 18 | 0 |
155534 | 155534 | 2020-05-18 | McLeod | Minnesota | 27085 | 18 | 0 |
152497 | 152497 | 2020-05-17 | Douglas | Minnesota | 27041 | 18 | 0 |
152520 | 152520 | 2020-05-17 | McLeod | Minnesota | 27085 | 18 | 0 |
149486 | 149486 | 2020-05-16 | Douglas | Minnesota | 27041 | 18 | 0 |
146481 | 146481 | 2020-05-15 | Douglas | Minnesota | 27041 | 18 | 0 |
143539 | 143539 | 2020-05-14 | Waseca | Minnesota | 27161 | 18 | 0 |
134521 | 134521 | 2020-05-11 | Lyon | Minnesota | 27083 | 18 | 0 |
125527 | 125527 | 2020-05-08 | Chisago | Minnesota | 27025 | 18 | 1 |
125563 | 125563 | 2020-05-08 | Nicollet | Minnesota | 27103 | 18 | 2 |
122535 | 122535 | 2020-05-07 | Becker | Minnesota | 27005 | 18 | 0 |
122576 | 122576 | 2020-05-07 | Meeker | Minnesota | 27093 | 18 | 0 |
122581 | 122581 | 2020-05-07 | Nicollet | Minnesota | 27103 | 18 | 2 |
122607 | 122607 | 2020-05-07 | Unknown | Minnesota | 18 | 0 | |
122612 | 122612 | 2020-05-07 | Watonwan | Minnesota | 27165 | 18 | 0 |
119602 | 119602 | 2020-05-06 | Meeker | Minnesota | 27093 | 18 | 0 |
119622 | 119622 | 2020-05-06 | Rock | Minnesota | 27133 | 18 | 0 |
119631 | 119631 | 2020-05-06 | Todd | Minnesota | 27153 | 18 | 0 |
116662 | 116662 | 2020-05-05 | Rock | Minnesota | 27133 | 18 | 0 |
113770 | 113770 | 2020-05-04 | Otter Tail | Minnesota | 27111 | 18 | 0 |
110869 | 110869 | 2020-05-03 | Jackson | Minnesota | 27063 | 18 | 0 |
107998 | 107998 | 2020-05-02 | Jackson | Minnesota | 27063 | 18 | 0 |
108029 | 108029 | 2020-05-02 | Rice | Minnesota | 27131 | 18 | 1 |
105172 | 105172 | 2020-05-01 | Steele | Minnesota | 27147 | 18 | 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);