ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-07-17" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1526400 | 1526400 | 2021-07-17 | Adair | Oklahoma | 40001 | 3304 | 45 |
1526401 | 1526401 | 2021-07-17 | Alfalfa | Oklahoma | 40003 | 1156 | 7 |
1526402 | 1526402 | 2021-07-17 | Atoka | Oklahoma | 40005 | 1909 | 28 |
1526403 | 1526403 | 2021-07-17 | Beaver | Oklahoma | 40007 | 475 | 6 |
1526404 | 1526404 | 2021-07-17 | Beckham | Oklahoma | 40009 | 2907 | 58 |
1526405 | 1526405 | 2021-07-17 | Blaine | Oklahoma | 40011 | 1060 | 20 |
1526406 | 1526406 | 2021-07-17 | Bryan | Oklahoma | 40013 | 6303 | 79 |
1526407 | 1526407 | 2021-07-17 | Caddo | Oklahoma | 40015 | 4008 | 96 |
1526408 | 1526408 | 2021-07-17 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1526409 | 1526409 | 2021-07-17 | Carter | Oklahoma | 40019 | 6424 | 131 |
1526410 | 1526410 | 2021-07-17 | Cherokee | Oklahoma | 40021 | 5776 | 79 |
1526411 | 1526411 | 2021-07-17 | Choctaw | Oklahoma | 40023 | 1644 | 27 |
1526412 | 1526412 | 2021-07-17 | Cimarron | Oklahoma | 40025 | 239 | 2 |
1526413 | 1526413 | 2021-07-17 | Cleveland | Oklahoma | 40027 | 31669 | 441 |
1526414 | 1526414 | 2021-07-17 | Coal | Oklahoma | 40029 | 715 | 15 |
1526415 | 1526415 | 2021-07-17 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1526416 | 1526416 | 2021-07-17 | Cotton | Oklahoma | 40033 | 700 | 16 |
1526417 | 1526417 | 2021-07-17 | Craig | Oklahoma | 40035 | 2096 | 18 |
1526418 | 1526418 | 2021-07-17 | Creek | Oklahoma | 40037 | 7194 | 165 |
1526419 | 1526419 | 2021-07-17 | Custer | Oklahoma | 40039 | 4103 | 104 |
1526420 | 1526420 | 2021-07-17 | Delaware | Oklahoma | 40041 | 4974 | 98 |
1526421 | 1526421 | 2021-07-17 | Dewey | Oklahoma | 40043 | 553 | 14 |
1526422 | 1526422 | 2021-07-17 | Ellis | Oklahoma | 40045 | 364 | 6 |
1526423 | 1526423 | 2021-07-17 | Garfield | Oklahoma | 40047 | 7856 | 139 |
1526424 | 1526424 | 2021-07-17 | Garvin | Oklahoma | 40049 | 3685 | 79 |
1526425 | 1526425 | 2021-07-17 | Grady | Oklahoma | 40051 | 6037 | 130 |
1526426 | 1526426 | 2021-07-17 | Grant | Oklahoma | 40053 | 551 | 7 |
1526427 | 1526427 | 2021-07-17 | Greer | Oklahoma | 40055 | 591 | 22 |
1526428 | 1526428 | 2021-07-17 | Harmon | Oklahoma | 40057 | 328 | 6 |
1526429 | 1526429 | 2021-07-17 | Harper | Oklahoma | 40059 | 422 | 8 |
1526430 | 1526430 | 2021-07-17 | Haskell | Oklahoma | 40061 | 1280 | 17 |
1526431 | 1526431 | 2021-07-17 | Hughes | Oklahoma | 40063 | 1259 | 29 |
1526432 | 1526432 | 2021-07-17 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1526433 | 1526433 | 2021-07-17 | Jefferson | Oklahoma | 40067 | 715 | 18 |
1526434 | 1526434 | 2021-07-17 | Johnston | Oklahoma | 40069 | 1413 | 37 |
1526435 | 1526435 | 2021-07-17 | Kay | Oklahoma | 40071 | 5366 | 128 |
1526436 | 1526436 | 2021-07-17 | Kingfisher | Oklahoma | 40073 | 2063 | 41 |
1526437 | 1526437 | 2021-07-17 | Kiowa | Oklahoma | 40075 | 822 | 26 |
1526438 | 1526438 | 2021-07-17 | Latimer | Oklahoma | 40077 | 856 | 13 |
1526439 | 1526439 | 2021-07-17 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1526440 | 1526440 | 2021-07-17 | Lincoln | Oklahoma | 40081 | 3309 | 72 |
1526441 | 1526441 | 2021-07-17 | Logan | Oklahoma | 40083 | 4336 | 65 |
1526442 | 1526442 | 2021-07-17 | Love | Oklahoma | 40085 | 1547 | 23 |
1526443 | 1526443 | 2021-07-17 | Major | Oklahoma | 40093 | 956 | 24 |
1526444 | 1526444 | 2021-07-17 | Marshall | Oklahoma | 40095 | 2081 | 23 |
1526445 | 1526445 | 2021-07-17 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1526446 | 1526446 | 2021-07-17 | McClain | Oklahoma | 40087 | 5418 | 73 |
1526447 | 1526447 | 2021-07-17 | McCurtain | Oklahoma | 40089 | 4017 | 94 |
1526448 | 1526448 | 2021-07-17 | McIntosh | Oklahoma | 40091 | 2054 | 61 |
1526449 | 1526449 | 2021-07-17 | Murray | Oklahoma | 40099 | 2057 | 44 |
1526450 | 1526450 | 2021-07-17 | Muskogee | Oklahoma | 40101 | 9498 | 177 |
1526451 | 1526451 | 2021-07-17 | Noble | Oklahoma | 40103 | 1385 | 20 |
1526452 | 1526452 | 2021-07-17 | Nowata | Oklahoma | 40105 | 1171 | 20 |
1526453 | 1526453 | 2021-07-17 | Okfuskee | Oklahoma | 40107 | 1815 | 32 |
1526454 | 1526454 | 2021-07-17 | Oklahoma | Oklahoma | 40109 | 88295 | 1313 |
1526455 | 1526455 | 2021-07-17 | Okmulgee | Oklahoma | 40111 | 3956 | 85 |
1526456 | 1526456 | 2021-07-17 | Osage | Oklahoma | 40113 | 4848 | 81 |
1526457 | 1526457 | 2021-07-17 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1526458 | 1526458 | 2021-07-17 | Pawnee | Oklahoma | 40117 | 1806 | 53 |
1526459 | 1526459 | 2021-07-17 | Payne | Oklahoma | 40119 | 8772 | 76 |
1526460 | 1526460 | 2021-07-17 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1526461 | 1526461 | 2021-07-17 | Pontotoc | Oklahoma | 40123 | 5212 | 80 |
1526462 | 1526462 | 2021-07-17 | Pottawatomie | Oklahoma | 40125 | 8487 | 131 |
1526463 | 1526463 | 2021-07-17 | Pushmataha | Oklahoma | 40127 | 1038 | 22 |
1526464 | 1526464 | 2021-07-17 | Roger Mills | Oklahoma | 40129 | 391 | 12 |
1526465 | 1526465 | 2021-07-17 | Rogers | Oklahoma | 40131 | 10900 | 196 |
1526466 | 1526466 | 2021-07-17 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1526467 | 1526467 | 2021-07-17 | Sequoyah | Oklahoma | 40135 | 4267 | 57 |
1526468 | 1526468 | 2021-07-17 | Stephens | Oklahoma | 40137 | 4963 | 107 |
1526469 | 1526469 | 2021-07-17 | Texas | Oklahoma | 40139 | 3548 | 34 |
1526470 | 1526470 | 2021-07-17 | Tillman | Oklahoma | 40141 | 808 | 17 |
1526471 | 1526471 | 2021-07-17 | Tulsa | Oklahoma | 40143 | 77325 | 1135 |
1526472 | 1526472 | 2021-07-17 | Unknown | Oklahoma | 2722 | 0 | |
1526473 | 1526473 | 2021-07-17 | Wagoner | Oklahoma | 40145 | 8421 | 123 |
1526474 | 1526474 | 2021-07-17 | Washington | Oklahoma | 40147 | 5384 | 119 |
1526475 | 1526475 | 2021-07-17 | Washita | Oklahoma | 40149 | 1093 | 23 |
1526476 | 1526476 | 2021-07-17 | Woods | Oklahoma | 40151 | 1221 | 18 |
1526477 | 1526477 | 2021-07-17 | Woodward | Oklahoma | 40153 | 3175 | 36 |
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);