ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 27139 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921832 | 921832 | 2021-01-12 | Scott | Minnesota | 27139 | 11703 | 93 |
918587 | 918587 | 2021-01-11 | Scott | Minnesota | 27139 | 11665 | 93 |
915342 | 915342 | 2021-01-10 | Scott | Minnesota | 27139 | 11634 | 92 |
912097 | 912097 | 2021-01-09 | Scott | Minnesota | 27139 | 11591 | 91 |
908852 | 908852 | 2021-01-08 | Scott | Minnesota | 27139 | 11498 | 91 |
905606 | 905606 | 2021-01-07 | Scott | Minnesota | 27139 | 11424 | 88 |
902361 | 902361 | 2021-01-06 | Scott | Minnesota | 27139 | 11354 | 87 |
899116 | 899116 | 2021-01-05 | Scott | Minnesota | 27139 | 11280 | 85 |
895871 | 895871 | 2021-01-04 | Scott | Minnesota | 27139 | 11246 | 84 |
892624 | 892624 | 2021-01-03 | Scott | Minnesota | 27139 | 11184 | 84 |
889378 | 889378 | 2021-01-02 | Scott | Minnesota | 27139 | 11108 | 83 |
886132 | 886132 | 2021-01-01 | Scott | Minnesota | 27139 | 11016 | 81 |
882887 | 882887 | 2020-12-31 | Scott | Minnesota | 27139 | 11016 | 81 |
879642 | 879642 | 2020-12-30 | Scott | Minnesota | 27139 | 10947 | 80 |
876397 | 876397 | 2020-12-29 | Scott | Minnesota | 27139 | 10886 | 78 |
873152 | 873152 | 2020-12-28 | Scott | Minnesota | 27139 | 10860 | 76 |
869907 | 869907 | 2020-12-27 | Scott | Minnesota | 27139 | 10834 | 76 |
866662 | 866662 | 2020-12-26 | Scott | Minnesota | 27139 | 10777 | 76 |
863417 | 863417 | 2020-12-25 | Scott | Minnesota | 27139 | 10693 | 74 |
860172 | 860172 | 2020-12-24 | Scott | Minnesota | 27139 | 10693 | 74 |
856927 | 856927 | 2020-12-23 | Scott | Minnesota | 27139 | 10654 | 74 |
853682 | 853682 | 2020-12-22 | Scott | Minnesota | 27139 | 10625 | 73 |
850437 | 850437 | 2020-12-21 | Scott | Minnesota | 27139 | 10580 | 73 |
847192 | 847192 | 2020-12-20 | Scott | Minnesota | 27139 | 10546 | 73 |
843946 | 843946 | 2020-12-19 | Scott | Minnesota | 27139 | 10468 | 73 |
840701 | 840701 | 2020-12-18 | Scott | Minnesota | 27139 | 10412 | 72 |
837456 | 837456 | 2020-12-17 | Scott | Minnesota | 27139 | 10357 | 72 |
834210 | 834210 | 2020-12-16 | Scott | Minnesota | 27139 | 10285 | 72 |
830963 | 830963 | 2020-12-15 | Scott | Minnesota | 27139 | 10233 | 71 |
827717 | 827717 | 2020-12-14 | Scott | Minnesota | 27139 | 10160 | 71 |
824470 | 824470 | 2020-12-13 | Scott | Minnesota | 27139 | 10091 | 70 |
821224 | 821224 | 2020-12-12 | Scott | Minnesota | 27139 | 10013 | 69 |
817978 | 817978 | 2020-12-11 | Scott | Minnesota | 27139 | 9898 | 66 |
814732 | 814732 | 2020-12-10 | Scott | Minnesota | 27139 | 9805 | 64 |
811487 | 811487 | 2020-12-09 | Scott | Minnesota | 27139 | 9727 | 64 |
808242 | 808242 | 2020-12-08 | Scott | Minnesota | 27139 | 9605 | 63 |
804997 | 804997 | 2020-12-07 | Scott | Minnesota | 27139 | 9530 | 63 |
801752 | 801752 | 2020-12-06 | Scott | Minnesota | 27139 | 9417 | 63 |
798507 | 798507 | 2020-12-05 | Scott | Minnesota | 27139 | 9274 | 63 |
795262 | 795262 | 2020-12-04 | Scott | Minnesota | 27139 | 9094 | 61 |
792017 | 792017 | 2020-12-03 | Scott | Minnesota | 27139 | 8964 | 60 |
788772 | 788772 | 2020-12-02 | Scott | Minnesota | 27139 | 8810 | 56 |
785527 | 785527 | 2020-12-01 | Scott | Minnesota | 27139 | 8667 | 55 |
782283 | 782283 | 2020-11-30 | Scott | Minnesota | 27139 | 8597 | 55 |
779037 | 779037 | 2020-11-29 | Scott | Minnesota | 27139 | 8462 | 55 |
775792 | 775792 | 2020-11-28 | Scott | Minnesota | 27139 | 8201 | 54 |
772547 | 772547 | 2020-11-27 | Scott | Minnesota | 27139 | 7981 | 54 |
769302 | 769302 | 2020-11-26 | Scott | Minnesota | 27139 | 7827 | 54 |
766056 | 766056 | 2020-11-25 | Scott | Minnesota | 27139 | 7827 | 54 |
762811 | 762811 | 2020-11-24 | Scott | Minnesota | 27139 | 7647 | 54 |
759566 | 759566 | 2020-11-23 | Scott | Minnesota | 27139 | 7538 | 54 |
756319 | 756319 | 2020-11-22 | Scott | Minnesota | 27139 | 7356 | 54 |
753073 | 753073 | 2020-11-21 | Scott | Minnesota | 27139 | 7131 | 53 |
749827 | 749827 | 2020-11-20 | Scott | Minnesota | 27139 | 6884 | 52 |
746581 | 746581 | 2020-11-19 | Scott | Minnesota | 27139 | 6701 | 52 |
743334 | 743334 | 2020-11-18 | Scott | Minnesota | 27139 | 6467 | 51 |
740087 | 740087 | 2020-11-17 | Scott | Minnesota | 27139 | 6296 | 51 |
736843 | 736843 | 2020-11-16 | Scott | Minnesota | 27139 | 6146 | 49 |
733597 | 733597 | 2020-11-15 | Scott | Minnesota | 27139 | 5897 | 49 |
730352 | 730352 | 2020-11-14 | Scott | Minnesota | 27139 | 5596 | 49 |
727109 | 727109 | 2020-11-13 | Scott | Minnesota | 27139 | 5336 | 49 |
723866 | 723866 | 2020-11-12 | Scott | Minnesota | 27139 | 5178 | 47 |
720623 | 720623 | 2020-11-11 | Scott | Minnesota | 27139 | 5025 | 46 |
717380 | 717380 | 2020-11-10 | Scott | Minnesota | 27139 | 4862 | 45 |
714136 | 714136 | 2020-11-09 | Scott | Minnesota | 27139 | 4744 | 44 |
710892 | 710892 | 2020-11-08 | Scott | Minnesota | 27139 | 4644 | 42 |
707648 | 707648 | 2020-11-07 | Scott | Minnesota | 27139 | 4481 | 40 |
704405 | 704405 | 2020-11-06 | Scott | Minnesota | 27139 | 4340 | 39 |
701163 | 701163 | 2020-11-05 | Scott | Minnesota | 27139 | 4201 | 39 |
697919 | 697919 | 2020-11-04 | Scott | Minnesota | 27139 | 4098 | 38 |
694676 | 694676 | 2020-11-03 | Scott | Minnesota | 27139 | 4013 | 37 |
691434 | 691434 | 2020-11-02 | Scott | Minnesota | 27139 | 3918 | 37 |
688189 | 688189 | 2020-11-01 | Scott | Minnesota | 27139 | 3836 | 37 |
684945 | 684945 | 2020-10-31 | Scott | Minnesota | 27139 | 3779 | 36 |
681702 | 681702 | 2020-10-30 | Scott | Minnesota | 27139 | 3666 | 36 |
678458 | 678458 | 2020-10-29 | Scott | Minnesota | 27139 | 3604 | 36 |
675216 | 675216 | 2020-10-28 | Scott | Minnesota | 27139 | 3549 | 34 |
671973 | 671973 | 2020-10-27 | Scott | Minnesota | 27139 | 3496 | 34 |
668731 | 668731 | 2020-10-26 | Scott | Minnesota | 27139 | 3429 | 34 |
665487 | 665487 | 2020-10-25 | Scott | Minnesota | 27139 | 3382 | 34 |
662242 | 662242 | 2020-10-24 | Scott | Minnesota | 27139 | 3348 | 34 |
658998 | 658998 | 2020-10-23 | Scott | Minnesota | 27139 | 3293 | 34 |
655753 | 655753 | 2020-10-22 | Scott | Minnesota | 27139 | 3265 | 34 |
652508 | 652508 | 2020-10-21 | Scott | Minnesota | 27139 | 3234 | 34 |
649263 | 649263 | 2020-10-20 | Scott | Minnesota | 27139 | 3209 | 34 |
646019 | 646019 | 2020-10-19 | Scott | Minnesota | 27139 | 3185 | 34 |
642772 | 642772 | 2020-10-18 | Scott | Minnesota | 27139 | 3156 | 34 |
639525 | 639525 | 2020-10-17 | Scott | Minnesota | 27139 | 3112 | 34 |
636279 | 636279 | 2020-10-16 | Scott | Minnesota | 27139 | 3057 | 34 |
633033 | 633033 | 2020-10-15 | Scott | Minnesota | 27139 | 3016 | 34 |
629788 | 629788 | 2020-10-14 | Scott | Minnesota | 27139 | 2995 | 34 |
626544 | 626544 | 2020-10-13 | Scott | Minnesota | 27139 | 2969 | 34 |
623302 | 623302 | 2020-10-12 | Scott | Minnesota | 27139 | 2946 | 34 |
620059 | 620059 | 2020-10-11 | Scott | Minnesota | 27139 | 2925 | 34 |
616817 | 616817 | 2020-10-10 | Scott | Minnesota | 27139 | 2889 | 34 |
613576 | 613576 | 2020-10-09 | Scott | Minnesota | 27139 | 2853 | 34 |
610334 | 610334 | 2020-10-08 | Scott | Minnesota | 27139 | 2822 | 34 |
607092 | 607092 | 2020-10-07 | Scott | Minnesota | 27139 | 2806 | 34 |
603849 | 603849 | 2020-10-06 | Scott | Minnesota | 27139 | 2794 | 34 |
600607 | 600607 | 2020-10-05 | Scott | Minnesota | 27139 | 2770 | 33 |
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);