ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Stearns" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921836 | 921836 | 2021-01-12 | Stearns | Minnesota | 27145 | 17600 | 179 |
918591 | 918591 | 2021-01-11 | Stearns | Minnesota | 27145 | 17568 | 179 |
915346 | 915346 | 2021-01-10 | Stearns | Minnesota | 27145 | 17548 | 179 |
912101 | 912101 | 2021-01-09 | Stearns | Minnesota | 27145 | 17499 | 179 |
908856 | 908856 | 2021-01-08 | Stearns | Minnesota | 27145 | 17441 | 177 |
905610 | 905610 | 2021-01-07 | Stearns | Minnesota | 27145 | 17384 | 177 |
902365 | 902365 | 2021-01-06 | Stearns | Minnesota | 27145 | 17327 | 175 |
899120 | 899120 | 2021-01-05 | Stearns | Minnesota | 27145 | 17249 | 175 |
895875 | 895875 | 2021-01-04 | Stearns | Minnesota | 27145 | 17190 | 175 |
892628 | 892628 | 2021-01-03 | Stearns | Minnesota | 27145 | 17093 | 173 |
889382 | 889382 | 2021-01-02 | Stearns | Minnesota | 27145 | 17019 | 173 |
886136 | 886136 | 2021-01-01 | Stearns | Minnesota | 27145 | 16946 | 172 |
882891 | 882891 | 2020-12-31 | Stearns | Minnesota | 27145 | 16946 | 172 |
879646 | 879646 | 2020-12-30 | Stearns | Minnesota | 27145 | 16881 | 171 |
876401 | 876401 | 2020-12-29 | Stearns | Minnesota | 27145 | 16811 | 170 |
873156 | 873156 | 2020-12-28 | Stearns | Minnesota | 27145 | 16797 | 168 |
869911 | 869911 | 2020-12-27 | Stearns | Minnesota | 27145 | 16759 | 168 |
866666 | 866666 | 2020-12-26 | Stearns | Minnesota | 27145 | 16701 | 167 |
863421 | 863421 | 2020-12-25 | Stearns | Minnesota | 27145 | 16630 | 165 |
860176 | 860176 | 2020-12-24 | Stearns | Minnesota | 27145 | 16630 | 165 |
856931 | 856931 | 2020-12-23 | Stearns | Minnesota | 27145 | 16569 | 164 |
853686 | 853686 | 2020-12-22 | Stearns | Minnesota | 27145 | 16524 | 161 |
850441 | 850441 | 2020-12-21 | Stearns | Minnesota | 27145 | 16478 | 160 |
847196 | 847196 | 2020-12-20 | Stearns | Minnesota | 27145 | 16422 | 159 |
843950 | 843950 | 2020-12-19 | Stearns | Minnesota | 27145 | 16354 | 157 |
840705 | 840705 | 2020-12-18 | Stearns | Minnesota | 27145 | 16285 | 155 |
837460 | 837460 | 2020-12-17 | Stearns | Minnesota | 27145 | 16209 | 153 |
834214 | 834214 | 2020-12-16 | Stearns | Minnesota | 27145 | 16133 | 151 |
830967 | 830967 | 2020-12-15 | Stearns | Minnesota | 27145 | 16065 | 145 |
827721 | 827721 | 2020-12-14 | Stearns | Minnesota | 27145 | 16011 | 145 |
824474 | 824474 | 2020-12-13 | Stearns | Minnesota | 27145 | 15926 | 145 |
821228 | 821228 | 2020-12-12 | Stearns | Minnesota | 27145 | 15854 | 142 |
817982 | 817982 | 2020-12-11 | Stearns | Minnesota | 27145 | 15746 | 141 |
814736 | 814736 | 2020-12-10 | Stearns | Minnesota | 27145 | 15611 | 139 |
811491 | 811491 | 2020-12-09 | Stearns | Minnesota | 27145 | 15469 | 138 |
808246 | 808246 | 2020-12-08 | Stearns | Minnesota | 27145 | 15303 | 133 |
805001 | 805001 | 2020-12-07 | Stearns | Minnesota | 27145 | 15227 | 133 |
801756 | 801756 | 2020-12-06 | Stearns | Minnesota | 27145 | 15064 | 132 |
798511 | 798511 | 2020-12-05 | Stearns | Minnesota | 27145 | 14916 | 130 |
795266 | 795266 | 2020-12-04 | Stearns | Minnesota | 27145 | 14679 | 126 |
792021 | 792021 | 2020-12-03 | Stearns | Minnesota | 27145 | 14564 | 125 |
788776 | 788776 | 2020-12-02 | Stearns | Minnesota | 27145 | 14314 | 121 |
785531 | 785531 | 2020-12-01 | Stearns | Minnesota | 27145 | 14131 | 117 |
782287 | 782287 | 2020-11-30 | Stearns | Minnesota | 27145 | 13976 | 117 |
779041 | 779041 | 2020-11-29 | Stearns | Minnesota | 27145 | 13733 | 116 |
775796 | 775796 | 2020-11-28 | Stearns | Minnesota | 27145 | 13524 | 108 |
772551 | 772551 | 2020-11-27 | Stearns | Minnesota | 27145 | 13245 | 106 |
769306 | 769306 | 2020-11-26 | Stearns | Minnesota | 27145 | 12910 | 98 |
766060 | 766060 | 2020-11-25 | Stearns | Minnesota | 27145 | 12910 | 98 |
762815 | 762815 | 2020-11-24 | Stearns | Minnesota | 27145 | 12547 | 93 |
759570 | 759570 | 2020-11-23 | Stearns | Minnesota | 27145 | 12266 | 89 |
756323 | 756323 | 2020-11-22 | Stearns | Minnesota | 27145 | 12003 | 89 |
753077 | 753077 | 2020-11-21 | Stearns | Minnesota | 27145 | 11795 | 88 |
749831 | 749831 | 2020-11-20 | Stearns | Minnesota | 27145 | 11593 | 84 |
746585 | 746585 | 2020-11-19 | Stearns | Minnesota | 27145 | 11238 | 79 |
743338 | 743338 | 2020-11-18 | Stearns | Minnesota | 27145 | 10739 | 76 |
740091 | 740091 | 2020-11-17 | Stearns | Minnesota | 27145 | 10524 | 74 |
736847 | 736847 | 2020-11-16 | Stearns | Minnesota | 27145 | 10199 | 74 |
733601 | 733601 | 2020-11-15 | Stearns | Minnesota | 27145 | 9883 | 74 |
730356 | 730356 | 2020-11-14 | Stearns | Minnesota | 27145 | 9724 | 71 |
727113 | 727113 | 2020-11-13 | Stearns | Minnesota | 27145 | 9365 | 69 |
723870 | 723870 | 2020-11-12 | Stearns | Minnesota | 27145 | 9027 | 68 |
720627 | 720627 | 2020-11-11 | Stearns | Minnesota | 27145 | 8661 | 66 |
717384 | 717384 | 2020-11-10 | Stearns | Minnesota | 27145 | 8474 | 61 |
714140 | 714140 | 2020-11-09 | Stearns | Minnesota | 27145 | 8229 | 61 |
710896 | 710896 | 2020-11-08 | Stearns | Minnesota | 27145 | 8023 | 60 |
707652 | 707652 | 2020-11-07 | Stearns | Minnesota | 27145 | 7839 | 59 |
704409 | 704409 | 2020-11-06 | Stearns | Minnesota | 27145 | 7654 | 58 |
701167 | 701167 | 2020-11-05 | Stearns | Minnesota | 27145 | 7315 | 55 |
697923 | 697923 | 2020-11-04 | Stearns | Minnesota | 27145 | 7141 | 54 |
694680 | 694680 | 2020-11-03 | Stearns | Minnesota | 27145 | 6946 | 53 |
691438 | 691438 | 2020-11-02 | Stearns | Minnesota | 27145 | 6778 | 53 |
688193 | 688193 | 2020-11-01 | Stearns | Minnesota | 27145 | 6666 | 53 |
684949 | 684949 | 2020-10-31 | Stearns | Minnesota | 27145 | 6592 | 51 |
681706 | 681706 | 2020-10-30 | Stearns | Minnesota | 27145 | 6478 | 50 |
678462 | 678462 | 2020-10-29 | Stearns | Minnesota | 27145 | 6255 | 50 |
675220 | 675220 | 2020-10-28 | Stearns | Minnesota | 27145 | 6082 | 48 |
671977 | 671977 | 2020-10-27 | Stearns | Minnesota | 27145 | 5991 | 44 |
668735 | 668735 | 2020-10-26 | Stearns | Minnesota | 27145 | 5883 | 44 |
665491 | 665491 | 2020-10-25 | Stearns | Minnesota | 27145 | 5825 | 43 |
662246 | 662246 | 2020-10-24 | Stearns | Minnesota | 27145 | 5743 | 43 |
659002 | 659002 | 2020-10-23 | Stearns | Minnesota | 27145 | 5665 | 41 |
655757 | 655757 | 2020-10-22 | Stearns | Minnesota | 27145 | 5546 | 41 |
652512 | 652512 | 2020-10-21 | Stearns | Minnesota | 27145 | 5485 | 40 |
649267 | 649267 | 2020-10-20 | Stearns | Minnesota | 27145 | 5443 | 36 |
646023 | 646023 | 2020-10-19 | Stearns | Minnesota | 27145 | 5370 | 35 |
642776 | 642776 | 2020-10-18 | Stearns | Minnesota | 27145 | 5255 | 34 |
639529 | 639529 | 2020-10-17 | Stearns | Minnesota | 27145 | 5161 | 33 |
636283 | 636283 | 2020-10-16 | Stearns | Minnesota | 27145 | 5094 | 33 |
633037 | 633037 | 2020-10-15 | Stearns | Minnesota | 27145 | 4888 | 33 |
629792 | 629792 | 2020-10-14 | Stearns | Minnesota | 27145 | 4841 | 33 |
626548 | 626548 | 2020-10-13 | Stearns | Minnesota | 27145 | 4758 | 31 |
623306 | 623306 | 2020-10-12 | Stearns | Minnesota | 27145 | 4725 | 29 |
620063 | 620063 | 2020-10-11 | Stearns | Minnesota | 27145 | 4693 | 29 |
616821 | 616821 | 2020-10-10 | Stearns | Minnesota | 27145 | 4634 | 30 |
613580 | 613580 | 2020-10-09 | Stearns | Minnesota | 27145 | 4570 | 29 |
610338 | 610338 | 2020-10-08 | Stearns | Minnesota | 27145 | 4508 | 28 |
607096 | 607096 | 2020-10-07 | Stearns | Minnesota | 27145 | 4439 | 27 |
603853 | 603853 | 2020-10-06 | Stearns | Minnesota | 27145 | 4387 | 26 |
600611 | 600611 | 2020-10-05 | Stearns | Minnesota | 27145 | 4362 | 26 |
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);