ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where county = "Bon Homme", deaths = 31 and fips = 46009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2108345 | 2108345 | 2022-01-12 | Bon Homme | South Dakota | 46009 | 1998 | 31 |
2105094 | 2105094 | 2022-01-11 | Bon Homme | South Dakota | 46009 | 1983 | 31 |
2101843 | 2101843 | 2022-01-10 | Bon Homme | South Dakota | 46009 | 1961 | 31 |
2098592 | 2098592 | 2022-01-09 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2095340 | 2095340 | 2022-01-08 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2092088 | 2092088 | 2022-01-07 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2088836 | 2088836 | 2022-01-06 | Bon Homme | South Dakota | 46009 | 1929 | 31 |
2085585 | 2085585 | 2022-01-05 | Bon Homme | South Dakota | 46009 | 1907 | 31 |
2082333 | 2082333 | 2022-01-04 | Bon Homme | South Dakota | 46009 | 1889 | 31 |
2079081 | 2079081 | 2022-01-03 | Bon Homme | South Dakota | 46009 | 1862 | 31 |
2075830 | 2075830 | 2022-01-02 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2072579 | 2072579 | 2022-01-01 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2069328 | 2069328 | 2021-12-31 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2066077 | 2066077 | 2021-12-30 | Bon Homme | South Dakota | 46009 | 1854 | 31 |
2062827 | 2062827 | 2021-12-29 | Bon Homme | South Dakota | 46009 | 1851 | 31 |
2059577 | 2059577 | 2021-12-28 | Bon Homme | South Dakota | 46009 | 1838 | 31 |
2056328 | 2056328 | 2021-12-27 | Bon Homme | South Dakota | 46009 | 1823 | 31 |
2053079 | 2053079 | 2021-12-26 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2049829 | 2049829 | 2021-12-25 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2046579 | 2046579 | 2021-12-24 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2043329 | 2043329 | 2021-12-23 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2040080 | 2040080 | 2021-12-22 | Bon Homme | South Dakota | 46009 | 1815 | 31 |
2036830 | 2036830 | 2021-12-21 | Bon Homme | South Dakota | 46009 | 1812 | 31 |
2033580 | 2033580 | 2021-12-20 | Bon Homme | South Dakota | 46009 | 1806 | 31 |
2030330 | 2030330 | 2021-12-19 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2027079 | 2027079 | 2021-12-18 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2023828 | 2023828 | 2021-12-17 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2020577 | 2020577 | 2021-12-16 | Bon Homme | South Dakota | 46009 | 1794 | 31 |
2017326 | 2017326 | 2021-12-15 | Bon Homme | South Dakota | 46009 | 1791 | 31 |
2014076 | 2014076 | 2021-12-14 | Bon Homme | South Dakota | 46009 | 1788 | 31 |
2010825 | 2010825 | 2021-12-13 | Bon Homme | South Dakota | 46009 | 1783 | 31 |
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);