ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where "date" is on date 2020-07-08 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
314459 | 314459 | 2020-07-08 | Adair | Oklahoma | 40001 | 130 | 4 |
314460 | 314460 | 2020-07-08 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
314461 | 314461 | 2020-07-08 | Atoka | Oklahoma | 40005 | 30 | 0 |
314462 | 314462 | 2020-07-08 | Beaver | Oklahoma | 40007 | 32 | 0 |
314463 | 314463 | 2020-07-08 | Beckham | Oklahoma | 40009 | 13 | 0 |
314464 | 314464 | 2020-07-08 | Blaine | Oklahoma | 40011 | 18 | 0 |
314465 | 314465 | 2020-07-08 | Bryan | Oklahoma | 40013 | 146 | 1 |
314466 | 314466 | 2020-07-08 | Caddo | Oklahoma | 40015 | 200 | 11 |
314467 | 314467 | 2020-07-08 | Canadian | Oklahoma | 40017 | 409 | 3 |
314468 | 314468 | 2020-07-08 | Carter | Oklahoma | 40019 | 151 | 2 |
314469 | 314469 | 2020-07-08 | Cherokee | Oklahoma | 40021 | 97 | 1 |
314470 | 314470 | 2020-07-08 | Choctaw | Oklahoma | 40023 | 121 | 1 |
314471 | 314471 | 2020-07-08 | Cimarron | Oklahoma | 40025 | 1 | 0 |
314472 | 314472 | 2020-07-08 | Cleveland | Oklahoma | 40027 | 1186 | 40 |
314473 | 314473 | 2020-07-08 | Coal | Oklahoma | 40029 | 10 | 0 |
314474 | 314474 | 2020-07-08 | Comanche | Oklahoma | 40031 | 463 | 7 |
314475 | 314475 | 2020-07-08 | Cotton | Oklahoma | 40033 | 9 | 2 |
314476 | 314476 | 2020-07-08 | Craig | Oklahoma | 40035 | 23 | 0 |
314477 | 314477 | 2020-07-08 | Creek | Oklahoma | 40037 | 194 | 7 |
314478 | 314478 | 2020-07-08 | Custer | Oklahoma | 40039 | 69 | 0 |
314479 | 314479 | 2020-07-08 | Delaware | Oklahoma | 40041 | 200 | 17 |
314480 | 314480 | 2020-07-08 | Dewey | Oklahoma | 40043 | 4 | 0 |
314481 | 314481 | 2020-07-08 | Ellis | Oklahoma | 40045 | 2 | 0 |
314482 | 314482 | 2020-07-08 | Garfield | Oklahoma | 40047 | 86 | 2 |
314483 | 314483 | 2020-07-08 | Garvin | Oklahoma | 40049 | 98 | 2 |
314484 | 314484 | 2020-07-08 | Grady | Oklahoma | 40051 | 212 | 5 |
314485 | 314485 | 2020-07-08 | Grant | Oklahoma | 40053 | 2 | 0 |
314486 | 314486 | 2020-07-08 | Greer | Oklahoma | 40055 | 67 | 7 |
314487 | 314487 | 2020-07-08 | Harmon | Oklahoma | 40057 | 3 | 0 |
314488 | 314488 | 2020-07-08 | Harper | Oklahoma | 40059 | 1 | 0 |
314489 | 314489 | 2020-07-08 | Haskell | Oklahoma | 40061 | 15 | 0 |
314490 | 314490 | 2020-07-08 | Hughes | Oklahoma | 40063 | 13 | 0 |
314491 | 314491 | 2020-07-08 | Jackson | Oklahoma | 40065 | 54 | 3 |
314492 | 314492 | 2020-07-08 | Jefferson | Oklahoma | 40067 | 13 | 0 |
314493 | 314493 | 2020-07-08 | Johnston | Oklahoma | 40069 | 15 | 0 |
314494 | 314494 | 2020-07-08 | Kay | Oklahoma | 40071 | 115 | 8 |
314495 | 314495 | 2020-07-08 | Kingfisher | Oklahoma | 40073 | 38 | 0 |
314496 | 314496 | 2020-07-08 | Kiowa | Oklahoma | 40075 | 15 | 1 |
314497 | 314497 | 2020-07-08 | Latimer | Oklahoma | 40077 | 14 | 1 |
314498 | 314498 | 2020-07-08 | Le Flore | Oklahoma | 40079 | 48 | 1 |
314499 | 314499 | 2020-07-08 | Lincoln | Oklahoma | 40081 | 38 | 2 |
314500 | 314500 | 2020-07-08 | Logan | Oklahoma | 40083 | 70 | 1 |
314501 | 314501 | 2020-07-08 | Love | Oklahoma | 40085 | 40 | 0 |
314502 | 314502 | 2020-07-08 | Major | Oklahoma | 40093 | 9 | 1 |
314503 | 314503 | 2020-07-08 | Marshall | Oklahoma | 40095 | 43 | 0 |
314504 | 314504 | 2020-07-08 | Mayes | Oklahoma | 40097 | 105 | 5 |
314505 | 314505 | 2020-07-08 | McClain | Oklahoma | 40087 | 221 | 4 |
314506 | 314506 | 2020-07-08 | McCurtain | Oklahoma | 40089 | 581 | 9 |
314507 | 314507 | 2020-07-08 | McIntosh | Oklahoma | 40091 | 71 | 1 |
314508 | 314508 | 2020-07-08 | Murray | Oklahoma | 40099 | 23 | 0 |
314509 | 314509 | 2020-07-08 | Muskogee | Oklahoma | 40101 | 159 | 12 |
314510 | 314510 | 2020-07-08 | Noble | Oklahoma | 40103 | 48 | 1 |
314511 | 314511 | 2020-07-08 | Nowata | Oklahoma | 40105 | 37 | 1 |
314512 | 314512 | 2020-07-08 | Okfuskee | Oklahoma | 40107 | 16 | 0 |
314513 | 314513 | 2020-07-08 | Oklahoma | Oklahoma | 40109 | 4039 | 71 |
314514 | 314514 | 2020-07-08 | Okmulgee | Oklahoma | 40111 | 113 | 0 |
314515 | 314515 | 2020-07-08 | Osage | Oklahoma | 40113 | 188 | 8 |
314516 | 314516 | 2020-07-08 | Ottawa | Oklahoma | 40115 | 121 | 2 |
314517 | 314517 | 2020-07-08 | Pawnee | Oklahoma | 40117 | 61 | 2 |
314518 | 314518 | 2020-07-08 | Payne | Oklahoma | 40119 | 455 | 1 |
314519 | 314519 | 2020-07-08 | Pittsburg | Oklahoma | 40121 | 69 | 3 |
314520 | 314520 | 2020-07-08 | Pontotoc | Oklahoma | 40123 | 63 | 2 |
314521 | 314521 | 2020-07-08 | Pottawatomie | Oklahoma | 40125 | 134 | 4 |
314522 | 314522 | 2020-07-08 | Pushmataha | Oklahoma | 40127 | 17 | 0 |
314523 | 314523 | 2020-07-08 | Rogers | Oklahoma | 40131 | 278 | 7 |
314524 | 314524 | 2020-07-08 | Seminole | Oklahoma | 40133 | 48 | 3 |
314525 | 314525 | 2020-07-08 | Sequoyah | Oklahoma | 40135 | 57 | 3 |
314526 | 314526 | 2020-07-08 | Stephens | Oklahoma | 40137 | 74 | 1 |
314527 | 314527 | 2020-07-08 | Texas | Oklahoma | 40139 | 998 | 6 |
314528 | 314528 | 2020-07-08 | Tillman | Oklahoma | 40141 | 25 | 1 |
314529 | 314529 | 2020-07-08 | Tulsa | Oklahoma | 40143 | 4571 | 72 |
314530 | 314530 | 2020-07-08 | Wagoner | Oklahoma | 40145 | 336 | 19 |
314531 | 314531 | 2020-07-08 | Washington | Oklahoma | 40147 | 437 | 39 |
314532 | 314532 | 2020-07-08 | Washita | Oklahoma | 40149 | 6 | 0 |
314533 | 314533 | 2020-07-08 | Woods | Oklahoma | 40151 | 9 | 0 |
314534 | 314534 | 2020-07-08 | Woodward | Oklahoma | 40153 | 15 | 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);