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)
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,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);