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 |
---|---|---|---|---|---|---|---|
2175043 | 2175043 | 2022-02-02 | Johnson | Iowa | 19103 | 32095 | 126 |
2171790 | 2171790 | 2022-02-01 | Johnson | Iowa | 19103 | 30972 | 121 |
2168537 | 2168537 | 2022-01-31 | Johnson | Iowa | 19103 | 30972 | 121 |
2165282 | 2165282 | 2022-01-30 | Johnson | Iowa | 19103 | 30972 | 121 |
2162027 | 2162027 | 2022-01-29 | Johnson | Iowa | 19103 | 30972 | 121 |
2158772 | 2158772 | 2022-01-28 | Johnson | Iowa | 19103 | 30972 | 121 |
2155518 | 2155518 | 2022-01-27 | Johnson | Iowa | 19103 | 30972 | 121 |
2152265 | 2152265 | 2022-01-26 | Johnson | Iowa | 19103 | 30972 | 121 |
2149013 | 2149013 | 2022-01-25 | Johnson | Iowa | 19103 | 28987 | 120 |
2145761 | 2145761 | 2022-01-24 | Johnson | Iowa | 19103 | 28987 | 120 |
2142506 | 2142506 | 2022-01-23 | Johnson | Iowa | 19103 | 28987 | 120 |
2139251 | 2139251 | 2022-01-22 | Johnson | Iowa | 19103 | 28987 | 120 |
2135995 | 2135995 | 2022-01-21 | Johnson | Iowa | 19103 | 28987 | 120 |
2132743 | 2132743 | 2022-01-20 | Johnson | Iowa | 19103 | 28987 | 120 |
2129490 | 2129490 | 2022-01-19 | Johnson | Iowa | 19103 | 28987 | 120 |
2126236 | 2126236 | 2022-01-18 | Johnson | Iowa | 19103 | 26588 | 119 |
2122984 | 2122984 | 2022-01-17 | Johnson | Iowa | 19103 | 26588 | 119 |
2119732 | 2119732 | 2022-01-16 | Johnson | Iowa | 19103 | 26588 | 119 |
2116480 | 2116480 | 2022-01-15 | Johnson | Iowa | 19103 | 26588 | 119 |
2113229 | 2113229 | 2022-01-14 | Johnson | Iowa | 19103 | 26588 | 119 |
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 |
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);