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-08-31 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
488047 | 488047 | 2020-08-31 | Adair | Oklahoma | 40001 | 447 | 8 |
488048 | 488048 | 2020-08-31 | Alfalfa | Oklahoma | 40003 | 13 | 0 |
488049 | 488049 | 2020-08-31 | Atoka | Oklahoma | 40005 | 111 | 1 |
488050 | 488050 | 2020-08-31 | Beaver | Oklahoma | 40007 | 44 | 0 |
488051 | 488051 | 2020-08-31 | Beckham | Oklahoma | 40009 | 123 | 1 |
488052 | 488052 | 2020-08-31 | Blaine | Oklahoma | 40011 | 75 | 1 |
488053 | 488053 | 2020-08-31 | Bryan | Oklahoma | 40013 | 599 | 3 |
488054 | 488054 | 2020-08-31 | Caddo | Oklahoma | 40015 | 562 | 20 |
488055 | 488055 | 2020-08-31 | Canadian | Oklahoma | 40017 | 1541 | 12 |
488056 | 488056 | 2020-08-31 | Carter | Oklahoma | 40019 | 411 | 6 |
488057 | 488057 | 2020-08-31 | Cherokee | Oklahoma | 40021 | 684 | 6 |
488058 | 488058 | 2020-08-31 | Choctaw | Oklahoma | 40023 | 245 | 1 |
488059 | 488059 | 2020-08-31 | Cimarron | Oklahoma | 40025 | 14 | 0 |
488060 | 488060 | 2020-08-31 | Cleveland | Oklahoma | 40027 | 3930 | 64 |
488061 | 488061 | 2020-08-31 | Coal | Oklahoma | 40029 | 57 | 0 |
488062 | 488062 | 2020-08-31 | Comanche | Oklahoma | 40031 | 1251 | 11 |
488063 | 488063 | 2020-08-31 | Cotton | Oklahoma | 40033 | 29 | 2 |
488064 | 488064 | 2020-08-31 | Craig | Oklahoma | 40035 | 119 | 1 |
488065 | 488065 | 2020-08-31 | Creek | Oklahoma | 40037 | 812 | 21 |
488066 | 488066 | 2020-08-31 | Custer | Oklahoma | 40039 | 326 | 0 |
488067 | 488067 | 2020-08-31 | Delaware | Oklahoma | 40041 | 540 | 21 |
488068 | 488068 | 2020-08-31 | Dewey | Oklahoma | 40043 | 21 | 0 |
488069 | 488069 | 2020-08-31 | Ellis | Oklahoma | 40045 | 6 | 0 |
488070 | 488070 | 2020-08-31 | Garfield | Oklahoma | 40047 | 980 | 12 |
488071 | 488071 | 2020-08-31 | Garvin | Oklahoma | 40049 | 261 | 4 |
488072 | 488072 | 2020-08-31 | Grady | Oklahoma | 40051 | 533 | 7 |
488073 | 488073 | 2020-08-31 | Grant | Oklahoma | 40053 | 25 | 0 |
488074 | 488074 | 2020-08-31 | Greer | Oklahoma | 40055 | 88 | 8 |
488075 | 488075 | 2020-08-31 | Harmon | Oklahoma | 40057 | 39 | 0 |
488076 | 488076 | 2020-08-31 | Harper | Oklahoma | 40059 | 17 | 0 |
488077 | 488077 | 2020-08-31 | Haskell | Oklahoma | 40061 | 164 | 4 |
488078 | 488078 | 2020-08-31 | Hughes | Oklahoma | 40063 | 215 | 3 |
488079 | 488079 | 2020-08-31 | Jackson | Oklahoma | 40065 | 596 | 9 |
488080 | 488080 | 2020-08-31 | Jefferson | Oklahoma | 40067 | 36 | 0 |
488081 | 488081 | 2020-08-31 | Johnston | Oklahoma | 40069 | 88 | 1 |
488082 | 488082 | 2020-08-31 | Kay | Oklahoma | 40071 | 309 | 12 |
488083 | 488083 | 2020-08-31 | Kingfisher | Oklahoma | 40073 | 262 | 1 |
488084 | 488084 | 2020-08-31 | Kiowa | Oklahoma | 40075 | 44 | 1 |
488085 | 488085 | 2020-08-31 | Latimer | Oklahoma | 40077 | 113 | 2 |
488086 | 488086 | 2020-08-31 | Le Flore | Oklahoma | 40079 | 648 | 6 |
488087 | 488087 | 2020-08-31 | Lincoln | Oklahoma | 40081 | 296 | 8 |
488088 | 488088 | 2020-08-31 | Logan | Oklahoma | 40083 | 301 | 1 |
488089 | 488089 | 2020-08-31 | Love | Oklahoma | 40085 | 107 | 0 |
488090 | 488090 | 2020-08-31 | Major | Oklahoma | 40093 | 52 | 1 |
488091 | 488091 | 2020-08-31 | Marshall | Oklahoma | 40095 | 130 | 1 |
488092 | 488092 | 2020-08-31 | Mayes | Oklahoma | 40097 | 414 | 9 |
488093 | 488093 | 2020-08-31 | McClain | Oklahoma | 40087 | 574 | 4 |
488094 | 488094 | 2020-08-31 | McCurtain | Oklahoma | 40089 | 1025 | 29 |
488095 | 488095 | 2020-08-31 | McIntosh | Oklahoma | 40091 | 237 | 4 |
488096 | 488096 | 2020-08-31 | Murray | Oklahoma | 40099 | 89 | 1 |
488097 | 488097 | 2020-08-31 | Muskogee | Oklahoma | 40101 | 1287 | 16 |
488098 | 488098 | 2020-08-31 | Noble | Oklahoma | 40103 | 105 | 2 |
488099 | 488099 | 2020-08-31 | Nowata | Oklahoma | 40105 | 99 | 1 |
488100 | 488100 | 2020-08-31 | Okfuskee | Oklahoma | 40107 | 101 | 3 |
488101 | 488101 | 2020-08-31 | Oklahoma | Oklahoma | 40109 | 13436 | 154 |
488102 | 488102 | 2020-08-31 | Okmulgee | Oklahoma | 40111 | 613 | 4 |
488103 | 488103 | 2020-08-31 | Osage | Oklahoma | 40113 | 640 | 12 |
488104 | 488104 | 2020-08-31 | Ottawa | Oklahoma | 40115 | 524 | 4 |
488105 | 488105 | 2020-08-31 | Pawnee | Oklahoma | 40117 | 219 | 3 |
488106 | 488106 | 2020-08-31 | Payne | Oklahoma | 40119 | 1180 | 5 |
488107 | 488107 | 2020-08-31 | Pittsburg | Oklahoma | 40121 | 581 | 15 |
488108 | 488108 | 2020-08-31 | Pontotoc | Oklahoma | 40123 | 241 | 3 |
488109 | 488109 | 2020-08-31 | Pottawatomie | Oklahoma | 40125 | 863 | 9 |
488110 | 488110 | 2020-08-31 | Pushmataha | Oklahoma | 40127 | 126 | 1 |
488111 | 488111 | 2020-08-31 | Roger Mills | Oklahoma | 40129 | 13 | 1 |
488112 | 488112 | 2020-08-31 | Rogers | Oklahoma | 40131 | 1314 | 41 |
488113 | 488113 | 2020-08-31 | Seminole | Oklahoma | 40133 | 323 | 5 |
488114 | 488114 | 2020-08-31 | Sequoyah | Oklahoma | 40135 | 581 | 8 |
488115 | 488115 | 2020-08-31 | Stephens | Oklahoma | 40137 | 252 | 4 |
488116 | 488116 | 2020-08-31 | Texas | Oklahoma | 40139 | 1143 | 7 |
488117 | 488117 | 2020-08-31 | Tillman | Oklahoma | 40141 | 68 | 1 |
488118 | 488118 | 2020-08-31 | Tulsa | Oklahoma | 40143 | 13233 | 132 |
488119 | 488119 | 2020-08-31 | Unknown | Oklahoma | 82 | 0 | |
488120 | 488120 | 2020-08-31 | Wagoner | Oklahoma | 40145 | 1147 | 23 |
488121 | 488121 | 2020-08-31 | Washington | Oklahoma | 40147 | 795 | 39 |
488122 | 488122 | 2020-08-31 | Washita | Oklahoma | 40149 | 42 | 0 |
488123 | 488123 | 2020-08-31 | Woods | Oklahoma | 40151 | 25 | 0 |
488124 | 488124 | 2020-08-31 | Woodward | Oklahoma | 40153 | 97 | 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);