ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where county = "Aitkin", deaths = 1, fips = 27001 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 |
---|---|---|---|---|---|---|---|
642704 | 642704 | 2020-10-18 | Aitkin | Minnesota | 27001 | 151 | 1 |
639457 | 639457 | 2020-10-17 | Aitkin | Minnesota | 27001 | 146 | 1 |
636211 | 636211 | 2020-10-16 | Aitkin | Minnesota | 27001 | 140 | 1 |
632965 | 632965 | 2020-10-15 | Aitkin | Minnesota | 27001 | 133 | 1 |
629720 | 629720 | 2020-10-14 | Aitkin | Minnesota | 27001 | 129 | 1 |
626476 | 626476 | 2020-10-13 | Aitkin | Minnesota | 27001 | 123 | 1 |
623234 | 623234 | 2020-10-12 | Aitkin | Minnesota | 27001 | 119 | 1 |
619991 | 619991 | 2020-10-11 | Aitkin | Minnesota | 27001 | 117 | 1 |
616749 | 616749 | 2020-10-10 | Aitkin | Minnesota | 27001 | 113 | 1 |
613508 | 613508 | 2020-10-09 | Aitkin | Minnesota | 27001 | 111 | 1 |
610266 | 610266 | 2020-10-08 | Aitkin | Minnesota | 27001 | 108 | 1 |
607024 | 607024 | 2020-10-07 | Aitkin | Minnesota | 27001 | 108 | 1 |
603781 | 603781 | 2020-10-06 | Aitkin | Minnesota | 27001 | 103 | 1 |
600539 | 600539 | 2020-10-05 | Aitkin | Minnesota | 27001 | 101 | 1 |
597296 | 597296 | 2020-10-04 | Aitkin | Minnesota | 27001 | 95 | 1 |
594055 | 594055 | 2020-10-03 | Aitkin | Minnesota | 27001 | 94 | 1 |
590814 | 590814 | 2020-10-02 | Aitkin | Minnesota | 27001 | 97 | 1 |
587573 | 587573 | 2020-10-01 | Aitkin | Minnesota | 27001 | 91 | 1 |
584333 | 584333 | 2020-09-30 | Aitkin | Minnesota | 27001 | 88 | 1 |
581092 | 581092 | 2020-09-29 | Aitkin | Minnesota | 27001 | 84 | 1 |
577851 | 577851 | 2020-09-28 | Aitkin | Minnesota | 27001 | 83 | 1 |
574610 | 574610 | 2020-09-27 | Aitkin | Minnesota | 27001 | 81 | 1 |
571367 | 571367 | 2020-09-26 | Aitkin | Minnesota | 27001 | 80 | 1 |
568125 | 568125 | 2020-09-25 | Aitkin | Minnesota | 27001 | 76 | 1 |
564885 | 564885 | 2020-09-24 | Aitkin | Minnesota | 27001 | 75 | 1 |
561645 | 561645 | 2020-09-23 | Aitkin | Minnesota | 27001 | 74 | 1 |
558408 | 558408 | 2020-09-22 | Aitkin | Minnesota | 27001 | 76 | 1 |
555171 | 555171 | 2020-09-21 | Aitkin | Minnesota | 27001 | 73 | 1 |
551933 | 551933 | 2020-09-20 | Aitkin | Minnesota | 27001 | 71 | 1 |
548694 | 548694 | 2020-09-19 | Aitkin | Minnesota | 27001 | 70 | 1 |
545456 | 545456 | 2020-09-18 | Aitkin | Minnesota | 27001 | 69 | 1 |
542219 | 542219 | 2020-09-17 | Aitkin | Minnesota | 27001 | 69 | 1 |
538983 | 538983 | 2020-09-16 | Aitkin | Minnesota | 27001 | 68 | 1 |
535746 | 535746 | 2020-09-15 | Aitkin | Minnesota | 27001 | 66 | 1 |
532511 | 532511 | 2020-09-14 | Aitkin | Minnesota | 27001 | 66 | 1 |
529275 | 529275 | 2020-09-13 | Aitkin | Minnesota | 27001 | 66 | 1 |
526039 | 526039 | 2020-09-12 | Aitkin | Minnesota | 27001 | 65 | 1 |
522803 | 522803 | 2020-09-11 | Aitkin | Minnesota | 27001 | 63 | 1 |
519566 | 519566 | 2020-09-10 | Aitkin | Minnesota | 27001 | 63 | 1 |
516331 | 516331 | 2020-09-09 | Aitkin | Minnesota | 27001 | 64 | 1 |
513097 | 513097 | 2020-09-08 | Aitkin | Minnesota | 27001 | 64 | 1 |
509865 | 509865 | 2020-09-07 | Aitkin | Minnesota | 27001 | 59 | 1 |
506632 | 506632 | 2020-09-06 | Aitkin | Minnesota | 27001 | 59 | 1 |
503399 | 503399 | 2020-09-05 | Aitkin | Minnesota | 27001 | 58 | 1 |
500165 | 500165 | 2020-09-04 | Aitkin | Minnesota | 27001 | 55 | 1 |
496931 | 496931 | 2020-09-03 | Aitkin | Minnesota | 27001 | 52 | 1 |
493698 | 493698 | 2020-09-02 | Aitkin | Minnesota | 27001 | 51 | 1 |
490464 | 490464 | 2020-09-01 | Aitkin | Minnesota | 27001 | 51 | 1 |
487231 | 487231 | 2020-08-31 | Aitkin | Minnesota | 27001 | 48 | 1 |
483997 | 483997 | 2020-08-30 | Aitkin | Minnesota | 27001 | 48 | 1 |
480762 | 480762 | 2020-08-29 | Aitkin | Minnesota | 27001 | 48 | 1 |
477530 | 477530 | 2020-08-28 | Aitkin | Minnesota | 27001 | 48 | 1 |
474297 | 474297 | 2020-08-27 | Aitkin | Minnesota | 27001 | 47 | 1 |
471065 | 471065 | 2020-08-26 | Aitkin | Minnesota | 27001 | 46 | 1 |
467835 | 467835 | 2020-08-25 | Aitkin | Minnesota | 27001 | 45 | 1 |
464606 | 464606 | 2020-08-24 | Aitkin | Minnesota | 27001 | 45 | 1 |
461375 | 461375 | 2020-08-23 | Aitkin | Minnesota | 27001 | 45 | 1 |
458148 | 458148 | 2020-08-22 | Aitkin | Minnesota | 27001 | 45 | 1 |
454920 | 454920 | 2020-08-21 | Aitkin | Minnesota | 27001 | 44 | 1 |
451692 | 451692 | 2020-08-20 | Aitkin | Minnesota | 27001 | 44 | 1 |
448464 | 448464 | 2020-08-19 | Aitkin | Minnesota | 27001 | 44 | 1 |
445238 | 445238 | 2020-08-18 | Aitkin | Minnesota | 27001 | 44 | 1 |
442012 | 442012 | 2020-08-17 | Aitkin | Minnesota | 27001 | 44 | 1 |
438785 | 438785 | 2020-08-16 | Aitkin | Minnesota | 27001 | 42 | 1 |
435560 | 435560 | 2020-08-15 | Aitkin | Minnesota | 27001 | 42 | 1 |
432334 | 432334 | 2020-08-14 | Aitkin | Minnesota | 27001 | 42 | 1 |
429107 | 429107 | 2020-08-13 | Aitkin | Minnesota | 27001 | 41 | 1 |
425883 | 425883 | 2020-08-12 | Aitkin | Minnesota | 27001 | 40 | 1 |
422661 | 422661 | 2020-08-11 | Aitkin | Minnesota | 27001 | 41 | 1 |
419439 | 419439 | 2020-08-10 | Aitkin | Minnesota | 27001 | 40 | 1 |
416218 | 416218 | 2020-08-09 | Aitkin | Minnesota | 27001 | 40 | 1 |
412998 | 412998 | 2020-08-08 | Aitkin | Minnesota | 27001 | 40 | 1 |
409778 | 409778 | 2020-08-07 | Aitkin | Minnesota | 27001 | 34 | 1 |
406558 | 406558 | 2020-08-06 | Aitkin | Minnesota | 27001 | 29 | 1 |
403340 | 403340 | 2020-08-05 | Aitkin | Minnesota | 27001 | 29 | 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);