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)
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 |
---|---|---|---|---|---|---|---|
65813 | 65813 | 2020-04-17 | Aitkin | Minnesota | 27001 | 1 | 0 |
68564 | 68564 | 2020-04-18 | Aitkin | Minnesota | 27001 | 1 | 0 |
71328 | 71328 | 2020-04-19 | Aitkin | Minnesota | 27001 | 1 | 0 |
74100 | 74100 | 2020-04-20 | Aitkin | Minnesota | 27001 | 1 | 0 |
76880 | 76880 | 2020-04-21 | Aitkin | Minnesota | 27001 | 1 | 0 |
79665 | 79665 | 2020-04-22 | Aitkin | Minnesota | 27001 | 1 | 0 |
82461 | 82461 | 2020-04-23 | Aitkin | Minnesota | 27001 | 1 | 0 |
85265 | 85265 | 2020-04-24 | Aitkin | Minnesota | 27001 | 1 | 0 |
88075 | 88075 | 2020-04-25 | Aitkin | Minnesota | 27001 | 1 | 0 |
90891 | 90891 | 2020-04-26 | Aitkin | Minnesota | 27001 | 1 | 0 |
93712 | 93712 | 2020-04-27 | Aitkin | Minnesota | 27001 | 1 | 0 |
96547 | 96547 | 2020-04-28 | Aitkin | Minnesota | 27001 | 1 | 0 |
99393 | 99393 | 2020-04-29 | Aitkin | Minnesota | 27001 | 1 | 0 |
102245 | 102245 | 2020-04-30 | Aitkin | Minnesota | 27001 | 1 | 0 |
105105 | 105105 | 2020-05-01 | Aitkin | Minnesota | 27001 | 1 | 0 |
107969 | 107969 | 2020-05-02 | Aitkin | Minnesota | 27001 | 1 | 0 |
110840 | 110840 | 2020-05-03 | Aitkin | Minnesota | 27001 | 1 | 0 |
113719 | 113719 | 2020-05-04 | Aitkin | Minnesota | 27001 | 1 | 0 |
116600 | 116600 | 2020-05-05 | Aitkin | Minnesota | 27001 | 1 | 0 |
119560 | 119560 | 2020-05-06 | Aitkin | Minnesota | 27001 | 1 | 0 |
122533 | 122533 | 2020-05-07 | Aitkin | Minnesota | 27001 | 1 | 0 |
125515 | 125515 | 2020-05-08 | Aitkin | Minnesota | 27001 | 2 | 0 |
128502 | 128502 | 2020-05-09 | Aitkin | Minnesota | 27001 | 2 | 0 |
131492 | 131492 | 2020-05-10 | Aitkin | Minnesota | 27001 | 2 | 0 |
134483 | 134483 | 2020-05-11 | Aitkin | Minnesota | 27001 | 2 | 0 |
137473 | 137473 | 2020-05-12 | Aitkin | Minnesota | 27001 | 2 | 0 |
140467 | 140467 | 2020-05-13 | Aitkin | Minnesota | 27001 | 2 | 0 |
143462 | 143462 | 2020-05-14 | Aitkin | Minnesota | 27001 | 2 | 0 |
146462 | 146462 | 2020-05-15 | Aitkin | Minnesota | 27001 | 2 | 0 |
149467 | 149467 | 2020-05-16 | Aitkin | Minnesota | 27001 | 3 | 0 |
152478 | 152478 | 2020-05-17 | Aitkin | Minnesota | 27001 | 3 | 0 |
155492 | 155492 | 2020-05-18 | Aitkin | Minnesota | 27001 | 4 | 0 |
158510 | 158510 | 2020-05-19 | Aitkin | Minnesota | 27001 | 4 | 0 |
161536 | 161536 | 2020-05-20 | Aitkin | Minnesota | 27001 | 4 | 0 |
164565 | 164565 | 2020-05-21 | Aitkin | Minnesota | 27001 | 4 | 0 |
167601 | 167601 | 2020-05-22 | Aitkin | Minnesota | 27001 | 4 | 0 |
170638 | 170638 | 2020-05-23 | Aitkin | Minnesota | 27001 | 6 | 0 |
173680 | 173680 | 2020-05-24 | Aitkin | Minnesota | 27001 | 6 | 0 |
176723 | 176723 | 2020-05-25 | Aitkin | Minnesota | 27001 | 6 | 0 |
179767 | 179767 | 2020-05-26 | Aitkin | Minnesota | 27001 | 7 | 0 |
182813 | 182813 | 2020-05-27 | Aitkin | Minnesota | 27001 | 7 | 0 |
185868 | 185868 | 2020-05-28 | Aitkin | Minnesota | 27001 | 7 | 0 |
188926 | 188926 | 2020-05-29 | Aitkin | Minnesota | 27001 | 7 | 0 |
191990 | 191990 | 2020-05-30 | Aitkin | Minnesota | 27001 | 8 | 0 |
195058 | 195058 | 2020-05-31 | Aitkin | Minnesota | 27001 | 8 | 0 |
198129 | 198129 | 2020-06-01 | Aitkin | Minnesota | 27001 | 8 | 0 |
201202 | 201202 | 2020-06-02 | Aitkin | Minnesota | 27001 | 11 | 0 |
204279 | 204279 | 2020-06-03 | Aitkin | Minnesota | 27001 | 11 | 0 |
207360 | 207360 | 2020-06-04 | Aitkin | Minnesota | 27001 | 11 | 0 |
210441 | 210441 | 2020-06-05 | Aitkin | Minnesota | 27001 | 12 | 0 |
213525 | 213525 | 2020-06-06 | Aitkin | Minnesota | 27001 | 12 | 0 |
216613 | 216613 | 2020-06-07 | Aitkin | Minnesota | 27001 | 12 | 0 |
219705 | 219705 | 2020-06-08 | Aitkin | Minnesota | 27001 | 12 | 0 |
222800 | 222800 | 2020-06-09 | Aitkin | Minnesota | 27001 | 13 | 0 |
225898 | 225898 | 2020-06-10 | Aitkin | Minnesota | 27001 | 13 | 0 |
229000 | 229000 | 2020-06-11 | Aitkin | Minnesota | 27001 | 13 | 0 |
232104 | 232104 | 2020-06-12 | Aitkin | Minnesota | 27001 | 13 | 0 |
235209 | 235209 | 2020-06-13 | Aitkin | Minnesota | 27001 | 13 | 0 |
238316 | 238316 | 2020-06-14 | Aitkin | Minnesota | 27001 | 13 | 0 |
241425 | 241425 | 2020-06-15 | Aitkin | Minnesota | 27001 | 13 | 0 |
244536 | 244536 | 2020-06-16 | Aitkin | Minnesota | 27001 | 13 | 0 |
247649 | 247649 | 2020-06-17 | Aitkin | Minnesota | 27001 | 13 | 0 |
250761 | 250761 | 2020-06-18 | Aitkin | Minnesota | 27001 | 13 | 0 |
253876 | 253876 | 2020-06-19 | Aitkin | Minnesota | 27001 | 13 | 0 |
256996 | 256996 | 2020-06-20 | Aitkin | Minnesota | 27001 | 13 | 0 |
260122 | 260122 | 2020-06-21 | Aitkin | Minnesota | 27001 | 13 | 0 |
263251 | 263251 | 2020-06-22 | Aitkin | Minnesota | 27001 | 13 | 0 |
266377 | 266377 | 2020-06-23 | Aitkin | Minnesota | 27001 | 13 | 0 |
269510 | 269510 | 2020-06-24 | Aitkin | Minnesota | 27001 | 13 | 0 |
272647 | 272647 | 2020-06-25 | Aitkin | Minnesota | 27001 | 13 | 0 |
275790 | 275790 | 2020-06-26 | Aitkin | Minnesota | 27001 | 13 | 0 |
278938 | 278938 | 2020-06-27 | Aitkin | Minnesota | 27001 | 13 | 0 |
282086 | 282086 | 2020-06-28 | Aitkin | Minnesota | 27001 | 13 | 0 |
285231 | 285231 | 2020-06-29 | Aitkin | Minnesota | 27001 | 13 | 0 |
288381 | 288381 | 2020-06-30 | Aitkin | Minnesota | 27001 | 14 | 0 |
291532 | 291532 | 2020-07-01 | Aitkin | Minnesota | 27001 | 14 | 0 |
294686 | 294686 | 2020-07-02 | Aitkin | Minnesota | 27001 | 14 | 0 |
297844 | 297844 | 2020-07-03 | Aitkin | Minnesota | 27001 | 14 | 0 |
301007 | 301007 | 2020-07-04 | Aitkin | Minnesota | 27001 | 14 | 0 |
304171 | 304171 | 2020-07-05 | Aitkin | Minnesota | 27001 | 15 | 0 |
307338 | 307338 | 2020-07-06 | Aitkin | Minnesota | 27001 | 15 | 0 |
310506 | 310506 | 2020-07-07 | Aitkin | Minnesota | 27001 | 15 | 0 |
313676 | 313676 | 2020-07-08 | Aitkin | Minnesota | 27001 | 15 | 0 |
316850 | 316850 | 2020-07-09 | Aitkin | Minnesota | 27001 | 15 | 0 |
320025 | 320025 | 2020-07-10 | Aitkin | Minnesota | 27001 | 15 | 0 |
323204 | 323204 | 2020-07-11 | Aitkin | Minnesota | 27001 | 15 | 0 |
326387 | 326387 | 2020-07-12 | Aitkin | Minnesota | 27001 | 16 | 0 |
329573 | 329573 | 2020-07-13 | Aitkin | Minnesota | 27001 | 16 | 0 |
332760 | 332760 | 2020-07-14 | Aitkin | Minnesota | 27001 | 17 | 0 |
335953 | 335953 | 2020-07-15 | Aitkin | Minnesota | 27001 | 17 | 0 |
339149 | 339149 | 2020-07-16 | Aitkin | Minnesota | 27001 | 18 | 0 |
342345 | 342345 | 2020-07-17 | Aitkin | Minnesota | 27001 | 18 | 0 |
345545 | 345545 | 2020-07-18 | Aitkin | Minnesota | 27001 | 18 | 0 |
348746 | 348746 | 2020-07-19 | Aitkin | Minnesota | 27001 | 19 | 0 |
351946 | 351946 | 2020-07-20 | Aitkin | Minnesota | 27001 | 19 | 0 |
355148 | 355148 | 2020-07-21 | Aitkin | Minnesota | 27001 | 21 | 0 |
358351 | 358351 | 2020-07-22 | Aitkin | Minnesota | 27001 | 22 | 0 |
361556 | 361556 | 2020-07-23 | Aitkin | Minnesota | 27001 | 24 | 0 |
364763 | 364763 | 2020-07-24 | Aitkin | Minnesota | 27001 | 24 | 0 |
367970 | 367970 | 2020-07-25 | Aitkin | Minnesota | 27001 | 24 | 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);