ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 27013 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921770 | 921770 | 2021-01-12 | Blue Earth | Minnesota | 27013 | 5306 | 32 |
918525 | 918525 | 2021-01-11 | Blue Earth | Minnesota | 27013 | 5274 | 32 |
915280 | 915280 | 2021-01-10 | Blue Earth | Minnesota | 27013 | 5272 | 32 |
912035 | 912035 | 2021-01-09 | Blue Earth | Minnesota | 27013 | 5263 | 32 |
908790 | 908790 | 2021-01-08 | Blue Earth | Minnesota | 27013 | 5226 | 32 |
905544 | 905544 | 2021-01-07 | Blue Earth | Minnesota | 27013 | 5192 | 32 |
902299 | 902299 | 2021-01-06 | Blue Earth | Minnesota | 27013 | 5171 | 29 |
899054 | 899054 | 2021-01-05 | Blue Earth | Minnesota | 27013 | 5153 | 30 |
895809 | 895809 | 2021-01-04 | Blue Earth | Minnesota | 27013 | 5135 | 30 |
892562 | 892562 | 2021-01-03 | Blue Earth | Minnesota | 27013 | 5091 | 30 |
889316 | 889316 | 2021-01-02 | Blue Earth | Minnesota | 27013 | 5072 | 28 |
886070 | 886070 | 2021-01-01 | Blue Earth | Minnesota | 27013 | 5040 | 28 |
882825 | 882825 | 2020-12-31 | Blue Earth | Minnesota | 27013 | 5040 | 28 |
879580 | 879580 | 2020-12-30 | Blue Earth | Minnesota | 27013 | 5026 | 28 |
876335 | 876335 | 2020-12-29 | Blue Earth | Minnesota | 27013 | 4994 | 28 |
873090 | 873090 | 2020-12-28 | Blue Earth | Minnesota | 27013 | 4975 | 28 |
869845 | 869845 | 2020-12-27 | Blue Earth | Minnesota | 27013 | 4967 | 28 |
866600 | 866600 | 2020-12-26 | Blue Earth | Minnesota | 27013 | 4941 | 28 |
863355 | 863355 | 2020-12-25 | Blue Earth | Minnesota | 27013 | 4910 | 27 |
860110 | 860110 | 2020-12-24 | Blue Earth | Minnesota | 27013 | 4910 | 27 |
856865 | 856865 | 2020-12-23 | Blue Earth | Minnesota | 27013 | 4879 | 27 |
853620 | 853620 | 2020-12-22 | Blue Earth | Minnesota | 27013 | 4867 | 26 |
850375 | 850375 | 2020-12-21 | Blue Earth | Minnesota | 27013 | 4850 | 25 |
847130 | 847130 | 2020-12-20 | Blue Earth | Minnesota | 27013 | 4831 | 24 |
843884 | 843884 | 2020-12-19 | Blue Earth | Minnesota | 27013 | 4817 | 23 |
840639 | 840639 | 2020-12-18 | Blue Earth | Minnesota | 27013 | 4793 | 22 |
837394 | 837394 | 2020-12-17 | Blue Earth | Minnesota | 27013 | 4765 | 22 |
834148 | 834148 | 2020-12-16 | Blue Earth | Minnesota | 27013 | 4746 | 22 |
830901 | 830901 | 2020-12-15 | Blue Earth | Minnesota | 27013 | 4732 | 22 |
827655 | 827655 | 2020-12-14 | Blue Earth | Minnesota | 27013 | 4710 | 22 |
824408 | 824408 | 2020-12-13 | Blue Earth | Minnesota | 27013 | 4696 | 22 |
821162 | 821162 | 2020-12-12 | Blue Earth | Minnesota | 27013 | 4655 | 22 |
817916 | 817916 | 2020-12-11 | Blue Earth | Minnesota | 27013 | 4609 | 22 |
814670 | 814670 | 2020-12-10 | Blue Earth | Minnesota | 27013 | 4590 | 19 |
811425 | 811425 | 2020-12-09 | Blue Earth | Minnesota | 27013 | 4558 | 18 |
808180 | 808180 | 2020-12-08 | Blue Earth | Minnesota | 27013 | 4508 | 17 |
804935 | 804935 | 2020-12-07 | Blue Earth | Minnesota | 27013 | 4479 | 17 |
801690 | 801690 | 2020-12-06 | Blue Earth | Minnesota | 27013 | 4452 | 17 |
798445 | 798445 | 2020-12-05 | Blue Earth | Minnesota | 27013 | 4415 | 17 |
795200 | 795200 | 2020-12-04 | Blue Earth | Minnesota | 27013 | 4362 | 17 |
791955 | 791955 | 2020-12-03 | Blue Earth | Minnesota | 27013 | 4312 | 17 |
788710 | 788710 | 2020-12-02 | Blue Earth | Minnesota | 27013 | 4266 | 17 |
785465 | 785465 | 2020-12-01 | Blue Earth | Minnesota | 27013 | 4213 | 16 |
782221 | 782221 | 2020-11-30 | Blue Earth | Minnesota | 27013 | 4180 | 16 |
778975 | 778975 | 2020-11-29 | Blue Earth | Minnesota | 27013 | 4141 | 16 |
775730 | 775730 | 2020-11-28 | Blue Earth | Minnesota | 27013 | 4052 | 14 |
772485 | 772485 | 2020-11-27 | Blue Earth | Minnesota | 27013 | 3958 | 13 |
769240 | 769240 | 2020-11-26 | Blue Earth | Minnesota | 27013 | 3871 | 12 |
765994 | 765994 | 2020-11-25 | Blue Earth | Minnesota | 27013 | 3871 | 12 |
762749 | 762749 | 2020-11-24 | Blue Earth | Minnesota | 27013 | 3795 | 11 |
759504 | 759504 | 2020-11-23 | Blue Earth | Minnesota | 27013 | 3735 | 11 |
756257 | 756257 | 2020-11-22 | Blue Earth | Minnesota | 27013 | 3670 | 11 |
753011 | 753011 | 2020-11-21 | Blue Earth | Minnesota | 27013 | 3599 | 11 |
749765 | 749765 | 2020-11-20 | Blue Earth | Minnesota | 27013 | 3525 | 11 |
746519 | 746519 | 2020-11-19 | Blue Earth | Minnesota | 27013 | 3436 | 12 |
743272 | 743272 | 2020-11-18 | Blue Earth | Minnesota | 27013 | 3304 | 12 |
740025 | 740025 | 2020-11-17 | Blue Earth | Minnesota | 27013 | 3270 | 11 |
736781 | 736781 | 2020-11-16 | Blue Earth | Minnesota | 27013 | 3213 | 10 |
733535 | 733535 | 2020-11-15 | Blue Earth | Minnesota | 27013 | 3097 | 10 |
730290 | 730290 | 2020-11-14 | Blue Earth | Minnesota | 27013 | 2890 | 10 |
727047 | 727047 | 2020-11-13 | Blue Earth | Minnesota | 27013 | 2781 | 8 |
723804 | 723804 | 2020-11-12 | Blue Earth | Minnesota | 27013 | 2751 | 8 |
720561 | 720561 | 2020-11-11 | Blue Earth | Minnesota | 27013 | 2678 | 8 |
717318 | 717318 | 2020-11-10 | Blue Earth | Minnesota | 27013 | 2630 | 8 |
714074 | 714074 | 2020-11-09 | Blue Earth | Minnesota | 27013 | 2582 | 7 |
710830 | 710830 | 2020-11-08 | Blue Earth | Minnesota | 27013 | 2535 | 7 |
707586 | 707586 | 2020-11-07 | Blue Earth | Minnesota | 27013 | 2484 | 7 |
704343 | 704343 | 2020-11-06 | Blue Earth | Minnesota | 27013 | 2392 | 7 |
701101 | 701101 | 2020-11-05 | Blue Earth | Minnesota | 27013 | 2335 | 7 |
697857 | 697857 | 2020-11-04 | Blue Earth | Minnesota | 27013 | 2310 | 7 |
694614 | 694614 | 2020-11-03 | Blue Earth | Minnesota | 27013 | 2254 | 7 |
691372 | 691372 | 2020-11-02 | Blue Earth | Minnesota | 27013 | 2219 | 7 |
688127 | 688127 | 2020-11-01 | Blue Earth | Minnesota | 27013 | 2207 | 7 |
684883 | 684883 | 2020-10-31 | Blue Earth | Minnesota | 27013 | 2169 | 7 |
681640 | 681640 | 2020-10-30 | Blue Earth | Minnesota | 27013 | 2136 | 7 |
678396 | 678396 | 2020-10-29 | Blue Earth | Minnesota | 27013 | 2114 | 7 |
675154 | 675154 | 2020-10-28 | Blue Earth | Minnesota | 27013 | 2085 | 7 |
671911 | 671911 | 2020-10-27 | Blue Earth | Minnesota | 27013 | 2066 | 7 |
668669 | 668669 | 2020-10-26 | Blue Earth | Minnesota | 27013 | 2045 | 7 |
665425 | 665425 | 2020-10-25 | Blue Earth | Minnesota | 27013 | 2043 | 7 |
662180 | 662180 | 2020-10-24 | Blue Earth | Minnesota | 27013 | 2036 | 7 |
658936 | 658936 | 2020-10-23 | Blue Earth | Minnesota | 27013 | 2020 | 7 |
655691 | 655691 | 2020-10-22 | Blue Earth | Minnesota | 27013 | 2003 | 7 |
652446 | 652446 | 2020-10-21 | Blue Earth | Minnesota | 27013 | 1979 | 7 |
649201 | 649201 | 2020-10-20 | Blue Earth | Minnesota | 27013 | 1971 | 7 |
645957 | 645957 | 2020-10-19 | Blue Earth | Minnesota | 27013 | 1970 | 7 |
642710 | 642710 | 2020-10-18 | Blue Earth | Minnesota | 27013 | 1958 | 7 |
639463 | 639463 | 2020-10-17 | Blue Earth | Minnesota | 27013 | 1948 | 7 |
636217 | 636217 | 2020-10-16 | Blue Earth | Minnesota | 27013 | 1933 | 7 |
632971 | 632971 | 2020-10-15 | Blue Earth | Minnesota | 27013 | 1890 | 7 |
629726 | 629726 | 2020-10-14 | Blue Earth | Minnesota | 27013 | 1886 | 7 |
626482 | 626482 | 2020-10-13 | Blue Earth | Minnesota | 27013 | 1880 | 7 |
623240 | 623240 | 2020-10-12 | Blue Earth | Minnesota | 27013 | 1876 | 7 |
619997 | 619997 | 2020-10-11 | Blue Earth | Minnesota | 27013 | 1875 | 7 |
616755 | 616755 | 2020-10-10 | Blue Earth | Minnesota | 27013 | 1868 | 7 |
613514 | 613514 | 2020-10-09 | Blue Earth | Minnesota | 27013 | 1855 | 7 |
610272 | 610272 | 2020-10-08 | Blue Earth | Minnesota | 27013 | 1846 | 7 |
607030 | 607030 | 2020-10-07 | Blue Earth | Minnesota | 27013 | 1833 | 7 |
603787 | 603787 | 2020-10-06 | Blue Earth | Minnesota | 27013 | 1823 | 7 |
600545 | 600545 | 2020-10-05 | Blue Earth | Minnesota | 27013 | 1811 | 7 |
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);