ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Franklin", fips = 19069 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175026 | 2175026 | 2022-02-02 | Franklin | Iowa | 19069 | 2395 | 39 |
2171773 | 2171773 | 2022-02-01 | Franklin | Iowa | 19069 | 2352 | 38 |
2168520 | 2168520 | 2022-01-31 | Franklin | Iowa | 19069 | 2352 | 38 |
2165265 | 2165265 | 2022-01-30 | Franklin | Iowa | 19069 | 2352 | 38 |
2162010 | 2162010 | 2022-01-29 | Franklin | Iowa | 19069 | 2352 | 38 |
2158755 | 2158755 | 2022-01-28 | Franklin | Iowa | 19069 | 2352 | 38 |
2155501 | 2155501 | 2022-01-27 | Franklin | Iowa | 19069 | 2352 | 38 |
2152248 | 2152248 | 2022-01-26 | Franklin | Iowa | 19069 | 2352 | 38 |
2148996 | 2148996 | 2022-01-25 | Franklin | Iowa | 19069 | 2261 | 36 |
2145744 | 2145744 | 2022-01-24 | Franklin | Iowa | 19069 | 2261 | 36 |
2142489 | 2142489 | 2022-01-23 | Franklin | Iowa | 19069 | 2261 | 36 |
2139234 | 2139234 | 2022-01-22 | Franklin | Iowa | 19069 | 2261 | 36 |
2135978 | 2135978 | 2022-01-21 | Franklin | Iowa | 19069 | 2261 | 36 |
2132726 | 2132726 | 2022-01-20 | Franklin | Iowa | 19069 | 2261 | 36 |
2129473 | 2129473 | 2022-01-19 | Franklin | Iowa | 19069 | 2261 | 36 |
2126219 | 2126219 | 2022-01-18 | Franklin | Iowa | 19069 | 2131 | 35 |
2122967 | 2122967 | 2022-01-17 | Franklin | Iowa | 19069 | 2131 | 35 |
2119715 | 2119715 | 2022-01-16 | Franklin | Iowa | 19069 | 2131 | 35 |
2116463 | 2116463 | 2022-01-15 | Franklin | Iowa | 19069 | 2131 | 35 |
2113212 | 2113212 | 2022-01-14 | Franklin | Iowa | 19069 | 2131 | 35 |
2109960 | 2109960 | 2022-01-13 | Franklin | Iowa | 19069 | 2131 | 35 |
2106709 | 2106709 | 2022-01-12 | Franklin | Iowa | 19069 | 2131 | 35 |
2103458 | 2103458 | 2022-01-11 | Franklin | Iowa | 19069 | 2035 | 35 |
2100207 | 2100207 | 2022-01-10 | Franklin | Iowa | 19069 | 2035 | 35 |
2096956 | 2096956 | 2022-01-09 | Franklin | Iowa | 19069 | 2035 | 35 |
2093704 | 2093704 | 2022-01-08 | Franklin | Iowa | 19069 | 2035 | 35 |
2090452 | 2090452 | 2022-01-07 | Franklin | Iowa | 19069 | 2035 | 35 |
2087201 | 2087201 | 2022-01-06 | Franklin | Iowa | 19069 | 2035 | 35 |
2083949 | 2083949 | 2022-01-05 | Franklin | Iowa | 19069 | 2035 | 35 |
2080697 | 2080697 | 2022-01-04 | Franklin | Iowa | 19069 | 2003 | 35 |
2077445 | 2077445 | 2022-01-03 | Franklin | Iowa | 19069 | 2003 | 35 |
2074194 | 2074194 | 2022-01-02 | Franklin | Iowa | 19069 | 2003 | 35 |
2070943 | 2070943 | 2022-01-01 | Franklin | Iowa | 19069 | 2003 | 35 |
2067692 | 2067692 | 2021-12-31 | Franklin | Iowa | 19069 | 2003 | 35 |
2064441 | 2064441 | 2021-12-30 | Franklin | Iowa | 19069 | 2003 | 35 |
2061191 | 2061191 | 2021-12-29 | Franklin | Iowa | 19069 | 2003 | 35 |
2057942 | 2057942 | 2021-12-28 | Franklin | Iowa | 19069 | 1974 | 35 |
2054693 | 2054693 | 2021-12-27 | Franklin | Iowa | 19069 | 1974 | 35 |
2051443 | 2051443 | 2021-12-26 | Franklin | Iowa | 19069 | 1974 | 35 |
2048193 | 2048193 | 2021-12-25 | Franklin | Iowa | 19069 | 1974 | 35 |
2044943 | 2044943 | 2021-12-24 | Franklin | Iowa | 19069 | 1974 | 35 |
2041694 | 2041694 | 2021-12-23 | Franklin | Iowa | 19069 | 1974 | 35 |
2038444 | 2038444 | 2021-12-22 | Franklin | Iowa | 19069 | 1974 | 35 |
2035194 | 2035194 | 2021-12-21 | Franklin | Iowa | 19069 | 1958 | 34 |
2031944 | 2031944 | 2021-12-20 | Franklin | Iowa | 19069 | 1958 | 34 |
2028693 | 2028693 | 2021-12-19 | Franklin | Iowa | 19069 | 1958 | 34 |
2025442 | 2025442 | 2021-12-18 | Franklin | Iowa | 19069 | 1958 | 34 |
2022191 | 2022191 | 2021-12-17 | Franklin | Iowa | 19069 | 1958 | 34 |
2018940 | 2018940 | 2021-12-16 | Franklin | Iowa | 19069 | 1958 | 34 |
2015690 | 2015690 | 2021-12-15 | Franklin | Iowa | 19069 | 1958 | 34 |
2012439 | 2012439 | 2021-12-14 | Franklin | Iowa | 19069 | 1926 | 32 |
2009188 | 2009188 | 2021-12-13 | Franklin | Iowa | 19069 | 1926 | 32 |
2005937 | 2005937 | 2021-12-12 | Franklin | Iowa | 19069 | 1926 | 32 |
2002686 | 2002686 | 2021-12-11 | Franklin | Iowa | 19069 | 1926 | 32 |
1999436 | 1999436 | 2021-12-10 | Franklin | Iowa | 19069 | 1926 | 32 |
1996185 | 1996185 | 2021-12-09 | Franklin | Iowa | 19069 | 1926 | 32 |
1992934 | 1992934 | 2021-12-08 | Franklin | Iowa | 19069 | 1926 | 32 |
1989683 | 1989683 | 2021-12-07 | Franklin | Iowa | 19069 | 1884 | 31 |
1986433 | 1986433 | 2021-12-06 | Franklin | Iowa | 19069 | 1884 | 31 |
1983183 | 1983183 | 2021-12-05 | Franklin | Iowa | 19069 | 1884 | 31 |
1979933 | 1979933 | 2021-12-04 | Franklin | Iowa | 19069 | 1884 | 31 |
1976683 | 1976683 | 2021-12-03 | Franklin | Iowa | 19069 | 1884 | 31 |
1973434 | 1973434 | 2021-12-02 | Franklin | Iowa | 19069 | 1884 | 31 |
1970184 | 1970184 | 2021-12-01 | Franklin | Iowa | 19069 | 1884 | 31 |
1966934 | 1966934 | 2021-11-30 | Franklin | Iowa | 19069 | 1839 | 29 |
1963682 | 1963682 | 2021-11-29 | Franklin | Iowa | 19069 | 1839 | 29 |
1960431 | 1960431 | 2021-11-28 | Franklin | Iowa | 19069 | 1839 | 29 |
1957180 | 1957180 | 2021-11-27 | Franklin | Iowa | 19069 | 1839 | 29 |
1953929 | 1953929 | 2021-11-26 | Franklin | Iowa | 19069 | 1839 | 29 |
1950678 | 1950678 | 2021-11-25 | Franklin | Iowa | 19069 | 1839 | 29 |
1947427 | 1947427 | 2021-11-24 | Franklin | Iowa | 19069 | 1839 | 29 |
1944176 | 1944176 | 2021-11-23 | Franklin | Iowa | 19069 | 1779 | 29 |
1940926 | 1940926 | 2021-11-22 | Franklin | Iowa | 19069 | 1779 | 29 |
1937676 | 1937676 | 2021-11-21 | Franklin | Iowa | 19069 | 1779 | 29 |
1934426 | 1934426 | 2021-11-20 | Franklin | Iowa | 19069 | 1779 | 29 |
1931175 | 1931175 | 2021-11-19 | Franklin | Iowa | 19069 | 1779 | 29 |
1927924 | 1927924 | 2021-11-18 | Franklin | Iowa | 19069 | 1779 | 29 |
1924674 | 1924674 | 2021-11-17 | Franklin | Iowa | 19069 | 1779 | 29 |
1921425 | 1921425 | 2021-11-16 | Franklin | Iowa | 19069 | 1723 | 29 |
1918175 | 1918175 | 2021-11-15 | Franklin | Iowa | 19069 | 1723 | 29 |
1914925 | 1914925 | 2021-11-14 | Franklin | Iowa | 19069 | 1723 | 29 |
1911675 | 1911675 | 2021-11-13 | Franklin | Iowa | 19069 | 1723 | 29 |
1908426 | 1908426 | 2021-11-12 | Franklin | Iowa | 19069 | 1723 | 29 |
1905177 | 1905177 | 2021-11-11 | Franklin | Iowa | 19069 | 1723 | 29 |
1901927 | 1901927 | 2021-11-10 | Franklin | Iowa | 19069 | 1723 | 29 |
1898677 | 1898677 | 2021-11-09 | Franklin | Iowa | 19069 | 1687 | 28 |
1895427 | 1895427 | 2021-11-08 | Franklin | Iowa | 19069 | 1687 | 28 |
1892177 | 1892177 | 2021-11-07 | Franklin | Iowa | 19069 | 1687 | 28 |
1888927 | 1888927 | 2021-11-06 | Franklin | Iowa | 19069 | 1687 | 28 |
1885677 | 1885677 | 2021-11-05 | Franklin | Iowa | 19069 | 1687 | 28 |
1882428 | 1882428 | 2021-11-04 | Franklin | Iowa | 19069 | 1687 | 28 |
1879179 | 1879179 | 2021-11-03 | Franklin | Iowa | 19069 | 1687 | 28 |
1875930 | 1875930 | 2021-11-02 | Franklin | Iowa | 19069 | 1669 | 28 |
1872681 | 1872681 | 2021-11-01 | Franklin | Iowa | 19069 | 1669 | 28 |
1869432 | 1869432 | 2021-10-31 | Franklin | Iowa | 19069 | 1669 | 28 |
1866183 | 1866183 | 2021-10-30 | Franklin | Iowa | 19069 | 1669 | 28 |
1862934 | 1862934 | 2021-10-29 | Franklin | Iowa | 19069 | 1669 | 28 |
1859685 | 1859685 | 2021-10-28 | Franklin | Iowa | 19069 | 1669 | 28 |
1856436 | 1856436 | 2021-10-27 | Franklin | Iowa | 19069 | 1669 | 28 |
1853187 | 1853187 | 2021-10-26 | Franklin | Iowa | 19069 | 1647 | 28 |
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);