ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 27161 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093860 | 1093860 | 2021-03-06 | Waseca | Minnesota | 27161 | 2104 | 17 |
1090614 | 1090614 | 2021-03-05 | Waseca | Minnesota | 27161 | 2101 | 17 |
1087369 | 1087369 | 2021-03-04 | Waseca | Minnesota | 27161 | 2097 | 17 |
1084124 | 1084124 | 2021-03-03 | Waseca | Minnesota | 27161 | 2093 | 17 |
1080878 | 1080878 | 2021-03-02 | Waseca | Minnesota | 27161 | 2087 | 17 |
1077632 | 1077632 | 2021-03-01 | Waseca | Minnesota | 27161 | 2089 | 17 |
1074386 | 1074386 | 2021-02-28 | Waseca | Minnesota | 27161 | 2088 | 17 |
1071140 | 1071140 | 2021-02-27 | Waseca | Minnesota | 27161 | 2086 | 17 |
1067895 | 1067895 | 2021-02-26 | Waseca | Minnesota | 27161 | 2079 | 17 |
1064650 | 1064650 | 2021-02-25 | Waseca | Minnesota | 27161 | 2073 | 17 |
1061406 | 1061406 | 2021-02-24 | Waseca | Minnesota | 27161 | 2069 | 17 |
1058160 | 1058160 | 2021-02-23 | Waseca | Minnesota | 27161 | 2063 | 17 |
1054914 | 1054914 | 2021-02-22 | Waseca | Minnesota | 27161 | 2060 | 17 |
1051667 | 1051667 | 2021-02-21 | Waseca | Minnesota | 27161 | 2057 | 17 |
1048420 | 1048420 | 2021-02-20 | Waseca | Minnesota | 27161 | 2052 | 17 |
1045174 | 1045174 | 2021-02-19 | Waseca | Minnesota | 27161 | 2049 | 17 |
1041929 | 1041929 | 2021-02-18 | Waseca | Minnesota | 27161 | 2044 | 17 |
1038684 | 1038684 | 2021-02-17 | Waseca | Minnesota | 27161 | 2040 | 17 |
1035439 | 1035439 | 2021-02-16 | Waseca | Minnesota | 27161 | 2039 | 17 |
1032194 | 1032194 | 2021-02-15 | Waseca | Minnesota | 27161 | 2035 | 17 |
1028947 | 1028947 | 2021-02-14 | Waseca | Minnesota | 27161 | 2031 | 17 |
1025701 | 1025701 | 2021-02-13 | Waseca | Minnesota | 27161 | 2025 | 17 |
1022456 | 1022456 | 2021-02-12 | Waseca | Minnesota | 27161 | 2022 | 17 |
1019211 | 1019211 | 2021-02-11 | Waseca | Minnesota | 27161 | 2015 | 17 |
1015966 | 1015966 | 2021-02-10 | Waseca | Minnesota | 27161 | 2009 | 17 |
1012721 | 1012721 | 2021-02-09 | Waseca | Minnesota | 27161 | 2001 | 17 |
1009476 | 1009476 | 2021-02-08 | Waseca | Minnesota | 27161 | 2000 | 17 |
1006229 | 1006229 | 2021-02-07 | Waseca | Minnesota | 27161 | 1996 | 17 |
1002983 | 1002983 | 2021-02-06 | Waseca | Minnesota | 27161 | 1992 | 17 |
999738 | 999738 | 2021-02-05 | Waseca | Minnesota | 27161 | 1989 | 16 |
996492 | 996492 | 2021-02-04 | Waseca | Minnesota | 27161 | 1976 | 16 |
993246 | 993246 | 2021-02-03 | Waseca | Minnesota | 27161 | 1971 | 16 |
990000 | 990000 | 2021-02-02 | Waseca | Minnesota | 27161 | 1970 | 16 |
986753 | 986753 | 2021-02-01 | Waseca | Minnesota | 27161 | 1971 | 16 |
983506 | 983506 | 2021-01-31 | Waseca | Minnesota | 27161 | 1968 | 16 |
980260 | 980260 | 2021-01-30 | Waseca | Minnesota | 27161 | 1963 | 16 |
977014 | 977014 | 2021-01-29 | Waseca | Minnesota | 27161 | 1956 | 16 |
973769 | 973769 | 2021-01-28 | Waseca | Minnesota | 27161 | 1952 | 16 |
970524 | 970524 | 2021-01-27 | Waseca | Minnesota | 27161 | 1940 | 16 |
967279 | 967279 | 2021-01-26 | Waseca | Minnesota | 27161 | 1939 | 16 |
964035 | 964035 | 2021-01-25 | Waseca | Minnesota | 27161 | 1933 | 16 |
960790 | 960790 | 2021-01-24 | Waseca | Minnesota | 27161 | 1932 | 16 |
957544 | 957544 | 2021-01-23 | Waseca | Minnesota | 27161 | 1928 | 16 |
954299 | 954299 | 2021-01-22 | Waseca | Minnesota | 27161 | 1919 | 16 |
951054 | 951054 | 2021-01-21 | Waseca | Minnesota | 27161 | 1907 | 16 |
947808 | 947808 | 2021-01-20 | Waseca | Minnesota | 27161 | 1901 | 16 |
944561 | 944561 | 2021-01-19 | Waseca | Minnesota | 27161 | 1893 | 16 |
941316 | 941316 | 2021-01-18 | Waseca | Minnesota | 27161 | 1889 | 16 |
938071 | 938071 | 2021-01-17 | Waseca | Minnesota | 27161 | 1889 | 16 |
934826 | 934826 | 2021-01-16 | Waseca | Minnesota | 27161 | 1888 | 16 |
931581 | 931581 | 2021-01-15 | Waseca | Minnesota | 27161 | 1880 | 15 |
928336 | 928336 | 2021-01-14 | Waseca | Minnesota | 27161 | 1875 | 15 |
925090 | 925090 | 2021-01-13 | Waseca | Minnesota | 27161 | 1873 | 15 |
921845 | 921845 | 2021-01-12 | Waseca | Minnesota | 27161 | 1868 | 15 |
918600 | 918600 | 2021-01-11 | Waseca | Minnesota | 27161 | 1864 | 16 |
915355 | 915355 | 2021-01-10 | Waseca | Minnesota | 27161 | 1860 | 16 |
912110 | 912110 | 2021-01-09 | Waseca | Minnesota | 27161 | 1856 | 16 |
908865 | 908865 | 2021-01-08 | Waseca | Minnesota | 27161 | 1836 | 16 |
905619 | 905619 | 2021-01-07 | Waseca | Minnesota | 27161 | 1825 | 16 |
902374 | 902374 | 2021-01-06 | Waseca | Minnesota | 27161 | 1811 | 16 |
899129 | 899129 | 2021-01-05 | Waseca | Minnesota | 27161 | 1806 | 15 |
895884 | 895884 | 2021-01-04 | Waseca | Minnesota | 27161 | 1794 | 15 |
892637 | 892637 | 2021-01-03 | Waseca | Minnesota | 27161 | 1779 | 15 |
889391 | 889391 | 2021-01-02 | Waseca | Minnesota | 27161 | 1772 | 13 |
886145 | 886145 | 2021-01-01 | Waseca | Minnesota | 27161 | 1755 | 13 |
882900 | 882900 | 2020-12-31 | Waseca | Minnesota | 27161 | 1755 | 13 |
879655 | 879655 | 2020-12-30 | Waseca | Minnesota | 27161 | 1747 | 12 |
876410 | 876410 | 2020-12-29 | Waseca | Minnesota | 27161 | 1717 | 12 |
873165 | 873165 | 2020-12-28 | Waseca | Minnesota | 27161 | 1714 | 12 |
869920 | 869920 | 2020-12-27 | Waseca | Minnesota | 27161 | 1711 | 12 |
866675 | 866675 | 2020-12-26 | Waseca | Minnesota | 27161 | 1699 | 12 |
863430 | 863430 | 2020-12-25 | Waseca | Minnesota | 27161 | 1680 | 12 |
860185 | 860185 | 2020-12-24 | Waseca | Minnesota | 27161 | 1680 | 12 |
856940 | 856940 | 2020-12-23 | Waseca | Minnesota | 27161 | 1669 | 12 |
853695 | 853695 | 2020-12-22 | Waseca | Minnesota | 27161 | 1659 | 12 |
850450 | 850450 | 2020-12-21 | Waseca | Minnesota | 27161 | 1649 | 12 |
847205 | 847205 | 2020-12-20 | Waseca | Minnesota | 27161 | 1645 | 12 |
843959 | 843959 | 2020-12-19 | Waseca | Minnesota | 27161 | 1635 | 12 |
840714 | 840714 | 2020-12-18 | Waseca | Minnesota | 27161 | 1620 | 12 |
837469 | 837469 | 2020-12-17 | Waseca | Minnesota | 27161 | 1608 | 12 |
834223 | 834223 | 2020-12-16 | Waseca | Minnesota | 27161 | 1589 | 12 |
830976 | 830976 | 2020-12-15 | Waseca | Minnesota | 27161 | 1582 | 12 |
827730 | 827730 | 2020-12-14 | Waseca | Minnesota | 27161 | 1568 | 11 |
824483 | 824483 | 2020-12-13 | Waseca | Minnesota | 27161 | 1565 | 11 |
821237 | 821237 | 2020-12-12 | Waseca | Minnesota | 27161 | 1551 | 11 |
817991 | 817991 | 2020-12-11 | Waseca | Minnesota | 27161 | 1536 | 11 |
814745 | 814745 | 2020-12-10 | Waseca | Minnesota | 27161 | 1530 | 11 |
811500 | 811500 | 2020-12-09 | Waseca | Minnesota | 27161 | 1507 | 11 |
808255 | 808255 | 2020-12-08 | Waseca | Minnesota | 27161 | 1489 | 11 |
805010 | 805010 | 2020-12-07 | Waseca | Minnesota | 27161 | 1478 | 11 |
801765 | 801765 | 2020-12-06 | Waseca | Minnesota | 27161 | 1473 | 11 |
798520 | 798520 | 2020-12-05 | Waseca | Minnesota | 27161 | 1463 | 11 |
795275 | 795275 | 2020-12-04 | Waseca | Minnesota | 27161 | 1453 | 11 |
792030 | 792030 | 2020-12-03 | Waseca | Minnesota | 27161 | 1434 | 11 |
788785 | 788785 | 2020-12-02 | Waseca | Minnesota | 27161 | 1418 | 11 |
785540 | 785540 | 2020-12-01 | Waseca | Minnesota | 27161 | 1406 | 11 |
782296 | 782296 | 2020-11-30 | Waseca | Minnesota | 27161 | 1398 | 11 |
779050 | 779050 | 2020-11-29 | Waseca | Minnesota | 27161 | 1392 | 11 |
775805 | 775805 | 2020-11-28 | Waseca | Minnesota | 27161 | 1378 | 11 |
772560 | 772560 | 2020-11-27 | Waseca | Minnesota | 27161 | 1359 | 11 |
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);