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 2020-09-09 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
517148 | 517148 | 2020-09-09 | Adair | Oklahoma | 40001 | 510 | 10 |
517149 | 517149 | 2020-09-09 | Alfalfa | Oklahoma | 40003 | 20 | 0 |
517150 | 517150 | 2020-09-09 | Atoka | Oklahoma | 40005 | 172 | 1 |
517151 | 517151 | 2020-09-09 | Beaver | Oklahoma | 40007 | 44 | 0 |
517152 | 517152 | 2020-09-09 | Beckham | Oklahoma | 40009 | 146 | 1 |
517153 | 517153 | 2020-09-09 | Blaine | Oklahoma | 40011 | 91 | 1 |
517154 | 517154 | 2020-09-09 | Bryan | Oklahoma | 40013 | 678 | 3 |
517155 | 517155 | 2020-09-09 | Caddo | Oklahoma | 40015 | 613 | 20 |
517156 | 517156 | 2020-09-09 | Canadian | Oklahoma | 40017 | 1664 | 13 |
517157 | 517157 | 2020-09-09 | Carter | Oklahoma | 40019 | 446 | 7 |
517158 | 517158 | 2020-09-09 | Cherokee | Oklahoma | 40021 | 802 | 7 |
517159 | 517159 | 2020-09-09 | Choctaw | Oklahoma | 40023 | 259 | 2 |
517160 | 517160 | 2020-09-09 | Cimarron | Oklahoma | 40025 | 16 | 0 |
517161 | 517161 | 2020-09-09 | Cleveland | Oklahoma | 40027 | 4621 | 67 |
517162 | 517162 | 2020-09-09 | Coal | Oklahoma | 40029 | 63 | 0 |
517163 | 517163 | 2020-09-09 | Comanche | Oklahoma | 40031 | 1318 | 12 |
517164 | 517164 | 2020-09-09 | Cotton | Oklahoma | 40033 | 57 | 2 |
517165 | 517165 | 2020-09-09 | Craig | Oklahoma | 40035 | 182 | 1 |
517166 | 517166 | 2020-09-09 | Creek | Oklahoma | 40037 | 919 | 23 |
517167 | 517167 | 2020-09-09 | Custer | Oklahoma | 40039 | 376 | 0 |
517168 | 517168 | 2020-09-09 | Delaware | Oklahoma | 40041 | 600 | 22 |
517169 | 517169 | 2020-09-09 | Dewey | Oklahoma | 40043 | 26 | 1 |
517170 | 517170 | 2020-09-09 | Ellis | Oklahoma | 40045 | 6 | 0 |
517171 | 517171 | 2020-09-09 | Garfield | Oklahoma | 40047 | 1206 | 14 |
517172 | 517172 | 2020-09-09 | Garvin | Oklahoma | 40049 | 288 | 4 |
517173 | 517173 | 2020-09-09 | Grady | Oklahoma | 40051 | 600 | 7 |
517174 | 517174 | 2020-09-09 | Grant | Oklahoma | 40053 | 30 | 0 |
517175 | 517175 | 2020-09-09 | Greer | Oklahoma | 40055 | 93 | 8 |
517176 | 517176 | 2020-09-09 | Harmon | Oklahoma | 40057 | 40 | 0 |
517177 | 517177 | 2020-09-09 | Harper | Oklahoma | 40059 | 22 | 0 |
517178 | 517178 | 2020-09-09 | Haskell | Oklahoma | 40061 | 194 | 4 |
517179 | 517179 | 2020-09-09 | Hughes | Oklahoma | 40063 | 244 | 4 |
517180 | 517180 | 2020-09-09 | Jackson | Oklahoma | 40065 | 628 | 9 |
517181 | 517181 | 2020-09-09 | Jefferson | Oklahoma | 40067 | 37 | 0 |
517182 | 517182 | 2020-09-09 | Johnston | Oklahoma | 40069 | 120 | 2 |
517183 | 517183 | 2020-09-09 | Kay | Oklahoma | 40071 | 383 | 12 |
517184 | 517184 | 2020-09-09 | Kingfisher | Oklahoma | 40073 | 290 | 2 |
517185 | 517185 | 2020-09-09 | Kiowa | Oklahoma | 40075 | 54 | 2 |
517186 | 517186 | 2020-09-09 | Latimer | Oklahoma | 40077 | 118 | 2 |
517187 | 517187 | 2020-09-09 | Le Flore | Oklahoma | 40079 | 809 | 11 |
517188 | 517188 | 2020-09-09 | Lincoln | Oklahoma | 40081 | 339 | 9 |
517189 | 517189 | 2020-09-09 | Logan | Oklahoma | 40083 | 343 | 1 |
517190 | 517190 | 2020-09-09 | Love | Oklahoma | 40085 | 134 | 1 |
517191 | 517191 | 2020-09-09 | Major | Oklahoma | 40093 | 58 | 1 |
517192 | 517192 | 2020-09-09 | Marshall | Oklahoma | 40095 | 143 | 1 |
517193 | 517193 | 2020-09-09 | Mayes | Oklahoma | 40097 | 471 | 10 |
517194 | 517194 | 2020-09-09 | McClain | Oklahoma | 40087 | 647 | 4 |
517195 | 517195 | 2020-09-09 | McCurtain | Oklahoma | 40089 | 1112 | 31 |
517196 | 517196 | 2020-09-09 | McIntosh | Oklahoma | 40091 | 257 | 4 |
517197 | 517197 | 2020-09-09 | Murray | Oklahoma | 40099 | 102 | 1 |
517198 | 517198 | 2020-09-09 | Muskogee | Oklahoma | 40101 | 1484 | 17 |
517199 | 517199 | 2020-09-09 | Noble | Oklahoma | 40103 | 119 | 2 |
517200 | 517200 | 2020-09-09 | Nowata | Oklahoma | 40105 | 117 | 2 |
517201 | 517201 | 2020-09-09 | Okfuskee | Oklahoma | 40107 | 116 | 3 |
517202 | 517202 | 2020-09-09 | Oklahoma | Oklahoma | 40109 | 14543 | 168 |
517203 | 517203 | 2020-09-09 | Okmulgee | Oklahoma | 40111 | 688 | 5 |
517204 | 517204 | 2020-09-09 | Osage | Oklahoma | 40113 | 718 | 12 |
517205 | 517205 | 2020-09-09 | Ottawa | Oklahoma | 40115 | 646 | 4 |
517206 | 517206 | 2020-09-09 | Pawnee | Oklahoma | 40117 | 228 | 3 |
517207 | 517207 | 2020-09-09 | Payne | Oklahoma | 40119 | 1595 | 5 |
517208 | 517208 | 2020-09-09 | Pittsburg | Oklahoma | 40121 | 667 | 18 |
517209 | 517209 | 2020-09-09 | Pontotoc | Oklahoma | 40123 | 272 | 3 |
517210 | 517210 | 2020-09-09 | Pottawatomie | Oklahoma | 40125 | 980 | 9 |
517211 | 517211 | 2020-09-09 | Pushmataha | Oklahoma | 40127 | 132 | 1 |
517212 | 517212 | 2020-09-09 | Roger Mills | Oklahoma | 40129 | 14 | 1 |
517213 | 517213 | 2020-09-09 | Rogers | Oklahoma | 40131 | 1478 | 42 |
517214 | 517214 | 2020-09-09 | Seminole | Oklahoma | 40133 | 360 | 5 |
517215 | 517215 | 2020-09-09 | Sequoyah | Oklahoma | 40135 | 651 | 8 |
517216 | 517216 | 2020-09-09 | Stephens | Oklahoma | 40137 | 294 | 4 |
517217 | 517217 | 2020-09-09 | Texas | Oklahoma | 40139 | 1279 | 7 |
517218 | 517218 | 2020-09-09 | Tillman | Oklahoma | 40141 | 73 | 1 |
517219 | 517219 | 2020-09-09 | Tulsa | Oklahoma | 40143 | 14655 | 143 |
517220 | 517220 | 2020-09-09 | Unknown | Oklahoma | 55 | 0 | |
517221 | 517221 | 2020-09-09 | Wagoner | Oklahoma | 40145 | 1270 | 23 |
517222 | 517222 | 2020-09-09 | Washington | Oklahoma | 40147 | 890 | 40 |
517223 | 517223 | 2020-09-09 | Washita | Oklahoma | 40149 | 45 | 0 |
517224 | 517224 | 2020-09-09 | Woods | Oklahoma | 40151 | 33 | 0 |
517225 | 517225 | 2020-09-09 | Woodward | Oklahoma | 40153 | 136 | 0 |
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);