ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-04-27" 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 |
---|---|---|---|---|---|---|---|
2449622 | 2449622 | 2022-04-27 | Adair | Oklahoma | 40001 | 7952 | 73 |
2449623 | 2449623 | 2022-04-27 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2449624 | 2449624 | 2022-04-27 | Atoka | Oklahoma | 40005 | 3887 | 52 |
2449625 | 2449625 | 2022-04-27 | Beaver | Oklahoma | 40007 | 968 | 11 |
2449626 | 2449626 | 2022-04-27 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2449627 | 2449627 | 2022-04-27 | Blaine | Oklahoma | 40011 | 2454 | 41 |
2449628 | 2449628 | 2022-04-27 | Bryan | Oklahoma | 40013 | 13580 | 135 |
2449629 | 2449629 | 2022-04-27 | Caddo | Oklahoma | 40015 | 8264 | 165 |
2449630 | 2449630 | 2022-04-27 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2449631 | 2449631 | 2022-04-27 | Carter | Oklahoma | 40019 | 14329 | 235 |
2449632 | 2449632 | 2022-04-27 | Cherokee | Oklahoma | 40021 | 14513 | 149 |
2449633 | 2449633 | 2022-04-27 | Choctaw | Oklahoma | 40023 | 4061 | 64 |
2449634 | 2449634 | 2022-04-27 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2449635 | 2449635 | 2022-04-27 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2449636 | 2449636 | 2022-04-27 | Coal | Oklahoma | 40029 | 1670 | 24 |
2449637 | 2449637 | 2022-04-27 | Comanche | Oklahoma | 40031 | 33113 | 392 |
2449638 | 2449638 | 2022-04-27 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2449639 | 2449639 | 2022-04-27 | Craig | Oklahoma | 40035 | 4770 | 55 |
2449640 | 2449640 | 2022-04-27 | Creek | Oklahoma | 40037 | 18181 | 334 |
2449641 | 2449641 | 2022-04-27 | Custer | Oklahoma | 40039 | 7907 | 167 |
2449642 | 2449642 | 2022-04-27 | Delaware | Oklahoma | 40041 | 11080 | 201 |
2449643 | 2449643 | 2022-04-27 | Dewey | Oklahoma | 40043 | 1062 | 31 |
2449644 | 2449644 | 2022-04-27 | Ellis | Oklahoma | 40045 | 770 | 8 |
2449645 | 2449645 | 2022-04-27 | Garfield | Oklahoma | 40047 | 15182 | 290 |
2449646 | 2449646 | 2022-04-27 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2449647 | 2449647 | 2022-04-27 | Grady | Oklahoma | 40051 | 13723 | 243 |
2449648 | 2449648 | 2022-04-27 | Grant | Oklahoma | 40053 | 1032 | 16 |
2449649 | 2449649 | 2022-04-27 | Greer | Oklahoma | 40055 | 1295 | 37 |
2449650 | 2449650 | 2022-04-27 | Harmon | Oklahoma | 40057 | 521 | 12 |
2449651 | 2449651 | 2022-04-27 | Harper | Oklahoma | 40059 | 714 | 12 |
2449652 | 2449652 | 2022-04-27 | Haskell | Oklahoma | 40061 | 2775 | 41 |
2449653 | 2449653 | 2022-04-27 | Hughes | Oklahoma | 40063 | 2582 | 62 |
2449654 | 2449654 | 2022-04-27 | Jackson | Oklahoma | 40065 | 6558 | 106 |
2449655 | 2449655 | 2022-04-27 | Jefferson | Oklahoma | 40067 | 1314 | 28 |
2449656 | 2449656 | 2022-04-27 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2449657 | 2449657 | 2022-04-27 | Kay | Oklahoma | 40071 | 12283 | 217 |
2449658 | 2449658 | 2022-04-27 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2449659 | 2449659 | 2022-04-27 | Kiowa | Oklahoma | 40075 | 1958 | 52 |
2449660 | 2449660 | 2022-04-27 | Latimer | Oklahoma | 40077 | 2270 | 36 |
2449661 | 2449661 | 2022-04-27 | Le Flore | Oklahoma | 40079 | 12482 | 108 |
2449662 | 2449662 | 2022-04-27 | Lincoln | Oklahoma | 40081 | 7872 | 138 |
2449663 | 2449663 | 2022-04-27 | Logan | Oklahoma | 40083 | 10858 | 160 |
2449664 | 2449664 | 2022-04-27 | Love | Oklahoma | 40085 | 3097 | 39 |
2449665 | 2449665 | 2022-04-27 | Major | Oklahoma | 40093 | 2461 | 41 |
2449666 | 2449666 | 2022-04-27 | Marshall | Oklahoma | 40095 | 4605 | 43 |
2449667 | 2449667 | 2022-04-27 | Mayes | Oklahoma | 40097 | 10310 | 163 |
2449668 | 2449668 | 2022-04-27 | McClain | Oklahoma | 40087 | 11650 | 133 |
2449669 | 2449669 | 2022-04-27 | McCurtain | Oklahoma | 40089 | 8087 | 163 |
2449670 | 2449670 | 2022-04-27 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2449671 | 2449671 | 2022-04-27 | Murray | Oklahoma | 40099 | 4165 | 73 |
2449672 | 2449672 | 2022-04-27 | Muskogee | Oklahoma | 40101 | 19950 | 343 |
2449673 | 2449673 | 2022-04-27 | Noble | Oklahoma | 40103 | 3034 | 39 |
2449674 | 2449674 | 2022-04-27 | Nowata | Oklahoma | 40105 | 2778 | 39 |
2449675 | 2449675 | 2022-04-27 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2449676 | 2449676 | 2022-04-27 | Oklahoma | Oklahoma | 40109 | 199022 | 2445 |
2449677 | 2449677 | 2022-04-27 | Okmulgee | Oklahoma | 40111 | 9668 | 186 |
2449678 | 2449678 | 2022-04-27 | Osage | Oklahoma | 40113 | 10918 | 167 |
2449679 | 2449679 | 2022-04-27 | Ottawa | Oklahoma | 40115 | 9189 | 126 |
2449680 | 2449680 | 2022-04-27 | Pawnee | Oklahoma | 40117 | 4106 | 85 |
2449681 | 2449681 | 2022-04-27 | Payne | Oklahoma | 40119 | 18343 | 163 |
2449682 | 2449682 | 2022-04-27 | Pittsburg | Oklahoma | 40121 | 10770 | 210 |
2449683 | 2449683 | 2022-04-27 | Pontotoc | Oklahoma | 40123 | 12076 | 145 |
2449684 | 2449684 | 2022-04-27 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2449685 | 2449685 | 2022-04-27 | Pushmataha | Oklahoma | 40127 | 2670 | 45 |
2449686 | 2449686 | 2022-04-27 | Roger Mills | Oklahoma | 40129 | 883 | 16 |
2449687 | 2449687 | 2022-04-27 | Rogers | Oklahoma | 40131 | 25406 | 383 |
2449688 | 2449688 | 2022-04-27 | Seminole | Oklahoma | 40133 | 6131 | 134 |
2449689 | 2449689 | 2022-04-27 | Sequoyah | Oklahoma | 40135 | 10621 | 104 |
2449690 | 2449690 | 2022-04-27 | Stephens | Oklahoma | 40137 | 11119 | 203 |
2449691 | 2449691 | 2022-04-27 | Texas | Oklahoma | 40139 | 5991 | 54 |
2449692 | 2449692 | 2022-04-27 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2449693 | 2449693 | 2022-04-27 | Tulsa | Oklahoma | 40143 | 171073 | 2162 |
2449694 | 2449694 | 2022-04-27 | Unknown | Oklahoma | 1893 | 0 | |
2449695 | 2449695 | 2022-04-27 | Wagoner | Oklahoma | 40145 | 21745 | 275 |
2449696 | 2449696 | 2022-04-27 | Washington | Oklahoma | 40147 | 12677 | 260 |
2449697 | 2449697 | 2022-04-27 | Washita | Oklahoma | 40149 | 2630 | 52 |
2449698 | 2449698 | 2022-04-27 | Woods | Oklahoma | 40151 | 2352 | 38 |
2449699 | 2449699 | 2022-04-27 | Woodward | Oklahoma | 40153 | 5169 | 76 |
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);