ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-18" 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 |
---|---|---|---|---|---|---|---|
1630336 | 1630336 | 2021-08-18 | Adair | Oklahoma | 40001 | 3931 | 47 |
1630337 | 1630337 | 2021-08-18 | Alfalfa | Oklahoma | 40003 | 1195 | 7 |
1630338 | 1630338 | 2021-08-18 | Atoka | Oklahoma | 40005 | 2142 | 28 |
1630339 | 1630339 | 2021-08-18 | Beaver | Oklahoma | 40007 | 482 | 6 |
1630340 | 1630340 | 2021-08-18 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1630341 | 1630341 | 2021-08-18 | Blaine | Oklahoma | 40011 | 1134 | 21 |
1630342 | 1630342 | 2021-08-18 | Bryan | Oklahoma | 40013 | 7087 | 80 |
1630343 | 1630343 | 2021-08-18 | Caddo | Oklahoma | 40015 | 4343 | 97 |
1630344 | 1630344 | 2021-08-18 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1630345 | 1630345 | 2021-08-18 | Carter | Oklahoma | 40019 | 7252 | 133 |
1630346 | 1630346 | 2021-08-18 | Cherokee | Oklahoma | 40021 | 6717 | 80 |
1630347 | 1630347 | 2021-08-18 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1630348 | 1630348 | 2021-08-18 | Cimarron | Oklahoma | 40025 | 263 | 2 |
1630349 | 1630349 | 2021-08-18 | Cleveland | Oklahoma | 40027 | 34799 | 457 |
1630350 | 1630350 | 2021-08-18 | Coal | Oklahoma | 40029 | 804 | 15 |
1630351 | 1630351 | 2021-08-18 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1630352 | 1630352 | 2021-08-18 | Cotton | Oklahoma | 40033 | 754 | 16 |
1630353 | 1630353 | 2021-08-18 | Craig | Oklahoma | 40035 | 2522 | 21 |
1630354 | 1630354 | 2021-08-18 | Creek | Oklahoma | 40037 | 8480 | 171 |
1630355 | 1630355 | 2021-08-18 | Custer | Oklahoma | 40039 | 4329 | 106 |
1630356 | 1630356 | 2021-08-18 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1630357 | 1630357 | 2021-08-18 | Dewey | Oklahoma | 40043 | 590 | 14 |
1630358 | 1630358 | 2021-08-18 | Ellis | Oklahoma | 40045 | 376 | 6 |
1630359 | 1630359 | 2021-08-18 | Garfield | Oklahoma | 40047 | 8288 | 140 |
1630360 | 1630360 | 2021-08-18 | Garvin | Oklahoma | 40049 | 3991 | 81 |
1630361 | 1630361 | 2021-08-18 | Grady | Oklahoma | 40051 | 6562 | 133 |
1630362 | 1630362 | 2021-08-18 | Grant | Oklahoma | 40053 | 594 | 7 |
1630363 | 1630363 | 2021-08-18 | Greer | Oklahoma | 40055 | 608 | 22 |
1630364 | 1630364 | 2021-08-18 | Harmon | Oklahoma | 40057 | 341 | 6 |
1630365 | 1630365 | 2021-08-18 | Harper | Oklahoma | 40059 | 430 | 8 |
1630366 | 1630366 | 2021-08-18 | Haskell | Oklahoma | 40061 | 1489 | 19 |
1630367 | 1630367 | 2021-08-18 | Hughes | Oklahoma | 40063 | 1379 | 30 |
1630368 | 1630368 | 2021-08-18 | Jackson | Oklahoma | 40065 | 3292 | 56 |
1630369 | 1630369 | 2021-08-18 | Jefferson | Oklahoma | 40067 | 763 | 18 |
1630370 | 1630370 | 2021-08-18 | Johnston | Oklahoma | 40069 | 1593 | 38 |
1630371 | 1630371 | 2021-08-18 | Kay | Oklahoma | 40071 | 5795 | 132 |
1630372 | 1630372 | 2021-08-18 | Kingfisher | Oklahoma | 40073 | 2225 | 42 |
1630373 | 1630373 | 2021-08-18 | Kiowa | Oklahoma | 40075 | 892 | 27 |
1630374 | 1630374 | 2021-08-18 | Latimer | Oklahoma | 40077 | 1011 | 13 |
1630375 | 1630375 | 2021-08-18 | Le Flore | Oklahoma | 40079 | 6441 | 71 |
1630376 | 1630376 | 2021-08-18 | Lincoln | Oklahoma | 40081 | 3756 | 76 |
1630377 | 1630377 | 2021-08-18 | Logan | Oklahoma | 40083 | 4756 | 67 |
1630378 | 1630378 | 2021-08-18 | Love | Oklahoma | 40085 | 1677 | 23 |
1630379 | 1630379 | 2021-08-18 | Major | Oklahoma | 40093 | 1019 | 24 |
1630380 | 1630380 | 2021-08-18 | Marshall | Oklahoma | 40095 | 2289 | 24 |
1630381 | 1630381 | 2021-08-18 | Mayes | Oklahoma | 40097 | 5205 | 77 |
1630382 | 1630382 | 2021-08-18 | McClain | Oklahoma | 40087 | 6093 | 75 |
1630383 | 1630383 | 2021-08-18 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1630384 | 1630384 | 2021-08-18 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1630385 | 1630385 | 2021-08-18 | Murray | Oklahoma | 40099 | 2243 | 45 |
1630386 | 1630386 | 2021-08-18 | Muskogee | Oklahoma | 40101 | 10804 | 189 |
1630387 | 1630387 | 2021-08-18 | Noble | Oklahoma | 40103 | 1536 | 22 |
1630388 | 1630388 | 2021-08-18 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1630389 | 1630389 | 2021-08-18 | Okfuskee | Oklahoma | 40107 | 1971 | 32 |
1630390 | 1630390 | 2021-08-18 | Oklahoma | Oklahoma | 40109 | 96822 | 1346 |
1630391 | 1630391 | 2021-08-18 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1630392 | 1630392 | 2021-08-18 | Osage | Oklahoma | 40113 | 5556 | 86 |
1630393 | 1630393 | 2021-08-18 | Ottawa | Oklahoma | 40115 | 5172 | 81 |
1630394 | 1630394 | 2021-08-18 | Pawnee | Oklahoma | 40117 | 2137 | 54 |
1630395 | 1630395 | 2021-08-18 | Payne | Oklahoma | 40119 | 9597 | 77 |
1630396 | 1630396 | 2021-08-18 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1630397 | 1630397 | 2021-08-18 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1630398 | 1630398 | 2021-08-18 | Pottawatomie | Oklahoma | 40125 | 9301 | 134 |
1630399 | 1630399 | 2021-08-18 | Pushmataha | Oklahoma | 40127 | 1314 | 24 |
1630400 | 1630400 | 2021-08-18 | Roger Mills | Oklahoma | 40129 | 419 | 12 |
1630401 | 1630401 | 2021-08-18 | Rogers | Oklahoma | 40131 | 12735 | 203 |
1630402 | 1630402 | 2021-08-18 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1630403 | 1630403 | 2021-08-18 | Sequoyah | Oklahoma | 40135 | 5140 | 58 |
1630404 | 1630404 | 2021-08-18 | Stephens | Oklahoma | 40137 | 5562 | 107 |
1630405 | 1630405 | 2021-08-18 | Texas | Oklahoma | 40139 | 3625 | 35 |
1630406 | 1630406 | 2021-08-18 | Tillman | Oklahoma | 40141 | 861 | 18 |
1630407 | 1630407 | 2021-08-18 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1630408 | 1630408 | 2021-08-18 | Unknown | Oklahoma | 3342 | 0 | |
1630409 | 1630409 | 2021-08-18 | Wagoner | Oklahoma | 40145 | 9733 | 131 |
1630410 | 1630410 | 2021-08-18 | Washington | Oklahoma | 40147 | 6540 | 130 |
1630411 | 1630411 | 2021-08-18 | Washita | Oklahoma | 40149 | 1180 | 23 |
1630412 | 1630412 | 2021-08-18 | Woods | Oklahoma | 40151 | 1348 | 18 |
1630413 | 1630413 | 2021-08-18 | Woodward | Oklahoma | 40153 | 3262 | 38 |
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);