ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-02-06" 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 |
---|---|---|---|---|---|---|---|
2189357 | 2189357 | 2022-02-06 | Adair | Oklahoma | 40001 | 7348 | 66 |
2189358 | 2189358 | 2022-02-06 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2189359 | 2189359 | 2022-02-06 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2189360 | 2189360 | 2022-02-06 | Beaver | Oklahoma | 40007 | 894 | 10 |
2189361 | 2189361 | 2022-02-06 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2189362 | 2189362 | 2022-02-06 | Blaine | Oklahoma | 40011 | 2329 | 34 |
2189363 | 2189363 | 2022-02-06 | Bryan | Oklahoma | 40013 | 12916 | 121 |
2189364 | 2189364 | 2022-02-06 | Caddo | Oklahoma | 40015 | 7875 | 145 |
2189365 | 2189365 | 2022-02-06 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2189366 | 2189366 | 2022-02-06 | Carter | Oklahoma | 40019 | 13021 | 208 |
2189367 | 2189367 | 2022-02-06 | Cherokee | Oklahoma | 40021 | 13799 | 132 |
2189368 | 2189368 | 2022-02-06 | Choctaw | Oklahoma | 40023 | 3858 | 54 |
2189369 | 2189369 | 2022-02-06 | Cimarron | Oklahoma | 40025 | 520 | 0 |
2189370 | 2189370 | 2022-02-06 | Cleveland | Oklahoma | 40027 | 75571 | 687 |
2189371 | 2189371 | 2022-02-06 | Coal | Oklahoma | 40029 | 1510 | 20 |
2189372 | 2189372 | 2022-02-06 | Comanche | Oklahoma | 40031 | 30399 | 343 |
2189373 | 2189373 | 2022-02-06 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2189374 | 2189374 | 2022-02-06 | Craig | Oklahoma | 40035 | 4435 | 42 |
2189375 | 2189375 | 2022-02-06 | Creek | Oklahoma | 40037 | 17298 | 291 |
2189376 | 2189376 | 2022-02-06 | Custer | Oklahoma | 40039 | 7465 | 143 |
2189377 | 2189377 | 2022-02-06 | Delaware | Oklahoma | 40041 | 10471 | 175 |
2189378 | 2189378 | 2022-02-06 | Dewey | Oklahoma | 40043 | 1019 | 25 |
2189379 | 2189379 | 2022-02-06 | Ellis | Oklahoma | 40045 | 697 | 7 |
2189380 | 2189380 | 2022-02-06 | Garfield | Oklahoma | 40047 | 14095 | 233 |
2189381 | 2189381 | 2022-02-06 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2189382 | 2189382 | 2022-02-06 | Grady | Oklahoma | 40051 | 13148 | 218 |
2189383 | 2189383 | 2022-02-06 | Grant | Oklahoma | 40053 | 986 | 12 |
2189384 | 2189384 | 2022-02-06 | Greer | Oklahoma | 40055 | 1215 | 29 |
2189385 | 2189385 | 2022-02-06 | Harmon | Oklahoma | 40057 | 493 | 11 |
2189386 | 2189386 | 2022-02-06 | Harper | Oklahoma | 40059 | 687 | 11 |
2189387 | 2189387 | 2022-02-06 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2189388 | 2189388 | 2022-02-06 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2189389 | 2189389 | 2022-02-06 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2189390 | 2189390 | 2022-02-06 | Jefferson | Oklahoma | 40067 | 1228 | 21 |
2189391 | 2189391 | 2022-02-06 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2189392 | 2189392 | 2022-02-06 | Kay | Oklahoma | 40071 | 11459 | 186 |
2189393 | 2189393 | 2022-02-06 | Kingfisher | Oklahoma | 40073 | 3756 | 56 |
2189394 | 2189394 | 2022-02-06 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2189395 | 2189395 | 2022-02-06 | Latimer | Oklahoma | 40077 | 2169 | 31 |
2189396 | 2189396 | 2022-02-06 | Le Flore | Oklahoma | 40079 | 11543 | 98 |
2189397 | 2189397 | 2022-02-06 | Lincoln | Oklahoma | 40081 | 7382 | 119 |
2189398 | 2189398 | 2022-02-06 | Logan | Oklahoma | 40083 | 10177 | 140 |
2189399 | 2189399 | 2022-02-06 | Love | Oklahoma | 40085 | 2887 | 31 |
2189400 | 2189400 | 2022-02-06 | Major | Oklahoma | 40093 | 2377 | 35 |
2189401 | 2189401 | 2022-02-06 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2189402 | 2189402 | 2022-02-06 | Mayes | Oklahoma | 40097 | 9704 | 140 |
2189403 | 2189403 | 2022-02-06 | McClain | Oklahoma | 40087 | 11079 | 115 |
2189404 | 2189404 | 2022-02-06 | McCurtain | Oklahoma | 40089 | 7710 | 145 |
2189405 | 2189405 | 2022-02-06 | McIntosh | Oklahoma | 40091 | 4678 | 111 |
2189406 | 2189406 | 2022-02-06 | Murray | Oklahoma | 40099 | 4004 | 62 |
2189407 | 2189407 | 2022-02-06 | Muskogee | Oklahoma | 40101 | 19064 | 293 |
2189408 | 2189408 | 2022-02-06 | Noble | Oklahoma | 40103 | 2826 | 33 |
2189409 | 2189409 | 2022-02-06 | Nowata | Oklahoma | 40105 | 2655 | 34 |
2189410 | 2189410 | 2022-02-06 | Okfuskee | Oklahoma | 40107 | 3398 | 52 |
2189411 | 2189411 | 2022-02-06 | Oklahoma | Oklahoma | 40109 | 185532 | 2065 |
2189412 | 2189412 | 2022-02-06 | Okmulgee | Oklahoma | 40111 | 9060 | 159 |
2189413 | 2189413 | 2022-02-06 | Osage | Oklahoma | 40113 | 10200 | 146 |
2189414 | 2189414 | 2022-02-06 | Ottawa | Oklahoma | 40115 | 8588 | 111 |
2189415 | 2189415 | 2022-02-06 | Pawnee | Oklahoma | 40117 | 3905 | 73 |
2189416 | 2189416 | 2022-02-06 | Payne | Oklahoma | 40119 | 17240 | 137 |
2189417 | 2189417 | 2022-02-06 | Pittsburg | Oklahoma | 40121 | 10253 | 183 |
2189418 | 2189418 | 2022-02-06 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2189419 | 2189419 | 2022-02-06 | Pottawatomie | Oklahoma | 40125 | 19542 | 236 |
2189420 | 2189420 | 2022-02-06 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2189421 | 2189421 | 2022-02-06 | Roger Mills | Oklahoma | 40129 | 849 | 13 |
2189422 | 2189422 | 2022-02-06 | Rogers | Oklahoma | 40131 | 24139 | 336 |
2189423 | 2189423 | 2022-02-06 | Seminole | Oklahoma | 40133 | 5793 | 109 |
2189424 | 2189424 | 2022-02-06 | Sequoyah | Oklahoma | 40135 | 9886 | 94 |
2189425 | 2189425 | 2022-02-06 | Stephens | Oklahoma | 40137 | 10123 | 166 |
2189426 | 2189426 | 2022-02-06 | Texas | Oklahoma | 40139 | 5720 | 46 |
2189427 | 2189427 | 2022-02-06 | Tillman | Oklahoma | 40141 | 1451 | 30 |
2189428 | 2189428 | 2022-02-06 | Tulsa | Oklahoma | 40143 | 161879 | 1899 |
2189429 | 2189429 | 2022-02-06 | Unknown | Oklahoma | 18770 | 4 | |
2189430 | 2189430 | 2022-02-06 | Wagoner | Oklahoma | 40145 | 20650 | 239 |
2189431 | 2189431 | 2022-02-06 | Washington | Oklahoma | 40147 | 11939 | 224 |
2189432 | 2189432 | 2022-02-06 | Washita | Oklahoma | 40149 | 2507 | 38 |
2189433 | 2189433 | 2022-02-06 | Woods | Oklahoma | 40151 | 2212 | 30 |
2189434 | 2189434 | 2022-02-06 | Woodward | Oklahoma | 40153 | 4966 | 61 |
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);