ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19171 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054386 | 1054386 | 2021-02-22 | Tama | Iowa | 19171 | 1985 | 64 |
1051139 | 1051139 | 2021-02-21 | Tama | Iowa | 19171 | 1985 | 64 |
1047892 | 1047892 | 2021-02-20 | Tama | Iowa | 19171 | 1985 | 64 |
1044647 | 1044647 | 2021-02-19 | Tama | Iowa | 19171 | 1985 | 64 |
1041402 | 1041402 | 2021-02-18 | Tama | Iowa | 19171 | 1985 | 64 |
1038157 | 1038157 | 2021-02-17 | Tama | Iowa | 19171 | 1983 | 64 |
1034912 | 1034912 | 2021-02-16 | Tama | Iowa | 19171 | 1981 | 63 |
1031666 | 1031666 | 2021-02-15 | Tama | Iowa | 19171 | 1980 | 63 |
1028419 | 1028419 | 2021-02-14 | Tama | Iowa | 19171 | 1976 | 63 |
1025174 | 1025174 | 2021-02-13 | Tama | Iowa | 19171 | 1975 | 63 |
1021929 | 1021929 | 2021-02-12 | Tama | Iowa | 19171 | 1973 | 63 |
1018684 | 1018684 | 2021-02-11 | Tama | Iowa | 19171 | 1970 | 63 |
1015439 | 1015439 | 2021-02-10 | Tama | Iowa | 19171 | 1969 | 63 |
1012194 | 1012194 | 2021-02-09 | Tama | Iowa | 19171 | 1967 | 63 |
1008948 | 1008948 | 2021-02-08 | Tama | Iowa | 19171 | 1965 | 63 |
1005702 | 1005702 | 2021-02-07 | Tama | Iowa | 19171 | 1963 | 63 |
1002456 | 1002456 | 2021-02-06 | Tama | Iowa | 19171 | 1963 | 63 |
999210 | 999210 | 2021-02-05 | Tama | Iowa | 19171 | 1962 | 63 |
995964 | 995964 | 2021-02-04 | Tama | Iowa | 19171 | 1956 | 63 |
992718 | 992718 | 2021-02-03 | Tama | Iowa | 19171 | 1953 | 62 |
989472 | 989472 | 2021-02-02 | Tama | Iowa | 19171 | 1948 | 61 |
986225 | 986225 | 2021-02-01 | Tama | Iowa | 19171 | 1944 | 61 |
982978 | 982978 | 2021-01-31 | Tama | Iowa | 19171 | 1939 | 61 |
979732 | 979732 | 2021-01-30 | Tama | Iowa | 19171 | 1938 | 59 |
976486 | 976486 | 2021-01-29 | Tama | Iowa | 19171 | 1931 | 59 |
973241 | 973241 | 2021-01-28 | Tama | Iowa | 19171 | 1930 | 59 |
969996 | 969996 | 2021-01-27 | Tama | Iowa | 19171 | 1922 | 59 |
966752 | 966752 | 2021-01-26 | Tama | Iowa | 19171 | 1916 | 59 |
963507 | 963507 | 2021-01-25 | Tama | Iowa | 19171 | 1909 | 59 |
960262 | 960262 | 2021-01-24 | Tama | Iowa | 19171 | 1902 | 59 |
957016 | 957016 | 2021-01-23 | Tama | Iowa | 19171 | 1901 | 59 |
953771 | 953771 | 2021-01-22 | Tama | Iowa | 19171 | 1899 | 59 |
950526 | 950526 | 2021-01-21 | Tama | Iowa | 19171 | 1895 | 59 |
947280 | 947280 | 2021-01-20 | Tama | Iowa | 19171 | 1887 | 58 |
944033 | 944033 | 2021-01-19 | Tama | Iowa | 19171 | 1877 | 57 |
940788 | 940788 | 2021-01-18 | Tama | Iowa | 19171 | 1866 | 57 |
937543 | 937543 | 2021-01-17 | Tama | Iowa | 19171 | 1858 | 57 |
934298 | 934298 | 2021-01-16 | Tama | Iowa | 19171 | 1856 | 57 |
931053 | 931053 | 2021-01-15 | Tama | Iowa | 19171 | 1853 | 57 |
927808 | 927808 | 2021-01-14 | Tama | Iowa | 19171 | 1847 | 57 |
924562 | 924562 | 2021-01-13 | Tama | Iowa | 19171 | 1841 | 57 |
921317 | 921317 | 2021-01-12 | Tama | Iowa | 19171 | 1833 | 57 |
918072 | 918072 | 2021-01-11 | Tama | Iowa | 19171 | 1831 | 57 |
914827 | 914827 | 2021-01-10 | Tama | Iowa | 19171 | 1828 | 57 |
911582 | 911582 | 2021-01-09 | Tama | Iowa | 19171 | 1827 | 57 |
908337 | 908337 | 2021-01-08 | Tama | Iowa | 19171 | 1823 | 57 |
905091 | 905091 | 2021-01-07 | Tama | Iowa | 19171 | 1817 | 57 |
901846 | 901846 | 2021-01-06 | Tama | Iowa | 19171 | 1807 | 57 |
898601 | 898601 | 2021-01-05 | Tama | Iowa | 19171 | 1792 | 56 |
895356 | 895356 | 2021-01-04 | Tama | Iowa | 19171 | 1784 | 56 |
892109 | 892109 | 2021-01-03 | Tama | Iowa | 19171 | 1766 | 56 |
888863 | 888863 | 2021-01-02 | Tama | Iowa | 19171 | 1764 | 56 |
885617 | 885617 | 2021-01-01 | Tama | Iowa | 19171 | 1762 | 55 |
882372 | 882372 | 2020-12-31 | Tama | Iowa | 19171 | 1756 | 55 |
879127 | 879127 | 2020-12-30 | Tama | Iowa | 19171 | 1751 | 55 |
875882 | 875882 | 2020-12-29 | Tama | Iowa | 19171 | 1748 | 55 |
872637 | 872637 | 2020-12-28 | Tama | Iowa | 19171 | 1743 | 55 |
869392 | 869392 | 2020-12-27 | Tama | Iowa | 19171 | 1739 | 55 |
866147 | 866147 | 2020-12-26 | Tama | Iowa | 19171 | 1739 | 55 |
862902 | 862902 | 2020-12-25 | Tama | Iowa | 19171 | 1733 | 55 |
859657 | 859657 | 2020-12-24 | Tama | Iowa | 19171 | 1726 | 55 |
856412 | 856412 | 2020-12-23 | Tama | Iowa | 19171 | 1715 | 55 |
853167 | 853167 | 2020-12-22 | Tama | Iowa | 19171 | 1708 | 55 |
849922 | 849922 | 2020-12-21 | Tama | Iowa | 19171 | 1703 | 55 |
846677 | 846677 | 2020-12-20 | Tama | Iowa | 19171 | 1698 | 55 |
843431 | 843431 | 2020-12-19 | Tama | Iowa | 19171 | 1691 | 55 |
840186 | 840186 | 2020-12-18 | Tama | Iowa | 19171 | 1679 | 55 |
836941 | 836941 | 2020-12-17 | Tama | Iowa | 19171 | 1663 | 55 |
833695 | 833695 | 2020-12-16 | Tama | Iowa | 19171 | 1649 | 55 |
830448 | 830448 | 2020-12-15 | Tama | Iowa | 19171 | 1633 | 55 |
827202 | 827202 | 2020-12-14 | Tama | Iowa | 19171 | 1630 | 55 |
823955 | 823955 | 2020-12-13 | Tama | Iowa | 19171 | 1629 | 55 |
820709 | 820709 | 2020-12-12 | Tama | Iowa | 19171 | 1623 | 55 |
817463 | 817463 | 2020-12-11 | Tama | Iowa | 19171 | 1618 | 55 |
814217 | 814217 | 2020-12-10 | Tama | Iowa | 19171 | 1604 | 55 |
810972 | 810972 | 2020-12-09 | Tama | Iowa | 19171 | 1598 | 55 |
807727 | 807727 | 2020-12-08 | Tama | Iowa | 19171 | 1591 | 54 |
804482 | 804482 | 2020-12-07 | Tama | Iowa | 19171 | 1591 | 42 |
801237 | 801237 | 2020-12-06 | Tama | Iowa | 19171 | 1589 | 42 |
797992 | 797992 | 2020-12-05 | Tama | Iowa | 19171 | 1584 | 42 |
794747 | 794747 | 2020-12-04 | Tama | Iowa | 19171 | 1580 | 42 |
791502 | 791502 | 2020-12-03 | Tama | Iowa | 19171 | 1574 | 42 |
788257 | 788257 | 2020-12-02 | Tama | Iowa | 19171 | 1566 | 41 |
785013 | 785013 | 2020-12-01 | Tama | Iowa | 19171 | 1562 | 40 |
781768 | 781768 | 2020-11-30 | Tama | Iowa | 19171 | 1549 | 40 |
778522 | 778522 | 2020-11-29 | Tama | Iowa | 19171 | 1543 | 40 |
775277 | 775277 | 2020-11-28 | Tama | Iowa | 19171 | 1538 | 40 |
772032 | 772032 | 2020-11-27 | Tama | Iowa | 19171 | 1533 | 40 |
768787 | 768787 | 2020-11-26 | Tama | Iowa | 19171 | 1522 | 40 |
765541 | 765541 | 2020-11-25 | Tama | Iowa | 19171 | 1515 | 40 |
762296 | 762296 | 2020-11-24 | Tama | Iowa | 19171 | 1494 | 40 |
759051 | 759051 | 2020-11-23 | Tama | Iowa | 19171 | 1463 | 40 |
755804 | 755804 | 2020-11-22 | Tama | Iowa | 19171 | 1451 | 40 |
752558 | 752558 | 2020-11-21 | Tama | Iowa | 19171 | 1445 | 40 |
749312 | 749312 | 2020-11-20 | Tama | Iowa | 19171 | 1432 | 39 |
746066 | 746066 | 2020-11-19 | Tama | Iowa | 19171 | 1409 | 39 |
742819 | 742819 | 2020-11-18 | Tama | Iowa | 19171 | 1388 | 39 |
739572 | 739572 | 2020-11-17 | Tama | Iowa | 19171 | 1366 | 39 |
736328 | 736328 | 2020-11-16 | Tama | Iowa | 19171 | 1358 | 39 |
733082 | 733082 | 2020-11-15 | Tama | Iowa | 19171 | 1338 | 39 |
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);