ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Winneshiek" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054397 | 1054397 | 2021-02-22 | Winneshiek | Iowa | 19191 | 1783 | 26 |
1051150 | 1051150 | 2021-02-21 | Winneshiek | Iowa | 19191 | 1783 | 26 |
1047903 | 1047903 | 2021-02-20 | Winneshiek | Iowa | 19191 | 1783 | 26 |
1044658 | 1044658 | 2021-02-19 | Winneshiek | Iowa | 19191 | 1783 | 26 |
1041413 | 1041413 | 2021-02-18 | Winneshiek | Iowa | 19191 | 1780 | 26 |
1038168 | 1038168 | 2021-02-17 | Winneshiek | Iowa | 19191 | 1778 | 26 |
1034923 | 1034923 | 2021-02-16 | Winneshiek | Iowa | 19191 | 1764 | 26 |
1031677 | 1031677 | 2021-02-15 | Winneshiek | Iowa | 19191 | 1760 | 26 |
1028430 | 1028430 | 2021-02-14 | Winneshiek | Iowa | 19191 | 1757 | 26 |
1025185 | 1025185 | 2021-02-13 | Winneshiek | Iowa | 19191 | 1757 | 26 |
1021940 | 1021940 | 2021-02-12 | Winneshiek | Iowa | 19191 | 1750 | 26 |
1018695 | 1018695 | 2021-02-11 | Winneshiek | Iowa | 19191 | 1735 | 26 |
1015450 | 1015450 | 2021-02-10 | Winneshiek | Iowa | 19191 | 1733 | 26 |
1012205 | 1012205 | 2021-02-09 | Winneshiek | Iowa | 19191 | 1717 | 26 |
1008959 | 1008959 | 2021-02-08 | Winneshiek | Iowa | 19191 | 1701 | 26 |
1005713 | 1005713 | 2021-02-07 | Winneshiek | Iowa | 19191 | 1698 | 26 |
1002467 | 1002467 | 2021-02-06 | Winneshiek | Iowa | 19191 | 1695 | 26 |
999221 | 999221 | 2021-02-05 | Winneshiek | Iowa | 19191 | 1687 | 26 |
995975 | 995975 | 2021-02-04 | Winneshiek | Iowa | 19191 | 1686 | 25 |
992729 | 992729 | 2021-02-03 | Winneshiek | Iowa | 19191 | 1678 | 24 |
989483 | 989483 | 2021-02-02 | Winneshiek | Iowa | 19191 | 1669 | 24 |
986236 | 986236 | 2021-02-01 | Winneshiek | Iowa | 19191 | 1658 | 24 |
982989 | 982989 | 2021-01-31 | Winneshiek | Iowa | 19191 | 1653 | 24 |
979743 | 979743 | 2021-01-30 | Winneshiek | Iowa | 19191 | 1652 | 23 |
976497 | 976497 | 2021-01-29 | Winneshiek | Iowa | 19191 | 1636 | 20 |
973252 | 973252 | 2021-01-28 | Winneshiek | Iowa | 19191 | 1632 | 20 |
970007 | 970007 | 2021-01-27 | Winneshiek | Iowa | 19191 | 1630 | 20 |
966763 | 966763 | 2021-01-26 | Winneshiek | Iowa | 19191 | 1614 | 20 |
963518 | 963518 | 2021-01-25 | Winneshiek | Iowa | 19191 | 1610 | 20 |
960273 | 960273 | 2021-01-24 | Winneshiek | Iowa | 19191 | 1608 | 20 |
957027 | 957027 | 2021-01-23 | Winneshiek | Iowa | 19191 | 1608 | 20 |
953782 | 953782 | 2021-01-22 | Winneshiek | Iowa | 19191 | 1597 | 20 |
950537 | 950537 | 2021-01-21 | Winneshiek | Iowa | 19191 | 1591 | 20 |
947291 | 947291 | 2021-01-20 | Winneshiek | Iowa | 19191 | 1569 | 19 |
944044 | 944044 | 2021-01-19 | Winneshiek | Iowa | 19191 | 1557 | 19 |
940799 | 940799 | 2021-01-18 | Winneshiek | Iowa | 19191 | 1552 | 19 |
937554 | 937554 | 2021-01-17 | Winneshiek | Iowa | 19191 | 1551 | 19 |
934309 | 934309 | 2021-01-16 | Winneshiek | Iowa | 19191 | 1548 | 19 |
931064 | 931064 | 2021-01-15 | Winneshiek | Iowa | 19191 | 1530 | 19 |
927819 | 927819 | 2021-01-14 | Winneshiek | Iowa | 19191 | 1508 | 19 |
924573 | 924573 | 2021-01-13 | Winneshiek | Iowa | 19191 | 1506 | 19 |
921328 | 921328 | 2021-01-12 | Winneshiek | Iowa | 19191 | 1474 | 19 |
918083 | 918083 | 2021-01-11 | Winneshiek | Iowa | 19191 | 1473 | 19 |
914838 | 914838 | 2021-01-10 | Winneshiek | Iowa | 19191 | 1472 | 19 |
911593 | 911593 | 2021-01-09 | Winneshiek | Iowa | 19191 | 1471 | 19 |
908348 | 908348 | 2021-01-08 | Winneshiek | Iowa | 19191 | 1462 | 19 |
905102 | 905102 | 2021-01-07 | Winneshiek | Iowa | 19191 | 1437 | 19 |
901857 | 901857 | 2021-01-06 | Winneshiek | Iowa | 19191 | 1424 | 19 |
898612 | 898612 | 2021-01-05 | Winneshiek | Iowa | 19191 | 1403 | 19 |
895367 | 895367 | 2021-01-04 | Winneshiek | Iowa | 19191 | 1400 | 19 |
892120 | 892120 | 2021-01-03 | Winneshiek | Iowa | 19191 | 1398 | 18 |
888874 | 888874 | 2021-01-02 | Winneshiek | Iowa | 19191 | 1393 | 18 |
885628 | 885628 | 2021-01-01 | Winneshiek | Iowa | 19191 | 1386 | 18 |
882383 | 882383 | 2020-12-31 | Winneshiek | Iowa | 19191 | 1381 | 18 |
879138 | 879138 | 2020-12-30 | Winneshiek | Iowa | 19191 | 1379 | 18 |
875893 | 875893 | 2020-12-29 | Winneshiek | Iowa | 19191 | 1368 | 18 |
872648 | 872648 | 2020-12-28 | Winneshiek | Iowa | 19191 | 1349 | 17 |
869403 | 869403 | 2020-12-27 | Winneshiek | Iowa | 19191 | 1345 | 17 |
866158 | 866158 | 2020-12-26 | Winneshiek | Iowa | 19191 | 1344 | 17 |
862913 | 862913 | 2020-12-25 | Winneshiek | Iowa | 19191 | 1340 | 17 |
859668 | 859668 | 2020-12-24 | Winneshiek | Iowa | 19191 | 1339 | 17 |
856423 | 856423 | 2020-12-23 | Winneshiek | Iowa | 19191 | 1330 | 17 |
853178 | 853178 | 2020-12-22 | Winneshiek | Iowa | 19191 | 1308 | 17 |
849933 | 849933 | 2020-12-21 | Winneshiek | Iowa | 19191 | 1299 | 17 |
846688 | 846688 | 2020-12-20 | Winneshiek | Iowa | 19191 | 1296 | 17 |
843442 | 843442 | 2020-12-19 | Winneshiek | Iowa | 19191 | 1293 | 17 |
840197 | 840197 | 2020-12-18 | Winneshiek | Iowa | 19191 | 1269 | 16 |
836952 | 836952 | 2020-12-17 | Winneshiek | Iowa | 19191 | 1253 | 16 |
833706 | 833706 | 2020-12-16 | Winneshiek | Iowa | 19191 | 1242 | 16 |
830459 | 830459 | 2020-12-15 | Winneshiek | Iowa | 19191 | 1217 | 16 |
827213 | 827213 | 2020-12-14 | Winneshiek | Iowa | 19191 | 1210 | 15 |
823966 | 823966 | 2020-12-13 | Winneshiek | Iowa | 19191 | 1205 | 15 |
820720 | 820720 | 2020-12-12 | Winneshiek | Iowa | 19191 | 1194 | 15 |
817474 | 817474 | 2020-12-11 | Winneshiek | Iowa | 19191 | 1184 | 15 |
814228 | 814228 | 2020-12-10 | Winneshiek | Iowa | 19191 | 1165 | 15 |
810983 | 810983 | 2020-12-09 | Winneshiek | Iowa | 19191 | 1156 | 14 |
807738 | 807738 | 2020-12-08 | Winneshiek | Iowa | 19191 | 1118 | 14 |
804493 | 804493 | 2020-12-07 | Winneshiek | Iowa | 19191 | 1117 | 14 |
801248 | 801248 | 2020-12-06 | Winneshiek | Iowa | 19191 | 1112 | 14 |
798003 | 798003 | 2020-12-05 | Winneshiek | Iowa | 19191 | 1109 | 14 |
794758 | 794758 | 2020-12-04 | Winneshiek | Iowa | 19191 | 1097 | 14 |
791513 | 791513 | 2020-12-03 | Winneshiek | Iowa | 19191 | 1055 | 13 |
788268 | 788268 | 2020-12-02 | Winneshiek | Iowa | 19191 | 1027 | 13 |
785024 | 785024 | 2020-12-01 | Winneshiek | Iowa | 19191 | 1010 | 13 |
781779 | 781779 | 2020-11-30 | Winneshiek | Iowa | 19191 | 984 | 13 |
778533 | 778533 | 2020-11-29 | Winneshiek | Iowa | 19191 | 976 | 13 |
775288 | 775288 | 2020-11-28 | Winneshiek | Iowa | 19191 | 962 | 12 |
772043 | 772043 | 2020-11-27 | Winneshiek | Iowa | 19191 | 958 | 12 |
768798 | 768798 | 2020-11-26 | Winneshiek | Iowa | 19191 | 954 | 12 |
765552 | 765552 | 2020-11-25 | Winneshiek | Iowa | 19191 | 933 | 11 |
762307 | 762307 | 2020-11-24 | Winneshiek | Iowa | 19191 | 915 | 10 |
759062 | 759062 | 2020-11-23 | Winneshiek | Iowa | 19191 | 903 | 10 |
755815 | 755815 | 2020-11-22 | Winneshiek | Iowa | 19191 | 889 | 10 |
752569 | 752569 | 2020-11-21 | Winneshiek | Iowa | 19191 | 883 | 9 |
749323 | 749323 | 2020-11-20 | Winneshiek | Iowa | 19191 | 860 | 9 |
746077 | 746077 | 2020-11-19 | Winneshiek | Iowa | 19191 | 840 | 9 |
742830 | 742830 | 2020-11-18 | Winneshiek | Iowa | 19191 | 805 | 9 |
739583 | 739583 | 2020-11-17 | Winneshiek | Iowa | 19191 | 785 | 9 |
736339 | 736339 | 2020-11-16 | Winneshiek | Iowa | 19191 | 756 | 9 |
733093 | 733093 | 2020-11-15 | Winneshiek | Iowa | 19191 | 748 | 9 |
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);