ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2020-08-15 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
436371 | 436371 | 2020-08-15 | Adair | Oklahoma | 40001 | 376 | 6 |
436372 | 436372 | 2020-08-15 | Alfalfa | Oklahoma | 40003 | 5 | 0 |
436373 | 436373 | 2020-08-15 | Atoka | Oklahoma | 40005 | 83 | 1 |
436374 | 436374 | 2020-08-15 | Beaver | Oklahoma | 40007 | 39 | 0 |
436375 | 436375 | 2020-08-15 | Beckham | Oklahoma | 40009 | 76 | 1 |
436376 | 436376 | 2020-08-15 | Blaine | Oklahoma | 40011 | 45 | 0 |
436377 | 436377 | 2020-08-15 | Bryan | Oklahoma | 40013 | 505 | 2 |
436378 | 436378 | 2020-08-15 | Caddo | Oklahoma | 40015 | 463 | 18 |
436379 | 436379 | 2020-08-15 | Canadian | Oklahoma | 40017 | 1314 | 9 |
436380 | 436380 | 2020-08-15 | Carter | Oklahoma | 40019 | 365 | 5 |
436381 | 436381 | 2020-08-15 | Cherokee | Oklahoma | 40021 | 504 | 2 |
436382 | 436382 | 2020-08-15 | Choctaw | Oklahoma | 40023 | 208 | 1 |
436383 | 436383 | 2020-08-15 | Cimarron | Oklahoma | 40025 | 11 | 0 |
436384 | 436384 | 2020-08-15 | Cleveland | Oklahoma | 40027 | 3179 | 57 |
436385 | 436385 | 2020-08-15 | Coal | Oklahoma | 40029 | 46 | 0 |
436386 | 436386 | 2020-08-15 | Comanche | Oklahoma | 40031 | 884 | 11 |
436387 | 436387 | 2020-08-15 | Cotton | Oklahoma | 40033 | 21 | 2 |
436388 | 436388 | 2020-08-15 | Craig | Oklahoma | 40035 | 93 | 1 |
436389 | 436389 | 2020-08-15 | Creek | Oklahoma | 40037 | 678 | 15 |
436390 | 436390 | 2020-08-15 | Custer | Oklahoma | 40039 | 227 | 0 |
436391 | 436391 | 2020-08-15 | Delaware | Oklahoma | 40041 | 467 | 20 |
436392 | 436392 | 2020-08-15 | Dewey | Oklahoma | 40043 | 12 | 0 |
436393 | 436393 | 2020-08-15 | Ellis | Oklahoma | 40045 | 5 | 0 |
436394 | 436394 | 2020-08-15 | Garfield | Oklahoma | 40047 | 571 | 8 |
436395 | 436395 | 2020-08-15 | Garvin | Oklahoma | 40049 | 241 | 4 |
436396 | 436396 | 2020-08-15 | Grady | Oklahoma | 40051 | 464 | 7 |
436397 | 436397 | 2020-08-15 | Grant | Oklahoma | 40053 | 17 | 0 |
436398 | 436398 | 2020-08-15 | Greer | Oklahoma | 40055 | 84 | 8 |
436399 | 436399 | 2020-08-15 | Harmon | Oklahoma | 40057 | 32 | 0 |
436400 | 436400 | 2020-08-15 | Harper | Oklahoma | 40059 | 11 | 0 |
436401 | 436401 | 2020-08-15 | Haskell | Oklahoma | 40061 | 88 | 1 |
436402 | 436402 | 2020-08-15 | Hughes | Oklahoma | 40063 | 177 | 2 |
436403 | 436403 | 2020-08-15 | Jackson | Oklahoma | 40065 | 537 | 7 |
436404 | 436404 | 2020-08-15 | Jefferson | Oklahoma | 40067 | 33 | 0 |
436405 | 436405 | 2020-08-15 | Johnston | Oklahoma | 40069 | 53 | 0 |
436406 | 436406 | 2020-08-15 | Kay | Oklahoma | 40071 | 265 | 11 |
436407 | 436407 | 2020-08-15 | Kingfisher | Oklahoma | 40073 | 155 | 0 |
436408 | 436408 | 2020-08-15 | Kiowa | Oklahoma | 40075 | 31 | 1 |
436409 | 436409 | 2020-08-15 | Latimer | Oklahoma | 40077 | 98 | 2 |
436410 | 436410 | 2020-08-15 | Le Flore | Oklahoma | 40079 | 423 | 1 |
436411 | 436411 | 2020-08-15 | Lincoln | Oklahoma | 40081 | 242 | 3 |
436412 | 436412 | 2020-08-15 | Logan | Oklahoma | 40083 | 242 | 1 |
436413 | 436413 | 2020-08-15 | Love | Oklahoma | 40085 | 82 | 0 |
436414 | 436414 | 2020-08-15 | Major | Oklahoma | 40093 | 39 | 1 |
436415 | 436415 | 2020-08-15 | Marshall | Oklahoma | 40095 | 121 | 1 |
436416 | 436416 | 2020-08-15 | Mayes | Oklahoma | 40097 | 365 | 8 |
436417 | 436417 | 2020-08-15 | McClain | Oklahoma | 40087 | 479 | 4 |
436418 | 436418 | 2020-08-15 | McCurtain | Oklahoma | 40089 | 886 | 28 |
436419 | 436419 | 2020-08-15 | McIntosh | Oklahoma | 40091 | 205 | 2 |
436420 | 436420 | 2020-08-15 | Murray | Oklahoma | 40099 | 79 | 0 |
436421 | 436421 | 2020-08-15 | Muskogee | Oklahoma | 40101 | 572 | 16 |
436422 | 436422 | 2020-08-15 | Noble | Oklahoma | 40103 | 91 | 2 |
436423 | 436423 | 2020-08-15 | Nowata | Oklahoma | 40105 | 62 | 1 |
436424 | 436424 | 2020-08-15 | Okfuskee | Oklahoma | 40107 | 82 | 1 |
436425 | 436425 | 2020-08-15 | Oklahoma | Oklahoma | 40109 | 11458 | 129 |
436426 | 436426 | 2020-08-15 | Okmulgee | Oklahoma | 40111 | 504 | 3 |
436427 | 436427 | 2020-08-15 | Osage | Oklahoma | 40113 | 559 | 12 |
436428 | 436428 | 2020-08-15 | Ottawa | Oklahoma | 40115 | 417 | 3 |
436429 | 436429 | 2020-08-15 | Pawnee | Oklahoma | 40117 | 166 | 3 |
436430 | 436430 | 2020-08-15 | Payne | Oklahoma | 40119 | 792 | 4 |
436431 | 436431 | 2020-08-15 | Pittsburg | Oklahoma | 40121 | 428 | 4 |
436432 | 436432 | 2020-08-15 | Pontotoc | Oklahoma | 40123 | 211 | 2 |
436433 | 436433 | 2020-08-15 | Pottawatomie | Oklahoma | 40125 | 502 | 9 |
436434 | 436434 | 2020-08-15 | Pushmataha | Oklahoma | 40127 | 116 | 0 |
436435 | 436435 | 2020-08-15 | Roger Mills | Oklahoma | 40129 | 9 | 1 |
436436 | 436436 | 2020-08-15 | Rogers | Oklahoma | 40131 | 1108 | 21 |
436437 | 436437 | 2020-08-15 | Seminole | Oklahoma | 40133 | 257 | 5 |
436438 | 436438 | 2020-08-15 | Sequoyah | Oklahoma | 40135 | 425 | 4 |
436439 | 436439 | 2020-08-15 | Stephens | Oklahoma | 40137 | 215 | 3 |
436440 | 436440 | 2020-08-15 | Texas | Oklahoma | 40139 | 1077 | 7 |
436441 | 436441 | 2020-08-15 | Tillman | Oklahoma | 40141 | 59 | 1 |
436442 | 436442 | 2020-08-15 | Tulsa | Oklahoma | 40143 | 11312 | 113 |
436443 | 436443 | 2020-08-15 | Unknown | Oklahoma | 4 | 0 | |
436444 | 436444 | 2020-08-15 | Wagoner | Oklahoma | 40145 | 954 | 23 |
436445 | 436445 | 2020-08-15 | Washington | Oklahoma | 40147 | 690 | 39 |
436446 | 436446 | 2020-08-15 | Washita | Oklahoma | 40149 | 32 | 0 |
436447 | 436447 | 2020-08-15 | Woods | Oklahoma | 40151 | 21 | 0 |
436448 | 436448 | 2020-08-15 | Woodward | Oklahoma | 40153 | 49 | 0 |
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);