ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Pottawattamie" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947470 | 1947470 | 2021-11-24 | Pottawattamie | Iowa | 19155 | 15909 | 213 |
1944219 | 1944219 | 2021-11-23 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1940969 | 1940969 | 2021-11-22 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1937719 | 1937719 | 2021-11-21 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1934469 | 1934469 | 2021-11-20 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1931218 | 1931218 | 2021-11-19 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1927967 | 1927967 | 2021-11-18 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1924717 | 1924717 | 2021-11-17 | Pottawattamie | Iowa | 19155 | 15456 | 211 |
1921468 | 1921468 | 2021-11-16 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1918218 | 1918218 | 2021-11-15 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1914968 | 1914968 | 2021-11-14 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1911718 | 1911718 | 2021-11-13 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1908469 | 1908469 | 2021-11-12 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1905220 | 1905220 | 2021-11-11 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1901970 | 1901970 | 2021-11-10 | Pottawattamie | Iowa | 19155 | 15176 | 208 |
1898720 | 1898720 | 2021-11-09 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1895470 | 1895470 | 2021-11-08 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1892220 | 1892220 | 2021-11-07 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1888970 | 1888970 | 2021-11-06 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1885720 | 1885720 | 2021-11-05 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1882471 | 1882471 | 2021-11-04 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1879222 | 1879222 | 2021-11-03 | Pottawattamie | Iowa | 19155 | 14847 | 205 |
1875973 | 1875973 | 2021-11-02 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1872724 | 1872724 | 2021-11-01 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1869475 | 1869475 | 2021-10-31 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1866226 | 1866226 | 2021-10-30 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1862977 | 1862977 | 2021-10-29 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1859728 | 1859728 | 2021-10-28 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1856479 | 1856479 | 2021-10-27 | Pottawattamie | Iowa | 19155 | 14666 | 202 |
1853230 | 1853230 | 2021-10-26 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1849981 | 1849981 | 2021-10-25 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1846731 | 1846731 | 2021-10-24 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1843481 | 1843481 | 2021-10-23 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1840231 | 1840231 | 2021-10-22 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1836982 | 1836982 | 2021-10-21 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1833733 | 1833733 | 2021-10-20 | Pottawattamie | Iowa | 19155 | 14276 | 200 |
1830484 | 1830484 | 2021-10-19 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1827235 | 1827235 | 2021-10-18 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1823986 | 1823986 | 2021-10-17 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1820737 | 1820737 | 2021-10-16 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1817488 | 1817488 | 2021-10-15 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1814240 | 1814240 | 2021-10-14 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1810991 | 1810991 | 2021-10-13 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1807742 | 1807742 | 2021-10-12 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1804491 | 1804491 | 2021-10-11 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1801242 | 1801242 | 2021-10-10 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1797993 | 1797993 | 2021-10-09 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1794744 | 1794744 | 2021-10-08 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1791496 | 1791496 | 2021-10-07 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1788247 | 1788247 | 2021-10-06 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1784998 | 1784998 | 2021-10-05 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1781749 | 1781749 | 2021-10-04 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1778499 | 1778499 | 2021-10-03 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1775249 | 1775249 | 2021-10-02 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1771999 | 1771999 | 2021-10-01 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1768750 | 1768750 | 2021-09-30 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1765501 | 1765501 | 2021-09-29 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1762252 | 1762252 | 2021-09-28 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1759004 | 1759004 | 2021-09-27 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1755756 | 1755756 | 2021-09-26 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1752508 | 1752508 | 2021-09-25 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1749259 | 1749259 | 2021-09-24 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1746009 | 1746009 | 2021-09-23 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1742760 | 1742760 | 2021-09-22 | Pottawattamie | Iowa | 19155 | 13371 | 186 |
1739511 | 1739511 | 2021-09-21 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1736262 | 1736262 | 2021-09-20 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1733012 | 1733012 | 2021-09-19 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1729762 | 1729762 | 2021-09-18 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1726512 | 1726512 | 2021-09-17 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1723263 | 1723263 | 2021-09-16 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1720014 | 1720014 | 2021-09-15 | Pottawattamie | Iowa | 19155 | 13059 | 183 |
1716766 | 1716766 | 2021-09-14 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1713520 | 1713520 | 2021-09-13 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1710273 | 1710273 | 2021-09-12 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1707026 | 1707026 | 2021-09-11 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1703778 | 1703778 | 2021-09-10 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1700528 | 1700528 | 2021-09-09 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1697279 | 1697279 | 2021-09-08 | Pottawattamie | Iowa | 19155 | 12714 | 182 |
1694031 | 1694031 | 2021-09-07 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1690782 | 1690782 | 2021-09-06 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1687532 | 1687532 | 2021-09-05 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1684282 | 1684282 | 2021-09-04 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1681031 | 1681031 | 2021-09-03 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1677783 | 1677783 | 2021-09-02 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1674536 | 1674536 | 2021-09-01 | Pottawattamie | Iowa | 19155 | 12473 | 180 |
1671287 | 1671287 | 2021-08-31 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1668040 | 1668040 | 2021-08-30 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1664793 | 1664793 | 2021-08-29 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1661545 | 1661545 | 2021-08-28 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1658297 | 1658297 | 2021-08-27 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1655049 | 1655049 | 2021-08-26 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1651802 | 1651802 | 2021-08-25 | Pottawattamie | Iowa | 19155 | 12196 | 179 |
1648553 | 1648553 | 2021-08-24 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1645305 | 1645305 | 2021-08-23 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1642056 | 1642056 | 2021-08-22 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1638806 | 1638806 | 2021-08-21 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1635556 | 1635556 | 2021-08-20 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1632306 | 1632306 | 2021-08-19 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1629059 | 1629059 | 2021-08-18 | Pottawattamie | Iowa | 19155 | 11921 | 178 |
1625812 | 1625812 | 2021-08-17 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
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);