ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-07-01" 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 |
---|---|---|---|---|---|---|---|
1474452 | 1474452 | 2021-07-01 | Adair | Oklahoma | 40001 | 3226 | 44 |
1474453 | 1474453 | 2021-07-01 | Alfalfa | Oklahoma | 40003 | 1155 | 7 |
1474454 | 1474454 | 2021-07-01 | Atoka | Oklahoma | 40005 | 1885 | 27 |
1474455 | 1474455 | 2021-07-01 | Beaver | Oklahoma | 40007 | 475 | 6 |
1474456 | 1474456 | 2021-07-01 | Beckham | Oklahoma | 40009 | 2902 | 58 |
1474457 | 1474457 | 2021-07-01 | Blaine | Oklahoma | 40011 | 1055 | 20 |
1474458 | 1474458 | 2021-07-01 | Bryan | Oklahoma | 40013 | 6219 | 79 |
1474459 | 1474459 | 2021-07-01 | Caddo | Oklahoma | 40015 | 3997 | 96 |
1474460 | 1474460 | 2021-07-01 | Canadian | Oklahoma | 40017 | 17461 | 187 |
1474461 | 1474461 | 2021-07-01 | Carter | Oklahoma | 40019 | 6337 | 129 |
1474462 | 1474462 | 2021-07-01 | Cherokee | Oklahoma | 40021 | 5711 | 79 |
1474463 | 1474463 | 2021-07-01 | Choctaw | Oklahoma | 40023 | 1633 | 27 |
1474464 | 1474464 | 2021-07-01 | Cimarron | Oklahoma | 40025 | 219 | 2 |
1474465 | 1474465 | 2021-07-01 | Cleveland | Oklahoma | 40027 | 31412 | 439 |
1474466 | 1474466 | 2021-07-01 | Coal | Oklahoma | 40029 | 705 | 15 |
1474467 | 1474467 | 2021-07-01 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1474468 | 1474468 | 2021-07-01 | Cotton | Oklahoma | 40033 | 697 | 16 |
1474469 | 1474469 | 2021-07-01 | Craig | Oklahoma | 40035 | 2053 | 18 |
1474470 | 1474470 | 2021-07-01 | Creek | Oklahoma | 40037 | 7100 | 165 |
1474471 | 1474471 | 2021-07-01 | Custer | Oklahoma | 40039 | 4088 | 104 |
1474472 | 1474472 | 2021-07-01 | Delaware | Oklahoma | 40041 | 4780 | 96 |
1474473 | 1474473 | 2021-07-01 | Dewey | Oklahoma | 40043 | 553 | 14 |
1474474 | 1474474 | 2021-07-01 | Ellis | Oklahoma | 40045 | 357 | 6 |
1474475 | 1474475 | 2021-07-01 | Garfield | Oklahoma | 40047 | 7835 | 139 |
1474476 | 1474476 | 2021-07-01 | Garvin | Oklahoma | 40049 | 3640 | 79 |
1474477 | 1474477 | 2021-07-01 | Grady | Oklahoma | 40051 | 6001 | 130 |
1474478 | 1474478 | 2021-07-01 | Grant | Oklahoma | 40053 | 549 | 7 |
1474479 | 1474479 | 2021-07-01 | Greer | Oklahoma | 40055 | 584 | 22 |
1474480 | 1474480 | 2021-07-01 | Harmon | Oklahoma | 40057 | 327 | 6 |
1474481 | 1474481 | 2021-07-01 | Harper | Oklahoma | 40059 | 422 | 8 |
1474482 | 1474482 | 2021-07-01 | Haskell | Oklahoma | 40061 | 1267 | 17 |
1474483 | 1474483 | 2021-07-01 | Hughes | Oklahoma | 40063 | 1253 | 29 |
1474484 | 1474484 | 2021-07-01 | Jackson | Oklahoma | 40065 | 3133 | 56 |
1474485 | 1474485 | 2021-07-01 | Jefferson | Oklahoma | 40067 | 710 | 18 |
1474486 | 1474486 | 2021-07-01 | Johnston | Oklahoma | 40069 | 1385 | 37 |
1474487 | 1474487 | 2021-07-01 | Kay | Oklahoma | 40071 | 5350 | 128 |
1474488 | 1474488 | 2021-07-01 | Kingfisher | Oklahoma | 40073 | 2057 | 41 |
1474489 | 1474489 | 2021-07-01 | Kiowa | Oklahoma | 40075 | 821 | 26 |
1474490 | 1474490 | 2021-07-01 | Latimer | Oklahoma | 40077 | 844 | 13 |
1474491 | 1474491 | 2021-07-01 | Le Flore | Oklahoma | 40079 | 5680 | 67 |
1474492 | 1474492 | 2021-07-01 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1474493 | 1474493 | 2021-07-01 | Logan | Oklahoma | 40083 | 4319 | 65 |
1474494 | 1474494 | 2021-07-01 | Love | Oklahoma | 40085 | 1533 | 22 |
1474495 | 1474495 | 2021-07-01 | Major | Oklahoma | 40093 | 956 | 24 |
1474496 | 1474496 | 2021-07-01 | Marshall | Oklahoma | 40095 | 2060 | 23 |
1474497 | 1474497 | 2021-07-01 | Mayes | Oklahoma | 40097 | 4303 | 74 |
1474498 | 1474498 | 2021-07-01 | McClain | Oklahoma | 40087 | 5359 | 73 |
1474499 | 1474499 | 2021-07-01 | McCurtain | Oklahoma | 40089 | 4006 | 94 |
1474500 | 1474500 | 2021-07-01 | McIntosh | Oklahoma | 40091 | 2028 | 61 |
1474501 | 1474501 | 2021-07-01 | Murray | Oklahoma | 40099 | 2041 | 44 |
1474502 | 1474502 | 2021-07-01 | Muskogee | Oklahoma | 40101 | 9434 | 177 |
1474503 | 1474503 | 2021-07-01 | Noble | Oklahoma | 40103 | 1383 | 20 |
1474504 | 1474504 | 2021-07-01 | Nowata | Oklahoma | 40105 | 1170 | 20 |
1474505 | 1474505 | 2021-07-01 | Okfuskee | Oklahoma | 40107 | 1805 | 32 |
1474506 | 1474506 | 2021-07-01 | Oklahoma | Oklahoma | 40109 | 87823 | 1312 |
1474507 | 1474507 | 2021-07-01 | Okmulgee | Oklahoma | 40111 | 3908 | 85 |
1474508 | 1474508 | 2021-07-01 | Osage | Oklahoma | 40113 | 4812 | 80 |
1474509 | 1474509 | 2021-07-01 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1474510 | 1474510 | 2021-07-01 | Pawnee | Oklahoma | 40117 | 1801 | 53 |
1474511 | 1474511 | 2021-07-01 | Payne | Oklahoma | 40119 | 8724 | 76 |
1474512 | 1474512 | 2021-07-01 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1474513 | 1474513 | 2021-07-01 | Pontotoc | Oklahoma | 40123 | 5181 | 80 |
1474514 | 1474514 | 2021-07-01 | Pottawatomie | Oklahoma | 40125 | 8430 | 131 |
1474515 | 1474515 | 2021-07-01 | Pushmataha | Oklahoma | 40127 | 1017 | 22 |
1474516 | 1474516 | 2021-07-01 | Roger Mills | Oklahoma | 40129 | 390 | 12 |
1474517 | 1474517 | 2021-07-01 | Rogers | Oklahoma | 40131 | 10717 | 195 |
1474518 | 1474518 | 2021-07-01 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1474519 | 1474519 | 2021-07-01 | Sequoyah | Oklahoma | 40135 | 4213 | 56 |
1474520 | 1474520 | 2021-07-01 | Stephens | Oklahoma | 40137 | 4924 | 106 |
1474521 | 1474521 | 2021-07-01 | Texas | Oklahoma | 40139 | 3544 | 34 |
1474522 | 1474522 | 2021-07-01 | Tillman | Oklahoma | 40141 | 807 | 17 |
1474523 | 1474523 | 2021-07-01 | Tulsa | Oklahoma | 40143 | 76351 | 1126 |
1474524 | 1474524 | 2021-07-01 | Unknown | Oklahoma | 660 | 0 | |
1474525 | 1474525 | 2021-07-01 | Wagoner | Oklahoma | 40145 | 8290 | 123 |
1474526 | 1474526 | 2021-07-01 | Washington | Oklahoma | 40147 | 5309 | 119 |
1474527 | 1474527 | 2021-07-01 | Washita | Oklahoma | 40149 | 1089 | 23 |
1474528 | 1474528 | 2021-07-01 | Woods | Oklahoma | 40151 | 1220 | 18 |
1474529 | 1474529 | 2021-07-01 | Woodward | Oklahoma | 40153 | 3173 | 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);