ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22,952 rows where state = "Oklahoma" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 40143 325
- 40109 318
- 40065 317
- 40027 316
- 40071 316
- 40119 316
- 40017 315
- 40117 314
- 40039 312
- 40051 312
- 40083 312
- 40087 312
- 40147 312
- 40049 311
- 40101 309
- 40103 309
- 40123 308
- 40097 307
- 40145 307
- 40001 306
- 40013 306
- 40019 306
- 40037 306
- 40041 306
- 40113 306
- 40125 306
- 40137 306
- 40031 305
- 40035 305
- 40081 305
- ...
county
- Tulsa 325
- Oklahoma 318
- Jackson 317
- Cleveland 316
- Kay 316
- Payne 316
- Canadian 315
- Pawnee 314
- Custer 312
- Grady 312
- Logan 312
- McClain 312
- Washington 312
- Garvin 311
- Muskogee 309
- Noble 309
- Pontotoc 308
- Mayes 307
- Wagoner 307
- Adair 306
- Bryan 306
- Carter 306
- Creek 306
- Delaware 306
- Osage 306
- Pottawatomie 306
- Stephens 306
- Comanche 305
- Craig 305
- Lincoln 305
- ...
state
- Oklahoma · 22,952 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
961610 | 961610 | 2021-01-24 | Adair | Oklahoma | 40001 | 2661 | 18 |
961611 | 961611 | 2021-01-24 | Alfalfa | Oklahoma | 40003 | 1062 | 5 |
961612 | 961612 | 2021-01-24 | Atoka | Oklahoma | 40005 | 1608 | 8 |
961613 | 961613 | 2021-01-24 | Beaver | Oklahoma | 40007 | 370 | 4 |
961614 | 961614 | 2021-01-24 | Beckham | Oklahoma | 40009 | 2407 | 28 |
961615 | 961615 | 2021-01-24 | Blaine | Oklahoma | 40011 | 835 | 5 |
961616 | 961616 | 2021-01-24 | Bryan | Oklahoma | 40013 | 5099 | 44 |
961617 | 961617 | 2021-01-24 | Caddo | Oklahoma | 40015 | 3438 | 46 |
961618 | 961618 | 2021-01-24 | Canadian | Oklahoma | 40017 | 13840 | 61 |
961619 | 961619 | 2021-01-24 | Carter | Oklahoma | 40019 | 4740 | 23 |
961620 | 961620 | 2021-01-24 | Cherokee | Oklahoma | 40021 | 4874 | 29 |
961621 | 961621 | 2021-01-24 | Choctaw | Oklahoma | 40023 | 1389 | 11 |
961622 | 961622 | 2021-01-24 | Cimarron | Oklahoma | 40025 | 116 | 1 |
961623 | 961623 | 2021-01-24 | Cleveland | Oklahoma | 40027 | 25182 | 199 |
961624 | 961624 | 2021-01-24 | Coal | Oklahoma | 40029 | 613 | 8 |
961625 | 961625 | 2021-01-24 | Comanche | Oklahoma | 40031 | 9431 | 99 |
961626 | 961626 | 2021-01-24 | Cotton | Oklahoma | 40033 | 564 | 13 |
961627 | 961627 | 2021-01-24 | Craig | Oklahoma | 40035 | 1763 | 8 |
961628 | 961628 | 2021-01-24 | Creek | Oklahoma | 40037 | 5485 | 84 |
961629 | 961629 | 2021-01-24 | Custer | Oklahoma | 40039 | 3635 | 53 |
961630 | 961630 | 2021-01-24 | Delaware | Oklahoma | 40041 | 3936 | 54 |
961631 | 961631 | 2021-01-24 | Dewey | Oklahoma | 40043 | 490 | 4 |
961632 | 961632 | 2021-01-24 | Ellis | Oklahoma | 40045 | 332 | 1 |
961633 | 961633 | 2021-01-24 | Garfield | Oklahoma | 40047 | 6614 | 57 |
961634 | 961634 | 2021-01-24 | Garvin | Oklahoma | 40049 | 3098 | 25 |
961635 | 961635 | 2021-01-24 | Grady | Oklahoma | 40051 | 5044 | 55 |
961636 | 961636 | 2021-01-24 | Grant | Oklahoma | 40053 | 478 | 5 |
961637 | 961637 | 2021-01-24 | Greer | Oklahoma | 40055 | 451 | 11 |
961638 | 961638 | 2021-01-24 | Harmon | Oklahoma | 40057 | 252 | 1 |
961639 | 961639 | 2021-01-24 | Harper | Oklahoma | 40059 | 384 | 3 |
961640 | 961640 | 2021-01-24 | Haskell | Oklahoma | 40061 | 1107 | 8 |
961641 | 961641 | 2021-01-24 | Hughes | Oklahoma | 40063 | 1028 | 13 |
961642 | 961642 | 2021-01-24 | Jackson | Oklahoma | 40065 | 2664 | 40 |
961643 | 961643 | 2021-01-24 | Jefferson | Oklahoma | 40067 | 611 | 7 |
961644 | 961644 | 2021-01-24 | Johnston | Oklahoma | 40069 | 1140 | 13 |
961645 | 961645 | 2021-01-24 | Kay | Oklahoma | 40071 | 4559 | 54 |
961646 | 961646 | 2021-01-24 | Kingfisher | Oklahoma | 40073 | 1791 | 18 |
961647 | 961647 | 2021-01-24 | Kiowa | Oklahoma | 40075 | 703 | 13 |
961648 | 961648 | 2021-01-24 | Latimer | Oklahoma | 40077 | 703 | 7 |
961649 | 961649 | 2021-01-24 | Le Flore | Oklahoma | 40079 | 4632 | 37 |
961650 | 961650 | 2021-01-24 | Lincoln | Oklahoma | 40081 | 2706 | 39 |
961651 | 961651 | 2021-01-24 | Logan | Oklahoma | 40083 | 3473 | 22 |
961652 | 961652 | 2021-01-24 | Love | Oklahoma | 40085 | 1295 | 8 |
961653 | 961653 | 2021-01-24 | Major | Oklahoma | 40093 | 850 | 4 |
961654 | 961654 | 2021-01-24 | Marshall | Oklahoma | 40095 | 1612 | 11 |
961655 | 961655 | 2021-01-24 | Mayes | Oklahoma | 40097 | 3415 | 31 |
961656 | 961656 | 2021-01-24 | McClain | Oklahoma | 40087 | 4497 | 36 |
961657 | 961657 | 2021-01-24 | McCurtain | Oklahoma | 40089 | 3354 | 57 |
961658 | 961658 | 2021-01-24 | McIntosh | Oklahoma | 40091 | 1706 | 27 |
961659 | 961659 | 2021-01-24 | Murray | Oklahoma | 40099 | 1645 | 16 |
961660 | 961660 | 2021-01-24 | Muskogee | Oklahoma | 40101 | 8140 | 66 |
961661 | 961661 | 2021-01-24 | Noble | Oklahoma | 40103 | 1200 | 8 |
961662 | 961662 | 2021-01-24 | Nowata | Oklahoma | 40105 | 954 | 12 |
961663 | 961663 | 2021-01-24 | Okfuskee | Oklahoma | 40107 | 1637 | 16 |
961664 | 961664 | 2021-01-24 | Oklahoma | Oklahoma | 40109 | 72550 | 539 |
961665 | 961665 | 2021-01-24 | Okmulgee | Oklahoma | 40111 | 3212 | 37 |
961666 | 961666 | 2021-01-24 | Osage | Oklahoma | 40113 | 3897 | 38 |
961667 | 961667 | 2021-01-24 | Ottawa | Oklahoma | 40115 | 3332 | 34 |
961668 | 961668 | 2021-01-24 | Pawnee | Oklahoma | 40117 | 1414 | 19 |
961669 | 961669 | 2021-01-24 | Payne | Oklahoma | 40119 | 7520 | 39 |
961670 | 961670 | 2021-01-24 | Pittsburg | Oklahoma | 40121 | 3906 | 31 |
961671 | 961671 | 2021-01-24 | Pontotoc | Oklahoma | 40123 | 4196 | 36 |
961672 | 961672 | 2021-01-24 | Pottawatomie | Oklahoma | 40125 | 6941 | 48 |
961673 | 961673 | 2021-01-24 | Pushmataha | Oklahoma | 40127 | 863 | 8 |
961674 | 961674 | 2021-01-24 | Roger Mills | Oklahoma | 40129 | 359 | 6 |
961675 | 961675 | 2021-01-24 | Rogers | Oklahoma | 40131 | 8637 | 94 |
961676 | 961676 | 2021-01-24 | Seminole | Oklahoma | 40133 | 2414 | 25 |
961677 | 961677 | 2021-01-24 | Sequoyah | Oklahoma | 40135 | 3399 | 24 |
961678 | 961678 | 2021-01-24 | Stephens | Oklahoma | 40137 | 4104 | 43 |
961679 | 961679 | 2021-01-24 | Texas | Oklahoma | 40139 | 3278 | 20 |
961680 | 961680 | 2021-01-24 | Tillman | Oklahoma | 40141 | 674 | 13 |
961681 | 961681 | 2021-01-24 | Tulsa | Oklahoma | 40143 | 61145 | 541 |
961682 | 961682 | 2021-01-24 | Unknown | Oklahoma | 89 | 0 | |
961683 | 961683 | 2021-01-24 | Wagoner | Oklahoma | 40145 | 6541 | 65 |
961684 | 961684 | 2021-01-24 | Washington | Oklahoma | 40147 | 4011 | 70 |
961685 | 961685 | 2021-01-24 | Washita | Oklahoma | 40149 | 963 | 6 |
961686 | 961686 | 2021-01-24 | Woods | Oklahoma | 40151 | 1127 | 5 |
961687 | 961687 | 2021-01-24 | Woodward | Oklahoma | 40153 | 2905 | 12 |
958365 | 958365 | 2021-01-23 | Adair | Oklahoma | 40001 | 2651 | 18 |
958366 | 958366 | 2021-01-23 | Alfalfa | Oklahoma | 40003 | 1054 | 5 |
958367 | 958367 | 2021-01-23 | Atoka | Oklahoma | 40005 | 1598 | 8 |
958368 | 958368 | 2021-01-23 | Beaver | Oklahoma | 40007 | 357 | 4 |
958369 | 958369 | 2021-01-23 | Beckham | Oklahoma | 40009 | 2386 | 28 |
958370 | 958370 | 2021-01-23 | Blaine | Oklahoma | 40011 | 823 | 5 |
958371 | 958371 | 2021-01-23 | Bryan | Oklahoma | 40013 | 5051 | 44 |
958372 | 958372 | 2021-01-23 | Caddo | Oklahoma | 40015 | 3418 | 46 |
958373 | 958373 | 2021-01-23 | Canadian | Oklahoma | 40017 | 13725 | 61 |
958374 | 958374 | 2021-01-23 | Carter | Oklahoma | 40019 | 4672 | 22 |
958375 | 958375 | 2021-01-23 | Cherokee | Oklahoma | 40021 | 4857 | 28 |
958376 | 958376 | 2021-01-23 | Choctaw | Oklahoma | 40023 | 1384 | 11 |
958377 | 958377 | 2021-01-23 | Cimarron | Oklahoma | 40025 | 116 | 1 |
958378 | 958378 | 2021-01-23 | Cleveland | Oklahoma | 40027 | 24919 | 197 |
958379 | 958379 | 2021-01-23 | Coal | Oklahoma | 40029 | 603 | 8 |
958380 | 958380 | 2021-01-23 | Comanche | Oklahoma | 40031 | 9322 | 96 |
958381 | 958381 | 2021-01-23 | Cotton | Oklahoma | 40033 | 562 | 13 |
958382 | 958382 | 2021-01-23 | Craig | Oklahoma | 40035 | 1755 | 8 |
958383 | 958383 | 2021-01-23 | Creek | Oklahoma | 40037 | 5432 | 83 |
958384 | 958384 | 2021-01-23 | Custer | Oklahoma | 40039 | 3623 | 50 |
958385 | 958385 | 2021-01-23 | Delaware | Oklahoma | 40041 | 3905 | 53 |
958386 | 958386 | 2021-01-23 | Dewey | Oklahoma | 40043 | 490 | 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]);