ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-07-21" 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 |
---|---|---|---|---|---|---|---|
1539389 | 1539389 | 2021-07-21 | Adair | Oklahoma | 40001 | 3370 | 45 |
1539390 | 1539390 | 2021-07-21 | Alfalfa | Oklahoma | 40003 | 1156 | 7 |
1539391 | 1539391 | 2021-07-21 | Atoka | Oklahoma | 40005 | 1922 | 28 |
1539392 | 1539392 | 2021-07-21 | Beaver | Oklahoma | 40007 | 475 | 6 |
1539393 | 1539393 | 2021-07-21 | Beckham | Oklahoma | 40009 | 2917 | 58 |
1539394 | 1539394 | 2021-07-21 | Blaine | Oklahoma | 40011 | 1063 | 20 |
1539395 | 1539395 | 2021-07-21 | Bryan | Oklahoma | 40013 | 6391 | 80 |
1539396 | 1539396 | 2021-07-21 | Caddo | Oklahoma | 40015 | 4016 | 96 |
1539397 | 1539397 | 2021-07-21 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1539398 | 1539398 | 2021-07-21 | Carter | Oklahoma | 40019 | 6486 | 132 |
1539399 | 1539399 | 2021-07-21 | Cherokee | Oklahoma | 40021 | 5838 | 79 |
1539400 | 1539400 | 2021-07-21 | Choctaw | Oklahoma | 40023 | 1669 | 27 |
1539401 | 1539401 | 2021-07-21 | Cimarron | Oklahoma | 40025 | 244 | 2 |
1539402 | 1539402 | 2021-07-21 | Cleveland | Oklahoma | 40027 | 31896 | 445 |
1539403 | 1539403 | 2021-07-21 | Coal | Oklahoma | 40029 | 723 | 15 |
1539404 | 1539404 | 2021-07-21 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1539405 | 1539405 | 2021-07-21 | Cotton | Oklahoma | 40033 | 703 | 16 |
1539406 | 1539406 | 2021-07-21 | Craig | Oklahoma | 40035 | 2172 | 18 |
1539407 | 1539407 | 2021-07-21 | Creek | Oklahoma | 40037 | 7327 | 166 |
1539408 | 1539408 | 2021-07-21 | Custer | Oklahoma | 40039 | 4116 | 105 |
1539409 | 1539409 | 2021-07-21 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1539410 | 1539410 | 2021-07-21 | Dewey | Oklahoma | 40043 | 556 | 14 |
1539411 | 1539411 | 2021-07-21 | Ellis | Oklahoma | 40045 | 366 | 6 |
1539412 | 1539412 | 2021-07-21 | Garfield | Oklahoma | 40047 | 7877 | 139 |
1539413 | 1539413 | 2021-07-21 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1539414 | 1539414 | 2021-07-21 | Grady | Oklahoma | 40051 | 6064 | 130 |
1539415 | 1539415 | 2021-07-21 | Grant | Oklahoma | 40053 | 555 | 7 |
1539416 | 1539416 | 2021-07-21 | Greer | Oklahoma | 40055 | 591 | 22 |
1539417 | 1539417 | 2021-07-21 | Harmon | Oklahoma | 40057 | 328 | 6 |
1539418 | 1539418 | 2021-07-21 | Harper | Oklahoma | 40059 | 422 | 8 |
1539419 | 1539419 | 2021-07-21 | Haskell | Oklahoma | 40061 | 1299 | 17 |
1539420 | 1539420 | 2021-07-21 | Hughes | Oklahoma | 40063 | 1263 | 30 |
1539421 | 1539421 | 2021-07-21 | Jackson | Oklahoma | 40065 | 3158 | 56 |
1539422 | 1539422 | 2021-07-21 | Jefferson | Oklahoma | 40067 | 716 | 18 |
1539423 | 1539423 | 2021-07-21 | Johnston | Oklahoma | 40069 | 1440 | 37 |
1539424 | 1539424 | 2021-07-21 | Kay | Oklahoma | 40071 | 5405 | 128 |
1539425 | 1539425 | 2021-07-21 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1539426 | 1539426 | 2021-07-21 | Kiowa | Oklahoma | 40075 | 824 | 26 |
1539427 | 1539427 | 2021-07-21 | Latimer | Oklahoma | 40077 | 876 | 13 |
1539428 | 1539428 | 2021-07-21 | Le Flore | Oklahoma | 40079 | 5827 | 67 |
1539429 | 1539429 | 2021-07-21 | Lincoln | Oklahoma | 40081 | 3337 | 73 |
1539430 | 1539430 | 2021-07-21 | Logan | Oklahoma | 40083 | 4363 | 65 |
1539431 | 1539431 | 2021-07-21 | Love | Oklahoma | 40085 | 1555 | 23 |
1539432 | 1539432 | 2021-07-21 | Major | Oklahoma | 40093 | 957 | 24 |
1539433 | 1539433 | 2021-07-21 | Marshall | Oklahoma | 40095 | 2096 | 23 |
1539434 | 1539434 | 2021-07-21 | Mayes | Oklahoma | 40097 | 4507 | 75 |
1539435 | 1539435 | 2021-07-21 | McClain | Oklahoma | 40087 | 5483 | 73 |
1539436 | 1539436 | 2021-07-21 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1539437 | 1539437 | 2021-07-21 | McIntosh | Oklahoma | 40091 | 2074 | 61 |
1539438 | 1539438 | 2021-07-21 | Murray | Oklahoma | 40099 | 2078 | 44 |
1539439 | 1539439 | 2021-07-21 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1539440 | 1539440 | 2021-07-21 | Noble | Oklahoma | 40103 | 1399 | 20 |
1539441 | 1539441 | 2021-07-21 | Nowata | Oklahoma | 40105 | 1180 | 20 |
1539442 | 1539442 | 2021-07-21 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1539443 | 1539443 | 2021-07-21 | Oklahoma | Oklahoma | 40109 | 88919 | 1319 |
1539444 | 1539444 | 2021-07-21 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1539445 | 1539445 | 2021-07-21 | Osage | Oklahoma | 40113 | 4915 | 82 |
1539446 | 1539446 | 2021-07-21 | Ottawa | Oklahoma | 40115 | 4617 | 72 |
1539447 | 1539447 | 2021-07-21 | Pawnee | Oklahoma | 40117 | 1837 | 53 |
1539448 | 1539448 | 2021-07-21 | Payne | Oklahoma | 40119 | 8816 | 76 |
1539449 | 1539449 | 2021-07-21 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1539450 | 1539450 | 2021-07-21 | Pontotoc | Oklahoma | 40123 | 5250 | 80 |
1539451 | 1539451 | 2021-07-21 | Pottawatomie | Oklahoma | 40125 | 8545 | 131 |
1539452 | 1539452 | 2021-07-21 | Pushmataha | Oklahoma | 40127 | 1069 | 22 |
1539453 | 1539453 | 2021-07-21 | Roger Mills | Oklahoma | 40129 | 391 | 12 |
1539454 | 1539454 | 2021-07-21 | Rogers | Oklahoma | 40131 | 11154 | 196 |
1539455 | 1539455 | 2021-07-21 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1539456 | 1539456 | 2021-07-21 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1539457 | 1539457 | 2021-07-21 | Stephens | Oklahoma | 40137 | 4987 | 107 |
1539458 | 1539458 | 2021-07-21 | Texas | Oklahoma | 40139 | 3557 | 35 |
1539459 | 1539459 | 2021-07-21 | Tillman | Oklahoma | 40141 | 811 | 17 |
1539460 | 1539460 | 2021-07-21 | Tulsa | Oklahoma | 40143 | 78445 | 1148 |
1539461 | 1539461 | 2021-07-21 | Unknown | Oklahoma | 1674 | 0 | |
1539462 | 1539462 | 2021-07-21 | Wagoner | Oklahoma | 40145 | 8522 | 124 |
1539463 | 1539463 | 2021-07-21 | Washington | Oklahoma | 40147 | 5500 | 119 |
1539464 | 1539464 | 2021-07-21 | Washita | Oklahoma | 40149 | 1103 | 23 |
1539465 | 1539465 | 2021-07-21 | Woods | Oklahoma | 40151 | 1230 | 18 |
1539466 | 1539466 | 2021-07-21 | Woodward | Oklahoma | 40153 | 3177 | 37 |
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);