ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where county = "Pennington" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921820 | 921820 | 2021-01-12 | Pennington | Minnesota | 27113 | 939 | 15 |
918575 | 918575 | 2021-01-11 | Pennington | Minnesota | 27113 | 932 | 15 |
915330 | 915330 | 2021-01-10 | Pennington | Minnesota | 27113 | 927 | 15 |
912085 | 912085 | 2021-01-09 | Pennington | Minnesota | 27113 | 923 | 15 |
908840 | 908840 | 2021-01-08 | Pennington | Minnesota | 27113 | 921 | 14 |
905594 | 905594 | 2021-01-07 | Pennington | Minnesota | 27113 | 919 | 14 |
902349 | 902349 | 2021-01-06 | Pennington | Minnesota | 27113 | 915 | 14 |
899104 | 899104 | 2021-01-05 | Pennington | Minnesota | 27113 | 914 | 14 |
895859 | 895859 | 2021-01-04 | Pennington | Minnesota | 27113 | 911 | 14 |
892612 | 892612 | 2021-01-03 | Pennington | Minnesota | 27113 | 908 | 14 |
889366 | 889366 | 2021-01-02 | Pennington | Minnesota | 27113 | 906 | 14 |
886120 | 886120 | 2021-01-01 | Pennington | Minnesota | 27113 | 905 | 14 |
882875 | 882875 | 2020-12-31 | Pennington | Minnesota | 27113 | 905 | 14 |
879630 | 879630 | 2020-12-30 | Pennington | Minnesota | 27113 | 900 | 14 |
876385 | 876385 | 2020-12-29 | Pennington | Minnesota | 27113 | 895 | 14 |
873140 | 873140 | 2020-12-28 | Pennington | Minnesota | 27113 | 882 | 14 |
869895 | 869895 | 2020-12-27 | Pennington | Minnesota | 27113 | 882 | 14 |
866650 | 866650 | 2020-12-26 | Pennington | Minnesota | 27113 | 878 | 14 |
863405 | 863405 | 2020-12-25 | Pennington | Minnesota | 27113 | 875 | 14 |
860160 | 860160 | 2020-12-24 | Pennington | Minnesota | 27113 | 875 | 14 |
856915 | 856915 | 2020-12-23 | Pennington | Minnesota | 27113 | 873 | 13 |
853670 | 853670 | 2020-12-22 | Pennington | Minnesota | 27113 | 871 | 12 |
850425 | 850425 | 2020-12-21 | Pennington | Minnesota | 27113 | 867 | 12 |
847180 | 847180 | 2020-12-20 | Pennington | Minnesota | 27113 | 865 | 12 |
843934 | 843934 | 2020-12-19 | Pennington | Minnesota | 27113 | 865 | 12 |
840689 | 840689 | 2020-12-18 | Pennington | Minnesota | 27113 | 863 | 12 |
837444 | 837444 | 2020-12-17 | Pennington | Minnesota | 27113 | 847 | 12 |
834198 | 834198 | 2020-12-16 | Pennington | Minnesota | 27113 | 848 | 11 |
830951 | 830951 | 2020-12-15 | Pennington | Minnesota | 27113 | 842 | 10 |
827705 | 827705 | 2020-12-14 | Pennington | Minnesota | 27113 | 832 | 10 |
824458 | 824458 | 2020-12-13 | Pennington | Minnesota | 27113 | 830 | 10 |
821212 | 821212 | 2020-12-12 | Pennington | Minnesota | 27113 | 823 | 9 |
817966 | 817966 | 2020-12-11 | Pennington | Minnesota | 27113 | 819 | 9 |
814720 | 814720 | 2020-12-10 | Pennington | Minnesota | 27113 | 811 | 9 |
811475 | 811475 | 2020-12-09 | Pennington | Minnesota | 27113 | 799 | 9 |
808230 | 808230 | 2020-12-08 | Pennington | Minnesota | 27113 | 800 | 9 |
804985 | 804985 | 2020-12-07 | Pennington | Minnesota | 27113 | 793 | 9 |
801740 | 801740 | 2020-12-06 | Pennington | Minnesota | 27113 | 782 | 9 |
798495 | 798495 | 2020-12-05 | Pennington | Minnesota | 27113 | 765 | 9 |
795250 | 795250 | 2020-12-04 | Pennington | Minnesota | 27113 | 733 | 9 |
792005 | 792005 | 2020-12-03 | Pennington | Minnesota | 27113 | 705 | 8 |
788760 | 788760 | 2020-12-02 | Pennington | Minnesota | 27113 | 675 | 8 |
785515 | 785515 | 2020-12-01 | Pennington | Minnesota | 27113 | 669 | 8 |
782271 | 782271 | 2020-11-30 | Pennington | Minnesota | 27113 | 663 | 8 |
779025 | 779025 | 2020-11-29 | Pennington | Minnesota | 27113 | 647 | 8 |
775780 | 775780 | 2020-11-28 | Pennington | Minnesota | 27113 | 627 | 7 |
772535 | 772535 | 2020-11-27 | Pennington | Minnesota | 27113 | 613 | 7 |
769290 | 769290 | 2020-11-26 | Pennington | Minnesota | 27113 | 585 | 6 |
766044 | 766044 | 2020-11-25 | Pennington | Minnesota | 27113 | 585 | 6 |
762799 | 762799 | 2020-11-24 | Pennington | Minnesota | 27113 | 557 | 6 |
759554 | 759554 | 2020-11-23 | Pennington | Minnesota | 27113 | 535 | 6 |
756307 | 756307 | 2020-11-22 | Pennington | Minnesota | 27113 | 507 | 6 |
753061 | 753061 | 2020-11-21 | Pennington | Minnesota | 27113 | 480 | 6 |
749815 | 749815 | 2020-11-20 | Pennington | Minnesota | 27113 | 466 | 4 |
746569 | 746569 | 2020-11-19 | Pennington | Minnesota | 27113 | 451 | 4 |
743322 | 743322 | 2020-11-18 | Pennington | Minnesota | 27113 | 439 | 4 |
740075 | 740075 | 2020-11-17 | Pennington | Minnesota | 27113 | 427 | 4 |
736831 | 736831 | 2020-11-16 | Pennington | Minnesota | 27113 | 411 | 4 |
733585 | 733585 | 2020-11-15 | Pennington | Minnesota | 27113 | 388 | 4 |
730340 | 730340 | 2020-11-14 | Pennington | Minnesota | 27113 | 375 | 3 |
727097 | 727097 | 2020-11-13 | Pennington | Minnesota | 27113 | 358 | 2 |
723854 | 723854 | 2020-11-12 | Pennington | Minnesota | 27113 | 331 | 2 |
720611 | 720611 | 2020-11-11 | Pennington | Minnesota | 27113 | 312 | 2 |
717368 | 717368 | 2020-11-10 | Pennington | Minnesota | 27113 | 296 | 2 |
714124 | 714124 | 2020-11-09 | Pennington | Minnesota | 27113 | 288 | 2 |
710880 | 710880 | 2020-11-08 | Pennington | Minnesota | 27113 | 278 | 2 |
707636 | 707636 | 2020-11-07 | Pennington | Minnesota | 27113 | 269 | 2 |
704393 | 704393 | 2020-11-06 | Pennington | Minnesota | 27113 | 261 | 2 |
701151 | 701151 | 2020-11-05 | Pennington | Minnesota | 27113 | 254 | 2 |
697907 | 697907 | 2020-11-04 | Pennington | Minnesota | 27113 | 246 | 2 |
694664 | 694664 | 2020-11-03 | Pennington | Minnesota | 27113 | 240 | 2 |
691422 | 691422 | 2020-11-02 | Pennington | Minnesota | 27113 | 238 | 2 |
688177 | 688177 | 2020-11-01 | Pennington | Minnesota | 27113 | 235 | 2 |
684933 | 684933 | 2020-10-31 | Pennington | Minnesota | 27113 | 227 | 1 |
681690 | 681690 | 2020-10-30 | Pennington | Minnesota | 27113 | 222 | 1 |
678446 | 678446 | 2020-10-29 | Pennington | Minnesota | 27113 | 218 | 1 |
675204 | 675204 | 2020-10-28 | Pennington | Minnesota | 27113 | 209 | 1 |
671961 | 671961 | 2020-10-27 | Pennington | Minnesota | 27113 | 207 | 1 |
668719 | 668719 | 2020-10-26 | Pennington | Minnesota | 27113 | 195 | 1 |
665475 | 665475 | 2020-10-25 | Pennington | Minnesota | 27113 | 191 | 1 |
662230 | 662230 | 2020-10-24 | Pennington | Minnesota | 27113 | 185 | 1 |
658986 | 658986 | 2020-10-23 | Pennington | Minnesota | 27113 | 174 | 1 |
655741 | 655741 | 2020-10-22 | Pennington | Minnesota | 27113 | 171 | 1 |
652496 | 652496 | 2020-10-21 | Pennington | Minnesota | 27113 | 170 | 1 |
649251 | 649251 | 2020-10-20 | Pennington | Minnesota | 27113 | 165 | 1 |
646007 | 646007 | 2020-10-19 | Pennington | Minnesota | 27113 | 163 | 1 |
642760 | 642760 | 2020-10-18 | Pennington | Minnesota | 27113 | 162 | 1 |
639513 | 639513 | 2020-10-17 | Pennington | Minnesota | 27113 | 157 | 1 |
636267 | 636267 | 2020-10-16 | Pennington | Minnesota | 27113 | 153 | 1 |
633021 | 633021 | 2020-10-15 | Pennington | Minnesota | 27113 | 151 | 1 |
629776 | 629776 | 2020-10-14 | Pennington | Minnesota | 27113 | 150 | 1 |
626532 | 626532 | 2020-10-13 | Pennington | Minnesota | 27113 | 145 | 1 |
623290 | 623290 | 2020-10-12 | Pennington | Minnesota | 27113 | 145 | 1 |
620047 | 620047 | 2020-10-11 | Pennington | Minnesota | 27113 | 144 | 1 |
616805 | 616805 | 2020-10-10 | Pennington | Minnesota | 27113 | 142 | 1 |
613564 | 613564 | 2020-10-09 | Pennington | Minnesota | 27113 | 140 | 1 |
610322 | 610322 | 2020-10-08 | Pennington | Minnesota | 27113 | 140 | 1 |
607080 | 607080 | 2020-10-07 | Pennington | Minnesota | 27113 | 138 | 1 |
603837 | 603837 | 2020-10-06 | Pennington | Minnesota | 27113 | 136 | 1 |
600595 | 600595 | 2020-10-05 | Pennington | Minnesota | 27113 | 136 | 1 |
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);