ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 27111 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 |
---|---|---|---|---|---|---|---|
18584 | 18584 | 2020-03-29 | Otter Tail | Minnesota | 27111 | 1 | 0 |
20606 | 20606 | 2020-03-30 | Otter Tail | Minnesota | 27111 | 1 | 0 |
22721 | 22721 | 2020-03-31 | Otter Tail | Minnesota | 27111 | 1 | 0 |
24903 | 24903 | 2020-04-01 | Otter Tail | Minnesota | 27111 | 1 | 0 |
27157 | 27157 | 2020-04-02 | Otter Tail | Minnesota | 27111 | 1 | 0 |
29476 | 29476 | 2020-04-03 | Otter Tail | Minnesota | 27111 | 1 | 0 |
31855 | 31855 | 2020-04-04 | Otter Tail | Minnesota | 27111 | 1 | 0 |
34281 | 34281 | 2020-04-05 | Otter Tail | Minnesota | 27111 | 1 | 0 |
36742 | 36742 | 2020-04-06 | Otter Tail | Minnesota | 27111 | 2 | 0 |
39251 | 39251 | 2020-04-07 | Otter Tail | Minnesota | 27111 | 2 | 0 |
41804 | 41804 | 2020-04-08 | Otter Tail | Minnesota | 27111 | 2 | 0 |
44380 | 44380 | 2020-04-09 | Otter Tail | Minnesota | 27111 | 3 | 0 |
46990 | 46990 | 2020-04-10 | Otter Tail | Minnesota | 27111 | 3 | 0 |
49635 | 49635 | 2020-04-11 | Otter Tail | Minnesota | 27111 | 4 | 0 |
52305 | 52305 | 2020-04-12 | Otter Tail | Minnesota | 27111 | 4 | 0 |
54987 | 54987 | 2020-04-13 | Otter Tail | Minnesota | 27111 | 4 | 0 |
57685 | 57685 | 2020-04-14 | Otter Tail | Minnesota | 27111 | 4 | 0 |
60396 | 60396 | 2020-04-15 | Otter Tail | Minnesota | 27111 | 4 | 0 |
63119 | 63119 | 2020-04-16 | Otter Tail | Minnesota | 27111 | 4 | 0 |
65858 | 65858 | 2020-04-17 | Otter Tail | Minnesota | 27111 | 4 | 0 |
68610 | 68610 | 2020-04-18 | Otter Tail | Minnesota | 27111 | 5 | 0 |
71376 | 71376 | 2020-04-19 | Otter Tail | Minnesota | 27111 | 6 | 0 |
74149 | 74149 | 2020-04-20 | Otter Tail | Minnesota | 27111 | 6 | 0 |
76929 | 76929 | 2020-04-21 | Otter Tail | Minnesota | 27111 | 6 | 0 |
79714 | 79714 | 2020-04-22 | Otter Tail | Minnesota | 27111 | 6 | 0 |
82510 | 82510 | 2020-04-23 | Otter Tail | Minnesota | 27111 | 6 | 0 |
85314 | 85314 | 2020-04-24 | Otter Tail | Minnesota | 27111 | 6 | 0 |
88124 | 88124 | 2020-04-25 | Otter Tail | Minnesota | 27111 | 8 | 0 |
90940 | 90940 | 2020-04-26 | Otter Tail | Minnesota | 27111 | 8 | 0 |
93761 | 93761 | 2020-04-27 | Otter Tail | Minnesota | 27111 | 8 | 0 |
96596 | 96596 | 2020-04-28 | Otter Tail | Minnesota | 27111 | 8 | 0 |
99442 | 99442 | 2020-04-29 | Otter Tail | Minnesota | 27111 | 8 | 0 |
102294 | 102294 | 2020-04-30 | Otter Tail | Minnesota | 27111 | 9 | 0 |
105155 | 105155 | 2020-05-01 | Otter Tail | Minnesota | 27111 | 14 | 0 |
108020 | 108020 | 2020-05-02 | Otter Tail | Minnesota | 27111 | 17 | 0 |
110891 | 110891 | 2020-05-03 | Otter Tail | Minnesota | 27111 | 17 | 0 |
113770 | 113770 | 2020-05-04 | Otter Tail | Minnesota | 27111 | 18 | 0 |
116651 | 116651 | 2020-05-05 | Otter Tail | Minnesota | 27111 | 19 | 0 |
119611 | 119611 | 2020-05-06 | Otter Tail | Minnesota | 27111 | 19 | 0 |
122585 | 122585 | 2020-05-07 | Otter Tail | Minnesota | 27111 | 21 | 0 |
125567 | 125567 | 2020-05-08 | Otter Tail | Minnesota | 27111 | 21 | 0 |
128554 | 128554 | 2020-05-09 | Otter Tail | Minnesota | 27111 | 23 | 0 |
131544 | 131544 | 2020-05-10 | Otter Tail | Minnesota | 27111 | 23 | 0 |
134535 | 134535 | 2020-05-11 | Otter Tail | Minnesota | 27111 | 25 | 0 |
137525 | 137525 | 2020-05-12 | Otter Tail | Minnesota | 27111 | 25 | 0 |
140519 | 140519 | 2020-05-13 | Otter Tail | Minnesota | 27111 | 25 | 0 |
143514 | 143514 | 2020-05-14 | Otter Tail | Minnesota | 27111 | 33 | 0 |
146514 | 146514 | 2020-05-15 | Otter Tail | Minnesota | 27111 | 35 | 0 |
149519 | 149519 | 2020-05-16 | Otter Tail | Minnesota | 27111 | 36 | 0 |
152530 | 152530 | 2020-05-17 | Otter Tail | Minnesota | 27111 | 38 | 0 |
155544 | 155544 | 2020-05-18 | Otter Tail | Minnesota | 27111 | 47 | 0 |
158562 | 158562 | 2020-05-19 | Otter Tail | Minnesota | 27111 | 51 | 0 |
161588 | 161588 | 2020-05-20 | Otter Tail | Minnesota | 27111 | 51 | 0 |
164617 | 164617 | 2020-05-21 | Otter Tail | Minnesota | 27111 | 52 | 0 |
167653 | 167653 | 2020-05-22 | Otter Tail | Minnesota | 27111 | 52 | 0 |
170691 | 170691 | 2020-05-23 | Otter Tail | Minnesota | 27111 | 53 | 0 |
173733 | 173733 | 2020-05-24 | Otter Tail | Minnesota | 27111 | 55 | 0 |
176776 | 176776 | 2020-05-25 | Otter Tail | Minnesota | 27111 | 60 | 0 |
179820 | 179820 | 2020-05-26 | Otter Tail | Minnesota | 27111 | 59 | 0 |
182866 | 182866 | 2020-05-27 | Otter Tail | Minnesota | 27111 | 62 | 0 |
185921 | 185921 | 2020-05-28 | Otter Tail | Minnesota | 27111 | 63 | 0 |
188979 | 188979 | 2020-05-29 | Otter Tail | Minnesota | 27111 | 63 | 0 |
192043 | 192043 | 2020-05-30 | Otter Tail | Minnesota | 27111 | 64 | 0 |
195111 | 195111 | 2020-05-31 | Otter Tail | Minnesota | 27111 | 68 | 0 |
198182 | 198182 | 2020-06-01 | Otter Tail | Minnesota | 27111 | 70 | 0 |
201255 | 201255 | 2020-06-02 | Otter Tail | Minnesota | 27111 | 70 | 0 |
204332 | 204332 | 2020-06-03 | Otter Tail | Minnesota | 27111 | 71 | 0 |
207413 | 207413 | 2020-06-04 | Otter Tail | Minnesota | 27111 | 73 | 0 |
210494 | 210494 | 2020-06-05 | Otter Tail | Minnesota | 27111 | 73 | 1 |
213578 | 213578 | 2020-06-06 | Otter Tail | Minnesota | 27111 | 75 | 1 |
216666 | 216666 | 2020-06-07 | Otter Tail | Minnesota | 27111 | 76 | 1 |
219758 | 219758 | 2020-06-08 | Otter Tail | Minnesota | 27111 | 77 | 1 |
222853 | 222853 | 2020-06-09 | Otter Tail | Minnesota | 27111 | 78 | 1 |
225951 | 225951 | 2020-06-10 | Otter Tail | Minnesota | 27111 | 78 | 1 |
229053 | 229053 | 2020-06-11 | Otter Tail | Minnesota | 27111 | 80 | 1 |
232157 | 232157 | 2020-06-12 | Otter Tail | Minnesota | 27111 | 80 | 1 |
235263 | 235263 | 2020-06-13 | Otter Tail | Minnesota | 27111 | 83 | 1 |
238370 | 238370 | 2020-06-14 | Otter Tail | Minnesota | 27111 | 83 | 1 |
241479 | 241479 | 2020-06-15 | Otter Tail | Minnesota | 27111 | 83 | 1 |
244590 | 244590 | 2020-06-16 | Otter Tail | Minnesota | 27111 | 83 | 1 |
247703 | 247703 | 2020-06-17 | Otter Tail | Minnesota | 27111 | 83 | 1 |
250815 | 250815 | 2020-06-18 | Otter Tail | Minnesota | 27111 | 83 | 1 |
253930 | 253930 | 2020-06-19 | Otter Tail | Minnesota | 27111 | 83 | 1 |
257050 | 257050 | 2020-06-20 | Otter Tail | Minnesota | 27111 | 85 | 1 |
260176 | 260176 | 2020-06-21 | Otter Tail | Minnesota | 27111 | 85 | 1 |
263305 | 263305 | 2020-06-22 | Otter Tail | Minnesota | 27111 | 85 | 1 |
266431 | 266431 | 2020-06-23 | Otter Tail | Minnesota | 27111 | 85 | 1 |
269564 | 269564 | 2020-06-24 | Otter Tail | Minnesota | 27111 | 85 | 1 |
272701 | 272701 | 2020-06-25 | Otter Tail | Minnesota | 27111 | 85 | 1 |
275844 | 275844 | 2020-06-26 | Otter Tail | Minnesota | 27111 | 86 | 1 |
278992 | 278992 | 2020-06-27 | Otter Tail | Minnesota | 27111 | 87 | 1 |
282140 | 282140 | 2020-06-28 | Otter Tail | Minnesota | 27111 | 88 | 1 |
285285 | 285285 | 2020-06-29 | Otter Tail | Minnesota | 27111 | 91 | 1 |
288435 | 288435 | 2020-06-30 | Otter Tail | Minnesota | 27111 | 92 | 1 |
291586 | 291586 | 2020-07-01 | Otter Tail | Minnesota | 27111 | 92 | 1 |
294740 | 294740 | 2020-07-02 | Otter Tail | Minnesota | 27111 | 92 | 1 |
297898 | 297898 | 2020-07-03 | Otter Tail | Minnesota | 27111 | 93 | 1 |
301061 | 301061 | 2020-07-04 | Otter Tail | Minnesota | 27111 | 93 | 1 |
304225 | 304225 | 2020-07-05 | Otter Tail | Minnesota | 27111 | 93 | 1 |
307392 | 307392 | 2020-07-06 | Otter Tail | Minnesota | 27111 | 95 | 1 |
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);