ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-05-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 |
---|---|---|---|---|---|---|---|
1341378 | 1341378 | 2021-05-21 | Adair | Oklahoma | 40001 | 3182 | 41 |
1341379 | 1341379 | 2021-05-21 | Alfalfa | Oklahoma | 40003 | 1154 | 6 |
1341380 | 1341380 | 2021-05-21 | Atoka | Oklahoma | 40005 | 1873 | 25 |
1341381 | 1341381 | 2021-05-21 | Beaver | Oklahoma | 40007 | 475 | 6 |
1341382 | 1341382 | 2021-05-21 | Beckham | Oklahoma | 40009 | 2898 | 57 |
1341383 | 1341383 | 2021-05-21 | Blaine | Oklahoma | 40011 | 1045 | 19 |
1341384 | 1341384 | 2021-05-21 | Bryan | Oklahoma | 40013 | 6118 | 72 |
1341385 | 1341385 | 2021-05-21 | Caddo | Oklahoma | 40015 | 3972 | 89 |
1341386 | 1341386 | 2021-05-21 | Canadian | Oklahoma | 40017 | 17284 | 175 |
1341387 | 1341387 | 2021-05-21 | Carter | Oklahoma | 40019 | 6142 | 111 |
1341388 | 1341388 | 2021-05-21 | Cherokee | Oklahoma | 40021 | 5632 | 75 |
1341389 | 1341389 | 2021-05-21 | Choctaw | Oklahoma | 40023 | 1616 | 22 |
1341390 | 1341390 | 2021-05-21 | Cimarron | Oklahoma | 40025 | 214 | 1 |
1341391 | 1341391 | 2021-05-21 | Cleveland | Oklahoma | 40027 | 31140 | 406 |
1341392 | 1341392 | 2021-05-21 | Coal | Oklahoma | 40029 | 699 | 15 |
1341393 | 1341393 | 2021-05-21 | Comanche | Oklahoma | 40031 | 13853 | 188 |
1341394 | 1341394 | 2021-05-21 | Cotton | Oklahoma | 40033 | 695 | 16 |
1341395 | 1341395 | 2021-05-21 | Craig | Oklahoma | 40035 | 1988 | 18 |
1341396 | 1341396 | 2021-05-21 | Creek | Oklahoma | 40037 | 6972 | 157 |
1341397 | 1341397 | 2021-05-21 | Custer | Oklahoma | 40039 | 4075 | 98 |
1341398 | 1341398 | 2021-05-21 | Delaware | Oklahoma | 40041 | 4650 | 91 |
1341399 | 1341399 | 2021-05-21 | Dewey | Oklahoma | 40043 | 552 | 14 |
1341400 | 1341400 | 2021-05-21 | Ellis | Oklahoma | 40045 | 357 | 5 |
1341401 | 1341401 | 2021-05-21 | Garfield | Oklahoma | 40047 | 7806 | 131 |
1341402 | 1341402 | 2021-05-21 | Garvin | Oklahoma | 40049 | 3613 | 78 |
1341403 | 1341403 | 2021-05-21 | Grady | Oklahoma | 40051 | 5963 | 121 |
1341404 | 1341404 | 2021-05-21 | Grant | Oklahoma | 40053 | 549 | 6 |
1341405 | 1341405 | 2021-05-21 | Greer | Oklahoma | 40055 | 585 | 21 |
1341406 | 1341406 | 2021-05-21 | Harmon | Oklahoma | 40057 | 327 | 4 |
1341407 | 1341407 | 2021-05-21 | Harper | Oklahoma | 40059 | 420 | 6 |
1341408 | 1341408 | 2021-05-21 | Haskell | Oklahoma | 40061 | 1254 | 17 |
1341409 | 1341409 | 2021-05-21 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1341410 | 1341410 | 2021-05-21 | Jackson | Oklahoma | 40065 | 3117 | 56 |
1341411 | 1341411 | 2021-05-21 | Jefferson | Oklahoma | 40067 | 703 | 13 |
1341412 | 1341412 | 2021-05-21 | Johnston | Oklahoma | 40069 | 1377 | 35 |
1341413 | 1341413 | 2021-05-21 | Kay | Oklahoma | 40071 | 5325 | 126 |
1341414 | 1341414 | 2021-05-21 | Kingfisher | Oklahoma | 40073 | 2056 | 38 |
1341415 | 1341415 | 2021-05-21 | Kiowa | Oklahoma | 40075 | 818 | 25 |
1341416 | 1341416 | 2021-05-21 | Latimer | Oklahoma | 40077 | 836 | 13 |
1341417 | 1341417 | 2021-05-21 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1341418 | 1341418 | 2021-05-21 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1341419 | 1341419 | 2021-05-21 | Logan | Oklahoma | 40083 | 4276 | 57 |
1341420 | 1341420 | 2021-05-21 | Love | Oklahoma | 40085 | 1504 | 21 |
1341421 | 1341421 | 2021-05-21 | Major | Oklahoma | 40093 | 956 | 21 |
1341422 | 1341422 | 2021-05-21 | Marshall | Oklahoma | 40095 | 2048 | 23 |
1341423 | 1341423 | 2021-05-21 | Mayes | Oklahoma | 40097 | 4214 | 69 |
1341424 | 1341424 | 2021-05-21 | McClain | Oklahoma | 40087 | 5306 | 69 |
1341425 | 1341425 | 2021-05-21 | McCurtain | Oklahoma | 40089 | 3946 | 90 |
1341426 | 1341426 | 2021-05-21 | McIntosh | Oklahoma | 40091 | 2010 | 59 |
1341427 | 1341427 | 2021-05-21 | Murray | Oklahoma | 40099 | 2018 | 38 |
1341428 | 1341428 | 2021-05-21 | Muskogee | Oklahoma | 40101 | 9332 | 164 |
1341429 | 1341429 | 2021-05-21 | Noble | Oklahoma | 40103 | 1380 | 19 |
1341430 | 1341430 | 2021-05-21 | Nowata | Oklahoma | 40105 | 1149 | 19 |
1341431 | 1341431 | 2021-05-21 | Okfuskee | Oklahoma | 40107 | 1789 | 31 |
1341432 | 1341432 | 2021-05-21 | Oklahoma | Oklahoma | 40109 | 87025 | 1221 |
1341433 | 1341433 | 2021-05-21 | Okmulgee | Oklahoma | 40111 | 3796 | 78 |
1341434 | 1341434 | 2021-05-21 | Osage | Oklahoma | 40113 | 4756 | 72 |
1341435 | 1341435 | 2021-05-21 | Ottawa | Oklahoma | 40115 | 3914 | 67 |
1341436 | 1341436 | 2021-05-21 | Pawnee | Oklahoma | 40117 | 1786 | 50 |
1341437 | 1341437 | 2021-05-21 | Payne | Oklahoma | 40119 | 8686 | 72 |
1341438 | 1341438 | 2021-05-21 | Pittsburg | Oklahoma | 40121 | 4648 | 70 |
1341439 | 1341439 | 2021-05-21 | Pontotoc | Oklahoma | 40123 | 5142 | 72 |
1341440 | 1341440 | 2021-05-21 | Pottawatomie | Oklahoma | 40125 | 8375 | 127 |
1341441 | 1341441 | 2021-05-21 | Pushmataha | Oklahoma | 40127 | 1010 | 20 |
1341442 | 1341442 | 2021-05-21 | Roger Mills | Oklahoma | 40129 | 389 | 12 |
1341443 | 1341443 | 2021-05-21 | Rogers | Oklahoma | 40131 | 10523 | 180 |
1341444 | 1341444 | 2021-05-21 | Seminole | Oklahoma | 40133 | 2878 | 70 |
1341445 | 1341445 | 2021-05-21 | Sequoyah | Oklahoma | 40135 | 4130 | 51 |
1341446 | 1341446 | 2021-05-21 | Stephens | Oklahoma | 40137 | 4876 | 102 |
1341447 | 1341447 | 2021-05-21 | Texas | Oklahoma | 40139 | 3527 | 34 |
1341448 | 1341448 | 2021-05-21 | Tillman | Oklahoma | 40141 | 803 | 17 |
1341449 | 1341449 | 2021-05-21 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1341450 | 1341450 | 2021-05-21 | Unknown | Oklahoma | 550 | 0 | |
1341451 | 1341451 | 2021-05-21 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1341452 | 1341452 | 2021-05-21 | Washington | Oklahoma | 40147 | 5216 | 111 |
1341453 | 1341453 | 2021-05-21 | Washita | Oklahoma | 40149 | 1084 | 22 |
1341454 | 1341454 | 2021-05-21 | Woods | Oklahoma | 40151 | 1203 | 17 |
1341455 | 1341455 | 2021-05-21 | Woodward | Oklahoma | 40153 | 3166 | 35 |
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);