ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 19103 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109977 | 2109977 | 2022-01-13 | Johnson | Iowa | 19103 | 26588 | 119 |
2106726 | 2106726 | 2022-01-12 | Johnson | Iowa | 19103 | 26588 | 119 |
2103475 | 2103475 | 2022-01-11 | Johnson | Iowa | 19103 | 24040 | 118 |
2100224 | 2100224 | 2022-01-10 | Johnson | Iowa | 19103 | 24040 | 118 |
2096973 | 2096973 | 2022-01-09 | Johnson | Iowa | 19103 | 24040 | 118 |
2093721 | 2093721 | 2022-01-08 | Johnson | Iowa | 19103 | 24040 | 118 |
2090469 | 2090469 | 2022-01-07 | Johnson | Iowa | 19103 | 24040 | 118 |
2087218 | 2087218 | 2022-01-06 | Johnson | Iowa | 19103 | 24040 | 118 |
2083966 | 2083966 | 2022-01-05 | Johnson | Iowa | 19103 | 24040 | 118 |
2080714 | 2080714 | 2022-01-04 | Johnson | Iowa | 19103 | 22358 | 116 |
2077462 | 2077462 | 2022-01-03 | Johnson | Iowa | 19103 | 22358 | 116 |
2074211 | 2074211 | 2022-01-02 | Johnson | Iowa | 19103 | 22358 | 116 |
2070960 | 2070960 | 2022-01-01 | Johnson | Iowa | 19103 | 22358 | 116 |
2067709 | 2067709 | 2021-12-31 | Johnson | Iowa | 19103 | 22358 | 116 |
2064458 | 2064458 | 2021-12-30 | Johnson | Iowa | 19103 | 22358 | 116 |
2061208 | 2061208 | 2021-12-29 | Johnson | Iowa | 19103 | 22358 | 116 |
2057959 | 2057959 | 2021-12-28 | Johnson | Iowa | 19103 | 21585 | 116 |
2054710 | 2054710 | 2021-12-27 | Johnson | Iowa | 19103 | 21585 | 116 |
2051460 | 2051460 | 2021-12-26 | Johnson | Iowa | 19103 | 21585 | 116 |
2048210 | 2048210 | 2021-12-25 | Johnson | Iowa | 19103 | 21585 | 116 |
2044960 | 2044960 | 2021-12-24 | Johnson | Iowa | 19103 | 21585 | 116 |
2041711 | 2041711 | 2021-12-23 | Johnson | Iowa | 19103 | 21585 | 116 |
2038461 | 2038461 | 2021-12-22 | Johnson | Iowa | 19103 | 21585 | 116 |
2035211 | 2035211 | 2021-12-21 | Johnson | Iowa | 19103 | 21083 | 111 |
2031961 | 2031961 | 2021-12-20 | Johnson | Iowa | 19103 | 21083 | 111 |
2028710 | 2028710 | 2021-12-19 | Johnson | Iowa | 19103 | 21083 | 111 |
2025459 | 2025459 | 2021-12-18 | Johnson | Iowa | 19103 | 21083 | 111 |
2022208 | 2022208 | 2021-12-17 | Johnson | Iowa | 19103 | 21083 | 111 |
2018957 | 2018957 | 2021-12-16 | Johnson | Iowa | 19103 | 21083 | 111 |
2015707 | 2015707 | 2021-12-15 | Johnson | Iowa | 19103 | 21083 | 111 |
2012456 | 2012456 | 2021-12-14 | Johnson | Iowa | 19103 | 20664 | 108 |
2009205 | 2009205 | 2021-12-13 | Johnson | Iowa | 19103 | 20664 | 108 |
2005954 | 2005954 | 2021-12-12 | Johnson | Iowa | 19103 | 20664 | 108 |
2002703 | 2002703 | 2021-12-11 | Johnson | Iowa | 19103 | 20664 | 108 |
1999453 | 1999453 | 2021-12-10 | Johnson | Iowa | 19103 | 20664 | 108 |
1996202 | 1996202 | 2021-12-09 | Johnson | Iowa | 19103 | 20664 | 108 |
1992951 | 1992951 | 2021-12-08 | Johnson | Iowa | 19103 | 20664 | 108 |
1989700 | 1989700 | 2021-12-07 | Johnson | Iowa | 19103 | 20215 | 108 |
1986450 | 1986450 | 2021-12-06 | Johnson | Iowa | 19103 | 20215 | 108 |
1983200 | 1983200 | 2021-12-05 | Johnson | Iowa | 19103 | 20215 | 108 |
1979950 | 1979950 | 2021-12-04 | Johnson | Iowa | 19103 | 20215 | 108 |
1976700 | 1976700 | 2021-12-03 | Johnson | Iowa | 19103 | 20215 | 108 |
1973451 | 1973451 | 2021-12-02 | Johnson | Iowa | 19103 | 20215 | 108 |
1970201 | 1970201 | 2021-12-01 | Johnson | Iowa | 19103 | 20215 | 108 |
1966951 | 1966951 | 2021-11-30 | Johnson | Iowa | 19103 | 19840 | 105 |
1963699 | 1963699 | 2021-11-29 | Johnson | Iowa | 19103 | 19840 | 105 |
1960448 | 1960448 | 2021-11-28 | Johnson | Iowa | 19103 | 19840 | 105 |
1957197 | 1957197 | 2021-11-27 | Johnson | Iowa | 19103 | 19840 | 105 |
1953946 | 1953946 | 2021-11-26 | Johnson | Iowa | 19103 | 19840 | 105 |
1950695 | 1950695 | 2021-11-25 | Johnson | Iowa | 19103 | 19840 | 105 |
1947444 | 1947444 | 2021-11-24 | Johnson | Iowa | 19103 | 19840 | 105 |
1944193 | 1944193 | 2021-11-23 | Johnson | Iowa | 19103 | 19309 | 105 |
1940943 | 1940943 | 2021-11-22 | Johnson | Iowa | 19103 | 19309 | 105 |
1937693 | 1937693 | 2021-11-21 | Johnson | Iowa | 19103 | 19309 | 105 |
1934443 | 1934443 | 2021-11-20 | Johnson | Iowa | 19103 | 19309 | 105 |
1931192 | 1931192 | 2021-11-19 | Johnson | Iowa | 19103 | 19309 | 105 |
1927941 | 1927941 | 2021-11-18 | Johnson | Iowa | 19103 | 19309 | 105 |
1924691 | 1924691 | 2021-11-17 | Johnson | Iowa | 19103 | 19309 | 105 |
1921442 | 1921442 | 2021-11-16 | Johnson | Iowa | 19103 | 18877 | 103 |
1918192 | 1918192 | 2021-11-15 | Johnson | Iowa | 19103 | 18877 | 103 |
1914942 | 1914942 | 2021-11-14 | Johnson | Iowa | 19103 | 18877 | 103 |
1911692 | 1911692 | 2021-11-13 | Johnson | Iowa | 19103 | 18877 | 103 |
1908443 | 1908443 | 2021-11-12 | Johnson | Iowa | 19103 | 18877 | 103 |
1905194 | 1905194 | 2021-11-11 | Johnson | Iowa | 19103 | 18877 | 103 |
1901944 | 1901944 | 2021-11-10 | Johnson | Iowa | 19103 | 18877 | 103 |
1898694 | 1898694 | 2021-11-09 | Johnson | Iowa | 19103 | 18461 | 101 |
1895444 | 1895444 | 2021-11-08 | Johnson | Iowa | 19103 | 18461 | 101 |
1892194 | 1892194 | 2021-11-07 | Johnson | Iowa | 19103 | 18461 | 101 |
1888944 | 1888944 | 2021-11-06 | Johnson | Iowa | 19103 | 18461 | 101 |
1885694 | 1885694 | 2021-11-05 | Johnson | Iowa | 19103 | 18461 | 101 |
1882445 | 1882445 | 2021-11-04 | Johnson | Iowa | 19103 | 18461 | 101 |
1879196 | 1879196 | 2021-11-03 | Johnson | Iowa | 19103 | 18461 | 101 |
1875947 | 1875947 | 2021-11-02 | Johnson | Iowa | 19103 | 18184 | 101 |
1872698 | 1872698 | 2021-11-01 | Johnson | Iowa | 19103 | 18184 | 101 |
1869449 | 1869449 | 2021-10-31 | Johnson | Iowa | 19103 | 18184 | 101 |
1866200 | 1866200 | 2021-10-30 | Johnson | Iowa | 19103 | 18184 | 101 |
1862951 | 1862951 | 2021-10-29 | Johnson | Iowa | 19103 | 18184 | 101 |
1859702 | 1859702 | 2021-10-28 | Johnson | Iowa | 19103 | 18184 | 101 |
1856453 | 1856453 | 2021-10-27 | Johnson | Iowa | 19103 | 18184 | 101 |
1853204 | 1853204 | 2021-10-26 | Johnson | Iowa | 19103 | 18003 | 100 |
1849955 | 1849955 | 2021-10-25 | Johnson | Iowa | 19103 | 18003 | 100 |
1846705 | 1846705 | 2021-10-24 | Johnson | Iowa | 19103 | 18003 | 100 |
1843455 | 1843455 | 2021-10-23 | Johnson | Iowa | 19103 | 18003 | 100 |
1840205 | 1840205 | 2021-10-22 | Johnson | Iowa | 19103 | 18003 | 100 |
1836956 | 1836956 | 2021-10-21 | Johnson | Iowa | 19103 | 18003 | 100 |
1833707 | 1833707 | 2021-10-20 | Johnson | Iowa | 19103 | 18003 | 100 |
1830458 | 1830458 | 2021-10-19 | Johnson | Iowa | 19103 | 17809 | 100 |
1827209 | 1827209 | 2021-10-18 | Johnson | Iowa | 19103 | 17809 | 100 |
1823960 | 1823960 | 2021-10-17 | Johnson | Iowa | 19103 | 17809 | 100 |
1820711 | 1820711 | 2021-10-16 | Johnson | Iowa | 19103 | 17809 | 100 |
1817462 | 1817462 | 2021-10-15 | Johnson | Iowa | 19103 | 17809 | 100 |
1814214 | 1814214 | 2021-10-14 | Johnson | Iowa | 19103 | 17809 | 100 |
1810965 | 1810965 | 2021-10-13 | Johnson | Iowa | 19103 | 17809 | 100 |
1807716 | 1807716 | 2021-10-12 | Johnson | Iowa | 19103 | 17624 | 98 |
1804465 | 1804465 | 2021-10-11 | Johnson | Iowa | 19103 | 17624 | 98 |
1801216 | 1801216 | 2021-10-10 | Johnson | Iowa | 19103 | 17624 | 98 |
1797967 | 1797967 | 2021-10-09 | Johnson | Iowa | 19103 | 17624 | 98 |
1794718 | 1794718 | 2021-10-08 | Johnson | Iowa | 19103 | 17624 | 98 |
1791470 | 1791470 | 2021-10-07 | Johnson | Iowa | 19103 | 17624 | 98 |
1788221 | 1788221 | 2021-10-06 | Johnson | Iowa | 19103 | 17624 | 98 |
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);