ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,508 rows where deaths = 6 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Beaver 253
- Ellis 245
- Harmon 154
- Pushmataha 76
- Roger Mills 66
- Dewey 49
- Harper 49
- Texas 44
- Seminole 42
- Muskogee 38
- Choctaw 29
- Grant 27
- Adair 25
- Kingfisher 24
- Garvin 22
- Murray 22
- Woodward 22
- Alfalfa 21
- Greer 21
- Kiowa 18
- Haskell 17
- Marshall 17
- Carter 13
- Grady 13
- Mayes 13
- Creek 12
- Okfuskee 11
- Payne 11
- Pottawatomie 11
- Washita 10
- …
state 1
- Oklahoma · 1,508 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290179 | 2290179 | 2022-03-09 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2286927 | 2286927 | 2022-03-08 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2283675 | 2283675 | 2022-03-07 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2280423 | 2280423 | 2022-03-06 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2277170 | 2277170 | 2022-03-05 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2273917 | 2273917 | 2022-03-04 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2270664 | 2270664 | 2022-03-03 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2267412 | 2267412 | 2022-03-02 | Cimarron | Oklahoma | 40025 | 562 | 6 |
2150340 | 2150340 | 2022-01-25 | Ellis | Oklahoma | 40045 | 628 | 6 |
2147088 | 2147088 | 2022-01-24 | Ellis | Oklahoma | 40045 | 628 | 6 |
2143834 | 2143834 | 2022-01-23 | Ellis | Oklahoma | 40045 | 628 | 6 |
2140579 | 2140579 | 2022-01-22 | Ellis | Oklahoma | 40045 | 628 | 6 |
2137323 | 2137323 | 2022-01-21 | Ellis | Oklahoma | 40045 | 628 | 6 |
2134069 | 2134069 | 2022-01-20 | Ellis | Oklahoma | 40045 | 628 | 6 |
2130817 | 2130817 | 2022-01-19 | Ellis | Oklahoma | 40045 | 628 | 6 |
2127563 | 2127563 | 2022-01-18 | Ellis | Oklahoma | 40045 | 604 | 6 |
2124311 | 2124311 | 2022-01-17 | Ellis | Oklahoma | 40045 | 604 | 6 |
2121059 | 2121059 | 2022-01-16 | Ellis | Oklahoma | 40045 | 604 | 6 |
2117807 | 2117807 | 2022-01-15 | Ellis | Oklahoma | 40045 | 604 | 6 |
2114556 | 2114556 | 2022-01-14 | Ellis | Oklahoma | 40045 | 604 | 6 |
2111304 | 2111304 | 2022-01-13 | Ellis | Oklahoma | 40045 | 604 | 6 |
2108052 | 2108052 | 2022-01-12 | Ellis | Oklahoma | 40045 | 604 | 6 |
2104801 | 2104801 | 2022-01-11 | Ellis | Oklahoma | 40045 | 573 | 6 |
2101550 | 2101550 | 2022-01-10 | Ellis | Oklahoma | 40045 | 573 | 6 |
2098299 | 2098299 | 2022-01-09 | Ellis | Oklahoma | 40045 | 573 | 6 |
2095047 | 2095047 | 2022-01-08 | Ellis | Oklahoma | 40045 | 573 | 6 |
2091795 | 2091795 | 2022-01-07 | Ellis | Oklahoma | 40045 | 573 | 6 |
2088543 | 2088543 | 2022-01-06 | Ellis | Oklahoma | 40045 | 573 | 6 |
2085292 | 2085292 | 2022-01-05 | Ellis | Oklahoma | 40045 | 573 | 6 |
2082040 | 2082040 | 2022-01-04 | Ellis | Oklahoma | 40045 | 556 | 6 |
2078788 | 2078788 | 2022-01-03 | Ellis | Oklahoma | 40045 | 556 | 6 |
2075537 | 2075537 | 2022-01-02 | Ellis | Oklahoma | 40045 | 556 | 6 |
2072286 | 2072286 | 2022-01-01 | Ellis | Oklahoma | 40045 | 556 | 6 |
2069035 | 2069035 | 2021-12-31 | Ellis | Oklahoma | 40045 | 556 | 6 |
2065784 | 2065784 | 2021-12-30 | Ellis | Oklahoma | 40045 | 556 | 6 |
2062534 | 2062534 | 2021-12-29 | Ellis | Oklahoma | 40045 | 556 | 6 |
2059284 | 2059284 | 2021-12-28 | Ellis | Oklahoma | 40045 | 551 | 6 |
2056035 | 2056035 | 2021-12-27 | Ellis | Oklahoma | 40045 | 551 | 6 |
2052786 | 2052786 | 2021-12-26 | Ellis | Oklahoma | 40045 | 551 | 6 |
2049536 | 2049536 | 2021-12-25 | Ellis | Oklahoma | 40045 | 551 | 6 |
2046286 | 2046286 | 2021-12-24 | Ellis | Oklahoma | 40045 | 551 | 6 |
2043036 | 2043036 | 2021-12-23 | Ellis | Oklahoma | 40045 | 551 | 6 |
2039787 | 2039787 | 2021-12-22 | Ellis | Oklahoma | 40045 | 551 | 6 |
2036537 | 2036537 | 2021-12-21 | Ellis | Oklahoma | 40045 | 545 | 6 |
2033287 | 2033287 | 2021-12-20 | Ellis | Oklahoma | 40045 | 545 | 6 |
2030037 | 2030037 | 2021-12-19 | Ellis | Oklahoma | 40045 | 545 | 6 |
2026786 | 2026786 | 2021-12-18 | Ellis | Oklahoma | 40045 | 545 | 6 |
2023535 | 2023535 | 2021-12-17 | Ellis | Oklahoma | 40045 | 545 | 6 |
2020284 | 2020284 | 2021-12-16 | Ellis | Oklahoma | 40045 | 545 | 6 |
2017033 | 2017033 | 2021-12-15 | Ellis | Oklahoma | 40045 | 545 | 6 |
2013783 | 2013783 | 2021-12-14 | Ellis | Oklahoma | 40045 | 540 | 6 |
2010532 | 2010532 | 2021-12-13 | Ellis | Oklahoma | 40045 | 540 | 6 |
2007281 | 2007281 | 2021-12-12 | Ellis | Oklahoma | 40045 | 540 | 6 |
2004030 | 2004030 | 2021-12-11 | Ellis | Oklahoma | 40045 | 540 | 6 |
2000779 | 2000779 | 2021-12-10 | Ellis | Oklahoma | 40045 | 540 | 6 |
1997529 | 1997529 | 2021-12-09 | Ellis | Oklahoma | 40045 | 540 | 6 |
1994278 | 1994278 | 2021-12-08 | Ellis | Oklahoma | 40045 | 540 | 6 |
1991027 | 1991027 | 2021-12-07 | Ellis | Oklahoma | 40045 | 524 | 6 |
1987776 | 1987776 | 2021-12-06 | Ellis | Oklahoma | 40045 | 524 | 6 |
1984526 | 1984526 | 2021-12-05 | Ellis | Oklahoma | 40045 | 524 | 6 |
1981276 | 1981276 | 2021-12-04 | Ellis | Oklahoma | 40045 | 524 | 6 |
1978026 | 1978026 | 2021-12-03 | Ellis | Oklahoma | 40045 | 524 | 6 |
1974776 | 1974776 | 2021-12-02 | Ellis | Oklahoma | 40045 | 524 | 6 |
1971527 | 1971527 | 2021-12-01 | Ellis | Oklahoma | 40045 | 524 | 6 |
1968277 | 1968277 | 2021-11-30 | Ellis | Oklahoma | 40045 | 516 | 6 |
1965026 | 1965026 | 2021-11-29 | Ellis | Oklahoma | 40045 | 516 | 6 |
1961774 | 1961774 | 2021-11-28 | Ellis | Oklahoma | 40045 | 516 | 6 |
1958523 | 1958523 | 2021-11-27 | Ellis | Oklahoma | 40045 | 516 | 6 |
1955272 | 1955272 | 2021-11-26 | Ellis | Oklahoma | 40045 | 516 | 6 |
1952021 | 1952021 | 2021-11-25 | Ellis | Oklahoma | 40045 | 516 | 6 |
1948770 | 1948770 | 2021-11-24 | Ellis | Oklahoma | 40045 | 516 | 6 |
1945519 | 1945519 | 2021-11-23 | Ellis | Oklahoma | 40045 | 509 | 6 |
1942268 | 1942268 | 2021-11-22 | Ellis | Oklahoma | 40045 | 509 | 6 |
1939018 | 1939018 | 2021-11-21 | Ellis | Oklahoma | 40045 | 509 | 6 |
1935768 | 1935768 | 2021-11-20 | Ellis | Oklahoma | 40045 | 509 | 6 |
1932518 | 1932518 | 2021-11-19 | Ellis | Oklahoma | 40045 | 509 | 6 |
1929267 | 1929267 | 2021-11-18 | Ellis | Oklahoma | 40045 | 509 | 6 |
1926017 | 1926017 | 2021-11-17 | Ellis | Oklahoma | 40045 | 509 | 6 |
1922767 | 1922767 | 2021-11-16 | Ellis | Oklahoma | 40045 | 497 | 6 |
1919518 | 1919518 | 2021-11-15 | Ellis | Oklahoma | 40045 | 497 | 6 |
1916268 | 1916268 | 2021-11-14 | Ellis | Oklahoma | 40045 | 497 | 6 |
1913018 | 1913018 | 2021-11-13 | Ellis | Oklahoma | 40045 | 497 | 6 |
1909768 | 1909768 | 2021-11-12 | Ellis | Oklahoma | 40045 | 497 | 6 |
1906519 | 1906519 | 2021-11-11 | Ellis | Oklahoma | 40045 | 497 | 6 |
1903270 | 1903270 | 2021-11-10 | Ellis | Oklahoma | 40045 | 497 | 6 |
1900020 | 1900020 | 2021-11-09 | Ellis | Oklahoma | 40045 | 486 | 6 |
1896770 | 1896770 | 2021-11-08 | Ellis | Oklahoma | 40045 | 486 | 6 |
1893520 | 1893520 | 2021-11-07 | Ellis | Oklahoma | 40045 | 486 | 6 |
1890270 | 1890270 | 2021-11-06 | Ellis | Oklahoma | 40045 | 486 | 6 |
1887020 | 1887020 | 2021-11-05 | Ellis | Oklahoma | 40045 | 486 | 6 |
1883770 | 1883770 | 2021-11-04 | Ellis | Oklahoma | 40045 | 486 | 6 |
1880521 | 1880521 | 2021-11-03 | Ellis | Oklahoma | 40045 | 486 | 6 |
1877272 | 1877272 | 2021-11-02 | Ellis | Oklahoma | 40045 | 470 | 6 |
1874023 | 1874023 | 2021-11-01 | Ellis | Oklahoma | 40045 | 470 | 6 |
1870774 | 1870774 | 2021-10-31 | Ellis | Oklahoma | 40045 | 470 | 6 |
1867525 | 1867525 | 2021-10-30 | Ellis | Oklahoma | 40045 | 470 | 6 |
1864276 | 1864276 | 2021-10-29 | Ellis | Oklahoma | 40045 | 470 | 6 |
1861027 | 1861027 | 2021-10-28 | Ellis | Oklahoma | 40045 | 470 | 6 |
1857778 | 1857778 | 2021-10-27 | Ellis | Oklahoma | 40045 | 470 | 6 |
1854529 | 1854529 | 2021-10-26 | Ellis | Oklahoma | 40045 | 453 | 6 |
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);