ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 17, fips = 27103 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668714 | 668714 | 2020-10-26 | Nicollet | Minnesota | 27103 | 739 | 17 |
665470 | 665470 | 2020-10-25 | Nicollet | Minnesota | 27103 | 730 | 17 |
662225 | 662225 | 2020-10-24 | Nicollet | Minnesota | 27103 | 718 | 17 |
658981 | 658981 | 2020-10-23 | Nicollet | Minnesota | 27103 | 714 | 17 |
655736 | 655736 | 2020-10-22 | Nicollet | Minnesota | 27103 | 700 | 17 |
652491 | 652491 | 2020-10-21 | Nicollet | Minnesota | 27103 | 689 | 17 |
649246 | 649246 | 2020-10-20 | Nicollet | Minnesota | 27103 | 682 | 17 |
646002 | 646002 | 2020-10-19 | Nicollet | Minnesota | 27103 | 673 | 17 |
642755 | 642755 | 2020-10-18 | Nicollet | Minnesota | 27103 | 664 | 17 |
639508 | 639508 | 2020-10-17 | Nicollet | Minnesota | 27103 | 663 | 17 |
636262 | 636262 | 2020-10-16 | Nicollet | Minnesota | 27103 | 651 | 17 |
633016 | 633016 | 2020-10-15 | Nicollet | Minnesota | 27103 | 638 | 17 |
629771 | 629771 | 2020-10-14 | Nicollet | Minnesota | 27103 | 637 | 17 |
626527 | 626527 | 2020-10-13 | Nicollet | Minnesota | 27103 | 630 | 17 |
623285 | 623285 | 2020-10-12 | Nicollet | Minnesota | 27103 | 628 | 17 |
620042 | 620042 | 2020-10-11 | Nicollet | Minnesota | 27103 | 628 | 17 |
616800 | 616800 | 2020-10-10 | Nicollet | Minnesota | 27103 | 625 | 17 |
613559 | 613559 | 2020-10-09 | Nicollet | Minnesota | 27103 | 619 | 17 |
610317 | 610317 | 2020-10-08 | Nicollet | Minnesota | 27103 | 613 | 17 |
607075 | 607075 | 2020-10-07 | Nicollet | Minnesota | 27103 | 607 | 17 |
603832 | 603832 | 2020-10-06 | Nicollet | Minnesota | 27103 | 602 | 17 |
600590 | 600590 | 2020-10-05 | Nicollet | Minnesota | 27103 | 594 | 17 |
597347 | 597347 | 2020-10-04 | Nicollet | Minnesota | 27103 | 589 | 17 |
594106 | 594106 | 2020-10-03 | Nicollet | Minnesota | 27103 | 583 | 17 |
590865 | 590865 | 2020-10-02 | Nicollet | Minnesota | 27103 | 570 | 17 |
587624 | 587624 | 2020-10-01 | Nicollet | Minnesota | 27103 | 562 | 17 |
584384 | 584384 | 2020-09-30 | Nicollet | Minnesota | 27103 | 553 | 17 |
581143 | 581143 | 2020-09-29 | Nicollet | Minnesota | 27103 | 547 | 17 |
577902 | 577902 | 2020-09-28 | Nicollet | Minnesota | 27103 | 545 | 17 |
574661 | 574661 | 2020-09-27 | Nicollet | Minnesota | 27103 | 542 | 17 |
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);