ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-02-23" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2244642 | 2244642 | 2022-02-23 | Adair | Oklahoma | 40001 | 7767 | 68 |
2244643 | 2244643 | 2022-02-23 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2244644 | 2244644 | 2022-02-23 | Atoka | Oklahoma | 40005 | 3786 | 45 |
2244645 | 2244645 | 2022-02-23 | Beaver | Oklahoma | 40007 | 946 | 10 |
2244646 | 2244646 | 2022-02-23 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2244647 | 2244647 | 2022-02-23 | Blaine | Oklahoma | 40011 | 2397 | 36 |
2244648 | 2244648 | 2022-02-23 | Bryan | Oklahoma | 40013 | 13433 | 127 |
2244649 | 2244649 | 2022-02-23 | Caddo | Oklahoma | 40015 | 8159 | 153 |
2244650 | 2244650 | 2022-02-23 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2244651 | 2244651 | 2022-02-23 | Carter | Oklahoma | 40019 | 13531 | 213 |
2244652 | 2244652 | 2022-02-23 | Cherokee | Oklahoma | 40021 | 14378 | 136 |
2244653 | 2244653 | 2022-02-23 | Choctaw | Oklahoma | 40023 | 4036 | 56 |
2244654 | 2244654 | 2022-02-23 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2244655 | 2244655 | 2022-02-23 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2244656 | 2244656 | 2022-02-23 | Coal | Oklahoma | 40029 | 1637 | 20 |
2244657 | 2244657 | 2022-02-23 | Comanche | Oklahoma | 40031 | 31209 | 361 |
2244658 | 2244658 | 2022-02-23 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2244659 | 2244659 | 2022-02-23 | Craig | Oklahoma | 40035 | 4653 | 46 |
2244660 | 2244660 | 2022-02-23 | Creek | Oklahoma | 40037 | 17986 | 306 |
2244661 | 2244661 | 2022-02-23 | Custer | Oklahoma | 40039 | 7691 | 157 |
2244662 | 2244662 | 2022-02-23 | Delaware | Oklahoma | 40041 | 10940 | 190 |
2244663 | 2244663 | 2022-02-23 | Dewey | Oklahoma | 40043 | 1055 | 28 |
2244664 | 2244664 | 2022-02-23 | Ellis | Oklahoma | 40045 | 761 | 7 |
2244665 | 2244665 | 2022-02-23 | Garfield | Oklahoma | 40047 | 14952 | 259 |
2244666 | 2244666 | 2022-02-23 | Garvin | Oklahoma | 40049 | 6941 | 129 |
2244667 | 2244667 | 2022-02-23 | Grady | Oklahoma | 40051 | 13540 | 229 |
2244668 | 2244668 | 2022-02-23 | Grant | Oklahoma | 40053 | 1021 | 14 |
2244669 | 2244669 | 2022-02-23 | Greer | Oklahoma | 40055 | 1271 | 30 |
2244670 | 2244670 | 2022-02-23 | Harmon | Oklahoma | 40057 | 514 | 11 |
2244671 | 2244671 | 2022-02-23 | Harper | Oklahoma | 40059 | 700 | 12 |
2244672 | 2244672 | 2022-02-23 | Haskell | Oklahoma | 40061 | 2760 | 36 |
2244673 | 2244673 | 2022-02-23 | Hughes | Oklahoma | 40063 | 2532 | 56 |
2244674 | 2244674 | 2022-02-23 | Jackson | Oklahoma | 40065 | 6509 | 96 |
2244675 | 2244675 | 2022-02-23 | Jefferson | Oklahoma | 40067 | 1278 | 23 |
2244676 | 2244676 | 2022-02-23 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2244677 | 2244677 | 2022-02-23 | Kay | Oklahoma | 40071 | 11999 | 203 |
2244678 | 2244678 | 2022-02-23 | Kingfisher | Oklahoma | 40073 | 4015 | 59 |
2244679 | 2244679 | 2022-02-23 | Kiowa | Oklahoma | 40075 | 1940 | 50 |
2244680 | 2244680 | 2022-02-23 | Latimer | Oklahoma | 40077 | 2266 | 32 |
2244681 | 2244681 | 2022-02-23 | Le Flore | Oklahoma | 40079 | 12267 | 101 |
2244682 | 2244682 | 2022-02-23 | Lincoln | Oklahoma | 40081 | 7710 | 124 |
2244683 | 2244683 | 2022-02-23 | Logan | Oklahoma | 40083 | 10584 | 149 |
2244684 | 2244684 | 2022-02-23 | Love | Oklahoma | 40085 | 2992 | 36 |
2244685 | 2244685 | 2022-02-23 | Major | Oklahoma | 40093 | 2429 | 36 |
2244686 | 2244686 | 2022-02-23 | Marshall | Oklahoma | 40095 | 4507 | 38 |
2244687 | 2244687 | 2022-02-23 | Mayes | Oklahoma | 40097 | 10157 | 148 |
2244688 | 2244688 | 2022-02-23 | McClain | Oklahoma | 40087 | 11474 | 122 |
2244689 | 2244689 | 2022-02-23 | McCurtain | Oklahoma | 40089 | 7967 | 152 |
2244690 | 2244690 | 2022-02-23 | McIntosh | Oklahoma | 40091 | 4865 | 114 |
2244691 | 2244691 | 2022-02-23 | Murray | Oklahoma | 40099 | 4137 | 65 |
2244692 | 2244692 | 2022-02-23 | Muskogee | Oklahoma | 40101 | 19763 | 312 |
2244693 | 2244693 | 2022-02-23 | Noble | Oklahoma | 40103 | 2991 | 36 |
2244694 | 2244694 | 2022-02-23 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2244695 | 2244695 | 2022-02-23 | Okfuskee | Oklahoma | 40107 | 3498 | 55 |
2244696 | 2244696 | 2022-02-23 | Oklahoma | Oklahoma | 40109 | 192433 | 2230 |
2244697 | 2244697 | 2022-02-23 | Okmulgee | Oklahoma | 40111 | 9608 | 170 |
2244698 | 2244698 | 2022-02-23 | Osage | Oklahoma | 40113 | 10799 | 155 |
2244699 | 2244699 | 2022-02-23 | Ottawa | Oklahoma | 40115 | 9025 | 115 |
2244700 | 2244700 | 2022-02-23 | Pawnee | Oklahoma | 40117 | 4063 | 79 |
2244701 | 2244701 | 2022-02-23 | Payne | Oklahoma | 40119 | 18044 | 147 |
2244702 | 2244702 | 2022-02-23 | Pittsburg | Oklahoma | 40121 | 10693 | 193 |
2244703 | 2244703 | 2022-02-23 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2244704 | 2244704 | 2022-02-23 | Pottawatomie | Oklahoma | 40125 | 20289 | 257 |
2244705 | 2244705 | 2022-02-23 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2244706 | 2244706 | 2022-02-23 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2244707 | 2244707 | 2022-02-23 | Rogers | Oklahoma | 40131 | 25091 | 354 |
2244708 | 2244708 | 2022-02-23 | Seminole | Oklahoma | 40133 | 6031 | 122 |
2244709 | 2244709 | 2022-02-23 | Sequoyah | Oklahoma | 40135 | 10492 | 97 |
2244710 | 2244710 | 2022-02-23 | Stephens | Oklahoma | 40137 | 10588 | 185 |
2244711 | 2244711 | 2022-02-23 | Texas | Oklahoma | 40139 | 5944 | 52 |
2244712 | 2244712 | 2022-02-23 | Tillman | Oklahoma | 40141 | 1502 | 30 |
2244713 | 2244713 | 2022-02-23 | Tulsa | Oklahoma | 40143 | 167771 | 1979 |
2244714 | 2244714 | 2022-02-23 | Unknown | Oklahoma | 1561 | 0 | |
2244715 | 2244715 | 2022-02-23 | Wagoner | Oklahoma | 40145 | 21406 | 250 |
2244716 | 2244716 | 2022-02-23 | Washington | Oklahoma | 40147 | 12553 | 236 |
2244717 | 2244717 | 2022-02-23 | Washita | Oklahoma | 40149 | 2591 | 45 |
2244718 | 2244718 | 2022-02-23 | Woods | Oklahoma | 40151 | 2334 | 33 |
2244719 | 2244719 | 2022-02-23 | 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);