ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Cleveland" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176362 | 2176362 | 2022-02-02 | Cleveland | Oklahoma | 40027 | 75571 | 687 |
2173108 | 2173108 | 2022-02-01 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2169856 | 2169856 | 2022-01-31 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2166601 | 2166601 | 2022-01-30 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2163346 | 2163346 | 2022-01-29 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2160091 | 2160091 | 2022-01-28 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2156836 | 2156836 | 2022-01-27 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2153583 | 2153583 | 2022-01-26 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2150331 | 2150331 | 2022-01-25 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2147079 | 2147079 | 2022-01-24 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2143825 | 2143825 | 2022-01-23 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2140570 | 2140570 | 2022-01-22 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2137314 | 2137314 | 2022-01-21 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2134060 | 2134060 | 2022-01-20 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2130808 | 2130808 | 2022-01-19 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2127554 | 2127554 | 2022-01-18 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2124302 | 2124302 | 2022-01-17 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2121050 | 2121050 | 2022-01-16 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2117798 | 2117798 | 2022-01-15 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2114547 | 2114547 | 2022-01-14 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2111295 | 2111295 | 2022-01-13 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2108043 | 2108043 | 2022-01-12 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2104792 | 2104792 | 2022-01-11 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2101541 | 2101541 | 2022-01-10 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2098290 | 2098290 | 2022-01-09 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2095038 | 2095038 | 2022-01-08 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2091786 | 2091786 | 2022-01-07 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2088534 | 2088534 | 2022-01-06 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2085283 | 2085283 | 2022-01-05 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2082031 | 2082031 | 2022-01-04 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2078779 | 2078779 | 2022-01-03 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2075528 | 2075528 | 2022-01-02 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2072277 | 2072277 | 2022-01-01 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2069026 | 2069026 | 2021-12-31 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2065775 | 2065775 | 2021-12-30 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2062525 | 2062525 | 2021-12-29 | Cleveland | Oklahoma | 40027 | 47093 | 643 |
2059275 | 2059275 | 2021-12-28 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2056026 | 2056026 | 2021-12-27 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2052777 | 2052777 | 2021-12-26 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2049527 | 2049527 | 2021-12-25 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2046277 | 2046277 | 2021-12-24 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2043027 | 2043027 | 2021-12-23 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2039778 | 2039778 | 2021-12-22 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2036528 | 2036528 | 2021-12-21 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2033278 | 2033278 | 2021-12-20 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2030028 | 2030028 | 2021-12-19 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2026777 | 2026777 | 2021-12-18 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2023526 | 2023526 | 2021-12-17 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2020275 | 2020275 | 2021-12-16 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2017024 | 2017024 | 2021-12-15 | Cleveland | Oklahoma | 40027 | 46168 | 635 |
2013774 | 2013774 | 2021-12-14 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
2010523 | 2010523 | 2021-12-13 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
2007272 | 2007272 | 2021-12-12 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
2004021 | 2004021 | 2021-12-11 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
2000770 | 2000770 | 2021-12-10 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
1997520 | 1997520 | 2021-12-09 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
1994269 | 1994269 | 2021-12-08 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
1991018 | 1991018 | 2021-12-07 | Cleveland | Oklahoma | 40027 | 45263 | 630 |
1987767 | 1987767 | 2021-12-06 | Cleveland | Oklahoma | 40027 | 45263 | 630 |
1984517 | 1984517 | 2021-12-05 | Cleveland | Oklahoma | 40027 | 45263 | 630 |
1981267 | 1981267 | 2021-12-04 | Cleveland | Oklahoma | 40027 | 45263 | 630 |
1978017 | 1978017 | 2021-12-03 | Cleveland | Oklahoma | 40027 | 45263 | 630 |
1974767 | 1974767 | 2021-12-02 | Cleveland | Oklahoma | 40027 | 45263 | 609 |
1971518 | 1971518 | 2021-12-01 | Cleveland | Oklahoma | 40027 | 45263 | 609 |
1968268 | 1968268 | 2021-11-30 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1965017 | 1965017 | 2021-11-29 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1961765 | 1961765 | 2021-11-28 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1958514 | 1958514 | 2021-11-27 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1955263 | 1955263 | 2021-11-26 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1952012 | 1952012 | 2021-11-25 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1948761 | 1948761 | 2021-11-24 | Cleveland | Oklahoma | 40027 | 44907 | 609 |
1945510 | 1945510 | 2021-11-23 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1942259 | 1942259 | 2021-11-22 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1939009 | 1939009 | 2021-11-21 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1935759 | 1935759 | 2021-11-20 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1932509 | 1932509 | 2021-11-19 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1929258 | 1929258 | 2021-11-18 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1926008 | 1926008 | 2021-11-17 | Cleveland | Oklahoma | 40027 | 44597 | 609 |
1922758 | 1922758 | 2021-11-16 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1919509 | 1919509 | 2021-11-15 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1916259 | 1916259 | 2021-11-14 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1913009 | 1913009 | 2021-11-13 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1909759 | 1909759 | 2021-11-12 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1906510 | 1906510 | 2021-11-11 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1903261 | 1903261 | 2021-11-10 | Cleveland | Oklahoma | 40027 | 44194 | 609 |
1900011 | 1900011 | 2021-11-09 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1896761 | 1896761 | 2021-11-08 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1893511 | 1893511 | 2021-11-07 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1890261 | 1890261 | 2021-11-06 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1887011 | 1887011 | 2021-11-05 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1883761 | 1883761 | 2021-11-04 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1880512 | 1880512 | 2021-11-03 | Cleveland | Oklahoma | 40027 | 43708 | 609 |
1877263 | 1877263 | 2021-11-02 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1874014 | 1874014 | 2021-11-01 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1870765 | 1870765 | 2021-10-31 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1867516 | 1867516 | 2021-10-30 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1864267 | 1864267 | 2021-10-29 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1861018 | 1861018 | 2021-10-28 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1857769 | 1857769 | 2021-10-27 | Cleveland | Oklahoma | 40027 | 43446 | 605 |
1854520 | 1854520 | 2021-10-26 | Cleveland | Oklahoma | 40027 | 43056 | 599 |
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);