ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Pottawatomie" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176411 | 2176411 | 2022-02-02 | Pottawatomie | Oklahoma | 40125 | 19542 | 236 |
2173157 | 2173157 | 2022-02-01 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2169905 | 2169905 | 2022-01-31 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2166650 | 2166650 | 2022-01-30 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2163395 | 2163395 | 2022-01-29 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2160140 | 2160140 | 2022-01-28 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2156885 | 2156885 | 2022-01-27 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2153632 | 2153632 | 2022-01-26 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2150380 | 2150380 | 2022-01-25 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2147128 | 2147128 | 2022-01-24 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2143874 | 2143874 | 2022-01-23 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2140619 | 2140619 | 2022-01-22 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2137363 | 2137363 | 2022-01-21 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2134109 | 2134109 | 2022-01-20 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2130857 | 2130857 | 2022-01-19 | Pottawatomie | Oklahoma | 40125 | 16430 | 228 |
2127603 | 2127603 | 2022-01-18 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2124351 | 2124351 | 2022-01-17 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2121099 | 2121099 | 2022-01-16 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2117847 | 2117847 | 2022-01-15 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2114596 | 2114596 | 2022-01-14 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2111344 | 2111344 | 2022-01-13 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2108092 | 2108092 | 2022-01-12 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2104841 | 2104841 | 2022-01-11 | Pottawatomie | Oklahoma | 40125 | 13791 | 224 |
2101590 | 2101590 | 2022-01-10 | Pottawatomie | Oklahoma | 40125 | 13791 | 224 |
2098339 | 2098339 | 2022-01-09 | Pottawatomie | Oklahoma | 40125 | 13791 | 224 |
2095087 | 2095087 | 2022-01-08 | Pottawatomie | Oklahoma | 40125 | 13791 | 224 |
2091835 | 2091835 | 2022-01-07 | Pottawatomie | Oklahoma | 40125 | 13791 | 224 |
2088583 | 2088583 | 2022-01-06 | Pottawatomie | Oklahoma | 40125 | 13792 | 224 |
2085332 | 2085332 | 2022-01-05 | Pottawatomie | Oklahoma | 40125 | 13792 | 224 |
2082080 | 2082080 | 2022-01-04 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2078828 | 2078828 | 2022-01-03 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2075577 | 2075577 | 2022-01-02 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2072326 | 2072326 | 2022-01-01 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2069075 | 2069075 | 2021-12-31 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2065824 | 2065824 | 2021-12-30 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2062574 | 2062574 | 2021-12-29 | Pottawatomie | Oklahoma | 40125 | 13389 | 214 |
2059324 | 2059324 | 2021-12-28 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2056075 | 2056075 | 2021-12-27 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2052826 | 2052826 | 2021-12-26 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2049576 | 2049576 | 2021-12-25 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2046326 | 2046326 | 2021-12-24 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2043076 | 2043076 | 2021-12-23 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2039827 | 2039827 | 2021-12-22 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2036577 | 2036577 | 2021-12-21 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2033327 | 2033327 | 2021-12-20 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2030077 | 2030077 | 2021-12-19 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2026826 | 2026826 | 2021-12-18 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2023575 | 2023575 | 2021-12-17 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2020324 | 2020324 | 2021-12-16 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2017073 | 2017073 | 2021-12-15 | Pottawatomie | Oklahoma | 40125 | 13070 | 212 |
2013823 | 2013823 | 2021-12-14 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
2010572 | 2010572 | 2021-12-13 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
2007321 | 2007321 | 2021-12-12 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
2004070 | 2004070 | 2021-12-11 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
2000819 | 2000819 | 2021-12-10 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
1997569 | 1997569 | 2021-12-09 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
1994318 | 1994318 | 2021-12-08 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
1991067 | 1991067 | 2021-12-07 | Pottawatomie | Oklahoma | 40125 | 12741 | 207 |
1987816 | 1987816 | 2021-12-06 | Pottawatomie | Oklahoma | 40125 | 12741 | 207 |
1984566 | 1984566 | 2021-12-05 | Pottawatomie | Oklahoma | 40125 | 12741 | 207 |
1981316 | 1981316 | 2021-12-04 | Pottawatomie | Oklahoma | 40125 | 12741 | 207 |
1978066 | 1978066 | 2021-12-03 | Pottawatomie | Oklahoma | 40125 | 12741 | 207 |
1974816 | 1974816 | 2021-12-02 | Pottawatomie | Oklahoma | 40125 | 12741 | 195 |
1971567 | 1971567 | 2021-12-01 | Pottawatomie | Oklahoma | 40125 | 12741 | 195 |
1968317 | 1968317 | 2021-11-30 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1965066 | 1965066 | 2021-11-29 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1961814 | 1961814 | 2021-11-28 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1958563 | 1958563 | 2021-11-27 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1955312 | 1955312 | 2021-11-26 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1952061 | 1952061 | 2021-11-25 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1948810 | 1948810 | 2021-11-24 | Pottawatomie | Oklahoma | 40125 | 12642 | 195 |
1945559 | 1945559 | 2021-11-23 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1942308 | 1942308 | 2021-11-22 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1939058 | 1939058 | 2021-11-21 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1935808 | 1935808 | 2021-11-20 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1932558 | 1932558 | 2021-11-19 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1929307 | 1929307 | 2021-11-18 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1926057 | 1926057 | 2021-11-17 | Pottawatomie | Oklahoma | 40125 | 12539 | 195 |
1922807 | 1922807 | 2021-11-16 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1919558 | 1919558 | 2021-11-15 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1916308 | 1916308 | 2021-11-14 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1913058 | 1913058 | 2021-11-13 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1909808 | 1909808 | 2021-11-12 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1906559 | 1906559 | 2021-11-11 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1903310 | 1903310 | 2021-11-10 | Pottawatomie | Oklahoma | 40125 | 12408 | 195 |
1900060 | 1900060 | 2021-11-09 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1896810 | 1896810 | 2021-11-08 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1893560 | 1893560 | 2021-11-07 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1890310 | 1890310 | 2021-11-06 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1887060 | 1887060 | 2021-11-05 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1883810 | 1883810 | 2021-11-04 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1880561 | 1880561 | 2021-11-03 | Pottawatomie | Oklahoma | 40125 | 12281 | 195 |
1877312 | 1877312 | 2021-11-02 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1874063 | 1874063 | 2021-11-01 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1870814 | 1870814 | 2021-10-31 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1867565 | 1867565 | 2021-10-30 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1864316 | 1864316 | 2021-10-29 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1861067 | 1861067 | 2021-10-28 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1857818 | 1857818 | 2021-10-27 | Pottawatomie | Oklahoma | 40125 | 12194 | 190 |
1854569 | 1854569 | 2021-10-26 | Pottawatomie | Oklahoma | 40125 | 12022 | 189 |
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);