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 78
- 40143 466
- 40109 459
- 40065 458
- 40027 457
- 40071 457
- 40119 457
- 40017 456
- 40117 455
- 40039 453
- 40051 453
- 40083 453
- 40087 453
- 40147 453
- 40049 452
- 40101 450
- 40103 450
- 40123 449
- 40097 448
- 40145 448
- 40001 447
- 40013 447
- 40019 447
- 40037 447
- 40041 447
- 40113 447
- 40125 447
- 40137 447
- 40031 446
- 40035 446
- 40081 446
- 40111 446
- 40115 446
- 40135 446
- 40015 445
- 40021 445
- 40023 445
- 40077 445
- 40121 445
- 40079 444
- 40105 444
- 40047 443
- 40131 443
- 40133 443
- 40139 443
- 40009 442
- 40033 442
- 40085 442
- 40055 440
- 40005 439
- 40073 439
- 40075 439
- 40153 439
- 40053 438
- 40089 438
- 40093 438
- 40141 437
- 40067 435
- 40007 434
- 40043 434
- 40095 434
- 40099 431
- 40107 431
- 40003 428
- 40069 427
- 40061 424
- 40091 424
- 40151 424
- 40059 423
- 40025 420
- 40127 414
- 40011 407
- 40149 397
- 40029 392
- 40063 382
- 40045 359
- 40057 349
- 40129 336
- - 307
county 78
- Tulsa 466
- Oklahoma 459
- Jackson 458
- Cleveland 457
- Kay 457
- Payne 457
- Canadian 456
- Pawnee 455
- Custer 453
- Grady 453
- Logan 453
- McClain 453
- Washington 453
- Garvin 452
- Muskogee 450
- Noble 450
- Pontotoc 449
- Mayes 448
- Wagoner 448
- Adair 447
- Bryan 447
- Carter 447
- Creek 447
- Delaware 447
- Osage 447
- Pottawatomie 447
- Stephens 447
- Comanche 446
- Craig 446
- Lincoln 446
- Okmulgee 446
- Ottawa 446
- Sequoyah 446
- Caddo 445
- Cherokee 445
- Choctaw 445
- Latimer 445
- Pittsburg 445
- Le Flore 444
- Nowata 444
- Garfield 443
- Rogers 443
- Seminole 443
- Texas 443
- Beckham 442
- Cotton 442
- Love 442
- Greer 440
- Atoka 439
- Kingfisher 439
- Kiowa 439
- Woodward 439
- Grant 438
- Major 438
- McCurtain 438
- Tillman 437
- Jefferson 435
- Beaver 434
- Dewey 434
- Marshall 434
- Murray 431
- Okfuskee 431
- Alfalfa 428
- Johnston 427
- Haskell 424
- McIntosh 424
- Woods 424
- Harper 423
- Cimarron 420
- Pushmataha 414
- Blaine 407
- Washita 397
- Coal 392
- Hughes 382
- Ellis 359
- Harmon 349
- Roger Mills 336
- Unknown 307
state 1
- Oklahoma · 33,949 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419277 | 1419277 | 2021-06-14 | Adair | Oklahoma | 40001 | 3198 | 43 |
1419278 | 1419278 | 2021-06-14 | Alfalfa | Oklahoma | 40003 | 1154 | 7 |
1419279 | 1419279 | 2021-06-14 | Atoka | Oklahoma | 40005 | 1878 | 26 |
1419280 | 1419280 | 2021-06-14 | Beaver | Oklahoma | 40007 | 475 | 6 |
1419281 | 1419281 | 2021-06-14 | Beckham | Oklahoma | 40009 | 2899 | 58 |
1419282 | 1419282 | 2021-06-14 | Blaine | Oklahoma | 40011 | 1047 | 20 |
1419283 | 1419283 | 2021-06-14 | Bryan | Oklahoma | 40013 | 6127 | 78 |
1419284 | 1419284 | 2021-06-14 | Caddo | Oklahoma | 40015 | 3982 | 96 |
1419285 | 1419285 | 2021-06-14 | Canadian | Oklahoma | 40017 | 17392 | 185 |
1419286 | 1419286 | 2021-06-14 | Carter | Oklahoma | 40019 | 6187 | 126 |
1419287 | 1419287 | 2021-06-14 | Cherokee | Oklahoma | 40021 | 5653 | 78 |
1419288 | 1419288 | 2021-06-14 | Choctaw | Oklahoma | 40023 | 1621 | 27 |
1419289 | 1419289 | 2021-06-14 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1419290 | 1419290 | 2021-06-14 | Cleveland | Oklahoma | 40027 | 31286 | 435 |
1419291 | 1419291 | 2021-06-14 | Coal | Oklahoma | 40029 | 701 | 15 |
1419292 | 1419292 | 2021-06-14 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1419293 | 1419293 | 2021-06-14 | Cotton | Oklahoma | 40033 | 695 | 16 |
1419294 | 1419294 | 2021-06-14 | Craig | Oklahoma | 40035 | 2000 | 18 |
1419295 | 1419295 | 2021-06-14 | Creek | Oklahoma | 40037 | 7024 | 165 |
1419296 | 1419296 | 2021-06-14 | Custer | Oklahoma | 40039 | 4084 | 104 |
1419297 | 1419297 | 2021-06-14 | Delaware | Oklahoma | 40041 | 4687 | 94 |
1419298 | 1419298 | 2021-06-14 | Dewey | Oklahoma | 40043 | 553 | 14 |
1419299 | 1419299 | 2021-06-14 | Ellis | Oklahoma | 40045 | 357 | 6 |
1419300 | 1419300 | 2021-06-14 | Garfield | Oklahoma | 40047 | 7815 | 139 |
1419301 | 1419301 | 2021-06-14 | Garvin | Oklahoma | 40049 | 3622 | 79 |
1419302 | 1419302 | 2021-06-14 | Grady | Oklahoma | 40051 | 5983 | 129 |
1419303 | 1419303 | 2021-06-14 | Grant | Oklahoma | 40053 | 549 | 7 |
1419304 | 1419304 | 2021-06-14 | Greer | Oklahoma | 40055 | 584 | 22 |
1419305 | 1419305 | 2021-06-14 | Harmon | Oklahoma | 40057 | 327 | 6 |
1419306 | 1419306 | 2021-06-14 | Harper | Oklahoma | 40059 | 420 | 8 |
1419307 | 1419307 | 2021-06-14 | Haskell | Oklahoma | 40061 | 1256 | 17 |
1419308 | 1419308 | 2021-06-14 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1419309 | 1419309 | 2021-06-14 | Jackson | Oklahoma | 40065 | 3131 | 56 |
1419310 | 1419310 | 2021-06-14 | Jefferson | Oklahoma | 40067 | 704 | 16 |
1419311 | 1419311 | 2021-06-14 | Johnston | Oklahoma | 40069 | 1380 | 37 |
1419312 | 1419312 | 2021-06-14 | Kay | Oklahoma | 40071 | 5342 | 128 |
1419313 | 1419313 | 2021-06-14 | Kingfisher | Oklahoma | 40073 | 2058 | 41 |
1419314 | 1419314 | 2021-06-14 | Kiowa | Oklahoma | 40075 | 819 | 26 |
1419315 | 1419315 | 2021-06-14 | Latimer | Oklahoma | 40077 | 843 | 13 |
1419316 | 1419316 | 2021-06-14 | Le Flore | Oklahoma | 40079 | 5635 | 67 |
1419317 | 1419317 | 2021-06-14 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1419318 | 1419318 | 2021-06-14 | Logan | Oklahoma | 40083 | 4305 | 65 |
1419319 | 1419319 | 2021-06-14 | Love | Oklahoma | 40085 | 1504 | 22 |
1419320 | 1419320 | 2021-06-14 | Major | Oklahoma | 40093 | 955 | 24 |
1419321 | 1419321 | 2021-06-14 | Marshall | Oklahoma | 40095 | 2048 | 23 |
1419322 | 1419322 | 2021-06-14 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1419323 | 1419323 | 2021-06-14 | McClain | Oklahoma | 40087 | 5325 | 73 |
1419324 | 1419324 | 2021-06-14 | McCurtain | Oklahoma | 40089 | 3986 | 94 |
1419325 | 1419325 | 2021-06-14 | McIntosh | Oklahoma | 40091 | 2015 | 61 |
1419326 | 1419326 | 2021-06-14 | Murray | Oklahoma | 40099 | 2026 | 44 |
1419327 | 1419327 | 2021-06-14 | Muskogee | Oklahoma | 40101 | 9371 | 176 |
1419328 | 1419328 | 2021-06-14 | Noble | Oklahoma | 40103 | 1380 | 20 |
1419329 | 1419329 | 2021-06-14 | Nowata | Oklahoma | 40105 | 1151 | 20 |
1419330 | 1419330 | 2021-06-14 | Okfuskee | Oklahoma | 40107 | 1797 | 32 |
1419331 | 1419331 | 2021-06-14 | Oklahoma | Oklahoma | 40109 | 87523 | 1301 |
1419332 | 1419332 | 2021-06-14 | Okmulgee | Oklahoma | 40111 | 3834 | 81 |
1419333 | 1419333 | 2021-06-14 | Osage | Oklahoma | 40113 | 4783 | 78 |
1419334 | 1419334 | 2021-06-14 | Ottawa | Oklahoma | 40115 | 3972 | 70 |
1419335 | 1419335 | 2021-06-14 | Pawnee | Oklahoma | 40117 | 1793 | 52 |
1419336 | 1419336 | 2021-06-14 | Payne | Oklahoma | 40119 | 8712 | 76 |
1419337 | 1419337 | 2021-06-14 | Pittsburg | Oklahoma | 40121 | 4657 | 78 |
1419338 | 1419338 | 2021-06-14 | Pontotoc | Oklahoma | 40123 | 5164 | 80 |
1419339 | 1419339 | 2021-06-14 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1419340 | 1419340 | 2021-06-14 | Pushmataha | Oklahoma | 40127 | 1011 | 22 |
1419341 | 1419341 | 2021-06-14 | Roger Mills | Oklahoma | 40129 | 390 | 12 |
1419342 | 1419342 | 2021-06-14 | Rogers | Oklahoma | 40131 | 10601 | 193 |
1419343 | 1419343 | 2021-06-14 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1419344 | 1419344 | 2021-06-14 | Sequoyah | Oklahoma | 40135 | 4154 | 56 |
1419345 | 1419345 | 2021-06-14 | Stephens | Oklahoma | 40137 | 4899 | 106 |
1419346 | 1419346 | 2021-06-14 | Texas | Oklahoma | 40139 | 3535 | 34 |
1419347 | 1419347 | 2021-06-14 | Tillman | Oklahoma | 40141 | 803 | 17 |
1419348 | 1419348 | 2021-06-14 | Tulsa | Oklahoma | 40143 | 75531 | 1113 |
1419349 | 1419349 | 2021-06-14 | Unknown | Oklahoma | 996 | 0 | |
1419350 | 1419350 | 2021-06-14 | Wagoner | Oklahoma | 40145 | 8199 | 121 |
1419351 | 1419351 | 2021-06-14 | Washington | Oklahoma | 40147 | 5250 | 117 |
1419352 | 1419352 | 2021-06-14 | Washita | Oklahoma | 40149 | 1087 | 23 |
1419353 | 1419353 | 2021-06-14 | Woods | Oklahoma | 40151 | 1216 | 18 |
1419354 | 1419354 | 2021-06-14 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1416032 | 1416032 | 2021-06-13 | Adair | Oklahoma | 40001 | 3198 | 43 |
1416033 | 1416033 | 2021-06-13 | Alfalfa | Oklahoma | 40003 | 1154 | 7 |
1416034 | 1416034 | 2021-06-13 | Atoka | Oklahoma | 40005 | 1878 | 26 |
1416035 | 1416035 | 2021-06-13 | Beaver | Oklahoma | 40007 | 475 | 6 |
1416036 | 1416036 | 2021-06-13 | Beckham | Oklahoma | 40009 | 2899 | 58 |
1416037 | 1416037 | 2021-06-13 | Blaine | Oklahoma | 40011 | 1047 | 20 |
1416038 | 1416038 | 2021-06-13 | Bryan | Oklahoma | 40013 | 6127 | 78 |
1416039 | 1416039 | 2021-06-13 | Caddo | Oklahoma | 40015 | 3982 | 96 |
1416040 | 1416040 | 2021-06-13 | Canadian | Oklahoma | 40017 | 17392 | 185 |
1416041 | 1416041 | 2021-06-13 | Carter | Oklahoma | 40019 | 6187 | 126 |
1416042 | 1416042 | 2021-06-13 | Cherokee | Oklahoma | 40021 | 5653 | 78 |
1416043 | 1416043 | 2021-06-13 | Choctaw | Oklahoma | 40023 | 1621 | 27 |
1416044 | 1416044 | 2021-06-13 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1416045 | 1416045 | 2021-06-13 | Cleveland | Oklahoma | 40027 | 31286 | 435 |
1416046 | 1416046 | 2021-06-13 | Coal | Oklahoma | 40029 | 701 | 15 |
1416047 | 1416047 | 2021-06-13 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1416048 | 1416048 | 2021-06-13 | Cotton | Oklahoma | 40033 | 695 | 16 |
1416049 | 1416049 | 2021-06-13 | Craig | Oklahoma | 40035 | 2000 | 18 |
1416050 | 1416050 | 2021-06-13 | Creek | Oklahoma | 40037 | 7024 | 165 |
1416051 | 1416051 | 2021-06-13 | Custer | Oklahoma | 40039 | 4084 | 104 |
1416052 | 1416052 | 2021-06-13 | Delaware | Oklahoma | 40041 | 4687 | 94 |
1416053 | 1416053 | 2021-06-13 | Dewey | Oklahoma | 40043 | 553 | 14 |
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);