ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59,923 rows where state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 130
- 40109 123
- 40065 122
- 40071 121
- 40119 121
- 40027 120
- 40017 119
- 40117 119
- 40051 117
- 40083 117
- 40087 117
- 40147 117
- 40039 116
- 40049 116
- 40101 114
- 40103 114
- 40123 113
- 40097 112
- 40145 112
- 40113 111
- 40125 111
- 40137 111
- 40001 110
- 40013 110
- 40019 110
- 40037 110
- 40041 110
- 40081 110
- 40111 110
- 40115 110
- …
county >30
- Tulsa 130
- Oklahoma 123
- Jackson 122
- Kay 121
- Payne 121
- Cleveland 120
- Canadian 119
- Pawnee 119
- Grady 117
- Logan 117
- McClain 117
- Washington 117
- Custer 116
- Garvin 116
- Muskogee 114
- Noble 114
- Pontotoc 113
- Mayes 112
- Wagoner 112
- Osage 111
- Pottawatomie 111
- Stephens 111
- Adair 110
- Bryan 110
- Carter 110
- Creek 110
- Delaware 110
- Lincoln 110
- Okmulgee 110
- Ottawa 110
- …
state 1
- Oklahoma · 7,751 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
330385 | 330385 | 2020-07-13 | Garvin | Oklahoma | 40049 | 123 | 3 |
330386 | 330386 | 2020-07-13 | Grady | Oklahoma | 40051 | 241 | 5 |
330387 | 330387 | 2020-07-13 | Grant | Oklahoma | 40053 | 3 | 0 |
330388 | 330388 | 2020-07-13 | Greer | Oklahoma | 40055 | 68 | 7 |
330389 | 330389 | 2020-07-13 | Harmon | Oklahoma | 40057 | 3 | 0 |
330390 | 330390 | 2020-07-13 | Harper | Oklahoma | 40059 | 1 | 0 |
330391 | 330391 | 2020-07-13 | Haskell | Oklahoma | 40061 | 16 | 0 |
330392 | 330392 | 2020-07-13 | Hughes | Oklahoma | 40063 | 14 | 0 |
330393 | 330393 | 2020-07-13 | Jackson | Oklahoma | 40065 | 57 | 3 |
330394 | 330394 | 2020-07-13 | Jefferson | Oklahoma | 40067 | 17 | 0 |
330395 | 330395 | 2020-07-13 | Johnston | Oklahoma | 40069 | 17 | 0 |
330396 | 330396 | 2020-07-13 | Kay | Oklahoma | 40071 | 126 | 8 |
330397 | 330397 | 2020-07-13 | Kingfisher | Oklahoma | 40073 | 46 | 0 |
330398 | 330398 | 2020-07-13 | Kiowa | Oklahoma | 40075 | 17 | 1 |
330399 | 330399 | 2020-07-13 | Latimer | Oklahoma | 40077 | 20 | 1 |
330400 | 330400 | 2020-07-13 | Le Flore | Oklahoma | 40079 | 61 | 1 |
330401 | 330401 | 2020-07-13 | Lincoln | Oklahoma | 40081 | 46 | 2 |
330402 | 330402 | 2020-07-13 | Logan | Oklahoma | 40083 | 98 | 1 |
330403 | 330403 | 2020-07-13 | Love | Oklahoma | 40085 | 46 | 0 |
330404 | 330404 | 2020-07-13 | Major | Oklahoma | 40093 | 14 | 1 |
330405 | 330405 | 2020-07-13 | Marshall | Oklahoma | 40095 | 43 | 0 |
330406 | 330406 | 2020-07-13 | Mayes | Oklahoma | 40097 | 122 | 5 |
330407 | 330407 | 2020-07-13 | McClain | Oklahoma | 40087 | 241 | 4 |
330408 | 330408 | 2020-07-13 | McCurtain | Oklahoma | 40089 | 622 | 11 |
330409 | 330409 | 2020-07-13 | McIntosh | Oklahoma | 40091 | 87 | 1 |
330410 | 330410 | 2020-07-13 | Murray | Oklahoma | 40099 | 25 | 0 |
330411 | 330411 | 2020-07-13 | Muskogee | Oklahoma | 40101 | 200 | 14 |
330412 | 330412 | 2020-07-13 | Noble | Oklahoma | 40103 | 53 | 1 |
330413 | 330413 | 2020-07-13 | Nowata | Oklahoma | 40105 | 38 | 1 |
330414 | 330414 | 2020-07-13 | Okfuskee | Oklahoma | 40107 | 19 | 0 |
330415 | 330415 | 2020-07-13 | Oklahoma | Oklahoma | 40109 | 4986 | 74 |
330416 | 330416 | 2020-07-13 | Okmulgee | Oklahoma | 40111 | 157 | 0 |
330417 | 330417 | 2020-07-13 | Osage | Oklahoma | 40113 | 218 | 8 |
330418 | 330418 | 2020-07-13 | Ottawa | Oklahoma | 40115 | 157 | 2 |
330419 | 330419 | 2020-07-13 | Pawnee | Oklahoma | 40117 | 71 | 3 |
330420 | 330420 | 2020-07-13 | Payne | Oklahoma | 40119 | 481 | 2 |
330421 | 330421 | 2020-07-13 | Pittsburg | Oklahoma | 40121 | 76 | 3 |
330422 | 330422 | 2020-07-13 | Pontotoc | Oklahoma | 40123 | 72 | 2 |
330423 | 330423 | 2020-07-13 | Pottawatomie | Oklahoma | 40125 | 159 | 4 |
330424 | 330424 | 2020-07-13 | Pushmataha | Oklahoma | 40127 | 25 | 0 |
330425 | 330425 | 2020-07-13 | Rogers | Oklahoma | 40131 | 342 | 7 |
330426 | 330426 | 2020-07-13 | Seminole | Oklahoma | 40133 | 72 | 3 |
330427 | 330427 | 2020-07-13 | Sequoyah | Oklahoma | 40135 | 65 | 3 |
330428 | 330428 | 2020-07-13 | Stephens | Oklahoma | 40137 | 83 | 1 |
330429 | 330429 | 2020-07-13 | Texas | Oklahoma | 40139 | 1006 | 6 |
330430 | 330430 | 2020-07-13 | Tillman | Oklahoma | 40141 | 26 | 1 |
330431 | 330431 | 2020-07-13 | Tulsa | Oklahoma | 40143 | 5267 | 76 |
330432 | 330432 | 2020-07-13 | Wagoner | Oklahoma | 40145 | 376 | 19 |
330433 | 330433 | 2020-07-13 | Washington | Oklahoma | 40147 | 449 | 39 |
330434 | 330434 | 2020-07-13 | Washita | Oklahoma | 40149 | 8 | 0 |
330435 | 330435 | 2020-07-13 | Woods | Oklahoma | 40151 | 9 | 0 |
330436 | 330436 | 2020-07-13 | Woodward | Oklahoma | 40153 | 15 | 0 |
327174 | 327174 | 2020-07-12 | Adair | Oklahoma | 40001 | 137 | 4 |
327175 | 327175 | 2020-07-12 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
327176 | 327176 | 2020-07-12 | Atoka | Oklahoma | 40005 | 34 | 0 |
327177 | 327177 | 2020-07-12 | Beaver | Oklahoma | 40007 | 32 | 0 |
327178 | 327178 | 2020-07-12 | Beckham | Oklahoma | 40009 | 19 | 0 |
327179 | 327179 | 2020-07-12 | Blaine | Oklahoma | 40011 | 22 | 0 |
327180 | 327180 | 2020-07-12 | Bryan | Oklahoma | 40013 | 183 | 1 |
327181 | 327181 | 2020-07-12 | Caddo | Oklahoma | 40015 | 206 | 11 |
327182 | 327182 | 2020-07-12 | Canadian | Oklahoma | 40017 | 502 | 3 |
327183 | 327183 | 2020-07-12 | Carter | Oklahoma | 40019 | 182 | 2 |
327184 | 327184 | 2020-07-12 | Cherokee | Oklahoma | 40021 | 120 | 1 |
327185 | 327185 | 2020-07-12 | Choctaw | Oklahoma | 40023 | 122 | 1 |
327186 | 327186 | 2020-07-12 | Cimarron | Oklahoma | 40025 | 1 | 0 |
327187 | 327187 | 2020-07-12 | Cleveland | Oklahoma | 40027 | 1319 | 40 |
327188 | 327188 | 2020-07-12 | Coal | Oklahoma | 40029 | 10 | 0 |
327189 | 327189 | 2020-07-12 | Comanche | Oklahoma | 40031 | 498 | 9 |
327190 | 327190 | 2020-07-12 | Cotton | Oklahoma | 40033 | 11 | 2 |
327191 | 327191 | 2020-07-12 | Craig | Oklahoma | 40035 | 27 | 0 |
327192 | 327192 | 2020-07-12 | Creek | Oklahoma | 40037 | 212 | 8 |
327193 | 327193 | 2020-07-12 | Custer | Oklahoma | 40039 | 78 | 0 |
327194 | 327194 | 2020-07-12 | Delaware | Oklahoma | 40041 | 242 | 17 |
327195 | 327195 | 2020-07-12 | Dewey | Oklahoma | 40043 | 4 | 0 |
327196 | 327196 | 2020-07-12 | Ellis | Oklahoma | 40045 | 2 | 0 |
327197 | 327197 | 2020-07-12 | Garfield | Oklahoma | 40047 | 104 | 2 |
327198 | 327198 | 2020-07-12 | Garvin | Oklahoma | 40049 | 122 | 3 |
327199 | 327199 | 2020-07-12 | Grady | Oklahoma | 40051 | 241 | 5 |
327200 | 327200 | 2020-07-12 | Grant | Oklahoma | 40053 | 2 | 0 |
327201 | 327201 | 2020-07-12 | Greer | Oklahoma | 40055 | 68 | 7 |
327202 | 327202 | 2020-07-12 | Harmon | Oklahoma | 40057 | 3 | 0 |
327203 | 327203 | 2020-07-12 | Harper | Oklahoma | 40059 | 1 | 0 |
327204 | 327204 | 2020-07-12 | Haskell | Oklahoma | 40061 | 16 | 0 |
327205 | 327205 | 2020-07-12 | Hughes | Oklahoma | 40063 | 14 | 0 |
327206 | 327206 | 2020-07-12 | Jackson | Oklahoma | 40065 | 57 | 3 |
327207 | 327207 | 2020-07-12 | Jefferson | Oklahoma | 40067 | 16 | 0 |
327208 | 327208 | 2020-07-12 | Johnston | Oklahoma | 40069 | 16 | 0 |
327209 | 327209 | 2020-07-12 | Kay | Oklahoma | 40071 | 124 | 8 |
327210 | 327210 | 2020-07-12 | Kingfisher | Oklahoma | 40073 | 46 | 0 |
327211 | 327211 | 2020-07-12 | Kiowa | Oklahoma | 40075 | 16 | 1 |
327212 | 327212 | 2020-07-12 | Latimer | Oklahoma | 40077 | 20 | 1 |
327213 | 327213 | 2020-07-12 | Le Flore | Oklahoma | 40079 | 57 | 1 |
327214 | 327214 | 2020-07-12 | Lincoln | Oklahoma | 40081 | 44 | 2 |
327215 | 327215 | 2020-07-12 | Logan | Oklahoma | 40083 | 98 | 1 |
327216 | 327216 | 2020-07-12 | Love | Oklahoma | 40085 | 46 | 0 |
327217 | 327217 | 2020-07-12 | Major | Oklahoma | 40093 | 14 | 1 |
327218 | 327218 | 2020-07-12 | Marshall | Oklahoma | 40095 | 43 | 0 |
327219 | 327219 | 2020-07-12 | Mayes | Oklahoma | 40097 | 122 | 5 |
327220 | 327220 | 2020-07-12 | McClain | Oklahoma | 40087 | 238 | 4 |
327221 | 327221 | 2020-07-12 | McCurtain | Oklahoma | 40089 | 610 | 11 |
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);