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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
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 |
1265 | 1265 | 2020-03-11 | Ramsey | Minnesota | 27123 | 2 | 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 |
1490 | 1490 | 2020-03-12 | Ramsey | Minnesota | 27123 | 2 | 0 |
1491 | 1491 | 2020-03-12 | Stearns | Minnesota | 27145 | 2 | 0 |
1768 | 1768 | 2020-03-13 | Anoka | Minnesota | 27003 | 1 | 0 |
1769 | 1769 | 2020-03-13 | Carver | Minnesota | 27019 | 1 | 0 |
1770 | 1770 | 2020-03-13 | Dakota | Minnesota | 27037 | 2 | 0 |
1771 | 1771 | 2020-03-13 | Hennepin | Minnesota | 27053 | 3 | 0 |
1772 | 1772 | 2020-03-13 | Olmsted | Minnesota | 27109 | 1 | 0 |
1773 | 1773 | 2020-03-13 | Ramsey | Minnesota | 27123 | 3 | 0 |
1774 | 1774 | 2020-03-13 | Stearns | Minnesota | 27145 | 2 | 0 |
1775 | 1775 | 2020-03-13 | Wright | Minnesota | 27171 | 1 | 0 |
2112 | 2112 | 2020-03-14 | Anoka | Minnesota | 27003 | 2 | 0 |
2113 | 2113 | 2020-03-14 | Carver | Minnesota | 27019 | 1 | 0 |
2114 | 2114 | 2020-03-14 | Dakota | Minnesota | 27037 | 2 | 0 |
2115 | 2115 | 2020-03-14 | Hennepin | Minnesota | 27053 | 6 | 0 |
2116 | 2116 | 2020-03-14 | Olmsted | Minnesota | 27109 | 1 | 0 |
2117 | 2117 | 2020-03-14 | Ramsey | Minnesota | 27123 | 4 | 0 |
2118 | 2118 | 2020-03-14 | Renville | Minnesota | 27129 | 1 | 0 |
2119 | 2119 | 2020-03-14 | Stearns | Minnesota | 27145 | 3 | 0 |
2120 | 2120 | 2020-03-14 | Wright | Minnesota | 27171 | 1 | 0 |
2516 | 2516 | 2020-03-15 | Anoka | Minnesota | 27003 | 2 | 0 |
2517 | 2517 | 2020-03-15 | Carver | Minnesota | 27019 | 1 | 0 |
2518 | 2518 | 2020-03-15 | Dakota | Minnesota | 27037 | 3 | 0 |
2519 | 2519 | 2020-03-15 | Hennepin | Minnesota | 27053 | 12 | 0 |
2520 | 2520 | 2020-03-15 | Olmsted | Minnesota | 27109 | 2 | 0 |
2521 | 2521 | 2020-03-15 | Ramsey | Minnesota | 27123 | 8 | 0 |
2522 | 2522 | 2020-03-15 | Renville | Minnesota | 27129 | 1 | 0 |
2523 | 2523 | 2020-03-15 | Stearns | Minnesota | 27145 | 3 | 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 |
2966 | 2966 | 2020-03-16 | Anoka | Minnesota | 27003 | 3 | 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 |
2970 | 2970 | 2020-03-16 | Dakota | Minnesota | 27037 | 4 | 0 |
2971 | 2971 | 2020-03-16 | Hennepin | Minnesota | 27053 | 26 | 0 |
2972 | 2972 | 2020-03-16 | Olmsted | Minnesota | 27109 | 3 | 0 |
2973 | 2973 | 2020-03-16 | Ramsey | Minnesota | 27123 | 8 | 0 |
2974 | 2974 | 2020-03-16 | Renville | Minnesota | 27129 | 1 | 0 |
2975 | 2975 | 2020-03-16 | Stearns | Minnesota | 27145 | 3 | 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 |
3469 | 3469 | 2020-03-17 | Anoka | Minnesota | 27003 | 3 | 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 |
3473 | 3473 | 2020-03-17 | Dakota | Minnesota | 27037 | 7 | 0 |
3474 | 3474 | 2020-03-17 | Hennepin | Minnesota | 27053 | 26 | 0 |
3475 | 3475 | 2020-03-17 | Martin | Minnesota | 27091 | 2 | 0 |
3476 | 3476 | 2020-03-17 | Nicollet | Minnesota | 27103 | 1 | 0 |
3477 | 3477 | 2020-03-17 | Olmsted | Minnesota | 27109 | 3 | 0 |
3478 | 3478 | 2020-03-17 | Ramsey | Minnesota | 27123 | 8 | 0 |
3479 | 3479 | 2020-03-17 | Renville | Minnesota | 27129 | 1 | 0 |
3480 | 3480 | 2020-03-17 | Stearns | Minnesota | 27145 | 3 | 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 |
4052 | 4052 | 2020-03-18 | Anoka | Minnesota | 27003 | 3 | 0 |
4053 | 4053 | 2020-03-18 | Benton | Minnesota | 27009 | 1 | 0 |
4054 | 4054 | 2020-03-18 | Blue Earth | Minnesota | 27013 | 2 | 0 |
4055 | 4055 | 2020-03-18 | Carver | Minnesota | 27019 | 2 | 0 |
4056 | 4056 | 2020-03-18 | Dakota | Minnesota | 27037 | 7 | 0 |
4057 | 4057 | 2020-03-18 | Hennepin | Minnesota | 27053 | 33 | 0 |
4058 | 4058 | 2020-03-18 | Martin | Minnesota | 27091 | 3 | 0 |
4059 | 4059 | 2020-03-18 | Nicollet | Minnesota | 27103 | 2 | 0 |
4060 | 4060 | 2020-03-18 | Olmsted | Minnesota | 27109 | 6 | 0 |
4061 | 4061 | 2020-03-18 | Ramsey | Minnesota | 27123 | 8 | 0 |
4062 | 4062 | 2020-03-18 | Renville | Minnesota | 27129 | 1 | 0 |
4063 | 4063 | 2020-03-18 | Rice | Minnesota | 27131 | 1 | 0 |
4064 | 4064 | 2020-03-18 | Stearns | Minnesota | 27145 | 3 | 0 |
4065 | 4065 | 2020-03-18 | Waseca | Minnesota | 27161 | 1 | 0 |
4066 | 4066 | 2020-03-18 | Washington | Minnesota | 27163 | 3 | 0 |
4067 | 4067 | 2020-03-18 | Wright | Minnesota | 27171 | 1 | 0 |
4762 | 4762 | 2020-03-19 | Anoka | Minnesota | 27003 | 5 | 0 |
4763 | 4763 | 2020-03-19 | Benton | Minnesota | 27009 | 1 | 0 |
4764 | 4764 | 2020-03-19 | Blue Earth | Minnesota | 27013 | 2 | 0 |
4765 | 4765 | 2020-03-19 | Carver | Minnesota | 27019 | 3 | 0 |
4766 | 4766 | 2020-03-19 | Dakota | Minnesota | 27037 | 7 | 0 |
4767 | 4767 | 2020-03-19 | Hennepin | Minnesota | 27053 | 33 | 0 |
4768 | 4768 | 2020-03-19 | Martin | Minnesota | 27091 | 3 | 0 |
4769 | 4769 | 2020-03-19 | Mower | Minnesota | 27099 | 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);