ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-03-10" 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 |
---|---|---|---|---|---|---|---|
2293419 | 2293419 | 2022-03-10 | Adair | Oklahoma | 40001 | 7830 | 70 |
2293420 | 2293420 | 2022-03-10 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2293421 | 2293421 | 2022-03-10 | Atoka | Oklahoma | 40005 | 3848 | 46 |
2293422 | 2293422 | 2022-03-10 | Beaver | Oklahoma | 40007 | 959 | 10 |
2293423 | 2293423 | 2022-03-10 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2293424 | 2293424 | 2022-03-10 | Blaine | Oklahoma | 40011 | 2418 | 38 |
2293425 | 2293425 | 2022-03-10 | Bryan | Oklahoma | 40013 | 13534 | 127 |
2293426 | 2293426 | 2022-03-10 | Caddo | Oklahoma | 40015 | 8208 | 156 |
2293427 | 2293427 | 2022-03-10 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2293428 | 2293428 | 2022-03-10 | Carter | Oklahoma | 40019 | 14162 | 223 |
2293429 | 2293429 | 2022-03-10 | Cherokee | Oklahoma | 40021 | 14494 | 143 |
2293430 | 2293430 | 2022-03-10 | Choctaw | Oklahoma | 40023 | 4055 | 59 |
2293431 | 2293431 | 2022-03-10 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2293432 | 2293432 | 2022-03-10 | Cleveland | Oklahoma | 40027 | 78688 | 774 |
2293433 | 2293433 | 2022-03-10 | Coal | Oklahoma | 40029 | 1647 | 21 |
2293434 | 2293434 | 2022-03-10 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2293435 | 2293435 | 2022-03-10 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2293436 | 2293436 | 2022-03-10 | Craig | Oklahoma | 40035 | 4683 | 52 |
2293437 | 2293437 | 2022-03-10 | Creek | Oklahoma | 40037 | 18079 | 319 |
2293438 | 2293438 | 2022-03-10 | Custer | Oklahoma | 40039 | 7817 | 162 |
2293439 | 2293439 | 2022-03-10 | Delaware | Oklahoma | 40041 | 11009 | 195 |
2293440 | 2293440 | 2022-03-10 | Dewey | Oklahoma | 40043 | 1061 | 29 |
2293441 | 2293441 | 2022-03-10 | Ellis | Oklahoma | 40045 | 767 | 7 |
2293442 | 2293442 | 2022-03-10 | Garfield | Oklahoma | 40047 | 15131 | 272 |
2293443 | 2293443 | 2022-03-10 | Garvin | Oklahoma | 40049 | 6990 | 134 |
2293444 | 2293444 | 2022-03-10 | Grady | Oklahoma | 40051 | 13652 | 235 |
2293445 | 2293445 | 2022-03-10 | Grant | Oklahoma | 40053 | 1028 | 14 |
2293446 | 2293446 | 2022-03-10 | Greer | Oklahoma | 40055 | 1284 | 30 |
2293447 | 2293447 | 2022-03-10 | Harmon | Oklahoma | 40057 | 519 | 11 |
2293448 | 2293448 | 2022-03-10 | Harper | Oklahoma | 40059 | 706 | 12 |
2293449 | 2293449 | 2022-03-10 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2293450 | 2293450 | 2022-03-10 | Hughes | Oklahoma | 40063 | 2548 | 58 |
2293451 | 2293451 | 2022-03-10 | Jackson | Oklahoma | 40065 | 6541 | 100 |
2293452 | 2293452 | 2022-03-10 | Jefferson | Oklahoma | 40067 | 1289 | 25 |
2293453 | 2293453 | 2022-03-10 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2293454 | 2293454 | 2022-03-10 | Kay | Oklahoma | 40071 | 12204 | 209 |
2293455 | 2293455 | 2022-03-10 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2293456 | 2293456 | 2022-03-10 | Kiowa | Oklahoma | 40075 | 1942 | 50 |
2293457 | 2293457 | 2022-03-10 | Latimer | Oklahoma | 40077 | 2268 | 34 |
2293458 | 2293458 | 2022-03-10 | Le Flore | Oklahoma | 40079 | 12367 | 105 |
2293459 | 2293459 | 2022-03-10 | Lincoln | Oklahoma | 40081 | 7810 | 129 |
2293460 | 2293460 | 2022-03-10 | Logan | Oklahoma | 40083 | 10725 | 156 |
2293461 | 2293461 | 2022-03-10 | Love | Oklahoma | 40085 | 3082 | 36 |
2293462 | 2293462 | 2022-03-10 | Major | Oklahoma | 40093 | 2446 | 40 |
2293463 | 2293463 | 2022-03-10 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2293464 | 2293464 | 2022-03-10 | Mayes | Oklahoma | 40097 | 10224 | 155 |
2293465 | 2293465 | 2022-03-10 | McClain | Oklahoma | 40087 | 11549 | 128 |
2293466 | 2293466 | 2022-03-10 | McCurtain | Oklahoma | 40089 | 8015 | 160 |
2293467 | 2293467 | 2022-03-10 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2293468 | 2293468 | 2022-03-10 | Murray | Oklahoma | 40099 | 4152 | 69 |
2293469 | 2293469 | 2022-03-10 | Muskogee | Oklahoma | 40101 | 19865 | 323 |
2293470 | 2293470 | 2022-03-10 | Noble | Oklahoma | 40103 | 3022 | 36 |
2293471 | 2293471 | 2022-03-10 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2293472 | 2293472 | 2022-03-10 | Okfuskee | Oklahoma | 40107 | 3514 | 59 |
2293473 | 2293473 | 2022-03-10 | Oklahoma | Oklahoma | 40109 | 195855 | 2301 |
2293474 | 2293474 | 2022-03-10 | Okmulgee | Oklahoma | 40111 | 9648 | 175 |
2293475 | 2293475 | 2022-03-10 | Osage | Oklahoma | 40113 | 10863 | 159 |
2293476 | 2293476 | 2022-03-10 | Ottawa | Oklahoma | 40115 | 9116 | 121 |
2293477 | 2293477 | 2022-03-10 | Pawnee | Oklahoma | 40117 | 4087 | 83 |
2293478 | 2293478 | 2022-03-10 | Payne | Oklahoma | 40119 | 18175 | 157 |
2293479 | 2293479 | 2022-03-10 | Pittsburg | Oklahoma | 40121 | 10748 | 199 |
2293480 | 2293480 | 2022-03-10 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2293481 | 2293481 | 2022-03-10 | Pottawatomie | Oklahoma | 40125 | 20520 | 263 |
2293482 | 2293482 | 2022-03-10 | Pushmataha | Oklahoma | 40127 | 2644 | 44 |
2293483 | 2293483 | 2022-03-10 | Roger Mills | Oklahoma | 40129 | 864 | 15 |
2293484 | 2293484 | 2022-03-10 | Rogers | Oklahoma | 40131 | 25271 | 373 |
2293485 | 2293485 | 2022-03-10 | Seminole | Oklahoma | 40133 | 6078 | 127 |
2293486 | 2293486 | 2022-03-10 | Sequoyah | Oklahoma | 40135 | 10587 | 102 |
2293487 | 2293487 | 2022-03-10 | Stephens | Oklahoma | 40137 | 10915 | 193 |
2293488 | 2293488 | 2022-03-10 | Texas | Oklahoma | 40139 | 5983 | 54 |
2293489 | 2293489 | 2022-03-10 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2293490 | 2293490 | 2022-03-10 | Tulsa | Oklahoma | 40143 | 168883 | 2072 |
2293491 | 2293491 | 2022-03-10 | Unknown | Oklahoma | 161 | 1 | |
2293492 | 2293492 | 2022-03-10 | Wagoner | Oklahoma | 40145 | 21529 | 261 |
2293493 | 2293493 | 2022-03-10 | Washington | Oklahoma | 40147 | 12631 | 242 |
2293494 | 2293494 | 2022-03-10 | Washita | Oklahoma | 40149 | 2622 | 47 |
2293495 | 2293495 | 2022-03-10 | Woods | Oklahoma | 40151 | 2346 | 37 |
2293496 | 2293496 | 2022-03-10 | Woodward | Oklahoma | 40153 | 5151 | 72 |
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);