ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
727 rows where county = "Adams" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174993 | 2174993 | 2022-02-02 | Adams | Iowa | 19003 | 783 | 12 |
2171740 | 2171740 | 2022-02-01 | Adams | Iowa | 19003 | 739 | 12 |
2168487 | 2168487 | 2022-01-31 | Adams | Iowa | 19003 | 739 | 12 |
2165232 | 2165232 | 2022-01-30 | Adams | Iowa | 19003 | 739 | 12 |
2161977 | 2161977 | 2022-01-29 | Adams | Iowa | 19003 | 739 | 12 |
2158722 | 2158722 | 2022-01-28 | Adams | Iowa | 19003 | 739 | 12 |
2155468 | 2155468 | 2022-01-27 | Adams | Iowa | 19003 | 739 | 12 |
2152215 | 2152215 | 2022-01-26 | Adams | Iowa | 19003 | 739 | 12 |
2148963 | 2148963 | 2022-01-25 | Adams | Iowa | 19003 | 697 | 12 |
2145711 | 2145711 | 2022-01-24 | Adams | Iowa | 19003 | 697 | 12 |
2142456 | 2142456 | 2022-01-23 | Adams | Iowa | 19003 | 697 | 12 |
2139201 | 2139201 | 2022-01-22 | Adams | Iowa | 19003 | 697 | 12 |
2135945 | 2135945 | 2022-01-21 | Adams | Iowa | 19003 | 697 | 12 |
2132693 | 2132693 | 2022-01-20 | Adams | Iowa | 19003 | 697 | 12 |
2129440 | 2129440 | 2022-01-19 | Adams | Iowa | 19003 | 697 | 12 |
2126186 | 2126186 | 2022-01-18 | Adams | Iowa | 19003 | 664 | 12 |
2122934 | 2122934 | 2022-01-17 | Adams | Iowa | 19003 | 664 | 12 |
2119682 | 2119682 | 2022-01-16 | Adams | Iowa | 19003 | 664 | 12 |
2116430 | 2116430 | 2022-01-15 | Adams | Iowa | 19003 | 664 | 12 |
2113179 | 2113179 | 2022-01-14 | Adams | Iowa | 19003 | 664 | 12 |
2109927 | 2109927 | 2022-01-13 | Adams | Iowa | 19003 | 664 | 12 |
2106676 | 2106676 | 2022-01-12 | Adams | Iowa | 19003 | 664 | 12 |
2103425 | 2103425 | 2022-01-11 | Adams | Iowa | 19003 | 651 | 12 |
2100174 | 2100174 | 2022-01-10 | Adams | Iowa | 19003 | 651 | 12 |
2096923 | 2096923 | 2022-01-09 | Adams | Iowa | 19003 | 651 | 12 |
2093671 | 2093671 | 2022-01-08 | Adams | Iowa | 19003 | 651 | 12 |
2090419 | 2090419 | 2022-01-07 | Adams | Iowa | 19003 | 651 | 12 |
2087168 | 2087168 | 2022-01-06 | Adams | Iowa | 19003 | 651 | 12 |
2083916 | 2083916 | 2022-01-05 | Adams | Iowa | 19003 | 651 | 12 |
2080664 | 2080664 | 2022-01-04 | Adams | Iowa | 19003 | 640 | 11 |
2077412 | 2077412 | 2022-01-03 | Adams | Iowa | 19003 | 640 | 11 |
2074161 | 2074161 | 2022-01-02 | Adams | Iowa | 19003 | 640 | 11 |
2070910 | 2070910 | 2022-01-01 | Adams | Iowa | 19003 | 640 | 11 |
2067659 | 2067659 | 2021-12-31 | Adams | Iowa | 19003 | 640 | 11 |
2064408 | 2064408 | 2021-12-30 | Adams | Iowa | 19003 | 640 | 11 |
2061158 | 2061158 | 2021-12-29 | Adams | Iowa | 19003 | 640 | 11 |
2057909 | 2057909 | 2021-12-28 | Adams | Iowa | 19003 | 630 | 11 |
2054660 | 2054660 | 2021-12-27 | Adams | Iowa | 19003 | 630 | 11 |
2051410 | 2051410 | 2021-12-26 | Adams | Iowa | 19003 | 630 | 11 |
2048160 | 2048160 | 2021-12-25 | Adams | Iowa | 19003 | 630 | 11 |
2044910 | 2044910 | 2021-12-24 | Adams | Iowa | 19003 | 630 | 11 |
2041661 | 2041661 | 2021-12-23 | Adams | Iowa | 19003 | 630 | 11 |
2038411 | 2038411 | 2021-12-22 | Adams | Iowa | 19003 | 630 | 11 |
2035161 | 2035161 | 2021-12-21 | Adams | Iowa | 19003 | 618 | 11 |
2031911 | 2031911 | 2021-12-20 | Adams | Iowa | 19003 | 618 | 11 |
2028660 | 2028660 | 2021-12-19 | Adams | Iowa | 19003 | 618 | 11 |
2025409 | 2025409 | 2021-12-18 | Adams | Iowa | 19003 | 618 | 11 |
2022158 | 2022158 | 2021-12-17 | Adams | Iowa | 19003 | 618 | 11 |
2018907 | 2018907 | 2021-12-16 | Adams | Iowa | 19003 | 618 | 11 |
2015657 | 2015657 | 2021-12-15 | Adams | Iowa | 19003 | 618 | 11 |
2012406 | 2012406 | 2021-12-14 | Adams | Iowa | 19003 | 602 | 9 |
2009155 | 2009155 | 2021-12-13 | Adams | Iowa | 19003 | 602 | 9 |
2005904 | 2005904 | 2021-12-12 | Adams | Iowa | 19003 | 602 | 9 |
2002653 | 2002653 | 2021-12-11 | Adams | Iowa | 19003 | 602 | 9 |
1999403 | 1999403 | 2021-12-10 | Adams | Iowa | 19003 | 602 | 9 |
1996152 | 1996152 | 2021-12-09 | Adams | Iowa | 19003 | 602 | 9 |
1992901 | 1992901 | 2021-12-08 | Adams | Iowa | 19003 | 602 | 9 |
1989650 | 1989650 | 2021-12-07 | Adams | Iowa | 19003 | 589 | 9 |
1986400 | 1986400 | 2021-12-06 | Adams | Iowa | 19003 | 589 | 9 |
1983150 | 1983150 | 2021-12-05 | Adams | Iowa | 19003 | 589 | 9 |
1979900 | 1979900 | 2021-12-04 | Adams | Iowa | 19003 | 589 | 9 |
1976650 | 1976650 | 2021-12-03 | Adams | Iowa | 19003 | 589 | 9 |
1973401 | 1973401 | 2021-12-02 | Adams | Iowa | 19003 | 589 | 9 |
1970151 | 1970151 | 2021-12-01 | Adams | Iowa | 19003 | 589 | 9 |
1966901 | 1966901 | 2021-11-30 | Adams | Iowa | 19003 | 575 | 8 |
1963649 | 1963649 | 2021-11-29 | Adams | Iowa | 19003 | 575 | 8 |
1960398 | 1960398 | 2021-11-28 | Adams | Iowa | 19003 | 575 | 8 |
1957147 | 1957147 | 2021-11-27 | Adams | Iowa | 19003 | 575 | 8 |
1953896 | 1953896 | 2021-11-26 | Adams | Iowa | 19003 | 575 | 8 |
1950645 | 1950645 | 2021-11-25 | Adams | Iowa | 19003 | 575 | 8 |
1947394 | 1947394 | 2021-11-24 | Adams | Iowa | 19003 | 575 | 8 |
1944143 | 1944143 | 2021-11-23 | Adams | Iowa | 19003 | 565 | 8 |
1940893 | 1940893 | 2021-11-22 | Adams | Iowa | 19003 | 565 | 8 |
1937643 | 1937643 | 2021-11-21 | Adams | Iowa | 19003 | 565 | 8 |
1934393 | 1934393 | 2021-11-20 | Adams | Iowa | 19003 | 565 | 8 |
1931142 | 1931142 | 2021-11-19 | Adams | Iowa | 19003 | 565 | 8 |
1927891 | 1927891 | 2021-11-18 | Adams | Iowa | 19003 | 565 | 8 |
1924641 | 1924641 | 2021-11-17 | Adams | Iowa | 19003 | 565 | 8 |
1921392 | 1921392 | 2021-11-16 | Adams | Iowa | 19003 | 546 | 8 |
1918142 | 1918142 | 2021-11-15 | Adams | Iowa | 19003 | 546 | 8 |
1914892 | 1914892 | 2021-11-14 | Adams | Iowa | 19003 | 546 | 8 |
1911642 | 1911642 | 2021-11-13 | Adams | Iowa | 19003 | 546 | 8 |
1908393 | 1908393 | 2021-11-12 | Adams | Iowa | 19003 | 546 | 8 |
1905144 | 1905144 | 2021-11-11 | Adams | Iowa | 19003 | 546 | 8 |
1901894 | 1901894 | 2021-11-10 | Adams | Iowa | 19003 | 546 | 8 |
1898644 | 1898644 | 2021-11-09 | Adams | Iowa | 19003 | 531 | 8 |
1895394 | 1895394 | 2021-11-08 | Adams | Iowa | 19003 | 531 | 8 |
1892144 | 1892144 | 2021-11-07 | Adams | Iowa | 19003 | 531 | 8 |
1888894 | 1888894 | 2021-11-06 | Adams | Iowa | 19003 | 531 | 8 |
1885644 | 1885644 | 2021-11-05 | Adams | Iowa | 19003 | 531 | 8 |
1882395 | 1882395 | 2021-11-04 | Adams | Iowa | 19003 | 531 | 8 |
1879146 | 1879146 | 2021-11-03 | Adams | Iowa | 19003 | 531 | 8 |
1875897 | 1875897 | 2021-11-02 | Adams | Iowa | 19003 | 520 | 7 |
1872648 | 1872648 | 2021-11-01 | Adams | Iowa | 19003 | 520 | 7 |
1869399 | 1869399 | 2021-10-31 | Adams | Iowa | 19003 | 520 | 7 |
1866150 | 1866150 | 2021-10-30 | Adams | Iowa | 19003 | 520 | 7 |
1862901 | 1862901 | 2021-10-29 | Adams | Iowa | 19003 | 520 | 7 |
1859652 | 1859652 | 2021-10-28 | Adams | Iowa | 19003 | 520 | 7 |
1856403 | 1856403 | 2021-10-27 | Adams | Iowa | 19003 | 520 | 7 |
1853154 | 1853154 | 2021-10-26 | Adams | Iowa | 19003 | 509 | 5 |
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);