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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 88
- 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
- 27141 782
- 27049 780
- 27169 780
- 27067 779
- 27143 779
- 27167 779
- - 779
- 27007 778
- 27043 778
- 27081 778
- 27087 778
- 27029 777
- 27033 776
- 27041 776
- 27059 776
- 27111 776
- 27061 775
- 27093 775
- 27165 775
- 27015 774
- 27017 774
- 27083 774
- 27155 774
- 27035 773
- 27047 773
- 27173 773
- 27071 772
- 27085 770
- 27119 770
- 27055 769
- 27117 769
- 27101 768
- 27127 768
- 27135 767
- 27151 767
- 27115 766
- 27105 764
- 27005 763
- 27125 762
- 27133 762
- 27153 762
- 27107 759
- 27095 758
- 27001 757
- 27069 756
- 27089 755
- 27097 755
- 27023 754
- 27113 753
- 27159 746
- 27065 743
- 27051 742
- 27121 739
- 27075 737
- 27057 721
- 27149 716
- 27031 700
- 27077 658
county 88
- 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
- Sherburne 782
- Goodhue 780
- Winona 780
- Kandiyohi 779
- Sibley 779
- Unknown 779
- Wilkin 779
- Beltrami 778
- Faribault 778
- Lincoln 778
- Mahnomen 778
- Clearwater 777
- Cottonwood 776
- Douglas 776
- Isanti 776
- Otter Tail 776
- Itasca 775
- Meeker 775
- Watonwan 775
- Brown 774
- Carlton 774
- Lyon 774
- Traverse 774
- Crow Wing 773
- Freeborn 773
- Yellow Medicine 773
- Koochiching 772
- McLeod 770
- Polk 770
- Houston 769
- Pipestone 769
- Murray 768
- Redwood 768
- Roseau 767
- Swift 767
- Pine 766
- Nobles 764
- Becker 763
- Red Lake 762
- Rock 762
- Todd 762
- Norman 759
- Mille Lacs 758
- Aitkin 757
- Kittson 756
- Marshall 755
- Morrison 755
- Chippewa 754
- Pennington 753
- Wadena 746
- Kanabec 743
- Grant 742
- Pope 739
- Lake 737
- Hubbard 721
- Stevens 716
- Cook 700
- Lake of the Woods 658
state 1
- Minnesota · 67,883 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
22732 | 22732 | 2020-03-31 | Unknown | Minnesota | 0 | 2 | |
24914 | 24914 | 2020-04-01 | Unknown | Minnesota | 0 | 7 | |
27168 | 27168 | 2020-04-02 | Unknown | Minnesota | 0 | 7 | |
29487 | 29487 | 2020-04-03 | Unknown | Minnesota | 0 | 3 | |
620 | 620 | 2020-03-06 | Ramsey | Minnesota | 27123 | 1 | 0 |
706 | 706 | 2020-03-07 | Ramsey | Minnesota | 27123 | 1 | 0 |
809 | 809 | 2020-03-08 | Carver | Minnesota | 27019 | 1 | 0 |
810 | 810 | 2020-03-08 | Ramsey | Minnesota | 27123 | 1 | 0 |
933 | 933 | 2020-03-09 | Carver | Minnesota | 27019 | 1 | 0 |
934 | 934 | 2020-03-09 | Ramsey | Minnesota | 27123 | 1 | 0 |
1082 | 1082 | 2020-03-10 | Anoka | Minnesota | 27003 | 1 | 0 |
1083 | 1083 | 2020-03-10 | Carver | Minnesota | 27019 | 1 | 0 |
1084 | 1084 | 2020-03-10 | Ramsey | Minnesota | 27123 | 1 | 0 |
1262 | 1262 | 2020-03-11 | Anoka | Minnesota | 27003 | 1 | 0 |
1263 | 1263 | 2020-03-11 | Carver | Minnesota | 27019 | 1 | 0 |
1264 | 1264 | 2020-03-11 | Olmsted | Minnesota | 27109 | 1 | 0 |
1485 | 1485 | 2020-03-12 | Anoka | Minnesota | 27003 | 1 | 0 |
1486 | 1486 | 2020-03-12 | Carver | Minnesota | 27019 | 1 | 0 |
1487 | 1487 | 2020-03-12 | Dakota | Minnesota | 27037 | 1 | 0 |
1488 | 1488 | 2020-03-12 | Hennepin | Minnesota | 27053 | 1 | 0 |
1489 | 1489 | 2020-03-12 | Olmsted | Minnesota | 27109 | 1 | 0 |
1768 | 1768 | 2020-03-13 | Anoka | Minnesota | 27003 | 1 | 0 |
1769 | 1769 | 2020-03-13 | Carver | Minnesota | 27019 | 1 | 0 |
1772 | 1772 | 2020-03-13 | Olmsted | Minnesota | 27109 | 1 | 0 |
1775 | 1775 | 2020-03-13 | Wright | Minnesota | 27171 | 1 | 0 |
2113 | 2113 | 2020-03-14 | Carver | Minnesota | 27019 | 1 | 0 |
2116 | 2116 | 2020-03-14 | Olmsted | Minnesota | 27109 | 1 | 0 |
2118 | 2118 | 2020-03-14 | Renville | Minnesota | 27129 | 1 | 0 |
2120 | 2120 | 2020-03-14 | Wright | Minnesota | 27171 | 1 | 0 |
2517 | 2517 | 2020-03-15 | Carver | Minnesota | 27019 | 1 | 0 |
2522 | 2522 | 2020-03-15 | Renville | Minnesota | 27129 | 1 | 0 |
2524 | 2524 | 2020-03-15 | Waseca | Minnesota | 27161 | 1 | 0 |
2525 | 2525 | 2020-03-15 | Washington | Minnesota | 27163 | 1 | 0 |
2526 | 2526 | 2020-03-15 | Wright | Minnesota | 27171 | 1 | 0 |
2967 | 2967 | 2020-03-16 | Benton | Minnesota | 27009 | 1 | 0 |
2968 | 2968 | 2020-03-16 | Blue Earth | Minnesota | 27013 | 1 | 0 |
2969 | 2969 | 2020-03-16 | Carver | Minnesota | 27019 | 1 | 0 |
2974 | 2974 | 2020-03-16 | Renville | Minnesota | 27129 | 1 | 0 |
2976 | 2976 | 2020-03-16 | Waseca | Minnesota | 27161 | 1 | 0 |
2977 | 2977 | 2020-03-16 | Washington | Minnesota | 27163 | 1 | 0 |
2978 | 2978 | 2020-03-16 | Wright | Minnesota | 27171 | 1 | 0 |
3470 | 3470 | 2020-03-17 | Benton | Minnesota | 27009 | 1 | 0 |
3471 | 3471 | 2020-03-17 | Blue Earth | Minnesota | 27013 | 1 | 0 |
3472 | 3472 | 2020-03-17 | Carver | Minnesota | 27019 | 1 | 0 |
3476 | 3476 | 2020-03-17 | Nicollet | Minnesota | 27103 | 1 | 0 |
3479 | 3479 | 2020-03-17 | Renville | Minnesota | 27129 | 1 | 0 |
3481 | 3481 | 2020-03-17 | Waseca | Minnesota | 27161 | 1 | 0 |
3482 | 3482 | 2020-03-17 | Washington | Minnesota | 27163 | 1 | 0 |
3483 | 3483 | 2020-03-17 | Wright | Minnesota | 27171 | 1 | 0 |
4053 | 4053 | 2020-03-18 | Benton | Minnesota | 27009 | 1 | 0 |
4062 | 4062 | 2020-03-18 | Renville | Minnesota | 27129 | 1 | 0 |
4063 | 4063 | 2020-03-18 | Rice | Minnesota | 27131 | 1 | 0 |
4065 | 4065 | 2020-03-18 | Waseca | Minnesota | 27161 | 1 | 0 |
4067 | 4067 | 2020-03-18 | Wright | Minnesota | 27171 | 1 | 0 |
4763 | 4763 | 2020-03-19 | Benton | Minnesota | 27009 | 1 | 0 |
4769 | 4769 | 2020-03-19 | Mower | Minnesota | 27099 | 1 | 0 |
4773 | 4773 | 2020-03-19 | Renville | Minnesota | 27129 | 1 | 0 |
4774 | 4774 | 2020-03-19 | Rice | Minnesota | 27131 | 1 | 0 |
4775 | 4775 | 2020-03-19 | Scott | Minnesota | 27139 | 1 | 0 |
5582 | 5582 | 2020-03-20 | Benton | Minnesota | 27009 | 1 | 0 |
5585 | 5585 | 2020-03-20 | Chisago | Minnesota | 27025 | 1 | 0 |
5586 | 5586 | 2020-03-20 | Clay | Minnesota | 27027 | 1 | 0 |
5591 | 5591 | 2020-03-20 | Mower | Minnesota | 27099 | 1 | 0 |
5595 | 5595 | 2020-03-20 | Renville | Minnesota | 27129 | 1 | 0 |
5596 | 5596 | 2020-03-20 | Rice | Minnesota | 27131 | 1 | 0 |
6550 | 6550 | 2020-03-21 | Benton | Minnesota | 27009 | 1 | 0 |
6553 | 6553 | 2020-03-21 | Chisago | Minnesota | 27025 | 1 | 0 |
6554 | 6554 | 2020-03-21 | Clay | Minnesota | 27027 | 1 | 0 |
6556 | 6556 | 2020-03-21 | Dodge | Minnesota | 27039 | 1 | 0 |
6559 | 6559 | 2020-03-21 | Jackson | Minnesota | 27063 | 1 | 0 |
6565 | 6565 | 2020-03-21 | Renville | Minnesota | 27129 | 1 | 0 |
6566 | 6566 | 2020-03-21 | Rice | Minnesota | 27131 | 1 | 0 |
6568 | 6568 | 2020-03-21 | St. Louis | Minnesota | 27137 | 1 | 0 |
6571 | 6571 | 2020-03-21 | Unknown | Minnesota | 1 | 0 | |
6572 | 6572 | 2020-03-21 | Wabasha | Minnesota | 27157 | 1 | 0 |
7631 | 7631 | 2020-03-22 | Benton | Minnesota | 27009 | 1 | 0 |
7634 | 7634 | 2020-03-22 | Chisago | Minnesota | 27025 | 1 | 0 |
7640 | 7640 | 2020-03-22 | Jackson | Minnesota | 27063 | 1 | 0 |
7641 | 7641 | 2020-03-22 | Le Sueur | Minnesota | 27079 | 1 | 0 |
7647 | 7647 | 2020-03-22 | Renville | Minnesota | 27129 | 1 | 0 |
7648 | 7648 | 2020-03-22 | Rice | Minnesota | 27131 | 1 | 0 |
7650 | 7650 | 2020-03-22 | St. Louis | Minnesota | 27137 | 1 | 0 |
7653 | 7653 | 2020-03-22 | Unknown | Minnesota | 1 | 0 | |
7654 | 7654 | 2020-03-22 | Wabasha | Minnesota | 27157 | 1 | 0 |
8807 | 8807 | 2020-03-23 | Benton | Minnesota | 27009 | 1 | 0 |
8808 | 8808 | 2020-03-23 | Big Stone | Minnesota | 27011 | 1 | 0 |
8811 | 8811 | 2020-03-23 | Cass | Minnesota | 27021 | 1 | 0 |
8818 | 8818 | 2020-03-23 | Jackson | Minnesota | 27063 | 1 | 0 |
8819 | 8819 | 2020-03-23 | Lac qui Parle | Minnesota | 27073 | 1 | 0 |
8820 | 8820 | 2020-03-23 | Le Sueur | Minnesota | 27079 | 1 | 0 |
8826 | 8826 | 2020-03-23 | Renville | Minnesota | 27129 | 1 | 0 |
8829 | 8829 | 2020-03-23 | Sherburne | Minnesota | 27141 | 1 | 0 |
8833 | 8833 | 2020-03-23 | Unknown | Minnesota | 1 | 0 | |
8834 | 8834 | 2020-03-23 | Wabasha | Minnesota | 27157 | 1 | 0 |
10102 | 10102 | 2020-03-24 | Benton | Minnesota | 27009 | 1 | 0 |
10103 | 10103 | 2020-03-24 | Big Stone | Minnesota | 27011 | 1 | 0 |
10106 | 10106 | 2020-03-24 | Cass | Minnesota | 27021 | 1 | 0 |
10113 | 10113 | 2020-03-24 | Jackson | Minnesota | 27063 | 1 | 0 |
10114 | 10114 | 2020-03-24 | Lac qui Parle | Minnesota | 27073 | 1 | 0 |
10121 | 10121 | 2020-03-24 | Renville | Minnesota | 27129 | 1 | 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);