ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Pontotoc" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176410 | 2176410 | 2022-02-02 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2173156 | 2173156 | 2022-02-01 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2169904 | 2169904 | 2022-01-31 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2166649 | 2166649 | 2022-01-30 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2163394 | 2163394 | 2022-01-29 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2160139 | 2160139 | 2022-01-28 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2156884 | 2156884 | 2022-01-27 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2153631 | 2153631 | 2022-01-26 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2150379 | 2150379 | 2022-01-25 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2147127 | 2147127 | 2022-01-24 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2143873 | 2143873 | 2022-01-23 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2140618 | 2140618 | 2022-01-22 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2137362 | 2137362 | 2022-01-21 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2134108 | 2134108 | 2022-01-20 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2130856 | 2130856 | 2022-01-19 | Pontotoc | Oklahoma | 40123 | 8821 | 110 |
2127602 | 2127602 | 2022-01-18 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2124350 | 2124350 | 2022-01-17 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2121098 | 2121098 | 2022-01-16 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2117846 | 2117846 | 2022-01-15 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2114595 | 2114595 | 2022-01-14 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2111343 | 2111343 | 2022-01-13 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2108091 | 2108091 | 2022-01-12 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2104840 | 2104840 | 2022-01-11 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2101589 | 2101589 | 2022-01-10 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2098338 | 2098338 | 2022-01-09 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2095086 | 2095086 | 2022-01-08 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2091834 | 2091834 | 2022-01-07 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2088582 | 2088582 | 2022-01-06 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2085331 | 2085331 | 2022-01-05 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2082079 | 2082079 | 2022-01-04 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2078827 | 2078827 | 2022-01-03 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2075576 | 2075576 | 2022-01-02 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2072325 | 2072325 | 2022-01-01 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2069074 | 2069074 | 2021-12-31 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2065823 | 2065823 | 2021-12-30 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2062573 | 2062573 | 2021-12-29 | Pontotoc | Oklahoma | 40123 | 7425 | 108 |
2059323 | 2059323 | 2021-12-28 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2056074 | 2056074 | 2021-12-27 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2052825 | 2052825 | 2021-12-26 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2049575 | 2049575 | 2021-12-25 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2046325 | 2046325 | 2021-12-24 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2043075 | 2043075 | 2021-12-23 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2039826 | 2039826 | 2021-12-22 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2036576 | 2036576 | 2021-12-21 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2033326 | 2033326 | 2021-12-20 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2030076 | 2030076 | 2021-12-19 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2026825 | 2026825 | 2021-12-18 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2023574 | 2023574 | 2021-12-17 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2020323 | 2020323 | 2021-12-16 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2017072 | 2017072 | 2021-12-15 | Pontotoc | Oklahoma | 40123 | 7270 | 107 |
2013822 | 2013822 | 2021-12-14 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
2010571 | 2010571 | 2021-12-13 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
2007320 | 2007320 | 2021-12-12 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
2004069 | 2004069 | 2021-12-11 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
2000818 | 2000818 | 2021-12-10 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
1997568 | 1997568 | 2021-12-09 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
1994317 | 1994317 | 2021-12-08 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
1991066 | 1991066 | 2021-12-07 | Pontotoc | Oklahoma | 40123 | 7103 | 106 |
1987815 | 1987815 | 2021-12-06 | Pontotoc | Oklahoma | 40123 | 7103 | 106 |
1984565 | 1984565 | 2021-12-05 | Pontotoc | Oklahoma | 40123 | 7103 | 106 |
1981315 | 1981315 | 2021-12-04 | Pontotoc | Oklahoma | 40123 | 7103 | 106 |
1978065 | 1978065 | 2021-12-03 | Pontotoc | Oklahoma | 40123 | 7103 | 106 |
1974815 | 1974815 | 2021-12-02 | Pontotoc | Oklahoma | 40123 | 7103 | 101 |
1971566 | 1971566 | 2021-12-01 | Pontotoc | Oklahoma | 40123 | 7103 | 101 |
1968316 | 1968316 | 2021-11-30 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1965065 | 1965065 | 2021-11-29 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1961813 | 1961813 | 2021-11-28 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1958562 | 1958562 | 2021-11-27 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1955311 | 1955311 | 2021-11-26 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1952060 | 1952060 | 2021-11-25 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1948809 | 1948809 | 2021-11-24 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1945558 | 1945558 | 2021-11-23 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1942307 | 1942307 | 2021-11-22 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1939057 | 1939057 | 2021-11-21 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1935807 | 1935807 | 2021-11-20 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1932557 | 1932557 | 2021-11-19 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1929306 | 1929306 | 2021-11-18 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1926056 | 1926056 | 2021-11-17 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1922806 | 1922806 | 2021-11-16 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1919557 | 1919557 | 2021-11-15 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1916307 | 1916307 | 2021-11-14 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1913057 | 1913057 | 2021-11-13 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1909807 | 1909807 | 2021-11-12 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1906558 | 1906558 | 2021-11-11 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1903309 | 1903309 | 2021-11-10 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1900059 | 1900059 | 2021-11-09 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1896809 | 1896809 | 2021-11-08 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1893559 | 1893559 | 2021-11-07 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1890309 | 1890309 | 2021-11-06 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1887059 | 1887059 | 2021-11-05 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1883809 | 1883809 | 2021-11-04 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1880560 | 1880560 | 2021-11-03 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1877311 | 1877311 | 2021-11-02 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1874062 | 1874062 | 2021-11-01 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1870813 | 1870813 | 2021-10-31 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1867564 | 1867564 | 2021-10-30 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1864315 | 1864315 | 2021-10-29 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1861066 | 1861066 | 2021-10-28 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1857817 | 1857817 | 2021-10-27 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1854568 | 1854568 | 2021-10-26 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
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);