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 397
- 40109 390
- 40065 389
- 40027 388
- 40071 388
- 40119 388
- 40017 387
- 40117 386
- 40039 384
- 40051 384
- 40083 384
- 40087 384
- 40147 384
- 40049 383
- 40101 381
- 40103 381
- 40123 380
- 40097 379
- 40145 379
- 40001 378
- 40013 378
- 40019 378
- 40037 378
- 40041 378
- 40113 378
- 40125 378
- 40137 378
- 40031 377
- 40035 377
- 40081 377
- …
county >30
- Tulsa 397
- Oklahoma 390
- Jackson 389
- Cleveland 388
- Kay 388
- Payne 388
- Canadian 387
- Pawnee 386
- Custer 384
- Grady 384
- Logan 384
- McClain 384
- Washington 384
- Garvin 383
- Muskogee 381
- Noble 381
- Pontotoc 380
- Mayes 379
- Wagoner 379
- Adair 378
- Bryan 378
- Carter 378
- Creek 378
- Delaware 378
- Osage 378
- Pottawatomie 378
- Stephens 378
- Comanche 377
- Craig 377
- Lincoln 377
- …
state 1
- Oklahoma · 28,567 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195258 | 1195258 | 2021-04-06 | Adair | Oklahoma | 40001 | 3151 | 26 |
1195259 | 1195259 | 2021-04-06 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1195260 | 1195260 | 2021-04-06 | Atoka | Oklahoma | 40005 | 1856 | 15 |
1195261 | 1195261 | 2021-04-06 | Beaver | Oklahoma | 40007 | 459 | 6 |
1195262 | 1195262 | 2021-04-06 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1195263 | 1195263 | 2021-04-06 | Blaine | Oklahoma | 40011 | 1016 | 9 |
1195264 | 1195264 | 2021-04-06 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1195265 | 1195265 | 2021-04-06 | Caddo | Oklahoma | 40015 | 3915 | 61 |
1195266 | 1195266 | 2021-04-06 | Canadian | Oklahoma | 40017 | 16434 | 106 |
1195267 | 1195267 | 2021-04-06 | Carter | Oklahoma | 40019 | 5937 | 65 |
1195268 | 1195268 | 2021-04-06 | Cherokee | Oklahoma | 40021 | 5558 | 47 |
1195269 | 1195269 | 2021-04-06 | Choctaw | Oklahoma | 40023 | 1601 | 16 |
1195270 | 1195270 | 2021-04-06 | Cimarron | Oklahoma | 40025 | 209 | 1 |
1195271 | 1195271 | 2021-04-06 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1195272 | 1195272 | 2021-04-06 | Coal | Oklahoma | 40029 | 689 | 14 |
1195273 | 1195273 | 2021-04-06 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1195274 | 1195274 | 2021-04-06 | Cotton | Oklahoma | 40033 | 666 | 14 |
1195275 | 1195275 | 2021-04-06 | Craig | Oklahoma | 40035 | 1936 | 12 |
1195276 | 1195276 | 2021-04-06 | Creek | Oklahoma | 40037 | 6757 | 124 |
1195277 | 1195277 | 2021-04-06 | Custer | Oklahoma | 40039 | 4058 | 73 |
1195278 | 1195278 | 2021-04-06 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1195279 | 1195279 | 2021-04-06 | Dewey | Oklahoma | 40043 | 543 | 6 |
1195280 | 1195280 | 2021-04-06 | Ellis | Oklahoma | 40045 | 354 | 3 |
1195281 | 1195281 | 2021-04-06 | Garfield | Oklahoma | 40047 | 7696 | 89 |
1195282 | 1195282 | 2021-04-06 | Garvin | Oklahoma | 40049 | 3539 | 56 |
1195283 | 1195283 | 2021-04-06 | Grady | Oklahoma | 40051 | 5809 | 88 |
1195284 | 1195284 | 2021-04-06 | Grant | Oklahoma | 40053 | 548 | 7 |
1195285 | 1195285 | 2021-04-06 | Greer | Oklahoma | 40055 | 571 | 17 |
1195286 | 1195286 | 2021-04-06 | Harmon | Oklahoma | 40057 | 307 | 3 |
1195287 | 1195287 | 2021-04-06 | Harper | Oklahoma | 40059 | 409 | 4 |
1195288 | 1195288 | 2021-04-06 | Haskell | Oklahoma | 40061 | 1240 | 11 |
1195289 | 1195289 | 2021-04-06 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1195290 | 1195290 | 2021-04-06 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1195291 | 1195291 | 2021-04-06 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1195292 | 1195292 | 2021-04-06 | Johnston | Oklahoma | 40069 | 1358 | 20 |
1195293 | 1195293 | 2021-04-06 | Kay | Oklahoma | 40071 | 5244 | 86 |
1195294 | 1195294 | 2021-04-06 | Kingfisher | Oklahoma | 40073 | 2023 | 27 |
1195295 | 1195295 | 2021-04-06 | Kiowa | Oklahoma | 40075 | 805 | 16 |
1195296 | 1195296 | 2021-04-06 | Latimer | Oklahoma | 40077 | 828 | 10 |
1195297 | 1195297 | 2021-04-06 | Le Flore | Oklahoma | 40079 | 5509 | 47 |
1195298 | 1195298 | 2021-04-06 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1195299 | 1195299 | 2021-04-06 | Logan | Oklahoma | 40083 | 4122 | 34 |
1195300 | 1195300 | 2021-04-06 | Love | Oklahoma | 40085 | 1457 | 13 |
1195301 | 1195301 | 2021-04-06 | Major | Oklahoma | 40093 | 949 | 13 |
1195302 | 1195302 | 2021-04-06 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1195303 | 1195303 | 2021-04-06 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1195304 | 1195304 | 2021-04-06 | McClain | Oklahoma | 40087 | 5153 | 57 |
1195305 | 1195305 | 2021-04-06 | McCurtain | Oklahoma | 40089 | 3887 | 71 |
1195306 | 1195306 | 2021-04-06 | McIntosh | Oklahoma | 40091 | 1971 | 39 |
1195307 | 1195307 | 2021-04-06 | Murray | Oklahoma | 40099 | 1957 | 23 |
1195308 | 1195308 | 2021-04-06 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1195309 | 1195309 | 2021-04-06 | Noble | Oklahoma | 40103 | 1370 | 16 |
1195310 | 1195310 | 2021-04-06 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1195311 | 1195311 | 2021-04-06 | Okfuskee | Oklahoma | 40107 | 1776 | 21 |
1195312 | 1195312 | 2021-04-06 | Oklahoma | Oklahoma | 40109 | 83647 | 837 |
1195313 | 1195313 | 2021-04-06 | Okmulgee | Oklahoma | 40111 | 3676 | 53 |
1195314 | 1195314 | 2021-04-06 | Osage | Oklahoma | 40113 | 4592 | 57 |
1195315 | 1195315 | 2021-04-06 | Ottawa | Oklahoma | 40115 | 3782 | 51 |
1195316 | 1195316 | 2021-04-06 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1195317 | 1195317 | 2021-04-06 | Payne | Oklahoma | 40119 | 8571 | 52 |
1195318 | 1195318 | 2021-04-06 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
1195319 | 1195319 | 2021-04-06 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1195320 | 1195320 | 2021-04-06 | Pottawatomie | Oklahoma | 40125 | 8140 | 86 |
1195321 | 1195321 | 2021-04-06 | Pushmataha | Oklahoma | 40127 | 1005 | 14 |
1195322 | 1195322 | 2021-04-06 | Roger Mills | Oklahoma | 40129 | 386 | 9 |
1195323 | 1195323 | 2021-04-06 | Rogers | Oklahoma | 40131 | 10199 | 131 |
1195324 | 1195324 | 2021-04-06 | Seminole | Oklahoma | 40133 | 2817 | 43 |
1195325 | 1195325 | 2021-04-06 | Sequoyah | Oklahoma | 40135 | 4051 | 35 |
1195326 | 1195326 | 2021-04-06 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1195327 | 1195327 | 2021-04-06 | Texas | Oklahoma | 40139 | 3490 | 27 |
1195328 | 1195328 | 2021-04-06 | Tillman | Oklahoma | 40141 | 780 | 16 |
1195329 | 1195329 | 2021-04-06 | Tulsa | Oklahoma | 40143 | 72684 | 794 |
1195330 | 1195330 | 2021-04-06 | Unknown | Oklahoma | 2289 | 0 | |
1195331 | 1195331 | 2021-04-06 | Wagoner | Oklahoma | 40145 | 7848 | 91 |
1195332 | 1195332 | 2021-04-06 | Washington | Oklahoma | 40147 | 5047 | 95 |
1195333 | 1195333 | 2021-04-06 | Washita | Oklahoma | 40149 | 1067 | 9 |
1195334 | 1195334 | 2021-04-06 | Woods | Oklahoma | 40151 | 1197 | 11 |
1195335 | 1195335 | 2021-04-06 | Woodward | Oklahoma | 40153 | 3129 | 21 |
1192010 | 1192010 | 2021-04-05 | Adair | Oklahoma | 40001 | 3151 | 26 |
1192011 | 1192011 | 2021-04-05 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1192012 | 1192012 | 2021-04-05 | Atoka | Oklahoma | 40005 | 1856 | 15 |
1192013 | 1192013 | 2021-04-05 | Beaver | Oklahoma | 40007 | 459 | 6 |
1192014 | 1192014 | 2021-04-05 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1192015 | 1192015 | 2021-04-05 | Blaine | Oklahoma | 40011 | 1016 | 9 |
1192016 | 1192016 | 2021-04-05 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1192017 | 1192017 | 2021-04-05 | Caddo | Oklahoma | 40015 | 3915 | 61 |
1192018 | 1192018 | 2021-04-05 | Canadian | Oklahoma | 40017 | 16434 | 106 |
1192019 | 1192019 | 2021-04-05 | Carter | Oklahoma | 40019 | 5937 | 65 |
1192020 | 1192020 | 2021-04-05 | Cherokee | Oklahoma | 40021 | 5558 | 47 |
1192021 | 1192021 | 2021-04-05 | Choctaw | Oklahoma | 40023 | 1601 | 16 |
1192022 | 1192022 | 2021-04-05 | Cimarron | Oklahoma | 40025 | 209 | 1 |
1192023 | 1192023 | 2021-04-05 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1192024 | 1192024 | 2021-04-05 | Coal | Oklahoma | 40029 | 689 | 14 |
1192025 | 1192025 | 2021-04-05 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1192026 | 1192026 | 2021-04-05 | Cotton | Oklahoma | 40033 | 666 | 14 |
1192027 | 1192027 | 2021-04-05 | Craig | Oklahoma | 40035 | 1936 | 12 |
1192028 | 1192028 | 2021-04-05 | Creek | Oklahoma | 40037 | 6757 | 124 |
1192029 | 1192029 | 2021-04-05 | Custer | Oklahoma | 40039 | 4058 | 73 |
1192030 | 1192030 | 2021-04-05 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1192031 | 1192031 | 2021-04-05 | Dewey | Oklahoma | 40043 | 543 | 6 |
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);