ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-02-01" 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 |
---|---|---|---|---|---|---|---|
2173095 | 2173095 | 2022-02-01 | Adair | Oklahoma | 40001 | 6678 | 65 |
2173096 | 2173096 | 2022-02-01 | Alfalfa | Oklahoma | 40003 | 1596 | 10 |
2173097 | 2173097 | 2022-02-01 | Atoka | Oklahoma | 40005 | 3449 | 41 |
2173098 | 2173098 | 2022-02-01 | Beaver | Oklahoma | 40007 | 852 | 10 |
2173099 | 2173099 | 2022-02-01 | Beckham | Oklahoma | 40009 | 5317 | 90 |
2173100 | 2173100 | 2022-02-01 | Blaine | Oklahoma | 40011 | 2192 | 34 |
2173101 | 2173101 | 2022-02-01 | Bryan | Oklahoma | 40013 | 12368 | 120 |
2173102 | 2173102 | 2022-02-01 | Caddo | Oklahoma | 40015 | 7448 | 143 |
2173103 | 2173103 | 2022-02-01 | Canadian | Oklahoma | 40017 | 35570 | 328 |
2173104 | 2173104 | 2022-02-01 | Carter | Oklahoma | 40019 | 12342 | 204 |
2173105 | 2173105 | 2022-02-01 | Cherokee | Oklahoma | 40021 | 12495 | 130 |
2173106 | 2173106 | 2022-02-01 | Choctaw | Oklahoma | 40023 | 3659 | 53 |
2173107 | 2173107 | 2022-02-01 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2173108 | 2173108 | 2022-02-01 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2173109 | 2173109 | 2022-02-01 | Coal | Oklahoma | 40029 | 1382 | 20 |
2173110 | 2173110 | 2022-02-01 | Comanche | Oklahoma | 40031 | 28895 | 338 |
2173111 | 2173111 | 2022-02-01 | Cotton | Oklahoma | 40033 | 1258 | 24 |
2173112 | 2173112 | 2022-02-01 | Craig | Oklahoma | 40035 | 4030 | 40 |
2173113 | 2173113 | 2022-02-01 | Creek | Oklahoma | 40037 | 15587 | 287 |
2173114 | 2173114 | 2022-02-01 | Custer | Oklahoma | 40039 | 7072 | 142 |
2173115 | 2173115 | 2022-02-01 | Delaware | Oklahoma | 40041 | 9792 | 174 |
2173116 | 2173116 | 2022-02-01 | Dewey | Oklahoma | 40043 | 975 | 25 |
2173117 | 2173117 | 2022-02-01 | Ellis | Oklahoma | 40045 | 671 | 7 |
2173118 | 2173118 | 2022-02-01 | Garfield | Oklahoma | 40047 | 13189 | 229 |
2173119 | 2173119 | 2022-02-01 | Garvin | Oklahoma | 40049 | 6291 | 115 |
2173120 | 2173120 | 2022-02-01 | Grady | Oklahoma | 40051 | 12450 | 216 |
2173121 | 2173121 | 2022-02-01 | Grant | Oklahoma | 40053 | 931 | 12 |
2173122 | 2173122 | 2022-02-01 | Greer | Oklahoma | 40055 | 1120 | 29 |
2173123 | 2173123 | 2022-02-01 | Harmon | Oklahoma | 40057 | 476 | 10 |
2173124 | 2173124 | 2022-02-01 | Harper | Oklahoma | 40059 | 672 | 11 |
2173125 | 2173125 | 2022-02-01 | Haskell | Oklahoma | 40061 | 2368 | 33 |
2173126 | 2173126 | 2022-02-01 | Hughes | Oklahoma | 40063 | 2234 | 49 |
2173127 | 2173127 | 2022-02-01 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2173128 | 2173128 | 2022-02-01 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2173129 | 2173129 | 2022-02-01 | Johnston | Oklahoma | 40069 | 2709 | 49 |
2173130 | 2173130 | 2022-02-01 | Kay | Oklahoma | 40071 | 10688 | 183 |
2173131 | 2173131 | 2022-02-01 | Kingfisher | Oklahoma | 40073 | 3561 | 56 |
2173132 | 2173132 | 2022-02-01 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2173133 | 2173133 | 2022-02-01 | Latimer | Oklahoma | 40077 | 1969 | 31 |
2173134 | 2173134 | 2022-02-01 | Le Flore | Oklahoma | 40079 | 10815 | 98 |
2173135 | 2173135 | 2022-02-01 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2173136 | 2173136 | 2022-02-01 | Logan | Oklahoma | 40083 | 9593 | 140 |
2173137 | 2173137 | 2022-02-01 | Love | Oklahoma | 40085 | 2707 | 31 |
2173138 | 2173138 | 2022-02-01 | Major | Oklahoma | 40093 | 2192 | 34 |
2173139 | 2173139 | 2022-02-01 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2173140 | 2173140 | 2022-02-01 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2173141 | 2173141 | 2022-02-01 | McClain | Oklahoma | 40087 | 10440 | 111 |
2173142 | 2173142 | 2022-02-01 | McCurtain | Oklahoma | 40089 | 7454 | 141 |
2173143 | 2173143 | 2022-02-01 | McIntosh | Oklahoma | 40091 | 4244 | 108 |
2173144 | 2173144 | 2022-02-01 | Murray | Oklahoma | 40099 | 3739 | 62 |
2173145 | 2173145 | 2022-02-01 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2173146 | 2173146 | 2022-02-01 | Noble | Oklahoma | 40103 | 2613 | 33 |
2173147 | 2173147 | 2022-02-01 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2173148 | 2173148 | 2022-02-01 | Okfuskee | Oklahoma | 40107 | 3137 | 52 |
2173149 | 2173149 | 2022-02-01 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2173150 | 2173150 | 2022-02-01 | Okmulgee | Oklahoma | 40111 | 8012 | 158 |
2173151 | 2173151 | 2022-02-01 | Osage | Oklahoma | 40113 | 9614 | 144 |
2173152 | 2173152 | 2022-02-01 | Ottawa | Oklahoma | 40115 | 8017 | 110 |
2173153 | 2173153 | 2022-02-01 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2173154 | 2173154 | 2022-02-01 | Payne | Oklahoma | 40119 | 15921 | 134 |
2173155 | 2173155 | 2022-02-01 | Pittsburg | Oklahoma | 40121 | 9384 | 183 |
2173156 | 2173156 | 2022-02-01 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2173157 | 2173157 | 2022-02-01 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2173158 | 2173158 | 2022-02-01 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2173159 | 2173159 | 2022-02-01 | Roger Mills | Oklahoma | 40129 | 805 | 13 |
2173160 | 2173160 | 2022-02-01 | Rogers | Oklahoma | 40131 | 22295 | 327 |
2173161 | 2173161 | 2022-02-01 | Seminole | Oklahoma | 40133 | 5347 | 108 |
2173162 | 2173162 | 2022-02-01 | Sequoyah | Oklahoma | 40135 | 9194 | 94 |
2173163 | 2173163 | 2022-02-01 | Stephens | Oklahoma | 40137 | 9690 | 164 |
2173164 | 2173164 | 2022-02-01 | Texas | Oklahoma | 40139 | 5508 | 46 |
2173165 | 2173165 | 2022-02-01 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2173166 | 2173166 | 2022-02-01 | Tulsa | Oklahoma | 40143 | 150136 | 1880 |
2173167 | 2173167 | 2022-02-01 | Unknown | Oklahoma | 65423 | 3 | |
2173168 | 2173168 | 2022-02-01 | Wagoner | Oklahoma | 40145 | 19244 | 237 |
2173169 | 2173169 | 2022-02-01 | Washington | Oklahoma | 40147 | 10914 | 222 |
2173170 | 2173170 | 2022-02-01 | Washita | Oklahoma | 40149 | 2358 | 38 |
2173171 | 2173171 | 2022-02-01 | Woods | Oklahoma | 40151 | 2081 | 30 |
2173172 | 2173172 | 2022-02-01 | Woodward | Oklahoma | 40153 | 4704 | 60 |
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);