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 423
- 40109 416
- 40065 415
- 40027 414
- 40071 414
- 40119 414
- 40017 413
- 40117 412
- 40039 410
- 40051 410
- 40083 410
- 40087 410
- 40147 410
- 40049 409
- 40101 407
- 40103 407
- 40123 406
- 40097 405
- 40145 405
- 40001 404
- 40013 404
- 40019 404
- 40037 404
- 40041 404
- 40113 404
- 40125 404
- 40137 404
- 40031 403
- 40035 403
- 40081 403
- …
county >30
- Tulsa 423
- Oklahoma 416
- Jackson 415
- Cleveland 414
- Kay 414
- Payne 414
- Canadian 413
- Pawnee 412
- Custer 410
- Grady 410
- Logan 410
- McClain 410
- Washington 410
- Garvin 409
- Muskogee 407
- Noble 407
- Pontotoc 406
- Mayes 405
- Wagoner 405
- Adair 404
- Bryan 404
- Carter 404
- Creek 404
- Delaware 404
- Osage 404
- Pottawatomie 404
- Stephens 404
- Comanche 403
- Craig 403
- Lincoln 403
- …
state 1
- Oklahoma · 30,595 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279693 | 1279693 | 2021-05-02 | Adair | Oklahoma | 40001 | 3170 | 41 |
1279694 | 1279694 | 2021-05-02 | Alfalfa | Oklahoma | 40003 | 1156 | 7 |
1279695 | 1279695 | 2021-05-02 | Atoka | Oklahoma | 40005 | 1868 | 25 |
1279696 | 1279696 | 2021-05-02 | Beaver | Oklahoma | 40007 | 474 | 6 |
1279697 | 1279697 | 2021-05-02 | Beckham | Oklahoma | 40009 | 2892 | 54 |
1279698 | 1279698 | 2021-05-02 | Blaine | Oklahoma | 40011 | 1040 | 18 |
1279699 | 1279699 | 2021-05-02 | Bryan | Oklahoma | 40013 | 6086 | 71 |
1279700 | 1279700 | 2021-05-02 | Caddo | Oklahoma | 40015 | 3963 | 87 |
1279701 | 1279701 | 2021-05-02 | Canadian | Oklahoma | 40017 | 17046 | 168 |
1279702 | 1279702 | 2021-05-02 | Carter | Oklahoma | 40019 | 6091 | 108 |
1279703 | 1279703 | 2021-05-02 | Cherokee | Oklahoma | 40021 | 5609 | 74 |
1279704 | 1279704 | 2021-05-02 | Choctaw | Oklahoma | 40023 | 1611 | 21 |
1279705 | 1279705 | 2021-05-02 | Cimarron | Oklahoma | 40025 | 214 | 1 |
1279706 | 1279706 | 2021-05-02 | Cleveland | Oklahoma | 40027 | 30818 | 401 |
1279707 | 1279707 | 2021-05-02 | Coal | Oklahoma | 40029 | 696 | 15 |
1279708 | 1279708 | 2021-05-02 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1279709 | 1279709 | 2021-05-02 | Cotton | Oklahoma | 40033 | 679 | 16 |
1279710 | 1279710 | 2021-05-02 | Craig | Oklahoma | 40035 | 1966 | 18 |
1279711 | 1279711 | 2021-05-02 | Creek | Oklahoma | 40037 | 6891 | 154 |
1279712 | 1279712 | 2021-05-02 | Custer | Oklahoma | 40039 | 4066 | 99 |
1279713 | 1279713 | 2021-05-02 | Delaware | Oklahoma | 40041 | 4594 | 90 |
1279714 | 1279714 | 2021-05-02 | Dewey | Oklahoma | 40043 | 548 | 14 |
1279715 | 1279715 | 2021-05-02 | Ellis | Oklahoma | 40045 | 354 | 5 |
1279716 | 1279716 | 2021-05-02 | Garfield | Oklahoma | 40047 | 7782 | 128 |
1279717 | 1279717 | 2021-05-02 | Garvin | Oklahoma | 40049 | 3602 | 77 |
1279718 | 1279718 | 2021-05-02 | Grady | Oklahoma | 40051 | 5919 | 121 |
1279719 | 1279719 | 2021-05-02 | Grant | Oklahoma | 40053 | 549 | 7 |
1279720 | 1279720 | 2021-05-02 | Greer | Oklahoma | 40055 | 581 | 21 |
1279721 | 1279721 | 2021-05-02 | Harmon | Oklahoma | 40057 | 324 | 4 |
1279722 | 1279722 | 2021-05-02 | Harper | Oklahoma | 40059 | 420 | 6 |
1279723 | 1279723 | 2021-05-02 | Haskell | Oklahoma | 40061 | 1250 | 16 |
1279724 | 1279724 | 2021-05-02 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1279725 | 1279725 | 2021-05-02 | Jackson | Oklahoma | 40065 | 3108 | 56 |
1279726 | 1279726 | 2021-05-02 | Jefferson | Oklahoma | 40067 | 700 | 13 |
1279727 | 1279727 | 2021-05-02 | Johnston | Oklahoma | 40069 | 1375 | 35 |
1279728 | 1279728 | 2021-05-02 | Kay | Oklahoma | 40071 | 5305 | 126 |
1279729 | 1279729 | 2021-05-02 | Kingfisher | Oklahoma | 40073 | 2050 | 38 |
1279730 | 1279730 | 2021-05-02 | Kiowa | Oklahoma | 40075 | 810 | 24 |
1279731 | 1279731 | 2021-05-02 | Latimer | Oklahoma | 40077 | 835 | 13 |
1279732 | 1279732 | 2021-05-02 | Le Flore | Oklahoma | 40079 | 5557 | 64 |
1279733 | 1279733 | 2021-05-02 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1279734 | 1279734 | 2021-05-02 | Logan | Oklahoma | 40083 | 4216 | 56 |
1279735 | 1279735 | 2021-05-02 | Love | Oklahoma | 40085 | 1492 | 20 |
1279736 | 1279736 | 2021-05-02 | Major | Oklahoma | 40093 | 954 | 21 |
1279737 | 1279737 | 2021-05-02 | Marshall | Oklahoma | 40095 | 2044 | 23 |
1279738 | 1279738 | 2021-05-02 | Mayes | Oklahoma | 40097 | 4175 | 68 |
1279739 | 1279739 | 2021-05-02 | McClain | Oklahoma | 40087 | 5273 | 69 |
1279740 | 1279740 | 2021-05-02 | McCurtain | Oklahoma | 40089 | 3928 | 88 |
1279741 | 1279741 | 2021-05-02 | McIntosh | Oklahoma | 40091 | 1997 | 58 |
1279742 | 1279742 | 2021-05-02 | Murray | Oklahoma | 40099 | 2014 | 38 |
1279743 | 1279743 | 2021-05-02 | Muskogee | Oklahoma | 40101 | 9306 | 164 |
1279744 | 1279744 | 2021-05-02 | Noble | Oklahoma | 40103 | 1377 | 19 |
1279745 | 1279745 | 2021-05-02 | Nowata | Oklahoma | 40105 | 1144 | 18 |
1279746 | 1279746 | 2021-05-02 | Okfuskee | Oklahoma | 40107 | 1781 | 30 |
1279747 | 1279747 | 2021-05-02 | Oklahoma | Oklahoma | 40109 | 86030 | 1194 |
1279748 | 1279748 | 2021-05-02 | Okmulgee | Oklahoma | 40111 | 3724 | 77 |
1279749 | 1279749 | 2021-05-02 | Osage | Oklahoma | 40113 | 4681 | 73 |
1279750 | 1279750 | 2021-05-02 | Ottawa | Oklahoma | 40115 | 3881 | 64 |
1279751 | 1279751 | 2021-05-02 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1279752 | 1279752 | 2021-05-02 | Payne | Oklahoma | 40119 | 8653 | 71 |
1279753 | 1279753 | 2021-05-02 | Pittsburg | Oklahoma | 40121 | 4621 | 68 |
1279754 | 1279754 | 2021-05-02 | Pontotoc | Oklahoma | 40123 | 5105 | 72 |
1279755 | 1279755 | 2021-05-02 | Pottawatomie | Oklahoma | 40125 | 8319 | 125 |
1279756 | 1279756 | 2021-05-02 | Pushmataha | Oklahoma | 40127 | 1012 | 20 |
1279757 | 1279757 | 2021-05-02 | Roger Mills | Oklahoma | 40129 | 391 | 12 |
1279758 | 1279758 | 2021-05-02 | Rogers | Oklahoma | 40131 | 10426 | 174 |
1279759 | 1279759 | 2021-05-02 | Seminole | Oklahoma | 40133 | 2861 | 69 |
1279760 | 1279760 | 2021-05-02 | Sequoyah | Oklahoma | 40135 | 4098 | 50 |
1279761 | 1279761 | 2021-05-02 | Stephens | Oklahoma | 40137 | 4828 | 101 |
1279762 | 1279762 | 2021-05-02 | Texas | Oklahoma | 40139 | 3506 | 32 |
1279763 | 1279763 | 2021-05-02 | Tillman | Oklahoma | 40141 | 803 | 17 |
1279764 | 1279764 | 2021-05-02 | Tulsa | Oklahoma | 40143 | 74049 | 1033 |
1279765 | 1279765 | 2021-05-02 | Unknown | Oklahoma | 1026 | 0 | |
1279766 | 1279766 | 2021-05-02 | Wagoner | Oklahoma | 40145 | 8027 | 113 |
1279767 | 1279767 | 2021-05-02 | Washington | Oklahoma | 40147 | 5183 | 108 |
1279768 | 1279768 | 2021-05-02 | Washita | Oklahoma | 40149 | 1079 | 21 |
1279769 | 1279769 | 2021-05-02 | Woods | Oklahoma | 40151 | 1204 | 17 |
1279770 | 1279770 | 2021-05-02 | Woodward | Oklahoma | 40153 | 3156 | 33 |
1276446 | 1276446 | 2021-05-01 | Adair | Oklahoma | 40001 | 3170 | 41 |
1276447 | 1276447 | 2021-05-01 | Alfalfa | Oklahoma | 40003 | 1156 | 7 |
1276448 | 1276448 | 2021-05-01 | Atoka | Oklahoma | 40005 | 1868 | 25 |
1276449 | 1276449 | 2021-05-01 | Beaver | Oklahoma | 40007 | 474 | 6 |
1276450 | 1276450 | 2021-05-01 | Beckham | Oklahoma | 40009 | 2892 | 54 |
1276451 | 1276451 | 2021-05-01 | Blaine | Oklahoma | 40011 | 1040 | 18 |
1276452 | 1276452 | 2021-05-01 | Bryan | Oklahoma | 40013 | 6086 | 71 |
1276453 | 1276453 | 2021-05-01 | Caddo | Oklahoma | 40015 | 3963 | 87 |
1276454 | 1276454 | 2021-05-01 | Canadian | Oklahoma | 40017 | 17046 | 168 |
1276455 | 1276455 | 2021-05-01 | Carter | Oklahoma | 40019 | 6091 | 108 |
1276456 | 1276456 | 2021-05-01 | Cherokee | Oklahoma | 40021 | 5609 | 74 |
1276457 | 1276457 | 2021-05-01 | Choctaw | Oklahoma | 40023 | 1611 | 21 |
1276458 | 1276458 | 2021-05-01 | Cimarron | Oklahoma | 40025 | 214 | 1 |
1276459 | 1276459 | 2021-05-01 | Cleveland | Oklahoma | 40027 | 30818 | 401 |
1276460 | 1276460 | 2021-05-01 | Coal | Oklahoma | 40029 | 696 | 15 |
1276461 | 1276461 | 2021-05-01 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1276462 | 1276462 | 2021-05-01 | Cotton | Oklahoma | 40033 | 679 | 16 |
1276463 | 1276463 | 2021-05-01 | Craig | Oklahoma | 40035 | 1966 | 18 |
1276464 | 1276464 | 2021-05-01 | Creek | Oklahoma | 40037 | 6891 | 154 |
1276465 | 1276465 | 2021-05-01 | Custer | Oklahoma | 40039 | 4066 | 99 |
1276466 | 1276466 | 2021-05-01 | Delaware | Oklahoma | 40041 | 4594 | 90 |
1276467 | 1276467 | 2021-05-01 | Dewey | Oklahoma | 40043 | 548 | 14 |
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);