ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 27167 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320108 | 320108 | 2020-07-10 | Wilkin | Minnesota | 27167 | 21 | 3 |
316933 | 316933 | 2020-07-09 | Wilkin | Minnesota | 27167 | 21 | 3 |
313759 | 313759 | 2020-07-08 | Wilkin | Minnesota | 27167 | 21 | 3 |
310589 | 310589 | 2020-07-07 | Wilkin | Minnesota | 27167 | 21 | 3 |
307421 | 307421 | 2020-07-06 | Wilkin | Minnesota | 27167 | 21 | 3 |
304254 | 304254 | 2020-07-05 | Wilkin | Minnesota | 27167 | 20 | 3 |
301090 | 301090 | 2020-07-04 | Wilkin | Minnesota | 27167 | 20 | 3 |
297927 | 297927 | 2020-07-03 | Wilkin | Minnesota | 27167 | 20 | 3 |
294769 | 294769 | 2020-07-02 | Wilkin | Minnesota | 27167 | 20 | 3 |
291615 | 291615 | 2020-07-01 | Wilkin | Minnesota | 27167 | 20 | 3 |
288464 | 288464 | 2020-06-30 | Wilkin | Minnesota | 27167 | 20 | 3 |
285314 | 285314 | 2020-06-29 | Wilkin | Minnesota | 27167 | 20 | 3 |
282169 | 282169 | 2020-06-28 | Wilkin | Minnesota | 27167 | 20 | 3 |
279021 | 279021 | 2020-06-27 | Wilkin | Minnesota | 27167 | 20 | 3 |
275873 | 275873 | 2020-06-26 | Wilkin | Minnesota | 27167 | 20 | 3 |
272730 | 272730 | 2020-06-25 | Wilkin | Minnesota | 27167 | 20 | 3 |
269593 | 269593 | 2020-06-24 | Wilkin | Minnesota | 27167 | 20 | 3 |
266460 | 266460 | 2020-06-23 | Wilkin | Minnesota | 27167 | 20 | 3 |
263334 | 263334 | 2020-06-22 | Wilkin | Minnesota | 27167 | 20 | 3 |
260205 | 260205 | 2020-06-21 | Wilkin | Minnesota | 27167 | 20 | 3 |
257079 | 257079 | 2020-06-20 | Wilkin | Minnesota | 27167 | 20 | 3 |
253959 | 253959 | 2020-06-19 | Wilkin | Minnesota | 27167 | 20 | 3 |
250844 | 250844 | 2020-06-18 | Wilkin | Minnesota | 27167 | 18 | 3 |
247732 | 247732 | 2020-06-17 | Wilkin | Minnesota | 27167 | 15 | 3 |
244619 | 244619 | 2020-06-16 | Wilkin | Minnesota | 27167 | 15 | 3 |
241508 | 241508 | 2020-06-15 | Wilkin | Minnesota | 27167 | 15 | 3 |
238399 | 238399 | 2020-06-14 | Wilkin | Minnesota | 27167 | 15 | 3 |
235292 | 235292 | 2020-06-13 | Wilkin | Minnesota | 27167 | 14 | 3 |
232186 | 232186 | 2020-06-12 | Wilkin | Minnesota | 27167 | 12 | 3 |
229082 | 229082 | 2020-06-11 | Wilkin | Minnesota | 27167 | 12 | 3 |
225980 | 225980 | 2020-06-10 | Wilkin | Minnesota | 27167 | 12 | 3 |
222882 | 222882 | 2020-06-09 | Wilkin | Minnesota | 27167 | 11 | 3 |
219787 | 219787 | 2020-06-08 | Wilkin | Minnesota | 27167 | 11 | 3 |
216695 | 216695 | 2020-06-07 | Wilkin | Minnesota | 27167 | 11 | 3 |
213607 | 213607 | 2020-06-06 | Wilkin | Minnesota | 27167 | 11 | 3 |
210523 | 210523 | 2020-06-05 | Wilkin | Minnesota | 27167 | 11 | 3 |
207442 | 207442 | 2020-06-04 | Wilkin | Minnesota | 27167 | 11 | 3 |
204361 | 204361 | 2020-06-03 | Wilkin | Minnesota | 27167 | 11 | 3 |
201284 | 201284 | 2020-06-02 | Wilkin | Minnesota | 27167 | 11 | 3 |
198211 | 198211 | 2020-06-01 | Wilkin | Minnesota | 27167 | 11 | 3 |
195140 | 195140 | 2020-05-31 | Wilkin | Minnesota | 27167 | 11 | 3 |
192072 | 192072 | 2020-05-30 | Wilkin | Minnesota | 27167 | 11 | 3 |
189008 | 189008 | 2020-05-29 | Wilkin | Minnesota | 27167 | 11 | 3 |
185950 | 185950 | 2020-05-28 | Wilkin | Minnesota | 27167 | 11 | 3 |
182894 | 182894 | 2020-05-27 | Wilkin | Minnesota | 27167 | 11 | 3 |
179848 | 179848 | 2020-05-26 | Wilkin | Minnesota | 27167 | 11 | 3 |
176804 | 176804 | 2020-05-25 | Wilkin | Minnesota | 27167 | 11 | 3 |
173761 | 173761 | 2020-05-24 | Wilkin | Minnesota | 27167 | 11 | 3 |
170719 | 170719 | 2020-05-23 | Wilkin | Minnesota | 27167 | 11 | 3 |
167681 | 167681 | 2020-05-22 | Wilkin | Minnesota | 27167 | 11 | 3 |
164645 | 164645 | 2020-05-21 | Wilkin | Minnesota | 27167 | 11 | 3 |
161616 | 161616 | 2020-05-20 | Wilkin | Minnesota | 27167 | 11 | 3 |
158590 | 158590 | 2020-05-19 | Wilkin | Minnesota | 27167 | 11 | 3 |
155572 | 155572 | 2020-05-18 | Wilkin | Minnesota | 27167 | 11 | 3 |
152558 | 152558 | 2020-05-17 | Wilkin | Minnesota | 27167 | 11 | 3 |
149547 | 149547 | 2020-05-16 | Wilkin | Minnesota | 27167 | 11 | 3 |
146542 | 146542 | 2020-05-15 | Wilkin | Minnesota | 27167 | 11 | 3 |
143542 | 143542 | 2020-05-14 | Wilkin | Minnesota | 27167 | 11 | 3 |
140547 | 140547 | 2020-05-13 | Wilkin | Minnesota | 27167 | 11 | 3 |
137553 | 137553 | 2020-05-12 | Wilkin | Minnesota | 27167 | 11 | 3 |
134563 | 134563 | 2020-05-11 | Wilkin | Minnesota | 27167 | 11 | 3 |
131572 | 131572 | 2020-05-10 | Wilkin | Minnesota | 27167 | 12 | 3 |
128582 | 128582 | 2020-05-09 | Wilkin | Minnesota | 27167 | 12 | 3 |
125595 | 125595 | 2020-05-08 | Wilkin | Minnesota | 27167 | 12 | 3 |
122613 | 122613 | 2020-05-07 | Wilkin | Minnesota | 27167 | 12 | 3 |
119639 | 119639 | 2020-05-06 | Wilkin | Minnesota | 27167 | 12 | 3 |
116679 | 116679 | 2020-05-05 | Wilkin | Minnesota | 27167 | 12 | 3 |
113797 | 113797 | 2020-05-04 | Wilkin | Minnesota | 27167 | 12 | 3 |
110918 | 110918 | 2020-05-03 | Wilkin | Minnesota | 27167 | 12 | 3 |
108047 | 108047 | 2020-05-02 | Wilkin | Minnesota | 27167 | 12 | 3 |
105182 | 105182 | 2020-05-01 | Wilkin | Minnesota | 27167 | 12 | 3 |
102321 | 102321 | 2020-04-30 | Wilkin | Minnesota | 27167 | 12 | 3 |
99469 | 99469 | 2020-04-29 | Wilkin | Minnesota | 27167 | 12 | 3 |
96623 | 96623 | 2020-04-28 | Wilkin | Minnesota | 27167 | 12 | 3 |
93787 | 93787 | 2020-04-27 | Wilkin | Minnesota | 27167 | 11 | 3 |
90966 | 90966 | 2020-04-26 | Wilkin | Minnesota | 27167 | 11 | 3 |
88150 | 88150 | 2020-04-25 | Wilkin | Minnesota | 27167 | 11 | 3 |
85340 | 85340 | 2020-04-24 | Wilkin | Minnesota | 27167 | 11 | 2 |
82536 | 82536 | 2020-04-23 | Wilkin | Minnesota | 27167 | 11 | 2 |
79740 | 79740 | 2020-04-22 | Wilkin | Minnesota | 27167 | 10 | 2 |
76955 | 76955 | 2020-04-21 | Wilkin | Minnesota | 27167 | 9 | 2 |
74174 | 74174 | 2020-04-20 | Wilkin | Minnesota | 27167 | 9 | 2 |
71401 | 71401 | 2020-04-19 | Wilkin | Minnesota | 27167 | 9 | 2 |
68635 | 68635 | 2020-04-18 | Wilkin | Minnesota | 27167 | 8 | 2 |
65883 | 65883 | 2020-04-17 | Wilkin | Minnesota | 27167 | 7 | 2 |
63143 | 63143 | 2020-04-16 | Wilkin | Minnesota | 27167 | 7 | 2 |
60421 | 60421 | 2020-04-15 | Wilkin | Minnesota | 27167 | 7 | 2 |
57710 | 57710 | 2020-04-14 | Wilkin | Minnesota | 27167 | 7 | 2 |
55012 | 55012 | 2020-04-13 | Wilkin | Minnesota | 27167 | 7 | 1 |
52330 | 52330 | 2020-04-12 | Wilkin | Minnesota | 27167 | 7 | 1 |
49657 | 49657 | 2020-04-11 | Wilkin | Minnesota | 27167 | 7 | 1 |
47011 | 47011 | 2020-04-10 | Wilkin | Minnesota | 27167 | 6 | 1 |
44402 | 44402 | 2020-04-09 | Wilkin | Minnesota | 27167 | 5 | 1 |
41826 | 41826 | 2020-04-08 | Wilkin | Minnesota | 27167 | 2 | 1 |
39272 | 39272 | 2020-04-07 | Wilkin | Minnesota | 27167 | 2 | 0 |
36761 | 36761 | 2020-04-06 | Wilkin | Minnesota | 27167 | 2 | 0 |
34299 | 34299 | 2020-04-05 | Wilkin | Minnesota | 27167 | 2 | 0 |
31872 | 31872 | 2020-04-04 | Wilkin | Minnesota | 27167 | 2 | 0 |
29492 | 29492 | 2020-04-03 | Wilkin | Minnesota | 27167 | 2 | 0 |
27173 | 27173 | 2020-04-02 | Wilkin | Minnesota | 27167 | 1 | 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);