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 366
- 40109 359
- 40065 358
- 40071 357
- 40119 357
- 40027 356
- 40017 355
- 40117 355
- 40051 353
- 40083 353
- 40087 353
- 40147 353
- 40039 352
- 40049 352
- 40101 350
- 40103 350
- 40123 349
- 40097 348
- 40145 348
- 40113 347
- 40125 347
- 40137 347
- 40001 346
- 40013 346
- 40019 346
- 40037 346
- 40041 346
- 40081 346
- 40111 346
- 40115 346
- …
county >30
- Tulsa 366
- Oklahoma 359
- Jackson 358
- Kay 357
- Payne 357
- Cleveland 356
- Canadian 355
- Pawnee 355
- Grady 353
- Logan 353
- McClain 353
- Washington 353
- Custer 352
- Garvin 352
- Muskogee 350
- Noble 350
- Pontotoc 349
- Mayes 348
- Wagoner 348
- Osage 347
- Pottawatomie 347
- Stephens 347
- Adair 346
- Bryan 346
- Carter 346
- Creek 346
- Delaware 346
- Lincoln 346
- Okmulgee 346
- Ottawa 346
- …
state 1
- Oklahoma · 26,127 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1094623 | 1094623 | 2021-03-06 | Ellis | Oklahoma | 40045 | 352 | 3 |
1094624 | 1094624 | 2021-03-06 | Garfield | Oklahoma | 40047 | 7610 | 78 |
1094625 | 1094625 | 2021-03-06 | Garvin | Oklahoma | 40049 | 3475 | 52 |
1094626 | 1094626 | 2021-03-06 | Grady | Oklahoma | 40051 | 5687 | 76 |
1094627 | 1094627 | 2021-03-06 | Grant | Oklahoma | 40053 | 538 | 7 |
1094628 | 1094628 | 2021-03-06 | Greer | Oklahoma | 40055 | 538 | 17 |
1094629 | 1094629 | 2021-03-06 | Harmon | Oklahoma | 40057 | 290 | 3 |
1094630 | 1094630 | 2021-03-06 | Harper | Oklahoma | 40059 | 407 | 4 |
1094631 | 1094631 | 2021-03-06 | Haskell | Oklahoma | 40061 | 1229 | 11 |
1094632 | 1094632 | 2021-03-06 | Hughes | Oklahoma | 40063 | 1169 | 17 |
1094633 | 1094633 | 2021-03-06 | Jackson | Oklahoma | 40065 | 2955 | 44 |
1094634 | 1094634 | 2021-03-06 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1094635 | 1094635 | 2021-03-06 | Johnston | Oklahoma | 40069 | 1334 | 20 |
1094636 | 1094636 | 2021-03-06 | Kay | Oklahoma | 40071 | 5100 | 81 |
1094637 | 1094637 | 2021-03-06 | Kingfisher | Oklahoma | 40073 | 1996 | 24 |
1094638 | 1094638 | 2021-03-06 | Kiowa | Oklahoma | 40075 | 799 | 16 |
1094639 | 1094639 | 2021-03-06 | Latimer | Oklahoma | 40077 | 815 | 9 |
1094640 | 1094640 | 2021-03-06 | Le Flore | Oklahoma | 40079 | 5422 | 44 |
1094641 | 1094641 | 2021-03-06 | Lincoln | Oklahoma | 40081 | 3095 | 54 |
1094642 | 1094642 | 2021-03-06 | Logan | Oklahoma | 40083 | 4015 | 28 |
1094643 | 1094643 | 2021-03-06 | Love | Oklahoma | 40085 | 1432 | 12 |
1094644 | 1094644 | 2021-03-06 | Major | Oklahoma | 40093 | 940 | 12 |
1094645 | 1094645 | 2021-03-06 | Marshall | Oklahoma | 40095 | 1872 | 12 |
1094646 | 1094646 | 2021-03-06 | Mayes | Oklahoma | 40097 | 4037 | 38 |
1094647 | 1094647 | 2021-03-06 | McClain | Oklahoma | 40087 | 5061 | 50 |
1094648 | 1094648 | 2021-03-06 | McCurtain | Oklahoma | 40089 | 3835 | 64 |
1094649 | 1094649 | 2021-03-06 | McIntosh | Oklahoma | 40091 | 1940 | 35 |
1094650 | 1094650 | 2021-03-06 | Murray | Oklahoma | 40099 | 1926 | 22 |
1094651 | 1094651 | 2021-03-06 | Muskogee | Oklahoma | 40101 | 9132 | 106 |
1094652 | 1094652 | 2021-03-06 | Noble | Oklahoma | 40103 | 1356 | 13 |
1094653 | 1094653 | 2021-03-06 | Nowata | Oklahoma | 40105 | 1112 | 16 |
1094654 | 1094654 | 2021-03-06 | Okfuskee | Oklahoma | 40107 | 1766 | 20 |
1094655 | 1094655 | 2021-03-06 | Oklahoma | Oklahoma | 40109 | 81597 | 758 |
1094656 | 1094656 | 2021-03-06 | Okmulgee | Oklahoma | 40111 | 3640 | 50 |
1094657 | 1094657 | 2021-03-06 | Osage | Oklahoma | 40113 | 4510 | 52 |
1094658 | 1094658 | 2021-03-06 | Ottawa | Oklahoma | 40115 | 3642 | 46 |
1094659 | 1094659 | 2021-03-06 | Pawnee | Oklahoma | 40117 | 1729 | 33 |
1094660 | 1094660 | 2021-03-06 | Payne | Oklahoma | 40119 | 8428 | 47 |
1094661 | 1094661 | 2021-03-06 | Pittsburg | Oklahoma | 40121 | 4473 | 39 |
1094662 | 1094662 | 2021-03-06 | Pontotoc | Oklahoma | 40123 | 4969 | 48 |
1094663 | 1094663 | 2021-03-06 | Pottawatomie | Oklahoma | 40125 | 7970 | 79 |
1094664 | 1094664 | 2021-03-06 | Pushmataha | Oklahoma | 40127 | 995 | 14 |
1094665 | 1094665 | 2021-03-06 | Roger Mills | Oklahoma | 40129 | 383 | 7 |
1094666 | 1094666 | 2021-03-06 | Rogers | Oklahoma | 40131 | 9967 | 119 |
1094667 | 1094667 | 2021-03-06 | Seminole | Oklahoma | 40133 | 2774 | 39 |
1094668 | 1094668 | 2021-03-06 | Sequoyah | Oklahoma | 40135 | 3980 | 31 |
1094669 | 1094669 | 2021-03-06 | Stephens | Oklahoma | 40137 | 4703 | 68 |
1094670 | 1094670 | 2021-03-06 | Texas | Oklahoma | 40139 | 3456 | 24 |
1094671 | 1094671 | 2021-03-06 | Tillman | Oklahoma | 40141 | 756 | 14 |
1094672 | 1094672 | 2021-03-06 | Tulsa | Oklahoma | 40143 | 71481 | 723 |
1094673 | 1094673 | 2021-03-06 | Unknown | Oklahoma | 8 | 0 | |
1094674 | 1094674 | 2021-03-06 | Wagoner | Oklahoma | 40145 | 7742 | 83 |
1094675 | 1094675 | 2021-03-06 | Washington | Oklahoma | 40147 | 4877 | 89 |
1094676 | 1094676 | 2021-03-06 | Washita | Oklahoma | 40149 | 1057 | 9 |
1094677 | 1094677 | 2021-03-06 | Woods | Oklahoma | 40151 | 1187 | 11 |
1094678 | 1094678 | 2021-03-06 | Woodward | Oklahoma | 40153 | 3095 | 18 |
1091355 | 1091355 | 2021-03-05 | Adair | Oklahoma | 40001 | 3104 | 25 |
1091356 | 1091356 | 2021-03-05 | Alfalfa | Oklahoma | 40003 | 1149 | 5 |
1091357 | 1091357 | 2021-03-05 | Atoka | Oklahoma | 40005 | 1774 | 13 |
1091358 | 1091358 | 2021-03-05 | Beaver | Oklahoma | 40007 | 440 | 6 |
1091359 | 1091359 | 2021-03-05 | Beckham | Oklahoma | 40009 | 2793 | 37 |
1091360 | 1091360 | 2021-03-05 | Blaine | Oklahoma | 40011 | 1003 | 8 |
1091361 | 1091361 | 2021-03-05 | Bryan | Oklahoma | 40013 | 5933 | 56 |
1091362 | 1091362 | 2021-03-05 | Caddo | Oklahoma | 40015 | 3838 | 58 |
1091363 | 1091363 | 2021-03-05 | Canadian | Oklahoma | 40017 | 16026 | 97 |
1091364 | 1091364 | 2021-03-05 | Carter | Oklahoma | 40019 | 5747 | 60 |
1091365 | 1091365 | 2021-03-05 | Cherokee | Oklahoma | 40021 | 5440 | 44 |
1091366 | 1091366 | 2021-03-05 | Choctaw | Oklahoma | 40023 | 1569 | 14 |
1091367 | 1091367 | 2021-03-05 | Cimarron | Oklahoma | 40025 | 198 | 1 |
1091368 | 1091368 | 2021-03-05 | Cleveland | Oklahoma | 40027 | 28905 | 274 |
1091369 | 1091369 | 2021-03-05 | Coal | Oklahoma | 40029 | 684 | 14 |
1091370 | 1091370 | 2021-03-05 | Comanche | Oklahoma | 40031 | 12179 | 140 |
1091371 | 1091371 | 2021-03-05 | Cotton | Oklahoma | 40033 | 653 | 13 |
1091372 | 1091372 | 2021-03-05 | Craig | Oklahoma | 40035 | 1897 | 11 |
1091373 | 1091373 | 2021-03-05 | Creek | Oklahoma | 40037 | 6608 | 117 |
1091374 | 1091374 | 2021-03-05 | Custer | Oklahoma | 40039 | 4026 | 72 |
1091375 | 1091375 | 2021-03-05 | Delaware | Oklahoma | 40041 | 4384 | 62 |
1091376 | 1091376 | 2021-03-05 | Dewey | Oklahoma | 40043 | 536 | 6 |
1091377 | 1091377 | 2021-03-05 | Ellis | Oklahoma | 40045 | 352 | 3 |
1091378 | 1091378 | 2021-03-05 | Garfield | Oklahoma | 40047 | 7599 | 78 |
1091379 | 1091379 | 2021-03-05 | Garvin | Oklahoma | 40049 | 3472 | 52 |
1091380 | 1091380 | 2021-03-05 | Grady | Oklahoma | 40051 | 5682 | 76 |
1091381 | 1091381 | 2021-03-05 | Grant | Oklahoma | 40053 | 538 | 7 |
1091382 | 1091382 | 2021-03-05 | Greer | Oklahoma | 40055 | 537 | 17 |
1091383 | 1091383 | 2021-03-05 | Harmon | Oklahoma | 40057 | 290 | 3 |
1091384 | 1091384 | 2021-03-05 | Harper | Oklahoma | 40059 | 407 | 4 |
1091385 | 1091385 | 2021-03-05 | Haskell | Oklahoma | 40061 | 1226 | 11 |
1091386 | 1091386 | 2021-03-05 | Hughes | Oklahoma | 40063 | 1163 | 17 |
1091387 | 1091387 | 2021-03-05 | Jackson | Oklahoma | 40065 | 2951 | 44 |
1091388 | 1091388 | 2021-03-05 | Jefferson | Oklahoma | 40067 | 672 | 12 |
1091389 | 1091389 | 2021-03-05 | Johnston | Oklahoma | 40069 | 1334 | 20 |
1091390 | 1091390 | 2021-03-05 | Kay | Oklahoma | 40071 | 5098 | 81 |
1091391 | 1091391 | 2021-03-05 | Kingfisher | Oklahoma | 40073 | 1996 | 24 |
1091392 | 1091392 | 2021-03-05 | Kiowa | Oklahoma | 40075 | 796 | 16 |
1091393 | 1091393 | 2021-03-05 | Latimer | Oklahoma | 40077 | 812 | 9 |
1091394 | 1091394 | 2021-03-05 | Le Flore | Oklahoma | 40079 | 5400 | 44 |
1091395 | 1091395 | 2021-03-05 | Lincoln | Oklahoma | 40081 | 3092 | 54 |
1091396 | 1091396 | 2021-03-05 | Logan | Oklahoma | 40083 | 4003 | 28 |
1091397 | 1091397 | 2021-03-05 | Love | Oklahoma | 40085 | 1429 | 12 |
1091398 | 1091398 | 2021-03-05 | Major | Oklahoma | 40093 | 940 | 12 |
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);