ny_times_us_counties

Table actions
⚠️ 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

22,952 rows where state = "Oklahoma" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

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

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
);
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]);