ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 40097 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176394 | 2176394 | 2022-02-02 | Mayes | Oklahoma | 40097 | 9704 | 140 |
2173140 | 2173140 | 2022-02-01 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2169888 | 2169888 | 2022-01-31 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2166633 | 2166633 | 2022-01-30 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2163378 | 2163378 | 2022-01-29 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2160123 | 2160123 | 2022-01-28 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2156868 | 2156868 | 2022-01-27 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2153615 | 2153615 | 2022-01-26 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2150363 | 2150363 | 2022-01-25 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2147111 | 2147111 | 2022-01-24 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2143857 | 2143857 | 2022-01-23 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2140602 | 2140602 | 2022-01-22 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2137346 | 2137346 | 2022-01-21 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2134092 | 2134092 | 2022-01-20 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2130840 | 2130840 | 2022-01-19 | Mayes | Oklahoma | 40097 | 8009 | 134 |
2127586 | 2127586 | 2022-01-18 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2124334 | 2124334 | 2022-01-17 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2121082 | 2121082 | 2022-01-16 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2117830 | 2117830 | 2022-01-15 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2114579 | 2114579 | 2022-01-14 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2111327 | 2111327 | 2022-01-13 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2108075 | 2108075 | 2022-01-12 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2104824 | 2104824 | 2022-01-11 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2101573 | 2101573 | 2022-01-10 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2098322 | 2098322 | 2022-01-09 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2095070 | 2095070 | 2022-01-08 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2091818 | 2091818 | 2022-01-07 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2088566 | 2088566 | 2022-01-06 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2085315 | 2085315 | 2022-01-05 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2082063 | 2082063 | 2022-01-04 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2078811 | 2078811 | 2022-01-03 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2075560 | 2075560 | 2022-01-02 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2072309 | 2072309 | 2022-01-01 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2069058 | 2069058 | 2021-12-31 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2065807 | 2065807 | 2021-12-30 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2062557 | 2062557 | 2021-12-29 | Mayes | Oklahoma | 40097 | 7280 | 133 |
2059307 | 2059307 | 2021-12-28 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2056058 | 2056058 | 2021-12-27 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2052809 | 2052809 | 2021-12-26 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2049559 | 2049559 | 2021-12-25 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2046309 | 2046309 | 2021-12-24 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2043059 | 2043059 | 2021-12-23 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2039810 | 2039810 | 2021-12-22 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2036560 | 2036560 | 2021-12-21 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2033310 | 2033310 | 2021-12-20 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2030060 | 2030060 | 2021-12-19 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2026809 | 2026809 | 2021-12-18 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2023558 | 2023558 | 2021-12-17 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2020307 | 2020307 | 2021-12-16 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2017056 | 2017056 | 2021-12-15 | Mayes | Oklahoma | 40097 | 7165 | 133 |
2013806 | 2013806 | 2021-12-14 | Mayes | Oklahoma | 40097 | 7103 | 131 |
2010555 | 2010555 | 2021-12-13 | Mayes | Oklahoma | 40097 | 7103 | 131 |
2007304 | 2007304 | 2021-12-12 | Mayes | Oklahoma | 40097 | 7103 | 131 |
2004053 | 2004053 | 2021-12-11 | Mayes | Oklahoma | 40097 | 7103 | 131 |
2000802 | 2000802 | 2021-12-10 | Mayes | Oklahoma | 40097 | 7103 | 131 |
1997552 | 1997552 | 2021-12-09 | Mayes | Oklahoma | 40097 | 7103 | 131 |
1994301 | 1994301 | 2021-12-08 | Mayes | Oklahoma | 40097 | 7103 | 131 |
1991050 | 1991050 | 2021-12-07 | Mayes | Oklahoma | 40097 | 7009 | 130 |
1987799 | 1987799 | 2021-12-06 | Mayes | Oklahoma | 40097 | 7009 | 130 |
1984549 | 1984549 | 2021-12-05 | Mayes | Oklahoma | 40097 | 7009 | 130 |
1981299 | 1981299 | 2021-12-04 | Mayes | Oklahoma | 40097 | 7009 | 130 |
1978049 | 1978049 | 2021-12-03 | Mayes | Oklahoma | 40097 | 7009 | 130 |
1974799 | 1974799 | 2021-12-02 | Mayes | Oklahoma | 40097 | 7009 | 126 |
1971550 | 1971550 | 2021-12-01 | Mayes | Oklahoma | 40097 | 7009 | 126 |
1968300 | 1968300 | 2021-11-30 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1965049 | 1965049 | 2021-11-29 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1961797 | 1961797 | 2021-11-28 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1958546 | 1958546 | 2021-11-27 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1955295 | 1955295 | 2021-11-26 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1952044 | 1952044 | 2021-11-25 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1948793 | 1948793 | 2021-11-24 | Mayes | Oklahoma | 40097 | 6973 | 126 |
1945542 | 1945542 | 2021-11-23 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1942291 | 1942291 | 2021-11-22 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1939041 | 1939041 | 2021-11-21 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1935791 | 1935791 | 2021-11-20 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1932541 | 1932541 | 2021-11-19 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1929290 | 1929290 | 2021-11-18 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1926040 | 1926040 | 2021-11-17 | Mayes | Oklahoma | 40097 | 6914 | 126 |
1922790 | 1922790 | 2021-11-16 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1919541 | 1919541 | 2021-11-15 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1916291 | 1916291 | 2021-11-14 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1913041 | 1913041 | 2021-11-13 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1909791 | 1909791 | 2021-11-12 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1906542 | 1906542 | 2021-11-11 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1903293 | 1903293 | 2021-11-10 | Mayes | Oklahoma | 40097 | 6869 | 126 |
1900043 | 1900043 | 2021-11-09 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1896793 | 1896793 | 2021-11-08 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1893543 | 1893543 | 2021-11-07 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1890293 | 1890293 | 2021-11-06 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1887043 | 1887043 | 2021-11-05 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1883793 | 1883793 | 2021-11-04 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1880544 | 1880544 | 2021-11-03 | Mayes | Oklahoma | 40097 | 6823 | 126 |
1877295 | 1877295 | 2021-11-02 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1874046 | 1874046 | 2021-11-01 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1870797 | 1870797 | 2021-10-31 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1867548 | 1867548 | 2021-10-30 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1864299 | 1864299 | 2021-10-29 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1861050 | 1861050 | 2021-10-28 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1857801 | 1857801 | 2021-10-27 | Mayes | Oklahoma | 40097 | 6768 | 124 |
1854552 | 1854552 | 2021-10-26 | Mayes | Oklahoma | 40097 | 6703 | 122 |
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);