ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Dakota" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921782 | 921782 | 2021-01-12 | Dakota | Minnesota | 27037 | 32330 | 310 |
918537 | 918537 | 2021-01-11 | Dakota | Minnesota | 27037 | 32250 | 309 |
915292 | 915292 | 2021-01-10 | Dakota | Minnesota | 27037 | 32154 | 308 |
912047 | 912047 | 2021-01-09 | Dakota | Minnesota | 27037 | 31965 | 298 |
908802 | 908802 | 2021-01-08 | Dakota | Minnesota | 27037 | 31771 | 296 |
905556 | 905556 | 2021-01-07 | Dakota | Minnesota | 27037 | 31538 | 291 |
902311 | 902311 | 2021-01-06 | Dakota | Minnesota | 27037 | 31358 | 288 |
899066 | 899066 | 2021-01-05 | Dakota | Minnesota | 27037 | 31134 | 285 |
895821 | 895821 | 2021-01-04 | Dakota | Minnesota | 27037 | 31018 | 284 |
892574 | 892574 | 2021-01-03 | Dakota | Minnesota | 27037 | 30764 | 281 |
889328 | 889328 | 2021-01-02 | Dakota | Minnesota | 27037 | 30490 | 279 |
886082 | 886082 | 2021-01-01 | Dakota | Minnesota | 27037 | 30280 | 277 |
882837 | 882837 | 2020-12-31 | Dakota | Minnesota | 27037 | 30280 | 277 |
879592 | 879592 | 2020-12-30 | Dakota | Minnesota | 27037 | 30071 | 275 |
876347 | 876347 | 2020-12-29 | Dakota | Minnesota | 27037 | 29890 | 272 |
873102 | 873102 | 2020-12-28 | Dakota | Minnesota | 27037 | 29820 | 271 |
869857 | 869857 | 2020-12-27 | Dakota | Minnesota | 27037 | 29727 | 269 |
866612 | 866612 | 2020-12-26 | Dakota | Minnesota | 27037 | 29528 | 266 |
863367 | 863367 | 2020-12-25 | Dakota | Minnesota | 27037 | 29355 | 262 |
860122 | 860122 | 2020-12-24 | Dakota | Minnesota | 27037 | 29355 | 262 |
856877 | 856877 | 2020-12-23 | Dakota | Minnesota | 27037 | 29170 | 261 |
853632 | 853632 | 2020-12-22 | Dakota | Minnesota | 27037 | 29019 | 256 |
850387 | 850387 | 2020-12-21 | Dakota | Minnesota | 27037 | 28846 | 255 |
847142 | 847142 | 2020-12-20 | Dakota | Minnesota | 27037 | 28677 | 255 |
843896 | 843896 | 2020-12-19 | Dakota | Minnesota | 27037 | 28481 | 250 |
840651 | 840651 | 2020-12-18 | Dakota | Minnesota | 27037 | 28246 | 246 |
837406 | 837406 | 2020-12-17 | Dakota | Minnesota | 27037 | 28025 | 245 |
834160 | 834160 | 2020-12-16 | Dakota | Minnesota | 27037 | 27798 | 241 |
830913 | 830913 | 2020-12-15 | Dakota | Minnesota | 27037 | 27615 | 237 |
827667 | 827667 | 2020-12-14 | Dakota | Minnesota | 27037 | 27388 | 236 |
824420 | 824420 | 2020-12-13 | Dakota | Minnesota | 27037 | 27132 | 234 |
821174 | 821174 | 2020-12-12 | Dakota | Minnesota | 27037 | 26857 | 231 |
817928 | 817928 | 2020-12-11 | Dakota | Minnesota | 27037 | 26493 | 228 |
814682 | 814682 | 2020-12-10 | Dakota | Minnesota | 27037 | 26208 | 224 |
811437 | 811437 | 2020-12-09 | Dakota | Minnesota | 27037 | 25988 | 220 |
808192 | 808192 | 2020-12-08 | Dakota | Minnesota | 27037 | 25545 | 218 |
804947 | 804947 | 2020-12-07 | Dakota | Minnesota | 27037 | 25282 | 217 |
801702 | 801702 | 2020-12-06 | Dakota | Minnesota | 27037 | 24846 | 213 |
798457 | 798457 | 2020-12-05 | Dakota | Minnesota | 27037 | 24425 | 208 |
795212 | 795212 | 2020-12-04 | Dakota | Minnesota | 27037 | 23961 | 202 |
791967 | 791967 | 2020-12-03 | Dakota | Minnesota | 27037 | 23564 | 198 |
788722 | 788722 | 2020-12-02 | Dakota | Minnesota | 27037 | 23102 | 194 |
785477 | 785477 | 2020-12-01 | Dakota | Minnesota | 27037 | 22657 | 192 |
782233 | 782233 | 2020-11-30 | Dakota | Minnesota | 27037 | 22414 | 190 |
778987 | 778987 | 2020-11-29 | Dakota | Minnesota | 27037 | 22015 | 190 |
775742 | 775742 | 2020-11-28 | Dakota | Minnesota | 27037 | 21268 | 190 |
772497 | 772497 | 2020-11-27 | Dakota | Minnesota | 27037 | 20527 | 189 |
769252 | 769252 | 2020-11-26 | Dakota | Minnesota | 27037 | 20096 | 183 |
766006 | 766006 | 2020-11-25 | Dakota | Minnesota | 27037 | 20096 | 183 |
762761 | 762761 | 2020-11-24 | Dakota | Minnesota | 27037 | 19573 | 179 |
759516 | 759516 | 2020-11-23 | Dakota | Minnesota | 27037 | 19215 | 176 |
756269 | 756269 | 2020-11-22 | Dakota | Minnesota | 27037 | 18738 | 176 |
753023 | 753023 | 2020-11-21 | Dakota | Minnesota | 27037 | 18228 | 174 |
749777 | 749777 | 2020-11-20 | Dakota | Minnesota | 27037 | 17787 | 172 |
746531 | 746531 | 2020-11-19 | Dakota | Minnesota | 27037 | 17340 | 170 |
743284 | 743284 | 2020-11-18 | Dakota | Minnesota | 27037 | 16897 | 165 |
740037 | 740037 | 2020-11-17 | Dakota | Minnesota | 27037 | 16469 | 160 |
736793 | 736793 | 2020-11-16 | Dakota | Minnesota | 27037 | 16073 | 159 |
733547 | 733547 | 2020-11-15 | Dakota | Minnesota | 27037 | 15556 | 159 |
730302 | 730302 | 2020-11-14 | Dakota | Minnesota | 27037 | 15081 | 158 |
727059 | 727059 | 2020-11-13 | Dakota | Minnesota | 27037 | 14491 | 157 |
723816 | 723816 | 2020-11-12 | Dakota | Minnesota | 27037 | 14114 | 156 |
720573 | 720573 | 2020-11-11 | Dakota | Minnesota | 27037 | 13634 | 152 |
717330 | 717330 | 2020-11-10 | Dakota | Minnesota | 27037 | 13322 | 150 |
714086 | 714086 | 2020-11-09 | Dakota | Minnesota | 27037 | 12946 | 148 |
710842 | 710842 | 2020-11-08 | Dakota | Minnesota | 27037 | 12661 | 147 |
707598 | 707598 | 2020-11-07 | Dakota | Minnesota | 27037 | 12213 | 146 |
704355 | 704355 | 2020-11-06 | Dakota | Minnesota | 27037 | 11938 | 144 |
701113 | 701113 | 2020-11-05 | Dakota | Minnesota | 27037 | 11664 | 142 |
697869 | 697869 | 2020-11-04 | Dakota | Minnesota | 27037 | 11435 | 141 |
694626 | 694626 | 2020-11-03 | Dakota | Minnesota | 27037 | 11184 | 141 |
691384 | 691384 | 2020-11-02 | Dakota | Minnesota | 27037 | 10933 | 139 |
688139 | 688139 | 2020-11-01 | Dakota | Minnesota | 27037 | 10733 | 139 |
684895 | 684895 | 2020-10-31 | Dakota | Minnesota | 27037 | 10589 | 139 |
681652 | 681652 | 2020-10-30 | Dakota | Minnesota | 27037 | 10420 | 139 |
678408 | 678408 | 2020-10-29 | Dakota | Minnesota | 27037 | 10271 | 139 |
675166 | 675166 | 2020-10-28 | Dakota | Minnesota | 27037 | 10132 | 138 |
671923 | 671923 | 2020-10-27 | Dakota | Minnesota | 27037 | 10027 | 138 |
668681 | 668681 | 2020-10-26 | Dakota | Minnesota | 27037 | 9897 | 138 |
665437 | 665437 | 2020-10-25 | Dakota | Minnesota | 27037 | 9823 | 138 |
662192 | 662192 | 2020-10-24 | Dakota | Minnesota | 27037 | 9686 | 137 |
658948 | 658948 | 2020-10-23 | Dakota | Minnesota | 27037 | 9541 | 137 |
655703 | 655703 | 2020-10-22 | Dakota | Minnesota | 27037 | 9467 | 136 |
652458 | 652458 | 2020-10-21 | Dakota | Minnesota | 27037 | 9389 | 136 |
649213 | 649213 | 2020-10-20 | Dakota | Minnesota | 27037 | 9321 | 134 |
645969 | 645969 | 2020-10-19 | Dakota | Minnesota | 27037 | 9251 | 133 |
642722 | 642722 | 2020-10-18 | Dakota | Minnesota | 27037 | 9146 | 133 |
639475 | 639475 | 2020-10-17 | Dakota | Minnesota | 27037 | 9030 | 133 |
636229 | 636229 | 2020-10-16 | Dakota | Minnesota | 27037 | 8930 | 133 |
632983 | 632983 | 2020-10-15 | Dakota | Minnesota | 27037 | 8814 | 133 |
629738 | 629738 | 2020-10-14 | Dakota | Minnesota | 27037 | 8742 | 133 |
626494 | 626494 | 2020-10-13 | Dakota | Minnesota | 27037 | 8673 | 132 |
623252 | 623252 | 2020-10-12 | Dakota | Minnesota | 27037 | 8576 | 132 |
620009 | 620009 | 2020-10-11 | Dakota | Minnesota | 27037 | 8493 | 132 |
616767 | 616767 | 2020-10-10 | Dakota | Minnesota | 27037 | 8400 | 130 |
613526 | 613526 | 2020-10-09 | Dakota | Minnesota | 27037 | 8295 | 130 |
610284 | 610284 | 2020-10-08 | Dakota | Minnesota | 27037 | 8200 | 130 |
607042 | 607042 | 2020-10-07 | Dakota | Minnesota | 27037 | 8140 | 130 |
603799 | 603799 | 2020-10-06 | Dakota | Minnesota | 27037 | 8099 | 130 |
600557 | 600557 | 2020-10-05 | Dakota | Minnesota | 27037 | 8034 | 130 |
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);