ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
640 rows where county = "Unknown" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176421 | 2176421 | 2022-02-02 | Unknown | Oklahoma | 7161 | 4 | |
2173167 | 2173167 | 2022-02-01 | Unknown | Oklahoma | 65423 | 3 | |
2169915 | 2169915 | 2022-01-31 | Unknown | Oklahoma | 62988 | 3 | |
2166660 | 2166660 | 2022-01-30 | Unknown | Oklahoma | 39190 | 3 | |
2163405 | 2163405 | 2022-01-29 | Unknown | Oklahoma | 39190 | 3 | |
2160150 | 2160150 | 2022-01-28 | Unknown | Oklahoma | 39190 | 3 | |
2156895 | 2156895 | 2022-01-27 | Unknown | Oklahoma | 30535 | 3 | |
2153642 | 2153642 | 2022-01-26 | Unknown | Oklahoma | 17107 | 3 | |
2150390 | 2150390 | 2022-01-25 | Unknown | Oklahoma | 86217 | 3 | |
2147138 | 2147138 | 2022-01-24 | Unknown | Oklahoma | 77407 | 3 | |
2143884 | 2143884 | 2022-01-23 | Unknown | Oklahoma | 57257 | 3 | |
2140629 | 2140629 | 2022-01-22 | Unknown | Oklahoma | 57257 | 3 | |
2137373 | 2137373 | 2022-01-21 | Unknown | Oklahoma | 43686 | 3 | |
2134119 | 2134119 | 2022-01-20 | Unknown | Oklahoma | 29747 | 3 | |
2130867 | 2130867 | 2022-01-19 | Unknown | Oklahoma | 16341 | 3 | |
2127613 | 2127613 | 2022-01-18 | Unknown | Oklahoma | 78064 | 3 | |
2124361 | 2124361 | 2022-01-17 | Unknown | Oklahoma | 74211 | 3 | |
2121109 | 2121109 | 2022-01-16 | Unknown | Oklahoma | 32054 | 3 | |
2117857 | 2117857 | 2022-01-15 | Unknown | Oklahoma | 32054 | 3 | |
2114606 | 2114606 | 2022-01-14 | Unknown | Oklahoma | 32054 | 3 | |
2111354 | 2111354 | 2022-01-13 | Unknown | Oklahoma | 20739 | 3 | |
2108102 | 2108102 | 2022-01-12 | Unknown | Oklahoma | 10237 | 3 | |
2104851 | 2104851 | 2022-01-11 | Unknown | Oklahoma | 52877 | 2 | |
2101600 | 2101600 | 2022-01-10 | Unknown | Oklahoma | 47866 | 2 | |
2098349 | 2098349 | 2022-01-09 | Unknown | Oklahoma | 20808 | 2 | |
2095097 | 2095097 | 2022-01-08 | Unknown | Oklahoma | 20808 | 2 | |
2091845 | 2091845 | 2022-01-07 | Unknown | Oklahoma | 20808 | 2 | |
2088593 | 2088593 | 2022-01-06 | Unknown | Oklahoma | 14362 | 2 | |
2085342 | 2085342 | 2022-01-05 | Unknown | Oklahoma | 8082 | 2 | |
2082090 | 2082090 | 2022-01-04 | Unknown | Oklahoma | 24299 | 2 | |
2078838 | 2078838 | 2022-01-03 | Unknown | Oklahoma | 20189 | 2 | |
2075587 | 2075587 | 2022-01-02 | Unknown | Oklahoma | 12276 | 2 | |
2072336 | 2072336 | 2022-01-01 | Unknown | Oklahoma | 12276 | 2 | |
2069085 | 2069085 | 2021-12-31 | Unknown | Oklahoma | 12276 | 2 | |
2065834 | 2065834 | 2021-12-30 | Unknown | Oklahoma | 8302 | 2 | |
2062584 | 2062584 | 2021-12-29 | Unknown | Oklahoma | 4136 | 2 | |
2059334 | 2059334 | 2021-12-28 | Unknown | Oklahoma | 11451 | 2 | |
2056085 | 2056085 | 2021-12-27 | Unknown | Oklahoma | 9008 | 2 | |
2052836 | 2052836 | 2021-12-26 | Unknown | Oklahoma | 5628 | 2 | |
2049586 | 2049586 | 2021-12-25 | Unknown | Oklahoma | 5628 | 2 | |
2046336 | 2046336 | 2021-12-24 | Unknown | Oklahoma | 5628 | 2 | |
2043086 | 2043086 | 2021-12-23 | Unknown | Oklahoma | 4617 | 2 | |
2039837 | 2039837 | 2021-12-22 | Unknown | Oklahoma | 2700 | 2 | |
2036587 | 2036587 | 2021-12-21 | Unknown | Oklahoma | 8188 | 2 | |
2033337 | 2033337 | 2021-12-20 | Unknown | Oklahoma | 7624 | 2 | |
2030087 | 2030087 | 2021-12-19 | Unknown | Oklahoma | 4294 | 2 | |
2026836 | 2026836 | 2021-12-18 | Unknown | Oklahoma | 4294 | 2 | |
2023585 | 2023585 | 2021-12-17 | Unknown | Oklahoma | 4294 | 2 | |
2020334 | 2020334 | 2021-12-16 | Unknown | Oklahoma | 2967 | 2 | |
2017083 | 2017083 | 2021-12-15 | Unknown | Oklahoma | 2967 | 2 | |
2013833 | 2013833 | 2021-12-14 | Unknown | Oklahoma | 9662 | 2 | |
2010582 | 2010582 | 2021-12-13 | Unknown | Oklahoma | 9041 | 2 | |
2007331 | 2007331 | 2021-12-12 | Unknown | Oklahoma | 6668 | 2 | |
2004080 | 2004080 | 2021-12-11 | Unknown | Oklahoma | 6668 | 2 | |
2000829 | 2000829 | 2021-12-10 | Unknown | Oklahoma | 6668 | 2 | |
1997579 | 1997579 | 2021-12-09 | Unknown | Oklahoma | 3665 | 2 | |
1994328 | 1994328 | 2021-12-08 | Unknown | Oklahoma | 2212 | 2 | |
1991077 | 1991077 | 2021-12-07 | Unknown | Oklahoma | 9761 | 2 | |
1987826 | 1987826 | 2021-12-06 | Unknown | Oklahoma | 8786 | 2 | |
1984576 | 1984576 | 2021-12-05 | Unknown | Oklahoma | 4448 | 2 | |
1981326 | 1981326 | 2021-12-04 | Unknown | Oklahoma | 4448 | 2 | |
1978076 | 1978076 | 2021-12-03 | Unknown | Oklahoma | 4448 | 2 | |
1974826 | 1974826 | 2021-12-02 | Unknown | Oklahoma | 3160 | 0 | |
1971577 | 1971577 | 2021-12-01 | Unknown | Oklahoma | 1540 | 0 | |
1968327 | 1968327 | 2021-11-30 | Unknown | Oklahoma | 5720 | 0 | |
1965076 | 1965076 | 2021-11-29 | Unknown | Oklahoma | 4833 | 0 | |
1961824 | 1961824 | 2021-11-28 | Unknown | Oklahoma | 1013 | 0 | |
1958573 | 1958573 | 2021-11-27 | Unknown | Oklahoma | 1013 | 0 | |
1955322 | 1955322 | 2021-11-26 | Unknown | Oklahoma | 1013 | 0 | |
1952071 | 1952071 | 2021-11-25 | Unknown | Oklahoma | 1013 | 0 | |
1948820 | 1948820 | 2021-11-24 | Unknown | Oklahoma | 1013 | 0 | |
1945569 | 1945569 | 2021-11-23 | Unknown | Oklahoma | 5192 | 0 | |
1942318 | 1942318 | 2021-11-22 | Unknown | Oklahoma | 4806 | 0 | |
1939068 | 1939068 | 2021-11-21 | Unknown | Oklahoma | 2117 | 0 | |
1935818 | 1935818 | 2021-11-20 | Unknown | Oklahoma | 2117 | 0 | |
1932568 | 1932568 | 2021-11-19 | Unknown | Oklahoma | 2117 | 0 | |
1929317 | 1929317 | 2021-11-18 | Unknown | Oklahoma | 1147 | 0 | |
1926067 | 1926067 | 2021-11-17 | Unknown | Oklahoma | 91 | 0 | |
1922817 | 1922817 | 2021-11-16 | Unknown | Oklahoma | 5248 | 0 | |
1919568 | 1919568 | 2021-11-15 | Unknown | Oklahoma | 4903 | 0 | |
1916318 | 1916318 | 2021-11-14 | Unknown | Oklahoma | 2122 | 0 | |
1913068 | 1913068 | 2021-11-13 | Unknown | Oklahoma | 2122 | 0 | |
1909818 | 1909818 | 2021-11-12 | Unknown | Oklahoma | 2122 | 0 | |
1906569 | 1906569 | 2021-11-11 | Unknown | Oklahoma | 80 | 0 | |
1903320 | 1903320 | 2021-11-10 | Unknown | Oklahoma | 80 | 0 | |
1900070 | 1900070 | 2021-11-09 | Unknown | Oklahoma | 5004 | 0 | |
1896820 | 1896820 | 2021-11-08 | Unknown | Oklahoma | 4739 | 0 | |
1893570 | 1893570 | 2021-11-07 | Unknown | Oklahoma | 2944 | 0 | |
1890320 | 1890320 | 2021-11-06 | Unknown | Oklahoma | 2944 | 0 | |
1887070 | 1887070 | 2021-11-05 | Unknown | Oklahoma | 2944 | 0 | |
1883820 | 1883820 | 2021-11-04 | Unknown | Oklahoma | 2368 | 0 | |
1880571 | 1880571 | 2021-11-03 | Unknown | Oklahoma | 1498 | 0 | |
1877322 | 1877322 | 2021-11-02 | Unknown | Oklahoma | 5254 | 0 | |
1874073 | 1874073 | 2021-11-01 | Unknown | Oklahoma | 4474 | 0 | |
1870824 | 1870824 | 2021-10-31 | Unknown | Oklahoma | 3100 | 0 | |
1867575 | 1867575 | 2021-10-30 | Unknown | Oklahoma | 3100 | 0 | |
1864326 | 1864326 | 2021-10-29 | Unknown | Oklahoma | 3100 | 0 | |
1861077 | 1861077 | 2021-10-28 | Unknown | Oklahoma | 2180 | 0 | |
1857828 | 1857828 | 2021-10-27 | Unknown | Oklahoma | 1484 | 0 | |
1854579 | 1854579 | 2021-10-26 | Unknown | Oklahoma | 6251 | 7 |
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);