ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46035 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176677 | 2176677 | 2022-02-02 | Davison | South Dakota | 46035 | 5700 | 79 |
2173423 | 2173423 | 2022-02-01 | Davison | South Dakota | 46035 | 5676 | 79 |
2170171 | 2170171 | 2022-01-31 | Davison | South Dakota | 46035 | 5641 | 78 |
2166917 | 2166917 | 2022-01-30 | Davison | South Dakota | 46035 | 5616 | 78 |
2163662 | 2163662 | 2022-01-29 | Davison | South Dakota | 46035 | 5616 | 78 |
2160407 | 2160407 | 2022-01-28 | Davison | South Dakota | 46035 | 5616 | 78 |
2157151 | 2157151 | 2022-01-27 | Davison | South Dakota | 46035 | 5592 | 78 |
2153898 | 2153898 | 2022-01-26 | Davison | South Dakota | 46035 | 5565 | 78 |
2150646 | 2150646 | 2022-01-25 | Davison | South Dakota | 46035 | 5528 | 78 |
2147394 | 2147394 | 2022-01-24 | Davison | South Dakota | 46035 | 5457 | 78 |
2144140 | 2144140 | 2022-01-23 | Davison | South Dakota | 46035 | 5397 | 77 |
2140885 | 2140885 | 2022-01-22 | Davison | South Dakota | 46035 | 5397 | 77 |
2137629 | 2137629 | 2022-01-21 | Davison | South Dakota | 46035 | 5397 | 77 |
2134375 | 2134375 | 2022-01-20 | Davison | South Dakota | 46035 | 5331 | 76 |
2131123 | 2131123 | 2022-01-19 | Davison | South Dakota | 46035 | 5243 | 76 |
2127869 | 2127869 | 2022-01-18 | Davison | South Dakota | 46035 | 5098 | 75 |
2124617 | 2124617 | 2022-01-17 | Davison | South Dakota | 46035 | 5048 | 75 |
2121365 | 2121365 | 2022-01-16 | Davison | South Dakota | 46035 | 5048 | 75 |
2118113 | 2118113 | 2022-01-15 | Davison | South Dakota | 46035 | 5048 | 75 |
2114862 | 2114862 | 2022-01-14 | Davison | South Dakota | 46035 | 5048 | 75 |
2111610 | 2111610 | 2022-01-13 | Davison | South Dakota | 46035 | 4994 | 75 |
2108358 | 2108358 | 2022-01-12 | Davison | South Dakota | 46035 | 4943 | 75 |
2105107 | 2105107 | 2022-01-11 | Davison | South Dakota | 46035 | 4867 | 75 |
2101856 | 2101856 | 2022-01-10 | Davison | South Dakota | 46035 | 4793 | 75 |
2098605 | 2098605 | 2022-01-09 | Davison | South Dakota | 46035 | 4750 | 75 |
2095353 | 2095353 | 2022-01-08 | Davison | South Dakota | 46035 | 4750 | 75 |
2092101 | 2092101 | 2022-01-07 | Davison | South Dakota | 46035 | 4750 | 75 |
2088849 | 2088849 | 2022-01-06 | Davison | South Dakota | 46035 | 4686 | 75 |
2085598 | 2085598 | 2022-01-05 | Davison | South Dakota | 46035 | 4634 | 74 |
2082346 | 2082346 | 2022-01-04 | Davison | South Dakota | 46035 | 4599 | 74 |
2079094 | 2079094 | 2022-01-03 | Davison | South Dakota | 46035 | 4548 | 73 |
2075843 | 2075843 | 2022-01-02 | Davison | South Dakota | 46035 | 4533 | 73 |
2072592 | 2072592 | 2022-01-01 | Davison | South Dakota | 46035 | 4533 | 73 |
2069341 | 2069341 | 2021-12-31 | Davison | South Dakota | 46035 | 4533 | 73 |
2066090 | 2066090 | 2021-12-30 | Davison | South Dakota | 46035 | 4533 | 73 |
2062840 | 2062840 | 2021-12-29 | Davison | South Dakota | 46035 | 4518 | 73 |
2059590 | 2059590 | 2021-12-28 | Davison | South Dakota | 46035 | 4489 | 73 |
2056341 | 2056341 | 2021-12-27 | Davison | South Dakota | 46035 | 4459 | 73 |
2053092 | 2053092 | 2021-12-26 | Davison | South Dakota | 46035 | 4437 | 73 |
2049842 | 2049842 | 2021-12-25 | Davison | South Dakota | 46035 | 4437 | 73 |
2046592 | 2046592 | 2021-12-24 | Davison | South Dakota | 46035 | 4437 | 73 |
2043342 | 2043342 | 2021-12-23 | Davison | South Dakota | 46035 | 4437 | 73 |
2040093 | 2040093 | 2021-12-22 | Davison | South Dakota | 46035 | 4420 | 72 |
2036843 | 2036843 | 2021-12-21 | Davison | South Dakota | 46035 | 4400 | 72 |
2033593 | 2033593 | 2021-12-20 | Davison | South Dakota | 46035 | 4350 | 72 |
2030343 | 2030343 | 2021-12-19 | Davison | South Dakota | 46035 | 4338 | 72 |
2027092 | 2027092 | 2021-12-18 | Davison | South Dakota | 46035 | 4338 | 72 |
2023841 | 2023841 | 2021-12-17 | Davison | South Dakota | 46035 | 4338 | 72 |
2020590 | 2020590 | 2021-12-16 | Davison | South Dakota | 46035 | 4313 | 72 |
2017339 | 2017339 | 2021-12-15 | Davison | South Dakota | 46035 | 4287 | 71 |
2014089 | 2014089 | 2021-12-14 | Davison | South Dakota | 46035 | 4260 | 71 |
2010838 | 2010838 | 2021-12-13 | Davison | South Dakota | 46035 | 4230 | 71 |
2007587 | 2007587 | 2021-12-12 | Davison | South Dakota | 46035 | 4217 | 71 |
2004336 | 2004336 | 2021-12-11 | Davison | South Dakota | 46035 | 4217 | 71 |
2001085 | 2001085 | 2021-12-10 | Davison | South Dakota | 46035 | 4217 | 71 |
1997835 | 1997835 | 2021-12-09 | Davison | South Dakota | 46035 | 4188 | 71 |
1994584 | 1994584 | 2021-12-08 | Davison | South Dakota | 46035 | 4170 | 71 |
1991333 | 1991333 | 2021-12-07 | Davison | South Dakota | 46035 | 4150 | 71 |
1988082 | 1988082 | 2021-12-06 | Davison | South Dakota | 46035 | 4114 | 71 |
1984832 | 1984832 | 2021-12-05 | Davison | South Dakota | 46035 | 4098 | 71 |
1981582 | 1981582 | 2021-12-04 | Davison | South Dakota | 46035 | 4098 | 71 |
1978332 | 1978332 | 2021-12-03 | Davison | South Dakota | 46035 | 4098 | 71 |
1975082 | 1975082 | 2021-12-02 | Davison | South Dakota | 46035 | 4077 | 71 |
1971833 | 1971833 | 2021-12-01 | Davison | South Dakota | 46035 | 4064 | 71 |
1968583 | 1968583 | 2021-11-30 | Davison | South Dakota | 46035 | 4046 | 71 |
1965332 | 1965332 | 2021-11-29 | Davison | South Dakota | 46035 | 4014 | 71 |
1962080 | 1962080 | 2021-11-28 | Davison | South Dakota | 46035 | 4006 | 71 |
1958829 | 1958829 | 2021-11-27 | Davison | South Dakota | 46035 | 4006 | 71 |
1955578 | 1955578 | 2021-11-26 | Davison | South Dakota | 46035 | 4006 | 71 |
1952327 | 1952327 | 2021-11-25 | Davison | South Dakota | 46035 | 4006 | 71 |
1949076 | 1949076 | 2021-11-24 | Davison | South Dakota | 46035 | 4006 | 71 |
1945825 | 1945825 | 2021-11-23 | Davison | South Dakota | 46035 | 3987 | 71 |
1942574 | 1942574 | 2021-11-22 | Davison | South Dakota | 46035 | 3965 | 71 |
1939324 | 1939324 | 2021-11-21 | Davison | South Dakota | 46035 | 3947 | 71 |
1936074 | 1936074 | 2021-11-20 | Davison | South Dakota | 46035 | 3947 | 71 |
1932824 | 1932824 | 2021-11-19 | Davison | South Dakota | 46035 | 3947 | 71 |
1929573 | 1929573 | 2021-11-18 | Davison | South Dakota | 46035 | 3934 | 71 |
1926323 | 1926323 | 2021-11-17 | Davison | South Dakota | 46035 | 3913 | 71 |
1923073 | 1923073 | 2021-11-16 | Davison | South Dakota | 46035 | 3898 | 71 |
1919824 | 1919824 | 2021-11-15 | Davison | South Dakota | 46035 | 3874 | 71 |
1916574 | 1916574 | 2021-11-14 | Davison | South Dakota | 46035 | 3847 | 71 |
1913324 | 1913324 | 2021-11-13 | Davison | South Dakota | 46035 | 3847 | 71 |
1910074 | 1910074 | 2021-11-12 | Davison | South Dakota | 46035 | 3847 | 71 |
1906825 | 1906825 | 2021-11-11 | Davison | South Dakota | 46035 | 3829 | 71 |
1903576 | 1903576 | 2021-11-10 | Davison | South Dakota | 46035 | 3829 | 71 |
1900326 | 1900326 | 2021-11-09 | Davison | South Dakota | 46035 | 3812 | 71 |
1897076 | 1897076 | 2021-11-08 | Davison | South Dakota | 46035 | 3799 | 71 |
1893826 | 1893826 | 2021-11-07 | Davison | South Dakota | 46035 | 3786 | 71 |
1890576 | 1890576 | 2021-11-06 | Davison | South Dakota | 46035 | 3786 | 71 |
1887326 | 1887326 | 2021-11-05 | Davison | South Dakota | 46035 | 3786 | 71 |
1884076 | 1884076 | 2021-11-04 | Davison | South Dakota | 46035 | 3781 | 70 |
1880827 | 1880827 | 2021-11-03 | Davison | South Dakota | 46035 | 3770 | 70 |
1877578 | 1877578 | 2021-11-02 | Davison | South Dakota | 46035 | 3762 | 70 |
1874329 | 1874329 | 2021-11-01 | Davison | South Dakota | 46035 | 3751 | 70 |
1871080 | 1871080 | 2021-10-31 | Davison | South Dakota | 46035 | 3742 | 70 |
1867831 | 1867831 | 2021-10-30 | Davison | South Dakota | 46035 | 3742 | 70 |
1864582 | 1864582 | 2021-10-29 | Davison | South Dakota | 46035 | 3742 | 70 |
1861333 | 1861333 | 2021-10-28 | Davison | South Dakota | 46035 | 3735 | 70 |
1858084 | 1858084 | 2021-10-27 | Davison | South Dakota | 46035 | 3730 | 70 |
1854835 | 1854835 | 2021-10-26 | Davison | South Dakota | 46035 | 3721 | 70 |
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);