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 descending
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 |
---|---|---|---|---|---|---|---|
24922 | 24922 | 2020-04-01 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
27176 | 27176 | 2020-04-02 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
29495 | 29495 | 2020-04-03 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
31875 | 31875 | 2020-04-04 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
34302 | 34302 | 2020-04-05 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
36764 | 36764 | 2020-04-06 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
39275 | 39275 | 2020-04-07 | Yellow Medicine | Minnesota | 27173 | 1 | 0 |
41829 | 41829 | 2020-04-08 | Yellow Medicine | Minnesota | 27173 | 2 | 0 |
44405 | 44405 | 2020-04-09 | Yellow Medicine | Minnesota | 27173 | 2 | 0 |
47014 | 47014 | 2020-04-10 | Yellow Medicine | Minnesota | 27173 | 2 | 0 |
49660 | 49660 | 2020-04-11 | Yellow Medicine | Minnesota | 27173 | 2 | 0 |
52333 | 52333 | 2020-04-12 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
55015 | 55015 | 2020-04-13 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
57713 | 57713 | 2020-04-14 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
60424 | 60424 | 2020-04-15 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
63146 | 63146 | 2020-04-16 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
65886 | 65886 | 2020-04-17 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
68638 | 68638 | 2020-04-18 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
71404 | 71404 | 2020-04-19 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
74177 | 74177 | 2020-04-20 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
76958 | 76958 | 2020-04-21 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
79743 | 79743 | 2020-04-22 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
82539 | 82539 | 2020-04-23 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
85343 | 85343 | 2020-04-24 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
88153 | 88153 | 2020-04-25 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
90969 | 90969 | 2020-04-26 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
93790 | 93790 | 2020-04-27 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
96626 | 96626 | 2020-04-28 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
99472 | 99472 | 2020-04-29 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
102324 | 102324 | 2020-04-30 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
105185 | 105185 | 2020-05-01 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
108050 | 108050 | 2020-05-02 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
110921 | 110921 | 2020-05-03 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
113800 | 113800 | 2020-05-04 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
116682 | 116682 | 2020-05-05 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
119642 | 119642 | 2020-05-06 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
122616 | 122616 | 2020-05-07 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
125598 | 125598 | 2020-05-08 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
128585 | 128585 | 2020-05-09 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
131575 | 131575 | 2020-05-10 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
134566 | 134566 | 2020-05-11 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
137556 | 137556 | 2020-05-12 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
140550 | 140550 | 2020-05-13 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
143545 | 143545 | 2020-05-14 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
146545 | 146545 | 2020-05-15 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
149550 | 149550 | 2020-05-16 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
152561 | 152561 | 2020-05-17 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
155575 | 155575 | 2020-05-18 | Yellow Medicine | Minnesota | 27173 | 3 | 0 |
158593 | 158593 | 2020-05-19 | Yellow Medicine | Minnesota | 27173 | 4 | 0 |
161619 | 161619 | 2020-05-20 | Yellow Medicine | Minnesota | 27173 | 5 | 0 |
164648 | 164648 | 2020-05-21 | Yellow Medicine | Minnesota | 27173 | 5 | 0 |
167684 | 167684 | 2020-05-22 | Yellow Medicine | Minnesota | 27173 | 5 | 0 |
170722 | 170722 | 2020-05-23 | Yellow Medicine | Minnesota | 27173 | 5 | 0 |
173764 | 173764 | 2020-05-24 | Yellow Medicine | Minnesota | 27173 | 5 | 0 |
176807 | 176807 | 2020-05-25 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
179851 | 179851 | 2020-05-26 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
182897 | 182897 | 2020-05-27 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
185953 | 185953 | 2020-05-28 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
189011 | 189011 | 2020-05-29 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
192075 | 192075 | 2020-05-30 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
195143 | 195143 | 2020-05-31 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
198214 | 198214 | 2020-06-01 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
201287 | 201287 | 2020-06-02 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
204364 | 204364 | 2020-06-03 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
207445 | 207445 | 2020-06-04 | Yellow Medicine | Minnesota | 27173 | 6 | 0 |
210526 | 210526 | 2020-06-05 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
213610 | 213610 | 2020-06-06 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
216698 | 216698 | 2020-06-07 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
219790 | 219790 | 2020-06-08 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
222885 | 222885 | 2020-06-09 | Yellow Medicine | Minnesota | 27173 | 7 | 0 |
225983 | 225983 | 2020-06-10 | Yellow Medicine | Minnesota | 27173 | 8 | 0 |
229085 | 229085 | 2020-06-11 | Yellow Medicine | Minnesota | 27173 | 8 | 0 |
232189 | 232189 | 2020-06-12 | Yellow Medicine | Minnesota | 27173 | 8 | 0 |
235295 | 235295 | 2020-06-13 | Yellow Medicine | Minnesota | 27173 | 9 | 0 |
238402 | 238402 | 2020-06-14 | Yellow Medicine | Minnesota | 27173 | 9 | 0 |
241511 | 241511 | 2020-06-15 | Yellow Medicine | Minnesota | 27173 | 10 | 0 |
244622 | 244622 | 2020-06-16 | Yellow Medicine | Minnesota | 27173 | 11 | 0 |
247735 | 247735 | 2020-06-17 | Yellow Medicine | Minnesota | 27173 | 10 | 0 |
250847 | 250847 | 2020-06-18 | Yellow Medicine | Minnesota | 27173 | 11 | 0 |
253962 | 253962 | 2020-06-19 | Yellow Medicine | Minnesota | 27173 | 14 | 0 |
257082 | 257082 | 2020-06-20 | Yellow Medicine | Minnesota | 27173 | 22 | 0 |
260208 | 260208 | 2020-06-21 | Yellow Medicine | Minnesota | 27173 | 22 | 0 |
263337 | 263337 | 2020-06-22 | Yellow Medicine | Minnesota | 27173 | 24 | 0 |
266463 | 266463 | 2020-06-23 | Yellow Medicine | Minnesota | 27173 | 23 | 0 |
269596 | 269596 | 2020-06-24 | Yellow Medicine | Minnesota | 27173 | 24 | 0 |
272733 | 272733 | 2020-06-25 | Yellow Medicine | Minnesota | 27173 | 24 | 0 |
275876 | 275876 | 2020-06-26 | Yellow Medicine | Minnesota | 27173 | 25 | 0 |
279024 | 279024 | 2020-06-27 | Yellow Medicine | Minnesota | 27173 | 25 | 0 |
282172 | 282172 | 2020-06-28 | Yellow Medicine | Minnesota | 27173 | 27 | 0 |
285317 | 285317 | 2020-06-29 | Yellow Medicine | Minnesota | 27173 | 27 | 0 |
288467 | 288467 | 2020-06-30 | Yellow Medicine | Minnesota | 27173 | 29 | 0 |
291618 | 291618 | 2020-07-01 | Yellow Medicine | Minnesota | 27173 | 29 | 0 |
294772 | 294772 | 2020-07-02 | Yellow Medicine | Minnesota | 27173 | 29 | 0 |
297930 | 297930 | 2020-07-03 | Yellow Medicine | Minnesota | 27173 | 30 | 0 |
301093 | 301093 | 2020-07-04 | Yellow Medicine | Minnesota | 27173 | 30 | 0 |
304257 | 304257 | 2020-07-05 | Yellow Medicine | Minnesota | 27173 | 30 | 0 |
307424 | 307424 | 2020-07-06 | Yellow Medicine | Minnesota | 27173 | 30 | 0 |
310592 | 310592 | 2020-07-07 | Yellow Medicine | Minnesota | 27173 | 30 | 0 |
313762 | 313762 | 2020-07-08 | Yellow Medicine | Minnesota | 27173 | 30 | 0 |
316936 | 316936 | 2020-07-09 | Yellow Medicine | Minnesota | 27173 | 31 | 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);