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-20 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
452505 | 452505 | 2020-08-20 | Adair | Oklahoma | 40001 | 400 | 6 |
452506 | 452506 | 2020-08-20 | Alfalfa | Oklahoma | 40003 | 6 | 0 |
452507 | 452507 | 2020-08-20 | Atoka | Oklahoma | 40005 | 90 | 1 |
452508 | 452508 | 2020-08-20 | Beaver | Oklahoma | 40007 | 40 | 0 |
452509 | 452509 | 2020-08-20 | Beckham | Oklahoma | 40009 | 103 | 1 |
452510 | 452510 | 2020-08-20 | Blaine | Oklahoma | 40011 | 50 | 0 |
452511 | 452511 | 2020-08-20 | Bryan | Oklahoma | 40013 | 532 | 3 |
452512 | 452512 | 2020-08-20 | Caddo | Oklahoma | 40015 | 492 | 20 |
452513 | 452513 | 2020-08-20 | Canadian | Oklahoma | 40017 | 1361 | 9 |
452514 | 452514 | 2020-08-20 | Carter | Oklahoma | 40019 | 375 | 5 |
452515 | 452515 | 2020-08-20 | Cherokee | Oklahoma | 40021 | 569 | 2 |
452516 | 452516 | 2020-08-20 | Choctaw | Oklahoma | 40023 | 211 | 1 |
452517 | 452517 | 2020-08-20 | Cimarron | Oklahoma | 40025 | 14 | 0 |
452518 | 452518 | 2020-08-20 | Cleveland | Oklahoma | 40027 | 3399 | 62 |
452519 | 452519 | 2020-08-20 | Coal | Oklahoma | 40029 | 46 | 0 |
452520 | 452520 | 2020-08-20 | Comanche | Oklahoma | 40031 | 923 | 11 |
452521 | 452521 | 2020-08-20 | Cotton | Oklahoma | 40033 | 22 | 2 |
452522 | 452522 | 2020-08-20 | Craig | Oklahoma | 40035 | 97 | 1 |
452523 | 452523 | 2020-08-20 | Creek | Oklahoma | 40037 | 721 | 19 |
452524 | 452524 | 2020-08-20 | Custer | Oklahoma | 40039 | 249 | 0 |
452525 | 452525 | 2020-08-20 | Delaware | Oklahoma | 40041 | 493 | 20 |
452526 | 452526 | 2020-08-20 | Dewey | Oklahoma | 40043 | 19 | 0 |
452527 | 452527 | 2020-08-20 | Ellis | Oklahoma | 40045 | 6 | 0 |
452528 | 452528 | 2020-08-20 | Garfield | Oklahoma | 40047 | 671 | 9 |
452529 | 452529 | 2020-08-20 | Garvin | Oklahoma | 40049 | 250 | 4 |
452530 | 452530 | 2020-08-20 | Grady | Oklahoma | 40051 | 481 | 7 |
452531 | 452531 | 2020-08-20 | Grant | Oklahoma | 40053 | 18 | 0 |
452532 | 452532 | 2020-08-20 | Greer | Oklahoma | 40055 | 84 | 8 |
452533 | 452533 | 2020-08-20 | Harmon | Oklahoma | 40057 | 32 | 0 |
452534 | 452534 | 2020-08-20 | Harper | Oklahoma | 40059 | 13 | 0 |
452535 | 452535 | 2020-08-20 | Haskell | Oklahoma | 40061 | 133 | 1 |
452536 | 452536 | 2020-08-20 | Hughes | Oklahoma | 40063 | 185 | 3 |
452537 | 452537 | 2020-08-20 | Jackson | Oklahoma | 40065 | 553 | 7 |
452538 | 452538 | 2020-08-20 | Jefferson | Oklahoma | 40067 | 34 | 0 |
452539 | 452539 | 2020-08-20 | Johnston | Oklahoma | 40069 | 60 | 0 |
452540 | 452540 | 2020-08-20 | Kay | Oklahoma | 40071 | 275 | 11 |
452541 | 452541 | 2020-08-20 | Kingfisher | Oklahoma | 40073 | 186 | 0 |
452542 | 452542 | 2020-08-20 | Kiowa | Oklahoma | 40075 | 36 | 1 |
452543 | 452543 | 2020-08-20 | Latimer | Oklahoma | 40077 | 103 | 2 |
452544 | 452544 | 2020-08-20 | Le Flore | Oklahoma | 40079 | 481 | 3 |
452545 | 452545 | 2020-08-20 | Lincoln | Oklahoma | 40081 | 250 | 5 |
452546 | 452546 | 2020-08-20 | Logan | Oklahoma | 40083 | 253 | 1 |
452547 | 452547 | 2020-08-20 | Love | Oklahoma | 40085 | 82 | 0 |
452548 | 452548 | 2020-08-20 | Major | Oklahoma | 40093 | 38 | 1 |
452549 | 452549 | 2020-08-20 | Marshall | Oklahoma | 40095 | 123 | 1 |
452550 | 452550 | 2020-08-20 | Mayes | Oklahoma | 40097 | 380 | 8 |
452551 | 452551 | 2020-08-20 | McClain | Oklahoma | 40087 | 506 | 4 |
452552 | 452552 | 2020-08-20 | McCurtain | Oklahoma | 40089 | 914 | 29 |
452553 | 452553 | 2020-08-20 | McIntosh | Oklahoma | 40091 | 213 | 3 |
452554 | 452554 | 2020-08-20 | Murray | Oklahoma | 40099 | 84 | 0 |
452555 | 452555 | 2020-08-20 | Muskogee | Oklahoma | 40101 | 628 | 16 |
452556 | 452556 | 2020-08-20 | Noble | Oklahoma | 40103 | 92 | 2 |
452557 | 452557 | 2020-08-20 | Nowata | Oklahoma | 40105 | 70 | 1 |
452558 | 452558 | 2020-08-20 | Okfuskee | Oklahoma | 40107 | 89 | 3 |
452559 | 452559 | 2020-08-20 | Oklahoma | Oklahoma | 40109 | 12037 | 139 |
452560 | 452560 | 2020-08-20 | Okmulgee | Oklahoma | 40111 | 531 | 3 |
452561 | 452561 | 2020-08-20 | Osage | Oklahoma | 40113 | 582 | 12 |
452562 | 452562 | 2020-08-20 | Ottawa | Oklahoma | 40115 | 442 | 3 |
452563 | 452563 | 2020-08-20 | Pawnee | Oklahoma | 40117 | 178 | 3 |
452564 | 452564 | 2020-08-20 | Payne | Oklahoma | 40119 | 847 | 4 |
452565 | 452565 | 2020-08-20 | Pittsburg | Oklahoma | 40121 | 502 | 11 |
452566 | 452566 | 2020-08-20 | Pontotoc | Oklahoma | 40123 | 215 | 2 |
452567 | 452567 | 2020-08-20 | Pottawatomie | Oklahoma | 40125 | 631 | 9 |
452568 | 452568 | 2020-08-20 | Pushmataha | Oklahoma | 40127 | 118 | 0 |
452569 | 452569 | 2020-08-20 | Roger Mills | Oklahoma | 40129 | 9 | 1 |
452570 | 452570 | 2020-08-20 | Rogers | Oklahoma | 40131 | 1179 | 23 |
452571 | 452571 | 2020-08-20 | Seminole | Oklahoma | 40133 | 273 | 5 |
452572 | 452572 | 2020-08-20 | Sequoyah | Oklahoma | 40135 | 483 | 5 |
452573 | 452573 | 2020-08-20 | Stephens | Oklahoma | 40137 | 224 | 3 |
452574 | 452574 | 2020-08-20 | Texas | Oklahoma | 40139 | 1083 | 7 |
452575 | 452575 | 2020-08-20 | Tillman | Oklahoma | 40141 | 59 | 1 |
452576 | 452576 | 2020-08-20 | Tulsa | Oklahoma | 40143 | 11873 | 123 |
452577 | 452577 | 2020-08-20 | Unknown | Oklahoma | 17 | 0 | |
452578 | 452578 | 2020-08-20 | Wagoner | Oklahoma | 40145 | 1003 | 23 |
452579 | 452579 | 2020-08-20 | Washington | Oklahoma | 40147 | 724 | 39 |
452580 | 452580 | 2020-08-20 | Washita | Oklahoma | 40149 | 37 | 0 |
452581 | 452581 | 2020-08-20 | Woods | Oklahoma | 40151 | 24 | 0 |
452582 | 452582 | 2020-08-20 | Woodward | Oklahoma | 40153 | 63 | 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);