ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 27 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Beltrami 7
- Mahnomen 6
- Lake 5
- Redwood 5
- Wadena 4
- Aitkin 3
- Clearwater 3
- Kittson 3
- Mower 3
- Wabasha 3
- Blue Earth 2
- Brown 2
- Chippewa 2
- Douglas 2
- Faribault 2
- Fillmore 2
- Freeborn 2
- Hubbard 2
- Marshall 2
- Polk 2
- Red Lake 2
- Scott 2
- Stevens 2
- Waseca 2
- Yellow Medicine 2
- Carlton 1
- Carver 1
- Chisago 1
- Cook 1
- Cottonwood 1
- …
state 1
- Minnesota · 91 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
694623 | 694623 | 2020-11-03 | Cook | Minnesota | 27031 | 27 | 0 |
649229 | 649229 | 2020-10-20 | Kittson | Minnesota | 27069 | 27 | 0 |
645985 | 645985 | 2020-10-19 | Kittson | Minnesota | 27069 | 27 | 0 |
642738 | 642738 | 2020-10-18 | Kittson | Minnesota | 27069 | 27 | 0 |
600577 | 600577 | 2020-10-05 | Lake of the Woods | Minnesota | 27077 | 27 | 1 |
571381 | 571381 | 2020-09-26 | Clearwater | Minnesota | 27029 | 27 | 0 |
568139 | 568139 | 2020-09-25 | Clearwater | Minnesota | 27029 | 27 | 0 |
564899 | 564899 | 2020-09-24 | Clearwater | Minnesota | 27029 | 27 | 0 |
526075 | 526075 | 2020-09-12 | Lac qui Parle | Minnesota | 27073 | 27 | 0 |
519643 | 519643 | 2020-09-10 | Traverse | Minnesota | 27155 | 27 | 0 |
471102 | 471102 | 2020-08-26 | Lake | Minnesota | 27075 | 27 | 0 |
471139 | 471139 | 2020-08-26 | Stevens | Minnesota | 27149 | 27 | 0 |
467872 | 467872 | 2020-08-25 | Lake | Minnesota | 27075 | 27 | 0 |
467909 | 467909 | 2020-08-25 | Stevens | Minnesota | 27149 | 27 | 0 |
464643 | 464643 | 2020-08-24 | Lake | Minnesota | 27075 | 27 | 0 |
461412 | 461412 | 2020-08-23 | Lake | Minnesota | 27075 | 27 | 0 |
458185 | 458185 | 2020-08-22 | Lake | Minnesota | 27075 | 27 | 0 |
454982 | 454982 | 2020-08-21 | Red Lake | Minnesota | 27125 | 27 | 0 |
451754 | 451754 | 2020-08-20 | Red Lake | Minnesota | 27125 | 27 | 0 |
432376 | 432376 | 2020-08-14 | Mahnomen | Minnesota | 27087 | 27 | 1 |
429149 | 429149 | 2020-08-13 | Mahnomen | Minnesota | 27087 | 27 | 1 |
425925 | 425925 | 2020-08-12 | Mahnomen | Minnesota | 27087 | 27 | 1 |
425963 | 425963 | 2020-08-12 | Wadena | Minnesota | 27159 | 27 | 0 |
422703 | 422703 | 2020-08-11 | Mahnomen | Minnesota | 27087 | 27 | 1 |
422741 | 422741 | 2020-08-11 | Wadena | Minnesota | 27159 | 27 | 0 |
419481 | 419481 | 2020-08-10 | Mahnomen | Minnesota | 27087 | 27 | 1 |
419519 | 419519 | 2020-08-10 | Wadena | Minnesota | 27159 | 27 | 0 |
416260 | 416260 | 2020-08-09 | Mahnomen | Minnesota | 27087 | 27 | 1 |
416298 | 416298 | 2020-08-09 | Wadena | Minnesota | 27159 | 27 | 0 |
400123 | 400123 | 2020-08-04 | Aitkin | Minnesota | 27001 | 27 | 0 |
396909 | 396909 | 2020-08-03 | Aitkin | Minnesota | 27001 | 27 | 0 |
390504 | 390504 | 2020-08-01 | Hubbard | Minnesota | 27057 | 27 | 0 |
390508 | 390508 | 2020-08-01 | Kanabec | Minnesota | 27065 | 27 | 1 |
390560 | 390560 | 2020-08-01 | Wilkin | Minnesota | 27167 | 27 | 3 |
387259 | 387259 | 2020-07-31 | Aitkin | Minnesota | 27001 | 27 | 0 |
387287 | 387287 | 2020-07-31 | Hubbard | Minnesota | 27057 | 27 | 0 |
387302 | 387302 | 2020-07-31 | Marshall | Minnesota | 27089 | 27 | 0 |
384084 | 384084 | 2020-07-30 | Marshall | Minnesota | 27089 | 27 | 0 |
361618 | 361618 | 2020-07-23 | Redwood | Minnesota | 27127 | 27 | 0 |
358413 | 358413 | 2020-07-22 | Redwood | Minnesota | 27127 | 27 | 0 |
355207 | 355207 | 2020-07-21 | Pope | Minnesota | 27121 | 27 | 0 |
355210 | 355210 | 2020-07-21 | Redwood | Minnesota | 27127 | 27 | 0 |
352008 | 352008 | 2020-07-20 | Redwood | Minnesota | 27127 | 27 | 0 |
348808 | 348808 | 2020-07-19 | Redwood | Minnesota | 27127 | 27 | 0 |
310533 | 310533 | 2020-07-07 | Houston | Minnesota | 27055 | 27 | 0 |
294708 | 294708 | 2020-07-02 | Fillmore | Minnesota | 27045 | 27 | 0 |
291554 | 291554 | 2020-07-01 | Fillmore | Minnesota | 27045 | 27 | 0 |
288384 | 288384 | 2020-06-30 | Beltrami | Minnesota | 27007 | 27 | 0 |
285234 | 285234 | 2020-06-29 | Beltrami | Minnesota | 27007 | 27 | 0 |
285238 | 285238 | 2020-06-29 | Brown | Minnesota | 27015 | 27 | 2 |
285317 | 285317 | 2020-06-29 | Yellow Medicine | Minnesota | 27173 | 27 | 0 |
282089 | 282089 | 2020-06-28 | Beltrami | Minnesota | 27007 | 27 | 0 |
282093 | 282093 | 2020-06-28 | Brown | Minnesota | 27015 | 27 | 2 |
282172 | 282172 | 2020-06-28 | Yellow Medicine | Minnesota | 27173 | 27 | 0 |
278941 | 278941 | 2020-06-27 | Beltrami | Minnesota | 27007 | 27 | 0 |
275793 | 275793 | 2020-06-26 | Beltrami | Minnesota | 27007 | 27 | 0 |
272650 | 272650 | 2020-06-25 | Beltrami | Minnesota | 27007 | 27 | 0 |
269513 | 269513 | 2020-06-24 | Beltrami | Minnesota | 27007 | 27 | 0 |
260200 | 260200 | 2020-06-21 | Wabasha | Minnesota | 27157 | 27 | 0 |
257074 | 257074 | 2020-06-20 | Wabasha | Minnesota | 27157 | 27 | 0 |
253954 | 253954 | 2020-06-19 | Wabasha | Minnesota | 27157 | 27 | 0 |
250830 | 250830 | 2020-06-18 | Sibley | Minnesota | 27143 | 27 | 2 |
241446 | 241446 | 2020-06-15 | Faribault | Minnesota | 27043 | 27 | 0 |
238337 | 238337 | 2020-06-14 | Faribault | Minnesota | 27043 | 27 | 0 |
207439 | 207439 | 2020-06-04 | Waseca | Minnesota | 27161 | 27 | 0 |
204358 | 204358 | 2020-06-03 | Waseca | Minnesota | 27161 | 27 | 0 |
176766 | 176766 | 2020-05-25 | McLeod | Minnesota | 27085 | 27 | 0 |
170657 | 170657 | 2020-05-23 | Douglas | Minnesota | 27041 | 27 | 0 |
167620 | 167620 | 2020-05-22 | Douglas | Minnesota | 27041 | 27 | 0 |
155537 | 155537 | 2020-05-18 | Morrison | Minnesota | 27097 | 27 | 0 |
146473 | 146473 | 2020-05-15 | Chippewa | Minnesota | 27023 | 27 | 0 |
146474 | 146474 | 2020-05-15 | Chisago | Minnesota | 27025 | 27 | 1 |
143473 | 143473 | 2020-05-14 | Chippewa | Minnesota | 27023 | 27 | 0 |
128549 | 128549 | 2020-05-09 | Murray | Minnesota | 27101 | 27 | 0 |
113728 | 113728 | 2020-05-04 | Carver | Minnesota | 27019 | 27 | 0 |
107984 | 107984 | 2020-05-02 | Cottonwood | Minnesota | 27033 | 27 | 0 |
102298 | 102298 | 2020-04-30 | Polk | Minnesota | 27119 | 27 | 0 |
99446 | 99446 | 2020-04-29 | Polk | Minnesota | 27119 | 27 | 0 |
88081 | 88081 | 2020-04-25 | Blue Earth | Minnesota | 27013 | 27 | 0 |
85271 | 85271 | 2020-04-24 | Blue Earth | Minnesota | 27013 | 27 | 0 |
82504 | 82504 | 2020-04-23 | Mower | Minnesota | 27099 | 27 | 0 |
79708 | 79708 | 2020-04-22 | Mower | Minnesota | 27099 | 27 | 0 |
76941 | 76941 | 2020-04-21 | Scott | Minnesota | 27139 | 27 | 1 |
76957 | 76957 | 2020-04-21 | Wright | Minnesota | 27171 | 27 | 1 |
74160 | 74160 | 2020-04-20 | Scott | Minnesota | 27139 | 27 | 1 |
71370 | 71370 | 2020-04-19 | Mower | Minnesota | 27099 | 27 | 0 |
60360 | 60360 | 2020-04-15 | Carlton | Minnesota | 27017 | 27 | 0 |
60373 | 60373 | 2020-04-15 | Freeborn | Minnesota | 27047 | 27 | 0 |
57663 | 57663 | 2020-04-14 | Freeborn | Minnesota | 27047 | 27 | 0 |
18596 | 18596 | 2020-03-29 | Washington | Minnesota | 27163 | 27 | 0 |
11538 | 11538 | 2020-03-25 | Ramsey | Minnesota | 27123 | 27 | 1 |
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);