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 465
- 40109 458
- 40065 457
- 40071 456
- 40119 456
- 40027 455
- 40017 454
- 40117 454
- 40051 452
- 40083 452
- 40087 452
- 40147 452
- 40039 451
- 40049 451
- 40101 449
- 40103 449
- 40123 448
- 40097 447
- 40145 447
- 40113 446
- 40125 446
- 40137 446
- 40001 445
- 40013 445
- 40019 445
- 40037 445
- 40041 445
- 40081 445
- 40111 445
- 40115 445
- 40135 445
- 40031 444
- 40035 444
- 40077 444
- 40121 444
- 40015 443
- 40021 443
- 40023 443
- 40079 443
- 40105 443
- 40047 442
- 40131 442
- 40133 442
- 40139 442
- 40085 441
- 40009 440
- 40033 440
- 40055 439
- 40073 438
- 40075 438
- 40153 438
- 40005 437
- 40053 437
- 40089 437
- 40093 437
- 40141 436
- 40067 434
- 40095 433
- 40007 432
- 40043 432
- 40099 430
- 40107 430
- 40003 426
- 40069 426
- 40061 423
- 40091 423
- 40151 423
- 40059 422
- 40025 418
- 40127 413
- 40011 405
- 40149 396
- 40029 390
- 40063 381
- 40045 358
- 40057 348
- 40129 335
- - 306
county 78
- Tulsa 465
- Oklahoma 458
- Jackson 457
- Kay 456
- Payne 456
- Cleveland 455
- Canadian 454
- Pawnee 454
- Grady 452
- Logan 452
- McClain 452
- Washington 452
- Custer 451
- Garvin 451
- Muskogee 449
- Noble 449
- Pontotoc 448
- Mayes 447
- Wagoner 447
- Osage 446
- Pottawatomie 446
- Stephens 446
- Adair 445
- Bryan 445
- Carter 445
- Creek 445
- Delaware 445
- Lincoln 445
- Okmulgee 445
- Ottawa 445
- Sequoyah 445
- Comanche 444
- Craig 444
- Latimer 444
- Pittsburg 444
- Caddo 443
- Cherokee 443
- Choctaw 443
- Le Flore 443
- Nowata 443
- Garfield 442
- Rogers 442
- Seminole 442
- Texas 442
- Love 441
- Beckham 440
- Cotton 440
- Greer 439
- Kingfisher 438
- Kiowa 438
- Woodward 438
- Atoka 437
- Grant 437
- Major 437
- McCurtain 437
- Tillman 436
- Jefferson 434
- Marshall 433
- Beaver 432
- Dewey 432
- Murray 430
- Okfuskee 430
- Alfalfa 426
- Johnston 426
- Haskell 423
- McIntosh 423
- Woods 423
- Harper 422
- Cimarron 418
- Pushmataha 413
- Blaine 405
- Washita 396
- Coal 390
- Hughes 381
- Ellis 358
- Harmon 348
- Roger Mills 335
- Unknown 306
state 1
- Oklahoma · 33,849 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1416054 | 1416054 | 2021-06-13 | Ellis | Oklahoma | 40045 | 357 | 6 |
1416055 | 1416055 | 2021-06-13 | Garfield | Oklahoma | 40047 | 7815 | 139 |
1416056 | 1416056 | 2021-06-13 | Garvin | Oklahoma | 40049 | 3622 | 79 |
1416057 | 1416057 | 2021-06-13 | Grady | Oklahoma | 40051 | 5983 | 129 |
1416058 | 1416058 | 2021-06-13 | Grant | Oklahoma | 40053 | 549 | 7 |
1416059 | 1416059 | 2021-06-13 | Greer | Oklahoma | 40055 | 584 | 22 |
1416060 | 1416060 | 2021-06-13 | Harmon | Oklahoma | 40057 | 327 | 6 |
1416061 | 1416061 | 2021-06-13 | Harper | Oklahoma | 40059 | 420 | 8 |
1416062 | 1416062 | 2021-06-13 | Haskell | Oklahoma | 40061 | 1256 | 17 |
1416063 | 1416063 | 2021-06-13 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1416064 | 1416064 | 2021-06-13 | Jackson | Oklahoma | 40065 | 3131 | 56 |
1416065 | 1416065 | 2021-06-13 | Jefferson | Oklahoma | 40067 | 704 | 16 |
1416066 | 1416066 | 2021-06-13 | Johnston | Oklahoma | 40069 | 1380 | 37 |
1416067 | 1416067 | 2021-06-13 | Kay | Oklahoma | 40071 | 5342 | 128 |
1416068 | 1416068 | 2021-06-13 | Kingfisher | Oklahoma | 40073 | 2058 | 41 |
1416069 | 1416069 | 2021-06-13 | Kiowa | Oklahoma | 40075 | 819 | 26 |
1416070 | 1416070 | 2021-06-13 | Latimer | Oklahoma | 40077 | 843 | 13 |
1416071 | 1416071 | 2021-06-13 | Le Flore | Oklahoma | 40079 | 5635 | 67 |
1416072 | 1416072 | 2021-06-13 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1416073 | 1416073 | 2021-06-13 | Logan | Oklahoma | 40083 | 4305 | 65 |
1416074 | 1416074 | 2021-06-13 | Love | Oklahoma | 40085 | 1504 | 22 |
1416075 | 1416075 | 2021-06-13 | Major | Oklahoma | 40093 | 955 | 24 |
1416076 | 1416076 | 2021-06-13 | Marshall | Oklahoma | 40095 | 2048 | 23 |
1416077 | 1416077 | 2021-06-13 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1416078 | 1416078 | 2021-06-13 | McClain | Oklahoma | 40087 | 5325 | 73 |
1416079 | 1416079 | 2021-06-13 | McCurtain | Oklahoma | 40089 | 3986 | 94 |
1416080 | 1416080 | 2021-06-13 | McIntosh | Oklahoma | 40091 | 2015 | 61 |
1416081 | 1416081 | 2021-06-13 | Murray | Oklahoma | 40099 | 2026 | 44 |
1416082 | 1416082 | 2021-06-13 | Muskogee | Oklahoma | 40101 | 9371 | 176 |
1416083 | 1416083 | 2021-06-13 | Noble | Oklahoma | 40103 | 1380 | 20 |
1416084 | 1416084 | 2021-06-13 | Nowata | Oklahoma | 40105 | 1151 | 20 |
1416085 | 1416085 | 2021-06-13 | Okfuskee | Oklahoma | 40107 | 1797 | 32 |
1416086 | 1416086 | 2021-06-13 | Oklahoma | Oklahoma | 40109 | 87523 | 1301 |
1416087 | 1416087 | 2021-06-13 | Okmulgee | Oklahoma | 40111 | 3834 | 81 |
1416088 | 1416088 | 2021-06-13 | Osage | Oklahoma | 40113 | 4783 | 78 |
1416089 | 1416089 | 2021-06-13 | Ottawa | Oklahoma | 40115 | 3972 | 70 |
1416090 | 1416090 | 2021-06-13 | Pawnee | Oklahoma | 40117 | 1793 | 52 |
1416091 | 1416091 | 2021-06-13 | Payne | Oklahoma | 40119 | 8712 | 76 |
1416092 | 1416092 | 2021-06-13 | Pittsburg | Oklahoma | 40121 | 4657 | 78 |
1416093 | 1416093 | 2021-06-13 | Pontotoc | Oklahoma | 40123 | 5164 | 80 |
1416094 | 1416094 | 2021-06-13 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1416095 | 1416095 | 2021-06-13 | Pushmataha | Oklahoma | 40127 | 1011 | 22 |
1416096 | 1416096 | 2021-06-13 | Roger Mills | Oklahoma | 40129 | 390 | 12 |
1416097 | 1416097 | 2021-06-13 | Rogers | Oklahoma | 40131 | 10601 | 193 |
1416098 | 1416098 | 2021-06-13 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1416099 | 1416099 | 2021-06-13 | Sequoyah | Oklahoma | 40135 | 4154 | 56 |
1416100 | 1416100 | 2021-06-13 | Stephens | Oklahoma | 40137 | 4899 | 106 |
1416101 | 1416101 | 2021-06-13 | Texas | Oklahoma | 40139 | 3535 | 34 |
1416102 | 1416102 | 2021-06-13 | Tillman | Oklahoma | 40141 | 803 | 17 |
1416103 | 1416103 | 2021-06-13 | Tulsa | Oklahoma | 40143 | 75531 | 1113 |
1416104 | 1416104 | 2021-06-13 | Unknown | Oklahoma | 506 | 0 | |
1416105 | 1416105 | 2021-06-13 | Wagoner | Oklahoma | 40145 | 8199 | 121 |
1416106 | 1416106 | 2021-06-13 | Washington | Oklahoma | 40147 | 5250 | 117 |
1416107 | 1416107 | 2021-06-13 | Washita | Oklahoma | 40149 | 1087 | 23 |
1416108 | 1416108 | 2021-06-13 | Woods | Oklahoma | 40151 | 1216 | 18 |
1416109 | 1416109 | 2021-06-13 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1412786 | 1412786 | 2021-06-12 | Adair | Oklahoma | 40001 | 3198 | 43 |
1412787 | 1412787 | 2021-06-12 | Alfalfa | Oklahoma | 40003 | 1154 | 7 |
1412788 | 1412788 | 2021-06-12 | Atoka | Oklahoma | 40005 | 1878 | 26 |
1412789 | 1412789 | 2021-06-12 | Beaver | Oklahoma | 40007 | 475 | 6 |
1412790 | 1412790 | 2021-06-12 | Beckham | Oklahoma | 40009 | 2899 | 58 |
1412791 | 1412791 | 2021-06-12 | Blaine | Oklahoma | 40011 | 1047 | 20 |
1412792 | 1412792 | 2021-06-12 | Bryan | Oklahoma | 40013 | 6127 | 78 |
1412793 | 1412793 | 2021-06-12 | Caddo | Oklahoma | 40015 | 3982 | 96 |
1412794 | 1412794 | 2021-06-12 | Canadian | Oklahoma | 40017 | 17392 | 185 |
1412795 | 1412795 | 2021-06-12 | Carter | Oklahoma | 40019 | 6187 | 126 |
1412796 | 1412796 | 2021-06-12 | Cherokee | Oklahoma | 40021 | 5653 | 78 |
1412797 | 1412797 | 2021-06-12 | Choctaw | Oklahoma | 40023 | 1621 | 27 |
1412798 | 1412798 | 2021-06-12 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1412799 | 1412799 | 2021-06-12 | Cleveland | Oklahoma | 40027 | 31286 | 435 |
1412800 | 1412800 | 2021-06-12 | Coal | Oklahoma | 40029 | 701 | 15 |
1412801 | 1412801 | 2021-06-12 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1412802 | 1412802 | 2021-06-12 | Cotton | Oklahoma | 40033 | 695 | 16 |
1412803 | 1412803 | 2021-06-12 | Craig | Oklahoma | 40035 | 2000 | 18 |
1412804 | 1412804 | 2021-06-12 | Creek | Oklahoma | 40037 | 7024 | 165 |
1412805 | 1412805 | 2021-06-12 | Custer | Oklahoma | 40039 | 4084 | 104 |
1412806 | 1412806 | 2021-06-12 | Delaware | Oklahoma | 40041 | 4687 | 94 |
1412807 | 1412807 | 2021-06-12 | Dewey | Oklahoma | 40043 | 553 | 14 |
1412808 | 1412808 | 2021-06-12 | Ellis | Oklahoma | 40045 | 357 | 6 |
1412809 | 1412809 | 2021-06-12 | Garfield | Oklahoma | 40047 | 7815 | 139 |
1412810 | 1412810 | 2021-06-12 | Garvin | Oklahoma | 40049 | 3622 | 79 |
1412811 | 1412811 | 2021-06-12 | Grady | Oklahoma | 40051 | 5983 | 129 |
1412812 | 1412812 | 2021-06-12 | Grant | Oklahoma | 40053 | 549 | 7 |
1412813 | 1412813 | 2021-06-12 | Greer | Oklahoma | 40055 | 584 | 22 |
1412814 | 1412814 | 2021-06-12 | Harmon | Oklahoma | 40057 | 327 | 6 |
1412815 | 1412815 | 2021-06-12 | Harper | Oklahoma | 40059 | 420 | 8 |
1412816 | 1412816 | 2021-06-12 | Haskell | Oklahoma | 40061 | 1256 | 17 |
1412817 | 1412817 | 2021-06-12 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1412818 | 1412818 | 2021-06-12 | Jackson | Oklahoma | 40065 | 3131 | 56 |
1412819 | 1412819 | 2021-06-12 | Jefferson | Oklahoma | 40067 | 704 | 16 |
1412820 | 1412820 | 2021-06-12 | Johnston | Oklahoma | 40069 | 1380 | 37 |
1412821 | 1412821 | 2021-06-12 | Kay | Oklahoma | 40071 | 5342 | 128 |
1412822 | 1412822 | 2021-06-12 | Kingfisher | Oklahoma | 40073 | 2058 | 41 |
1412823 | 1412823 | 2021-06-12 | Kiowa | Oklahoma | 40075 | 819 | 26 |
1412824 | 1412824 | 2021-06-12 | Latimer | Oklahoma | 40077 | 843 | 13 |
1412825 | 1412825 | 2021-06-12 | Le Flore | Oklahoma | 40079 | 5635 | 67 |
1412826 | 1412826 | 2021-06-12 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1412827 | 1412827 | 2021-06-12 | Logan | Oklahoma | 40083 | 4305 | 65 |
1412828 | 1412828 | 2021-06-12 | Love | Oklahoma | 40085 | 1504 | 22 |
1412829 | 1412829 | 2021-06-12 | Major | Oklahoma | 40093 | 955 | 24 |
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);