ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-04-22" 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 |
---|---|---|---|---|---|---|---|
2433342 | 2433342 | 2022-04-22 | Adair | Oklahoma | 40001 | 7952 | 73 |
2433343 | 2433343 | 2022-04-22 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2433344 | 2433344 | 2022-04-22 | Atoka | Oklahoma | 40005 | 3887 | 52 |
2433345 | 2433345 | 2022-04-22 | Beaver | Oklahoma | 40007 | 968 | 11 |
2433346 | 2433346 | 2022-04-22 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2433347 | 2433347 | 2022-04-22 | Blaine | Oklahoma | 40011 | 2454 | 41 |
2433348 | 2433348 | 2022-04-22 | Bryan | Oklahoma | 40013 | 13580 | 135 |
2433349 | 2433349 | 2022-04-22 | Caddo | Oklahoma | 40015 | 8264 | 165 |
2433350 | 2433350 | 2022-04-22 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2433351 | 2433351 | 2022-04-22 | Carter | Oklahoma | 40019 | 14329 | 235 |
2433352 | 2433352 | 2022-04-22 | Cherokee | Oklahoma | 40021 | 14513 | 149 |
2433353 | 2433353 | 2022-04-22 | Choctaw | Oklahoma | 40023 | 4061 | 64 |
2433354 | 2433354 | 2022-04-22 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2433355 | 2433355 | 2022-04-22 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2433356 | 2433356 | 2022-04-22 | Coal | Oklahoma | 40029 | 1670 | 24 |
2433357 | 2433357 | 2022-04-22 | Comanche | Oklahoma | 40031 | 33113 | 392 |
2433358 | 2433358 | 2022-04-22 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2433359 | 2433359 | 2022-04-22 | Craig | Oklahoma | 40035 | 4770 | 55 |
2433360 | 2433360 | 2022-04-22 | Creek | Oklahoma | 40037 | 18181 | 334 |
2433361 | 2433361 | 2022-04-22 | Custer | Oklahoma | 40039 | 7907 | 167 |
2433362 | 2433362 | 2022-04-22 | Delaware | Oklahoma | 40041 | 11080 | 201 |
2433363 | 2433363 | 2022-04-22 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2433364 | 2433364 | 2022-04-22 | Ellis | Oklahoma | 40045 | 770 | 8 |
2433365 | 2433365 | 2022-04-22 | Garfield | Oklahoma | 40047 | 15182 | 290 |
2433366 | 2433366 | 2022-04-22 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2433367 | 2433367 | 2022-04-22 | Grady | Oklahoma | 40051 | 13723 | 243 |
2433368 | 2433368 | 2022-04-22 | Grant | Oklahoma | 40053 | 1032 | 16 |
2433369 | 2433369 | 2022-04-22 | Greer | Oklahoma | 40055 | 1295 | 37 |
2433370 | 2433370 | 2022-04-22 | Harmon | Oklahoma | 40057 | 521 | 12 |
2433371 | 2433371 | 2022-04-22 | Harper | Oklahoma | 40059 | 714 | 12 |
2433372 | 2433372 | 2022-04-22 | Haskell | Oklahoma | 40061 | 2775 | 41 |
2433373 | 2433373 | 2022-04-22 | Hughes | Oklahoma | 40063 | 2582 | 62 |
2433374 | 2433374 | 2022-04-22 | Jackson | Oklahoma | 40065 | 6558 | 106 |
2433375 | 2433375 | 2022-04-22 | Jefferson | Oklahoma | 40067 | 1314 | 28 |
2433376 | 2433376 | 2022-04-22 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2433377 | 2433377 | 2022-04-22 | Kay | Oklahoma | 40071 | 12283 | 217 |
2433378 | 2433378 | 2022-04-22 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2433379 | 2433379 | 2022-04-22 | Kiowa | Oklahoma | 40075 | 1958 | 52 |
2433380 | 2433380 | 2022-04-22 | Latimer | Oklahoma | 40077 | 2270 | 36 |
2433381 | 2433381 | 2022-04-22 | Le Flore | Oklahoma | 40079 | 12482 | 108 |
2433382 | 2433382 | 2022-04-22 | Lincoln | Oklahoma | 40081 | 7872 | 138 |
2433383 | 2433383 | 2022-04-22 | Logan | Oklahoma | 40083 | 10858 | 160 |
2433384 | 2433384 | 2022-04-22 | Love | Oklahoma | 40085 | 3097 | 39 |
2433385 | 2433385 | 2022-04-22 | Major | Oklahoma | 40093 | 2461 | 41 |
2433386 | 2433386 | 2022-04-22 | Marshall | Oklahoma | 40095 | 4605 | 43 |
2433387 | 2433387 | 2022-04-22 | Mayes | Oklahoma | 40097 | 10310 | 163 |
2433388 | 2433388 | 2022-04-22 | McClain | Oklahoma | 40087 | 11650 | 133 |
2433389 | 2433389 | 2022-04-22 | McCurtain | Oklahoma | 40089 | 8087 | 163 |
2433390 | 2433390 | 2022-04-22 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2433391 | 2433391 | 2022-04-22 | Murray | Oklahoma | 40099 | 4165 | 73 |
2433392 | 2433392 | 2022-04-22 | Muskogee | Oklahoma | 40101 | 19950 | 343 |
2433393 | 2433393 | 2022-04-22 | Noble | Oklahoma | 40103 | 3034 | 39 |
2433394 | 2433394 | 2022-04-22 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2433395 | 2433395 | 2022-04-22 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2433396 | 2433396 | 2022-04-22 | Oklahoma | Oklahoma | 40109 | 199022 | 2445 |
2433397 | 2433397 | 2022-04-22 | Okmulgee | Oklahoma | 40111 | 9668 | 186 |
2433398 | 2433398 | 2022-04-22 | Osage | Oklahoma | 40113 | 10918 | 167 |
2433399 | 2433399 | 2022-04-22 | Ottawa | Oklahoma | 40115 | 9189 | 126 |
2433400 | 2433400 | 2022-04-22 | Pawnee | Oklahoma | 40117 | 4106 | 85 |
2433401 | 2433401 | 2022-04-22 | Payne | Oklahoma | 40119 | 18343 | 163 |
2433402 | 2433402 | 2022-04-22 | Pittsburg | Oklahoma | 40121 | 10770 | 210 |
2433403 | 2433403 | 2022-04-22 | Pontotoc | Oklahoma | 40123 | 12076 | 145 |
2433404 | 2433404 | 2022-04-22 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2433405 | 2433405 | 2022-04-22 | Pushmataha | Oklahoma | 40127 | 2670 | 45 |
2433406 | 2433406 | 2022-04-22 | Roger Mills | Oklahoma | 40129 | 883 | 16 |
2433407 | 2433407 | 2022-04-22 | Rogers | Oklahoma | 40131 | 25406 | 383 |
2433408 | 2433408 | 2022-04-22 | Seminole | Oklahoma | 40133 | 6131 | 134 |
2433409 | 2433409 | 2022-04-22 | Sequoyah | Oklahoma | 40135 | 10621 | 104 |
2433410 | 2433410 | 2022-04-22 | Stephens | Oklahoma | 40137 | 11119 | 203 |
2433411 | 2433411 | 2022-04-22 | Texas | Oklahoma | 40139 | 5991 | 54 |
2433412 | 2433412 | 2022-04-22 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2433413 | 2433413 | 2022-04-22 | Tulsa | Oklahoma | 40143 | 171073 | 2162 |
2433414 | 2433414 | 2022-04-22 | Unknown | Oklahoma | 742 | 0 | |
2433415 | 2433415 | 2022-04-22 | Wagoner | Oklahoma | 40145 | 21745 | 275 |
2433416 | 2433416 | 2022-04-22 | Washington | Oklahoma | 40147 | 12677 | 260 |
2433417 | 2433417 | 2022-04-22 | Washita | Oklahoma | 40149 | 2630 | 52 |
2433418 | 2433418 | 2022-04-22 | Woods | Oklahoma | 40151 | 2352 | 38 |
2433419 | 2433419 | 2022-04-22 | Woodward | Oklahoma | 40153 | 5169 | 76 |
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);