ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Tama" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110011 | 2110011 | 2022-01-13 | Tama | Iowa | 19171 | 3311 | 81 |
2106760 | 2106760 | 2022-01-12 | Tama | Iowa | 19171 | 3311 | 81 |
2103509 | 2103509 | 2022-01-11 | Tama | Iowa | 19171 | 3147 | 80 |
2100258 | 2100258 | 2022-01-10 | Tama | Iowa | 19171 | 3147 | 80 |
2097007 | 2097007 | 2022-01-09 | Tama | Iowa | 19171 | 3147 | 80 |
2093755 | 2093755 | 2022-01-08 | Tama | Iowa | 19171 | 3147 | 80 |
2090503 | 2090503 | 2022-01-07 | Tama | Iowa | 19171 | 3147 | 80 |
2087252 | 2087252 | 2022-01-06 | Tama | Iowa | 19171 | 3147 | 80 |
2084000 | 2084000 | 2022-01-05 | Tama | Iowa | 19171 | 3147 | 80 |
2080748 | 2080748 | 2022-01-04 | Tama | Iowa | 19171 | 3066 | 80 |
2077496 | 2077496 | 2022-01-03 | Tama | Iowa | 19171 | 3066 | 80 |
2074245 | 2074245 | 2022-01-02 | Tama | Iowa | 19171 | 3066 | 80 |
2070994 | 2070994 | 2022-01-01 | Tama | Iowa | 19171 | 3066 | 80 |
2067743 | 2067743 | 2021-12-31 | Tama | Iowa | 19171 | 3066 | 80 |
2064492 | 2064492 | 2021-12-30 | Tama | Iowa | 19171 | 3066 | 80 |
2061242 | 2061242 | 2021-12-29 | Tama | Iowa | 19171 | 3066 | 80 |
2057993 | 2057993 | 2021-12-28 | Tama | Iowa | 19171 | 3008 | 80 |
2054744 | 2054744 | 2021-12-27 | Tama | Iowa | 19171 | 3008 | 80 |
2051494 | 2051494 | 2021-12-26 | Tama | Iowa | 19171 | 3008 | 80 |
2048244 | 2048244 | 2021-12-25 | Tama | Iowa | 19171 | 3008 | 80 |
2044994 | 2044994 | 2021-12-24 | Tama | Iowa | 19171 | 3008 | 80 |
2041745 | 2041745 | 2021-12-23 | Tama | Iowa | 19171 | 3008 | 80 |
2038495 | 2038495 | 2021-12-22 | Tama | Iowa | 19171 | 3008 | 80 |
2035245 | 2035245 | 2021-12-21 | Tama | Iowa | 19171 | 2958 | 78 |
2031995 | 2031995 | 2021-12-20 | Tama | Iowa | 19171 | 2958 | 78 |
2028744 | 2028744 | 2021-12-19 | Tama | Iowa | 19171 | 2958 | 78 |
2025493 | 2025493 | 2021-12-18 | Tama | Iowa | 19171 | 2958 | 78 |
2022242 | 2022242 | 2021-12-17 | Tama | Iowa | 19171 | 2958 | 78 |
2018991 | 2018991 | 2021-12-16 | Tama | Iowa | 19171 | 2958 | 78 |
2015741 | 2015741 | 2021-12-15 | Tama | Iowa | 19171 | 2958 | 78 |
2012490 | 2012490 | 2021-12-14 | Tama | Iowa | 19171 | 2891 | 78 |
2009239 | 2009239 | 2021-12-13 | Tama | Iowa | 19171 | 2891 | 78 |
2005988 | 2005988 | 2021-12-12 | Tama | Iowa | 19171 | 2891 | 78 |
2002737 | 2002737 | 2021-12-11 | Tama | Iowa | 19171 | 2891 | 78 |
1999487 | 1999487 | 2021-12-10 | Tama | Iowa | 19171 | 2891 | 78 |
1996236 | 1996236 | 2021-12-09 | Tama | Iowa | 19171 | 2891 | 78 |
1992985 | 1992985 | 2021-12-08 | Tama | Iowa | 19171 | 2891 | 78 |
1989734 | 1989734 | 2021-12-07 | Tama | Iowa | 19171 | 2837 | 78 |
1986484 | 1986484 | 2021-12-06 | Tama | Iowa | 19171 | 2837 | 78 |
1983234 | 1983234 | 2021-12-05 | Tama | Iowa | 19171 | 2837 | 78 |
1979984 | 1979984 | 2021-12-04 | Tama | Iowa | 19171 | 2837 | 78 |
1976734 | 1976734 | 2021-12-03 | Tama | Iowa | 19171 | 2837 | 78 |
1973485 | 1973485 | 2021-12-02 | Tama | Iowa | 19171 | 2837 | 78 |
1970235 | 1970235 | 2021-12-01 | Tama | Iowa | 19171 | 2837 | 78 |
1966985 | 1966985 | 2021-11-30 | Tama | Iowa | 19171 | 2804 | 77 |
1963733 | 1963733 | 2021-11-29 | Tama | Iowa | 19171 | 2804 | 77 |
1960482 | 1960482 | 2021-11-28 | Tama | Iowa | 19171 | 2804 | 77 |
1957231 | 1957231 | 2021-11-27 | Tama | Iowa | 19171 | 2804 | 77 |
1953980 | 1953980 | 2021-11-26 | Tama | Iowa | 19171 | 2804 | 77 |
1950729 | 1950729 | 2021-11-25 | Tama | Iowa | 19171 | 2804 | 77 |
1947478 | 1947478 | 2021-11-24 | Tama | Iowa | 19171 | 2804 | 77 |
1944227 | 1944227 | 2021-11-23 | Tama | Iowa | 19171 | 2766 | 77 |
1940977 | 1940977 | 2021-11-22 | Tama | Iowa | 19171 | 2766 | 77 |
1937727 | 1937727 | 2021-11-21 | Tama | Iowa | 19171 | 2766 | 77 |
1934477 | 1934477 | 2021-11-20 | Tama | Iowa | 19171 | 2766 | 77 |
1931226 | 1931226 | 2021-11-19 | Tama | Iowa | 19171 | 2766 | 77 |
1927975 | 1927975 | 2021-11-18 | Tama | Iowa | 19171 | 2766 | 77 |
1924725 | 1924725 | 2021-11-17 | Tama | Iowa | 19171 | 2766 | 77 |
1921476 | 1921476 | 2021-11-16 | Tama | Iowa | 19171 | 2736 | 77 |
1918226 | 1918226 | 2021-11-15 | Tama | Iowa | 19171 | 2736 | 77 |
1914976 | 1914976 | 2021-11-14 | Tama | Iowa | 19171 | 2736 | 77 |
1911726 | 1911726 | 2021-11-13 | Tama | Iowa | 19171 | 2736 | 77 |
1908477 | 1908477 | 2021-11-12 | Tama | Iowa | 19171 | 2736 | 77 |
1905228 | 1905228 | 2021-11-11 | Tama | Iowa | 19171 | 2736 | 77 |
1901978 | 1901978 | 2021-11-10 | Tama | Iowa | 19171 | 2736 | 77 |
1898728 | 1898728 | 2021-11-09 | Tama | Iowa | 19171 | 2710 | 77 |
1895478 | 1895478 | 2021-11-08 | Tama | Iowa | 19171 | 2710 | 77 |
1892228 | 1892228 | 2021-11-07 | Tama | Iowa | 19171 | 2710 | 77 |
1888978 | 1888978 | 2021-11-06 | Tama | Iowa | 19171 | 2710 | 77 |
1885728 | 1885728 | 2021-11-05 | Tama | Iowa | 19171 | 2710 | 77 |
1882479 | 1882479 | 2021-11-04 | Tama | Iowa | 19171 | 2710 | 77 |
1879230 | 1879230 | 2021-11-03 | Tama | Iowa | 19171 | 2710 | 77 |
1875981 | 1875981 | 2021-11-02 | Tama | Iowa | 19171 | 2671 | 76 |
1872732 | 1872732 | 2021-11-01 | Tama | Iowa | 19171 | 2671 | 76 |
1869483 | 1869483 | 2021-10-31 | Tama | Iowa | 19171 | 2671 | 76 |
1866234 | 1866234 | 2021-10-30 | Tama | Iowa | 19171 | 2671 | 76 |
1862985 | 1862985 | 2021-10-29 | Tama | Iowa | 19171 | 2671 | 76 |
1859736 | 1859736 | 2021-10-28 | Tama | Iowa | 19171 | 2671 | 76 |
1856487 | 1856487 | 2021-10-27 | Tama | Iowa | 19171 | 2671 | 76 |
1853238 | 1853238 | 2021-10-26 | Tama | Iowa | 19171 | 2650 | 76 |
1849989 | 1849989 | 2021-10-25 | Tama | Iowa | 19171 | 2650 | 76 |
1846739 | 1846739 | 2021-10-24 | Tama | Iowa | 19171 | 2650 | 76 |
1843489 | 1843489 | 2021-10-23 | Tama | Iowa | 19171 | 2650 | 76 |
1840239 | 1840239 | 2021-10-22 | Tama | Iowa | 19171 | 2650 | 76 |
1836990 | 1836990 | 2021-10-21 | Tama | Iowa | 19171 | 2650 | 76 |
1833741 | 1833741 | 2021-10-20 | Tama | Iowa | 19171 | 2650 | 76 |
1830492 | 1830492 | 2021-10-19 | Tama | Iowa | 19171 | 2614 | 76 |
1827243 | 1827243 | 2021-10-18 | Tama | Iowa | 19171 | 2614 | 76 |
1823994 | 1823994 | 2021-10-17 | Tama | Iowa | 19171 | 2614 | 76 |
1820745 | 1820745 | 2021-10-16 | Tama | Iowa | 19171 | 2614 | 76 |
1817496 | 1817496 | 2021-10-15 | Tama | Iowa | 19171 | 2614 | 76 |
1814248 | 1814248 | 2021-10-14 | Tama | Iowa | 19171 | 2614 | 76 |
1810999 | 1810999 | 2021-10-13 | Tama | Iowa | 19171 | 2614 | 76 |
1807750 | 1807750 | 2021-10-12 | Tama | Iowa | 19171 | 2586 | 75 |
1804499 | 1804499 | 2021-10-11 | Tama | Iowa | 19171 | 2586 | 75 |
1801250 | 1801250 | 2021-10-10 | Tama | Iowa | 19171 | 2586 | 75 |
1798001 | 1798001 | 2021-10-09 | Tama | Iowa | 19171 | 2586 | 75 |
1794752 | 1794752 | 2021-10-08 | Tama | Iowa | 19171 | 2586 | 75 |
1791504 | 1791504 | 2021-10-07 | Tama | Iowa | 19171 | 2586 | 75 |
1788255 | 1788255 | 2021-10-06 | Tama | Iowa | 19171 | 2586 | 75 |
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);