ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Union" and fips = 46127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176723 | 2176723 | 2022-02-02 | Union | South Dakota | 46127 | 3900 | 49 |
2173469 | 2173469 | 2022-02-01 | Union | South Dakota | 46127 | 3890 | 49 |
2170217 | 2170217 | 2022-01-31 | Union | South Dakota | 46127 | 3872 | 48 |
2166963 | 2166963 | 2022-01-30 | Union | South Dakota | 46127 | 3848 | 47 |
2163708 | 2163708 | 2022-01-29 | Union | South Dakota | 46127 | 3848 | 47 |
2160453 | 2160453 | 2022-01-28 | Union | South Dakota | 46127 | 3848 | 47 |
2157197 | 2157197 | 2022-01-27 | Union | South Dakota | 46127 | 3830 | 47 |
2153944 | 2153944 | 2022-01-26 | Union | South Dakota | 46127 | 3803 | 47 |
2150692 | 2150692 | 2022-01-25 | Union | South Dakota | 46127 | 3777 | 47 |
2147440 | 2147440 | 2022-01-24 | Union | South Dakota | 46127 | 3717 | 47 |
2144186 | 2144186 | 2022-01-23 | Union | South Dakota | 46127 | 3672 | 47 |
2140931 | 2140931 | 2022-01-22 | Union | South Dakota | 46127 | 3672 | 47 |
2137675 | 2137675 | 2022-01-21 | Union | South Dakota | 46127 | 3672 | 47 |
2134421 | 2134421 | 2022-01-20 | Union | South Dakota | 46127 | 3647 | 47 |
2131169 | 2131169 | 2022-01-19 | Union | South Dakota | 46127 | 3626 | 47 |
2127915 | 2127915 | 2022-01-18 | Union | South Dakota | 46127 | 3526 | 47 |
2124663 | 2124663 | 2022-01-17 | Union | South Dakota | 46127 | 3474 | 47 |
2121411 | 2121411 | 2022-01-16 | Union | South Dakota | 46127 | 3474 | 47 |
2118159 | 2118159 | 2022-01-15 | Union | South Dakota | 46127 | 3474 | 47 |
2114908 | 2114908 | 2022-01-14 | Union | South Dakota | 46127 | 3474 | 47 |
2111656 | 2111656 | 2022-01-13 | Union | South Dakota | 46127 | 3410 | 47 |
2108404 | 2108404 | 2022-01-12 | Union | South Dakota | 46127 | 3375 | 47 |
2105153 | 2105153 | 2022-01-11 | Union | South Dakota | 46127 | 3317 | 47 |
2101902 | 2101902 | 2022-01-10 | Union | South Dakota | 46127 | 3268 | 47 |
2098651 | 2098651 | 2022-01-09 | Union | South Dakota | 46127 | 3221 | 47 |
2095399 | 2095399 | 2022-01-08 | Union | South Dakota | 46127 | 3221 | 47 |
2092147 | 2092147 | 2022-01-07 | Union | South Dakota | 46127 | 3221 | 47 |
2088895 | 2088895 | 2022-01-06 | Union | South Dakota | 46127 | 3201 | 47 |
2085644 | 2085644 | 2022-01-05 | Union | South Dakota | 46127 | 3163 | 47 |
2082392 | 2082392 | 2022-01-04 | Union | South Dakota | 46127 | 3095 | 47 |
2079140 | 2079140 | 2022-01-03 | Union | South Dakota | 46127 | 3060 | 47 |
2075889 | 2075889 | 2022-01-02 | Union | South Dakota | 46127 | 3049 | 47 |
2072638 | 2072638 | 2022-01-01 | Union | South Dakota | 46127 | 3049 | 47 |
2069387 | 2069387 | 2021-12-31 | Union | South Dakota | 46127 | 3049 | 47 |
2066136 | 2066136 | 2021-12-30 | Union | South Dakota | 46127 | 3049 | 47 |
2062886 | 2062886 | 2021-12-29 | Union | South Dakota | 46127 | 3042 | 47 |
2059636 | 2059636 | 2021-12-28 | Union | South Dakota | 46127 | 3037 | 47 |
2056387 | 2056387 | 2021-12-27 | Union | South Dakota | 46127 | 3024 | 47 |
2053138 | 2053138 | 2021-12-26 | Union | South Dakota | 46127 | 3014 | 46 |
2049888 | 2049888 | 2021-12-25 | Union | South Dakota | 46127 | 3014 | 46 |
2046638 | 2046638 | 2021-12-24 | Union | South Dakota | 46127 | 3014 | 46 |
2043388 | 2043388 | 2021-12-23 | Union | South Dakota | 46127 | 3014 | 46 |
2040139 | 2040139 | 2021-12-22 | Union | South Dakota | 46127 | 3010 | 46 |
2036889 | 2036889 | 2021-12-21 | Union | South Dakota | 46127 | 3007 | 46 |
2033639 | 2033639 | 2021-12-20 | Union | South Dakota | 46127 | 2996 | 46 |
2030389 | 2030389 | 2021-12-19 | Union | South Dakota | 46127 | 2993 | 46 |
2027138 | 2027138 | 2021-12-18 | Union | South Dakota | 46127 | 2993 | 46 |
2023887 | 2023887 | 2021-12-17 | Union | South Dakota | 46127 | 2993 | 46 |
2020636 | 2020636 | 2021-12-16 | Union | South Dakota | 46127 | 2990 | 46 |
2017385 | 2017385 | 2021-12-15 | Union | South Dakota | 46127 | 2982 | 46 |
2014135 | 2014135 | 2021-12-14 | Union | South Dakota | 46127 | 2975 | 46 |
2010884 | 2010884 | 2021-12-13 | Union | South Dakota | 46127 | 2959 | 46 |
2007633 | 2007633 | 2021-12-12 | Union | South Dakota | 46127 | 2949 | 46 |
2004382 | 2004382 | 2021-12-11 | Union | South Dakota | 46127 | 2949 | 46 |
2001131 | 2001131 | 2021-12-10 | Union | South Dakota | 46127 | 2949 | 46 |
1997881 | 1997881 | 2021-12-09 | Union | South Dakota | 46127 | 2943 | 46 |
1994630 | 1994630 | 2021-12-08 | Union | South Dakota | 46127 | 2936 | 46 |
1991379 | 1991379 | 2021-12-07 | Union | South Dakota | 46127 | 2929 | 46 |
1988128 | 1988128 | 2021-12-06 | Union | South Dakota | 46127 | 2913 | 46 |
1984878 | 1984878 | 2021-12-05 | Union | South Dakota | 46127 | 2906 | 46 |
1981628 | 1981628 | 2021-12-04 | Union | South Dakota | 46127 | 2906 | 46 |
1978378 | 1978378 | 2021-12-03 | Union | South Dakota | 46127 | 2906 | 46 |
1975128 | 1975128 | 2021-12-02 | Union | South Dakota | 46127 | 2901 | 46 |
1971879 | 1971879 | 2021-12-01 | Union | South Dakota | 46127 | 2893 | 46 |
1968629 | 1968629 | 2021-11-30 | Union | South Dakota | 46127 | 2879 | 46 |
1965378 | 1965378 | 2021-11-29 | Union | South Dakota | 46127 | 2856 | 46 |
1962126 | 1962126 | 2021-11-28 | Union | South Dakota | 46127 | 2845 | 46 |
1958875 | 1958875 | 2021-11-27 | Union | South Dakota | 46127 | 2845 | 46 |
1955624 | 1955624 | 2021-11-26 | Union | South Dakota | 46127 | 2845 | 46 |
1952373 | 1952373 | 2021-11-25 | Union | South Dakota | 46127 | 2845 | 46 |
1949122 | 1949122 | 2021-11-24 | Union | South Dakota | 46127 | 2845 | 46 |
1945871 | 1945871 | 2021-11-23 | Union | South Dakota | 46127 | 2830 | 46 |
1942620 | 1942620 | 2021-11-22 | Union | South Dakota | 46127 | 2809 | 46 |
1939370 | 1939370 | 2021-11-21 | Union | South Dakota | 46127 | 2800 | 46 |
1936120 | 1936120 | 2021-11-20 | Union | South Dakota | 46127 | 2800 | 46 |
1932870 | 1932870 | 2021-11-19 | Union | South Dakota | 46127 | 2800 | 46 |
1929619 | 1929619 | 2021-11-18 | Union | South Dakota | 46127 | 2788 | 46 |
1926369 | 1926369 | 2021-11-17 | Union | South Dakota | 46127 | 2783 | 46 |
1923119 | 1923119 | 2021-11-16 | Union | South Dakota | 46127 | 2779 | 46 |
1919870 | 1919870 | 2021-11-15 | Union | South Dakota | 46127 | 2774 | 46 |
1916620 | 1916620 | 2021-11-14 | Union | South Dakota | 46127 | 2756 | 46 |
1913370 | 1913370 | 2021-11-13 | Union | South Dakota | 46127 | 2756 | 46 |
1910120 | 1910120 | 2021-11-12 | Union | South Dakota | 46127 | 2756 | 46 |
1906871 | 1906871 | 2021-11-11 | Union | South Dakota | 46127 | 2743 | 46 |
1903622 | 1903622 | 2021-11-10 | Union | South Dakota | 46127 | 2743 | 46 |
1900372 | 1900372 | 2021-11-09 | Union | South Dakota | 46127 | 2739 | 46 |
1897122 | 1897122 | 2021-11-08 | Union | South Dakota | 46127 | 2727 | 46 |
1893872 | 1893872 | 2021-11-07 | Union | South Dakota | 46127 | 2718 | 46 |
1890622 | 1890622 | 2021-11-06 | Union | South Dakota | 46127 | 2718 | 46 |
1887372 | 1887372 | 2021-11-05 | Union | South Dakota | 46127 | 2718 | 46 |
1884122 | 1884122 | 2021-11-04 | Union | South Dakota | 46127 | 2713 | 46 |
1880873 | 1880873 | 2021-11-03 | Union | South Dakota | 46127 | 2708 | 46 |
1877624 | 1877624 | 2021-11-02 | Union | South Dakota | 46127 | 2698 | 46 |
1874375 | 1874375 | 2021-11-01 | Union | South Dakota | 46127 | 2687 | 46 |
1871126 | 1871126 | 2021-10-31 | Union | South Dakota | 46127 | 2673 | 45 |
1867877 | 1867877 | 2021-10-30 | Union | South Dakota | 46127 | 2673 | 45 |
1864628 | 1864628 | 2021-10-29 | Union | South Dakota | 46127 | 2673 | 45 |
1861379 | 1861379 | 2021-10-28 | Union | South Dakota | 46127 | 2671 | 45 |
1858130 | 1858130 | 2021-10-27 | Union | South Dakota | 46127 | 2662 | 45 |
1854881 | 1854881 | 2021-10-26 | Union | South Dakota | 46127 | 2652 | 45 |
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);