ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59,923 rows where state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 586
- 40109 579
- 40065 578
- 40071 577
- 40119 577
- 40027 576
- 40017 575
- 40117 575
- 40051 573
- 40083 573
- 40087 573
- 40147 573
- 40039 572
- 40049 572
- 40101 570
- 40103 570
- 40123 569
- 40097 568
- 40145 568
- 40113 567
- 40125 567
- 40137 567
- 40001 566
- 40013 566
- 40019 566
- 40037 566
- 40041 566
- 40081 566
- 40111 566
- 40115 566
- …
county >30
- Tulsa 586
- Oklahoma 579
- Jackson 578
- Kay 577
- Payne 577
- Cleveland 576
- Canadian 575
- Pawnee 575
- Grady 573
- Logan 573
- McClain 573
- Washington 573
- Custer 572
- Garvin 572
- Muskogee 570
- Noble 570
- Pontotoc 569
- Mayes 568
- Wagoner 568
- Osage 567
- Pottawatomie 567
- Stephens 567
- Adair 566
- Bryan 566
- Carter 566
- Creek 566
- Delaware 566
- Lincoln 566
- Okmulgee 566
- Ottawa 566
- …
state 1
- Oklahoma · 43,287 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1809041 | 1809041 | 2021-10-12 | Ellis | Oklahoma | 40045 | 419 | 6 |
1809042 | 1809042 | 2021-10-12 | Garfield | Oklahoma | 40047 | 9672 | 153 |
1809043 | 1809043 | 2021-10-12 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1809044 | 1809044 | 2021-10-12 | Grady | Oklahoma | 40051 | 7808 | 153 |
1809045 | 1809045 | 2021-10-12 | Grant | Oklahoma | 40053 | 686 | 7 |
1809046 | 1809046 | 2021-10-12 | Greer | Oklahoma | 40055 | 732 | 23 |
1809047 | 1809047 | 2021-10-12 | Harmon | Oklahoma | 40057 | 357 | 6 |
1809048 | 1809048 | 2021-10-12 | Harper | Oklahoma | 40059 | 475 | 8 |
1809049 | 1809049 | 2021-10-12 | Haskell | Oklahoma | 40061 | 1812 | 25 |
1809050 | 1809050 | 2021-10-12 | Hughes | Oklahoma | 40063 | 1625 | 37 |
1809051 | 1809051 | 2021-10-12 | Jackson | Oklahoma | 40065 | 3749 | 65 |
1809052 | 1809052 | 2021-10-12 | Jefferson | Oklahoma | 40067 | 908 | 18 |
1809053 | 1809053 | 2021-10-12 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1809054 | 1809054 | 2021-10-12 | Kay | Oklahoma | 40071 | 6939 | 148 |
1809055 | 1809055 | 2021-10-12 | Kingfisher | Oklahoma | 40073 | 2525 | 44 |
1809056 | 1809056 | 2021-10-12 | Kiowa | Oklahoma | 40075 | 1090 | 29 |
1809057 | 1809057 | 2021-10-12 | Latimer | Oklahoma | 40077 | 1438 | 14 |
1809058 | 1809058 | 2021-10-12 | Le Flore | Oklahoma | 40079 | 7801 | 76 |
1809059 | 1809059 | 2021-10-12 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1809060 | 1809060 | 2021-10-12 | Logan | Oklahoma | 40083 | 5898 | 97 |
1809061 | 1809061 | 2021-10-12 | Love | Oklahoma | 40085 | 1949 | 26 |
1809062 | 1809062 | 2021-10-12 | Major | Oklahoma | 40093 | 1192 | 27 |
1809063 | 1809063 | 2021-10-12 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1809064 | 1809064 | 2021-10-12 | Mayes | Oklahoma | 40097 | 6527 | 101 |
1809065 | 1809065 | 2021-10-12 | McClain | Oklahoma | 40087 | 7242 | 91 |
1809066 | 1809066 | 2021-10-12 | McCurtain | Oklahoma | 40089 | 5526 | 111 |
1809067 | 1809067 | 2021-10-12 | McIntosh | Oklahoma | 40091 | 2804 | 79 |
1809068 | 1809068 | 2021-10-12 | Murray | Oklahoma | 40099 | 2544 | 51 |
1809069 | 1809069 | 2021-10-12 | Muskogee | Oklahoma | 40101 | 12985 | 239 |
1809070 | 1809070 | 2021-10-12 | Noble | Oklahoma | 40103 | 1834 | 28 |
1809071 | 1809071 | 2021-10-12 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1809072 | 1809072 | 2021-10-12 | Okfuskee | Oklahoma | 40107 | 2242 | 34 |
1809073 | 1809073 | 2021-10-12 | Oklahoma | Oklahoma | 40109 | 115750 | 1544 |
1809074 | 1809074 | 2021-10-12 | Okmulgee | Oklahoma | 40111 | 5660 | 116 |
1809075 | 1809075 | 2021-10-12 | Osage | Oklahoma | 40113 | 6677 | 115 |
1809076 | 1809076 | 2021-10-12 | Ottawa | Oklahoma | 40115 | 5913 | 87 |
1809077 | 1809077 | 2021-10-12 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1809078 | 1809078 | 2021-10-12 | Payne | Oklahoma | 40119 | 11677 | 97 |
1809079 | 1809079 | 2021-10-12 | Pittsburg | Oklahoma | 40121 | 6505 | 104 |
1809080 | 1809080 | 2021-10-12 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1809081 | 1809081 | 2021-10-12 | Pottawatomie | Oklahoma | 40125 | 11203 | 170 |
1809082 | 1809082 | 2021-10-12 | Pushmataha | Oklahoma | 40127 | 1717 | 34 |
1809083 | 1809083 | 2021-10-12 | Roger Mills | Oklahoma | 40129 | 476 | 12 |
1809084 | 1809084 | 2021-10-12 | Rogers | Oklahoma | 40131 | 15287 | 255 |
1809085 | 1809085 | 2021-10-12 | Seminole | Oklahoma | 40133 | 3681 | 91 |
1809086 | 1809086 | 2021-10-12 | Sequoyah | Oklahoma | 40135 | 6563 | 76 |
1809087 | 1809087 | 2021-10-12 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1809088 | 1809088 | 2021-10-12 | Texas | Oklahoma | 40139 | 3933 | 37 |
1809089 | 1809089 | 2021-10-12 | Tillman | Oklahoma | 40141 | 956 | 20 |
1809090 | 1809090 | 2021-10-12 | Tulsa | Oklahoma | 40143 | 104222 | 1482 |
1809091 | 1809091 | 2021-10-12 | Unknown | Oklahoma | 9505 | 0 | |
1809092 | 1809092 | 2021-10-12 | Wagoner | Oklahoma | 40145 | 12263 | 187 |
1809093 | 1809093 | 2021-10-12 | Washington | Oklahoma | 40147 | 8219 | 179 |
1809094 | 1809094 | 2021-10-12 | Washita | Oklahoma | 40149 | 1432 | 25 |
1809095 | 1809095 | 2021-10-12 | Woods | Oklahoma | 40151 | 1577 | 22 |
1809096 | 1809096 | 2021-10-12 | Woodward | Oklahoma | 40153 | 3615 | 40 |
1805769 | 1805769 | 2021-10-11 | Adair | Oklahoma | 40001 | 4783 | 56 |
1805770 | 1805770 | 2021-10-11 | Alfalfa | Oklahoma | 40003 | 1272 | 7 |
1805771 | 1805771 | 2021-10-11 | Atoka | Oklahoma | 40005 | 2655 | 30 |
1805772 | 1805772 | 2021-10-11 | Beaver | Oklahoma | 40007 | 539 | 6 |
1805773 | 1805773 | 2021-10-11 | Beckham | Oklahoma | 40009 | 3302 | 62 |
1805774 | 1805774 | 2021-10-11 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1805775 | 1805775 | 2021-10-11 | Bryan | Oklahoma | 40013 | 8379 | 100 |
1805776 | 1805776 | 2021-10-11 | Caddo | Oklahoma | 40015 | 5039 | 106 |
1805777 | 1805777 | 2021-10-11 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1805778 | 1805778 | 2021-10-11 | Carter | Oklahoma | 40019 | 8683 | 156 |
1805779 | 1805779 | 2021-10-11 | Cherokee | Oklahoma | 40021 | 8816 | 100 |
1805780 | 1805780 | 2021-10-11 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1805781 | 1805781 | 2021-10-11 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1805782 | 1805782 | 2021-10-11 | Cleveland | Oklahoma | 40027 | 41981 | 527 |
1805783 | 1805783 | 2021-10-11 | Coal | Oklahoma | 40029 | 1006 | 19 |
1805784 | 1805784 | 2021-10-11 | Comanche | Oklahoma | 40031 | 20556 | 258 |
1805785 | 1805785 | 2021-10-11 | Cotton | Oklahoma | 40033 | 935 | 20 |
1805786 | 1805786 | 2021-10-11 | Craig | Oklahoma | 40035 | 2916 | 29 |
1805787 | 1805787 | 2021-10-11 | Creek | Oklahoma | 40037 | 10677 | 227 |
1805788 | 1805788 | 2021-10-11 | Custer | Oklahoma | 40039 | 4820 | 112 |
1805789 | 1805789 | 2021-10-11 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1805790 | 1805790 | 2021-10-11 | Dewey | Oklahoma | 40043 | 652 | 16 |
1805791 | 1805791 | 2021-10-11 | Ellis | Oklahoma | 40045 | 419 | 6 |
1805792 | 1805792 | 2021-10-11 | Garfield | Oklahoma | 40047 | 9672 | 153 |
1805793 | 1805793 | 2021-10-11 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1805794 | 1805794 | 2021-10-11 | Grady | Oklahoma | 40051 | 7808 | 153 |
1805795 | 1805795 | 2021-10-11 | Grant | Oklahoma | 40053 | 686 | 7 |
1805796 | 1805796 | 2021-10-11 | Greer | Oklahoma | 40055 | 732 | 23 |
1805797 | 1805797 | 2021-10-11 | Harmon | Oklahoma | 40057 | 357 | 6 |
1805798 | 1805798 | 2021-10-11 | Harper | Oklahoma | 40059 | 475 | 8 |
1805799 | 1805799 | 2021-10-11 | Haskell | Oklahoma | 40061 | 1812 | 25 |
1805800 | 1805800 | 2021-10-11 | Hughes | Oklahoma | 40063 | 1625 | 37 |
1805801 | 1805801 | 2021-10-11 | Jackson | Oklahoma | 40065 | 3749 | 65 |
1805802 | 1805802 | 2021-10-11 | Jefferson | Oklahoma | 40067 | 908 | 18 |
1805803 | 1805803 | 2021-10-11 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1805804 | 1805804 | 2021-10-11 | Kay | Oklahoma | 40071 | 6939 | 148 |
1805805 | 1805805 | 2021-10-11 | Kingfisher | Oklahoma | 40073 | 2525 | 44 |
1805806 | 1805806 | 2021-10-11 | Kiowa | Oklahoma | 40075 | 1090 | 29 |
1805807 | 1805807 | 2021-10-11 | Latimer | Oklahoma | 40077 | 1438 | 14 |
1805808 | 1805808 | 2021-10-11 | Le Flore | Oklahoma | 40079 | 7801 | 76 |
1805809 | 1805809 | 2021-10-11 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1805810 | 1805810 | 2021-10-11 | Logan | Oklahoma | 40083 | 5898 | 97 |
1805811 | 1805811 | 2021-10-11 | Love | Oklahoma | 40085 | 1949 | 26 |
1805812 | 1805812 | 2021-10-11 | Major | Oklahoma | 40093 | 1192 | 27 |
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);