ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Fayette" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054333 | 1054333 | 2021-02-22 | Fayette | Iowa | 19065 | 1757 | 32 |
1051086 | 1051086 | 2021-02-21 | Fayette | Iowa | 19065 | 1757 | 32 |
1047839 | 1047839 | 2021-02-20 | Fayette | Iowa | 19065 | 1757 | 32 |
1044594 | 1044594 | 2021-02-19 | Fayette | Iowa | 19065 | 1757 | 32 |
1041349 | 1041349 | 2021-02-18 | Fayette | Iowa | 19065 | 1757 | 32 |
1038104 | 1038104 | 2021-02-17 | Fayette | Iowa | 19065 | 1755 | 32 |
1034859 | 1034859 | 2021-02-16 | Fayette | Iowa | 19065 | 1751 | 31 |
1031613 | 1031613 | 2021-02-15 | Fayette | Iowa | 19065 | 1747 | 31 |
1028366 | 1028366 | 2021-02-14 | Fayette | Iowa | 19065 | 1747 | 31 |
1025121 | 1025121 | 2021-02-13 | Fayette | Iowa | 19065 | 1745 | 31 |
1021876 | 1021876 | 2021-02-12 | Fayette | Iowa | 19065 | 1744 | 31 |
1018631 | 1018631 | 2021-02-11 | Fayette | Iowa | 19065 | 1739 | 28 |
1015386 | 1015386 | 2021-02-10 | Fayette | Iowa | 19065 | 1736 | 28 |
1012141 | 1012141 | 2021-02-09 | Fayette | Iowa | 19065 | 1730 | 28 |
1008895 | 1008895 | 2021-02-08 | Fayette | Iowa | 19065 | 1725 | 27 |
1005649 | 1005649 | 2021-02-07 | Fayette | Iowa | 19065 | 1723 | 27 |
1002403 | 1002403 | 2021-02-06 | Fayette | Iowa | 19065 | 1722 | 27 |
999157 | 999157 | 2021-02-05 | Fayette | Iowa | 19065 | 1718 | 26 |
995911 | 995911 | 2021-02-04 | Fayette | Iowa | 19065 | 1712 | 26 |
992665 | 992665 | 2021-02-03 | Fayette | Iowa | 19065 | 1709 | 26 |
989419 | 989419 | 2021-02-02 | Fayette | Iowa | 19065 | 1704 | 26 |
986172 | 986172 | 2021-02-01 | Fayette | Iowa | 19065 | 1696 | 26 |
982925 | 982925 | 2021-01-31 | Fayette | Iowa | 19065 | 1695 | 26 |
979679 | 979679 | 2021-01-30 | Fayette | Iowa | 19065 | 1695 | 25 |
976433 | 976433 | 2021-01-29 | Fayette | Iowa | 19065 | 1689 | 25 |
973188 | 973188 | 2021-01-28 | Fayette | Iowa | 19065 | 1687 | 24 |
969943 | 969943 | 2021-01-27 | Fayette | Iowa | 19065 | 1684 | 24 |
966699 | 966699 | 2021-01-26 | Fayette | Iowa | 19065 | 1668 | 24 |
963454 | 963454 | 2021-01-25 | Fayette | Iowa | 19065 | 1663 | 24 |
960209 | 960209 | 2021-01-24 | Fayette | Iowa | 19065 | 1660 | 24 |
956963 | 956963 | 2021-01-23 | Fayette | Iowa | 19065 | 1659 | 24 |
953718 | 953718 | 2021-01-22 | Fayette | Iowa | 19065 | 1650 | 24 |
950473 | 950473 | 2021-01-21 | Fayette | Iowa | 19065 | 1641 | 23 |
947227 | 947227 | 2021-01-20 | Fayette | Iowa | 19065 | 1636 | 23 |
943980 | 943980 | 2021-01-19 | Fayette | Iowa | 19065 | 1623 | 22 |
940735 | 940735 | 2021-01-18 | Fayette | Iowa | 19065 | 1611 | 22 |
937490 | 937490 | 2021-01-17 | Fayette | Iowa | 19065 | 1601 | 22 |
934245 | 934245 | 2021-01-16 | Fayette | Iowa | 19065 | 1595 | 22 |
931000 | 931000 | 2021-01-15 | Fayette | Iowa | 19065 | 1591 | 22 |
927755 | 927755 | 2021-01-14 | Fayette | Iowa | 19065 | 1569 | 22 |
924509 | 924509 | 2021-01-13 | Fayette | Iowa | 19065 | 1556 | 22 |
921264 | 921264 | 2021-01-12 | Fayette | Iowa | 19065 | 1535 | 22 |
918019 | 918019 | 2021-01-11 | Fayette | Iowa | 19065 | 1530 | 22 |
914774 | 914774 | 2021-01-10 | Fayette | Iowa | 19065 | 1519 | 22 |
911529 | 911529 | 2021-01-09 | Fayette | Iowa | 19065 | 1513 | 22 |
908284 | 908284 | 2021-01-08 | Fayette | Iowa | 19065 | 1505 | 22 |
905038 | 905038 | 2021-01-07 | Fayette | Iowa | 19065 | 1494 | 21 |
901793 | 901793 | 2021-01-06 | Fayette | Iowa | 19065 | 1481 | 21 |
898548 | 898548 | 2021-01-05 | Fayette | Iowa | 19065 | 1460 | 21 |
895303 | 895303 | 2021-01-04 | Fayette | Iowa | 19065 | 1447 | 21 |
892056 | 892056 | 2021-01-03 | Fayette | Iowa | 19065 | 1436 | 19 |
888810 | 888810 | 2021-01-02 | Fayette | Iowa | 19065 | 1426 | 19 |
885564 | 885564 | 2021-01-01 | Fayette | Iowa | 19065 | 1412 | 19 |
882319 | 882319 | 2020-12-31 | Fayette | Iowa | 19065 | 1405 | 19 |
879074 | 879074 | 2020-12-30 | Fayette | Iowa | 19065 | 1396 | 17 |
875829 | 875829 | 2020-12-29 | Fayette | Iowa | 19065 | 1380 | 17 |
872584 | 872584 | 2020-12-28 | Fayette | Iowa | 19065 | 1359 | 16 |
869339 | 869339 | 2020-12-27 | Fayette | Iowa | 19065 | 1338 | 16 |
866094 | 866094 | 2020-12-26 | Fayette | Iowa | 19065 | 1329 | 16 |
862849 | 862849 | 2020-12-25 | Fayette | Iowa | 19065 | 1327 | 16 |
859604 | 859604 | 2020-12-24 | Fayette | Iowa | 19065 | 1308 | 16 |
856359 | 856359 | 2020-12-23 | Fayette | Iowa | 19065 | 1301 | 16 |
853114 | 853114 | 2020-12-22 | Fayette | Iowa | 19065 | 1287 | 16 |
849869 | 849869 | 2020-12-21 | Fayette | Iowa | 19065 | 1260 | 15 |
846624 | 846624 | 2020-12-20 | Fayette | Iowa | 19065 | 1242 | 15 |
843378 | 843378 | 2020-12-19 | Fayette | Iowa | 19065 | 1241 | 15 |
840133 | 840133 | 2020-12-18 | Fayette | Iowa | 19065 | 1226 | 14 |
836888 | 836888 | 2020-12-17 | Fayette | Iowa | 19065 | 1211 | 14 |
833642 | 833642 | 2020-12-16 | Fayette | Iowa | 19065 | 1205 | 14 |
830395 | 830395 | 2020-12-15 | Fayette | Iowa | 19065 | 1197 | 14 |
827149 | 827149 | 2020-12-14 | Fayette | Iowa | 19065 | 1188 | 14 |
823902 | 823902 | 2020-12-13 | Fayette | Iowa | 19065 | 1186 | 14 |
820656 | 820656 | 2020-12-12 | Fayette | Iowa | 19065 | 1184 | 14 |
817410 | 817410 | 2020-12-11 | Fayette | Iowa | 19065 | 1173 | 14 |
814164 | 814164 | 2020-12-10 | Fayette | Iowa | 19065 | 1160 | 14 |
810919 | 810919 | 2020-12-09 | Fayette | Iowa | 19065 | 1148 | 13 |
807674 | 807674 | 2020-12-08 | Fayette | Iowa | 19065 | 1140 | 12 |
804429 | 804429 | 2020-12-07 | Fayette | Iowa | 19065 | 1138 | 12 |
801184 | 801184 | 2020-12-06 | Fayette | Iowa | 19065 | 1131 | 12 |
797939 | 797939 | 2020-12-05 | Fayette | Iowa | 19065 | 1125 | 12 |
794694 | 794694 | 2020-12-04 | Fayette | Iowa | 19065 | 1118 | 12 |
791449 | 791449 | 2020-12-03 | Fayette | Iowa | 19065 | 1098 | 12 |
788204 | 788204 | 2020-12-02 | Fayette | Iowa | 19065 | 1087 | 12 |
784960 | 784960 | 2020-12-01 | Fayette | Iowa | 19065 | 1076 | 10 |
781715 | 781715 | 2020-11-30 | Fayette | Iowa | 19065 | 1057 | 10 |
778469 | 778469 | 2020-11-29 | Fayette | Iowa | 19065 | 1039 | 10 |
775224 | 775224 | 2020-11-28 | Fayette | Iowa | 19065 | 1033 | 10 |
771979 | 771979 | 2020-11-27 | Fayette | Iowa | 19065 | 1022 | 10 |
768734 | 768734 | 2020-11-26 | Fayette | Iowa | 19065 | 1015 | 9 |
765488 | 765488 | 2020-11-25 | Fayette | Iowa | 19065 | 1014 | 9 |
762243 | 762243 | 2020-11-24 | Fayette | Iowa | 19065 | 1000 | 8 |
758998 | 758998 | 2020-11-23 | Fayette | Iowa | 19065 | 977 | 8 |
755751 | 755751 | 2020-11-22 | Fayette | Iowa | 19065 | 958 | 8 |
752505 | 752505 | 2020-11-21 | Fayette | Iowa | 19065 | 942 | 8 |
749259 | 749259 | 2020-11-20 | Fayette | Iowa | 19065 | 928 | 8 |
746013 | 746013 | 2020-11-19 | Fayette | Iowa | 19065 | 910 | 8 |
742766 | 742766 | 2020-11-18 | Fayette | Iowa | 19065 | 884 | 8 |
739519 | 739519 | 2020-11-17 | Fayette | Iowa | 19065 | 857 | 8 |
736275 | 736275 | 2020-11-16 | Fayette | Iowa | 19065 | 826 | 8 |
733029 | 733029 | 2020-11-15 | Fayette | Iowa | 19065 | 797 | 8 |
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);