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-19 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
449277 | 449277 | 2020-08-19 | Adair | Oklahoma | 40001 | 385 | 6 |
449278 | 449278 | 2020-08-19 | Alfalfa | Oklahoma | 40003 | 6 | 0 |
449279 | 449279 | 2020-08-19 | Atoka | Oklahoma | 40005 | 89 | 1 |
449280 | 449280 | 2020-08-19 | Beaver | Oklahoma | 40007 | 40 | 0 |
449281 | 449281 | 2020-08-19 | Beckham | Oklahoma | 40009 | 102 | 1 |
449282 | 449282 | 2020-08-19 | Blaine | Oklahoma | 40011 | 46 | 0 |
449283 | 449283 | 2020-08-19 | Bryan | Oklahoma | 40013 | 522 | 3 |
449284 | 449284 | 2020-08-19 | Caddo | Oklahoma | 40015 | 483 | 20 |
449285 | 449285 | 2020-08-19 | Canadian | Oklahoma | 40017 | 1347 | 9 |
449286 | 449286 | 2020-08-19 | Carter | Oklahoma | 40019 | 375 | 5 |
449287 | 449287 | 2020-08-19 | Cherokee | Oklahoma | 40021 | 531 | 3 |
449288 | 449288 | 2020-08-19 | Choctaw | Oklahoma | 40023 | 209 | 1 |
449289 | 449289 | 2020-08-19 | Cimarron | Oklahoma | 40025 | 14 | 0 |
449290 | 449290 | 2020-08-19 | Cleveland | Oklahoma | 40027 | 3336 | 61 |
449291 | 449291 | 2020-08-19 | Coal | Oklahoma | 40029 | 46 | 0 |
449292 | 449292 | 2020-08-19 | Comanche | Oklahoma | 40031 | 905 | 11 |
449293 | 449293 | 2020-08-19 | Cotton | Oklahoma | 40033 | 21 | 2 |
449294 | 449294 | 2020-08-19 | Craig | Oklahoma | 40035 | 95 | 1 |
449295 | 449295 | 2020-08-19 | Creek | Oklahoma | 40037 | 711 | 19 |
449296 | 449296 | 2020-08-19 | Custer | Oklahoma | 40039 | 247 | 0 |
449297 | 449297 | 2020-08-19 | Delaware | Oklahoma | 40041 | 480 | 20 |
449298 | 449298 | 2020-08-19 | Dewey | Oklahoma | 40043 | 14 | 0 |
449299 | 449299 | 2020-08-19 | Ellis | Oklahoma | 40045 | 5 | 0 |
449300 | 449300 | 2020-08-19 | Garfield | Oklahoma | 40047 | 656 | 9 |
449301 | 449301 | 2020-08-19 | Garvin | Oklahoma | 40049 | 248 | 4 |
449302 | 449302 | 2020-08-19 | Grady | Oklahoma | 40051 | 478 | 7 |
449303 | 449303 | 2020-08-19 | Grant | Oklahoma | 40053 | 17 | 0 |
449304 | 449304 | 2020-08-19 | Greer | Oklahoma | 40055 | 84 | 8 |
449305 | 449305 | 2020-08-19 | Harmon | Oklahoma | 40057 | 32 | 0 |
449306 | 449306 | 2020-08-19 | Harper | Oklahoma | 40059 | 13 | 0 |
449307 | 449307 | 2020-08-19 | Haskell | Oklahoma | 40061 | 94 | 1 |
449308 | 449308 | 2020-08-19 | Hughes | Oklahoma | 40063 | 184 | 3 |
449309 | 449309 | 2020-08-19 | Jackson | Oklahoma | 40065 | 546 | 7 |
449310 | 449310 | 2020-08-19 | Jefferson | Oklahoma | 40067 | 34 | 0 |
449311 | 449311 | 2020-08-19 | Johnston | Oklahoma | 40069 | 60 | 0 |
449312 | 449312 | 2020-08-19 | Kay | Oklahoma | 40071 | 271 | 11 |
449313 | 449313 | 2020-08-19 | Kingfisher | Oklahoma | 40073 | 171 | 0 |
449314 | 449314 | 2020-08-19 | Kiowa | Oklahoma | 40075 | 34 | 1 |
449315 | 449315 | 2020-08-19 | Latimer | Oklahoma | 40077 | 102 | 2 |
449316 | 449316 | 2020-08-19 | Le Flore | Oklahoma | 40079 | 449 | 3 |
449317 | 449317 | 2020-08-19 | Lincoln | Oklahoma | 40081 | 250 | 3 |
449318 | 449318 | 2020-08-19 | Logan | Oklahoma | 40083 | 248 | 1 |
449319 | 449319 | 2020-08-19 | Love | Oklahoma | 40085 | 81 | 0 |
449320 | 449320 | 2020-08-19 | Major | Oklahoma | 40093 | 38 | 1 |
449321 | 449321 | 2020-08-19 | Marshall | Oklahoma | 40095 | 123 | 1 |
449322 | 449322 | 2020-08-19 | Mayes | Oklahoma | 40097 | 376 | 8 |
449323 | 449323 | 2020-08-19 | McClain | Oklahoma | 40087 | 503 | 4 |
449324 | 449324 | 2020-08-19 | McCurtain | Oklahoma | 40089 | 902 | 29 |
449325 | 449325 | 2020-08-19 | McIntosh | Oklahoma | 40091 | 210 | 3 |
449326 | 449326 | 2020-08-19 | Murray | Oklahoma | 40099 | 81 | 0 |
449327 | 449327 | 2020-08-19 | Muskogee | Oklahoma | 40101 | 614 | 16 |
449328 | 449328 | 2020-08-19 | Noble | Oklahoma | 40103 | 92 | 2 |
449329 | 449329 | 2020-08-19 | Nowata | Oklahoma | 40105 | 67 | 1 |
449330 | 449330 | 2020-08-19 | Okfuskee | Oklahoma | 40107 | 89 | 3 |
449331 | 449331 | 2020-08-19 | Oklahoma | Oklahoma | 40109 | 11921 | 135 |
449332 | 449332 | 2020-08-19 | Okmulgee | Oklahoma | 40111 | 522 | 3 |
449333 | 449333 | 2020-08-19 | Osage | Oklahoma | 40113 | 575 | 12 |
449334 | 449334 | 2020-08-19 | Ottawa | Oklahoma | 40115 | 433 | 3 |
449335 | 449335 | 2020-08-19 | Pawnee | Oklahoma | 40117 | 172 | 3 |
449336 | 449336 | 2020-08-19 | Payne | Oklahoma | 40119 | 836 | 4 |
449337 | 449337 | 2020-08-19 | Pittsburg | Oklahoma | 40121 | 493 | 9 |
449338 | 449338 | 2020-08-19 | Pontotoc | Oklahoma | 40123 | 213 | 2 |
449339 | 449339 | 2020-08-19 | Pottawatomie | Oklahoma | 40125 | 631 | 9 |
449340 | 449340 | 2020-08-19 | Pushmataha | Oklahoma | 40127 | 118 | 0 |
449341 | 449341 | 2020-08-19 | Roger Mills | Oklahoma | 40129 | 9 | 1 |
449342 | 449342 | 2020-08-19 | Rogers | Oklahoma | 40131 | 1163 | 23 |
449343 | 449343 | 2020-08-19 | Seminole | Oklahoma | 40133 | 268 | 5 |
449344 | 449344 | 2020-08-19 | Sequoyah | Oklahoma | 40135 | 451 | 4 |
449345 | 449345 | 2020-08-19 | Stephens | Oklahoma | 40137 | 224 | 3 |
449346 | 449346 | 2020-08-19 | Texas | Oklahoma | 40139 | 1083 | 7 |
449347 | 449347 | 2020-08-19 | Tillman | Oklahoma | 40141 | 59 | 1 |
449348 | 449348 | 2020-08-19 | Tulsa | Oklahoma | 40143 | 11763 | 122 |
449349 | 449349 | 2020-08-19 | Unknown | Oklahoma | 7 | 0 | |
449350 | 449350 | 2020-08-19 | Wagoner | Oklahoma | 40145 | 996 | 23 |
449351 | 449351 | 2020-08-19 | Washington | Oklahoma | 40147 | 716 | 39 |
449352 | 449352 | 2020-08-19 | Washita | Oklahoma | 40149 | 36 | 0 |
449353 | 449353 | 2020-08-19 | Woods | Oklahoma | 40151 | 22 | 0 |
449354 | 449354 | 2020-08-19 | Woodward | Oklahoma | 40153 | 56 | 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);