ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 27109 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921818 | 921818 | 2021-01-12 | Olmsted | Minnesota | 27109 | 10089 | 68 |
918573 | 918573 | 2021-01-11 | Olmsted | Minnesota | 27109 | 10015 | 68 |
915328 | 915328 | 2021-01-10 | Olmsted | Minnesota | 27109 | 10004 | 68 |
912083 | 912083 | 2021-01-09 | Olmsted | Minnesota | 27109 | 9978 | 66 |
908838 | 908838 | 2021-01-08 | Olmsted | Minnesota | 27109 | 9905 | 65 |
905592 | 905592 | 2021-01-07 | Olmsted | Minnesota | 27109 | 9854 | 65 |
902347 | 902347 | 2021-01-06 | Olmsted | Minnesota | 27109 | 9781 | 65 |
899102 | 899102 | 2021-01-05 | Olmsted | Minnesota | 27109 | 9651 | 64 |
895857 | 895857 | 2021-01-04 | Olmsted | Minnesota | 27109 | 9587 | 64 |
892610 | 892610 | 2021-01-03 | Olmsted | Minnesota | 27109 | 9455 | 64 |
889364 | 889364 | 2021-01-02 | Olmsted | Minnesota | 27109 | 9419 | 62 |
886118 | 886118 | 2021-01-01 | Olmsted | Minnesota | 27109 | 9309 | 61 |
882873 | 882873 | 2020-12-31 | Olmsted | Minnesota | 27109 | 9309 | 61 |
879628 | 879628 | 2020-12-30 | Olmsted | Minnesota | 27109 | 9205 | 59 |
876383 | 876383 | 2020-12-29 | Olmsted | Minnesota | 27109 | 9084 | 58 |
873138 | 873138 | 2020-12-28 | Olmsted | Minnesota | 27109 | 9030 | 57 |
869893 | 869893 | 2020-12-27 | Olmsted | Minnesota | 27109 | 8975 | 57 |
866648 | 866648 | 2020-12-26 | Olmsted | Minnesota | 27109 | 8904 | 56 |
863403 | 863403 | 2020-12-25 | Olmsted | Minnesota | 27109 | 8837 | 54 |
860158 | 860158 | 2020-12-24 | Olmsted | Minnesota | 27109 | 8837 | 54 |
856913 | 856913 | 2020-12-23 | Olmsted | Minnesota | 27109 | 8786 | 52 |
853668 | 853668 | 2020-12-22 | Olmsted | Minnesota | 27109 | 8737 | 50 |
850423 | 850423 | 2020-12-21 | Olmsted | Minnesota | 27109 | 8692 | 49 |
847178 | 847178 | 2020-12-20 | Olmsted | Minnesota | 27109 | 8619 | 49 |
843932 | 843932 | 2020-12-19 | Olmsted | Minnesota | 27109 | 8537 | 48 |
840687 | 840687 | 2020-12-18 | Olmsted | Minnesota | 27109 | 8423 | 47 |
837442 | 837442 | 2020-12-17 | Olmsted | Minnesota | 27109 | 8359 | 46 |
834196 | 834196 | 2020-12-16 | Olmsted | Minnesota | 27109 | 8278 | 46 |
830949 | 830949 | 2020-12-15 | Olmsted | Minnesota | 27109 | 8209 | 46 |
827703 | 827703 | 2020-12-14 | Olmsted | Minnesota | 27109 | 8159 | 46 |
824456 | 824456 | 2020-12-13 | Olmsted | Minnesota | 27109 | 8082 | 46 |
821210 | 821210 | 2020-12-12 | Olmsted | Minnesota | 27109 | 7973 | 45 |
817964 | 817964 | 2020-12-11 | Olmsted | Minnesota | 27109 | 7888 | 42 |
814718 | 814718 | 2020-12-10 | Olmsted | Minnesota | 27109 | 7799 | 41 |
811473 | 811473 | 2020-12-09 | Olmsted | Minnesota | 27109 | 7714 | 39 |
808228 | 808228 | 2020-12-08 | Olmsted | Minnesota | 27109 | 7608 | 38 |
804983 | 804983 | 2020-12-07 | Olmsted | Minnesota | 27109 | 7547 | 38 |
801738 | 801738 | 2020-12-06 | Olmsted | Minnesota | 27109 | 7469 | 38 |
798493 | 798493 | 2020-12-05 | Olmsted | Minnesota | 27109 | 7340 | 37 |
795248 | 795248 | 2020-12-04 | Olmsted | Minnesota | 27109 | 7232 | 37 |
792003 | 792003 | 2020-12-03 | Olmsted | Minnesota | 27109 | 7146 | 37 |
788758 | 788758 | 2020-12-02 | Olmsted | Minnesota | 27109 | 7025 | 36 |
785513 | 785513 | 2020-12-01 | Olmsted | Minnesota | 27109 | 6905 | 34 |
782269 | 782269 | 2020-11-30 | Olmsted | Minnesota | 27109 | 6811 | 34 |
779023 | 779023 | 2020-11-29 | Olmsted | Minnesota | 27109 | 6656 | 34 |
775778 | 775778 | 2020-11-28 | Olmsted | Minnesota | 27109 | 6535 | 34 |
772533 | 772533 | 2020-11-27 | Olmsted | Minnesota | 27109 | 6399 | 34 |
769288 | 769288 | 2020-11-26 | Olmsted | Minnesota | 27109 | 6261 | 34 |
766042 | 766042 | 2020-11-25 | Olmsted | Minnesota | 27109 | 6261 | 34 |
762797 | 762797 | 2020-11-24 | Olmsted | Minnesota | 27109 | 6160 | 33 |
759552 | 759552 | 2020-11-23 | Olmsted | Minnesota | 27109 | 6101 | 30 |
756305 | 756305 | 2020-11-22 | Olmsted | Minnesota | 27109 | 6047 | 30 |
753059 | 753059 | 2020-11-21 | Olmsted | Minnesota | 27109 | 5889 | 30 |
749813 | 749813 | 2020-11-20 | Olmsted | Minnesota | 27109 | 5800 | 30 |
746567 | 746567 | 2020-11-19 | Olmsted | Minnesota | 27109 | 5698 | 30 |
743320 | 743320 | 2020-11-18 | Olmsted | Minnesota | 27109 | 5538 | 30 |
740073 | 740073 | 2020-11-17 | Olmsted | Minnesota | 27109 | 5428 | 30 |
736829 | 736829 | 2020-11-16 | Olmsted | Minnesota | 27109 | 5313 | 30 |
733583 | 733583 | 2020-11-15 | Olmsted | Minnesota | 27109 | 5141 | 30 |
730338 | 730338 | 2020-11-14 | Olmsted | Minnesota | 27109 | 4643 | 30 |
727095 | 727095 | 2020-11-13 | Olmsted | Minnesota | 27109 | 4438 | 30 |
723852 | 723852 | 2020-11-12 | Olmsted | Minnesota | 27109 | 4395 | 30 |
720609 | 720609 | 2020-11-11 | Olmsted | Minnesota | 27109 | 4333 | 30 |
717366 | 717366 | 2020-11-10 | Olmsted | Minnesota | 27109 | 4283 | 30 |
714122 | 714122 | 2020-11-09 | Olmsted | Minnesota | 27109 | 4231 | 30 |
710878 | 710878 | 2020-11-08 | Olmsted | Minnesota | 27109 | 4213 | 30 |
707634 | 707634 | 2020-11-07 | Olmsted | Minnesota | 27109 | 4147 | 30 |
704391 | 704391 | 2020-11-06 | Olmsted | Minnesota | 27109 | 4045 | 30 |
701149 | 701149 | 2020-11-05 | Olmsted | Minnesota | 27109 | 3930 | 30 |
697905 | 697905 | 2020-11-04 | Olmsted | Minnesota | 27109 | 3823 | 30 |
694662 | 694662 | 2020-11-03 | Olmsted | Minnesota | 27109 | 3735 | 30 |
691420 | 691420 | 2020-11-02 | Olmsted | Minnesota | 27109 | 3686 | 30 |
688175 | 688175 | 2020-11-01 | Olmsted | Minnesota | 27109 | 3623 | 30 |
684931 | 684931 | 2020-10-31 | Olmsted | Minnesota | 27109 | 3514 | 30 |
681688 | 681688 | 2020-10-30 | Olmsted | Minnesota | 27109 | 3449 | 30 |
678444 | 678444 | 2020-10-29 | Olmsted | Minnesota | 27109 | 3402 | 30 |
675202 | 675202 | 2020-10-28 | Olmsted | Minnesota | 27109 | 3359 | 30 |
671959 | 671959 | 2020-10-27 | Olmsted | Minnesota | 27109 | 3314 | 30 |
668717 | 668717 | 2020-10-26 | Olmsted | Minnesota | 27109 | 3277 | 30 |
665473 | 665473 | 2020-10-25 | Olmsted | Minnesota | 27109 | 3252 | 30 |
662228 | 662228 | 2020-10-24 | Olmsted | Minnesota | 27109 | 3232 | 30 |
658984 | 658984 | 2020-10-23 | Olmsted | Minnesota | 27109 | 3183 | 30 |
655739 | 655739 | 2020-10-22 | Olmsted | Minnesota | 27109 | 3159 | 30 |
652494 | 652494 | 2020-10-21 | Olmsted | Minnesota | 27109 | 3125 | 29 |
649249 | 649249 | 2020-10-20 | Olmsted | Minnesota | 27109 | 3089 | 29 |
646005 | 646005 | 2020-10-19 | Olmsted | Minnesota | 27109 | 3070 | 29 |
642758 | 642758 | 2020-10-18 | Olmsted | Minnesota | 27109 | 3050 | 29 |
639511 | 639511 | 2020-10-17 | Olmsted | Minnesota | 27109 | 3025 | 29 |
636265 | 636265 | 2020-10-16 | Olmsted | Minnesota | 27109 | 2979 | 29 |
633019 | 633019 | 2020-10-15 | Olmsted | Minnesota | 27109 | 2912 | 29 |
629774 | 629774 | 2020-10-14 | Olmsted | Minnesota | 27109 | 2884 | 29 |
626530 | 626530 | 2020-10-13 | Olmsted | Minnesota | 27109 | 2861 | 28 |
623288 | 623288 | 2020-10-12 | Olmsted | Minnesota | 27109 | 2848 | 28 |
620045 | 620045 | 2020-10-11 | Olmsted | Minnesota | 27109 | 2838 | 28 |
616803 | 616803 | 2020-10-10 | Olmsted | Minnesota | 27109 | 2817 | 28 |
613562 | 613562 | 2020-10-09 | Olmsted | Minnesota | 27109 | 2776 | 28 |
610320 | 610320 | 2020-10-08 | Olmsted | Minnesota | 27109 | 2751 | 28 |
607078 | 607078 | 2020-10-07 | Olmsted | Minnesota | 27109 | 2723 | 28 |
603835 | 603835 | 2020-10-06 | Olmsted | Minnesota | 27109 | 2707 | 28 |
600593 | 600593 | 2020-10-05 | Olmsted | Minnesota | 27109 | 2683 | 28 |
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);