ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Oklahoma" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176403 | 2176403 | 2022-02-02 | Oklahoma | Oklahoma | 40109 | 185532 | 2065 |
2173149 | 2173149 | 2022-02-01 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2169897 | 2169897 | 2022-01-31 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2166642 | 2166642 | 2022-01-30 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2163387 | 2163387 | 2022-01-29 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2160132 | 2160132 | 2022-01-28 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2156877 | 2156877 | 2022-01-27 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2153624 | 2153624 | 2022-01-26 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2150372 | 2150372 | 2022-01-25 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2147120 | 2147120 | 2022-01-24 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2143866 | 2143866 | 2022-01-23 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2140611 | 2140611 | 2022-01-22 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2137355 | 2137355 | 2022-01-21 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2134101 | 2134101 | 2022-01-20 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2130849 | 2130849 | 2022-01-19 | Oklahoma | Oklahoma | 40109 | 162459 | 2014 |
2127595 | 2127595 | 2022-01-18 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2124343 | 2124343 | 2022-01-17 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2121091 | 2121091 | 2022-01-16 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2117839 | 2117839 | 2022-01-15 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2114588 | 2114588 | 2022-01-14 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2111336 | 2111336 | 2022-01-13 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2108084 | 2108084 | 2022-01-12 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2104833 | 2104833 | 2022-01-11 | Oklahoma | Oklahoma | 40109 | 133205 | 1981 |
2101582 | 2101582 | 2022-01-10 | Oklahoma | Oklahoma | 40109 | 133205 | 1981 |
2098331 | 2098331 | 2022-01-09 | Oklahoma | Oklahoma | 40109 | 133205 | 1981 |
2095079 | 2095079 | 2022-01-08 | Oklahoma | Oklahoma | 40109 | 133205 | 1981 |
2091827 | 2091827 | 2022-01-07 | Oklahoma | Oklahoma | 40109 | 133205 | 1981 |
2088575 | 2088575 | 2022-01-06 | Oklahoma | Oklahoma | 40109 | 133209 | 1981 |
2085324 | 2085324 | 2022-01-05 | Oklahoma | Oklahoma | 40109 | 133209 | 1981 |
2082072 | 2082072 | 2022-01-04 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2078820 | 2078820 | 2022-01-03 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2075569 | 2075569 | 2022-01-02 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2072318 | 2072318 | 2022-01-01 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2069067 | 2069067 | 2021-12-31 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2065816 | 2065816 | 2021-12-30 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2062566 | 2062566 | 2021-12-29 | Oklahoma | Oklahoma | 40109 | 130316 | 1983 |
2059316 | 2059316 | 2021-12-28 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2056067 | 2056067 | 2021-12-27 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2052818 | 2052818 | 2021-12-26 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2049568 | 2049568 | 2021-12-25 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2046318 | 2046318 | 2021-12-24 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2043068 | 2043068 | 2021-12-23 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2039819 | 2039819 | 2021-12-22 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2036569 | 2036569 | 2021-12-21 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2033319 | 2033319 | 2021-12-20 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2030069 | 2030069 | 2021-12-19 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2026818 | 2026818 | 2021-12-18 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2023567 | 2023567 | 2021-12-17 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2020316 | 2020316 | 2021-12-16 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2017065 | 2017065 | 2021-12-15 | Oklahoma | Oklahoma | 40109 | 126376 | 1957 |
2013815 | 2013815 | 2021-12-14 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
2010564 | 2010564 | 2021-12-13 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
2007313 | 2007313 | 2021-12-12 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
2004062 | 2004062 | 2021-12-11 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
2000811 | 2000811 | 2021-12-10 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
1997561 | 1997561 | 2021-12-09 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
1994310 | 1994310 | 2021-12-08 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
1991059 | 1991059 | 2021-12-07 | Oklahoma | Oklahoma | 40109 | 123418 | 1937 |
1987808 | 1987808 | 2021-12-06 | Oklahoma | Oklahoma | 40109 | 123418 | 1937 |
1984558 | 1984558 | 2021-12-05 | Oklahoma | Oklahoma | 40109 | 123418 | 1937 |
1981308 | 1981308 | 2021-12-04 | Oklahoma | Oklahoma | 40109 | 123418 | 1937 |
1978058 | 1978058 | 2021-12-03 | Oklahoma | Oklahoma | 40109 | 123418 | 1937 |
1974808 | 1974808 | 2021-12-02 | Oklahoma | Oklahoma | 40109 | 123418 | 1887 |
1971559 | 1971559 | 2021-12-01 | Oklahoma | Oklahoma | 40109 | 123418 | 1887 |
1968309 | 1968309 | 2021-11-30 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1965058 | 1965058 | 2021-11-29 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1961806 | 1961806 | 2021-11-28 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1958555 | 1958555 | 2021-11-27 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1955304 | 1955304 | 2021-11-26 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1952053 | 1952053 | 2021-11-25 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1948802 | 1948802 | 2021-11-24 | Oklahoma | Oklahoma | 40109 | 122554 | 1887 |
1945551 | 1945551 | 2021-11-23 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1942300 | 1942300 | 2021-11-22 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1939050 | 1939050 | 2021-11-21 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1935800 | 1935800 | 2021-11-20 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1932550 | 1932550 | 2021-11-19 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1929299 | 1929299 | 2021-11-18 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1926049 | 1926049 | 2021-11-17 | Oklahoma | Oklahoma | 40109 | 121884 | 1887 |
1922799 | 1922799 | 2021-11-16 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1919550 | 1919550 | 2021-11-15 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1916300 | 1916300 | 2021-11-14 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1913050 | 1913050 | 2021-11-13 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1909800 | 1909800 | 2021-11-12 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1906551 | 1906551 | 2021-11-11 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1903302 | 1903302 | 2021-11-10 | Oklahoma | Oklahoma | 40109 | 120888 | 1887 |
1900052 | 1900052 | 2021-11-09 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1896802 | 1896802 | 2021-11-08 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1893552 | 1893552 | 2021-11-07 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1890302 | 1890302 | 2021-11-06 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1887052 | 1887052 | 2021-11-05 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1883802 | 1883802 | 2021-11-04 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1880553 | 1880553 | 2021-11-03 | Oklahoma | Oklahoma | 40109 | 120077 | 1887 |
1877304 | 1877304 | 2021-11-02 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1874055 | 1874055 | 2021-11-01 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1870806 | 1870806 | 2021-10-31 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1867557 | 1867557 | 2021-10-30 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1864308 | 1864308 | 2021-10-29 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1861059 | 1861059 | 2021-10-28 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1857810 | 1857810 | 2021-10-27 | Oklahoma | Oklahoma | 40109 | 119447 | 1854 |
1854561 | 1854561 | 2021-10-26 | Oklahoma | Oklahoma | 40109 | 118645 | 1835 |
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);