ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Greene" and fips = 19073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175028 | 2175028 | 2022-02-02 | Greene | Iowa | 19073 | 1634 | 19 |
2171775 | 2171775 | 2022-02-01 | Greene | Iowa | 19073 | 1602 | 19 |
2168522 | 2168522 | 2022-01-31 | Greene | Iowa | 19073 | 1602 | 19 |
2165267 | 2165267 | 2022-01-30 | Greene | Iowa | 19073 | 1602 | 19 |
2162012 | 2162012 | 2022-01-29 | Greene | Iowa | 19073 | 1602 | 19 |
2158757 | 2158757 | 2022-01-28 | Greene | Iowa | 19073 | 1602 | 19 |
2155503 | 2155503 | 2022-01-27 | Greene | Iowa | 19073 | 1602 | 19 |
2152250 | 2152250 | 2022-01-26 | Greene | Iowa | 19073 | 1602 | 19 |
2148998 | 2148998 | 2022-01-25 | Greene | Iowa | 19073 | 1539 | 19 |
2145746 | 2145746 | 2022-01-24 | Greene | Iowa | 19073 | 1539 | 19 |
2142491 | 2142491 | 2022-01-23 | Greene | Iowa | 19073 | 1539 | 19 |
2139236 | 2139236 | 2022-01-22 | Greene | Iowa | 19073 | 1539 | 19 |
2135980 | 2135980 | 2022-01-21 | Greene | Iowa | 19073 | 1539 | 19 |
2132728 | 2132728 | 2022-01-20 | Greene | Iowa | 19073 | 1539 | 19 |
2129475 | 2129475 | 2022-01-19 | Greene | Iowa | 19073 | 1539 | 19 |
2126221 | 2126221 | 2022-01-18 | Greene | Iowa | 19073 | 1461 | 19 |
2122969 | 2122969 | 2022-01-17 | Greene | Iowa | 19073 | 1461 | 19 |
2119717 | 2119717 | 2022-01-16 | Greene | Iowa | 19073 | 1461 | 19 |
2116465 | 2116465 | 2022-01-15 | Greene | Iowa | 19073 | 1461 | 19 |
2113214 | 2113214 | 2022-01-14 | Greene | Iowa | 19073 | 1461 | 19 |
2109962 | 2109962 | 2022-01-13 | Greene | Iowa | 19073 | 1461 | 19 |
2106711 | 2106711 | 2022-01-12 | Greene | Iowa | 19073 | 1461 | 19 |
2103460 | 2103460 | 2022-01-11 | Greene | Iowa | 19073 | 1391 | 18 |
2100209 | 2100209 | 2022-01-10 | Greene | Iowa | 19073 | 1391 | 18 |
2096958 | 2096958 | 2022-01-09 | Greene | Iowa | 19073 | 1391 | 18 |
2093706 | 2093706 | 2022-01-08 | Greene | Iowa | 19073 | 1391 | 18 |
2090454 | 2090454 | 2022-01-07 | Greene | Iowa | 19073 | 1391 | 18 |
2087203 | 2087203 | 2022-01-06 | Greene | Iowa | 19073 | 1391 | 18 |
2083951 | 2083951 | 2022-01-05 | Greene | Iowa | 19073 | 1391 | 18 |
2080699 | 2080699 | 2022-01-04 | Greene | Iowa | 19073 | 1355 | 18 |
2077447 | 2077447 | 2022-01-03 | Greene | Iowa | 19073 | 1355 | 18 |
2074196 | 2074196 | 2022-01-02 | Greene | Iowa | 19073 | 1355 | 18 |
2070945 | 2070945 | 2022-01-01 | Greene | Iowa | 19073 | 1355 | 18 |
2067694 | 2067694 | 2021-12-31 | Greene | Iowa | 19073 | 1355 | 18 |
2064443 | 2064443 | 2021-12-30 | Greene | Iowa | 19073 | 1355 | 18 |
2061193 | 2061193 | 2021-12-29 | Greene | Iowa | 19073 | 1355 | 18 |
2057944 | 2057944 | 2021-12-28 | Greene | Iowa | 19073 | 1340 | 18 |
2054695 | 2054695 | 2021-12-27 | Greene | Iowa | 19073 | 1340 | 18 |
2051445 | 2051445 | 2021-12-26 | Greene | Iowa | 19073 | 1340 | 18 |
2048195 | 2048195 | 2021-12-25 | Greene | Iowa | 19073 | 1340 | 18 |
2044945 | 2044945 | 2021-12-24 | Greene | Iowa | 19073 | 1340 | 18 |
2041696 | 2041696 | 2021-12-23 | Greene | Iowa | 19073 | 1340 | 18 |
2038446 | 2038446 | 2021-12-22 | Greene | Iowa | 19073 | 1340 | 18 |
2035196 | 2035196 | 2021-12-21 | Greene | Iowa | 19073 | 1322 | 18 |
2031946 | 2031946 | 2021-12-20 | Greene | Iowa | 19073 | 1322 | 18 |
2028695 | 2028695 | 2021-12-19 | Greene | Iowa | 19073 | 1322 | 18 |
2025444 | 2025444 | 2021-12-18 | Greene | Iowa | 19073 | 1322 | 18 |
2022193 | 2022193 | 2021-12-17 | Greene | Iowa | 19073 | 1322 | 18 |
2018942 | 2018942 | 2021-12-16 | Greene | Iowa | 19073 | 1322 | 18 |
2015692 | 2015692 | 2021-12-15 | Greene | Iowa | 19073 | 1322 | 18 |
2012441 | 2012441 | 2021-12-14 | Greene | Iowa | 19073 | 1309 | 18 |
2009190 | 2009190 | 2021-12-13 | Greene | Iowa | 19073 | 1309 | 18 |
2005939 | 2005939 | 2021-12-12 | Greene | Iowa | 19073 | 1309 | 18 |
2002688 | 2002688 | 2021-12-11 | Greene | Iowa | 19073 | 1309 | 18 |
1999438 | 1999438 | 2021-12-10 | Greene | Iowa | 19073 | 1309 | 18 |
1996187 | 1996187 | 2021-12-09 | Greene | Iowa | 19073 | 1309 | 18 |
1992936 | 1992936 | 2021-12-08 | Greene | Iowa | 19073 | 1309 | 18 |
1989685 | 1989685 | 2021-12-07 | Greene | Iowa | 19073 | 1290 | 18 |
1986435 | 1986435 | 2021-12-06 | Greene | Iowa | 19073 | 1290 | 18 |
1983185 | 1983185 | 2021-12-05 | Greene | Iowa | 19073 | 1290 | 18 |
1979935 | 1979935 | 2021-12-04 | Greene | Iowa | 19073 | 1290 | 18 |
1976685 | 1976685 | 2021-12-03 | Greene | Iowa | 19073 | 1290 | 18 |
1973436 | 1973436 | 2021-12-02 | Greene | Iowa | 19073 | 1290 | 18 |
1970186 | 1970186 | 2021-12-01 | Greene | Iowa | 19073 | 1290 | 18 |
1966936 | 1966936 | 2021-11-30 | Greene | Iowa | 19073 | 1278 | 17 |
1963684 | 1963684 | 2021-11-29 | Greene | Iowa | 19073 | 1278 | 17 |
1960433 | 1960433 | 2021-11-28 | Greene | Iowa | 19073 | 1278 | 17 |
1957182 | 1957182 | 2021-11-27 | Greene | Iowa | 19073 | 1278 | 17 |
1953931 | 1953931 | 2021-11-26 | Greene | Iowa | 19073 | 1278 | 17 |
1950680 | 1950680 | 2021-11-25 | Greene | Iowa | 19073 | 1278 | 17 |
1947429 | 1947429 | 2021-11-24 | Greene | Iowa | 19073 | 1278 | 17 |
1944178 | 1944178 | 2021-11-23 | Greene | Iowa | 19073 | 1246 | 17 |
1940928 | 1940928 | 2021-11-22 | Greene | Iowa | 19073 | 1246 | 17 |
1937678 | 1937678 | 2021-11-21 | Greene | Iowa | 19073 | 1246 | 17 |
1934428 | 1934428 | 2021-11-20 | Greene | Iowa | 19073 | 1246 | 17 |
1931177 | 1931177 | 2021-11-19 | Greene | Iowa | 19073 | 1246 | 17 |
1927926 | 1927926 | 2021-11-18 | Greene | Iowa | 19073 | 1246 | 17 |
1924676 | 1924676 | 2021-11-17 | Greene | Iowa | 19073 | 1246 | 17 |
1921427 | 1921427 | 2021-11-16 | Greene | Iowa | 19073 | 1231 | 17 |
1918177 | 1918177 | 2021-11-15 | Greene | Iowa | 19073 | 1231 | 17 |
1914927 | 1914927 | 2021-11-14 | Greene | Iowa | 19073 | 1231 | 17 |
1911677 | 1911677 | 2021-11-13 | Greene | Iowa | 19073 | 1231 | 17 |
1908428 | 1908428 | 2021-11-12 | Greene | Iowa | 19073 | 1231 | 17 |
1905179 | 1905179 | 2021-11-11 | Greene | Iowa | 19073 | 1231 | 17 |
1901929 | 1901929 | 2021-11-10 | Greene | Iowa | 19073 | 1231 | 17 |
1898679 | 1898679 | 2021-11-09 | Greene | Iowa | 19073 | 1204 | 17 |
1895429 | 1895429 | 2021-11-08 | Greene | Iowa | 19073 | 1204 | 17 |
1892179 | 1892179 | 2021-11-07 | Greene | Iowa | 19073 | 1204 | 17 |
1888929 | 1888929 | 2021-11-06 | Greene | Iowa | 19073 | 1204 | 17 |
1885679 | 1885679 | 2021-11-05 | Greene | Iowa | 19073 | 1204 | 17 |
1882430 | 1882430 | 2021-11-04 | Greene | Iowa | 19073 | 1204 | 17 |
1879181 | 1879181 | 2021-11-03 | Greene | Iowa | 19073 | 1204 | 17 |
1875932 | 1875932 | 2021-11-02 | Greene | Iowa | 19073 | 1185 | 17 |
1872683 | 1872683 | 2021-11-01 | Greene | Iowa | 19073 | 1185 | 17 |
1869434 | 1869434 | 2021-10-31 | Greene | Iowa | 19073 | 1185 | 17 |
1866185 | 1866185 | 2021-10-30 | Greene | Iowa | 19073 | 1185 | 17 |
1862936 | 1862936 | 2021-10-29 | Greene | Iowa | 19073 | 1185 | 17 |
1859687 | 1859687 | 2021-10-28 | Greene | Iowa | 19073 | 1185 | 17 |
1856438 | 1856438 | 2021-10-27 | Greene | Iowa | 19073 | 1185 | 17 |
1853189 | 1853189 | 2021-10-26 | Greene | Iowa | 19073 | 1164 | 15 |
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);