ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40039 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176368 | 2176368 | 2022-02-02 | Custer | Oklahoma | 40039 | 7465 | 143 |
2173114 | 2173114 | 2022-02-01 | Custer | Oklahoma | 40039 | 7072 | 142 |
2169862 | 2169862 | 2022-01-31 | Custer | Oklahoma | 40039 | 7072 | 142 |
2166607 | 2166607 | 2022-01-30 | Custer | Oklahoma | 40039 | 7072 | 142 |
2163352 | 2163352 | 2022-01-29 | Custer | Oklahoma | 40039 | 7072 | 142 |
2160097 | 2160097 | 2022-01-28 | Custer | Oklahoma | 40039 | 7072 | 142 |
2156842 | 2156842 | 2022-01-27 | Custer | Oklahoma | 40039 | 7072 | 142 |
2153589 | 2153589 | 2022-01-26 | Custer | Oklahoma | 40039 | 7072 | 142 |
2150337 | 2150337 | 2022-01-25 | Custer | Oklahoma | 40039 | 6559 | 138 |
2147085 | 2147085 | 2022-01-24 | Custer | Oklahoma | 40039 | 6559 | 138 |
2143831 | 2143831 | 2022-01-23 | Custer | Oklahoma | 40039 | 6559 | 138 |
2140576 | 2140576 | 2022-01-22 | Custer | Oklahoma | 40039 | 6559 | 138 |
2137320 | 2137320 | 2022-01-21 | Custer | Oklahoma | 40039 | 6559 | 138 |
2134066 | 2134066 | 2022-01-20 | Custer | Oklahoma | 40039 | 6559 | 138 |
2130814 | 2130814 | 2022-01-19 | Custer | Oklahoma | 40039 | 6559 | 138 |
2127560 | 2127560 | 2022-01-18 | Custer | Oklahoma | 40039 | 6119 | 137 |
2124308 | 2124308 | 2022-01-17 | Custer | Oklahoma | 40039 | 6119 | 137 |
2121056 | 2121056 | 2022-01-16 | Custer | Oklahoma | 40039 | 6119 | 137 |
2117804 | 2117804 | 2022-01-15 | Custer | Oklahoma | 40039 | 6119 | 137 |
2114553 | 2114553 | 2022-01-14 | Custer | Oklahoma | 40039 | 6119 | 137 |
2111301 | 2111301 | 2022-01-13 | Custer | Oklahoma | 40039 | 6119 | 137 |
2108049 | 2108049 | 2022-01-12 | Custer | Oklahoma | 40039 | 6119 | 137 |
2104798 | 2104798 | 2022-01-11 | Custer | Oklahoma | 40039 | 5835 | 136 |
2101547 | 2101547 | 2022-01-10 | Custer | Oklahoma | 40039 | 5835 | 136 |
2098296 | 2098296 | 2022-01-09 | Custer | Oklahoma | 40039 | 5835 | 136 |
2095044 | 2095044 | 2022-01-08 | Custer | Oklahoma | 40039 | 5835 | 136 |
2091792 | 2091792 | 2022-01-07 | Custer | Oklahoma | 40039 | 5835 | 136 |
2088540 | 2088540 | 2022-01-06 | Custer | Oklahoma | 40039 | 5835 | 136 |
2085289 | 2085289 | 2022-01-05 | Custer | Oklahoma | 40039 | 5835 | 136 |
2082037 | 2082037 | 2022-01-04 | Custer | Oklahoma | 40039 | 5704 | 134 |
2078785 | 2078785 | 2022-01-03 | Custer | Oklahoma | 40039 | 5704 | 134 |
2075534 | 2075534 | 2022-01-02 | Custer | Oklahoma | 40039 | 5704 | 134 |
2072283 | 2072283 | 2022-01-01 | Custer | Oklahoma | 40039 | 5704 | 134 |
2069032 | 2069032 | 2021-12-31 | Custer | Oklahoma | 40039 | 5704 | 134 |
2065781 | 2065781 | 2021-12-30 | Custer | Oklahoma | 40039 | 5704 | 134 |
2062531 | 2062531 | 2021-12-29 | Custer | Oklahoma | 40039 | 5704 | 134 |
2059281 | 2059281 | 2021-12-28 | Custer | Oklahoma | 40039 | 5657 | 134 |
2056032 | 2056032 | 2021-12-27 | Custer | Oklahoma | 40039 | 5657 | 134 |
2052783 | 2052783 | 2021-12-26 | Custer | Oklahoma | 40039 | 5657 | 134 |
2049533 | 2049533 | 2021-12-25 | Custer | Oklahoma | 40039 | 5657 | 134 |
2046283 | 2046283 | 2021-12-24 | Custer | Oklahoma | 40039 | 5657 | 134 |
2043033 | 2043033 | 2021-12-23 | Custer | Oklahoma | 40039 | 5657 | 134 |
2039784 | 2039784 | 2021-12-22 | Custer | Oklahoma | 40039 | 5657 | 134 |
2036534 | 2036534 | 2021-12-21 | Custer | Oklahoma | 40039 | 5578 | 133 |
2033284 | 2033284 | 2021-12-20 | Custer | Oklahoma | 40039 | 5578 | 133 |
2030034 | 2030034 | 2021-12-19 | Custer | Oklahoma | 40039 | 5578 | 133 |
2026783 | 2026783 | 2021-12-18 | Custer | Oklahoma | 40039 | 5578 | 133 |
2023532 | 2023532 | 2021-12-17 | Custer | Oklahoma | 40039 | 5578 | 133 |
2020281 | 2020281 | 2021-12-16 | Custer | Oklahoma | 40039 | 5578 | 133 |
2017030 | 2017030 | 2021-12-15 | Custer | Oklahoma | 40039 | 5578 | 133 |
2013780 | 2013780 | 2021-12-14 | Custer | Oklahoma | 40039 | 5494 | 133 |
2010529 | 2010529 | 2021-12-13 | Custer | Oklahoma | 40039 | 5494 | 133 |
2007278 | 2007278 | 2021-12-12 | Custer | Oklahoma | 40039 | 5494 | 133 |
2004027 | 2004027 | 2021-12-11 | Custer | Oklahoma | 40039 | 5494 | 133 |
2000776 | 2000776 | 2021-12-10 | Custer | Oklahoma | 40039 | 5494 | 133 |
1997526 | 1997526 | 2021-12-09 | Custer | Oklahoma | 40039 | 5494 | 133 |
1994275 | 1994275 | 2021-12-08 | Custer | Oklahoma | 40039 | 5494 | 133 |
1991024 | 1991024 | 2021-12-07 | Custer | Oklahoma | 40039 | 5367 | 132 |
1987773 | 1987773 | 2021-12-06 | Custer | Oklahoma | 40039 | 5367 | 132 |
1984523 | 1984523 | 2021-12-05 | Custer | Oklahoma | 40039 | 5367 | 132 |
1981273 | 1981273 | 2021-12-04 | Custer | Oklahoma | 40039 | 5367 | 132 |
1978023 | 1978023 | 2021-12-03 | Custer | Oklahoma | 40039 | 5367 | 132 |
1974773 | 1974773 | 2021-12-02 | Custer | Oklahoma | 40039 | 5367 | 129 |
1971524 | 1971524 | 2021-12-01 | Custer | Oklahoma | 40039 | 5367 | 129 |
1968274 | 1968274 | 2021-11-30 | Custer | Oklahoma | 40039 | 5284 | 129 |
1965023 | 1965023 | 2021-11-29 | Custer | Oklahoma | 40039 | 5284 | 129 |
1961771 | 1961771 | 2021-11-28 | Custer | Oklahoma | 40039 | 5284 | 129 |
1958520 | 1958520 | 2021-11-27 | Custer | Oklahoma | 40039 | 5284 | 129 |
1955269 | 1955269 | 2021-11-26 | Custer | Oklahoma | 40039 | 5284 | 129 |
1952018 | 1952018 | 2021-11-25 | Custer | Oklahoma | 40039 | 5284 | 129 |
1948767 | 1948767 | 2021-11-24 | Custer | Oklahoma | 40039 | 5284 | 129 |
1945516 | 1945516 | 2021-11-23 | Custer | Oklahoma | 40039 | 5173 | 129 |
1942265 | 1942265 | 2021-11-22 | Custer | Oklahoma | 40039 | 5173 | 129 |
1939015 | 1939015 | 2021-11-21 | Custer | Oklahoma | 40039 | 5173 | 129 |
1935765 | 1935765 | 2021-11-20 | Custer | Oklahoma | 40039 | 5173 | 129 |
1932515 | 1932515 | 2021-11-19 | Custer | Oklahoma | 40039 | 5173 | 129 |
1929264 | 1929264 | 2021-11-18 | Custer | Oklahoma | 40039 | 5173 | 129 |
1926014 | 1926014 | 2021-11-17 | Custer | Oklahoma | 40039 | 5173 | 129 |
1922764 | 1922764 | 2021-11-16 | Custer | Oklahoma | 40039 | 5119 | 129 |
1919515 | 1919515 | 2021-11-15 | Custer | Oklahoma | 40039 | 5119 | 129 |
1916265 | 1916265 | 2021-11-14 | Custer | Oklahoma | 40039 | 5119 | 129 |
1913015 | 1913015 | 2021-11-13 | Custer | Oklahoma | 40039 | 5119 | 129 |
1909765 | 1909765 | 2021-11-12 | Custer | Oklahoma | 40039 | 5119 | 129 |
1906516 | 1906516 | 2021-11-11 | Custer | Oklahoma | 40039 | 5119 | 129 |
1903267 | 1903267 | 2021-11-10 | Custer | Oklahoma | 40039 | 5119 | 129 |
1900017 | 1900017 | 2021-11-09 | Custer | Oklahoma | 40039 | 5075 | 129 |
1896767 | 1896767 | 2021-11-08 | Custer | Oklahoma | 40039 | 5075 | 129 |
1893517 | 1893517 | 2021-11-07 | Custer | Oklahoma | 40039 | 5075 | 129 |
1890267 | 1890267 | 2021-11-06 | Custer | Oklahoma | 40039 | 5075 | 129 |
1887017 | 1887017 | 2021-11-05 | Custer | Oklahoma | 40039 | 5075 | 129 |
1883767 | 1883767 | 2021-11-04 | Custer | Oklahoma | 40039 | 5075 | 129 |
1880518 | 1880518 | 2021-11-03 | Custer | Oklahoma | 40039 | 5075 | 129 |
1877269 | 1877269 | 2021-11-02 | Custer | Oklahoma | 40039 | 5026 | 128 |
1874020 | 1874020 | 2021-11-01 | Custer | Oklahoma | 40039 | 5026 | 128 |
1870771 | 1870771 | 2021-10-31 | Custer | Oklahoma | 40039 | 5026 | 128 |
1867522 | 1867522 | 2021-10-30 | Custer | Oklahoma | 40039 | 5026 | 128 |
1864273 | 1864273 | 2021-10-29 | Custer | Oklahoma | 40039 | 5026 | 128 |
1861024 | 1861024 | 2021-10-28 | Custer | Oklahoma | 40039 | 5026 | 128 |
1857775 | 1857775 | 2021-10-27 | Custer | Oklahoma | 40039 | 5026 | 128 |
1854526 | 1854526 | 2021-10-26 | Custer | Oklahoma | 40039 | 4978 | 128 |
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);