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-01-28 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2160078 | 2160078 | 2022-01-28 | Adair | Oklahoma | 40001 | 6678 | 65 |
2160079 | 2160079 | 2022-01-28 | Alfalfa | Oklahoma | 40003 | 1596 | 10 |
2160080 | 2160080 | 2022-01-28 | Atoka | Oklahoma | 40005 | 3449 | 41 |
2160081 | 2160081 | 2022-01-28 | Beaver | Oklahoma | 40007 | 852 | 10 |
2160082 | 2160082 | 2022-01-28 | Beckham | Oklahoma | 40009 | 5317 | 90 |
2160083 | 2160083 | 2022-01-28 | Blaine | Oklahoma | 40011 | 2192 | 34 |
2160084 | 2160084 | 2022-01-28 | Bryan | Oklahoma | 40013 | 12368 | 120 |
2160085 | 2160085 | 2022-01-28 | Caddo | Oklahoma | 40015 | 7448 | 143 |
2160086 | 2160086 | 2022-01-28 | Canadian | Oklahoma | 40017 | 35570 | 328 |
2160087 | 2160087 | 2022-01-28 | Carter | Oklahoma | 40019 | 12342 | 204 |
2160088 | 2160088 | 2022-01-28 | Cherokee | Oklahoma | 40021 | 12495 | 130 |
2160089 | 2160089 | 2022-01-28 | Choctaw | Oklahoma | 40023 | 3659 | 53 |
2160090 | 2160090 | 2022-01-28 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2160091 | 2160091 | 2022-01-28 | Cleveland | Oklahoma | 40027 | 70801 | 676 |
2160092 | 2160092 | 2022-01-28 | Coal | Oklahoma | 40029 | 1382 | 20 |
2160093 | 2160093 | 2022-01-28 | Comanche | Oklahoma | 40031 | 28895 | 338 |
2160094 | 2160094 | 2022-01-28 | Cotton | Oklahoma | 40033 | 1258 | 24 |
2160095 | 2160095 | 2022-01-28 | Craig | Oklahoma | 40035 | 4030 | 40 |
2160096 | 2160096 | 2022-01-28 | Creek | Oklahoma | 40037 | 15587 | 287 |
2160097 | 2160097 | 2022-01-28 | Custer | Oklahoma | 40039 | 7072 | 142 |
2160098 | 2160098 | 2022-01-28 | Delaware | Oklahoma | 40041 | 9792 | 174 |
2160099 | 2160099 | 2022-01-28 | Dewey | Oklahoma | 40043 | 975 | 25 |
2160100 | 2160100 | 2022-01-28 | Ellis | Oklahoma | 40045 | 671 | 7 |
2160101 | 2160101 | 2022-01-28 | Garfield | Oklahoma | 40047 | 13189 | 229 |
2160102 | 2160102 | 2022-01-28 | Garvin | Oklahoma | 40049 | 6291 | 115 |
2160103 | 2160103 | 2022-01-28 | Grady | Oklahoma | 40051 | 12450 | 216 |
2160104 | 2160104 | 2022-01-28 | Grant | Oklahoma | 40053 | 931 | 12 |
2160105 | 2160105 | 2022-01-28 | Greer | Oklahoma | 40055 | 1120 | 29 |
2160106 | 2160106 | 2022-01-28 | Harmon | Oklahoma | 40057 | 476 | 10 |
2160107 | 2160107 | 2022-01-28 | Harper | Oklahoma | 40059 | 672 | 11 |
2160108 | 2160108 | 2022-01-28 | Haskell | Oklahoma | 40061 | 2368 | 33 |
2160109 | 2160109 | 2022-01-28 | Hughes | Oklahoma | 40063 | 2234 | 49 |
2160110 | 2160110 | 2022-01-28 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2160111 | 2160111 | 2022-01-28 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2160112 | 2160112 | 2022-01-28 | Johnston | Oklahoma | 40069 | 2709 | 49 |
2160113 | 2160113 | 2022-01-28 | Kay | Oklahoma | 40071 | 10688 | 183 |
2160114 | 2160114 | 2022-01-28 | Kingfisher | Oklahoma | 40073 | 3561 | 56 |
2160115 | 2160115 | 2022-01-28 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2160116 | 2160116 | 2022-01-28 | Latimer | Oklahoma | 40077 | 1969 | 31 |
2160117 | 2160117 | 2022-01-28 | Le Flore | Oklahoma | 40079 | 10815 | 98 |
2160118 | 2160118 | 2022-01-28 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2160119 | 2160119 | 2022-01-28 | Logan | Oklahoma | 40083 | 9593 | 140 |
2160120 | 2160120 | 2022-01-28 | Love | Oklahoma | 40085 | 2707 | 31 |
2160121 | 2160121 | 2022-01-28 | Major | Oklahoma | 40093 | 2192 | 34 |
2160122 | 2160122 | 2022-01-28 | Marshall | Oklahoma | 40095 | 4141 | 32 |
2160123 | 2160123 | 2022-01-28 | Mayes | Oklahoma | 40097 | 8705 | 138 |
2160124 | 2160124 | 2022-01-28 | McClain | Oklahoma | 40087 | 10440 | 111 |
2160125 | 2160125 | 2022-01-28 | McCurtain | Oklahoma | 40089 | 7454 | 141 |
2160126 | 2160126 | 2022-01-28 | McIntosh | Oklahoma | 40091 | 4244 | 108 |
2160127 | 2160127 | 2022-01-28 | Murray | Oklahoma | 40099 | 3739 | 62 |
2160128 | 2160128 | 2022-01-28 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2160129 | 2160129 | 2022-01-28 | Noble | Oklahoma | 40103 | 2613 | 33 |
2160130 | 2160130 | 2022-01-28 | Nowata | Oklahoma | 40105 | 2423 | 34 |
2160131 | 2160131 | 2022-01-28 | Okfuskee | Oklahoma | 40107 | 3137 | 52 |
2160132 | 2160132 | 2022-01-28 | Oklahoma | Oklahoma | 40109 | 176232 | 2040 |
2160133 | 2160133 | 2022-01-28 | Okmulgee | Oklahoma | 40111 | 8012 | 158 |
2160134 | 2160134 | 2022-01-28 | Osage | Oklahoma | 40113 | 9614 | 144 |
2160135 | 2160135 | 2022-01-28 | Ottawa | Oklahoma | 40115 | 8017 | 110 |
2160136 | 2160136 | 2022-01-28 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2160137 | 2160137 | 2022-01-28 | Payne | Oklahoma | 40119 | 15921 | 134 |
2160138 | 2160138 | 2022-01-28 | Pittsburg | Oklahoma | 40121 | 9384 | 183 |
2160139 | 2160139 | 2022-01-28 | Pontotoc | Oklahoma | 40123 | 10232 | 111 |
2160140 | 2160140 | 2022-01-28 | Pottawatomie | Oklahoma | 40125 | 18315 | 232 |
2160141 | 2160141 | 2022-01-28 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2160142 | 2160142 | 2022-01-28 | Roger Mills | Oklahoma | 40129 | 805 | 13 |
2160143 | 2160143 | 2022-01-28 | Rogers | Oklahoma | 40131 | 22295 | 327 |
2160144 | 2160144 | 2022-01-28 | Seminole | Oklahoma | 40133 | 5347 | 108 |
2160145 | 2160145 | 2022-01-28 | Sequoyah | Oklahoma | 40135 | 9194 | 94 |
2160146 | 2160146 | 2022-01-28 | Stephens | Oklahoma | 40137 | 9690 | 164 |
2160147 | 2160147 | 2022-01-28 | Texas | Oklahoma | 40139 | 5508 | 46 |
2160148 | 2160148 | 2022-01-28 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2160149 | 2160149 | 2022-01-28 | Tulsa | Oklahoma | 40143 | 150136 | 1880 |
2160150 | 2160150 | 2022-01-28 | Unknown | Oklahoma | 39190 | 3 | |
2160151 | 2160151 | 2022-01-28 | Wagoner | Oklahoma | 40145 | 19244 | 237 |
2160152 | 2160152 | 2022-01-28 | Washington | Oklahoma | 40147 | 10914 | 222 |
2160153 | 2160153 | 2022-01-28 | Washita | Oklahoma | 40149 | 2358 | 38 |
2160154 | 2160154 | 2022-01-28 | Woods | Oklahoma | 40151 | 2081 | 30 |
2160155 | 2160155 | 2022-01-28 | 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);