ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 19049 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947417 | 1947417 | 2021-11-24 | Dallas | Iowa | 19049 | 15367 | 113 |
1944166 | 1944166 | 2021-11-23 | Dallas | Iowa | 19049 | 15018 | 111 |
1940916 | 1940916 | 2021-11-22 | Dallas | Iowa | 19049 | 15018 | 111 |
1937666 | 1937666 | 2021-11-21 | Dallas | Iowa | 19049 | 15018 | 111 |
1934416 | 1934416 | 2021-11-20 | Dallas | Iowa | 19049 | 15018 | 111 |
1931165 | 1931165 | 2021-11-19 | Dallas | Iowa | 19049 | 15018 | 111 |
1927914 | 1927914 | 2021-11-18 | Dallas | Iowa | 19049 | 15018 | 111 |
1924664 | 1924664 | 2021-11-17 | Dallas | Iowa | 19049 | 15018 | 111 |
1921415 | 1921415 | 2021-11-16 | Dallas | Iowa | 19049 | 14767 | 109 |
1918165 | 1918165 | 2021-11-15 | Dallas | Iowa | 19049 | 14767 | 109 |
1914915 | 1914915 | 2021-11-14 | Dallas | Iowa | 19049 | 14767 | 109 |
1911665 | 1911665 | 2021-11-13 | Dallas | Iowa | 19049 | 14767 | 109 |
1908416 | 1908416 | 2021-11-12 | Dallas | Iowa | 19049 | 14767 | 109 |
1905167 | 1905167 | 2021-11-11 | Dallas | Iowa | 19049 | 14767 | 109 |
1901917 | 1901917 | 2021-11-10 | Dallas | Iowa | 19049 | 14767 | 109 |
1898667 | 1898667 | 2021-11-09 | Dallas | Iowa | 19049 | 14512 | 108 |
1895417 | 1895417 | 2021-11-08 | Dallas | Iowa | 19049 | 14512 | 108 |
1892167 | 1892167 | 2021-11-07 | Dallas | Iowa | 19049 | 14512 | 108 |
1888917 | 1888917 | 2021-11-06 | Dallas | Iowa | 19049 | 14512 | 108 |
1885667 | 1885667 | 2021-11-05 | Dallas | Iowa | 19049 | 14512 | 108 |
1882418 | 1882418 | 2021-11-04 | Dallas | Iowa | 19049 | 14512 | 108 |
1879169 | 1879169 | 2021-11-03 | Dallas | Iowa | 19049 | 14512 | 108 |
1875920 | 1875920 | 2021-11-02 | Dallas | Iowa | 19049 | 14289 | 108 |
1872671 | 1872671 | 2021-11-01 | Dallas | Iowa | 19049 | 14289 | 108 |
1869422 | 1869422 | 2021-10-31 | Dallas | Iowa | 19049 | 14289 | 108 |
1866173 | 1866173 | 2021-10-30 | Dallas | Iowa | 19049 | 14289 | 108 |
1862924 | 1862924 | 2021-10-29 | Dallas | Iowa | 19049 | 14289 | 108 |
1859675 | 1859675 | 2021-10-28 | Dallas | Iowa | 19049 | 14289 | 108 |
1856426 | 1856426 | 2021-10-27 | Dallas | Iowa | 19049 | 14289 | 108 |
1853177 | 1853177 | 2021-10-26 | Dallas | Iowa | 19049 | 14115 | 108 |
1849928 | 1849928 | 2021-10-25 | Dallas | Iowa | 19049 | 14115 | 108 |
1846678 | 1846678 | 2021-10-24 | Dallas | Iowa | 19049 | 14115 | 108 |
1843428 | 1843428 | 2021-10-23 | Dallas | Iowa | 19049 | 14115 | 108 |
1840178 | 1840178 | 2021-10-22 | Dallas | Iowa | 19049 | 14115 | 108 |
1836929 | 1836929 | 2021-10-21 | Dallas | Iowa | 19049 | 14115 | 108 |
1833680 | 1833680 | 2021-10-20 | Dallas | Iowa | 19049 | 14115 | 108 |
1830431 | 1830431 | 2021-10-19 | Dallas | Iowa | 19049 | 13904 | 107 |
1827182 | 1827182 | 2021-10-18 | Dallas | Iowa | 19049 | 13904 | 107 |
1823933 | 1823933 | 2021-10-17 | Dallas | Iowa | 19049 | 13904 | 107 |
1820684 | 1820684 | 2021-10-16 | Dallas | Iowa | 19049 | 13904 | 107 |
1817435 | 1817435 | 2021-10-15 | Dallas | Iowa | 19049 | 13904 | 107 |
1814187 | 1814187 | 2021-10-14 | Dallas | Iowa | 19049 | 13904 | 107 |
1810938 | 1810938 | 2021-10-13 | Dallas | Iowa | 19049 | 13904 | 107 |
1807689 | 1807689 | 2021-10-12 | Dallas | Iowa | 19049 | 13679 | 102 |
1804438 | 1804438 | 2021-10-11 | Dallas | Iowa | 19049 | 13679 | 102 |
1801189 | 1801189 | 2021-10-10 | Dallas | Iowa | 19049 | 13679 | 102 |
1797940 | 1797940 | 2021-10-09 | Dallas | Iowa | 19049 | 13679 | 102 |
1794691 | 1794691 | 2021-10-08 | Dallas | Iowa | 19049 | 13679 | 102 |
1791443 | 1791443 | 2021-10-07 | Dallas | Iowa | 19049 | 13679 | 102 |
1788194 | 1788194 | 2021-10-06 | Dallas | Iowa | 19049 | 13679 | 102 |
1784945 | 1784945 | 2021-10-05 | Dallas | Iowa | 19049 | 13384 | 102 |
1781696 | 1781696 | 2021-10-04 | Dallas | Iowa | 19049 | 13384 | 102 |
1778446 | 1778446 | 2021-10-03 | Dallas | Iowa | 19049 | 13384 | 102 |
1775196 | 1775196 | 2021-10-02 | Dallas | Iowa | 19049 | 13384 | 102 |
1771946 | 1771946 | 2021-10-01 | Dallas | Iowa | 19049 | 13384 | 102 |
1768697 | 1768697 | 2021-09-30 | Dallas | Iowa | 19049 | 13384 | 102 |
1765448 | 1765448 | 2021-09-29 | Dallas | Iowa | 19049 | 13384 | 102 |
1762199 | 1762199 | 2021-09-28 | Dallas | Iowa | 19049 | 13056 | 102 |
1758951 | 1758951 | 2021-09-27 | Dallas | Iowa | 19049 | 13056 | 102 |
1755703 | 1755703 | 2021-09-26 | Dallas | Iowa | 19049 | 13056 | 102 |
1752455 | 1752455 | 2021-09-25 | Dallas | Iowa | 19049 | 13056 | 102 |
1749206 | 1749206 | 2021-09-24 | Dallas | Iowa | 19049 | 13056 | 102 |
1745956 | 1745956 | 2021-09-23 | Dallas | Iowa | 19049 | 13056 | 102 |
1742707 | 1742707 | 2021-09-22 | Dallas | Iowa | 19049 | 13056 | 102 |
1739458 | 1739458 | 2021-09-21 | Dallas | Iowa | 19049 | 12760 | 102 |
1736209 | 1736209 | 2021-09-20 | Dallas | Iowa | 19049 | 12760 | 102 |
1732959 | 1732959 | 2021-09-19 | Dallas | Iowa | 19049 | 12760 | 102 |
1729709 | 1729709 | 2021-09-18 | Dallas | Iowa | 19049 | 12760 | 102 |
1726459 | 1726459 | 2021-09-17 | Dallas | Iowa | 19049 | 12760 | 102 |
1723210 | 1723210 | 2021-09-16 | Dallas | Iowa | 19049 | 12760 | 102 |
1719961 | 1719961 | 2021-09-15 | Dallas | Iowa | 19049 | 12760 | 102 |
1716713 | 1716713 | 2021-09-14 | Dallas | Iowa | 19049 | 12490 | 102 |
1713467 | 1713467 | 2021-09-13 | Dallas | Iowa | 19049 | 12490 | 102 |
1710220 | 1710220 | 2021-09-12 | Dallas | Iowa | 19049 | 12490 | 102 |
1706973 | 1706973 | 2021-09-11 | Dallas | Iowa | 19049 | 12490 | 102 |
1703725 | 1703725 | 2021-09-10 | Dallas | Iowa | 19049 | 12490 | 102 |
1700475 | 1700475 | 2021-09-09 | Dallas | Iowa | 19049 | 12490 | 102 |
1697226 | 1697226 | 2021-09-08 | Dallas | Iowa | 19049 | 12490 | 102 |
1693978 | 1693978 | 2021-09-07 | Dallas | Iowa | 19049 | 12293 | 102 |
1690729 | 1690729 | 2021-09-06 | Dallas | Iowa | 19049 | 12293 | 102 |
1687479 | 1687479 | 2021-09-05 | Dallas | Iowa | 19049 | 12293 | 102 |
1684229 | 1684229 | 2021-09-04 | Dallas | Iowa | 19049 | 12293 | 102 |
1680978 | 1680978 | 2021-09-03 | Dallas | Iowa | 19049 | 12293 | 102 |
1677730 | 1677730 | 2021-09-02 | Dallas | Iowa | 19049 | 12293 | 102 |
1674483 | 1674483 | 2021-09-01 | Dallas | Iowa | 19049 | 12293 | 102 |
1671234 | 1671234 | 2021-08-31 | Dallas | Iowa | 19049 | 12085 | 102 |
1667987 | 1667987 | 2021-08-30 | Dallas | Iowa | 19049 | 12085 | 102 |
1664740 | 1664740 | 2021-08-29 | Dallas | Iowa | 19049 | 12085 | 102 |
1661492 | 1661492 | 2021-08-28 | Dallas | Iowa | 19049 | 12085 | 102 |
1658244 | 1658244 | 2021-08-27 | Dallas | Iowa | 19049 | 12085 | 102 |
1654996 | 1654996 | 2021-08-26 | Dallas | Iowa | 19049 | 12085 | 102 |
1651749 | 1651749 | 2021-08-25 | Dallas | Iowa | 19049 | 12085 | 102 |
1648500 | 1648500 | 2021-08-24 | Dallas | Iowa | 19049 | 11905 | 101 |
1645252 | 1645252 | 2021-08-23 | Dallas | Iowa | 19049 | 11905 | 101 |
1642003 | 1642003 | 2021-08-22 | Dallas | Iowa | 19049 | 11905 | 101 |
1638753 | 1638753 | 2021-08-21 | Dallas | Iowa | 19049 | 11905 | 101 |
1635503 | 1635503 | 2021-08-20 | Dallas | Iowa | 19049 | 11905 | 101 |
1632253 | 1632253 | 2021-08-19 | Dallas | Iowa | 19049 | 11905 | 101 |
1629006 | 1629006 | 2021-08-18 | Dallas | Iowa | 19049 | 11905 | 101 |
1625759 | 1625759 | 2021-08-17 | Dallas | Iowa | 19049 | 11743 | 100 |
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);