ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 27019 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387268 | 387268 | 2020-07-31 | Carver | Minnesota | 27019 | 744 | 2 |
384050 | 384050 | 2020-07-30 | Carver | Minnesota | 27019 | 723 | 2 |
380833 | 380833 | 2020-07-29 | Carver | Minnesota | 27019 | 710 | 2 |
377616 | 377616 | 2020-07-28 | Carver | Minnesota | 27019 | 693 | 2 |
374401 | 374401 | 2020-07-27 | Carver | Minnesota | 27019 | 684 | 2 |
371189 | 371189 | 2020-07-26 | Carver | Minnesota | 27019 | 663 | 2 |
367979 | 367979 | 2020-07-25 | Carver | Minnesota | 27019 | 643 | 2 |
364772 | 364772 | 2020-07-24 | Carver | Minnesota | 27019 | 639 | 2 |
361565 | 361565 | 2020-07-23 | Carver | Minnesota | 27019 | 618 | 2 |
358360 | 358360 | 2020-07-22 | Carver | Minnesota | 27019 | 602 | 2 |
355157 | 355157 | 2020-07-21 | Carver | Minnesota | 27019 | 596 | 2 |
351955 | 351955 | 2020-07-20 | Carver | Minnesota | 27019 | 568 | 2 |
348755 | 348755 | 2020-07-19 | Carver | Minnesota | 27019 | 559 | 2 |
345554 | 345554 | 2020-07-18 | Carver | Minnesota | 27019 | 549 | 2 |
342354 | 342354 | 2020-07-17 | Carver | Minnesota | 27019 | 545 | 2 |
339158 | 339158 | 2020-07-16 | Carver | Minnesota | 27019 | 533 | 2 |
335962 | 335962 | 2020-07-15 | Carver | Minnesota | 27019 | 518 | 2 |
332769 | 332769 | 2020-07-14 | Carver | Minnesota | 27019 | 509 | 2 |
329582 | 329582 | 2020-07-13 | Carver | Minnesota | 27019 | 500 | 2 |
326396 | 326396 | 2020-07-12 | Carver | Minnesota | 27019 | 494 | 2 |
323213 | 323213 | 2020-07-11 | Carver | Minnesota | 27019 | 469 | 1 |
320034 | 320034 | 2020-07-10 | Carver | Minnesota | 27019 | 442 | 1 |
316859 | 316859 | 2020-07-09 | Carver | Minnesota | 27019 | 433 | 1 |
313685 | 313685 | 2020-07-08 | Carver | Minnesota | 27019 | 417 | 1 |
310515 | 310515 | 2020-07-07 | Carver | Minnesota | 27019 | 395 | 1 |
307347 | 307347 | 2020-07-06 | Carver | Minnesota | 27019 | 381 | 1 |
304180 | 304180 | 2020-07-05 | Carver | Minnesota | 27019 | 376 | 1 |
301016 | 301016 | 2020-07-04 | Carver | Minnesota | 27019 | 364 | 1 |
297853 | 297853 | 2020-07-03 | Carver | Minnesota | 27019 | 364 | 1 |
294695 | 294695 | 2020-07-02 | Carver | Minnesota | 27019 | 361 | 1 |
291541 | 291541 | 2020-07-01 | Carver | Minnesota | 27019 | 348 | 1 |
288390 | 288390 | 2020-06-30 | Carver | Minnesota | 27019 | 340 | 1 |
285240 | 285240 | 2020-06-29 | Carver | Minnesota | 27019 | 338 | 1 |
282095 | 282095 | 2020-06-28 | Carver | Minnesota | 27019 | 333 | 1 |
278947 | 278947 | 2020-06-27 | Carver | Minnesota | 27019 | 323 | 1 |
275799 | 275799 | 2020-06-26 | Carver | Minnesota | 27019 | 316 | 1 |
272656 | 272656 | 2020-06-25 | Carver | Minnesota | 27019 | 308 | 1 |
269519 | 269519 | 2020-06-24 | Carver | Minnesota | 27019 | 305 | 1 |
266386 | 266386 | 2020-06-23 | Carver | Minnesota | 27019 | 299 | 1 |
263260 | 263260 | 2020-06-22 | Carver | Minnesota | 27019 | 297 | 1 |
260131 | 260131 | 2020-06-21 | Carver | Minnesota | 27019 | 294 | 1 |
257005 | 257005 | 2020-06-20 | Carver | Minnesota | 27019 | 293 | 1 |
253885 | 253885 | 2020-06-19 | Carver | Minnesota | 27019 | 287 | 1 |
250770 | 250770 | 2020-06-18 | Carver | Minnesota | 27019 | 285 | 2 |
247658 | 247658 | 2020-06-17 | Carver | Minnesota | 27019 | 278 | 2 |
244545 | 244545 | 2020-06-16 | Carver | Minnesota | 27019 | 276 | 2 |
241434 | 241434 | 2020-06-15 | Carver | Minnesota | 27019 | 271 | 2 |
238325 | 238325 | 2020-06-14 | Carver | Minnesota | 27019 | 270 | 2 |
235218 | 235218 | 2020-06-13 | Carver | Minnesota | 27019 | 269 | 2 |
232113 | 232113 | 2020-06-12 | Carver | Minnesota | 27019 | 268 | 2 |
229009 | 229009 | 2020-06-11 | Carver | Minnesota | 27019 | 266 | 2 |
225907 | 225907 | 2020-06-10 | Carver | Minnesota | 27019 | 261 | 2 |
222809 | 222809 | 2020-06-09 | Carver | Minnesota | 27019 | 257 | 2 |
219714 | 219714 | 2020-06-08 | Carver | Minnesota | 27019 | 254 | 2 |
216622 | 216622 | 2020-06-07 | Carver | Minnesota | 27019 | 250 | 2 |
213534 | 213534 | 2020-06-06 | Carver | Minnesota | 27019 | 247 | 2 |
210450 | 210450 | 2020-06-05 | Carver | Minnesota | 27019 | 240 | 2 |
207369 | 207369 | 2020-06-04 | Carver | Minnesota | 27019 | 232 | 2 |
204288 | 204288 | 2020-06-03 | Carver | Minnesota | 27019 | 224 | 2 |
201211 | 201211 | 2020-06-02 | Carver | Minnesota | 27019 | 222 | 2 |
198138 | 198138 | 2020-06-01 | Carver | Minnesota | 27019 | 218 | 2 |
195067 | 195067 | 2020-05-31 | Carver | Minnesota | 27019 | 210 | 2 |
191999 | 191999 | 2020-05-30 | Carver | Minnesota | 27019 | 206 | 2 |
188935 | 188935 | 2020-05-29 | Carver | Minnesota | 27019 | 201 | 2 |
185877 | 185877 | 2020-05-28 | Carver | Minnesota | 27019 | 189 | 2 |
182822 | 182822 | 2020-05-27 | Carver | Minnesota | 27019 | 185 | 2 |
179776 | 179776 | 2020-05-26 | Carver | Minnesota | 27019 | 182 | 2 |
176732 | 176732 | 2020-05-25 | Carver | Minnesota | 27019 | 174 | 2 |
173689 | 173689 | 2020-05-24 | Carver | Minnesota | 27019 | 161 | 2 |
170647 | 170647 | 2020-05-23 | Carver | Minnesota | 27019 | 154 | 2 |
167610 | 167610 | 2020-05-22 | Carver | Minnesota | 27019 | 146 | 2 |
164574 | 164574 | 2020-05-21 | Carver | Minnesota | 27019 | 138 | 2 |
161545 | 161545 | 2020-05-20 | Carver | Minnesota | 27019 | 131 | 2 |
158519 | 158519 | 2020-05-19 | Carver | Minnesota | 27019 | 128 | 2 |
155501 | 155501 | 2020-05-18 | Carver | Minnesota | 27019 | 117 | 2 |
152487 | 152487 | 2020-05-17 | Carver | Minnesota | 27019 | 113 | 2 |
149476 | 149476 | 2020-05-16 | Carver | Minnesota | 27019 | 111 | 2 |
146471 | 146471 | 2020-05-15 | Carver | Minnesota | 27019 | 105 | 2 |
143471 | 143471 | 2020-05-14 | Carver | Minnesota | 27019 | 103 | 1 |
140476 | 140476 | 2020-05-13 | Carver | Minnesota | 27019 | 95 | 1 |
137482 | 137482 | 2020-05-12 | Carver | Minnesota | 27019 | 95 | 1 |
134492 | 134492 | 2020-05-11 | Carver | Minnesota | 27019 | 92 | 1 |
131501 | 131501 | 2020-05-10 | Carver | Minnesota | 27019 | 82 | 1 |
128511 | 128511 | 2020-05-09 | Carver | Minnesota | 27019 | 78 | 1 |
125524 | 125524 | 2020-05-08 | Carver | Minnesota | 27019 | 69 | 0 |
122542 | 122542 | 2020-05-07 | Carver | Minnesota | 27019 | 58 | 0 |
119569 | 119569 | 2020-05-06 | Carver | Minnesota | 27019 | 51 | 0 |
116609 | 116609 | 2020-05-05 | Carver | Minnesota | 27019 | 39 | 0 |
113728 | 113728 | 2020-05-04 | Carver | Minnesota | 27019 | 27 | 0 |
110849 | 110849 | 2020-05-03 | Carver | Minnesota | 27019 | 26 | 0 |
107978 | 107978 | 2020-05-02 | Carver | Minnesota | 27019 | 25 | 0 |
105114 | 105114 | 2020-05-01 | Carver | Minnesota | 27019 | 21 | 0 |
102254 | 102254 | 2020-04-30 | Carver | Minnesota | 27019 | 21 | 0 |
99402 | 99402 | 2020-04-29 | Carver | Minnesota | 27019 | 20 | 0 |
96556 | 96556 | 2020-04-28 | Carver | Minnesota | 27019 | 19 | 0 |
93721 | 93721 | 2020-04-27 | Carver | Minnesota | 27019 | 17 | 0 |
90900 | 90900 | 2020-04-26 | Carver | Minnesota | 27019 | 17 | 0 |
88084 | 88084 | 2020-04-25 | Carver | Minnesota | 27019 | 16 | 0 |
85274 | 85274 | 2020-04-24 | Carver | Minnesota | 27019 | 15 | 0 |
82470 | 82470 | 2020-04-23 | Carver | Minnesota | 27019 | 15 | 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);