ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 27127 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 |
---|---|---|---|---|---|---|---|
36746 | 36746 | 2020-04-06 | Redwood | Minnesota | 27127 | 1 | 0 |
39255 | 39255 | 2020-04-07 | Redwood | Minnesota | 27127 | 1 | 0 |
41809 | 41809 | 2020-04-08 | Redwood | Minnesota | 27127 | 1 | 0 |
44385 | 44385 | 2020-04-09 | Redwood | Minnesota | 27127 | 1 | 0 |
46995 | 46995 | 2020-04-10 | Redwood | Minnesota | 27127 | 1 | 0 |
49640 | 49640 | 2020-04-11 | Redwood | Minnesota | 27127 | 1 | 0 |
52311 | 52311 | 2020-04-12 | Redwood | Minnesota | 27127 | 1 | 0 |
54993 | 54993 | 2020-04-13 | Redwood | Minnesota | 27127 | 1 | 0 |
57691 | 57691 | 2020-04-14 | Redwood | Minnesota | 27127 | 1 | 0 |
60402 | 60402 | 2020-04-15 | Redwood | Minnesota | 27127 | 1 | 0 |
63125 | 63125 | 2020-04-16 | Redwood | Minnesota | 27127 | 1 | 0 |
65864 | 65864 | 2020-04-17 | Redwood | Minnesota | 27127 | 1 | 0 |
68616 | 68616 | 2020-04-18 | Redwood | Minnesota | 27127 | 1 | 0 |
71382 | 71382 | 2020-04-19 | Redwood | Minnesota | 27127 | 1 | 0 |
74155 | 74155 | 2020-04-20 | Redwood | Minnesota | 27127 | 1 | 0 |
76936 | 76936 | 2020-04-21 | Redwood | Minnesota | 27127 | 1 | 0 |
79721 | 79721 | 2020-04-22 | Redwood | Minnesota | 27127 | 1 | 0 |
82517 | 82517 | 2020-04-23 | Redwood | Minnesota | 27127 | 1 | 0 |
85321 | 85321 | 2020-04-24 | Redwood | Minnesota | 27127 | 1 | 0 |
88131 | 88131 | 2020-04-25 | Redwood | Minnesota | 27127 | 1 | 0 |
90947 | 90947 | 2020-04-26 | Redwood | Minnesota | 27127 | 1 | 0 |
93768 | 93768 | 2020-04-27 | Redwood | Minnesota | 27127 | 1 | 0 |
96603 | 96603 | 2020-04-28 | Redwood | Minnesota | 27127 | 1 | 0 |
99449 | 99449 | 2020-04-29 | Redwood | Minnesota | 27127 | 1 | 0 |
102301 | 102301 | 2020-04-30 | Redwood | Minnesota | 27127 | 2 | 0 |
105162 | 105162 | 2020-05-01 | Redwood | Minnesota | 27127 | 3 | 0 |
108027 | 108027 | 2020-05-02 | Redwood | Minnesota | 27127 | 3 | 0 |
110898 | 110898 | 2020-05-03 | Redwood | Minnesota | 27127 | 3 | 0 |
113777 | 113777 | 2020-05-04 | Redwood | Minnesota | 27127 | 3 | 0 |
116659 | 116659 | 2020-05-05 | Redwood | Minnesota | 27127 | 3 | 0 |
119619 | 119619 | 2020-05-06 | Redwood | Minnesota | 27127 | 3 | 0 |
122593 | 122593 | 2020-05-07 | Redwood | Minnesota | 27127 | 3 | 0 |
125575 | 125575 | 2020-05-08 | Redwood | Minnesota | 27127 | 3 | 0 |
128562 | 128562 | 2020-05-09 | Redwood | Minnesota | 27127 | 3 | 0 |
131552 | 131552 | 2020-05-10 | Redwood | Minnesota | 27127 | 3 | 0 |
134543 | 134543 | 2020-05-11 | Redwood | Minnesota | 27127 | 3 | 0 |
137533 | 137533 | 2020-05-12 | Redwood | Minnesota | 27127 | 3 | 0 |
140527 | 140527 | 2020-05-13 | Redwood | Minnesota | 27127 | 3 | 0 |
143522 | 143522 | 2020-05-14 | Redwood | Minnesota | 27127 | 3 | 0 |
146522 | 146522 | 2020-05-15 | Redwood | Minnesota | 27127 | 3 | 0 |
149527 | 149527 | 2020-05-16 | Redwood | Minnesota | 27127 | 3 | 0 |
152538 | 152538 | 2020-05-17 | Redwood | Minnesota | 27127 | 3 | 0 |
155552 | 155552 | 2020-05-18 | Redwood | Minnesota | 27127 | 3 | 0 |
158570 | 158570 | 2020-05-19 | Redwood | Minnesota | 27127 | 3 | 0 |
161596 | 161596 | 2020-05-20 | Redwood | Minnesota | 27127 | 3 | 0 |
164625 | 164625 | 2020-05-21 | Redwood | Minnesota | 27127 | 3 | 0 |
167661 | 167661 | 2020-05-22 | Redwood | Minnesota | 27127 | 3 | 0 |
170699 | 170699 | 2020-05-23 | Redwood | Minnesota | 27127 | 3 | 0 |
173741 | 173741 | 2020-05-24 | Redwood | Minnesota | 27127 | 3 | 0 |
176784 | 176784 | 2020-05-25 | Redwood | Minnesota | 27127 | 3 | 0 |
179828 | 179828 | 2020-05-26 | Redwood | Minnesota | 27127 | 3 | 0 |
182874 | 182874 | 2020-05-27 | Redwood | Minnesota | 27127 | 3 | 0 |
185929 | 185929 | 2020-05-28 | Redwood | Minnesota | 27127 | 4 | 0 |
188987 | 188987 | 2020-05-29 | Redwood | Minnesota | 27127 | 4 | 0 |
192051 | 192051 | 2020-05-30 | Redwood | Minnesota | 27127 | 4 | 0 |
195119 | 195119 | 2020-05-31 | Redwood | Minnesota | 27127 | 5 | 0 |
198190 | 198190 | 2020-06-01 | Redwood | Minnesota | 27127 | 5 | 0 |
201263 | 201263 | 2020-06-02 | Redwood | Minnesota | 27127 | 6 | 0 |
204340 | 204340 | 2020-06-03 | Redwood | Minnesota | 27127 | 6 | 0 |
207421 | 207421 | 2020-06-04 | Redwood | Minnesota | 27127 | 7 | 0 |
210502 | 210502 | 2020-06-05 | Redwood | Minnesota | 27127 | 7 | 0 |
213586 | 213586 | 2020-06-06 | Redwood | Minnesota | 27127 | 7 | 0 |
216674 | 216674 | 2020-06-07 | Redwood | Minnesota | 27127 | 7 | 0 |
219766 | 219766 | 2020-06-08 | Redwood | Minnesota | 27127 | 8 | 0 |
222861 | 222861 | 2020-06-09 | Redwood | Minnesota | 27127 | 8 | 0 |
225959 | 225959 | 2020-06-10 | Redwood | Minnesota | 27127 | 8 | 0 |
229061 | 229061 | 2020-06-11 | Redwood | Minnesota | 27127 | 8 | 0 |
232165 | 232165 | 2020-06-12 | Redwood | Minnesota | 27127 | 10 | 0 |
235271 | 235271 | 2020-06-13 | Redwood | Minnesota | 27127 | 10 | 0 |
238378 | 238378 | 2020-06-14 | Redwood | Minnesota | 27127 | 11 | 0 |
241487 | 241487 | 2020-06-15 | Redwood | Minnesota | 27127 | 10 | 0 |
244598 | 244598 | 2020-06-16 | Redwood | Minnesota | 27127 | 12 | 0 |
247711 | 247711 | 2020-06-17 | Redwood | Minnesota | 27127 | 12 | 0 |
250823 | 250823 | 2020-06-18 | Redwood | Minnesota | 27127 | 12 | 0 |
253938 | 253938 | 2020-06-19 | Redwood | Minnesota | 27127 | 12 | 0 |
257058 | 257058 | 2020-06-20 | Redwood | Minnesota | 27127 | 12 | 0 |
260184 | 260184 | 2020-06-21 | Redwood | Minnesota | 27127 | 12 | 0 |
263313 | 263313 | 2020-06-22 | Redwood | Minnesota | 27127 | 12 | 0 |
266439 | 266439 | 2020-06-23 | Redwood | Minnesota | 27127 | 12 | 0 |
269572 | 269572 | 2020-06-24 | Redwood | Minnesota | 27127 | 12 | 0 |
272709 | 272709 | 2020-06-25 | Redwood | Minnesota | 27127 | 12 | 0 |
275852 | 275852 | 2020-06-26 | Redwood | Minnesota | 27127 | 14 | 0 |
279000 | 279000 | 2020-06-27 | Redwood | Minnesota | 27127 | 14 | 0 |
282148 | 282148 | 2020-06-28 | Redwood | Minnesota | 27127 | 14 | 0 |
285293 | 285293 | 2020-06-29 | Redwood | Minnesota | 27127 | 16 | 0 |
288443 | 288443 | 2020-06-30 | Redwood | Minnesota | 27127 | 16 | 0 |
291594 | 291594 | 2020-07-01 | Redwood | Minnesota | 27127 | 17 | 0 |
294748 | 294748 | 2020-07-02 | Redwood | Minnesota | 27127 | 17 | 0 |
297906 | 297906 | 2020-07-03 | Redwood | Minnesota | 27127 | 18 | 0 |
301069 | 301069 | 2020-07-04 | Redwood | Minnesota | 27127 | 18 | 0 |
304233 | 304233 | 2020-07-05 | Redwood | Minnesota | 27127 | 18 | 0 |
307400 | 307400 | 2020-07-06 | Redwood | Minnesota | 27127 | 18 | 0 |
310568 | 310568 | 2020-07-07 | Redwood | Minnesota | 27127 | 19 | 0 |
313738 | 313738 | 2020-07-08 | Redwood | Minnesota | 27127 | 20 | 0 |
316912 | 316912 | 2020-07-09 | Redwood | Minnesota | 27127 | 21 | 0 |
320087 | 320087 | 2020-07-10 | Redwood | Minnesota | 27127 | 21 | 0 |
323266 | 323266 | 2020-07-11 | Redwood | Minnesota | 27127 | 23 | 0 |
326449 | 326449 | 2020-07-12 | Redwood | Minnesota | 27127 | 25 | 0 |
329635 | 329635 | 2020-07-13 | Redwood | Minnesota | 27127 | 25 | 0 |
332822 | 332822 | 2020-07-14 | Redwood | Minnesota | 27127 | 25 | 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);