ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-01-24" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
961530 | 961530 | 2021-01-24 | Adair | Oklahoma | 40001 | 2661 | 18 |
961531 | 961531 | 2021-01-24 | Alfalfa | Oklahoma | 40003 | 1062 | 5 |
961532 | 961532 | 2021-01-24 | Atoka | Oklahoma | 40005 | 1608 | 8 |
961533 | 961533 | 2021-01-24 | Beaver | Oklahoma | 40007 | 370 | 4 |
961534 | 961534 | 2021-01-24 | Beckham | Oklahoma | 40009 | 2407 | 28 |
961535 | 961535 | 2021-01-24 | Blaine | Oklahoma | 40011 | 835 | 5 |
961536 | 961536 | 2021-01-24 | Bryan | Oklahoma | 40013 | 5099 | 44 |
961537 | 961537 | 2021-01-24 | Caddo | Oklahoma | 40015 | 3438 | 46 |
961538 | 961538 | 2021-01-24 | Canadian | Oklahoma | 40017 | 13840 | 61 |
961539 | 961539 | 2021-01-24 | Carter | Oklahoma | 40019 | 4740 | 23 |
961540 | 961540 | 2021-01-24 | Cherokee | Oklahoma | 40021 | 4874 | 29 |
961541 | 961541 | 2021-01-24 | Choctaw | Oklahoma | 40023 | 1389 | 11 |
961542 | 961542 | 2021-01-24 | Cimarron | Oklahoma | 40025 | 116 | 1 |
961543 | 961543 | 2021-01-24 | Cleveland | Oklahoma | 40027 | 25182 | 199 |
961544 | 961544 | 2021-01-24 | Coal | Oklahoma | 40029 | 613 | 8 |
961545 | 961545 | 2021-01-24 | Comanche | Oklahoma | 40031 | 9431 | 99 |
961546 | 961546 | 2021-01-24 | Cotton | Oklahoma | 40033 | 564 | 13 |
961547 | 961547 | 2021-01-24 | Craig | Oklahoma | 40035 | 1763 | 8 |
961548 | 961548 | 2021-01-24 | Creek | Oklahoma | 40037 | 5485 | 84 |
961549 | 961549 | 2021-01-24 | Custer | Oklahoma | 40039 | 3635 | 53 |
961550 | 961550 | 2021-01-24 | Delaware | Oklahoma | 40041 | 3936 | 54 |
961551 | 961551 | 2021-01-24 | Dewey | Oklahoma | 40043 | 490 | 4 |
961552 | 961552 | 2021-01-24 | Ellis | Oklahoma | 40045 | 332 | 1 |
961553 | 961553 | 2021-01-24 | Garfield | Oklahoma | 40047 | 6614 | 57 |
961554 | 961554 | 2021-01-24 | Garvin | Oklahoma | 40049 | 3098 | 25 |
961555 | 961555 | 2021-01-24 | Grady | Oklahoma | 40051 | 5044 | 55 |
961556 | 961556 | 2021-01-24 | Grant | Oklahoma | 40053 | 478 | 5 |
961557 | 961557 | 2021-01-24 | Greer | Oklahoma | 40055 | 451 | 11 |
961558 | 961558 | 2021-01-24 | Harmon | Oklahoma | 40057 | 252 | 1 |
961559 | 961559 | 2021-01-24 | Harper | Oklahoma | 40059 | 384 | 3 |
961560 | 961560 | 2021-01-24 | Haskell | Oklahoma | 40061 | 1107 | 8 |
961561 | 961561 | 2021-01-24 | Hughes | Oklahoma | 40063 | 1028 | 13 |
961562 | 961562 | 2021-01-24 | Jackson | Oklahoma | 40065 | 2664 | 40 |
961563 | 961563 | 2021-01-24 | Jefferson | Oklahoma | 40067 | 611 | 7 |
961564 | 961564 | 2021-01-24 | Johnston | Oklahoma | 40069 | 1140 | 13 |
961565 | 961565 | 2021-01-24 | Kay | Oklahoma | 40071 | 4559 | 54 |
961566 | 961566 | 2021-01-24 | Kingfisher | Oklahoma | 40073 | 1791 | 18 |
961567 | 961567 | 2021-01-24 | Kiowa | Oklahoma | 40075 | 703 | 13 |
961568 | 961568 | 2021-01-24 | Latimer | Oklahoma | 40077 | 703 | 7 |
961569 | 961569 | 2021-01-24 | Le Flore | Oklahoma | 40079 | 4632 | 37 |
961570 | 961570 | 2021-01-24 | Lincoln | Oklahoma | 40081 | 2706 | 39 |
961571 | 961571 | 2021-01-24 | Logan | Oklahoma | 40083 | 3473 | 22 |
961572 | 961572 | 2021-01-24 | Love | Oklahoma | 40085 | 1295 | 8 |
961573 | 961573 | 2021-01-24 | Major | Oklahoma | 40093 | 850 | 4 |
961574 | 961574 | 2021-01-24 | Marshall | Oklahoma | 40095 | 1612 | 11 |
961575 | 961575 | 2021-01-24 | Mayes | Oklahoma | 40097 | 3415 | 31 |
961576 | 961576 | 2021-01-24 | McClain | Oklahoma | 40087 | 4497 | 36 |
961577 | 961577 | 2021-01-24 | McCurtain | Oklahoma | 40089 | 3354 | 57 |
961578 | 961578 | 2021-01-24 | McIntosh | Oklahoma | 40091 | 1706 | 27 |
961579 | 961579 | 2021-01-24 | Murray | Oklahoma | 40099 | 1645 | 16 |
961580 | 961580 | 2021-01-24 | Muskogee | Oklahoma | 40101 | 8140 | 66 |
961581 | 961581 | 2021-01-24 | Noble | Oklahoma | 40103 | 1200 | 8 |
961582 | 961582 | 2021-01-24 | Nowata | Oklahoma | 40105 | 954 | 12 |
961583 | 961583 | 2021-01-24 | Okfuskee | Oklahoma | 40107 | 1637 | 16 |
961584 | 961584 | 2021-01-24 | Oklahoma | Oklahoma | 40109 | 72550 | 539 |
961585 | 961585 | 2021-01-24 | Okmulgee | Oklahoma | 40111 | 3212 | 37 |
961586 | 961586 | 2021-01-24 | Osage | Oklahoma | 40113 | 3897 | 38 |
961587 | 961587 | 2021-01-24 | Ottawa | Oklahoma | 40115 | 3332 | 34 |
961588 | 961588 | 2021-01-24 | Pawnee | Oklahoma | 40117 | 1414 | 19 |
961589 | 961589 | 2021-01-24 | Payne | Oklahoma | 40119 | 7520 | 39 |
961590 | 961590 | 2021-01-24 | Pittsburg | Oklahoma | 40121 | 3906 | 31 |
961591 | 961591 | 2021-01-24 | Pontotoc | Oklahoma | 40123 | 4196 | 36 |
961592 | 961592 | 2021-01-24 | Pottawatomie | Oklahoma | 40125 | 6941 | 48 |
961593 | 961593 | 2021-01-24 | Pushmataha | Oklahoma | 40127 | 863 | 8 |
961594 | 961594 | 2021-01-24 | Roger Mills | Oklahoma | 40129 | 359 | 6 |
961595 | 961595 | 2021-01-24 | Rogers | Oklahoma | 40131 | 8637 | 94 |
961596 | 961596 | 2021-01-24 | Seminole | Oklahoma | 40133 | 2414 | 25 |
961597 | 961597 | 2021-01-24 | Sequoyah | Oklahoma | 40135 | 3399 | 24 |
961598 | 961598 | 2021-01-24 | Stephens | Oklahoma | 40137 | 4104 | 43 |
961599 | 961599 | 2021-01-24 | Texas | Oklahoma | 40139 | 3278 | 20 |
961600 | 961600 | 2021-01-24 | Tillman | Oklahoma | 40141 | 674 | 13 |
961601 | 961601 | 2021-01-24 | Tulsa | Oklahoma | 40143 | 61145 | 541 |
961602 | 961602 | 2021-01-24 | Unknown | Oklahoma | 89 | 0 | |
961603 | 961603 | 2021-01-24 | Wagoner | Oklahoma | 40145 | 6541 | 65 |
961604 | 961604 | 2021-01-24 | Washington | Oklahoma | 40147 | 4011 | 70 |
961605 | 961605 | 2021-01-24 | Washita | Oklahoma | 40149 | 963 | 6 |
961606 | 961606 | 2021-01-24 | Woods | Oklahoma | 40151 | 1127 | 5 |
961607 | 961607 | 2021-01-24 | Woodward | Oklahoma | 40153 | 2905 | 12 |
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);