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 679
- 40109 672
- 40065 671
- 40027 670
- 40071 670
- 40119 670
- 40017 669
- 40117 668
- 40039 666
- 40051 666
- 40083 666
- 40087 666
- 40147 666
- 40049 665
- 40101 663
- 40103 663
- 40123 662
- 40097 661
- 40145 661
- 40001 660
- 40013 660
- 40019 660
- 40037 660
- 40041 660
- 40113 660
- 40125 660
- 40137 660
- 40031 659
- 40035 659
- 40081 659
- …
county >30
- Tulsa 679
- Oklahoma 672
- Jackson 671
- Cleveland 670
- Kay 670
- Payne 670
- Canadian 669
- Pawnee 668
- Custer 666
- Grady 666
- Logan 666
- McClain 666
- Washington 666
- Garvin 665
- Muskogee 663
- Noble 663
- Pontotoc 662
- Mayes 661
- Wagoner 661
- Adair 660
- Bryan 660
- Carter 660
- Creek 660
- Delaware 660
- Osage 660
- Pottawatomie 660
- Stephens 660
- Comanche 659
- Craig 659
- Lincoln 659
- …
state 1
- Oklahoma · 50,563 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111282 | 2111282 | 2022-01-13 | Adair | Oklahoma | 40001 | 5459 | 64 |
2111283 | 2111283 | 2022-01-13 | Alfalfa | Oklahoma | 40003 | 1474 | 10 |
2111284 | 2111284 | 2022-01-13 | Atoka | Oklahoma | 40005 | 3018 | 41 |
2111285 | 2111285 | 2022-01-13 | Beaver | Oklahoma | 40007 | 745 | 10 |
2111286 | 2111286 | 2022-01-13 | Beckham | Oklahoma | 40009 | 4500 | 86 |
2111287 | 2111287 | 2022-01-13 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2111288 | 2111288 | 2022-01-13 | Bryan | Oklahoma | 40013 | 10376 | 119 |
2111289 | 2111289 | 2022-01-13 | Caddo | Oklahoma | 40015 | 6034 | 138 |
2111290 | 2111290 | 2022-01-13 | Canadian | Oklahoma | 40017 | 28798 | 319 |
2111291 | 2111291 | 2022-01-13 | Carter | Oklahoma | 40019 | 10350 | 202 |
2111292 | 2111292 | 2022-01-13 | Cherokee | Oklahoma | 40021 | 10182 | 129 |
2111293 | 2111293 | 2022-01-13 | Choctaw | Oklahoma | 40023 | 3000 | 52 |
2111294 | 2111294 | 2022-01-13 | Cimarron | Oklahoma | 40025 | 446 | 0 |
2111295 | 2111295 | 2022-01-13 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2111296 | 2111296 | 2022-01-13 | Coal | Oklahoma | 40029 | 1171 | 20 |
2111297 | 2111297 | 2022-01-13 | Comanche | Oklahoma | 40031 | 24300 | 335 |
2111298 | 2111298 | 2022-01-13 | Cotton | Oklahoma | 40033 | 1115 | 23 |
2111299 | 2111299 | 2022-01-13 | Craig | Oklahoma | 40035 | 3511 | 39 |
2111300 | 2111300 | 2022-01-13 | Creek | Oklahoma | 40037 | 13153 | 282 |
2111301 | 2111301 | 2022-01-13 | Custer | Oklahoma | 40039 | 6119 | 137 |
2111302 | 2111302 | 2022-01-13 | Delaware | Oklahoma | 40041 | 8334 | 172 |
2111303 | 2111303 | 2022-01-13 | Dewey | Oklahoma | 40043 | 860 | 24 |
2111304 | 2111304 | 2022-01-13 | Ellis | Oklahoma | 40045 | 604 | 6 |
2111305 | 2111305 | 2022-01-13 | Garfield | Oklahoma | 40047 | 11551 | 225 |
2111306 | 2111306 | 2022-01-13 | Garvin | Oklahoma | 40049 | 5430 | 112 |
2111307 | 2111307 | 2022-01-13 | Grady | Oklahoma | 40051 | 9967 | 204 |
2111308 | 2111308 | 2022-01-13 | Grant | Oklahoma | 40053 | 785 | 8 |
2111309 | 2111309 | 2022-01-13 | Greer | Oklahoma | 40055 | 894 | 28 |
2111310 | 2111310 | 2022-01-13 | Harmon | Oklahoma | 40057 | 413 | 9 |
2111311 | 2111311 | 2022-01-13 | Harper | Oklahoma | 40059 | 588 | 10 |
2111312 | 2111312 | 2022-01-13 | Haskell | Oklahoma | 40061 | 1991 | 32 |
2111313 | 2111313 | 2022-01-13 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2111314 | 2111314 | 2022-01-13 | Jackson | Oklahoma | 40065 | 4754 | 91 |
2111315 | 2111315 | 2022-01-13 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2111316 | 2111316 | 2022-01-13 | Johnston | Oklahoma | 40069 | 2212 | 49 |
2111317 | 2111317 | 2022-01-13 | Kay | Oklahoma | 40071 | 9136 | 176 |
2111318 | 2111318 | 2022-01-13 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2111319 | 2111319 | 2022-01-13 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2111320 | 2111320 | 2022-01-13 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2111321 | 2111321 | 2022-01-13 | Le Flore | Oklahoma | 40079 | 9177 | 96 |
2111322 | 2111322 | 2022-01-13 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2111323 | 2111323 | 2022-01-13 | Logan | Oklahoma | 40083 | 7980 | 134 |
2111324 | 2111324 | 2022-01-13 | Love | Oklahoma | 40085 | 2290 | 30 |
2111325 | 2111325 | 2022-01-13 | Major | Oklahoma | 40093 | 1722 | 34 |
2111326 | 2111326 | 2022-01-13 | Marshall | Oklahoma | 40095 | 3379 | 31 |
2111327 | 2111327 | 2022-01-13 | Mayes | Oklahoma | 40097 | 7495 | 133 |
2111328 | 2111328 | 2022-01-13 | McClain | Oklahoma | 40087 | 8768 | 106 |
2111329 | 2111329 | 2022-01-13 | McCurtain | Oklahoma | 40089 | 6329 | 140 |
2111330 | 2111330 | 2022-01-13 | McIntosh | Oklahoma | 40091 | 3417 | 106 |
2111331 | 2111331 | 2022-01-13 | Murray | Oklahoma | 40099 | 3053 | 57 |
2111332 | 2111332 | 2022-01-13 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2111333 | 2111333 | 2022-01-13 | Noble | Oklahoma | 40103 | 2124 | 33 |
2111334 | 2111334 | 2022-01-13 | Nowata | Oklahoma | 40105 | 2108 | 34 |
2111335 | 2111335 | 2022-01-13 | Okfuskee | Oklahoma | 40107 | 2646 | 49 |
2111336 | 2111336 | 2022-01-13 | Oklahoma | Oklahoma | 40109 | 146604 | 1997 |
2111337 | 2111337 | 2022-01-13 | Okmulgee | Oklahoma | 40111 | 7021 | 156 |
2111338 | 2111338 | 2022-01-13 | Osage | Oklahoma | 40113 | 8351 | 141 |
2111339 | 2111339 | 2022-01-13 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2111340 | 2111340 | 2022-01-13 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2111341 | 2111341 | 2022-01-13 | Payne | Oklahoma | 40119 | 13546 | 127 |
2111342 | 2111342 | 2022-01-13 | Pittsburg | Oklahoma | 40121 | 7734 | 175 |
2111343 | 2111343 | 2022-01-13 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2111344 | 2111344 | 2022-01-13 | Pottawatomie | Oklahoma | 40125 | 14797 | 227 |
2111345 | 2111345 | 2022-01-13 | Pushmataha | Oklahoma | 40127 | 1961 | 42 |
2111346 | 2111346 | 2022-01-13 | Roger Mills | Oklahoma | 40129 | 723 | 13 |
2111347 | 2111347 | 2022-01-13 | Rogers | Oklahoma | 40131 | 18858 | 319 |
2111348 | 2111348 | 2022-01-13 | Seminole | Oklahoma | 40133 | 4514 | 107 |
2111349 | 2111349 | 2022-01-13 | Sequoyah | Oklahoma | 40135 | 7608 | 94 |
2111350 | 2111350 | 2022-01-13 | Stephens | Oklahoma | 40137 | 8662 | 159 |
2111351 | 2111351 | 2022-01-13 | Texas | Oklahoma | 40139 | 4830 | 44 |
2111352 | 2111352 | 2022-01-13 | Tillman | Oklahoma | 40141 | 1177 | 29 |
2111353 | 2111353 | 2022-01-13 | Tulsa | Oklahoma | 40143 | 126355 | 1829 |
2111354 | 2111354 | 2022-01-13 | Unknown | Oklahoma | 20739 | 3 | |
2111355 | 2111355 | 2022-01-13 | Wagoner | Oklahoma | 40145 | 16111 | 226 |
2111356 | 2111356 | 2022-01-13 | Washington | Oklahoma | 40147 | 9503 | 215 |
2111357 | 2111357 | 2022-01-13 | Washita | Oklahoma | 40149 | 1956 | 35 |
2111358 | 2111358 | 2022-01-13 | Woods | Oklahoma | 40151 | 1871 | 30 |
2111359 | 2111359 | 2022-01-13 | Woodward | Oklahoma | 40153 | 4364 | 57 |
2108030 | 2108030 | 2022-01-12 | Adair | Oklahoma | 40001 | 5459 | 64 |
2108031 | 2108031 | 2022-01-12 | Alfalfa | Oklahoma | 40003 | 1474 | 10 |
2108032 | 2108032 | 2022-01-12 | Atoka | Oklahoma | 40005 | 3018 | 41 |
2108033 | 2108033 | 2022-01-12 | Beaver | Oklahoma | 40007 | 745 | 10 |
2108034 | 2108034 | 2022-01-12 | Beckham | Oklahoma | 40009 | 4500 | 86 |
2108035 | 2108035 | 2022-01-12 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2108036 | 2108036 | 2022-01-12 | Bryan | Oklahoma | 40013 | 10376 | 119 |
2108037 | 2108037 | 2022-01-12 | Caddo | Oklahoma | 40015 | 6034 | 138 |
2108038 | 2108038 | 2022-01-12 | Canadian | Oklahoma | 40017 | 28798 | 319 |
2108039 | 2108039 | 2022-01-12 | Carter | Oklahoma | 40019 | 10350 | 202 |
2108040 | 2108040 | 2022-01-12 | Cherokee | Oklahoma | 40021 | 10182 | 129 |
2108041 | 2108041 | 2022-01-12 | Choctaw | Oklahoma | 40023 | 3000 | 52 |
2108042 | 2108042 | 2022-01-12 | Cimarron | Oklahoma | 40025 | 446 | 0 |
2108043 | 2108043 | 2022-01-12 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2108044 | 2108044 | 2022-01-12 | Coal | Oklahoma | 40029 | 1171 | 20 |
2108045 | 2108045 | 2022-01-12 | Comanche | Oklahoma | 40031 | 24300 | 335 |
2108046 | 2108046 | 2022-01-12 | Cotton | Oklahoma | 40033 | 1115 | 23 |
2108047 | 2108047 | 2022-01-12 | Craig | Oklahoma | 40035 | 3511 | 39 |
2108048 | 2108048 | 2022-01-12 | Creek | Oklahoma | 40037 | 13153 | 282 |
2108049 | 2108049 | 2022-01-12 | Custer | Oklahoma | 40039 | 6119 | 137 |
2108050 | 2108050 | 2022-01-12 | Delaware | Oklahoma | 40041 | 8334 | 172 |
2108051 | 2108051 | 2022-01-12 | Dewey | Oklahoma | 40043 | 860 | 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);