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-28 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
478345 | 478345 | 2020-08-28 | Adair | Oklahoma | 40001 | 432 | 6 |
478346 | 478346 | 2020-08-28 | Alfalfa | Oklahoma | 40003 | 12 | 0 |
478347 | 478347 | 2020-08-28 | Atoka | Oklahoma | 40005 | 107 | 1 |
478348 | 478348 | 2020-08-28 | Beaver | Oklahoma | 40007 | 42 | 0 |
478349 | 478349 | 2020-08-28 | Beckham | Oklahoma | 40009 | 119 | 1 |
478350 | 478350 | 2020-08-28 | Blaine | Oklahoma | 40011 | 70 | 1 |
478351 | 478351 | 2020-08-28 | Bryan | Oklahoma | 40013 | 587 | 3 |
478352 | 478352 | 2020-08-28 | Caddo | Oklahoma | 40015 | 539 | 20 |
478353 | 478353 | 2020-08-28 | Canadian | Oklahoma | 40017 | 1502 | 11 |
478354 | 478354 | 2020-08-28 | Carter | Oklahoma | 40019 | 399 | 6 |
478355 | 478355 | 2020-08-28 | Cherokee | Oklahoma | 40021 | 638 | 5 |
478356 | 478356 | 2020-08-28 | Choctaw | Oklahoma | 40023 | 239 | 1 |
478357 | 478357 | 2020-08-28 | Cimarron | Oklahoma | 40025 | 14 | 0 |
478358 | 478358 | 2020-08-28 | Cleveland | Oklahoma | 40027 | 3749 | 63 |
478359 | 478359 | 2020-08-28 | Coal | Oklahoma | 40029 | 52 | 0 |
478360 | 478360 | 2020-08-28 | Comanche | Oklahoma | 40031 | 1212 | 11 |
478361 | 478361 | 2020-08-28 | Cotton | Oklahoma | 40033 | 26 | 2 |
478362 | 478362 | 2020-08-28 | Craig | Oklahoma | 40035 | 115 | 1 |
478363 | 478363 | 2020-08-28 | Creek | Oklahoma | 40037 | 779 | 21 |
478364 | 478364 | 2020-08-28 | Custer | Oklahoma | 40039 | 315 | 0 |
478365 | 478365 | 2020-08-28 | Delaware | Oklahoma | 40041 | 530 | 20 |
478366 | 478366 | 2020-08-28 | Dewey | Oklahoma | 40043 | 18 | 0 |
478367 | 478367 | 2020-08-28 | Ellis | Oklahoma | 40045 | 6 | 0 |
478368 | 478368 | 2020-08-28 | Garfield | Oklahoma | 40047 | 895 | 11 |
478369 | 478369 | 2020-08-28 | Garvin | Oklahoma | 40049 | 262 | 4 |
478370 | 478370 | 2020-08-28 | Grady | Oklahoma | 40051 | 516 | 7 |
478371 | 478371 | 2020-08-28 | Grant | Oklahoma | 40053 | 23 | 0 |
478372 | 478372 | 2020-08-28 | Greer | Oklahoma | 40055 | 87 | 8 |
478373 | 478373 | 2020-08-28 | Harmon | Oklahoma | 40057 | 37 | 0 |
478374 | 478374 | 2020-08-28 | Harper | Oklahoma | 40059 | 17 | 0 |
478375 | 478375 | 2020-08-28 | Haskell | Oklahoma | 40061 | 157 | 4 |
478376 | 478376 | 2020-08-28 | Hughes | Oklahoma | 40063 | 208 | 3 |
478377 | 478377 | 2020-08-28 | Jackson | Oklahoma | 40065 | 579 | 8 |
478378 | 478378 | 2020-08-28 | Jefferson | Oklahoma | 40067 | 36 | 0 |
478379 | 478379 | 2020-08-28 | Johnston | Oklahoma | 40069 | 77 | 1 |
478380 | 478380 | 2020-08-28 | Kay | Oklahoma | 40071 | 300 | 12 |
478381 | 478381 | 2020-08-28 | Kingfisher | Oklahoma | 40073 | 250 | 1 |
478382 | 478382 | 2020-08-28 | Kiowa | Oklahoma | 40075 | 40 | 1 |
478383 | 478383 | 2020-08-28 | Latimer | Oklahoma | 40077 | 109 | 2 |
478384 | 478384 | 2020-08-28 | Le Flore | Oklahoma | 40079 | 608 | 5 |
478385 | 478385 | 2020-08-28 | Lincoln | Oklahoma | 40081 | 289 | 8 |
478386 | 478386 | 2020-08-28 | Logan | Oklahoma | 40083 | 281 | 1 |
478387 | 478387 | 2020-08-28 | Love | Oklahoma | 40085 | 93 | 0 |
478388 | 478388 | 2020-08-28 | Major | Oklahoma | 40093 | 46 | 1 |
478389 | 478389 | 2020-08-28 | Marshall | Oklahoma | 40095 | 130 | 1 |
478390 | 478390 | 2020-08-28 | Mayes | Oklahoma | 40097 | 405 | 9 |
478391 | 478391 | 2020-08-28 | McClain | Oklahoma | 40087 | 551 | 4 |
478392 | 478392 | 2020-08-28 | McCurtain | Oklahoma | 40089 | 1004 | 29 |
478393 | 478393 | 2020-08-28 | McIntosh | Oklahoma | 40091 | 232 | 4 |
478394 | 478394 | 2020-08-28 | Murray | Oklahoma | 40099 | 87 | 1 |
478395 | 478395 | 2020-08-28 | Muskogee | Oklahoma | 40101 | 720 | 16 |
478396 | 478396 | 2020-08-28 | Noble | Oklahoma | 40103 | 101 | 2 |
478397 | 478397 | 2020-08-28 | Nowata | Oklahoma | 40105 | 92 | 1 |
478398 | 478398 | 2020-08-28 | Okfuskee | Oklahoma | 40107 | 98 | 3 |
478399 | 478399 | 2020-08-28 | Oklahoma | Oklahoma | 40109 | 13144 | 153 |
478400 | 478400 | 2020-08-28 | Okmulgee | Oklahoma | 40111 | 592 | 4 |
478401 | 478401 | 2020-08-28 | Osage | Oklahoma | 40113 | 614 | 12 |
478402 | 478402 | 2020-08-28 | Ottawa | Oklahoma | 40115 | 499 | 4 |
478403 | 478403 | 2020-08-28 | Pawnee | Oklahoma | 40117 | 210 | 3 |
478404 | 478404 | 2020-08-28 | Payne | Oklahoma | 40119 | 1047 | 5 |
478405 | 478405 | 2020-08-28 | Pittsburg | Oklahoma | 40121 | 564 | 15 |
478406 | 478406 | 2020-08-28 | Pontotoc | Oklahoma | 40123 | 233 | 3 |
478407 | 478407 | 2020-08-28 | Pottawatomie | Oklahoma | 40125 | 801 | 9 |
478408 | 478408 | 2020-08-28 | Pushmataha | Oklahoma | 40127 | 125 | 1 |
478409 | 478409 | 2020-08-28 | Roger Mills | Oklahoma | 40129 | 13 | 1 |
478410 | 478410 | 2020-08-28 | Rogers | Oklahoma | 40131 | 1279 | 40 |
478411 | 478411 | 2020-08-28 | Seminole | Oklahoma | 40133 | 305 | 5 |
478412 | 478412 | 2020-08-28 | Sequoyah | Oklahoma | 40135 | 575 | 8 |
478413 | 478413 | 2020-08-28 | Stephens | Oklahoma | 40137 | 247 | 4 |
478414 | 478414 | 2020-08-28 | Texas | Oklahoma | 40139 | 1127 | 7 |
478415 | 478415 | 2020-08-28 | Tillman | Oklahoma | 40141 | 64 | 1 |
478416 | 478416 | 2020-08-28 | Tulsa | Oklahoma | 40143 | 12941 | 129 |
478417 | 478417 | 2020-08-28 | Unknown | Oklahoma | 21 | 0 | |
478418 | 478418 | 2020-08-28 | Wagoner | Oklahoma | 40145 | 1114 | 23 |
478419 | 478419 | 2020-08-28 | Washington | Oklahoma | 40147 | 766 | 39 |
478420 | 478420 | 2020-08-28 | Washita | Oklahoma | 40149 | 42 | 0 |
478421 | 478421 | 2020-08-28 | Woods | Oklahoma | 40151 | 24 | 0 |
478422 | 478422 | 2020-08-28 | Woodward | Oklahoma | 40153 | 81 | 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);