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 131
- 40109 124
- 40065 123
- 40027 122
- 40071 122
- 40119 122
- 40017 121
- 40117 120
- 40039 118
- 40051 118
- 40083 118
- 40087 118
- 40147 118
- 40049 117
- 40101 115
- 40103 115
- 40123 114
- 40097 113
- 40145 113
- 40001 112
- 40013 112
- 40019 112
- 40037 112
- 40041 112
- 40113 112
- 40125 112
- 40137 112
- 40031 111
- 40035 111
- 40081 111
- …
county >30
- Tulsa 131
- Oklahoma 124
- Jackson 123
- Cleveland 122
- Kay 122
- Payne 122
- Canadian 121
- Pawnee 120
- Custer 118
- Grady 118
- Logan 118
- McClain 118
- Washington 118
- Garvin 117
- Muskogee 115
- Noble 115
- Pontotoc 114
- Mayes 113
- Wagoner 113
- Adair 112
- Bryan 112
- Carter 112
- Creek 112
- Delaware 112
- Osage 112
- Pottawatomie 112
- Stephens 112
- Comanche 111
- Craig 111
- Lincoln 111
- …
state 1
- Oklahoma · 7,851 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333553 | 333553 | 2020-07-14 | Adair | Oklahoma | 40001 | 144 | 4 |
333554 | 333554 | 2020-07-14 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
333555 | 333555 | 2020-07-14 | Atoka | Oklahoma | 40005 | 42 | 0 |
333556 | 333556 | 2020-07-14 | Beaver | Oklahoma | 40007 | 32 | 0 |
333557 | 333557 | 2020-07-14 | Beckham | Oklahoma | 40009 | 22 | 0 |
333558 | 333558 | 2020-07-14 | Blaine | Oklahoma | 40011 | 22 | 0 |
333559 | 333559 | 2020-07-14 | Bryan | Oklahoma | 40013 | 190 | 1 |
333560 | 333560 | 2020-07-14 | Caddo | Oklahoma | 40015 | 210 | 11 |
333561 | 333561 | 2020-07-14 | Canadian | Oklahoma | 40017 | 543 | 3 |
333562 | 333562 | 2020-07-14 | Carter | Oklahoma | 40019 | 186 | 2 |
333563 | 333563 | 2020-07-14 | Cherokee | Oklahoma | 40021 | 131 | 1 |
333564 | 333564 | 2020-07-14 | Choctaw | Oklahoma | 40023 | 128 | 1 |
333565 | 333565 | 2020-07-14 | Cimarron | Oklahoma | 40025 | 1 | 0 |
333566 | 333566 | 2020-07-14 | Cleveland | Oklahoma | 40027 | 1448 | 40 |
333567 | 333567 | 2020-07-14 | Coal | Oklahoma | 40029 | 12 | 0 |
333568 | 333568 | 2020-07-14 | Comanche | Oklahoma | 40031 | 517 | 9 |
333569 | 333569 | 2020-07-14 | Cotton | Oklahoma | 40033 | 12 | 2 |
333570 | 333570 | 2020-07-14 | Craig | Oklahoma | 40035 | 27 | 0 |
333571 | 333571 | 2020-07-14 | Creek | Oklahoma | 40037 | 223 | 8 |
333572 | 333572 | 2020-07-14 | Custer | Oklahoma | 40039 | 85 | 0 |
333573 | 333573 | 2020-07-14 | Delaware | Oklahoma | 40041 | 261 | 17 |
333574 | 333574 | 2020-07-14 | Dewey | Oklahoma | 40043 | 4 | 0 |
333575 | 333575 | 2020-07-14 | Ellis | Oklahoma | 40045 | 2 | 0 |
333576 | 333576 | 2020-07-14 | Garfield | Oklahoma | 40047 | 132 | 2 |
333577 | 333577 | 2020-07-14 | Garvin | Oklahoma | 40049 | 133 | 3 |
333578 | 333578 | 2020-07-14 | Grady | Oklahoma | 40051 | 254 | 5 |
333579 | 333579 | 2020-07-14 | Grant | Oklahoma | 40053 | 3 | 0 |
333580 | 333580 | 2020-07-14 | Greer | Oklahoma | 40055 | 69 | 7 |
333581 | 333581 | 2020-07-14 | Harmon | Oklahoma | 40057 | 3 | 0 |
333582 | 333582 | 2020-07-14 | Harper | Oklahoma | 40059 | 2 | 0 |
333583 | 333583 | 2020-07-14 | Haskell | Oklahoma | 40061 | 17 | 0 |
333584 | 333584 | 2020-07-14 | Hughes | Oklahoma | 40063 | 15 | 0 |
333585 | 333585 | 2020-07-14 | Jackson | Oklahoma | 40065 | 72 | 3 |
333586 | 333586 | 2020-07-14 | Jefferson | Oklahoma | 40067 | 18 | 0 |
333587 | 333587 | 2020-07-14 | Johnston | Oklahoma | 40069 | 18 | 0 |
333588 | 333588 | 2020-07-14 | Kay | Oklahoma | 40071 | 129 | 8 |
333589 | 333589 | 2020-07-14 | Kingfisher | Oklahoma | 40073 | 50 | 0 |
333590 | 333590 | 2020-07-14 | Kiowa | Oklahoma | 40075 | 17 | 1 |
333591 | 333591 | 2020-07-14 | Latimer | Oklahoma | 40077 | 22 | 1 |
333592 | 333592 | 2020-07-14 | Le Flore | Oklahoma | 40079 | 63 | 1 |
333593 | 333593 | 2020-07-14 | Lincoln | Oklahoma | 40081 | 47 | 2 |
333594 | 333594 | 2020-07-14 | Logan | Oklahoma | 40083 | 101 | 1 |
333595 | 333595 | 2020-07-14 | Love | Oklahoma | 40085 | 48 | 0 |
333596 | 333596 | 2020-07-14 | Major | Oklahoma | 40093 | 15 | 1 |
333597 | 333597 | 2020-07-14 | Marshall | Oklahoma | 40095 | 47 | 0 |
333598 | 333598 | 2020-07-14 | Mayes | Oklahoma | 40097 | 139 | 5 |
333599 | 333599 | 2020-07-14 | McClain | Oklahoma | 40087 | 261 | 4 |
333600 | 333600 | 2020-07-14 | McCurtain | Oklahoma | 40089 | 631 | 12 |
333601 | 333601 | 2020-07-14 | McIntosh | Oklahoma | 40091 | 88 | 1 |
333602 | 333602 | 2020-07-14 | Murray | Oklahoma | 40099 | 25 | 0 |
333603 | 333603 | 2020-07-14 | Muskogee | Oklahoma | 40101 | 216 | 14 |
333604 | 333604 | 2020-07-14 | Noble | Oklahoma | 40103 | 53 | 1 |
333605 | 333605 | 2020-07-14 | Nowata | Oklahoma | 40105 | 39 | 1 |
333606 | 333606 | 2020-07-14 | Okfuskee | Oklahoma | 40107 | 20 | 0 |
333607 | 333607 | 2020-07-14 | Oklahoma | Oklahoma | 40109 | 5259 | 75 |
333608 | 333608 | 2020-07-14 | Okmulgee | Oklahoma | 40111 | 186 | 0 |
333609 | 333609 | 2020-07-14 | Osage | Oklahoma | 40113 | 221 | 8 |
333610 | 333610 | 2020-07-14 | Ottawa | Oklahoma | 40115 | 183 | 2 |
333611 | 333611 | 2020-07-14 | Pawnee | Oklahoma | 40117 | 73 | 3 |
333612 | 333612 | 2020-07-14 | Payne | Oklahoma | 40119 | 484 | 2 |
333613 | 333613 | 2020-07-14 | Pittsburg | Oklahoma | 40121 | 81 | 3 |
333614 | 333614 | 2020-07-14 | Pontotoc | Oklahoma | 40123 | 82 | 2 |
333615 | 333615 | 2020-07-14 | Pottawatomie | Oklahoma | 40125 | 172 | 4 |
333616 | 333616 | 2020-07-14 | Pushmataha | Oklahoma | 40127 | 31 | 0 |
333617 | 333617 | 2020-07-14 | Rogers | Oklahoma | 40131 | 359 | 7 |
333618 | 333618 | 2020-07-14 | Seminole | Oklahoma | 40133 | 78 | 3 |
333619 | 333619 | 2020-07-14 | Sequoyah | Oklahoma | 40135 | 70 | 3 |
333620 | 333620 | 2020-07-14 | Stephens | Oklahoma | 40137 | 89 | 1 |
333621 | 333621 | 2020-07-14 | Texas | Oklahoma | 40139 | 1006 | 6 |
333622 | 333622 | 2020-07-14 | Tillman | Oklahoma | 40141 | 25 | 1 |
333623 | 333623 | 2020-07-14 | Tulsa | Oklahoma | 40143 | 5448 | 78 |
333624 | 333624 | 2020-07-14 | Wagoner | Oklahoma | 40145 | 400 | 19 |
333625 | 333625 | 2020-07-14 | Washington | Oklahoma | 40147 | 465 | 39 |
333626 | 333626 | 2020-07-14 | Washita | Oklahoma | 40149 | 10 | 0 |
333627 | 333627 | 2020-07-14 | Woods | Oklahoma | 40151 | 11 | 0 |
333628 | 333628 | 2020-07-14 | Woodward | Oklahoma | 40153 | 15 | 0 |
330361 | 330361 | 2020-07-13 | Adair | Oklahoma | 40001 | 137 | 4 |
330362 | 330362 | 2020-07-13 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
330363 | 330363 | 2020-07-13 | Atoka | Oklahoma | 40005 | 34 | 0 |
330364 | 330364 | 2020-07-13 | Beaver | Oklahoma | 40007 | 32 | 0 |
330365 | 330365 | 2020-07-13 | Beckham | Oklahoma | 40009 | 22 | 0 |
330366 | 330366 | 2020-07-13 | Blaine | Oklahoma | 40011 | 22 | 0 |
330367 | 330367 | 2020-07-13 | Bryan | Oklahoma | 40013 | 184 | 1 |
330368 | 330368 | 2020-07-13 | Caddo | Oklahoma | 40015 | 208 | 11 |
330369 | 330369 | 2020-07-13 | Canadian | Oklahoma | 40017 | 519 | 3 |
330370 | 330370 | 2020-07-13 | Carter | Oklahoma | 40019 | 182 | 2 |
330371 | 330371 | 2020-07-13 | Cherokee | Oklahoma | 40021 | 121 | 1 |
330372 | 330372 | 2020-07-13 | Choctaw | Oklahoma | 40023 | 126 | 1 |
330373 | 330373 | 2020-07-13 | Cimarron | Oklahoma | 40025 | 1 | 0 |
330374 | 330374 | 2020-07-13 | Cleveland | Oklahoma | 40027 | 1348 | 40 |
330375 | 330375 | 2020-07-13 | Coal | Oklahoma | 40029 | 11 | 0 |
330376 | 330376 | 2020-07-13 | Comanche | Oklahoma | 40031 | 502 | 9 |
330377 | 330377 | 2020-07-13 | Cotton | Oklahoma | 40033 | 11 | 2 |
330378 | 330378 | 2020-07-13 | Craig | Oklahoma | 40035 | 27 | 0 |
330379 | 330379 | 2020-07-13 | Creek | Oklahoma | 40037 | 217 | 8 |
330380 | 330380 | 2020-07-13 | Custer | Oklahoma | 40039 | 78 | 0 |
330381 | 330381 | 2020-07-13 | Delaware | Oklahoma | 40041 | 244 | 17 |
330382 | 330382 | 2020-07-13 | Dewey | Oklahoma | 40043 | 4 | 0 |
330383 | 330383 | 2020-07-13 | Ellis | Oklahoma | 40045 | 2 | 0 |
330384 | 330384 | 2020-07-13 | Garfield | Oklahoma | 40047 | 108 | 2 |
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);