ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
825224 | 825224 | 2020-12-13 | Adair | Oklahoma | 40001 | 1482 | 13 |
825225 | 825225 | 2020-12-13 | Alfalfa | Oklahoma | 40003 | 610 | 2 |
825226 | 825226 | 2020-12-13 | Atoka | Oklahoma | 40005 | 1030 | 2 |
825227 | 825227 | 2020-12-13 | Beaver | Oklahoma | 40007 | 272 | 2 |
825228 | 825228 | 2020-12-13 | Beckham | Oklahoma | 40009 | 1640 | 18 |
825229 | 825229 | 2020-12-13 | Blaine | Oklahoma | 40011 | 536 | 2 |
825230 | 825230 | 2020-12-13 | Bryan | Oklahoma | 40013 | 3255 | 25 |
825231 | 825231 | 2020-12-13 | Caddo | Oklahoma | 40015 | 2392 | 37 |
825232 | 825232 | 2020-12-13 | Canadian | Oklahoma | 40017 | 8643 | 41 |
825233 | 825233 | 2020-12-13 | Carter | Oklahoma | 40019 | 2100 | 16 |
825234 | 825234 | 2020-12-13 | Cherokee | Oklahoma | 40021 | 2895 | 13 |
825235 | 825235 | 2020-12-13 | Choctaw | Oklahoma | 40023 | 822 | 6 |
825236 | 825236 | 2020-12-13 | Cimarron | Oklahoma | 40025 | 91 | 0 |
825237 | 825237 | 2020-12-13 | Cleveland | Oklahoma | 40027 | 15540 | 138 |
825238 | 825238 | 2020-12-13 | Coal | Oklahoma | 40029 | 363 | 3 |
825239 | 825239 | 2020-12-13 | Comanche | Oklahoma | 40031 | 5785 | 46 |
825240 | 825240 | 2020-12-13 | Cotton | Oklahoma | 40033 | 345 | 7 |
825241 | 825241 | 2020-12-13 | Craig | Oklahoma | 40035 | 1176 | 4 |
825242 | 825242 | 2020-12-13 | Creek | Oklahoma | 40037 | 3257 | 55 |
825243 | 825243 | 2020-12-13 | Custer | Oklahoma | 40039 | 2503 | 19 |
825244 | 825244 | 2020-12-13 | Delaware | Oklahoma | 40041 | 2338 | 39 |
825245 | 825245 | 2020-12-13 | Dewey | Oklahoma | 40043 | 346 | 2 |
825246 | 825246 | 2020-12-13 | Ellis | Oklahoma | 40045 | 268 | 0 |
825247 | 825247 | 2020-12-13 | Garfield | Oklahoma | 40047 | 4627 | 40 |
825248 | 825248 | 2020-12-13 | Garvin | Oklahoma | 40049 | 1833 | 18 |
825249 | 825249 | 2020-12-13 | Grady | Oklahoma | 40051 | 3287 | 32 |
825250 | 825250 | 2020-12-13 | Grant | Oklahoma | 40053 | 280 | 5 |
825251 | 825251 | 2020-12-13 | Greer | Oklahoma | 40055 | 328 | 8 |
825252 | 825252 | 2020-12-13 | Harmon | Oklahoma | 40057 | 185 | 0 |
825253 | 825253 | 2020-12-13 | Harper | Oklahoma | 40059 | 317 | 2 |
825254 | 825254 | 2020-12-13 | Haskell | Oklahoma | 40061 | 715 | 7 |
825255 | 825255 | 2020-12-13 | Hughes | Oklahoma | 40063 | 684 | 8 |
825256 | 825256 | 2020-12-13 | Jackson | Oklahoma | 40065 | 2157 | 35 |
825257 | 825257 | 2020-12-13 | Jefferson | Oklahoma | 40067 | 318 | 2 |
825258 | 825258 | 2020-12-13 | Johnston | Oklahoma | 40069 | 646 | 5 |
825259 | 825259 | 2020-12-13 | Kay | Oklahoma | 40071 | 2413 | 27 |
825260 | 825260 | 2020-12-13 | Kingfisher | Oklahoma | 40073 | 1111 | 7 |
825261 | 825261 | 2020-12-13 | Kiowa | Oklahoma | 40075 | 478 | 8 |
825262 | 825262 | 2020-12-13 | Latimer | Oklahoma | 40077 | 376 | 4 |
825263 | 825263 | 2020-12-13 | Le Flore | Oklahoma | 40079 | 2919 | 28 |
825264 | 825264 | 2020-12-13 | Lincoln | Oklahoma | 40081 | 1723 | 28 |
825265 | 825265 | 2020-12-13 | Logan | Oklahoma | 40083 | 2010 | 5 |
825266 | 825266 | 2020-12-13 | Love | Oklahoma | 40085 | 727 | 1 |
825267 | 825267 | 2020-12-13 | Major | Oklahoma | 40093 | 620 | 4 |
825268 | 825268 | 2020-12-13 | Marshall | Oklahoma | 40095 | 945 | 4 |
825269 | 825269 | 2020-12-13 | Mayes | Oklahoma | 40097 | 1951 | 21 |
825270 | 825270 | 2020-12-13 | McClain | Oklahoma | 40087 | 2977 | 20 |
825271 | 825271 | 2020-12-13 | McCurtain | Oklahoma | 40089 | 2499 | 48 |
825272 | 825272 | 2020-12-13 | McIntosh | Oklahoma | 40091 | 1038 | 14 |
825273 | 825273 | 2020-12-13 | Murray | Oklahoma | 40099 | 862 | 6 |
825274 | 825274 | 2020-12-13 | Muskogee | Oklahoma | 40101 | 5306 | 42 |
825275 | 825275 | 2020-12-13 | Noble | Oklahoma | 40103 | 759 | 5 |
825276 | 825276 | 2020-12-13 | Nowata | Oklahoma | 40105 | 511 | 6 |
825277 | 825277 | 2020-12-13 | Okfuskee | Oklahoma | 40107 | 1181 | 15 |
825278 | 825278 | 2020-12-13 | Oklahoma | Oklahoma | 40109 | 49009 | 373 |
825279 | 825279 | 2020-12-13 | Okmulgee | Oklahoma | 40111 | 2099 | 25 |
825280 | 825280 | 2020-12-13 | Osage | Oklahoma | 40113 | 2403 | 21 |
825281 | 825281 | 2020-12-13 | Ottawa | Oklahoma | 40115 | 2109 | 25 |
825282 | 825282 | 2020-12-13 | Pawnee | Oklahoma | 40117 | 770 | 9 |
825283 | 825283 | 2020-12-13 | Payne | Oklahoma | 40119 | 4992 | 24 |
825284 | 825284 | 2020-12-13 | Pittsburg | Oklahoma | 40121 | 2291 | 23 |
825285 | 825285 | 2020-12-13 | Pontotoc | Oklahoma | 40123 | 2421 | 16 |
825286 | 825286 | 2020-12-13 | Pottawatomie | Oklahoma | 40125 | 4441 | 25 |
825287 | 825287 | 2020-12-13 | Pushmataha | Oklahoma | 40127 | 467 | 6 |
825288 | 825288 | 2020-12-13 | Roger Mills | Oklahoma | 40129 | 225 | 6 |
825289 | 825289 | 2020-12-13 | Rogers | Oklahoma | 40131 | 5034 | 76 |
825290 | 825290 | 2020-12-13 | Seminole | Oklahoma | 40133 | 1456 | 15 |
825291 | 825291 | 2020-12-13 | Sequoyah | Oklahoma | 40135 | 2049 | 16 |
825292 | 825292 | 2020-12-13 | Stephens | Oklahoma | 40137 | 2227 | 20 |
825293 | 825293 | 2020-12-13 | Texas | Oklahoma | 40139 | 2726 | 13 |
825294 | 825294 | 2020-12-13 | Tillman | Oklahoma | 40141 | 456 | 8 |
825295 | 825295 | 2020-12-13 | Tulsa | Oklahoma | 40143 | 39625 | 312 |
825296 | 825296 | 2020-12-13 | Unknown | Oklahoma | 114 | 0 | |
825297 | 825297 | 2020-12-13 | Wagoner | Oklahoma | 40145 | 3364 | 41 |
825298 | 825298 | 2020-12-13 | Washington | Oklahoma | 40147 | 2471 | 51 |
825299 | 825299 | 2020-12-13 | Washita | Oklahoma | 40149 | 581 | 3 |
825300 | 825300 | 2020-12-13 | Woods | Oklahoma | 40151 | 700 | 3 |
825301 | 825301 | 2020-12-13 | Woodward | Oklahoma | 40153 | 2166 | 8 |
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);