ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2022-02-27 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2257646 | 2257646 | 2022-02-27 | Adair | Oklahoma | 40001 | 7767 | 68 |
2257647 | 2257647 | 2022-02-27 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2257648 | 2257648 | 2022-02-27 | Atoka | Oklahoma | 40005 | 3786 | 45 |
2257649 | 2257649 | 2022-02-27 | Beaver | Oklahoma | 40007 | 946 | 10 |
2257650 | 2257650 | 2022-02-27 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2257651 | 2257651 | 2022-02-27 | Blaine | Oklahoma | 40011 | 2397 | 36 |
2257652 | 2257652 | 2022-02-27 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2257653 | 2257653 | 2022-02-27 | Caddo | Oklahoma | 40015 | 8159 | 153 |
2257654 | 2257654 | 2022-02-27 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2257655 | 2257655 | 2022-02-27 | Carter | Oklahoma | 40019 | 13531 | 213 |
2257656 | 2257656 | 2022-02-27 | Cherokee | Oklahoma | 40021 | 14378 | 136 |
2257657 | 2257657 | 2022-02-27 | Choctaw | Oklahoma | 40023 | 4036 | 56 |
2257658 | 2257658 | 2022-02-27 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2257659 | 2257659 | 2022-02-27 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2257660 | 2257660 | 2022-02-27 | Coal | Oklahoma | 40029 | 1637 | 20 |
2257661 | 2257661 | 2022-02-27 | Comanche | Oklahoma | 40031 | 31209 | 361 |
2257662 | 2257662 | 2022-02-27 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2257663 | 2257663 | 2022-02-27 | Craig | Oklahoma | 40035 | 4653 | 46 |
2257664 | 2257664 | 2022-02-27 | Creek | Oklahoma | 40037 | 17986 | 306 |
2257665 | 2257665 | 2022-02-27 | Custer | Oklahoma | 40039 | 7691 | 157 |
2257666 | 2257666 | 2022-02-27 | Delaware | Oklahoma | 40041 | 10940 | 190 |
2257667 | 2257667 | 2022-02-27 | Dewey | Oklahoma | 40043 | 1055 | 28 |
2257668 | 2257668 | 2022-02-27 | Ellis | Oklahoma | 40045 | 761 | 7 |
2257669 | 2257669 | 2022-02-27 | Garfield | Oklahoma | 40047 | 14952 | 259 |
2257670 | 2257670 | 2022-02-27 | Garvin | Oklahoma | 40049 | 6941 | 129 |
2257671 | 2257671 | 2022-02-27 | Grady | Oklahoma | 40051 | 13540 | 229 |
2257672 | 2257672 | 2022-02-27 | Grant | Oklahoma | 40053 | 1021 | 14 |
2257673 | 2257673 | 2022-02-27 | Greer | Oklahoma | 40055 | 1271 | 30 |
2257674 | 2257674 | 2022-02-27 | Harmon | Oklahoma | 40057 | 514 | 11 |
2257675 | 2257675 | 2022-02-27 | Harper | Oklahoma | 40059 | 700 | 12 |
2257676 | 2257676 | 2022-02-27 | Haskell | Oklahoma | 40061 | 2760 | 36 |
2257677 | 2257677 | 2022-02-27 | Hughes | Oklahoma | 40063 | 2532 | 56 |
2257678 | 2257678 | 2022-02-27 | Jackson | Oklahoma | 40065 | 6509 | 96 |
2257679 | 2257679 | 2022-02-27 | Jefferson | Oklahoma | 40067 | 1278 | 23 |
2257680 | 2257680 | 2022-02-27 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2257681 | 2257681 | 2022-02-27 | Kay | Oklahoma | 40071 | 11999 | 203 |
2257682 | 2257682 | 2022-02-27 | Kingfisher | Oklahoma | 40073 | 4015 | 59 |
2257683 | 2257683 | 2022-02-27 | Kiowa | Oklahoma | 40075 | 1940 | 50 |
2257684 | 2257684 | 2022-02-27 | Latimer | Oklahoma | 40077 | 2266 | 32 |
2257685 | 2257685 | 2022-02-27 | Le Flore | Oklahoma | 40079 | 12267 | 101 |
2257686 | 2257686 | 2022-02-27 | Lincoln | Oklahoma | 40081 | 7710 | 124 |
2257687 | 2257687 | 2022-02-27 | Logan | Oklahoma | 40083 | 10584 | 149 |
2257688 | 2257688 | 2022-02-27 | Love | Oklahoma | 40085 | 2992 | 36 |
2257689 | 2257689 | 2022-02-27 | Major | Oklahoma | 40093 | 2429 | 36 |
2257690 | 2257690 | 2022-02-27 | Marshall | Oklahoma | 40095 | 4507 | 38 |
2257691 | 2257691 | 2022-02-27 | Mayes | Oklahoma | 40097 | 10157 | 148 |
2257692 | 2257692 | 2022-02-27 | McClain | Oklahoma | 40087 | 11474 | 122 |
2257693 | 2257693 | 2022-02-27 | McCurtain | Oklahoma | 40089 | 7967 | 152 |
2257694 | 2257694 | 2022-02-27 | McIntosh | Oklahoma | 40091 | 4865 | 114 |
2257695 | 2257695 | 2022-02-27 | Murray | Oklahoma | 40099 | 4137 | 65 |
2257696 | 2257696 | 2022-02-27 | Muskogee | Oklahoma | 40101 | 19763 | 312 |
2257697 | 2257697 | 2022-02-27 | Noble | Oklahoma | 40103 | 2991 | 36 |
2257698 | 2257698 | 2022-02-27 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2257699 | 2257699 | 2022-02-27 | Okfuskee | Oklahoma | 40107 | 3498 | 55 |
2257700 | 2257700 | 2022-02-27 | Oklahoma | Oklahoma | 40109 | 192433 | 2230 |
2257701 | 2257701 | 2022-02-27 | Okmulgee | Oklahoma | 40111 | 9608 | 170 |
2257702 | 2257702 | 2022-02-27 | Osage | Oklahoma | 40113 | 10799 | 155 |
2257703 | 2257703 | 2022-02-27 | Ottawa | Oklahoma | 40115 | 9025 | 115 |
2257704 | 2257704 | 2022-02-27 | Pawnee | Oklahoma | 40117 | 4063 | 79 |
2257705 | 2257705 | 2022-02-27 | Payne | Oklahoma | 40119 | 18044 | 147 |
2257706 | 2257706 | 2022-02-27 | Pittsburg | Oklahoma | 40121 | 10693 | 193 |
2257707 | 2257707 | 2022-02-27 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2257708 | 2257708 | 2022-02-27 | Pottawatomie | Oklahoma | 40125 | 20289 | 257 |
2257709 | 2257709 | 2022-02-27 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2257710 | 2257710 | 2022-02-27 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2257711 | 2257711 | 2022-02-27 | Rogers | Oklahoma | 40131 | 25091 | 354 |
2257712 | 2257712 | 2022-02-27 | Seminole | Oklahoma | 40133 | 6031 | 122 |
2257713 | 2257713 | 2022-02-27 | Sequoyah | Oklahoma | 40135 | 10492 | 97 |
2257714 | 2257714 | 2022-02-27 | Stephens | Oklahoma | 40137 | 10588 | 185 |
2257715 | 2257715 | 2022-02-27 | Texas | Oklahoma | 40139 | 5944 | 52 |
2257716 | 2257716 | 2022-02-27 | Tillman | Oklahoma | 40141 | 1502 | 30 |
2257717 | 2257717 | 2022-02-27 | Tulsa | Oklahoma | 40143 | 167771 | 1979 |
2257718 | 2257718 | 2022-02-27 | Unknown | Oklahoma | 4105 | 0 | |
2257719 | 2257719 | 2022-02-27 | Wagoner | Oklahoma | 40145 | 21406 | 250 |
2257720 | 2257720 | 2022-02-27 | Washington | Oklahoma | 40147 | 12553 | 236 |
2257721 | 2257721 | 2022-02-27 | Washita | Oklahoma | 40149 | 2591 | 45 |
2257722 | 2257722 | 2022-02-27 | Woods | Oklahoma | 40151 | 2334 | 33 |
2257723 | 2257723 | 2022-02-27 | Woodward | Oklahoma | 40153 | 5128 | 69 |
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);