ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67,883 rows where state = "Minnesota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 27123 799
- 27019 797
- 27003 795
- 27109 794
- 27037 793
- 27053 793
- 27145 793
- 27171 792
- 27129 791
- 27161 790
- 27163 790
- 27009 789
- 27013 789
- 27091 788
- 27103 788
- 27131 787
- 27099 786
- 27139 786
- 27025 785
- 27027 785
- 27045 785
- 27039 784
- 27063 784
- 27137 784
- 27147 784
- 27157 784
- 27079 783
- 27011 782
- 27021 782
- 27073 782
- …
county >30
- Ramsey 799
- Carver 797
- Anoka 795
- Olmsted 794
- Dakota 793
- Hennepin 793
- Stearns 793
- Wright 792
- Renville 791
- Waseca 790
- Washington 790
- Benton 789
- Blue Earth 789
- Martin 788
- Nicollet 788
- Rice 787
- Mower 786
- Scott 786
- Chisago 785
- Clay 785
- Fillmore 785
- Dodge 784
- Jackson 784
- St. Louis 784
- Steele 784
- Wabasha 784
- Le Sueur 783
- Big Stone 782
- Cass 782
- Lac qui Parle 782
- …
state 1
- Minnesota · 67,783 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
371180 | 371180 | 2020-07-26 | Aitkin | Minnesota | 27001 | 24 | 0 |
374392 | 374392 | 2020-07-27 | Aitkin | Minnesota | 27001 | 25 | 0 |
377607 | 377607 | 2020-07-28 | Aitkin | Minnesota | 27001 | 25 | 0 |
380824 | 380824 | 2020-07-29 | Aitkin | Minnesota | 27001 | 25 | 0 |
384041 | 384041 | 2020-07-30 | Aitkin | Minnesota | 27001 | 25 | 0 |
387259 | 387259 | 2020-07-31 | Aitkin | Minnesota | 27001 | 27 | 0 |
390476 | 390476 | 2020-08-01 | Aitkin | Minnesota | 27001 | 28 | 0 |
393693 | 393693 | 2020-08-02 | Aitkin | Minnesota | 27001 | 28 | 0 |
396909 | 396909 | 2020-08-03 | Aitkin | Minnesota | 27001 | 27 | 0 |
400123 | 400123 | 2020-08-04 | Aitkin | Minnesota | 27001 | 27 | 0 |
403340 | 403340 | 2020-08-05 | Aitkin | Minnesota | 27001 | 29 | 1 |
406558 | 406558 | 2020-08-06 | Aitkin | Minnesota | 27001 | 29 | 1 |
409778 | 409778 | 2020-08-07 | Aitkin | Minnesota | 27001 | 34 | 1 |
412998 | 412998 | 2020-08-08 | Aitkin | Minnesota | 27001 | 40 | 1 |
416218 | 416218 | 2020-08-09 | Aitkin | Minnesota | 27001 | 40 | 1 |
419439 | 419439 | 2020-08-10 | Aitkin | Minnesota | 27001 | 40 | 1 |
422661 | 422661 | 2020-08-11 | Aitkin | Minnesota | 27001 | 41 | 1 |
425883 | 425883 | 2020-08-12 | Aitkin | Minnesota | 27001 | 40 | 1 |
429107 | 429107 | 2020-08-13 | Aitkin | Minnesota | 27001 | 41 | 1 |
432334 | 432334 | 2020-08-14 | Aitkin | Minnesota | 27001 | 42 | 1 |
435560 | 435560 | 2020-08-15 | Aitkin | Minnesota | 27001 | 42 | 1 |
438785 | 438785 | 2020-08-16 | Aitkin | Minnesota | 27001 | 42 | 1 |
442012 | 442012 | 2020-08-17 | Aitkin | Minnesota | 27001 | 44 | 1 |
445238 | 445238 | 2020-08-18 | Aitkin | Minnesota | 27001 | 44 | 1 |
448464 | 448464 | 2020-08-19 | Aitkin | Minnesota | 27001 | 44 | 1 |
451692 | 451692 | 2020-08-20 | Aitkin | Minnesota | 27001 | 44 | 1 |
454920 | 454920 | 2020-08-21 | Aitkin | Minnesota | 27001 | 44 | 1 |
458148 | 458148 | 2020-08-22 | Aitkin | Minnesota | 27001 | 45 | 1 |
461375 | 461375 | 2020-08-23 | Aitkin | Minnesota | 27001 | 45 | 1 |
464606 | 464606 | 2020-08-24 | Aitkin | Minnesota | 27001 | 45 | 1 |
467835 | 467835 | 2020-08-25 | Aitkin | Minnesota | 27001 | 45 | 1 |
471065 | 471065 | 2020-08-26 | Aitkin | Minnesota | 27001 | 46 | 1 |
474297 | 474297 | 2020-08-27 | Aitkin | Minnesota | 27001 | 47 | 1 |
477530 | 477530 | 2020-08-28 | Aitkin | Minnesota | 27001 | 48 | 1 |
480762 | 480762 | 2020-08-29 | Aitkin | Minnesota | 27001 | 48 | 1 |
483997 | 483997 | 2020-08-30 | Aitkin | Minnesota | 27001 | 48 | 1 |
487231 | 487231 | 2020-08-31 | Aitkin | Minnesota | 27001 | 48 | 1 |
490464 | 490464 | 2020-09-01 | Aitkin | Minnesota | 27001 | 51 | 1 |
493698 | 493698 | 2020-09-02 | Aitkin | Minnesota | 27001 | 51 | 1 |
496931 | 496931 | 2020-09-03 | Aitkin | Minnesota | 27001 | 52 | 1 |
500165 | 500165 | 2020-09-04 | Aitkin | Minnesota | 27001 | 55 | 1 |
503399 | 503399 | 2020-09-05 | Aitkin | Minnesota | 27001 | 58 | 1 |
506632 | 506632 | 2020-09-06 | Aitkin | Minnesota | 27001 | 59 | 1 |
509865 | 509865 | 2020-09-07 | Aitkin | Minnesota | 27001 | 59 | 1 |
513097 | 513097 | 2020-09-08 | Aitkin | Minnesota | 27001 | 64 | 1 |
516331 | 516331 | 2020-09-09 | Aitkin | Minnesota | 27001 | 64 | 1 |
519566 | 519566 | 2020-09-10 | Aitkin | Minnesota | 27001 | 63 | 1 |
522803 | 522803 | 2020-09-11 | Aitkin | Minnesota | 27001 | 63 | 1 |
526039 | 526039 | 2020-09-12 | Aitkin | Minnesota | 27001 | 65 | 1 |
529275 | 529275 | 2020-09-13 | Aitkin | Minnesota | 27001 | 66 | 1 |
532511 | 532511 | 2020-09-14 | Aitkin | Minnesota | 27001 | 66 | 1 |
535746 | 535746 | 2020-09-15 | Aitkin | Minnesota | 27001 | 66 | 1 |
538983 | 538983 | 2020-09-16 | Aitkin | Minnesota | 27001 | 68 | 1 |
542219 | 542219 | 2020-09-17 | Aitkin | Minnesota | 27001 | 69 | 1 |
545456 | 545456 | 2020-09-18 | Aitkin | Minnesota | 27001 | 69 | 1 |
548694 | 548694 | 2020-09-19 | Aitkin | Minnesota | 27001 | 70 | 1 |
551933 | 551933 | 2020-09-20 | Aitkin | Minnesota | 27001 | 71 | 1 |
555171 | 555171 | 2020-09-21 | Aitkin | Minnesota | 27001 | 73 | 1 |
558408 | 558408 | 2020-09-22 | Aitkin | Minnesota | 27001 | 76 | 1 |
561645 | 561645 | 2020-09-23 | Aitkin | Minnesota | 27001 | 74 | 1 |
564885 | 564885 | 2020-09-24 | Aitkin | Minnesota | 27001 | 75 | 1 |
568125 | 568125 | 2020-09-25 | Aitkin | Minnesota | 27001 | 76 | 1 |
571367 | 571367 | 2020-09-26 | Aitkin | Minnesota | 27001 | 80 | 1 |
574610 | 574610 | 2020-09-27 | Aitkin | Minnesota | 27001 | 81 | 1 |
577851 | 577851 | 2020-09-28 | Aitkin | Minnesota | 27001 | 83 | 1 |
581092 | 581092 | 2020-09-29 | Aitkin | Minnesota | 27001 | 84 | 1 |
584333 | 584333 | 2020-09-30 | Aitkin | Minnesota | 27001 | 88 | 1 |
587573 | 587573 | 2020-10-01 | Aitkin | Minnesota | 27001 | 91 | 1 |
590814 | 590814 | 2020-10-02 | Aitkin | Minnesota | 27001 | 97 | 1 |
594055 | 594055 | 2020-10-03 | Aitkin | Minnesota | 27001 | 94 | 1 |
597296 | 597296 | 2020-10-04 | Aitkin | Minnesota | 27001 | 95 | 1 |
600539 | 600539 | 2020-10-05 | Aitkin | Minnesota | 27001 | 101 | 1 |
603781 | 603781 | 2020-10-06 | Aitkin | Minnesota | 27001 | 103 | 1 |
607024 | 607024 | 2020-10-07 | Aitkin | Minnesota | 27001 | 108 | 1 |
610266 | 610266 | 2020-10-08 | Aitkin | Minnesota | 27001 | 108 | 1 |
613508 | 613508 | 2020-10-09 | Aitkin | Minnesota | 27001 | 111 | 1 |
616749 | 616749 | 2020-10-10 | Aitkin | Minnesota | 27001 | 113 | 1 |
619991 | 619991 | 2020-10-11 | Aitkin | Minnesota | 27001 | 117 | 1 |
623234 | 623234 | 2020-10-12 | Aitkin | Minnesota | 27001 | 119 | 1 |
626476 | 626476 | 2020-10-13 | Aitkin | Minnesota | 27001 | 123 | 1 |
629720 | 629720 | 2020-10-14 | Aitkin | Minnesota | 27001 | 129 | 1 |
632965 | 632965 | 2020-10-15 | Aitkin | Minnesota | 27001 | 133 | 1 |
636211 | 636211 | 2020-10-16 | Aitkin | Minnesota | 27001 | 140 | 1 |
639457 | 639457 | 2020-10-17 | Aitkin | Minnesota | 27001 | 146 | 1 |
642704 | 642704 | 2020-10-18 | Aitkin | Minnesota | 27001 | 151 | 1 |
645951 | 645951 | 2020-10-19 | Aitkin | Minnesota | 27001 | 154 | 2 |
649195 | 649195 | 2020-10-20 | Aitkin | Minnesota | 27001 | 156 | 2 |
652440 | 652440 | 2020-10-21 | Aitkin | Minnesota | 27001 | 157 | 2 |
655685 | 655685 | 2020-10-22 | Aitkin | Minnesota | 27001 | 159 | 2 |
658930 | 658930 | 2020-10-23 | Aitkin | Minnesota | 27001 | 165 | 2 |
662174 | 662174 | 2020-10-24 | Aitkin | Minnesota | 27001 | 177 | 2 |
665419 | 665419 | 2020-10-25 | Aitkin | Minnesota | 27001 | 179 | 2 |
668663 | 668663 | 2020-10-26 | Aitkin | Minnesota | 27001 | 179 | 2 |
671905 | 671905 | 2020-10-27 | Aitkin | Minnesota | 27001 | 186 | 2 |
675148 | 675148 | 2020-10-28 | Aitkin | Minnesota | 27001 | 188 | 2 |
678390 | 678390 | 2020-10-29 | Aitkin | Minnesota | 27001 | 198 | 2 |
681634 | 681634 | 2020-10-30 | Aitkin | Minnesota | 27001 | 214 | 2 |
684877 | 684877 | 2020-10-31 | Aitkin | Minnesota | 27001 | 224 | 2 |
688121 | 688121 | 2020-11-01 | Aitkin | Minnesota | 27001 | 232 | 3 |
691366 | 691366 | 2020-11-02 | Aitkin | Minnesota | 27001 | 244 | 4 |
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);