ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where county = "Morrison", deaths = 1 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
568173 | 568173 | 2020-09-25 | Morrison | Minnesota | 27097 | 233 | 1 |
564933 | 564933 | 2020-09-24 | Morrison | Minnesota | 27097 | 222 | 1 |
561693 | 561693 | 2020-09-23 | Morrison | Minnesota | 27097 | 216 | 1 |
558456 | 558456 | 2020-09-22 | Morrison | Minnesota | 27097 | 213 | 1 |
555219 | 555219 | 2020-09-21 | Morrison | Minnesota | 27097 | 208 | 1 |
551981 | 551981 | 2020-09-20 | Morrison | Minnesota | 27097 | 203 | 1 |
548742 | 548742 | 2020-09-19 | Morrison | Minnesota | 27097 | 195 | 1 |
545504 | 545504 | 2020-09-18 | Morrison | Minnesota | 27097 | 190 | 1 |
542267 | 542267 | 2020-09-17 | Morrison | Minnesota | 27097 | 184 | 1 |
539031 | 539031 | 2020-09-16 | Morrison | Minnesota | 27097 | 181 | 1 |
535794 | 535794 | 2020-09-15 | Morrison | Minnesota | 27097 | 177 | 1 |
532559 | 532559 | 2020-09-14 | Morrison | Minnesota | 27097 | 174 | 1 |
529323 | 529323 | 2020-09-13 | Morrison | Minnesota | 27097 | 170 | 1 |
526087 | 526087 | 2020-09-12 | Morrison | Minnesota | 27097 | 166 | 1 |
522851 | 522851 | 2020-09-11 | Morrison | Minnesota | 27097 | 160 | 1 |
519614 | 519614 | 2020-09-10 | Morrison | Minnesota | 27097 | 152 | 1 |
516379 | 516379 | 2020-09-09 | Morrison | Minnesota | 27097 | 151 | 1 |
513145 | 513145 | 2020-09-08 | Morrison | Minnesota | 27097 | 149 | 1 |
509913 | 509913 | 2020-09-07 | Morrison | Minnesota | 27097 | 149 | 1 |
506680 | 506680 | 2020-09-06 | Morrison | Minnesota | 27097 | 142 | 1 |
503447 | 503447 | 2020-09-05 | Morrison | Minnesota | 27097 | 131 | 1 |
500213 | 500213 | 2020-09-04 | Morrison | Minnesota | 27097 | 125 | 1 |
496979 | 496979 | 2020-09-03 | Morrison | Minnesota | 27097 | 124 | 1 |
493746 | 493746 | 2020-09-02 | Morrison | Minnesota | 27097 | 121 | 1 |
490512 | 490512 | 2020-09-01 | Morrison | Minnesota | 27097 | 119 | 1 |
487279 | 487279 | 2020-08-31 | Morrison | Minnesota | 27097 | 117 | 1 |
484045 | 484045 | 2020-08-30 | Morrison | Minnesota | 27097 | 114 | 1 |
480810 | 480810 | 2020-08-29 | Morrison | Minnesota | 27097 | 113 | 1 |
477578 | 477578 | 2020-08-28 | Morrison | Minnesota | 27097 | 112 | 1 |
474345 | 474345 | 2020-08-27 | Morrison | Minnesota | 27097 | 112 | 1 |
471113 | 471113 | 2020-08-26 | Morrison | Minnesota | 27097 | 110 | 1 |
467883 | 467883 | 2020-08-25 | Morrison | Minnesota | 27097 | 108 | 1 |
464654 | 464654 | 2020-08-24 | Morrison | Minnesota | 27097 | 108 | 1 |
461423 | 461423 | 2020-08-23 | Morrison | Minnesota | 27097 | 108 | 1 |
458196 | 458196 | 2020-08-22 | Morrison | Minnesota | 27097 | 107 | 1 |
454968 | 454968 | 2020-08-21 | Morrison | Minnesota | 27097 | 104 | 1 |
451740 | 451740 | 2020-08-20 | Morrison | Minnesota | 27097 | 104 | 1 |
448512 | 448512 | 2020-08-19 | Morrison | Minnesota | 27097 | 103 | 1 |
445286 | 445286 | 2020-08-18 | Morrison | Minnesota | 27097 | 102 | 1 |
442060 | 442060 | 2020-08-17 | Morrison | Minnesota | 27097 | 104 | 1 |
438833 | 438833 | 2020-08-16 | Morrison | Minnesota | 27097 | 103 | 1 |
435608 | 435608 | 2020-08-15 | Morrison | Minnesota | 27097 | 97 | 1 |
432382 | 432382 | 2020-08-14 | Morrison | Minnesota | 27097 | 97 | 1 |
429155 | 429155 | 2020-08-13 | Morrison | Minnesota | 27097 | 94 | 1 |
425931 | 425931 | 2020-08-12 | Morrison | Minnesota | 27097 | 93 | 1 |
422709 | 422709 | 2020-08-11 | Morrison | Minnesota | 27097 | 93 | 1 |
419487 | 419487 | 2020-08-10 | Morrison | Minnesota | 27097 | 93 | 1 |
416266 | 416266 | 2020-08-09 | Morrison | Minnesota | 27097 | 92 | 1 |
413046 | 413046 | 2020-08-08 | Morrison | Minnesota | 27097 | 89 | 1 |
409826 | 409826 | 2020-08-07 | Morrison | Minnesota | 27097 | 85 | 1 |
406606 | 406606 | 2020-08-06 | Morrison | Minnesota | 27097 | 85 | 1 |
403388 | 403388 | 2020-08-05 | Morrison | Minnesota | 27097 | 82 | 1 |
400171 | 400171 | 2020-08-04 | Morrison | Minnesota | 27097 | 82 | 1 |
396957 | 396957 | 2020-08-03 | Morrison | Minnesota | 27097 | 83 | 1 |
393741 | 393741 | 2020-08-02 | Morrison | Minnesota | 27097 | 83 | 1 |
390524 | 390524 | 2020-08-01 | Morrison | Minnesota | 27097 | 81 | 1 |
387307 | 387307 | 2020-07-31 | Morrison | Minnesota | 27097 | 81 | 1 |
384089 | 384089 | 2020-07-30 | Morrison | Minnesota | 27097 | 80 | 1 |
380872 | 380872 | 2020-07-29 | Morrison | Minnesota | 27097 | 80 | 1 |
377655 | 377655 | 2020-07-28 | Morrison | Minnesota | 27097 | 79 | 1 |
374440 | 374440 | 2020-07-27 | Morrison | Minnesota | 27097 | 79 | 1 |
371228 | 371228 | 2020-07-26 | Morrison | Minnesota | 27097 | 75 | 1 |
368018 | 368018 | 2020-07-25 | Morrison | Minnesota | 27097 | 74 | 1 |
364810 | 364810 | 2020-07-24 | Morrison | Minnesota | 27097 | 74 | 1 |
361603 | 361603 | 2020-07-23 | Morrison | Minnesota | 27097 | 74 | 1 |
358398 | 358398 | 2020-07-22 | Morrison | Minnesota | 27097 | 74 | 1 |
355195 | 355195 | 2020-07-21 | Morrison | Minnesota | 27097 | 74 | 1 |
351993 | 351993 | 2020-07-20 | Morrison | Minnesota | 27097 | 73 | 1 |
348793 | 348793 | 2020-07-19 | Morrison | Minnesota | 27097 | 73 | 1 |
345592 | 345592 | 2020-07-18 | Morrison | Minnesota | 27097 | 72 | 1 |
342392 | 342392 | 2020-07-17 | Morrison | Minnesota | 27097 | 70 | 1 |
339196 | 339196 | 2020-07-16 | Morrison | Minnesota | 27097 | 70 | 1 |
336000 | 336000 | 2020-07-15 | Morrison | Minnesota | 27097 | 70 | 1 |
332807 | 332807 | 2020-07-14 | Morrison | Minnesota | 27097 | 70 | 1 |
329620 | 329620 | 2020-07-13 | Morrison | Minnesota | 27097 | 69 | 1 |
326434 | 326434 | 2020-07-12 | Morrison | Minnesota | 27097 | 66 | 1 |
323251 | 323251 | 2020-07-11 | Morrison | Minnesota | 27097 | 64 | 1 |
320072 | 320072 | 2020-07-10 | Morrison | Minnesota | 27097 | 62 | 1 |
316897 | 316897 | 2020-07-09 | Morrison | Minnesota | 27097 | 61 | 1 |
313723 | 313723 | 2020-07-08 | Morrison | Minnesota | 27097 | 61 | 1 |
310553 | 310553 | 2020-07-07 | Morrison | Minnesota | 27097 | 61 | 1 |
307385 | 307385 | 2020-07-06 | Morrison | Minnesota | 27097 | 59 | 1 |
304218 | 304218 | 2020-07-05 | Morrison | Minnesota | 27097 | 59 | 1 |
301054 | 301054 | 2020-07-04 | Morrison | Minnesota | 27097 | 59 | 1 |
297891 | 297891 | 2020-07-03 | Morrison | Minnesota | 27097 | 59 | 1 |
294733 | 294733 | 2020-07-02 | Morrison | Minnesota | 27097 | 59 | 1 |
291579 | 291579 | 2020-07-01 | Morrison | Minnesota | 27097 | 57 | 1 |
288428 | 288428 | 2020-06-30 | Morrison | Minnesota | 27097 | 58 | 1 |
285278 | 285278 | 2020-06-29 | Morrison | Minnesota | 27097 | 58 | 1 |
282133 | 282133 | 2020-06-28 | Morrison | Minnesota | 27097 | 57 | 1 |
278985 | 278985 | 2020-06-27 | Morrison | Minnesota | 27097 | 57 | 1 |
275837 | 275837 | 2020-06-26 | Morrison | Minnesota | 27097 | 57 | 1 |
272694 | 272694 | 2020-06-25 | Morrison | Minnesota | 27097 | 56 | 1 |
269557 | 269557 | 2020-06-24 | Morrison | Minnesota | 27097 | 56 | 1 |
266424 | 266424 | 2020-06-23 | Morrison | Minnesota | 27097 | 56 | 1 |
263298 | 263298 | 2020-06-22 | Morrison | Minnesota | 27097 | 56 | 1 |
260169 | 260169 | 2020-06-21 | Morrison | Minnesota | 27097 | 55 | 1 |
257043 | 257043 | 2020-06-20 | Morrison | Minnesota | 27097 | 54 | 1 |
253923 | 253923 | 2020-06-19 | Morrison | Minnesota | 27097 | 54 | 1 |
250808 | 250808 | 2020-06-18 | Morrison | Minnesota | 27097 | 54 | 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);