ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-07-20" 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 |
---|---|---|---|---|---|---|---|
1536142 | 1536142 | 2021-07-20 | Adair | Oklahoma | 40001 | 3304 | 45 |
1536143 | 1536143 | 2021-07-20 | Alfalfa | Oklahoma | 40003 | 1156 | 7 |
1536144 | 1536144 | 2021-07-20 | Atoka | Oklahoma | 40005 | 1909 | 28 |
1536145 | 1536145 | 2021-07-20 | Beaver | Oklahoma | 40007 | 475 | 6 |
1536146 | 1536146 | 2021-07-20 | Beckham | Oklahoma | 40009 | 2907 | 58 |
1536147 | 1536147 | 2021-07-20 | Blaine | Oklahoma | 40011 | 1060 | 20 |
1536148 | 1536148 | 2021-07-20 | Bryan | Oklahoma | 40013 | 6303 | 79 |
1536149 | 1536149 | 2021-07-20 | Caddo | Oklahoma | 40015 | 4008 | 96 |
1536150 | 1536150 | 2021-07-20 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1536151 | 1536151 | 2021-07-20 | Carter | Oklahoma | 40019 | 6424 | 131 |
1536152 | 1536152 | 2021-07-20 | Cherokee | Oklahoma | 40021 | 5776 | 79 |
1536153 | 1536153 | 2021-07-20 | Choctaw | Oklahoma | 40023 | 1644 | 27 |
1536154 | 1536154 | 2021-07-20 | Cimarron | Oklahoma | 40025 | 239 | 2 |
1536155 | 1536155 | 2021-07-20 | Cleveland | Oklahoma | 40027 | 31669 | 441 |
1536156 | 1536156 | 2021-07-20 | Coal | Oklahoma | 40029 | 715 | 15 |
1536157 | 1536157 | 2021-07-20 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1536158 | 1536158 | 2021-07-20 | Cotton | Oklahoma | 40033 | 700 | 16 |
1536159 | 1536159 | 2021-07-20 | Craig | Oklahoma | 40035 | 2096 | 18 |
1536160 | 1536160 | 2021-07-20 | Creek | Oklahoma | 40037 | 7194 | 165 |
1536161 | 1536161 | 2021-07-20 | Custer | Oklahoma | 40039 | 4103 | 104 |
1536162 | 1536162 | 2021-07-20 | Delaware | Oklahoma | 40041 | 4974 | 98 |
1536163 | 1536163 | 2021-07-20 | Dewey | Oklahoma | 40043 | 553 | 14 |
1536164 | 1536164 | 2021-07-20 | Ellis | Oklahoma | 40045 | 364 | 6 |
1536165 | 1536165 | 2021-07-20 | Garfield | Oklahoma | 40047 | 7856 | 139 |
1536166 | 1536166 | 2021-07-20 | Garvin | Oklahoma | 40049 | 3685 | 79 |
1536167 | 1536167 | 2021-07-20 | Grady | Oklahoma | 40051 | 6037 | 130 |
1536168 | 1536168 | 2021-07-20 | Grant | Oklahoma | 40053 | 551 | 7 |
1536169 | 1536169 | 2021-07-20 | Greer | Oklahoma | 40055 | 591 | 22 |
1536170 | 1536170 | 2021-07-20 | Harmon | Oklahoma | 40057 | 328 | 6 |
1536171 | 1536171 | 2021-07-20 | Harper | Oklahoma | 40059 | 422 | 8 |
1536172 | 1536172 | 2021-07-20 | Haskell | Oklahoma | 40061 | 1280 | 17 |
1536173 | 1536173 | 2021-07-20 | Hughes | Oklahoma | 40063 | 1259 | 29 |
1536174 | 1536174 | 2021-07-20 | Jackson | Oklahoma | 40065 | 3149 | 56 |
1536175 | 1536175 | 2021-07-20 | Jefferson | Oklahoma | 40067 | 715 | 18 |
1536176 | 1536176 | 2021-07-20 | Johnston | Oklahoma | 40069 | 1413 | 37 |
1536177 | 1536177 | 2021-07-20 | Kay | Oklahoma | 40071 | 5366 | 128 |
1536178 | 1536178 | 2021-07-20 | Kingfisher | Oklahoma | 40073 | 2063 | 41 |
1536179 | 1536179 | 2021-07-20 | Kiowa | Oklahoma | 40075 | 822 | 26 |
1536180 | 1536180 | 2021-07-20 | Latimer | Oklahoma | 40077 | 856 | 13 |
1536181 | 1536181 | 2021-07-20 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1536182 | 1536182 | 2021-07-20 | Lincoln | Oklahoma | 40081 | 3309 | 72 |
1536183 | 1536183 | 2021-07-20 | Logan | Oklahoma | 40083 | 4336 | 65 |
1536184 | 1536184 | 2021-07-20 | Love | Oklahoma | 40085 | 1547 | 23 |
1536185 | 1536185 | 2021-07-20 | Major | Oklahoma | 40093 | 956 | 24 |
1536186 | 1536186 | 2021-07-20 | Marshall | Oklahoma | 40095 | 2081 | 23 |
1536187 | 1536187 | 2021-07-20 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1536188 | 1536188 | 2021-07-20 | McClain | Oklahoma | 40087 | 5418 | 73 |
1536189 | 1536189 | 2021-07-20 | McCurtain | Oklahoma | 40089 | 4017 | 94 |
1536190 | 1536190 | 2021-07-20 | McIntosh | Oklahoma | 40091 | 2054 | 61 |
1536191 | 1536191 | 2021-07-20 | Murray | Oklahoma | 40099 | 2057 | 44 |
1536192 | 1536192 | 2021-07-20 | Muskogee | Oklahoma | 40101 | 9498 | 177 |
1536193 | 1536193 | 2021-07-20 | Noble | Oklahoma | 40103 | 1385 | 20 |
1536194 | 1536194 | 2021-07-20 | Nowata | Oklahoma | 40105 | 1171 | 20 |
1536195 | 1536195 | 2021-07-20 | Okfuskee | Oklahoma | 40107 | 1815 | 32 |
1536196 | 1536196 | 2021-07-20 | Oklahoma | Oklahoma | 40109 | 88295 | 1313 |
1536197 | 1536197 | 2021-07-20 | Okmulgee | Oklahoma | 40111 | 3956 | 85 |
1536198 | 1536198 | 2021-07-20 | Osage | Oklahoma | 40113 | 4848 | 81 |
1536199 | 1536199 | 2021-07-20 | Ottawa | Oklahoma | 40115 | 4427 | 72 |
1536200 | 1536200 | 2021-07-20 | Pawnee | Oklahoma | 40117 | 1806 | 53 |
1536201 | 1536201 | 2021-07-20 | Payne | Oklahoma | 40119 | 8772 | 76 |
1536202 | 1536202 | 2021-07-20 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1536203 | 1536203 | 2021-07-20 | Pontotoc | Oklahoma | 40123 | 5212 | 80 |
1536204 | 1536204 | 2021-07-20 | Pottawatomie | Oklahoma | 40125 | 8487 | 131 |
1536205 | 1536205 | 2021-07-20 | Pushmataha | Oklahoma | 40127 | 1038 | 22 |
1536206 | 1536206 | 2021-07-20 | Roger Mills | Oklahoma | 40129 | 391 | 12 |
1536207 | 1536207 | 2021-07-20 | Rogers | Oklahoma | 40131 | 10900 | 196 |
1536208 | 1536208 | 2021-07-20 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1536209 | 1536209 | 2021-07-20 | Sequoyah | Oklahoma | 40135 | 4267 | 57 |
1536210 | 1536210 | 2021-07-20 | Stephens | Oklahoma | 40137 | 4963 | 107 |
1536211 | 1536211 | 2021-07-20 | Texas | Oklahoma | 40139 | 3548 | 34 |
1536212 | 1536212 | 2021-07-20 | Tillman | Oklahoma | 40141 | 808 | 17 |
1536213 | 1536213 | 2021-07-20 | Tulsa | Oklahoma | 40143 | 77325 | 1135 |
1536214 | 1536214 | 2021-07-20 | Unknown | Oklahoma | 5313 | 0 | |
1536215 | 1536215 | 2021-07-20 | Wagoner | Oklahoma | 40145 | 8421 | 123 |
1536216 | 1536216 | 2021-07-20 | Washington | Oklahoma | 40147 | 5384 | 119 |
1536217 | 1536217 | 2021-07-20 | Washita | Oklahoma | 40149 | 1093 | 23 |
1536218 | 1536218 | 2021-07-20 | Woods | Oklahoma | 40151 | 1221 | 18 |
1536219 | 1536219 | 2021-07-20 | Woodward | Oklahoma | 40153 | 3175 | 36 |
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);