ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-02-26" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2254395 | 2254395 | 2022-02-26 | Adair | Oklahoma | 40001 | 7767 | 68 |
2254396 | 2254396 | 2022-02-26 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2254397 | 2254397 | 2022-02-26 | Atoka | Oklahoma | 40005 | 3786 | 45 |
2254398 | 2254398 | 2022-02-26 | Beaver | Oklahoma | 40007 | 946 | 10 |
2254399 | 2254399 | 2022-02-26 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2254400 | 2254400 | 2022-02-26 | Blaine | Oklahoma | 40011 | 2397 | 36 |
2254401 | 2254401 | 2022-02-26 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2254402 | 2254402 | 2022-02-26 | Caddo | Oklahoma | 40015 | 8159 | 153 |
2254403 | 2254403 | 2022-02-26 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2254404 | 2254404 | 2022-02-26 | Carter | Oklahoma | 40019 | 13531 | 213 |
2254405 | 2254405 | 2022-02-26 | Cherokee | Oklahoma | 40021 | 14378 | 136 |
2254406 | 2254406 | 2022-02-26 | Choctaw | Oklahoma | 40023 | 4036 | 56 |
2254407 | 2254407 | 2022-02-26 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2254408 | 2254408 | 2022-02-26 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2254409 | 2254409 | 2022-02-26 | Coal | Oklahoma | 40029 | 1637 | 20 |
2254410 | 2254410 | 2022-02-26 | Comanche | Oklahoma | 40031 | 31209 | 361 |
2254411 | 2254411 | 2022-02-26 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2254412 | 2254412 | 2022-02-26 | Craig | Oklahoma | 40035 | 4653 | 46 |
2254413 | 2254413 | 2022-02-26 | Creek | Oklahoma | 40037 | 17986 | 306 |
2254414 | 2254414 | 2022-02-26 | Custer | Oklahoma | 40039 | 7691 | 157 |
2254415 | 2254415 | 2022-02-26 | Delaware | Oklahoma | 40041 | 10940 | 190 |
2254416 | 2254416 | 2022-02-26 | Dewey | Oklahoma | 40043 | 1055 | 28 |
2254417 | 2254417 | 2022-02-26 | Ellis | Oklahoma | 40045 | 761 | 7 |
2254418 | 2254418 | 2022-02-26 | Garfield | Oklahoma | 40047 | 14952 | 259 |
2254419 | 2254419 | 2022-02-26 | Garvin | Oklahoma | 40049 | 6941 | 129 |
2254420 | 2254420 | 2022-02-26 | Grady | Oklahoma | 40051 | 13540 | 229 |
2254421 | 2254421 | 2022-02-26 | Grant | Oklahoma | 40053 | 1021 | 14 |
2254422 | 2254422 | 2022-02-26 | Greer | Oklahoma | 40055 | 1271 | 30 |
2254423 | 2254423 | 2022-02-26 | Harmon | Oklahoma | 40057 | 514 | 11 |
2254424 | 2254424 | 2022-02-26 | Harper | Oklahoma | 40059 | 700 | 12 |
2254425 | 2254425 | 2022-02-26 | Haskell | Oklahoma | 40061 | 2760 | 36 |
2254426 | 2254426 | 2022-02-26 | Hughes | Oklahoma | 40063 | 2532 | 56 |
2254427 | 2254427 | 2022-02-26 | Jackson | Oklahoma | 40065 | 6509 | 96 |
2254428 | 2254428 | 2022-02-26 | Jefferson | Oklahoma | 40067 | 1278 | 23 |
2254429 | 2254429 | 2022-02-26 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2254430 | 2254430 | 2022-02-26 | Kay | Oklahoma | 40071 | 11999 | 203 |
2254431 | 2254431 | 2022-02-26 | Kingfisher | Oklahoma | 40073 | 4015 | 59 |
2254432 | 2254432 | 2022-02-26 | Kiowa | Oklahoma | 40075 | 1940 | 50 |
2254433 | 2254433 | 2022-02-26 | Latimer | Oklahoma | 40077 | 2266 | 32 |
2254434 | 2254434 | 2022-02-26 | Le Flore | Oklahoma | 40079 | 12267 | 101 |
2254435 | 2254435 | 2022-02-26 | Lincoln | Oklahoma | 40081 | 7710 | 124 |
2254436 | 2254436 | 2022-02-26 | Logan | Oklahoma | 40083 | 10584 | 149 |
2254437 | 2254437 | 2022-02-26 | Love | Oklahoma | 40085 | 2992 | 36 |
2254438 | 2254438 | 2022-02-26 | Major | Oklahoma | 40093 | 2429 | 36 |
2254439 | 2254439 | 2022-02-26 | Marshall | Oklahoma | 40095 | 4507 | 38 |
2254440 | 2254440 | 2022-02-26 | Mayes | Oklahoma | 40097 | 10157 | 148 |
2254441 | 2254441 | 2022-02-26 | McClain | Oklahoma | 40087 | 11474 | 122 |
2254442 | 2254442 | 2022-02-26 | McCurtain | Oklahoma | 40089 | 7967 | 152 |
2254443 | 2254443 | 2022-02-26 | McIntosh | Oklahoma | 40091 | 4865 | 114 |
2254444 | 2254444 | 2022-02-26 | Murray | Oklahoma | 40099 | 4137 | 65 |
2254445 | 2254445 | 2022-02-26 | Muskogee | Oklahoma | 40101 | 19763 | 312 |
2254446 | 2254446 | 2022-02-26 | Noble | Oklahoma | 40103 | 2991 | 36 |
2254447 | 2254447 | 2022-02-26 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2254448 | 2254448 | 2022-02-26 | Okfuskee | Oklahoma | 40107 | 3498 | 55 |
2254449 | 2254449 | 2022-02-26 | Oklahoma | Oklahoma | 40109 | 192433 | 2230 |
2254450 | 2254450 | 2022-02-26 | Okmulgee | Oklahoma | 40111 | 9608 | 170 |
2254451 | 2254451 | 2022-02-26 | Osage | Oklahoma | 40113 | 10799 | 155 |
2254452 | 2254452 | 2022-02-26 | Ottawa | Oklahoma | 40115 | 9025 | 115 |
2254453 | 2254453 | 2022-02-26 | Pawnee | Oklahoma | 40117 | 4063 | 79 |
2254454 | 2254454 | 2022-02-26 | Payne | Oklahoma | 40119 | 18044 | 147 |
2254455 | 2254455 | 2022-02-26 | Pittsburg | Oklahoma | 40121 | 10693 | 193 |
2254456 | 2254456 | 2022-02-26 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2254457 | 2254457 | 2022-02-26 | Pottawatomie | Oklahoma | 40125 | 20289 | 257 |
2254458 | 2254458 | 2022-02-26 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2254459 | 2254459 | 2022-02-26 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2254460 | 2254460 | 2022-02-26 | Rogers | Oklahoma | 40131 | 25091 | 354 |
2254461 | 2254461 | 2022-02-26 | Seminole | Oklahoma | 40133 | 6031 | 122 |
2254462 | 2254462 | 2022-02-26 | Sequoyah | Oklahoma | 40135 | 10492 | 97 |
2254463 | 2254463 | 2022-02-26 | Stephens | Oklahoma | 40137 | 10588 | 185 |
2254464 | 2254464 | 2022-02-26 | Texas | Oklahoma | 40139 | 5944 | 52 |
2254465 | 2254465 | 2022-02-26 | Tillman | Oklahoma | 40141 | 1502 | 30 |
2254466 | 2254466 | 2022-02-26 | Tulsa | Oklahoma | 40143 | 167771 | 1979 |
2254467 | 2254467 | 2022-02-26 | Unknown | Oklahoma | 4105 | 0 | |
2254468 | 2254468 | 2022-02-26 | Wagoner | Oklahoma | 40145 | 21406 | 250 |
2254469 | 2254469 | 2022-02-26 | Washington | Oklahoma | 40147 | 12553 | 236 |
2254470 | 2254470 | 2022-02-26 | Washita | Oklahoma | 40149 | 2591 | 45 |
2254471 | 2254471 | 2022-02-26 | Woods | Oklahoma | 40151 | 2334 | 33 |
2254472 | 2254472 | 2022-02-26 | Woodward | Oklahoma | 40153 | 5128 | 69 |
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);