ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-09-26" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
572187 | 572187 | 2020-09-26 | Adair | Oklahoma | 40001 | 614 | 10 |
572188 | 572188 | 2020-09-26 | Alfalfa | Oklahoma | 40003 | 64 | 0 |
572189 | 572189 | 2020-09-26 | Atoka | Oklahoma | 40005 | 293 | 1 |
572190 | 572190 | 2020-09-26 | Beaver | Oklahoma | 40007 | 54 | 0 |
572191 | 572191 | 2020-09-26 | Beckham | Oklahoma | 40009 | 404 | 1 |
572192 | 572192 | 2020-09-26 | Blaine | Oklahoma | 40011 | 126 | 1 |
572193 | 572193 | 2020-09-26 | Bryan | Oklahoma | 40013 | 940 | 4 |
572194 | 572194 | 2020-09-26 | Caddo | Oklahoma | 40015 | 758 | 21 |
572195 | 572195 | 2020-09-26 | Canadian | Oklahoma | 40017 | 2210 | 17 |
572196 | 572196 | 2020-09-26 | Carter | Oklahoma | 40019 | 549 | 8 |
572197 | 572197 | 2020-09-26 | Cherokee | Oklahoma | 40021 | 1070 | 8 |
572198 | 572198 | 2020-09-26 | Choctaw | Oklahoma | 40023 | 316 | 2 |
572199 | 572199 | 2020-09-26 | Cimarron | Oklahoma | 40025 | 24 | 0 |
572200 | 572200 | 2020-09-26 | Cleveland | Oklahoma | 40027 | 5967 | 70 |
572201 | 572201 | 2020-09-26 | Coal | Oklahoma | 40029 | 70 | 0 |
572202 | 572202 | 2020-09-26 | Comanche | Oklahoma | 40031 | 1578 | 13 |
572203 | 572203 | 2020-09-26 | Cotton | Oklahoma | 40033 | 68 | 3 |
572204 | 572204 | 2020-09-26 | Craig | Oklahoma | 40035 | 501 | 1 |
572205 | 572205 | 2020-09-26 | Creek | Oklahoma | 40037 | 1138 | 33 |
572206 | 572206 | 2020-09-26 | Custer | Oklahoma | 40039 | 666 | 0 |
572207 | 572207 | 2020-09-26 | Delaware | Oklahoma | 40041 | 741 | 25 |
572208 | 572208 | 2020-09-26 | Dewey | Oklahoma | 40043 | 66 | 1 |
572209 | 572209 | 2020-09-26 | Ellis | Oklahoma | 40045 | 11 | 0 |
572210 | 572210 | 2020-09-26 | Garfield | Oklahoma | 40047 | 1634 | 20 |
572211 | 572211 | 2020-09-26 | Garvin | Oklahoma | 40049 | 367 | 5 |
572212 | 572212 | 2020-09-26 | Grady | Oklahoma | 40051 | 1059 | 11 |
572213 | 572213 | 2020-09-26 | Grant | Oklahoma | 40053 | 46 | 0 |
572214 | 572214 | 2020-09-26 | Greer | Oklahoma | 40055 | 108 | 8 |
572215 | 572215 | 2020-09-26 | Harmon | Oklahoma | 40057 | 43 | 0 |
572216 | 572216 | 2020-09-26 | Harper | Oklahoma | 40059 | 29 | 1 |
572217 | 572217 | 2020-09-26 | Haskell | Oklahoma | 40061 | 278 | 4 |
572218 | 572218 | 2020-09-26 | Hughes | Oklahoma | 40063 | 296 | 4 |
572219 | 572219 | 2020-09-26 | Jackson | Oklahoma | 40065 | 759 | 10 |
572220 | 572220 | 2020-09-26 | Jefferson | Oklahoma | 40067 | 42 | 0 |
572221 | 572221 | 2020-09-26 | Johnston | Oklahoma | 40069 | 165 | 4 |
572222 | 572222 | 2020-09-26 | Kay | Oklahoma | 40071 | 585 | 13 |
572223 | 572223 | 2020-09-26 | Kingfisher | Oklahoma | 40073 | 345 | 2 |
572224 | 572224 | 2020-09-26 | Kiowa | Oklahoma | 40075 | 75 | 2 |
572225 | 572225 | 2020-09-26 | Latimer | Oklahoma | 40077 | 136 | 2 |
572226 | 572226 | 2020-09-26 | Le Flore | Oklahoma | 40079 | 1102 | 17 |
572227 | 572227 | 2020-09-26 | Lincoln | Oklahoma | 40081 | 441 | 10 |
572228 | 572228 | 2020-09-26 | Logan | Oklahoma | 40083 | 467 | 1 |
572229 | 572229 | 2020-09-26 | Love | Oklahoma | 40085 | 174 | 1 |
572230 | 572230 | 2020-09-26 | Major | Oklahoma | 40093 | 90 | 1 |
572231 | 572231 | 2020-09-26 | Marshall | Oklahoma | 40095 | 180 | 2 |
572232 | 572232 | 2020-09-26 | Mayes | Oklahoma | 40097 | 628 | 11 |
572233 | 572233 | 2020-09-26 | McClain | Oklahoma | 40087 | 854 | 7 |
572234 | 572234 | 2020-09-26 | McCurtain | Oklahoma | 40089 | 1273 | 34 |
572235 | 572235 | 2020-09-26 | McIntosh | Oklahoma | 40091 | 319 | 5 |
572236 | 572236 | 2020-09-26 | Murray | Oklahoma | 40099 | 137 | 1 |
572237 | 572237 | 2020-09-26 | Muskogee | Oklahoma | 40101 | 1822 | 22 |
572238 | 572238 | 2020-09-26 | Noble | Oklahoma | 40103 | 151 | 2 |
572239 | 572239 | 2020-09-26 | Nowata | Oklahoma | 40105 | 143 | 4 |
572240 | 572240 | 2020-09-26 | Okfuskee | Oklahoma | 40107 | 138 | 4 |
572241 | 572241 | 2020-09-26 | Oklahoma | Oklahoma | 40109 | 17711 | 194 |
572242 | 572242 | 2020-09-26 | Okmulgee | Oklahoma | 40111 | 833 | 7 |
572243 | 572243 | 2020-09-26 | Osage | Oklahoma | 40113 | 903 | 13 |
572244 | 572244 | 2020-09-26 | Ottawa | Oklahoma | 40115 | 858 | 6 |
572245 | 572245 | 2020-09-26 | Pawnee | Oklahoma | 40117 | 253 | 3 |
572246 | 572246 | 2020-09-26 | Payne | Oklahoma | 40119 | 2215 | 6 |
572247 | 572247 | 2020-09-26 | Pittsburg | Oklahoma | 40121 | 958 | 19 |
572248 | 572248 | 2020-09-26 | Pontotoc | Oklahoma | 40123 | 404 | 3 |
572249 | 572249 | 2020-09-26 | Pottawatomie | Oklahoma | 40125 | 1331 | 10 |
572250 | 572250 | 2020-09-26 | Pushmataha | Oklahoma | 40127 | 163 | 2 |
572251 | 572251 | 2020-09-26 | Roger Mills | Oklahoma | 40129 | 46 | 1 |
572252 | 572252 | 2020-09-26 | Rogers | Oklahoma | 40131 | 1852 | 50 |
572253 | 572253 | 2020-09-26 | Seminole | Oklahoma | 40133 | 448 | 6 |
572254 | 572254 | 2020-09-26 | Sequoyah | Oklahoma | 40135 | 873 | 11 |
572255 | 572255 | 2020-09-26 | Stephens | Oklahoma | 40137 | 432 | 5 |
572256 | 572256 | 2020-09-26 | Texas | Oklahoma | 40139 | 1507 | 9 |
572257 | 572257 | 2020-09-26 | Tillman | Oklahoma | 40141 | 93 | 2 |
572258 | 572258 | 2020-09-26 | Tulsa | Oklahoma | 40143 | 16793 | 160 |
572259 | 572259 | 2020-09-26 | Unknown | Oklahoma | 50 | 0 | |
572260 | 572260 | 2020-09-26 | Wagoner | Oklahoma | 40145 | 1467 | 26 |
572261 | 572261 | 2020-09-26 | Washington | Oklahoma | 40147 | 989 | 40 |
572262 | 572262 | 2020-09-26 | Washita | Oklahoma | 40149 | 78 | 0 |
572263 | 572263 | 2020-09-26 | Woods | Oklahoma | 40151 | 108 | 0 |
572264 | 572264 | 2020-09-26 | Woodward | Oklahoma | 40153 | 1031 | 4 |
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);