ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-12-24" 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 |
---|---|---|---|---|---|---|---|
2046264 | 2046264 | 2021-12-24 | Adair | Oklahoma | 40001 | 5123 | 63 |
2046265 | 2046265 | 2021-12-24 | Alfalfa | Oklahoma | 40003 | 1418 | 9 |
2046266 | 2046266 | 2021-12-24 | Atoka | Oklahoma | 40005 | 2825 | 40 |
2046267 | 2046267 | 2021-12-24 | Beaver | Oklahoma | 40007 | 661 | 9 |
2046268 | 2046268 | 2021-12-24 | Beckham | Oklahoma | 40009 | 4183 | 83 |
2046269 | 2046269 | 2021-12-24 | Blaine | Oklahoma | 40011 | 1692 | 32 |
2046270 | 2046270 | 2021-12-24 | Bryan | Oklahoma | 40013 | 9345 | 118 |
2046271 | 2046271 | 2021-12-24 | Caddo | Oklahoma | 40015 | 5589 | 137 |
2046272 | 2046272 | 2021-12-24 | Canadian | Oklahoma | 40017 | 25092 | 308 |
2046273 | 2046273 | 2021-12-24 | Carter | Oklahoma | 40019 | 9556 | 199 |
2046274 | 2046274 | 2021-12-24 | Cherokee | Oklahoma | 40021 | 9369 | 126 |
2046275 | 2046275 | 2021-12-24 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2046276 | 2046276 | 2021-12-24 | Cimarron | Oklahoma | 40025 | 411 | 0 |
2046277 | 2046277 | 2021-12-24 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2046278 | 2046278 | 2021-12-24 | Coal | Oklahoma | 40029 | 1103 | 20 |
2046279 | 2046279 | 2021-12-24 | Comanche | Oklahoma | 40031 | 21863 | 330 |
2046280 | 2046280 | 2021-12-24 | Cotton | Oklahoma | 40033 | 1024 | 23 |
2046281 | 2046281 | 2021-12-24 | Craig | Oklahoma | 40035 | 3301 | 36 |
2046282 | 2046282 | 2021-12-24 | Creek | Oklahoma | 40037 | 12050 | 274 |
2046283 | 2046283 | 2021-12-24 | Custer | Oklahoma | 40039 | 5657 | 134 |
2046284 | 2046284 | 2021-12-24 | Delaware | Oklahoma | 40041 | 7849 | 168 |
2046285 | 2046285 | 2021-12-24 | Dewey | Oklahoma | 40043 | 765 | 24 |
2046286 | 2046286 | 2021-12-24 | Ellis | Oklahoma | 40045 | 551 | 6 |
2046287 | 2046287 | 2021-12-24 | Garfield | Oklahoma | 40047 | 10890 | 219 |
2046288 | 2046288 | 2021-12-24 | Garvin | Oklahoma | 40049 | 5062 | 107 |
2046289 | 2046289 | 2021-12-24 | Grady | Oklahoma | 40051 | 8954 | 198 |
2046290 | 2046290 | 2021-12-24 | Grant | Oklahoma | 40053 | 737 | 8 |
2046291 | 2046291 | 2021-12-24 | Greer | Oklahoma | 40055 | 824 | 27 |
2046292 | 2046292 | 2021-12-24 | Harmon | Oklahoma | 40057 | 398 | 9 |
2046293 | 2046293 | 2021-12-24 | Harper | Oklahoma | 40059 | 550 | 10 |
2046294 | 2046294 | 2021-12-24 | Haskell | Oklahoma | 40061 | 1924 | 31 |
2046295 | 2046295 | 2021-12-24 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2046296 | 2046296 | 2021-12-24 | Jackson | Oklahoma | 40065 | 4383 | 89 |
2046297 | 2046297 | 2021-12-24 | Jefferson | Oklahoma | 40067 | 977 | 20 |
2046298 | 2046298 | 2021-12-24 | Johnston | Oklahoma | 40069 | 2037 | 49 |
2046299 | 2046299 | 2021-12-24 | Kay | Oklahoma | 40071 | 8285 | 172 |
2046300 | 2046300 | 2021-12-24 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2046301 | 2046301 | 2021-12-24 | Kiowa | Oklahoma | 40075 | 1238 | 45 |
2046302 | 2046302 | 2021-12-24 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2046303 | 2046303 | 2021-12-24 | Le Flore | Oklahoma | 40079 | 8699 | 94 |
2046304 | 2046304 | 2021-12-24 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2046305 | 2046305 | 2021-12-24 | Logan | Oklahoma | 40083 | 6613 | 123 |
2046306 | 2046306 | 2021-12-24 | Love | Oklahoma | 40085 | 2057 | 30 |
2046307 | 2046307 | 2021-12-24 | Major | Oklahoma | 40093 | 1467 | 34 |
2046308 | 2046308 | 2021-12-24 | Marshall | Oklahoma | 40095 | 2937 | 31 |
2046309 | 2046309 | 2021-12-24 | Mayes | Oklahoma | 40097 | 7235 | 133 |
2046310 | 2046310 | 2021-12-24 | McClain | Oklahoma | 40087 | 7962 | 107 |
2046311 | 2046311 | 2021-12-24 | McCurtain | Oklahoma | 40089 | 5921 | 139 |
2046312 | 2046312 | 2021-12-24 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2046313 | 2046313 | 2021-12-24 | Murray | Oklahoma | 40099 | 2800 | 57 |
2046314 | 2046314 | 2021-12-24 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2046315 | 2046315 | 2021-12-24 | Noble | Oklahoma | 40103 | 2001 | 33 |
2046316 | 2046316 | 2021-12-24 | Nowata | Oklahoma | 40105 | 1934 | 33 |
2046317 | 2046317 | 2021-12-24 | Okfuskee | Oklahoma | 40107 | 2469 | 49 |
2046318 | 2046318 | 2021-12-24 | Oklahoma | Oklahoma | 40109 | 127977 | 1971 |
2046319 | 2046319 | 2021-12-24 | Okmulgee | Oklahoma | 40111 | 6559 | 153 |
2046320 | 2046320 | 2021-12-24 | Osage | Oklahoma | 40113 | 7493 | 139 |
2046321 | 2046321 | 2021-12-24 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2046322 | 2046322 | 2021-12-24 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2046323 | 2046323 | 2021-12-24 | Payne | Oklahoma | 40119 | 12635 | 125 |
2046324 | 2046324 | 2021-12-24 | Pittsburg | Oklahoma | 40121 | 7235 | 169 |
2046325 | 2046325 | 2021-12-24 | Pontotoc | Oklahoma | 40123 | 7342 | 107 |
2046326 | 2046326 | 2021-12-24 | Pottawatomie | Oklahoma | 40125 | 13250 | 215 |
2046327 | 2046327 | 2021-12-24 | Pushmataha | Oklahoma | 40127 | 1874 | 40 |
2046328 | 2046328 | 2021-12-24 | Roger Mills | Oklahoma | 40129 | 677 | 12 |
2046329 | 2046329 | 2021-12-24 | Rogers | Oklahoma | 40131 | 17217 | 309 |
2046330 | 2046330 | 2021-12-24 | Seminole | Oklahoma | 40133 | 4150 | 107 |
2046331 | 2046331 | 2021-12-24 | Sequoyah | Oklahoma | 40135 | 7074 | 94 |
2046332 | 2046332 | 2021-12-24 | Stephens | Oklahoma | 40137 | 8121 | 154 |
2046333 | 2046333 | 2021-12-24 | Texas | Oklahoma | 40139 | 4480 | 41 |
2046334 | 2046334 | 2021-12-24 | Tillman | Oklahoma | 40141 | 1075 | 26 |
2046335 | 2046335 | 2021-12-24 | Tulsa | Oklahoma | 40143 | 115887 | 1806 |
2046336 | 2046336 | 2021-12-24 | Unknown | Oklahoma | 5628 | 2 | |
2046337 | 2046337 | 2021-12-24 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2046338 | 2046338 | 2021-12-24 | Washington | Oklahoma | 40147 | 8956 | 210 |
2046339 | 2046339 | 2021-12-24 | Washita | Oklahoma | 40149 | 1732 | 34 |
2046340 | 2046340 | 2021-12-24 | Woods | Oklahoma | 40151 | 1771 | 30 |
2046341 | 2046341 | 2021-12-24 | Woodward | Oklahoma | 40153 | 4172 | 55 |
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);