ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
150 rows where deaths = 127 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501790 | 2501790 | 2022-05-13 | Ottawa | Oklahoma | 40115 | 9204 | 127 |
2498532 | 2498532 | 2022-05-12 | Ottawa | Oklahoma | 40115 | 9204 | 127 |
2495274 | 2495274 | 2022-05-11 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2492016 | 2492016 | 2022-05-10 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2488758 | 2488758 | 2022-05-09 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2485501 | 2485501 | 2022-05-08 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2482243 | 2482243 | 2022-05-07 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2478985 | 2478985 | 2022-05-06 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2475727 | 2475727 | 2022-05-05 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2472470 | 2472470 | 2022-05-04 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2469214 | 2469214 | 2022-05-03 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2465958 | 2465958 | 2022-05-02 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2462703 | 2462703 | 2022-05-01 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2459447 | 2459447 | 2022-04-30 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2456191 | 2456191 | 2022-04-29 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2452935 | 2452935 | 2022-04-28 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2312938 | 2312938 | 2022-03-16 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2312998 | 2312998 | 2022-03-16 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2309685 | 2309685 | 2022-03-15 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2309745 | 2309745 | 2022-03-15 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2306432 | 2306432 | 2022-03-14 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2306492 | 2306492 | 2022-03-14 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2303181 | 2303181 | 2022-03-13 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2303241 | 2303241 | 2022-03-13 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2299929 | 2299929 | 2022-03-12 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2299989 | 2299989 | 2022-03-12 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2296677 | 2296677 | 2022-03-11 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2296737 | 2296737 | 2022-03-11 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2293425 | 2293425 | 2022-03-10 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2293485 | 2293485 | 2022-03-10 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2290173 | 2290173 | 2022-03-09 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2290207 | 2290207 | 2022-03-09 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2286921 | 2286921 | 2022-03-08 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2286955 | 2286955 | 2022-03-08 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2283669 | 2283669 | 2022-03-07 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2283703 | 2283703 | 2022-03-07 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2280417 | 2280417 | 2022-03-06 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2280451 | 2280451 | 2022-03-06 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2277164 | 2277164 | 2022-03-05 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2277198 | 2277198 | 2022-03-05 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2273911 | 2273911 | 2022-03-04 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2273945 | 2273945 | 2022-03-04 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2270658 | 2270658 | 2022-03-03 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2270692 | 2270692 | 2022-03-03 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2267406 | 2267406 | 2022-03-02 | Bryan | Oklahoma | 40013 | 13483 | 127 |
2267440 | 2267440 | 2022-03-02 | Lincoln | Oklahoma | 40081 | 7772 | 127 |
2264153 | 2264153 | 2022-03-01 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2260903 | 2260903 | 2022-02-28 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2257652 | 2257652 | 2022-02-27 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2254401 | 2254401 | 2022-02-26 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2251150 | 2251150 | 2022-02-25 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2247899 | 2247899 | 2022-02-24 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2244648 | 2244648 | 2022-02-23 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2127600 | 2127600 | 2022-01-18 | Payne | Oklahoma | 40119 | 13546 | 127 |
2124348 | 2124348 | 2022-01-17 | Payne | Oklahoma | 40119 | 13546 | 127 |
2121096 | 2121096 | 2022-01-16 | Payne | Oklahoma | 40119 | 13546 | 127 |
2117844 | 2117844 | 2022-01-15 | Payne | Oklahoma | 40119 | 13546 | 127 |
2114593 | 2114593 | 2022-01-14 | Payne | Oklahoma | 40119 | 13546 | 127 |
2111341 | 2111341 | 2022-01-13 | Payne | Oklahoma | 40119 | 13546 | 127 |
2108089 | 2108089 | 2022-01-12 | Payne | Oklahoma | 40119 | 13546 | 127 |
2104789 | 2104789 | 2022-01-11 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2104838 | 2104838 | 2022-01-11 | Payne | Oklahoma | 40119 | 12970 | 127 |
2101538 | 2101538 | 2022-01-10 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2101587 | 2101587 | 2022-01-10 | Payne | Oklahoma | 40119 | 12970 | 127 |
2098287 | 2098287 | 2022-01-09 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2098336 | 2098336 | 2022-01-09 | Payne | Oklahoma | 40119 | 12970 | 127 |
2095035 | 2095035 | 2022-01-08 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2095084 | 2095084 | 2022-01-08 | Payne | Oklahoma | 40119 | 12970 | 127 |
2091783 | 2091783 | 2022-01-07 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2091832 | 2091832 | 2022-01-07 | Payne | Oklahoma | 40119 | 12970 | 127 |
2088531 | 2088531 | 2022-01-06 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2088580 | 2088580 | 2022-01-06 | Payne | Oklahoma | 40119 | 12970 | 127 |
2085280 | 2085280 | 2022-01-05 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2085329 | 2085329 | 2022-01-05 | Payne | Oklahoma | 40119 | 12970 | 127 |
2082059 | 2082059 | 2022-01-04 | Logan | Oklahoma | 40083 | 6686 | 127 |
2082077 | 2082077 | 2022-01-04 | Payne | Oklahoma | 40119 | 12814 | 127 |
2078807 | 2078807 | 2022-01-03 | Logan | Oklahoma | 40083 | 6686 | 127 |
2078825 | 2078825 | 2022-01-03 | Payne | Oklahoma | 40119 | 12814 | 127 |
2075556 | 2075556 | 2022-01-02 | Logan | Oklahoma | 40083 | 6686 | 127 |
2075574 | 2075574 | 2022-01-02 | Payne | Oklahoma | 40119 | 12814 | 127 |
2072305 | 2072305 | 2022-01-01 | Logan | Oklahoma | 40083 | 6686 | 127 |
2072323 | 2072323 | 2022-01-01 | Payne | Oklahoma | 40119 | 12814 | 127 |
2069054 | 2069054 | 2021-12-31 | Logan | Oklahoma | 40083 | 6686 | 127 |
2069072 | 2069072 | 2021-12-31 | Payne | Oklahoma | 40119 | 12814 | 127 |
2065803 | 2065803 | 2021-12-30 | Logan | Oklahoma | 40083 | 6686 | 127 |
2065821 | 2065821 | 2021-12-30 | Payne | Oklahoma | 40119 | 12814 | 127 |
2062553 | 2062553 | 2021-12-29 | Logan | Oklahoma | 40083 | 6686 | 127 |
2062571 | 2062571 | 2021-12-29 | Payne | Oklahoma | 40119 | 12814 | 127 |
1974810 | 1974810 | 2021-12-02 | Osage | Oklahoma | 40113 | 7218 | 127 |
1971561 | 1971561 | 2021-12-01 | Osage | Oklahoma | 40113 | 7218 | 127 |
1968311 | 1968311 | 2021-11-30 | Osage | Oklahoma | 40113 | 7155 | 127 |
1965060 | 1965060 | 2021-11-29 | Osage | Oklahoma | 40113 | 7155 | 127 |
1961808 | 1961808 | 2021-11-28 | Osage | Oklahoma | 40113 | 7155 | 127 |
1958557 | 1958557 | 2021-11-27 | Osage | Oklahoma | 40113 | 7155 | 127 |
1955306 | 1955306 | 2021-11-26 | Osage | Oklahoma | 40113 | 7155 | 127 |
1952055 | 1952055 | 2021-11-25 | Osage | Oklahoma | 40113 | 7155 | 127 |
1948804 | 1948804 | 2021-11-24 | Osage | Oklahoma | 40113 | 7155 | 127 |
1945553 | 1945553 | 2021-11-23 | Osage | Oklahoma | 40113 | 7089 | 127 |
1942302 | 1942302 | 2021-11-22 | Osage | Oklahoma | 40113 | 7089 | 127 |
1939052 | 1939052 | 2021-11-21 | Osage | Oklahoma | 40113 | 7089 | 127 |
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);