ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 27061 and state = "Minnesota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20594 | 20594 | 2020-03-30 | Itasca | Minnesota | 27061 | 1 | 0 |
22708 | 22708 | 2020-03-31 | Itasca | Minnesota | 27061 | 1 | 0 |
24890 | 24890 | 2020-04-01 | Itasca | Minnesota | 27061 | 1 | 0 |
27143 | 27143 | 2020-04-02 | Itasca | Minnesota | 27061 | 2 | 0 |
29462 | 29462 | 2020-04-03 | Itasca | Minnesota | 27061 | 2 | 0 |
31840 | 31840 | 2020-04-04 | Itasca | Minnesota | 27061 | 2 | 0 |
34266 | 34266 | 2020-04-05 | Itasca | Minnesota | 27061 | 2 | 0 |
36726 | 36726 | 2020-04-06 | Itasca | Minnesota | 27061 | 2 | 0 |
39235 | 39235 | 2020-04-07 | Itasca | Minnesota | 27061 | 2 | 0 |
41788 | 41788 | 2020-04-08 | Itasca | Minnesota | 27061 | 2 | 0 |
44364 | 44364 | 2020-04-09 | Itasca | Minnesota | 27061 | 2 | 0 |
46973 | 46973 | 2020-04-10 | Itasca | Minnesota | 27061 | 2 | 0 |
49618 | 49618 | 2020-04-11 | Itasca | Minnesota | 27061 | 2 | 0 |
52288 | 52288 | 2020-04-12 | Itasca | Minnesota | 27061 | 2 | 0 |
54970 | 54970 | 2020-04-13 | Itasca | Minnesota | 27061 | 2 | 0 |
57668 | 57668 | 2020-04-14 | Itasca | Minnesota | 27061 | 2 | 0 |
60378 | 60378 | 2020-04-15 | Itasca | Minnesota | 27061 | 2 | 0 |
63100 | 63100 | 2020-04-16 | Itasca | Minnesota | 27061 | 2 | 0 |
65839 | 65839 | 2020-04-17 | Itasca | Minnesota | 27061 | 2 | 0 |
68590 | 68590 | 2020-04-18 | Itasca | Minnesota | 27061 | 2 | 0 |
71354 | 71354 | 2020-04-19 | Itasca | Minnesota | 27061 | 2 | 0 |
74127 | 74127 | 2020-04-20 | Itasca | Minnesota | 27061 | 2 | 0 |
76907 | 76907 | 2020-04-21 | Itasca | Minnesota | 27061 | 2 | 0 |
79692 | 79692 | 2020-04-22 | Itasca | Minnesota | 27061 | 2 | 0 |
82488 | 82488 | 2020-04-23 | Itasca | Minnesota | 27061 | 2 | 0 |
85292 | 85292 | 2020-04-24 | Itasca | Minnesota | 27061 | 2 | 0 |
88102 | 88102 | 2020-04-25 | Itasca | Minnesota | 27061 | 2 | 0 |
90918 | 90918 | 2020-04-26 | Itasca | Minnesota | 27061 | 2 | 0 |
93739 | 93739 | 2020-04-27 | Itasca | Minnesota | 27061 | 2 | 0 |
96574 | 96574 | 2020-04-28 | Itasca | Minnesota | 27061 | 2 | 0 |
99420 | 99420 | 2020-04-29 | Itasca | Minnesota | 27061 | 3 | 0 |
102272 | 102272 | 2020-04-30 | Itasca | Minnesota | 27061 | 5 | 0 |
105132 | 105132 | 2020-05-01 | Itasca | Minnesota | 27061 | 6 | 0 |
107997 | 107997 | 2020-05-02 | Itasca | Minnesota | 27061 | 7 | 0 |
110868 | 110868 | 2020-05-03 | Itasca | Minnesota | 27061 | 11 | 0 |
113747 | 113747 | 2020-05-04 | Itasca | Minnesota | 27061 | 12 | 0 |
116628 | 116628 | 2020-05-05 | Itasca | Minnesota | 27061 | 13 | 0 |
119588 | 119588 | 2020-05-06 | Itasca | Minnesota | 27061 | 24 | 0 |
122561 | 122561 | 2020-05-07 | Itasca | Minnesota | 27061 | 24 | 0 |
125543 | 125543 | 2020-05-08 | Itasca | Minnesota | 27061 | 24 | 0 |
128530 | 128530 | 2020-05-09 | Itasca | Minnesota | 27061 | 25 | 0 |
131520 | 131520 | 2020-05-10 | Itasca | Minnesota | 27061 | 28 | 0 |
134511 | 134511 | 2020-05-11 | Itasca | Minnesota | 27061 | 33 | 0 |
137501 | 137501 | 2020-05-12 | Itasca | Minnesota | 27061 | 35 | 2 |
140495 | 140495 | 2020-05-13 | Itasca | Minnesota | 27061 | 35 | 2 |
143490 | 143490 | 2020-05-14 | Itasca | Minnesota | 27061 | 41 | 2 |
146490 | 146490 | 2020-05-15 | Itasca | Minnesota | 27061 | 42 | 4 |
149495 | 149495 | 2020-05-16 | Itasca | Minnesota | 27061 | 43 | 4 |
152506 | 152506 | 2020-05-17 | Itasca | Minnesota | 27061 | 46 | 5 |
155520 | 155520 | 2020-05-18 | Itasca | Minnesota | 27061 | 49 | 5 |
158538 | 158538 | 2020-05-19 | Itasca | Minnesota | 27061 | 49 | 6 |
161564 | 161564 | 2020-05-20 | Itasca | Minnesota | 27061 | 50 | 6 |
164593 | 164593 | 2020-05-21 | Itasca | Minnesota | 27061 | 51 | 6 |
167629 | 167629 | 2020-05-22 | Itasca | Minnesota | 27061 | 51 | 6 |
170667 | 170667 | 2020-05-23 | Itasca | Minnesota | 27061 | 51 | 6 |
173709 | 173709 | 2020-05-24 | Itasca | Minnesota | 27061 | 52 | 7 |
176752 | 176752 | 2020-05-25 | Itasca | Minnesota | 27061 | 53 | 7 |
179796 | 179796 | 2020-05-26 | Itasca | Minnesota | 27061 | 53 | 7 |
182842 | 182842 | 2020-05-27 | Itasca | Minnesota | 27061 | 53 | 7 |
185897 | 185897 | 2020-05-28 | Itasca | Minnesota | 27061 | 54 | 8 |
188955 | 188955 | 2020-05-29 | Itasca | Minnesota | 27061 | 54 | 9 |
192019 | 192019 | 2020-05-30 | Itasca | Minnesota | 27061 | 54 | 10 |
195087 | 195087 | 2020-05-31 | Itasca | Minnesota | 27061 | 54 | 10 |
198158 | 198158 | 2020-06-01 | Itasca | Minnesota | 27061 | 55 | 10 |
201231 | 201231 | 2020-06-02 | Itasca | Minnesota | 27061 | 55 | 10 |
204308 | 204308 | 2020-06-03 | Itasca | Minnesota | 27061 | 56 | 10 |
207389 | 207389 | 2020-06-04 | Itasca | Minnesota | 27061 | 56 | 10 |
210470 | 210470 | 2020-06-05 | Itasca | Minnesota | 27061 | 56 | 10 |
213554 | 213554 | 2020-06-06 | Itasca | Minnesota | 27061 | 56 | 10 |
216642 | 216642 | 2020-06-07 | Itasca | Minnesota | 27061 | 56 | 11 |
219734 | 219734 | 2020-06-08 | Itasca | Minnesota | 27061 | 56 | 11 |
222829 | 222829 | 2020-06-09 | Itasca | Minnesota | 27061 | 57 | 11 |
225927 | 225927 | 2020-06-10 | Itasca | Minnesota | 27061 | 58 | 12 |
229029 | 229029 | 2020-06-11 | Itasca | Minnesota | 27061 | 58 | 12 |
232133 | 232133 | 2020-06-12 | Itasca | Minnesota | 27061 | 58 | 12 |
235239 | 235239 | 2020-06-13 | Itasca | Minnesota | 27061 | 58 | 12 |
238346 | 238346 | 2020-06-14 | Itasca | Minnesota | 27061 | 59 | 12 |
241455 | 241455 | 2020-06-15 | Itasca | Minnesota | 27061 | 59 | 12 |
244566 | 244566 | 2020-06-16 | Itasca | Minnesota | 27061 | 59 | 12 |
247679 | 247679 | 2020-06-17 | Itasca | Minnesota | 27061 | 59 | 12 |
250791 | 250791 | 2020-06-18 | Itasca | Minnesota | 27061 | 59 | 12 |
253906 | 253906 | 2020-06-19 | Itasca | Minnesota | 27061 | 59 | 12 |
257026 | 257026 | 2020-06-20 | Itasca | Minnesota | 27061 | 59 | 12 |
260152 | 260152 | 2020-06-21 | Itasca | Minnesota | 27061 | 59 | 12 |
263281 | 263281 | 2020-06-22 | Itasca | Minnesota | 27061 | 59 | 12 |
266407 | 266407 | 2020-06-23 | Itasca | Minnesota | 27061 | 59 | 12 |
269540 | 269540 | 2020-06-24 | Itasca | Minnesota | 27061 | 60 | 12 |
272677 | 272677 | 2020-06-25 | Itasca | Minnesota | 27061 | 63 | 12 |
275820 | 275820 | 2020-06-26 | Itasca | Minnesota | 27061 | 63 | 12 |
278968 | 278968 | 2020-06-27 | Itasca | Minnesota | 27061 | 64 | 12 |
282116 | 282116 | 2020-06-28 | Itasca | Minnesota | 27061 | 64 | 12 |
285261 | 285261 | 2020-06-29 | Itasca | Minnesota | 27061 | 64 | 12 |
288411 | 288411 | 2020-06-30 | Itasca | Minnesota | 27061 | 65 | 12 |
291562 | 291562 | 2020-07-01 | Itasca | Minnesota | 27061 | 65 | 12 |
294716 | 294716 | 2020-07-02 | Itasca | Minnesota | 27061 | 64 | 12 |
297874 | 297874 | 2020-07-03 | Itasca | Minnesota | 27061 | 64 | 12 |
301037 | 301037 | 2020-07-04 | Itasca | Minnesota | 27061 | 64 | 12 |
304201 | 304201 | 2020-07-05 | Itasca | Minnesota | 27061 | 64 | 12 |
307368 | 307368 | 2020-07-06 | Itasca | Minnesota | 27061 | 64 | 12 |
310536 | 310536 | 2020-07-07 | Itasca | Minnesota | 27061 | 64 | 12 |
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);