ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-07-13" 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 |
---|---|---|---|---|---|---|---|
1513410 | 1513410 | 2021-07-13 | Adair | Oklahoma | 40001 | 3242 | 44 |
1513411 | 1513411 | 2021-07-13 | Alfalfa | Oklahoma | 40003 | 1156 | 7 |
1513412 | 1513412 | 2021-07-13 | Atoka | Oklahoma | 40005 | 1899 | 28 |
1513413 | 1513413 | 2021-07-13 | Beaver | Oklahoma | 40007 | 475 | 6 |
1513414 | 1513414 | 2021-07-13 | Beckham | Oklahoma | 40009 | 2902 | 58 |
1513415 | 1513415 | 2021-07-13 | Blaine | Oklahoma | 40011 | 1057 | 20 |
1513416 | 1513416 | 2021-07-13 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1513417 | 1513417 | 2021-07-13 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1513418 | 1513418 | 2021-07-13 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1513419 | 1513419 | 2021-07-13 | Carter | Oklahoma | 40019 | 6374 | 130 |
1513420 | 1513420 | 2021-07-13 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1513421 | 1513421 | 2021-07-13 | Choctaw | Oklahoma | 40023 | 1635 | 27 |
1513422 | 1513422 | 2021-07-13 | Cimarron | Oklahoma | 40025 | 231 | 2 |
1513423 | 1513423 | 2021-07-13 | Cleveland | Oklahoma | 40027 | 31520 | 440 |
1513424 | 1513424 | 2021-07-13 | Coal | Oklahoma | 40029 | 710 | 15 |
1513425 | 1513425 | 2021-07-13 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1513426 | 1513426 | 2021-07-13 | Cotton | Oklahoma | 40033 | 697 | 16 |
1513427 | 1513427 | 2021-07-13 | Craig | Oklahoma | 40035 | 2067 | 18 |
1513428 | 1513428 | 2021-07-13 | Creek | Oklahoma | 40037 | 7131 | 165 |
1513429 | 1513429 | 2021-07-13 | Custer | Oklahoma | 40039 | 4090 | 104 |
1513430 | 1513430 | 2021-07-13 | Delaware | Oklahoma | 40041 | 4856 | 98 |
1513431 | 1513431 | 2021-07-13 | Dewey | Oklahoma | 40043 | 553 | 14 |
1513432 | 1513432 | 2021-07-13 | Ellis | Oklahoma | 40045 | 361 | 6 |
1513433 | 1513433 | 2021-07-13 | Garfield | Oklahoma | 40047 | 7845 | 139 |
1513434 | 1513434 | 2021-07-13 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1513435 | 1513435 | 2021-07-13 | Grady | Oklahoma | 40051 | 6009 | 130 |
1513436 | 1513436 | 2021-07-13 | Grant | Oklahoma | 40053 | 550 | 7 |
1513437 | 1513437 | 2021-07-13 | Greer | Oklahoma | 40055 | 590 | 22 |
1513438 | 1513438 | 2021-07-13 | Harmon | Oklahoma | 40057 | 327 | 6 |
1513439 | 1513439 | 2021-07-13 | Harper | Oklahoma | 40059 | 422 | 8 |
1513440 | 1513440 | 2021-07-13 | Haskell | Oklahoma | 40061 | 1271 | 17 |
1513441 | 1513441 | 2021-07-13 | Hughes | Oklahoma | 40063 | 1256 | 29 |
1513442 | 1513442 | 2021-07-13 | Jackson | Oklahoma | 40065 | 3141 | 56 |
1513443 | 1513443 | 2021-07-13 | Jefferson | Oklahoma | 40067 | 715 | 18 |
1513444 | 1513444 | 2021-07-13 | Johnston | Oklahoma | 40069 | 1389 | 37 |
1513445 | 1513445 | 2021-07-13 | Kay | Oklahoma | 40071 | 5357 | 128 |
1513446 | 1513446 | 2021-07-13 | Kingfisher | Oklahoma | 40073 | 2058 | 41 |
1513447 | 1513447 | 2021-07-13 | Kiowa | Oklahoma | 40075 | 822 | 26 |
1513448 | 1513448 | 2021-07-13 | Latimer | Oklahoma | 40077 | 846 | 13 |
1513449 | 1513449 | 2021-07-13 | Le Flore | Oklahoma | 40079 | 5699 | 67 |
1513450 | 1513450 | 2021-07-13 | Lincoln | Oklahoma | 40081 | 3295 | 72 |
1513451 | 1513451 | 2021-07-13 | Logan | Oklahoma | 40083 | 4326 | 65 |
1513452 | 1513452 | 2021-07-13 | Love | Oklahoma | 40085 | 1540 | 22 |
1513453 | 1513453 | 2021-07-13 | Major | Oklahoma | 40093 | 956 | 24 |
1513454 | 1513454 | 2021-07-13 | Marshall | Oklahoma | 40095 | 2073 | 23 |
1513455 | 1513455 | 2021-07-13 | Mayes | Oklahoma | 40097 | 4331 | 74 |
1513456 | 1513456 | 2021-07-13 | McClain | Oklahoma | 40087 | 5385 | 73 |
1513457 | 1513457 | 2021-07-13 | McCurtain | Oklahoma | 40089 | 4010 | 94 |
1513458 | 1513458 | 2021-07-13 | McIntosh | Oklahoma | 40091 | 2040 | 61 |
1513459 | 1513459 | 2021-07-13 | Murray | Oklahoma | 40099 | 2050 | 44 |
1513460 | 1513460 | 2021-07-13 | Muskogee | Oklahoma | 40101 | 9453 | 177 |
1513461 | 1513461 | 2021-07-13 | Noble | Oklahoma | 40103 | 1384 | 20 |
1513462 | 1513462 | 2021-07-13 | Nowata | Oklahoma | 40105 | 1169 | 20 |
1513463 | 1513463 | 2021-07-13 | Okfuskee | Oklahoma | 40107 | 1809 | 32 |
1513464 | 1513464 | 2021-07-13 | Oklahoma | Oklahoma | 40109 | 87981 | 1313 |
1513465 | 1513465 | 2021-07-13 | Okmulgee | Oklahoma | 40111 | 3922 | 85 |
1513466 | 1513466 | 2021-07-13 | Osage | Oklahoma | 40113 | 4830 | 81 |
1513467 | 1513467 | 2021-07-13 | Ottawa | Oklahoma | 40115 | 4334 | 72 |
1513468 | 1513468 | 2021-07-13 | Pawnee | Oklahoma | 40117 | 1804 | 53 |
1513469 | 1513469 | 2021-07-13 | Payne | Oklahoma | 40119 | 8742 | 76 |
1513470 | 1513470 | 2021-07-13 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1513471 | 1513471 | 2021-07-13 | Pontotoc | Oklahoma | 40123 | 5196 | 80 |
1513472 | 1513472 | 2021-07-13 | Pottawatomie | Oklahoma | 40125 | 8449 | 131 |
1513473 | 1513473 | 2021-07-13 | Pushmataha | Oklahoma | 40127 | 1025 | 22 |
1513474 | 1513474 | 2021-07-13 | Roger Mills | Oklahoma | 40129 | 391 | 12 |
1513475 | 1513475 | 2021-07-13 | Rogers | Oklahoma | 40131 | 10778 | 196 |
1513476 | 1513476 | 2021-07-13 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1513477 | 1513477 | 2021-07-13 | Sequoyah | Oklahoma | 40135 | 4224 | 57 |
1513478 | 1513478 | 2021-07-13 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1513479 | 1513479 | 2021-07-13 | Texas | Oklahoma | 40139 | 3544 | 34 |
1513480 | 1513480 | 2021-07-13 | Tillman | Oklahoma | 40141 | 808 | 17 |
1513481 | 1513481 | 2021-07-13 | Tulsa | Oklahoma | 40143 | 76712 | 1131 |
1513482 | 1513482 | 2021-07-13 | Unknown | Oklahoma | 2865 | 0 | |
1513483 | 1513483 | 2021-07-13 | Wagoner | Oklahoma | 40145 | 8340 | 123 |
1513484 | 1513484 | 2021-07-13 | Washington | Oklahoma | 40147 | 5339 | 119 |
1513485 | 1513485 | 2021-07-13 | Washita | Oklahoma | 40149 | 1089 | 23 |
1513486 | 1513486 | 2021-07-13 | Woods | Oklahoma | 40151 | 1220 | 18 |
1513487 | 1513487 | 2021-07-13 | Woodward | Oklahoma | 40153 | 3174 | 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);