ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27147 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921837 | 921837 | 2021-01-12 | Steele | Minnesota | 27147 | 2646 | 9 |
918592 | 918592 | 2021-01-11 | Steele | Minnesota | 27147 | 2628 | 9 |
915347 | 915347 | 2021-01-10 | Steele | Minnesota | 27147 | 2612 | 9 |
912102 | 912102 | 2021-01-09 | Steele | Minnesota | 27147 | 2605 | 9 |
908857 | 908857 | 2021-01-08 | Steele | Minnesota | 27147 | 2583 | 9 |
905611 | 905611 | 2021-01-07 | Steele | Minnesota | 27147 | 2564 | 9 |
902366 | 902366 | 2021-01-06 | Steele | Minnesota | 27147 | 2553 | 9 |
899121 | 899121 | 2021-01-05 | Steele | Minnesota | 27147 | 2551 | 9 |
895876 | 895876 | 2021-01-04 | Steele | Minnesota | 27147 | 2546 | 9 |
892629 | 892629 | 2021-01-03 | Steele | Minnesota | 27147 | 2535 | 9 |
889383 | 889383 | 2021-01-02 | Steele | Minnesota | 27147 | 2528 | 9 |
886137 | 886137 | 2021-01-01 | Steele | Minnesota | 27147 | 2512 | 9 |
882892 | 882892 | 2020-12-31 | Steele | Minnesota | 27147 | 2512 | 9 |
879647 | 879647 | 2020-12-30 | Steele | Minnesota | 27147 | 2498 | 9 |
876402 | 876402 | 2020-12-29 | Steele | Minnesota | 27147 | 2484 | 9 |
873157 | 873157 | 2020-12-28 | Steele | Minnesota | 27147 | 2478 | 9 |
869912 | 869912 | 2020-12-27 | Steele | Minnesota | 27147 | 2475 | 9 |
866667 | 866667 | 2020-12-26 | Steele | Minnesota | 27147 | 2469 | 9 |
863422 | 863422 | 2020-12-25 | Steele | Minnesota | 27147 | 2453 | 9 |
860177 | 860177 | 2020-12-24 | Steele | Minnesota | 27147 | 2453 | 9 |
856932 | 856932 | 2020-12-23 | Steele | Minnesota | 27147 | 2443 | 9 |
853687 | 853687 | 2020-12-22 | Steele | Minnesota | 27147 | 2431 | 9 |
850442 | 850442 | 2020-12-21 | Steele | Minnesota | 27147 | 2424 | 9 |
847197 | 847197 | 2020-12-20 | Steele | Minnesota | 27147 | 2421 | 9 |
843951 | 843951 | 2020-12-19 | Steele | Minnesota | 27147 | 2412 | 9 |
840706 | 840706 | 2020-12-18 | Steele | Minnesota | 27147 | 2399 | 9 |
837461 | 837461 | 2020-12-17 | Steele | Minnesota | 27147 | 2383 | 9 |
834215 | 834215 | 2020-12-16 | Steele | Minnesota | 27147 | 2371 | 9 |
830968 | 830968 | 2020-12-15 | Steele | Minnesota | 27147 | 2353 | 9 |
827722 | 827722 | 2020-12-14 | Steele | Minnesota | 27147 | 2346 | 9 |
824475 | 824475 | 2020-12-13 | Steele | Minnesota | 27147 | 2341 | 9 |
821229 | 821229 | 2020-12-12 | Steele | Minnesota | 27147 | 2325 | 9 |
817983 | 817983 | 2020-12-11 | Steele | Minnesota | 27147 | 2305 | 9 |
814737 | 814737 | 2020-12-10 | Steele | Minnesota | 27147 | 2283 | 9 |
811492 | 811492 | 2020-12-09 | Steele | Minnesota | 27147 | 2269 | 8 |
808247 | 808247 | 2020-12-08 | Steele | Minnesota | 27147 | 2250 | 8 |
805002 | 805002 | 2020-12-07 | Steele | Minnesota | 27147 | 2230 | 8 |
801757 | 801757 | 2020-12-06 | Steele | Minnesota | 27147 | 2218 | 8 |
798512 | 798512 | 2020-12-05 | Steele | Minnesota | 27147 | 2191 | 8 |
795267 | 795267 | 2020-12-04 | Steele | Minnesota | 27147 | 2147 | 8 |
792022 | 792022 | 2020-12-03 | Steele | Minnesota | 27147 | 2103 | 8 |
788777 | 788777 | 2020-12-02 | Steele | Minnesota | 27147 | 2056 | 8 |
785532 | 785532 | 2020-12-01 | Steele | Minnesota | 27147 | 2022 | 7 |
782288 | 782288 | 2020-11-30 | Steele | Minnesota | 27147 | 1991 | 7 |
779042 | 779042 | 2020-11-29 | Steele | Minnesota | 27147 | 1949 | 7 |
775797 | 775797 | 2020-11-28 | Steele | Minnesota | 27147 | 1913 | 7 |
772552 | 772552 | 2020-11-27 | Steele | Minnesota | 27147 | 1833 | 6 |
769307 | 769307 | 2020-11-26 | Steele | Minnesota | 27147 | 1782 | 6 |
766061 | 766061 | 2020-11-25 | Steele | Minnesota | 27147 | 1782 | 6 |
762816 | 762816 | 2020-11-24 | Steele | Minnesota | 27147 | 1729 | 6 |
759571 | 759571 | 2020-11-23 | Steele | Minnesota | 27147 | 1675 | 6 |
756324 | 756324 | 2020-11-22 | Steele | Minnesota | 27147 | 1639 | 6 |
753078 | 753078 | 2020-11-21 | Steele | Minnesota | 27147 | 1590 | 6 |
749832 | 749832 | 2020-11-20 | Steele | Minnesota | 27147 | 1543 | 6 |
746586 | 746586 | 2020-11-19 | Steele | Minnesota | 27147 | 1482 | 6 |
743339 | 743339 | 2020-11-18 | Steele | Minnesota | 27147 | 1447 | 6 |
740092 | 740092 | 2020-11-17 | Steele | Minnesota | 27147 | 1423 | 5 |
736848 | 736848 | 2020-11-16 | Steele | Minnesota | 27147 | 1392 | 5 |
733602 | 733602 | 2020-11-15 | Steele | Minnesota | 27147 | 1318 | 5 |
730357 | 730357 | 2020-11-14 | Steele | Minnesota | 27147 | 1138 | 5 |
727114 | 727114 | 2020-11-13 | Steele | Minnesota | 27147 | 1074 | 5 |
723871 | 723871 | 2020-11-12 | Steele | Minnesota | 27147 | 1056 | 5 |
720628 | 720628 | 2020-11-11 | Steele | Minnesota | 27147 | 1031 | 5 |
717385 | 717385 | 2020-11-10 | Steele | Minnesota | 27147 | 1025 | 4 |
714141 | 714141 | 2020-11-09 | Steele | Minnesota | 27147 | 1022 | 4 |
710897 | 710897 | 2020-11-08 | Steele | Minnesota | 27147 | 1017 | 4 |
707653 | 707653 | 2020-11-07 | Steele | Minnesota | 27147 | 1004 | 4 |
704410 | 704410 | 2020-11-06 | Steele | Minnesota | 27147 | 955 | 4 |
701168 | 701168 | 2020-11-05 | Steele | Minnesota | 27147 | 917 | 4 |
697924 | 697924 | 2020-11-04 | Steele | Minnesota | 27147 | 897 | 4 |
694681 | 694681 | 2020-11-03 | Steele | Minnesota | 27147 | 874 | 4 |
691439 | 691439 | 2020-11-02 | Steele | Minnesota | 27147 | 857 | 4 |
688194 | 688194 | 2020-11-01 | Steele | Minnesota | 27147 | 845 | 4 |
684950 | 684950 | 2020-10-31 | Steele | Minnesota | 27147 | 839 | 3 |
681707 | 681707 | 2020-10-30 | Steele | Minnesota | 27147 | 817 | 3 |
678463 | 678463 | 2020-10-29 | Steele | Minnesota | 27147 | 801 | 3 |
675221 | 675221 | 2020-10-28 | Steele | Minnesota | 27147 | 787 | 3 |
671978 | 671978 | 2020-10-27 | Steele | Minnesota | 27147 | 782 | 3 |
668736 | 668736 | 2020-10-26 | Steele | Minnesota | 27147 | 761 | 3 |
665492 | 665492 | 2020-10-25 | Steele | Minnesota | 27147 | 759 | 3 |
662247 | 662247 | 2020-10-24 | Steele | Minnesota | 27147 | 756 | 3 |
659003 | 659003 | 2020-10-23 | Steele | Minnesota | 27147 | 741 | 3 |
655758 | 655758 | 2020-10-22 | Steele | Minnesota | 27147 | 734 | 2 |
652513 | 652513 | 2020-10-21 | Steele | Minnesota | 27147 | 733 | 2 |
649268 | 649268 | 2020-10-20 | Steele | Minnesota | 27147 | 724 | 2 |
646024 | 646024 | 2020-10-19 | Steele | Minnesota | 27147 | 721 | 2 |
642777 | 642777 | 2020-10-18 | Steele | Minnesota | 27147 | 716 | 2 |
639530 | 639530 | 2020-10-17 | Steele | Minnesota | 27147 | 712 | 2 |
636284 | 636284 | 2020-10-16 | Steele | Minnesota | 27147 | 692 | 2 |
633038 | 633038 | 2020-10-15 | Steele | Minnesota | 27147 | 670 | 2 |
629793 | 629793 | 2020-10-14 | Steele | Minnesota | 27147 | 668 | 2 |
626549 | 626549 | 2020-10-13 | Steele | Minnesota | 27147 | 659 | 2 |
623307 | 623307 | 2020-10-12 | Steele | Minnesota | 27147 | 657 | 2 |
620064 | 620064 | 2020-10-11 | Steele | Minnesota | 27147 | 648 | 2 |
616822 | 616822 | 2020-10-10 | Steele | Minnesota | 27147 | 635 | 2 |
613581 | 613581 | 2020-10-09 | Steele | Minnesota | 27147 | 619 | 2 |
610339 | 610339 | 2020-10-08 | Steele | Minnesota | 27147 | 614 | 2 |
607097 | 607097 | 2020-10-07 | Steele | Minnesota | 27147 | 607 | 2 |
603854 | 603854 | 2020-10-06 | Steele | Minnesota | 27147 | 602 | 2 |
600612 | 600612 | 2020-10-05 | Steele | Minnesota | 27147 | 592 | 2 |
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);