ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where deaths = 1, fips = 27151 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 |
---|---|---|---|---|---|---|---|
671980 | 671980 | 2020-10-27 | Swift | Minnesota | 27151 | 209 | 1 |
668738 | 668738 | 2020-10-26 | Swift | Minnesota | 27151 | 207 | 1 |
665494 | 665494 | 2020-10-25 | Swift | Minnesota | 27151 | 201 | 1 |
662249 | 662249 | 2020-10-24 | Swift | Minnesota | 27151 | 201 | 1 |
659005 | 659005 | 2020-10-23 | Swift | Minnesota | 27151 | 194 | 1 |
655760 | 655760 | 2020-10-22 | Swift | Minnesota | 27151 | 193 | 1 |
652515 | 652515 | 2020-10-21 | Swift | Minnesota | 27151 | 192 | 1 |
649270 | 649270 | 2020-10-20 | Swift | Minnesota | 27151 | 192 | 1 |
646026 | 646026 | 2020-10-19 | Swift | Minnesota | 27151 | 192 | 1 |
642779 | 642779 | 2020-10-18 | Swift | Minnesota | 27151 | 191 | 1 |
639532 | 639532 | 2020-10-17 | Swift | Minnesota | 27151 | 184 | 1 |
636286 | 636286 | 2020-10-16 | Swift | Minnesota | 27151 | 179 | 1 |
633040 | 633040 | 2020-10-15 | Swift | Minnesota | 27151 | 178 | 1 |
629795 | 629795 | 2020-10-14 | Swift | Minnesota | 27151 | 178 | 1 |
626551 | 626551 | 2020-10-13 | Swift | Minnesota | 27151 | 174 | 1 |
623309 | 623309 | 2020-10-12 | Swift | Minnesota | 27151 | 173 | 1 |
620066 | 620066 | 2020-10-11 | Swift | Minnesota | 27151 | 167 | 1 |
616824 | 616824 | 2020-10-10 | Swift | Minnesota | 27151 | 166 | 1 |
613583 | 613583 | 2020-10-09 | Swift | Minnesota | 27151 | 163 | 1 |
610341 | 610341 | 2020-10-08 | Swift | Minnesota | 27151 | 160 | 1 |
607099 | 607099 | 2020-10-07 | Swift | Minnesota | 27151 | 156 | 1 |
603856 | 603856 | 2020-10-06 | Swift | Minnesota | 27151 | 156 | 1 |
600614 | 600614 | 2020-10-05 | Swift | Minnesota | 27151 | 155 | 1 |
597371 | 597371 | 2020-10-04 | Swift | Minnesota | 27151 | 155 | 1 |
594130 | 594130 | 2020-10-03 | Swift | Minnesota | 27151 | 152 | 1 |
590889 | 590889 | 2020-10-02 | Swift | Minnesota | 27151 | 153 | 1 |
587648 | 587648 | 2020-10-01 | Swift | Minnesota | 27151 | 147 | 1 |
584408 | 584408 | 2020-09-30 | Swift | Minnesota | 27151 | 145 | 1 |
581167 | 581167 | 2020-09-29 | Swift | Minnesota | 27151 | 144 | 1 |
577926 | 577926 | 2020-09-28 | Swift | Minnesota | 27151 | 144 | 1 |
574685 | 574685 | 2020-09-27 | Swift | Minnesota | 27151 | 142 | 1 |
571442 | 571442 | 2020-09-26 | Swift | Minnesota | 27151 | 138 | 1 |
568200 | 568200 | 2020-09-25 | Swift | Minnesota | 27151 | 137 | 1 |
564960 | 564960 | 2020-09-24 | Swift | Minnesota | 27151 | 127 | 1 |
561720 | 561720 | 2020-09-23 | Swift | Minnesota | 27151 | 123 | 1 |
558483 | 558483 | 2020-09-22 | Swift | Minnesota | 27151 | 123 | 1 |
555246 | 555246 | 2020-09-21 | Swift | Minnesota | 27151 | 123 | 1 |
552008 | 552008 | 2020-09-20 | Swift | Minnesota | 27151 | 114 | 1 |
548769 | 548769 | 2020-09-19 | Swift | Minnesota | 27151 | 111 | 1 |
545531 | 545531 | 2020-09-18 | Swift | Minnesota | 27151 | 104 | 1 |
542294 | 542294 | 2020-09-17 | Swift | Minnesota | 27151 | 99 | 1 |
539058 | 539058 | 2020-09-16 | Swift | Minnesota | 27151 | 96 | 1 |
535821 | 535821 | 2020-09-15 | Swift | Minnesota | 27151 | 96 | 1 |
532586 | 532586 | 2020-09-14 | Swift | Minnesota | 27151 | 96 | 1 |
529350 | 529350 | 2020-09-13 | Swift | Minnesota | 27151 | 94 | 1 |
526114 | 526114 | 2020-09-12 | Swift | Minnesota | 27151 | 89 | 1 |
522878 | 522878 | 2020-09-11 | Swift | Minnesota | 27151 | 78 | 1 |
519641 | 519641 | 2020-09-10 | Swift | Minnesota | 27151 | 74 | 1 |
516406 | 516406 | 2020-09-09 | Swift | Minnesota | 27151 | 74 | 1 |
513172 | 513172 | 2020-09-08 | Swift | Minnesota | 27151 | 73 | 1 |
509940 | 509940 | 2020-09-07 | Swift | Minnesota | 27151 | 71 | 1 |
506707 | 506707 | 2020-09-06 | Swift | Minnesota | 27151 | 69 | 1 |
503474 | 503474 | 2020-09-05 | Swift | Minnesota | 27151 | 69 | 1 |
500240 | 500240 | 2020-09-04 | Swift | Minnesota | 27151 | 70 | 1 |
497006 | 497006 | 2020-09-03 | Swift | Minnesota | 27151 | 68 | 1 |
493773 | 493773 | 2020-09-02 | Swift | Minnesota | 27151 | 65 | 1 |
490539 | 490539 | 2020-09-01 | Swift | Minnesota | 27151 | 65 | 1 |
487306 | 487306 | 2020-08-31 | Swift | Minnesota | 27151 | 65 | 1 |
484072 | 484072 | 2020-08-30 | Swift | Minnesota | 27151 | 63 | 1 |
480837 | 480837 | 2020-08-29 | Swift | Minnesota | 27151 | 60 | 1 |
477605 | 477605 | 2020-08-28 | Swift | Minnesota | 27151 | 60 | 1 |
474372 | 474372 | 2020-08-27 | Swift | Minnesota | 27151 | 60 | 1 |
471140 | 471140 | 2020-08-26 | Swift | Minnesota | 27151 | 60 | 1 |
467910 | 467910 | 2020-08-25 | Swift | Minnesota | 27151 | 60 | 1 |
464681 | 464681 | 2020-08-24 | Swift | Minnesota | 27151 | 60 | 1 |
461450 | 461450 | 2020-08-23 | Swift | Minnesota | 27151 | 59 | 1 |
458223 | 458223 | 2020-08-22 | Swift | Minnesota | 27151 | 58 | 1 |
454995 | 454995 | 2020-08-21 | Swift | Minnesota | 27151 | 58 | 1 |
451767 | 451767 | 2020-08-20 | Swift | Minnesota | 27151 | 58 | 1 |
448539 | 448539 | 2020-08-19 | Swift | Minnesota | 27151 | 58 | 1 |
445313 | 445313 | 2020-08-18 | Swift | Minnesota | 27151 | 58 | 1 |
442087 | 442087 | 2020-08-17 | Swift | Minnesota | 27151 | 58 | 1 |
438860 | 438860 | 2020-08-16 | Swift | Minnesota | 27151 | 58 | 1 |
435635 | 435635 | 2020-08-15 | Swift | Minnesota | 27151 | 57 | 1 |
432409 | 432409 | 2020-08-14 | Swift | Minnesota | 27151 | 57 | 1 |
429182 | 429182 | 2020-08-13 | Swift | Minnesota | 27151 | 56 | 1 |
425958 | 425958 | 2020-08-12 | Swift | Minnesota | 27151 | 55 | 1 |
422736 | 422736 | 2020-08-11 | Swift | Minnesota | 27151 | 55 | 1 |
419514 | 419514 | 2020-08-10 | Swift | Minnesota | 27151 | 55 | 1 |
416293 | 416293 | 2020-08-09 | Swift | Minnesota | 27151 | 53 | 1 |
413073 | 413073 | 2020-08-08 | Swift | Minnesota | 27151 | 52 | 1 |
409853 | 409853 | 2020-08-07 | Swift | Minnesota | 27151 | 52 | 1 |
406633 | 406633 | 2020-08-06 | Swift | Minnesota | 27151 | 52 | 1 |
403415 | 403415 | 2020-08-05 | Swift | Minnesota | 27151 | 52 | 1 |
400198 | 400198 | 2020-08-04 | Swift | Minnesota | 27151 | 52 | 1 |
396984 | 396984 | 2020-08-03 | Swift | Minnesota | 27151 | 52 | 1 |
393768 | 393768 | 2020-08-02 | Swift | Minnesota | 27151 | 52 | 1 |
390551 | 390551 | 2020-08-01 | Swift | Minnesota | 27151 | 51 | 1 |
387334 | 387334 | 2020-07-31 | Swift | Minnesota | 27151 | 51 | 1 |
384116 | 384116 | 2020-07-30 | Swift | Minnesota | 27151 | 51 | 1 |
380899 | 380899 | 2020-07-29 | Swift | Minnesota | 27151 | 51 | 1 |
377682 | 377682 | 2020-07-28 | Swift | Minnesota | 27151 | 51 | 1 |
374467 | 374467 | 2020-07-27 | Swift | Minnesota | 27151 | 50 | 1 |
371255 | 371255 | 2020-07-26 | Swift | Minnesota | 27151 | 50 | 1 |
368045 | 368045 | 2020-07-25 | Swift | Minnesota | 27151 | 48 | 1 |
364837 | 364837 | 2020-07-24 | Swift | Minnesota | 27151 | 47 | 1 |
361630 | 361630 | 2020-07-23 | Swift | Minnesota | 27151 | 47 | 1 |
358425 | 358425 | 2020-07-22 | Swift | Minnesota | 27151 | 47 | 1 |
355222 | 355222 | 2020-07-21 | Swift | Minnesota | 27151 | 46 | 1 |
352020 | 352020 | 2020-07-20 | Swift | Minnesota | 27151 | 46 | 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);