ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where county = "Cedar" and deaths = 42 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2100893 | 2100893 | 2022-01-10 | Cedar | Missouri | 29039 | 2222 | 42 |
2097642 | 2097642 | 2022-01-09 | Cedar | Missouri | 29039 | 2212 | 42 |
2094390 | 2094390 | 2022-01-08 | Cedar | Missouri | 29039 | 2206 | 42 |
2091138 | 2091138 | 2022-01-07 | Cedar | Missouri | 29039 | 2195 | 42 |
2087887 | 2087887 | 2022-01-06 | Cedar | Missouri | 29039 | 2180 | 42 |
2084635 | 2084635 | 2022-01-05 | Cedar | Missouri | 29039 | 2160 | 42 |
2081383 | 2081383 | 2022-01-04 | Cedar | Missouri | 29039 | 2135 | 42 |
2078131 | 2078131 | 2022-01-03 | Cedar | Missouri | 29039 | 2120 | 42 |
2074880 | 2074880 | 2022-01-02 | Cedar | Missouri | 29039 | 2106 | 42 |
2071629 | 2071629 | 2022-01-01 | Cedar | Missouri | 29039 | 2106 | 42 |
2068378 | 2068378 | 2021-12-31 | Cedar | Missouri | 29039 | 2106 | 42 |
2065127 | 2065127 | 2021-12-30 | Cedar | Missouri | 29039 | 2106 | 42 |
2061877 | 2061877 | 2021-12-29 | Cedar | Missouri | 29039 | 2098 | 42 |
2058628 | 2058628 | 2021-12-28 | Cedar | Missouri | 29039 | 2077 | 42 |
2055379 | 2055379 | 2021-12-27 | Cedar | Missouri | 29039 | 2066 | 42 |
2052129 | 2052129 | 2021-12-26 | Cedar | Missouri | 29039 | 2044 | 42 |
2048879 | 2048879 | 2021-12-25 | Cedar | Missouri | 29039 | 2044 | 42 |
2045629 | 2045629 | 2021-12-24 | Cedar | Missouri | 29039 | 2044 | 42 |
2042379 | 2042379 | 2021-12-23 | Cedar | Missouri | 29039 | 2044 | 42 |
2039130 | 2039130 | 2021-12-22 | Cedar | Missouri | 29039 | 2038 | 42 |
2035880 | 2035880 | 2021-12-21 | Cedar | Missouri | 29039 | 2036 | 42 |
2032630 | 2032630 | 2021-12-20 | Cedar | Missouri | 29039 | 2022 | 42 |
2029379 | 2029379 | 2021-12-19 | Cedar | Missouri | 29039 | 2018 | 42 |
2026128 | 2026128 | 2021-12-18 | Cedar | Missouri | 29039 | 2016 | 42 |
2022877 | 2022877 | 2021-12-17 | Cedar | Missouri | 29039 | 2004 | 42 |
2019626 | 2019626 | 2021-12-16 | Cedar | Missouri | 29039 | 1992 | 42 |
2016376 | 2016376 | 2021-12-15 | Cedar | Missouri | 29039 | 1980 | 42 |
2013125 | 2013125 | 2021-12-14 | Cedar | Missouri | 29039 | 1966 | 42 |
2009874 | 2009874 | 2021-12-13 | Cedar | Missouri | 29039 | 1953 | 42 |
2006623 | 2006623 | 2021-12-12 | Cedar | Missouri | 29039 | 1952 | 42 |
2003372 | 2003372 | 2021-12-11 | Cedar | Missouri | 29039 | 1951 | 42 |
2000122 | 2000122 | 2021-12-10 | Cedar | Missouri | 29039 | 1944 | 42 |
1996871 | 1996871 | 2021-12-09 | Cedar | Missouri | 29039 | 1932 | 42 |
1993620 | 1993620 | 2021-12-08 | Cedar | Missouri | 29039 | 1925 | 42 |
1990369 | 1990369 | 2021-12-07 | Cedar | Missouri | 29039 | 1915 | 42 |
1987119 | 1987119 | 2021-12-06 | Cedar | Missouri | 29039 | 1909 | 42 |
1983869 | 1983869 | 2021-12-05 | Cedar | Missouri | 29039 | 1906 | 42 |
1980619 | 1980619 | 2021-12-04 | Cedar | Missouri | 29039 | 1901 | 42 |
1977369 | 1977369 | 2021-12-03 | Cedar | Missouri | 29039 | 1880 | 42 |
1974119 | 1974119 | 2021-12-02 | Cedar | Missouri | 29039 | 1880 | 42 |
1970870 | 1970870 | 2021-12-01 | Cedar | Missouri | 29039 | 1869 | 42 |
1967620 | 1967620 | 2021-11-30 | Cedar | Missouri | 29039 | 1849 | 42 |
1964368 | 1964368 | 2021-11-29 | Cedar | Missouri | 29039 | 1846 | 42 |
1961117 | 1961117 | 2021-11-28 | Cedar | Missouri | 29039 | 1832 | 42 |
1957866 | 1957866 | 2021-11-27 | Cedar | Missouri | 29039 | 1832 | 42 |
1954615 | 1954615 | 2021-11-26 | Cedar | Missouri | 29039 | 1832 | 42 |
1951364 | 1951364 | 2021-11-25 | Cedar | Missouri | 29039 | 1832 | 42 |
1948113 | 1948113 | 2021-11-24 | Cedar | Missouri | 29039 | 1832 | 42 |
1944862 | 1944862 | 2021-11-23 | Cedar | Missouri | 29039 | 1816 | 42 |
1941611 | 1941611 | 2021-11-22 | Cedar | Missouri | 29039 | 1808 | 42 |
1938361 | 1938361 | 2021-11-21 | Cedar | Missouri | 29039 | 1806 | 42 |
1935111 | 1935111 | 2021-11-20 | Cedar | Missouri | 29039 | 1805 | 42 |
1931861 | 1931861 | 2021-11-19 | Cedar | Missouri | 29039 | 1799 | 42 |
1928610 | 1928610 | 2021-11-18 | Cedar | Missouri | 29039 | 1792 | 42 |
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);