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 588
- 40109 581
- 40065 580
- 40071 579
- 40119 579
- 40027 578
- 40017 577
- 40117 577
- 40051 575
- 40083 575
- 40087 575
- 40147 575
- 40039 574
- 40049 574
- 40101 572
- 40103 572
- 40123 571
- 40097 570
- 40145 570
- 40113 569
- 40125 569
- 40137 569
- 40001 568
- 40013 568
- 40019 568
- 40037 568
- 40041 568
- 40081 568
- 40111 568
- 40115 568
- …
county >30
- Tulsa 588
- Oklahoma 581
- Jackson 580
- Kay 579
- Payne 579
- Cleveland 578
- Canadian 577
- Pawnee 577
- Grady 575
- Logan 575
- McClain 575
- Washington 575
- Custer 574
- Garvin 574
- Muskogee 572
- Noble 572
- Pontotoc 571
- Mayes 570
- Wagoner 570
- Osage 569
- Pottawatomie 569
- Stephens 569
- Adair 568
- Bryan 568
- Carter 568
- Creek 568
- Delaware 568
- Lincoln 568
- Okmulgee 568
- Ottawa 568
- …
state 1
- Oklahoma · 43,443 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815538 | 1815538 | 2021-10-14 | Ellis | Oklahoma | 40045 | 437 | 6 |
1815539 | 1815539 | 2021-10-14 | Garfield | Oklahoma | 40047 | 9849 | 157 |
1815540 | 1815540 | 2021-10-14 | Garvin | Oklahoma | 40049 | 4659 | 95 |
1815541 | 1815541 | 2021-10-14 | Grady | Oklahoma | 40051 | 7911 | 156 |
1815542 | 1815542 | 2021-10-14 | Grant | Oklahoma | 40053 | 690 | 7 |
1815543 | 1815543 | 2021-10-14 | Greer | Oklahoma | 40055 | 739 | 23 |
1815544 | 1815544 | 2021-10-14 | Harmon | Oklahoma | 40057 | 360 | 6 |
1815545 | 1815545 | 2021-10-14 | Harper | Oklahoma | 40059 | 484 | 8 |
1815546 | 1815546 | 2021-10-14 | Haskell | Oklahoma | 40061 | 1829 | 26 |
1815547 | 1815547 | 2021-10-14 | Hughes | Oklahoma | 40063 | 1658 | 37 |
1815548 | 1815548 | 2021-10-14 | Jackson | Oklahoma | 40065 | 3808 | 67 |
1815549 | 1815549 | 2021-10-14 | Jefferson | Oklahoma | 40067 | 920 | 18 |
1815550 | 1815550 | 2021-10-14 | Johnston | Oklahoma | 40069 | 1915 | 44 |
1815551 | 1815551 | 2021-10-14 | Kay | Oklahoma | 40071 | 7044 | 148 |
1815552 | 1815552 | 2021-10-14 | Kingfisher | Oklahoma | 40073 | 2544 | 44 |
1815553 | 1815553 | 2021-10-14 | Kiowa | Oklahoma | 40075 | 1117 | 30 |
1815554 | 1815554 | 2021-10-14 | Latimer | Oklahoma | 40077 | 1451 | 14 |
1815555 | 1815555 | 2021-10-14 | Le Flore | Oklahoma | 40079 | 7885 | 77 |
1815556 | 1815556 | 2021-10-14 | Lincoln | Oklahoma | 40081 | 4769 | 101 |
1815557 | 1815557 | 2021-10-14 | Logan | Oklahoma | 40083 | 5975 | 97 |
1815558 | 1815558 | 2021-10-14 | Love | Oklahoma | 40085 | 1970 | 26 |
1815559 | 1815559 | 2021-10-14 | Major | Oklahoma | 40093 | 1219 | 28 |
1815560 | 1815560 | 2021-10-14 | Marshall | Oklahoma | 40095 | 2681 | 26 |
1815561 | 1815561 | 2021-10-14 | Mayes | Oklahoma | 40097 | 6642 | 105 |
1815562 | 1815562 | 2021-10-14 | McClain | Oklahoma | 40087 | 7325 | 92 |
1815563 | 1815563 | 2021-10-14 | McCurtain | Oklahoma | 40089 | 5603 | 113 |
1815564 | 1815564 | 2021-10-14 | McIntosh | Oklahoma | 40091 | 2831 | 80 |
1815565 | 1815565 | 2021-10-14 | Murray | Oklahoma | 40099 | 2574 | 51 |
1815566 | 1815566 | 2021-10-14 | Muskogee | Oklahoma | 40101 | 13176 | 243 |
1815567 | 1815567 | 2021-10-14 | Noble | Oklahoma | 40103 | 1865 | 28 |
1815568 | 1815568 | 2021-10-14 | Nowata | Oklahoma | 40105 | 1760 | 24 |
1815569 | 1815569 | 2021-10-14 | Okfuskee | Oklahoma | 40107 | 2273 | 34 |
1815570 | 1815570 | 2021-10-14 | Oklahoma | Oklahoma | 40109 | 117180 | 1577 |
1815571 | 1815571 | 2021-10-14 | Okmulgee | Oklahoma | 40111 | 5767 | 119 |
1815572 | 1815572 | 2021-10-14 | Osage | Oklahoma | 40113 | 6765 | 117 |
1815573 | 1815573 | 2021-10-14 | Ottawa | Oklahoma | 40115 | 5970 | 90 |
1815574 | 1815574 | 2021-10-14 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1815575 | 1815575 | 2021-10-14 | Payne | Oklahoma | 40119 | 11775 | 100 |
1815576 | 1815576 | 2021-10-14 | Pittsburg | Oklahoma | 40121 | 6569 | 108 |
1815577 | 1815577 | 2021-10-14 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1815578 | 1815578 | 2021-10-14 | Pottawatomie | Oklahoma | 40125 | 11809 | 173 |
1815579 | 1815579 | 2021-10-14 | Pushmataha | Oklahoma | 40127 | 1747 | 34 |
1815580 | 1815580 | 2021-10-14 | Roger Mills | Oklahoma | 40129 | 487 | 12 |
1815581 | 1815581 | 2021-10-14 | Rogers | Oklahoma | 40131 | 15443 | 260 |
1815582 | 1815582 | 2021-10-14 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1815583 | 1815583 | 2021-10-14 | Sequoyah | Oklahoma | 40135 | 6606 | 79 |
1815584 | 1815584 | 2021-10-14 | Stephens | Oklahoma | 40137 | 7364 | 122 |
1815585 | 1815585 | 2021-10-14 | Texas | Oklahoma | 40139 | 3998 | 37 |
1815586 | 1815586 | 2021-10-14 | Tillman | Oklahoma | 40141 | 972 | 21 |
1815587 | 1815587 | 2021-10-14 | Tulsa | Oklahoma | 40143 | 105510 | 1505 |
1815588 | 1815588 | 2021-10-14 | Unknown | Oklahoma | 3252 | 0 | |
1815589 | 1815589 | 2021-10-14 | Wagoner | Oklahoma | 40145 | 12429 | 191 |
1815590 | 1815590 | 2021-10-14 | Washington | Oklahoma | 40147 | 8310 | 183 |
1815591 | 1815591 | 2021-10-14 | Washita | Oklahoma | 40149 | 1454 | 25 |
1815592 | 1815592 | 2021-10-14 | Woods | Oklahoma | 40151 | 1599 | 22 |
1815593 | 1815593 | 2021-10-14 | Woodward | Oklahoma | 40153 | 3681 | 43 |
1812268 | 1812268 | 2021-10-13 | Adair | Oklahoma | 40001 | 4818 | 57 |
1812269 | 1812269 | 2021-10-13 | Alfalfa | Oklahoma | 40003 | 1290 | 7 |
1812270 | 1812270 | 2021-10-13 | Atoka | Oklahoma | 40005 | 2698 | 30 |
1812271 | 1812271 | 2021-10-13 | Beaver | Oklahoma | 40007 | 550 | 6 |
1812272 | 1812272 | 2021-10-13 | Beckham | Oklahoma | 40009 | 3382 | 63 |
1812273 | 1812273 | 2021-10-13 | Blaine | Oklahoma | 40011 | 1477 | 26 |
1812274 | 1812274 | 2021-10-13 | Bryan | Oklahoma | 40013 | 8479 | 103 |
1812275 | 1812275 | 2021-10-13 | Caddo | Oklahoma | 40015 | 5094 | 114 |
1812276 | 1812276 | 2021-10-13 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1812277 | 1812277 | 2021-10-13 | Carter | Oklahoma | 40019 | 8805 | 158 |
1812278 | 1812278 | 2021-10-13 | Cherokee | Oklahoma | 40021 | 8912 | 103 |
1812279 | 1812279 | 2021-10-13 | Choctaw | Oklahoma | 40023 | 2701 | 43 |
1812280 | 1812280 | 2021-10-13 | Cimarron | Oklahoma | 40025 | 306 | 2 |
1812281 | 1812281 | 2021-10-13 | Cleveland | Oklahoma | 40027 | 42536 | 540 |
1812282 | 1812282 | 2021-10-13 | Coal | Oklahoma | 40029 | 1027 | 19 |
1812283 | 1812283 | 2021-10-13 | Comanche | Oklahoma | 40031 | 20807 | 269 |
1812284 | 1812284 | 2021-10-13 | Cotton | Oklahoma | 40033 | 951 | 20 |
1812285 | 1812285 | 2021-10-13 | Craig | Oklahoma | 40035 | 2950 | 29 |
1812286 | 1812286 | 2021-10-13 | Creek | Oklahoma | 40037 | 10901 | 231 |
1812287 | 1812287 | 2021-10-13 | Custer | Oklahoma | 40039 | 4902 | 115 |
1812288 | 1812288 | 2021-10-13 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1812289 | 1812289 | 2021-10-13 | Dewey | Oklahoma | 40043 | 659 | 16 |
1812290 | 1812290 | 2021-10-13 | Ellis | Oklahoma | 40045 | 437 | 6 |
1812291 | 1812291 | 2021-10-13 | Garfield | Oklahoma | 40047 | 9849 | 157 |
1812292 | 1812292 | 2021-10-13 | Garvin | Oklahoma | 40049 | 4659 | 95 |
1812293 | 1812293 | 2021-10-13 | Grady | Oklahoma | 40051 | 7911 | 156 |
1812294 | 1812294 | 2021-10-13 | Grant | Oklahoma | 40053 | 690 | 7 |
1812295 | 1812295 | 2021-10-13 | Greer | Oklahoma | 40055 | 739 | 23 |
1812296 | 1812296 | 2021-10-13 | Harmon | Oklahoma | 40057 | 360 | 6 |
1812297 | 1812297 | 2021-10-13 | Harper | Oklahoma | 40059 | 484 | 8 |
1812298 | 1812298 | 2021-10-13 | Haskell | Oklahoma | 40061 | 1829 | 26 |
1812299 | 1812299 | 2021-10-13 | Hughes | Oklahoma | 40063 | 1658 | 37 |
1812300 | 1812300 | 2021-10-13 | Jackson | Oklahoma | 40065 | 3808 | 67 |
1812301 | 1812301 | 2021-10-13 | Jefferson | Oklahoma | 40067 | 920 | 18 |
1812302 | 1812302 | 2021-10-13 | Johnston | Oklahoma | 40069 | 1915 | 44 |
1812303 | 1812303 | 2021-10-13 | Kay | Oklahoma | 40071 | 7044 | 148 |
1812304 | 1812304 | 2021-10-13 | Kingfisher | Oklahoma | 40073 | 2544 | 44 |
1812305 | 1812305 | 2021-10-13 | Kiowa | Oklahoma | 40075 | 1117 | 30 |
1812306 | 1812306 | 2021-10-13 | Latimer | Oklahoma | 40077 | 1451 | 14 |
1812307 | 1812307 | 2021-10-13 | Le Flore | Oklahoma | 40079 | 7885 | 77 |
1812308 | 1812308 | 2021-10-13 | Lincoln | Oklahoma | 40081 | 4769 | 101 |
1812309 | 1812309 | 2021-10-13 | Logan | Oklahoma | 40083 | 5975 | 97 |
1812310 | 1812310 | 2021-10-13 | Love | Oklahoma | 40085 | 1970 | 26 |
1812311 | 1812311 | 2021-10-13 | Major | Oklahoma | 40093 | 1219 | 28 |
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);