ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27157 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093858 | 1093858 | 2021-03-06 | Wabasha | Minnesota | 27157 | 1873 | 3 |
1090612 | 1090612 | 2021-03-05 | Wabasha | Minnesota | 27157 | 1871 | 3 |
1087367 | 1087367 | 2021-03-04 | Wabasha | Minnesota | 27157 | 1867 | 3 |
1084122 | 1084122 | 2021-03-03 | Wabasha | Minnesota | 27157 | 1867 | 3 |
1080876 | 1080876 | 2021-03-02 | Wabasha | Minnesota | 27157 | 1865 | 3 |
1077630 | 1077630 | 2021-03-01 | Wabasha | Minnesota | 27157 | 1862 | 3 |
1074384 | 1074384 | 2021-02-28 | Wabasha | Minnesota | 27157 | 1861 | 3 |
1071138 | 1071138 | 2021-02-27 | Wabasha | Minnesota | 27157 | 1861 | 3 |
1067893 | 1067893 | 2021-02-26 | Wabasha | Minnesota | 27157 | 1857 | 3 |
1064648 | 1064648 | 2021-02-25 | Wabasha | Minnesota | 27157 | 1855 | 3 |
1061404 | 1061404 | 2021-02-24 | Wabasha | Minnesota | 27157 | 1854 | 3 |
1058158 | 1058158 | 2021-02-23 | Wabasha | Minnesota | 27157 | 1850 | 3 |
1054912 | 1054912 | 2021-02-22 | Wabasha | Minnesota | 27157 | 1850 | 3 |
1051665 | 1051665 | 2021-02-21 | Wabasha | Minnesota | 27157 | 1849 | 3 |
1048418 | 1048418 | 2021-02-20 | Wabasha | Minnesota | 27157 | 1847 | 3 |
1045172 | 1045172 | 2021-02-19 | Wabasha | Minnesota | 27157 | 1846 | 3 |
1041927 | 1041927 | 2021-02-18 | Wabasha | Minnesota | 27157 | 1845 | 3 |
1038682 | 1038682 | 2021-02-17 | Wabasha | Minnesota | 27157 | 1843 | 3 |
1035437 | 1035437 | 2021-02-16 | Wabasha | Minnesota | 27157 | 1839 | 3 |
1032192 | 1032192 | 2021-02-15 | Wabasha | Minnesota | 27157 | 1839 | 3 |
1028945 | 1028945 | 2021-02-14 | Wabasha | Minnesota | 27157 | 1838 | 3 |
1025699 | 1025699 | 2021-02-13 | Wabasha | Minnesota | 27157 | 1833 | 3 |
1022454 | 1022454 | 2021-02-12 | Wabasha | Minnesota | 27157 | 1828 | 3 |
1019209 | 1019209 | 2021-02-11 | Wabasha | Minnesota | 27157 | 1828 | 3 |
1015964 | 1015964 | 2021-02-10 | Wabasha | Minnesota | 27157 | 1826 | 3 |
1012719 | 1012719 | 2021-02-09 | Wabasha | Minnesota | 27157 | 1822 | 3 |
1009474 | 1009474 | 2021-02-08 | Wabasha | Minnesota | 27157 | 1820 | 3 |
1006227 | 1006227 | 2021-02-07 | Wabasha | Minnesota | 27157 | 1815 | 3 |
1002981 | 1002981 | 2021-02-06 | Wabasha | Minnesota | 27157 | 1811 | 3 |
999736 | 999736 | 2021-02-05 | Wabasha | Minnesota | 27157 | 1807 | 3 |
996490 | 996490 | 2021-02-04 | Wabasha | Minnesota | 27157 | 1807 | 3 |
993244 | 993244 | 2021-02-03 | Wabasha | Minnesota | 27157 | 1799 | 3 |
989998 | 989998 | 2021-02-02 | Wabasha | Minnesota | 27157 | 1790 | 3 |
986751 | 986751 | 2021-02-01 | Wabasha | Minnesota | 27157 | 1787 | 3 |
983504 | 983504 | 2021-01-31 | Wabasha | Minnesota | 27157 | 1786 | 3 |
980258 | 980258 | 2021-01-30 | Wabasha | Minnesota | 27157 | 1778 | 3 |
977012 | 977012 | 2021-01-29 | Wabasha | Minnesota | 27157 | 1770 | 3 |
973767 | 973767 | 2021-01-28 | Wabasha | Minnesota | 27157 | 1767 | 3 |
970522 | 970522 | 2021-01-27 | Wabasha | Minnesota | 27157 | 1756 | 3 |
967277 | 967277 | 2021-01-26 | Wabasha | Minnesota | 27157 | 1749 | 3 |
964033 | 964033 | 2021-01-25 | Wabasha | Minnesota | 27157 | 1748 | 3 |
960788 | 960788 | 2021-01-24 | Wabasha | Minnesota | 27157 | 1746 | 3 |
957542 | 957542 | 2021-01-23 | Wabasha | Minnesota | 27157 | 1741 | 3 |
954297 | 954297 | 2021-01-22 | Wabasha | Minnesota | 27157 | 1734 | 3 |
951052 | 951052 | 2021-01-21 | Wabasha | Minnesota | 27157 | 1729 | 3 |
947806 | 947806 | 2021-01-20 | Wabasha | Minnesota | 27157 | 1724 | 3 |
944559 | 944559 | 2021-01-19 | Wabasha | Minnesota | 27157 | 1708 | 3 |
941314 | 941314 | 2021-01-18 | Wabasha | Minnesota | 27157 | 1702 | 3 |
938069 | 938069 | 2021-01-17 | Wabasha | Minnesota | 27157 | 1695 | 3 |
934824 | 934824 | 2021-01-16 | Wabasha | Minnesota | 27157 | 1688 | 3 |
931579 | 931579 | 2021-01-15 | Wabasha | Minnesota | 27157 | 1680 | 2 |
928334 | 928334 | 2021-01-14 | Wabasha | Minnesota | 27157 | 1671 | 2 |
925088 | 925088 | 2021-01-13 | Wabasha | Minnesota | 27157 | 1661 | 2 |
921843 | 921843 | 2021-01-12 | Wabasha | Minnesota | 27157 | 1644 | 2 |
918598 | 918598 | 2021-01-11 | Wabasha | Minnesota | 27157 | 1631 | 2 |
915353 | 915353 | 2021-01-10 | Wabasha | Minnesota | 27157 | 1628 | 2 |
912108 | 912108 | 2021-01-09 | Wabasha | Minnesota | 27157 | 1625 | 2 |
908863 | 908863 | 2021-01-08 | Wabasha | Minnesota | 27157 | 1609 | 2 |
905617 | 905617 | 2021-01-07 | Wabasha | Minnesota | 27157 | 1592 | 2 |
902372 | 902372 | 2021-01-06 | Wabasha | Minnesota | 27157 | 1581 | 2 |
899127 | 899127 | 2021-01-05 | Wabasha | Minnesota | 27157 | 1568 | 2 |
895882 | 895882 | 2021-01-04 | Wabasha | Minnesota | 27157 | 1559 | 2 |
892635 | 892635 | 2021-01-03 | Wabasha | Minnesota | 27157 | 1521 | 2 |
889389 | 889389 | 2021-01-02 | Wabasha | Minnesota | 27157 | 1509 | 2 |
886143 | 886143 | 2021-01-01 | Wabasha | Minnesota | 27157 | 1500 | 2 |
882898 | 882898 | 2020-12-31 | Wabasha | Minnesota | 27157 | 1500 | 2 |
879653 | 879653 | 2020-12-30 | Wabasha | Minnesota | 27157 | 1484 | 2 |
876408 | 876408 | 2020-12-29 | Wabasha | Minnesota | 27157 | 1472 | 2 |
873163 | 873163 | 2020-12-28 | Wabasha | Minnesota | 27157 | 1465 | 2 |
869918 | 869918 | 2020-12-27 | Wabasha | Minnesota | 27157 | 1462 | 2 |
866673 | 866673 | 2020-12-26 | Wabasha | Minnesota | 27157 | 1452 | 2 |
863428 | 863428 | 2020-12-25 | Wabasha | Minnesota | 27157 | 1441 | 2 |
860183 | 860183 | 2020-12-24 | Wabasha | Minnesota | 27157 | 1441 | 2 |
856938 | 856938 | 2020-12-23 | Wabasha | Minnesota | 27157 | 1434 | 2 |
853693 | 853693 | 2020-12-22 | Wabasha | Minnesota | 27157 | 1423 | 2 |
850448 | 850448 | 2020-12-21 | Wabasha | Minnesota | 27157 | 1415 | 2 |
847203 | 847203 | 2020-12-20 | Wabasha | Minnesota | 27157 | 1405 | 2 |
843957 | 843957 | 2020-12-19 | Wabasha | Minnesota | 27157 | 1393 | 2 |
840712 | 840712 | 2020-12-18 | Wabasha | Minnesota | 27157 | 1374 | 2 |
837467 | 837467 | 2020-12-17 | Wabasha | Minnesota | 27157 | 1374 | 2 |
834221 | 834221 | 2020-12-16 | Wabasha | Minnesota | 27157 | 1366 | 2 |
830974 | 830974 | 2020-12-15 | Wabasha | Minnesota | 27157 | 1352 | 2 |
827728 | 827728 | 2020-12-14 | Wabasha | Minnesota | 27157 | 1347 | 2 |
824481 | 824481 | 2020-12-13 | Wabasha | Minnesota | 27157 | 1334 | 2 |
821235 | 821235 | 2020-12-12 | Wabasha | Minnesota | 27157 | 1318 | 2 |
817989 | 817989 | 2020-12-11 | Wabasha | Minnesota | 27157 | 1301 | 2 |
814743 | 814743 | 2020-12-10 | Wabasha | Minnesota | 27157 | 1269 | 2 |
811498 | 811498 | 2020-12-09 | Wabasha | Minnesota | 27157 | 1244 | 2 |
808253 | 808253 | 2020-12-08 | Wabasha | Minnesota | 27157 | 1227 | 1 |
805008 | 805008 | 2020-12-07 | Wabasha | Minnesota | 27157 | 1216 | 1 |
801763 | 801763 | 2020-12-06 | Wabasha | Minnesota | 27157 | 1185 | 1 |
798518 | 798518 | 2020-12-05 | Wabasha | Minnesota | 27157 | 1167 | 1 |
795273 | 795273 | 2020-12-04 | Wabasha | Minnesota | 27157 | 1143 | 1 |
792028 | 792028 | 2020-12-03 | Wabasha | Minnesota | 27157 | 1130 | 1 |
788783 | 788783 | 2020-12-02 | Wabasha | Minnesota | 27157 | 1104 | 1 |
785538 | 785538 | 2020-12-01 | Wabasha | Minnesota | 27157 | 1087 | 1 |
782294 | 782294 | 2020-11-30 | Wabasha | Minnesota | 27157 | 1078 | 1 |
779048 | 779048 | 2020-11-29 | Wabasha | Minnesota | 27157 | 1056 | 1 |
775803 | 775803 | 2020-11-28 | Wabasha | Minnesota | 27157 | 1030 | 1 |
772558 | 772558 | 2020-11-27 | Wabasha | Minnesota | 27157 | 994 | 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);