ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-12-08" 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 |
---|---|---|---|---|---|---|---|
1994256 | 1994256 | 2021-12-08 | Adair | Oklahoma | 40001 | 5056 | 63 |
1994257 | 1994257 | 2021-12-08 | Alfalfa | Oklahoma | 40003 | 1400 | 9 |
1994258 | 1994258 | 2021-12-08 | Atoka | Oklahoma | 40005 | 2825 | 40 |
1994259 | 1994259 | 2021-12-08 | Beaver | Oklahoma | 40007 | 636 | 9 |
1994260 | 1994260 | 2021-12-08 | Beckham | Oklahoma | 40009 | 3966 | 81 |
1994261 | 1994261 | 2021-12-08 | Blaine | Oklahoma | 40011 | 1645 | 32 |
1994262 | 1994262 | 2021-12-08 | Bryan | Oklahoma | 40013 | 9275 | 114 |
1994263 | 1994263 | 2021-12-08 | Caddo | Oklahoma | 40015 | 5435 | 137 |
1994264 | 1994264 | 2021-12-08 | Canadian | Oklahoma | 40017 | 24485 | 305 |
1994265 | 1994265 | 2021-12-08 | Carter | Oklahoma | 40019 | 9416 | 195 |
1994266 | 1994266 | 2021-12-08 | Cherokee | Oklahoma | 40021 | 9265 | 126 |
1994267 | 1994267 | 2021-12-08 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
1994268 | 1994268 | 2021-12-08 | Cimarron | Oklahoma | 40025 | 373 | 0 |
1994269 | 1994269 | 2021-12-08 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
1994270 | 1994270 | 2021-12-08 | Coal | Oklahoma | 40029 | 1089 | 20 |
1994271 | 1994271 | 2021-12-08 | Comanche | Oklahoma | 40031 | 21627 | 329 |
1994272 | 1994272 | 2021-12-08 | Cotton | Oklahoma | 40033 | 1013 | 23 |
1994273 | 1994273 | 2021-12-08 | Craig | Oklahoma | 40035 | 3191 | 36 |
1994274 | 1994274 | 2021-12-08 | Creek | Oklahoma | 40037 | 11799 | 269 |
1994275 | 1994275 | 2021-12-08 | Custer | Oklahoma | 40039 | 5494 | 133 |
1994276 | 1994276 | 2021-12-08 | Delaware | Oklahoma | 40041 | 7737 | 166 |
1994277 | 1994277 | 2021-12-08 | Dewey | Oklahoma | 40043 | 747 | 22 |
1994278 | 1994278 | 2021-12-08 | Ellis | Oklahoma | 40045 | 540 | 6 |
1994279 | 1994279 | 2021-12-08 | Garfield | Oklahoma | 40047 | 10692 | 218 |
1994280 | 1994280 | 2021-12-08 | Garvin | Oklahoma | 40049 | 4973 | 106 |
1994281 | 1994281 | 2021-12-08 | Grady | Oklahoma | 40051 | 8734 | 195 |
1994282 | 1994282 | 2021-12-08 | Grant | Oklahoma | 40053 | 721 | 8 |
1994283 | 1994283 | 2021-12-08 | Greer | Oklahoma | 40055 | 797 | 26 |
1994284 | 1994284 | 2021-12-08 | Harmon | Oklahoma | 40057 | 383 | 9 |
1994285 | 1994285 | 2021-12-08 | Harper | Oklahoma | 40059 | 549 | 10 |
1994286 | 1994286 | 2021-12-08 | Haskell | Oklahoma | 40061 | 1905 | 30 |
1994287 | 1994287 | 2021-12-08 | Hughes | Oklahoma | 40063 | 1801 | 48 |
1994288 | 1994288 | 2021-12-08 | Jackson | Oklahoma | 40065 | 4287 | 89 |
1994289 | 1994289 | 2021-12-08 | Jefferson | Oklahoma | 40067 | 974 | 20 |
1994290 | 1994290 | 2021-12-08 | Johnston | Oklahoma | 40069 | 2021 | 49 |
1994291 | 1994291 | 2021-12-08 | Kay | Oklahoma | 40071 | 8041 | 172 |
1994292 | 1994292 | 2021-12-08 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
1994293 | 1994293 | 2021-12-08 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
1994294 | 1994294 | 2021-12-08 | Latimer | Oklahoma | 40077 | 1605 | 28 |
1994295 | 1994295 | 2021-12-08 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
1994296 | 1994296 | 2021-12-08 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1994297 | 1994297 | 2021-12-08 | Logan | Oklahoma | 40083 | 6441 | 122 |
1994298 | 1994298 | 2021-12-08 | Love | Oklahoma | 40085 | 2045 | 30 |
1994299 | 1994299 | 2021-12-08 | Major | Oklahoma | 40093 | 1448 | 33 |
1994300 | 1994300 | 2021-12-08 | Marshall | Oklahoma | 40095 | 2886 | 31 |
1994301 | 1994301 | 2021-12-08 | Mayes | Oklahoma | 40097 | 7103 | 131 |
1994302 | 1994302 | 2021-12-08 | McClain | Oklahoma | 40087 | 7775 | 107 |
1994303 | 1994303 | 2021-12-08 | McCurtain | Oklahoma | 40089 | 5895 | 138 |
1994304 | 1994304 | 2021-12-08 | McIntosh | Oklahoma | 40091 | 2992 | 101 |
1994305 | 1994305 | 2021-12-08 | Murray | Oklahoma | 40099 | 2731 | 57 |
1994306 | 1994306 | 2021-12-08 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
1994307 | 1994307 | 2021-12-08 | Noble | Oklahoma | 40103 | 1978 | 33 |
1994308 | 1994308 | 2021-12-08 | Nowata | Oklahoma | 40105 | 1889 | 32 |
1994309 | 1994309 | 2021-12-08 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
1994310 | 1994310 | 2021-12-08 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
1994311 | 1994311 | 2021-12-08 | Okmulgee | Oklahoma | 40111 | 6431 | 151 |
1994312 | 1994312 | 2021-12-08 | Osage | Oklahoma | 40113 | 7318 | 136 |
1994313 | 1994313 | 2021-12-08 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
1994314 | 1994314 | 2021-12-08 | Pawnee | Oklahoma | 40117 | 2794 | 69 |
1994315 | 1994315 | 2021-12-08 | Payne | Oklahoma | 40119 | 12414 | 125 |
1994316 | 1994316 | 2021-12-08 | Pittsburg | Oklahoma | 40121 | 7122 | 166 |
1994317 | 1994317 | 2021-12-08 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
1994318 | 1994318 | 2021-12-08 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
1994319 | 1994319 | 2021-12-08 | Pushmataha | Oklahoma | 40127 | 1861 | 40 |
1994320 | 1994320 | 2021-12-08 | Roger Mills | Oklahoma | 40129 | 632 | 12 |
1994321 | 1994321 | 2021-12-08 | Rogers | Oklahoma | 40131 | 16842 | 305 |
1994322 | 1994322 | 2021-12-08 | Seminole | Oklahoma | 40133 | 4066 | 107 |
1994323 | 1994323 | 2021-12-08 | Sequoyah | Oklahoma | 40135 | 6968 | 93 |
1994324 | 1994324 | 2021-12-08 | Stephens | Oklahoma | 40137 | 8033 | 150 |
1994325 | 1994325 | 2021-12-08 | Texas | Oklahoma | 40139 | 4369 | 41 |
1994326 | 1994326 | 2021-12-08 | Tillman | Oklahoma | 40141 | 1056 | 26 |
1994327 | 1994327 | 2021-12-08 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
1994328 | 1994328 | 2021-12-08 | Unknown | Oklahoma | 2212 | 2 | |
1994329 | 1994329 | 2021-12-08 | Wagoner | Oklahoma | 40145 | 13507 | 215 |
1994330 | 1994330 | 2021-12-08 | Washington | Oklahoma | 40147 | 8786 | 209 |
1994331 | 1994331 | 2021-12-08 | Washita | Oklahoma | 40149 | 1694 | 33 |
1994332 | 1994332 | 2021-12-08 | Woods | Oklahoma | 40151 | 1723 | 29 |
1994333 | 1994333 | 2021-12-08 | Woodward | Oklahoma | 40153 | 4100 | 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);