ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Marshall", fips = 27089 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
310548 | 310548 | 2020-07-07 | Marshall | Minnesota | 27089 | 12 | 0 |
307380 | 307380 | 2020-07-06 | Marshall | Minnesota | 27089 | 12 | 0 |
304213 | 304213 | 2020-07-05 | Marshall | Minnesota | 27089 | 12 | 0 |
301049 | 301049 | 2020-07-04 | Marshall | Minnesota | 27089 | 12 | 0 |
297886 | 297886 | 2020-07-03 | Marshall | Minnesota | 27089 | 12 | 0 |
294728 | 294728 | 2020-07-02 | Marshall | Minnesota | 27089 | 12 | 0 |
291574 | 291574 | 2020-07-01 | Marshall | Minnesota | 27089 | 12 | 0 |
288423 | 288423 | 2020-06-30 | Marshall | Minnesota | 27089 | 12 | 0 |
285273 | 285273 | 2020-06-29 | Marshall | Minnesota | 27089 | 12 | 0 |
282128 | 282128 | 2020-06-28 | Marshall | Minnesota | 27089 | 12 | 0 |
278980 | 278980 | 2020-06-27 | Marshall | Minnesota | 27089 | 12 | 0 |
275832 | 275832 | 2020-06-26 | Marshall | Minnesota | 27089 | 12 | 0 |
272689 | 272689 | 2020-06-25 | Marshall | Minnesota | 27089 | 12 | 0 |
269552 | 269552 | 2020-06-24 | Marshall | Minnesota | 27089 | 12 | 0 |
266419 | 266419 | 2020-06-23 | Marshall | Minnesota | 27089 | 12 | 0 |
263293 | 263293 | 2020-06-22 | Marshall | Minnesota | 27089 | 12 | 0 |
260164 | 260164 | 2020-06-21 | Marshall | Minnesota | 27089 | 12 | 0 |
257038 | 257038 | 2020-06-20 | Marshall | Minnesota | 27089 | 12 | 0 |
253918 | 253918 | 2020-06-19 | Marshall | Minnesota | 27089 | 12 | 0 |
250803 | 250803 | 2020-06-18 | Marshall | Minnesota | 27089 | 12 | 0 |
247691 | 247691 | 2020-06-17 | Marshall | Minnesota | 27089 | 12 | 0 |
244578 | 244578 | 2020-06-16 | Marshall | Minnesota | 27089 | 12 | 0 |
241467 | 241467 | 2020-06-15 | Marshall | Minnesota | 27089 | 12 | 0 |
238358 | 238358 | 2020-06-14 | Marshall | Minnesota | 27089 | 12 | 0 |
235251 | 235251 | 2020-06-13 | Marshall | Minnesota | 27089 | 12 | 0 |
232145 | 232145 | 2020-06-12 | Marshall | Minnesota | 27089 | 12 | 0 |
229041 | 229041 | 2020-06-11 | Marshall | Minnesota | 27089 | 12 | 0 |
225939 | 225939 | 2020-06-10 | Marshall | Minnesota | 27089 | 12 | 0 |
222841 | 222841 | 2020-06-09 | Marshall | Minnesota | 27089 | 12 | 0 |
219746 | 219746 | 2020-06-08 | Marshall | Minnesota | 27089 | 12 | 0 |
216654 | 216654 | 2020-06-07 | Marshall | Minnesota | 27089 | 12 | 0 |
213566 | 213566 | 2020-06-06 | Marshall | Minnesota | 27089 | 12 | 0 |
210482 | 210482 | 2020-06-05 | Marshall | Minnesota | 27089 | 12 | 0 |
207401 | 207401 | 2020-06-04 | Marshall | Minnesota | 27089 | 12 | 0 |
204320 | 204320 | 2020-06-03 | Marshall | Minnesota | 27089 | 12 | 0 |
201243 | 201243 | 2020-06-02 | Marshall | Minnesota | 27089 | 12 | 0 |
198170 | 198170 | 2020-06-01 | Marshall | Minnesota | 27089 | 12 | 0 |
195099 | 195099 | 2020-05-31 | Marshall | Minnesota | 27089 | 12 | 0 |
192031 | 192031 | 2020-05-30 | Marshall | Minnesota | 27089 | 10 | 0 |
188967 | 188967 | 2020-05-29 | Marshall | Minnesota | 27089 | 10 | 0 |
185909 | 185909 | 2020-05-28 | Marshall | Minnesota | 27089 | 9 | 0 |
182854 | 182854 | 2020-05-27 | Marshall | Minnesota | 27089 | 9 | 0 |
179808 | 179808 | 2020-05-26 | Marshall | Minnesota | 27089 | 9 | 0 |
176764 | 176764 | 2020-05-25 | Marshall | Minnesota | 27089 | 9 | 0 |
173721 | 173721 | 2020-05-24 | Marshall | Minnesota | 27089 | 8 | 0 |
170679 | 170679 | 2020-05-23 | Marshall | Minnesota | 27089 | 8 | 0 |
167641 | 167641 | 2020-05-22 | Marshall | Minnesota | 27089 | 8 | 0 |
164605 | 164605 | 2020-05-21 | Marshall | Minnesota | 27089 | 8 | 0 |
161576 | 161576 | 2020-05-20 | Marshall | Minnesota | 27089 | 8 | 0 |
158550 | 158550 | 2020-05-19 | Marshall | Minnesota | 27089 | 8 | 0 |
155532 | 155532 | 2020-05-18 | Marshall | Minnesota | 27089 | 8 | 0 |
152518 | 152518 | 2020-05-17 | Marshall | Minnesota | 27089 | 8 | 0 |
149507 | 149507 | 2020-05-16 | Marshall | Minnesota | 27089 | 8 | 0 |
146502 | 146502 | 2020-05-15 | Marshall | Minnesota | 27089 | 8 | 0 |
143502 | 143502 | 2020-05-14 | Marshall | Minnesota | 27089 | 8 | 0 |
140507 | 140507 | 2020-05-13 | Marshall | Minnesota | 27089 | 8 | 0 |
137513 | 137513 | 2020-05-12 | Marshall | Minnesota | 27089 | 8 | 0 |
134523 | 134523 | 2020-05-11 | Marshall | Minnesota | 27089 | 8 | 0 |
131532 | 131532 | 2020-05-10 | Marshall | Minnesota | 27089 | 8 | 0 |
128542 | 128542 | 2020-05-09 | Marshall | Minnesota | 27089 | 8 | 0 |
125555 | 125555 | 2020-05-08 | Marshall | Minnesota | 27089 | 8 | 0 |
122573 | 122573 | 2020-05-07 | Marshall | Minnesota | 27089 | 8 | 0 |
119599 | 119599 | 2020-05-06 | Marshall | Minnesota | 27089 | 7 | 0 |
116639 | 116639 | 2020-05-05 | Marshall | Minnesota | 27089 | 7 | 0 |
113758 | 113758 | 2020-05-04 | Marshall | Minnesota | 27089 | 7 | 0 |
110879 | 110879 | 2020-05-03 | Marshall | Minnesota | 27089 | 5 | 0 |
108008 | 108008 | 2020-05-02 | Marshall | Minnesota | 27089 | 3 | 0 |
105143 | 105143 | 2020-05-01 | Marshall | Minnesota | 27089 | 2 | 0 |
102282 | 102282 | 2020-04-30 | Marshall | Minnesota | 27089 | 1 | 0 |
99430 | 99430 | 2020-04-29 | Marshall | Minnesota | 27089 | 1 | 0 |
96584 | 96584 | 2020-04-28 | Marshall | Minnesota | 27089 | 1 | 0 |
93749 | 93749 | 2020-04-27 | Marshall | Minnesota | 27089 | 1 | 0 |
90928 | 90928 | 2020-04-26 | Marshall | Minnesota | 27089 | 1 | 0 |
88112 | 88112 | 2020-04-25 | Marshall | Minnesota | 27089 | 1 | 0 |
85302 | 85302 | 2020-04-24 | Marshall | Minnesota | 27089 | 1 | 0 |
82498 | 82498 | 2020-04-23 | Marshall | Minnesota | 27089 | 1 | 0 |
79702 | 79702 | 2020-04-22 | Marshall | Minnesota | 27089 | 1 | 0 |
76917 | 76917 | 2020-04-21 | Marshall | Minnesota | 27089 | 1 | 0 |
74137 | 74137 | 2020-04-20 | Marshall | Minnesota | 27089 | 1 | 0 |
71364 | 71364 | 2020-04-19 | Marshall | Minnesota | 27089 | 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);