ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "St. Louis" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921835 | 921835 | 2021-01-12 | St. Louis | Minnesota | 27137 | 13358 | 231 |
918590 | 918590 | 2021-01-11 | St. Louis | Minnesota | 27137 | 13315 | 229 |
915345 | 915345 | 2021-01-10 | St. Louis | Minnesota | 27137 | 13281 | 229 |
912100 | 912100 | 2021-01-09 | St. Louis | Minnesota | 27137 | 13202 | 226 |
908855 | 908855 | 2021-01-08 | St. Louis | Minnesota | 27137 | 13143 | 226 |
905609 | 905609 | 2021-01-07 | St. Louis | Minnesota | 27137 | 13065 | 225 |
902364 | 902364 | 2021-01-06 | St. Louis | Minnesota | 27137 | 13018 | 220 |
899119 | 899119 | 2021-01-05 | St. Louis | Minnesota | 27137 | 12924 | 213 |
895874 | 895874 | 2021-01-04 | St. Louis | Minnesota | 27137 | 12865 | 212 |
892627 | 892627 | 2021-01-03 | St. Louis | Minnesota | 27137 | 12738 | 212 |
889381 | 889381 | 2021-01-02 | St. Louis | Minnesota | 27137 | 12624 | 208 |
886135 | 886135 | 2021-01-01 | St. Louis | Minnesota | 27137 | 12538 | 205 |
882890 | 882890 | 2020-12-31 | St. Louis | Minnesota | 27137 | 12538 | 205 |
879645 | 879645 | 2020-12-30 | St. Louis | Minnesota | 27137 | 12444 | 200 |
876400 | 876400 | 2020-12-29 | St. Louis | Minnesota | 27137 | 12365 | 198 |
873155 | 873155 | 2020-12-28 | St. Louis | Minnesota | 27137 | 12324 | 195 |
869910 | 869910 | 2020-12-27 | St. Louis | Minnesota | 27137 | 12254 | 193 |
866665 | 866665 | 2020-12-26 | St. Louis | Minnesota | 27137 | 12163 | 189 |
863420 | 863420 | 2020-12-25 | St. Louis | Minnesota | 27137 | 12066 | 186 |
860175 | 860175 | 2020-12-24 | St. Louis | Minnesota | 27137 | 12066 | 186 |
856930 | 856930 | 2020-12-23 | St. Louis | Minnesota | 27137 | 11983 | 181 |
853685 | 853685 | 2020-12-22 | St. Louis | Minnesota | 27137 | 11928 | 179 |
850440 | 850440 | 2020-12-21 | St. Louis | Minnesota | 27137 | 11885 | 179 |
847195 | 847195 | 2020-12-20 | St. Louis | Minnesota | 27137 | 11805 | 179 |
843949 | 843949 | 2020-12-19 | St. Louis | Minnesota | 27137 | 11705 | 177 |
840704 | 840704 | 2020-12-18 | St. Louis | Minnesota | 27137 | 11561 | 177 |
837459 | 837459 | 2020-12-17 | St. Louis | Minnesota | 27137 | 11467 | 172 |
834213 | 834213 | 2020-12-16 | St. Louis | Minnesota | 27137 | 11406 | 168 |
830966 | 830966 | 2020-12-15 | St. Louis | Minnesota | 27137 | 11333 | 159 |
827720 | 827720 | 2020-12-14 | St. Louis | Minnesota | 27137 | 11245 | 158 |
824473 | 824473 | 2020-12-13 | St. Louis | Minnesota | 27137 | 11121 | 158 |
821227 | 821227 | 2020-12-12 | St. Louis | Minnesota | 27137 | 11033 | 153 |
817981 | 817981 | 2020-12-11 | St. Louis | Minnesota | 27137 | 10834 | 149 |
814735 | 814735 | 2020-12-10 | St. Louis | Minnesota | 27137 | 10717 | 147 |
811490 | 811490 | 2020-12-09 | St. Louis | Minnesota | 27137 | 10621 | 141 |
808245 | 808245 | 2020-12-08 | St. Louis | Minnesota | 27137 | 10474 | 134 |
805000 | 805000 | 2020-12-07 | St. Louis | Minnesota | 27137 | 10361 | 134 |
801755 | 801755 | 2020-12-06 | St. Louis | Minnesota | 27137 | 10190 | 134 |
798510 | 798510 | 2020-12-05 | St. Louis | Minnesota | 27137 | 9983 | 131 |
795265 | 795265 | 2020-12-04 | St. Louis | Minnesota | 27137 | 9771 | 126 |
792020 | 792020 | 2020-12-03 | St. Louis | Minnesota | 27137 | 9549 | 121 |
788775 | 788775 | 2020-12-02 | St. Louis | Minnesota | 27137 | 9280 | 117 |
785530 | 785530 | 2020-12-01 | St. Louis | Minnesota | 27137 | 9086 | 112 |
782286 | 782286 | 2020-11-30 | St. Louis | Minnesota | 27137 | 8991 | 112 |
779040 | 779040 | 2020-11-29 | St. Louis | Minnesota | 27137 | 8747 | 112 |
775795 | 775795 | 2020-11-28 | St. Louis | Minnesota | 27137 | 8433 | 108 |
772550 | 772550 | 2020-11-27 | St. Louis | Minnesota | 27137 | 8141 | 108 |
769305 | 769305 | 2020-11-26 | St. Louis | Minnesota | 27137 | 7935 | 101 |
766059 | 766059 | 2020-11-25 | St. Louis | Minnesota | 27137 | 7935 | 101 |
762814 | 762814 | 2020-11-24 | St. Louis | Minnesota | 27137 | 7631 | 97 |
759569 | 759569 | 2020-11-23 | St. Louis | Minnesota | 27137 | 7408 | 97 |
756322 | 756322 | 2020-11-22 | St. Louis | Minnesota | 27137 | 7122 | 97 |
753076 | 753076 | 2020-11-21 | St. Louis | Minnesota | 27137 | 6911 | 94 |
749830 | 749830 | 2020-11-20 | St. Louis | Minnesota | 27137 | 6766 | 90 |
746584 | 746584 | 2020-11-19 | St. Louis | Minnesota | 27137 | 6546 | 87 |
743337 | 743337 | 2020-11-18 | St. Louis | Minnesota | 27137 | 6192 | 85 |
740090 | 740090 | 2020-11-17 | St. Louis | Minnesota | 27137 | 6011 | 84 |
736846 | 736846 | 2020-11-16 | St. Louis | Minnesota | 27137 | 5756 | 84 |
733600 | 733600 | 2020-11-15 | St. Louis | Minnesota | 27137 | 5520 | 84 |
730355 | 730355 | 2020-11-14 | St. Louis | Minnesota | 27137 | 5402 | 83 |
727112 | 727112 | 2020-11-13 | St. Louis | Minnesota | 27137 | 5216 | 82 |
723869 | 723869 | 2020-11-12 | St. Louis | Minnesota | 27137 | 5036 | 79 |
720626 | 720626 | 2020-11-11 | St. Louis | Minnesota | 27137 | 4717 | 77 |
717383 | 717383 | 2020-11-10 | St. Louis | Minnesota | 27137 | 4567 | 77 |
714139 | 714139 | 2020-11-09 | St. Louis | Minnesota | 27137 | 4457 | 77 |
710895 | 710895 | 2020-11-08 | St. Louis | Minnesota | 27137 | 4267 | 77 |
707651 | 707651 | 2020-11-07 | St. Louis | Minnesota | 27137 | 4120 | 77 |
704408 | 704408 | 2020-11-06 | St. Louis | Minnesota | 27137 | 4022 | 77 |
701166 | 701166 | 2020-11-05 | St. Louis | Minnesota | 27137 | 3835 | 76 |
697922 | 697922 | 2020-11-04 | St. Louis | Minnesota | 27137 | 3785 | 76 |
694679 | 694679 | 2020-11-03 | St. Louis | Minnesota | 27137 | 3618 | 75 |
691437 | 691437 | 2020-11-02 | St. Louis | Minnesota | 27137 | 3538 | 75 |
688192 | 688192 | 2020-11-01 | St. Louis | Minnesota | 27137 | 3457 | 75 |
684948 | 684948 | 2020-10-31 | St. Louis | Minnesota | 27137 | 3392 | 75 |
681705 | 681705 | 2020-10-30 | St. Louis | Minnesota | 27137 | 3330 | 74 |
678461 | 678461 | 2020-10-29 | St. Louis | Minnesota | 27137 | 3258 | 74 |
675219 | 675219 | 2020-10-28 | St. Louis | Minnesota | 27137 | 3142 | 71 |
671976 | 671976 | 2020-10-27 | St. Louis | Minnesota | 27137 | 3079 | 70 |
668734 | 668734 | 2020-10-26 | St. Louis | Minnesota | 27137 | 3026 | 69 |
665490 | 665490 | 2020-10-25 | St. Louis | Minnesota | 27137 | 2965 | 69 |
662245 | 662245 | 2020-10-24 | St. Louis | Minnesota | 27137 | 2912 | 67 |
659001 | 659001 | 2020-10-23 | St. Louis | Minnesota | 27137 | 2850 | 65 |
655756 | 655756 | 2020-10-22 | St. Louis | Minnesota | 27137 | 2797 | 65 |
652511 | 652511 | 2020-10-21 | St. Louis | Minnesota | 27137 | 2738 | 65 |
649266 | 649266 | 2020-10-20 | St. Louis | Minnesota | 27137 | 2689 | 63 |
646022 | 646022 | 2020-10-19 | St. Louis | Minnesota | 27137 | 2647 | 63 |
642775 | 642775 | 2020-10-18 | St. Louis | Minnesota | 27137 | 2585 | 63 |
639528 | 639528 | 2020-10-17 | St. Louis | Minnesota | 27137 | 2539 | 62 |
636282 | 636282 | 2020-10-16 | St. Louis | Minnesota | 27137 | 2498 | 61 |
633036 | 633036 | 2020-10-15 | St. Louis | Minnesota | 27137 | 2401 | 56 |
629791 | 629791 | 2020-10-14 | St. Louis | Minnesota | 27137 | 2348 | 55 |
626547 | 626547 | 2020-10-13 | St. Louis | Minnesota | 27137 | 2299 | 55 |
623305 | 623305 | 2020-10-12 | St. Louis | Minnesota | 27137 | 2226 | 55 |
620062 | 620062 | 2020-10-11 | St. Louis | Minnesota | 27137 | 2190 | 55 |
616820 | 616820 | 2020-10-10 | St. Louis | Minnesota | 27137 | 2157 | 55 |
613579 | 613579 | 2020-10-09 | St. Louis | Minnesota | 27137 | 2121 | 53 |
610337 | 610337 | 2020-10-08 | St. Louis | Minnesota | 27137 | 2081 | 52 |
607095 | 607095 | 2020-10-07 | St. Louis | Minnesota | 27137 | 2029 | 52 |
603852 | 603852 | 2020-10-06 | St. Louis | Minnesota | 27137 | 2007 | 49 |
600610 | 600610 | 2020-10-05 | St. Louis | Minnesota | 27137 | 1956 | 49 |
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);