ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2020-08-23 and state = "Oklahoma" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
462189 | 462189 | 2020-08-23 | Adair | Oklahoma | 40001 | 412 | 6 |
462190 | 462190 | 2020-08-23 | Alfalfa | Oklahoma | 40003 | 10 | 0 |
462191 | 462191 | 2020-08-23 | Atoka | Oklahoma | 40005 | 95 | 1 |
462192 | 462192 | 2020-08-23 | Beaver | Oklahoma | 40007 | 41 | 0 |
462193 | 462193 | 2020-08-23 | Beckham | Oklahoma | 40009 | 113 | 1 |
462194 | 462194 | 2020-08-23 | Blaine | Oklahoma | 40011 | 57 | 0 |
462195 | 462195 | 2020-08-23 | Bryan | Oklahoma | 40013 | 545 | 3 |
462196 | 462196 | 2020-08-23 | Caddo | Oklahoma | 40015 | 506 | 20 |
462197 | 462197 | 2020-08-23 | Canadian | Oklahoma | 40017 | 1413 | 9 |
462198 | 462198 | 2020-08-23 | Carter | Oklahoma | 40019 | 393 | 6 |
462199 | 462199 | 2020-08-23 | Cherokee | Oklahoma | 40021 | 578 | 3 |
462200 | 462200 | 2020-08-23 | Choctaw | Oklahoma | 40023 | 221 | 1 |
462201 | 462201 | 2020-08-23 | Cimarron | Oklahoma | 40025 | 14 | 0 |
462202 | 462202 | 2020-08-23 | Cleveland | Oklahoma | 40027 | 3522 | 63 |
462203 | 462203 | 2020-08-23 | Coal | Oklahoma | 40029 | 48 | 0 |
462204 | 462204 | 2020-08-23 | Comanche | Oklahoma | 40031 | 1149 | 11 |
462205 | 462205 | 2020-08-23 | Cotton | Oklahoma | 40033 | 25 | 2 |
462206 | 462206 | 2020-08-23 | Craig | Oklahoma | 40035 | 106 | 1 |
462207 | 462207 | 2020-08-23 | Creek | Oklahoma | 40037 | 745 | 19 |
462208 | 462208 | 2020-08-23 | Custer | Oklahoma | 40039 | 279 | 0 |
462209 | 462209 | 2020-08-23 | Delaware | Oklahoma | 40041 | 507 | 20 |
462210 | 462210 | 2020-08-23 | Dewey | Oklahoma | 40043 | 18 | 0 |
462211 | 462211 | 2020-08-23 | Ellis | Oklahoma | 40045 | 6 | 0 |
462212 | 462212 | 2020-08-23 | Garfield | Oklahoma | 40047 | 750 | 9 |
462213 | 462213 | 2020-08-23 | Garvin | Oklahoma | 40049 | 252 | 4 |
462214 | 462214 | 2020-08-23 | Grady | Oklahoma | 40051 | 494 | 7 |
462215 | 462215 | 2020-08-23 | Grant | Oklahoma | 40053 | 21 | 0 |
462216 | 462216 | 2020-08-23 | Greer | Oklahoma | 40055 | 86 | 8 |
462217 | 462217 | 2020-08-23 | Harmon | Oklahoma | 40057 | 37 | 0 |
462218 | 462218 | 2020-08-23 | Harper | Oklahoma | 40059 | 16 | 0 |
462219 | 462219 | 2020-08-23 | Haskell | Oklahoma | 40061 | 145 | 2 |
462220 | 462220 | 2020-08-23 | Hughes | Oklahoma | 40063 | 194 | 3 |
462221 | 462221 | 2020-08-23 | Jackson | Oklahoma | 40065 | 565 | 7 |
462222 | 462222 | 2020-08-23 | Jefferson | Oklahoma | 40067 | 34 | 0 |
462223 | 462223 | 2020-08-23 | Johnston | Oklahoma | 40069 | 66 | 0 |
462224 | 462224 | 2020-08-23 | Kay | Oklahoma | 40071 | 287 | 11 |
462225 | 462225 | 2020-08-23 | Kingfisher | Oklahoma | 40073 | 235 | 0 |
462226 | 462226 | 2020-08-23 | Kiowa | Oklahoma | 40075 | 39 | 1 |
462227 | 462227 | 2020-08-23 | Latimer | Oklahoma | 40077 | 104 | 2 |
462228 | 462228 | 2020-08-23 | Le Flore | Oklahoma | 40079 | 539 | 3 |
462229 | 462229 | 2020-08-23 | Lincoln | Oklahoma | 40081 | 271 | 5 |
462230 | 462230 | 2020-08-23 | Logan | Oklahoma | 40083 | 267 | 1 |
462231 | 462231 | 2020-08-23 | Love | Oklahoma | 40085 | 86 | 0 |
462232 | 462232 | 2020-08-23 | Major | Oklahoma | 40093 | 43 | 1 |
462233 | 462233 | 2020-08-23 | Marshall | Oklahoma | 40095 | 125 | 1 |
462234 | 462234 | 2020-08-23 | Mayes | Oklahoma | 40097 | 386 | 8 |
462235 | 462235 | 2020-08-23 | McClain | Oklahoma | 40087 | 534 | 4 |
462236 | 462236 | 2020-08-23 | McCurtain | Oklahoma | 40089 | 951 | 29 |
462237 | 462237 | 2020-08-23 | McIntosh | Oklahoma | 40091 | 223 | 4 |
462238 | 462238 | 2020-08-23 | Murray | Oklahoma | 40099 | 86 | 0 |
462239 | 462239 | 2020-08-23 | Muskogee | Oklahoma | 40101 | 662 | 16 |
462240 | 462240 | 2020-08-23 | Noble | Oklahoma | 40103 | 97 | 2 |
462241 | 462241 | 2020-08-23 | Nowata | Oklahoma | 40105 | 75 | 1 |
462242 | 462242 | 2020-08-23 | Okfuskee | Oklahoma | 40107 | 91 | 3 |
462243 | 462243 | 2020-08-23 | Oklahoma | Oklahoma | 40109 | 12584 | 143 |
462244 | 462244 | 2020-08-23 | Okmulgee | Oklahoma | 40111 | 566 | 4 |
462245 | 462245 | 2020-08-23 | Osage | Oklahoma | 40113 | 596 | 12 |
462246 | 462246 | 2020-08-23 | Ottawa | Oklahoma | 40115 | 464 | 4 |
462247 | 462247 | 2020-08-23 | Pawnee | Oklahoma | 40117 | 195 | 3 |
462248 | 462248 | 2020-08-23 | Payne | Oklahoma | 40119 | 914 | 4 |
462249 | 462249 | 2020-08-23 | Pittsburg | Oklahoma | 40121 | 531 | 12 |
462250 | 462250 | 2020-08-23 | Pontotoc | Oklahoma | 40123 | 223 | 2 |
462251 | 462251 | 2020-08-23 | Pottawatomie | Oklahoma | 40125 | 755 | 9 |
462252 | 462252 | 2020-08-23 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
462253 | 462253 | 2020-08-23 | Roger Mills | Oklahoma | 40129 | 12 | 1 |
462254 | 462254 | 2020-08-23 | Rogers | Oklahoma | 40131 | 1210 | 25 |
462255 | 462255 | 2020-08-23 | Seminole | Oklahoma | 40133 | 287 | 5 |
462256 | 462256 | 2020-08-23 | Sequoyah | Oklahoma | 40135 | 511 | 5 |
462257 | 462257 | 2020-08-23 | Stephens | Oklahoma | 40137 | 228 | 4 |
462258 | 462258 | 2020-08-23 | Texas | Oklahoma | 40139 | 1098 | 7 |
462259 | 462259 | 2020-08-23 | Tillman | Oklahoma | 40141 | 62 | 1 |
462260 | 462260 | 2020-08-23 | Tulsa | Oklahoma | 40143 | 12312 | 125 |
462261 | 462261 | 2020-08-23 | Unknown | Oklahoma | 6 | 0 | |
462262 | 462262 | 2020-08-23 | Wagoner | Oklahoma | 40145 | 1052 | 23 |
462263 | 462263 | 2020-08-23 | Washington | Oklahoma | 40147 | 740 | 39 |
462264 | 462264 | 2020-08-23 | Washita | Oklahoma | 40149 | 38 | 0 |
462265 | 462265 | 2020-08-23 | Woods | Oklahoma | 40151 | 24 | 0 |
462266 | 462266 | 2020-08-23 | Woodward | Oklahoma | 40153 | 72 | 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);