ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where date = "2020-05-07" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
123255 | 123255 | 2020-05-07 | Adair | Oklahoma | 40001 | 69 | 3 |
123256 | 123256 | 2020-05-07 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
123257 | 123257 | 2020-05-07 | Atoka | Oklahoma | 40005 | 1 | 0 |
123258 | 123258 | 2020-05-07 | Beaver | Oklahoma | 40007 | 17 | 0 |
123259 | 123259 | 2020-05-07 | Beckham | Oklahoma | 40009 | 6 | 0 |
123260 | 123260 | 2020-05-07 | Blaine | Oklahoma | 40011 | 2 | 0 |
123261 | 123261 | 2020-05-07 | Bryan | Oklahoma | 40013 | 12 | 1 |
123262 | 123262 | 2020-05-07 | Caddo | Oklahoma | 40015 | 89 | 8 |
123263 | 123263 | 2020-05-07 | Canadian | Oklahoma | 40017 | 107 | 3 |
123264 | 123264 | 2020-05-07 | Carter | Oklahoma | 40019 | 6 | 1 |
123265 | 123265 | 2020-05-07 | Cherokee | Oklahoma | 40021 | 29 | 1 |
123266 | 123266 | 2020-05-07 | Choctaw | Oklahoma | 40023 | 3 | 0 |
123267 | 123267 | 2020-05-07 | Cimarron | Oklahoma | 40025 | 1 | 0 |
123268 | 123268 | 2020-05-07 | Cleveland | Oklahoma | 40027 | 448 | 32 |
123269 | 123269 | 2020-05-07 | Comanche | Oklahoma | 40031 | 115 | 2 |
123270 | 123270 | 2020-05-07 | Cotton | Oklahoma | 40033 | 5 | 1 |
123271 | 123271 | 2020-05-07 | Craig | Oklahoma | 40035 | 13 | 0 |
123272 | 123272 | 2020-05-07 | Creek | Oklahoma | 40037 | 82 | 7 |
123273 | 123273 | 2020-05-07 | Custer | Oklahoma | 40039 | 11 | 0 |
123274 | 123274 | 2020-05-07 | Delaware | Oklahoma | 40041 | 92 | 15 |
123275 | 123275 | 2020-05-07 | Dewey | Oklahoma | 40043 | 2 | 0 |
123276 | 123276 | 2020-05-07 | Garfield | Oklahoma | 40047 | 21 | 1 |
123277 | 123277 | 2020-05-07 | Garvin | Oklahoma | 40049 | 14 | 1 |
123278 | 123278 | 2020-05-07 | Grady | Oklahoma | 40051 | 41 | 2 |
123279 | 123279 | 2020-05-07 | Grant | Oklahoma | 40053 | 2 | 0 |
123280 | 123280 | 2020-05-07 | Greer | Oklahoma | 40055 | 65 | 6 |
123281 | 123281 | 2020-05-07 | Harper | Oklahoma | 40059 | 1 | 0 |
123282 | 123282 | 2020-05-07 | Haskell | Oklahoma | 40061 | 5 | 0 |
123283 | 123283 | 2020-05-07 | Jackson | Oklahoma | 40065 | 19 | 0 |
123284 | 123284 | 2020-05-07 | Jefferson | Oklahoma | 40067 | 2 | 0 |
123285 | 123285 | 2020-05-07 | Johnston | Oklahoma | 40069 | 3 | 0 |
123286 | 123286 | 2020-05-07 | Kay | Oklahoma | 40071 | 48 | 7 |
123287 | 123287 | 2020-05-07 | Kingfisher | Oklahoma | 40073 | 8 | 0 |
123288 | 123288 | 2020-05-07 | Kiowa | Oklahoma | 40075 | 5 | 0 |
123289 | 123289 | 2020-05-07 | Latimer | Oklahoma | 40077 | 5 | 1 |
123290 | 123290 | 2020-05-07 | Le Flore | Oklahoma | 40079 | 13 | 0 |
123291 | 123291 | 2020-05-07 | Lincoln | Oklahoma | 40081 | 16 | 2 |
123292 | 123292 | 2020-05-07 | Logan | Oklahoma | 40083 | 18 | 1 |
123293 | 123293 | 2020-05-07 | Love | Oklahoma | 40085 | 3 | 0 |
123294 | 123294 | 2020-05-07 | Major | Oklahoma | 40093 | 4 | 1 |
123295 | 123295 | 2020-05-07 | Marshall | Oklahoma | 40095 | 2 | 0 |
123296 | 123296 | 2020-05-07 | Mayes | Oklahoma | 40097 | 24 | 4 |
123297 | 123297 | 2020-05-07 | McClain | Oklahoma | 40087 | 84 | 2 |
123298 | 123298 | 2020-05-07 | McCurtain | Oklahoma | 40089 | 8 | 0 |
123299 | 123299 | 2020-05-07 | McIntosh | Oklahoma | 40091 | 4 | 0 |
123300 | 123300 | 2020-05-07 | Murray | Oklahoma | 40099 | 2 | 0 |
123301 | 123301 | 2020-05-07 | Muskogee | Oklahoma | 40101 | 28 | 6 |
123302 | 123302 | 2020-05-07 | Noble | Oklahoma | 40103 | 7 | 0 |
123303 | 123303 | 2020-05-07 | Nowata | Oklahoma | 40105 | 21 | 0 |
123304 | 123304 | 2020-05-07 | Okfuskee | Oklahoma | 40107 | 1 | 0 |
123305 | 123305 | 2020-05-07 | Oklahoma | Oklahoma | 40109 | 895 | 40 |
123306 | 123306 | 2020-05-07 | Okmulgee | Oklahoma | 40111 | 17 | 0 |
123307 | 123307 | 2020-05-07 | Osage | Oklahoma | 40113 | 82 | 8 |
123308 | 123308 | 2020-05-07 | Ottawa | Oklahoma | 40115 | 34 | 1 |
123309 | 123309 | 2020-05-07 | Pawnee | Oklahoma | 40117 | 29 | 2 |
123310 | 123310 | 2020-05-07 | Payne | Oklahoma | 40119 | 44 | 1 |
123311 | 123311 | 2020-05-07 | Pittsburg | Oklahoma | 40121 | 39 | 2 |
123312 | 123312 | 2020-05-07 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
123313 | 123313 | 2020-05-07 | Pottawatomie | Oklahoma | 40125 | 53 | 4 |
123314 | 123314 | 2020-05-07 | Pushmataha | Oklahoma | 40127 | 1 | 0 |
123315 | 123315 | 2020-05-07 | Rogers | Oklahoma | 40131 | 69 | 4 |
123316 | 123316 | 2020-05-07 | Seminole | Oklahoma | 40133 | 19 | 2 |
123317 | 123317 | 2020-05-07 | Sequoyah | Oklahoma | 40135 | 13 | 3 |
123318 | 123318 | 2020-05-07 | Stephens | Oklahoma | 40137 | 22 | 1 |
123319 | 123319 | 2020-05-07 | Texas | Oklahoma | 40139 | 308 | 3 |
123320 | 123320 | 2020-05-07 | Tillman | Oklahoma | 40141 | 16 | 0 |
123321 | 123321 | 2020-05-07 | Tulsa | Oklahoma | 40143 | 676 | 36 |
123322 | 123322 | 2020-05-07 | Wagoner | Oklahoma | 40145 | 125 | 17 |
123323 | 123323 | 2020-05-07 | Washington | Oklahoma | 40147 | 289 | 26 |
123324 | 123324 | 2020-05-07 | Woods | Oklahoma | 40151 | 3 | 0 |
123325 | 123325 | 2020-05-07 | Woodward | Oklahoma | 40153 | 1 | 0 |
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);