ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where "date" is on date 2020-04-11 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
50240 | 50240 | 2020-04-11 | Adair | Oklahoma | 40001 | 27 | 2 |
50241 | 50241 | 2020-04-11 | Atoka | Oklahoma | 40005 | 1 | 0 |
50242 | 50242 | 2020-04-11 | Beaver | Oklahoma | 40007 | 1 | 0 |
50243 | 50243 | 2020-04-11 | Beckham | Oklahoma | 40009 | 1 | 0 |
50244 | 50244 | 2020-04-11 | Bryan | Oklahoma | 40013 | 3 | 0 |
50245 | 50245 | 2020-04-11 | Caddo | Oklahoma | 40015 | 9 | 0 |
50246 | 50246 | 2020-04-11 | Canadian | Oklahoma | 40017 | 56 | 1 |
50247 | 50247 | 2020-04-11 | Carter | Oklahoma | 40019 | 1 | 0 |
50248 | 50248 | 2020-04-11 | Cherokee | Oklahoma | 40021 | 18 | 1 |
50249 | 50249 | 2020-04-11 | Choctaw | Oklahoma | 40023 | 2 | 0 |
50250 | 50250 | 2020-04-11 | Cleveland | Oklahoma | 40027 | 247 | 17 |
50251 | 50251 | 2020-04-11 | Comanche | Oklahoma | 40031 | 49 | 0 |
50252 | 50252 | 2020-04-11 | Cotton | Oklahoma | 40033 | 4 | 0 |
50253 | 50253 | 2020-04-11 | Craig | Oklahoma | 40035 | 6 | 0 |
50254 | 50254 | 2020-04-11 | Creek | Oklahoma | 40037 | 54 | 3 |
50255 | 50255 | 2020-04-11 | Custer | Oklahoma | 40039 | 5 | 0 |
50256 | 50256 | 2020-04-11 | Delaware | Oklahoma | 40041 | 24 | 0 |
50257 | 50257 | 2020-04-11 | Dewey | Oklahoma | 40043 | 1 | 0 |
50258 | 50258 | 2020-04-11 | Garfield | Oklahoma | 40047 | 6 | 1 |
50259 | 50259 | 2020-04-11 | Garvin | Oklahoma | 40049 | 10 | 0 |
50260 | 50260 | 2020-04-11 | Grady | Oklahoma | 40051 | 11 | 0 |
50261 | 50261 | 2020-04-11 | Grant | Oklahoma | 40053 | 2 | 0 |
50262 | 50262 | 2020-04-11 | Greer | Oklahoma | 40055 | 48 | 4 |
50263 | 50263 | 2020-04-11 | Jackson | Oklahoma | 40065 | 7 | 0 |
50264 | 50264 | 2020-04-11 | Jefferson | Oklahoma | 40067 | 1 | 0 |
50265 | 50265 | 2020-04-11 | Kay | Oklahoma | 40071 | 42 | 3 |
50266 | 50266 | 2020-04-11 | Kingfisher | Oklahoma | 40073 | 5 | 0 |
50267 | 50267 | 2020-04-11 | Kiowa | Oklahoma | 40075 | 1 | 0 |
50268 | 50268 | 2020-04-11 | Latimer | Oklahoma | 40077 | 4 | 1 |
50269 | 50269 | 2020-04-11 | Le Flore | Oklahoma | 40079 | 3 | 0 |
50270 | 50270 | 2020-04-11 | Lincoln | Oklahoma | 40081 | 11 | 0 |
50271 | 50271 | 2020-04-11 | Logan | Oklahoma | 40083 | 7 | 0 |
50272 | 50272 | 2020-04-11 | Love | Oklahoma | 40085 | 2 | 0 |
50273 | 50273 | 2020-04-11 | Major | Oklahoma | 40093 | 1 | 0 |
50274 | 50274 | 2020-04-11 | Marshall | Oklahoma | 40095 | 1 | 0 |
50275 | 50275 | 2020-04-11 | Mayes | Oklahoma | 40097 | 13 | 2 |
50276 | 50276 | 2020-04-11 | McClain | Oklahoma | 40087 | 18 | 0 |
50277 | 50277 | 2020-04-11 | McCurtain | Oklahoma | 40089 | 2 | 0 |
50278 | 50278 | 2020-04-11 | Murray | Oklahoma | 40099 | 1 | 0 |
50279 | 50279 | 2020-04-11 | Muskogee | Oklahoma | 40101 | 21 | 2 |
50280 | 50280 | 2020-04-11 | Noble | Oklahoma | 40103 | 6 | 0 |
50281 | 50281 | 2020-04-11 | Nowata | Oklahoma | 40105 | 10 | 0 |
50282 | 50282 | 2020-04-11 | Okfuskee | Oklahoma | 40107 | 1 | 0 |
50283 | 50283 | 2020-04-11 | Oklahoma | Oklahoma | 40109 | 425 | 19 |
50284 | 50284 | 2020-04-11 | Okmulgee | Oklahoma | 40111 | 13 | 0 |
50285 | 50285 | 2020-04-11 | Osage | Oklahoma | 40113 | 45 | 7 |
50286 | 50286 | 2020-04-11 | Ottawa | Oklahoma | 40115 | 16 | 0 |
50287 | 50287 | 2020-04-11 | Pawnee | Oklahoma | 40117 | 26 | 2 |
50288 | 50288 | 2020-04-11 | Payne | Oklahoma | 40119 | 28 | 0 |
50289 | 50289 | 2020-04-11 | Pittsburg | Oklahoma | 40121 | 8 | 0 |
50290 | 50290 | 2020-04-11 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
50291 | 50291 | 2020-04-11 | Pottawatomie | Oklahoma | 40125 | 25 | 2 |
50292 | 50292 | 2020-04-11 | Rogers | Oklahoma | 40131 | 24 | 0 |
50293 | 50293 | 2020-04-11 | Seminole | Oklahoma | 40133 | 6 | 1 |
50294 | 50294 | 2020-04-11 | Sequoyah | Oklahoma | 40135 | 9 | 2 |
50295 | 50295 | 2020-04-11 | Stephens | Oklahoma | 40137 | 13 | 1 |
50296 | 50296 | 2020-04-11 | Texas | Oklahoma | 40139 | 3 | 0 |
50297 | 50297 | 2020-04-11 | Tillman | Oklahoma | 40141 | 1 | 0 |
50298 | 50298 | 2020-04-11 | Tulsa | Oklahoma | 40143 | 323 | 16 |
50299 | 50299 | 2020-04-11 | Wagoner | Oklahoma | 40145 | 67 | 4 |
50300 | 50300 | 2020-04-11 | Washington | Oklahoma | 40147 | 83 | 2 |
50301 | 50301 | 2020-04-11 | 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);