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-09-10 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
520384 | 520384 | 2020-09-10 | Adair | Oklahoma | 40001 | 514 | 10 |
520385 | 520385 | 2020-09-10 | Alfalfa | Oklahoma | 40003 | 20 | 0 |
520386 | 520386 | 2020-09-10 | Atoka | Oklahoma | 40005 | 172 | 1 |
520387 | 520387 | 2020-09-10 | Beaver | Oklahoma | 40007 | 44 | 0 |
520388 | 520388 | 2020-09-10 | Beckham | Oklahoma | 40009 | 149 | 1 |
520389 | 520389 | 2020-09-10 | Blaine | Oklahoma | 40011 | 92 | 1 |
520390 | 520390 | 2020-09-10 | Bryan | Oklahoma | 40013 | 685 | 3 |
520391 | 520391 | 2020-09-10 | Caddo | Oklahoma | 40015 | 619 | 20 |
520392 | 520392 | 2020-09-10 | Canadian | Oklahoma | 40017 | 1678 | 13 |
520393 | 520393 | 2020-09-10 | Carter | Oklahoma | 40019 | 451 | 8 |
520394 | 520394 | 2020-09-10 | Cherokee | Oklahoma | 40021 | 816 | 7 |
520395 | 520395 | 2020-09-10 | Choctaw | Oklahoma | 40023 | 262 | 2 |
520396 | 520396 | 2020-09-10 | Cimarron | Oklahoma | 40025 | 17 | 0 |
520397 | 520397 | 2020-09-10 | Cleveland | Oklahoma | 40027 | 4757 | 67 |
520398 | 520398 | 2020-09-10 | Coal | Oklahoma | 40029 | 63 | 0 |
520399 | 520399 | 2020-09-10 | Comanche | Oklahoma | 40031 | 1345 | 12 |
520400 | 520400 | 2020-09-10 | Cotton | Oklahoma | 40033 | 61 | 2 |
520401 | 520401 | 2020-09-10 | Craig | Oklahoma | 40035 | 184 | 1 |
520402 | 520402 | 2020-09-10 | Creek | Oklahoma | 40037 | 925 | 25 |
520403 | 520403 | 2020-09-10 | Custer | Oklahoma | 40039 | 380 | 0 |
520404 | 520404 | 2020-09-10 | Delaware | Oklahoma | 40041 | 610 | 22 |
520405 | 520405 | 2020-09-10 | Dewey | Oklahoma | 40043 | 27 | 1 |
520406 | 520406 | 2020-09-10 | Ellis | Oklahoma | 40045 | 6 | 0 |
520407 | 520407 | 2020-09-10 | Garfield | Oklahoma | 40047 | 1227 | 16 |
520408 | 520408 | 2020-09-10 | Garvin | Oklahoma | 40049 | 290 | 4 |
520409 | 520409 | 2020-09-10 | Grady | Oklahoma | 40051 | 620 | 7 |
520410 | 520410 | 2020-09-10 | Grant | Oklahoma | 40053 | 30 | 0 |
520411 | 520411 | 2020-09-10 | Greer | Oklahoma | 40055 | 93 | 8 |
520412 | 520412 | 2020-09-10 | Harmon | Oklahoma | 40057 | 40 | 0 |
520413 | 520413 | 2020-09-10 | Harper | Oklahoma | 40059 | 24 | 0 |
520414 | 520414 | 2020-09-10 | Haskell | Oklahoma | 40061 | 197 | 4 |
520415 | 520415 | 2020-09-10 | Hughes | Oklahoma | 40063 | 249 | 4 |
520416 | 520416 | 2020-09-10 | Jackson | Oklahoma | 40065 | 637 | 9 |
520417 | 520417 | 2020-09-10 | Jefferson | Oklahoma | 40067 | 37 | 0 |
520418 | 520418 | 2020-09-10 | Johnston | Oklahoma | 40069 | 121 | 3 |
520419 | 520419 | 2020-09-10 | Kay | Oklahoma | 40071 | 386 | 12 |
520420 | 520420 | 2020-09-10 | Kingfisher | Oklahoma | 40073 | 292 | 2 |
520421 | 520421 | 2020-09-10 | Kiowa | Oklahoma | 40075 | 55 | 2 |
520422 | 520422 | 2020-09-10 | Latimer | Oklahoma | 40077 | 120 | 2 |
520423 | 520423 | 2020-09-10 | Le Flore | Oklahoma | 40079 | 819 | 12 |
520424 | 520424 | 2020-09-10 | Lincoln | Oklahoma | 40081 | 338 | 9 |
520425 | 520425 | 2020-09-10 | Logan | Oklahoma | 40083 | 347 | 1 |
520426 | 520426 | 2020-09-10 | Love | Oklahoma | 40085 | 138 | 1 |
520427 | 520427 | 2020-09-10 | Major | Oklahoma | 40093 | 58 | 1 |
520428 | 520428 | 2020-09-10 | Marshall | Oklahoma | 40095 | 144 | 1 |
520429 | 520429 | 2020-09-10 | Mayes | Oklahoma | 40097 | 477 | 10 |
520430 | 520430 | 2020-09-10 | McClain | Oklahoma | 40087 | 659 | 4 |
520431 | 520431 | 2020-09-10 | McCurtain | Oklahoma | 40089 | 1119 | 31 |
520432 | 520432 | 2020-09-10 | McIntosh | Oklahoma | 40091 | 261 | 4 |
520433 | 520433 | 2020-09-10 | Murray | Oklahoma | 40099 | 104 | 1 |
520434 | 520434 | 2020-09-10 | Muskogee | Oklahoma | 40101 | 1498 | 18 |
520435 | 520435 | 2020-09-10 | Noble | Oklahoma | 40103 | 121 | 2 |
520436 | 520436 | 2020-09-10 | Nowata | Oklahoma | 40105 | 118 | 2 |
520437 | 520437 | 2020-09-10 | Okfuskee | Oklahoma | 40107 | 116 | 3 |
520438 | 520438 | 2020-09-10 | Oklahoma | Oklahoma | 40109 | 14713 | 171 |
520439 | 520439 | 2020-09-10 | Okmulgee | Oklahoma | 40111 | 691 | 5 |
520440 | 520440 | 2020-09-10 | Osage | Oklahoma | 40113 | 720 | 13 |
520441 | 520441 | 2020-09-10 | Ottawa | Oklahoma | 40115 | 671 | 4 |
520442 | 520442 | 2020-09-10 | Pawnee | Oklahoma | 40117 | 229 | 3 |
520443 | 520443 | 2020-09-10 | Payne | Oklahoma | 40119 | 1621 | 5 |
520444 | 520444 | 2020-09-10 | Pittsburg | Oklahoma | 40121 | 675 | 19 |
520445 | 520445 | 2020-09-10 | Pontotoc | Oklahoma | 40123 | 278 | 3 |
520446 | 520446 | 2020-09-10 | Pottawatomie | Oklahoma | 40125 | 992 | 9 |
520447 | 520447 | 2020-09-10 | Pushmataha | Oklahoma | 40127 | 134 | 1 |
520448 | 520448 | 2020-09-10 | Roger Mills | Oklahoma | 40129 | 14 | 1 |
520449 | 520449 | 2020-09-10 | Rogers | Oklahoma | 40131 | 1484 | 42 |
520450 | 520450 | 2020-09-10 | Seminole | Oklahoma | 40133 | 366 | 5 |
520451 | 520451 | 2020-09-10 | Sequoyah | Oklahoma | 40135 | 663 | 8 |
520452 | 520452 | 2020-09-10 | Stephens | Oklahoma | 40137 | 300 | 4 |
520453 | 520453 | 2020-09-10 | Texas | Oklahoma | 40139 | 1282 | 7 |
520454 | 520454 | 2020-09-10 | Tillman | Oklahoma | 40141 | 74 | 1 |
520455 | 520455 | 2020-09-10 | Tulsa | Oklahoma | 40143 | 14764 | 143 |
520456 | 520456 | 2020-09-10 | Unknown | Oklahoma | 16 | 0 | |
520457 | 520457 | 2020-09-10 | Wagoner | Oklahoma | 40145 | 1290 | 23 |
520458 | 520458 | 2020-09-10 | Washington | Oklahoma | 40147 | 896 | 40 |
520459 | 520459 | 2020-09-10 | Washita | Oklahoma | 40149 | 45 | 0 |
520460 | 520460 | 2020-09-10 | Woods | Oklahoma | 40151 | 33 | 0 |
520461 | 520461 | 2020-09-10 | Woodward | Oklahoma | 40153 | 137 | 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);