ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,927 rows where state = "Oklahoma" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Oklahoma · 7,927
Link rowid date ▲ county state fips cases deaths
336485 2020-07-15 Adair Oklahoma 40001 160 4
336486 2020-07-15 Alfalfa Oklahoma 40003 1 0
336487 2020-07-15 Atoka Oklahoma 40005 42 0
336488 2020-07-15 Beaver Oklahoma 40007 32 0
336489 2020-07-15 Beckham Oklahoma 40009 25 0
336490 2020-07-15 Blaine Oklahoma 40011 22 0
336491 2020-07-15 Bryan Oklahoma 40013 199 1
336492 2020-07-15 Caddo Oklahoma 40015 214 11
336493 2020-07-15 Canadian Oklahoma 40017 594 3
336494 2020-07-15 Carter Oklahoma 40019 203 2
336495 2020-07-15 Cherokee Oklahoma 40021 138 1
336496 2020-07-15 Choctaw Oklahoma 40023 131 1
336497 2020-07-15 Cimarron Oklahoma 40025 1 0
336498 2020-07-15 Cleveland Oklahoma 40027 1526 40
336499 2020-07-15 Coal Oklahoma 40029 12 0
336500 2020-07-15 Comanche Oklahoma 40031 570 9
336501 2020-07-15 Cotton Oklahoma 40033 13 2
336502 2020-07-15 Craig Oklahoma 40035 29 0
336503 2020-07-15 Creek Oklahoma 40037 231 9
336504 2020-07-15 Custer Oklahoma 40039 93 0
336505 2020-07-15 Delaware Oklahoma 40041 270 17
336506 2020-07-15 Dewey Oklahoma 40043 4 0
336507 2020-07-15 Ellis Oklahoma 40045 2 0
336508 2020-07-15 Garfield Oklahoma 40047 138 2
336509 2020-07-15 Garvin Oklahoma 40049 140 3
336510 2020-07-15 Grady Oklahoma 40051 264 5
336511 2020-07-15 Grant Oklahoma 40053 3 0
336512 2020-07-15 Greer Oklahoma 40055 71 7
336513 2020-07-15 Harmon Oklahoma 40057 4 0
336514 2020-07-15 Harper Oklahoma 40059 2 0
336515 2020-07-15 Haskell Oklahoma 40061 19 0
336516 2020-07-15 Hughes Oklahoma 40063 16 0
336517 2020-07-15 Jackson Oklahoma 40065 128 3
336518 2020-07-15 Jefferson Oklahoma 40067 19 0
336519 2020-07-15 Johnston Oklahoma 40069 21 0
336520 2020-07-15 Kay Oklahoma 40071 133 9
336521 2020-07-15 Kingfisher Oklahoma 40073 54 0
336522 2020-07-15 Kiowa Oklahoma 40075 18 1
336523 2020-07-15 Latimer Oklahoma 40077 25 1
336524 2020-07-15 Le Flore Oklahoma 40079 75 1
336525 2020-07-15 Lincoln Oklahoma 40081 49 2
336526 2020-07-15 Logan Oklahoma 40083 111 1
336527 2020-07-15 Love Oklahoma 40085 49 0
336528 2020-07-15 Major Oklahoma 40093 16 1
336529 2020-07-15 Marshall Oklahoma 40095 49 0
336530 2020-07-15 Mayes Oklahoma 40097 148 5
336531 2020-07-15 McClain Oklahoma 40087 271 4
336532 2020-07-15 McCurtain Oklahoma 40089 651 12
336533 2020-07-15 McIntosh Oklahoma 40091 88 1
336534 2020-07-15 Murray Oklahoma 40099 28 0
336535 2020-07-15 Muskogee Oklahoma 40101 228 14
336536 2020-07-15 Noble Oklahoma 40103 55 1
336537 2020-07-15 Nowata Oklahoma 40105 41 1
336538 2020-07-15 Okfuskee Oklahoma 40107 20 0
336539 2020-07-15 Oklahoma Oklahoma 40109 5591 76
336540 2020-07-15 Okmulgee Oklahoma 40111 196 0
336541 2020-07-15 Osage Oklahoma 40113 228 8
336542 2020-07-15 Ottawa Oklahoma 40115 190 2
336543 2020-07-15 Pawnee Oklahoma 40117 75 3
336544 2020-07-15 Payne Oklahoma 40119 493 2
336545 2020-07-15 Pittsburg Oklahoma 40121 83 3
336546 2020-07-15 Pontotoc Oklahoma 40123 93 2
336547 2020-07-15 Pottawatomie Oklahoma 40125 178 4
336548 2020-07-15 Pushmataha Oklahoma 40127 35 0
336549 2020-07-15 Rogers Oklahoma 40131 368 7
336550 2020-07-15 Seminole Oklahoma 40133 80 3
336551 2020-07-15 Sequoyah Oklahoma 40135 73 3
336552 2020-07-15 Stephens Oklahoma 40137 102 1
336553 2020-07-15 Texas Oklahoma 40139 1007 6
336554 2020-07-15 Tillman Oklahoma 40141 27 1
336555 2020-07-15 Tulsa Oklahoma 40143 5626 79
336556 2020-07-15 Wagoner Oklahoma 40145 410 19
336557 2020-07-15 Washington Oklahoma 40147 474 39
336558 2020-07-15 Washita Oklahoma 40149 12 0
336559 2020-07-15 Woods Oklahoma 40151 11 0
336560 2020-07-15 Woodward Oklahoma 40153 15 0
333293 2020-07-14 Adair Oklahoma 40001 144 4
333294 2020-07-14 Alfalfa Oklahoma 40003 1 0
333295 2020-07-14 Atoka Oklahoma 40005 42 0
333296 2020-07-14 Beaver Oklahoma 40007 32 0
333297 2020-07-14 Beckham Oklahoma 40009 22 0
333298 2020-07-14 Blaine Oklahoma 40011 22 0
333299 2020-07-14 Bryan Oklahoma 40013 190 1
333300 2020-07-14 Caddo Oklahoma 40015 210 11
333301 2020-07-14 Canadian Oklahoma 40017 543 3
333302 2020-07-14 Carter Oklahoma 40019 186 2
333303 2020-07-14 Cherokee Oklahoma 40021 131 1
333304 2020-07-14 Choctaw Oklahoma 40023 128 1
333305 2020-07-14 Cimarron Oklahoma 40025 1 0
333306 2020-07-14 Cleveland Oklahoma 40027 1448 40
333307 2020-07-14 Coal Oklahoma 40029 12 0
333308 2020-07-14 Comanche Oklahoma 40031 517 9
333309 2020-07-14 Cotton Oklahoma 40033 12 2
333310 2020-07-14 Craig Oklahoma 40035 27 0
333311 2020-07-14 Creek Oklahoma 40037 223 8
333312 2020-07-14 Custer Oklahoma 40039 85 0
333313 2020-07-14 Delaware Oklahoma 40041 261 17
333314 2020-07-14 Dewey Oklahoma 40043 4 0
333315 2020-07-14 Ellis Oklahoma 40045 2 0
333316 2020-07-14 Garfield Oklahoma 40047 132 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1132.895ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette