ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-21" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1640083 | 1640083 | 2021-08-21 | Adair | Oklahoma | 40001 | 3931 | 47 |
1640084 | 1640084 | 2021-08-21 | Alfalfa | Oklahoma | 40003 | 1195 | 7 |
1640085 | 1640085 | 2021-08-21 | Atoka | Oklahoma | 40005 | 2142 | 28 |
1640086 | 1640086 | 2021-08-21 | Beaver | Oklahoma | 40007 | 482 | 6 |
1640087 | 1640087 | 2021-08-21 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1640088 | 1640088 | 2021-08-21 | Blaine | Oklahoma | 40011 | 1134 | 21 |
1640089 | 1640089 | 2021-08-21 | Bryan | Oklahoma | 40013 | 7087 | 80 |
1640090 | 1640090 | 2021-08-21 | Caddo | Oklahoma | 40015 | 4343 | 97 |
1640091 | 1640091 | 2021-08-21 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1640092 | 1640092 | 2021-08-21 | Carter | Oklahoma | 40019 | 7252 | 133 |
1640093 | 1640093 | 2021-08-21 | Cherokee | Oklahoma | 40021 | 6717 | 80 |
1640094 | 1640094 | 2021-08-21 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1640095 | 1640095 | 2021-08-21 | Cimarron | Oklahoma | 40025 | 263 | 2 |
1640096 | 1640096 | 2021-08-21 | Cleveland | Oklahoma | 40027 | 34799 | 457 |
1640097 | 1640097 | 2021-08-21 | Coal | Oklahoma | 40029 | 804 | 15 |
1640098 | 1640098 | 2021-08-21 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1640099 | 1640099 | 2021-08-21 | Cotton | Oklahoma | 40033 | 754 | 16 |
1640100 | 1640100 | 2021-08-21 | Craig | Oklahoma | 40035 | 2522 | 21 |
1640101 | 1640101 | 2021-08-21 | Creek | Oklahoma | 40037 | 8480 | 171 |
1640102 | 1640102 | 2021-08-21 | Custer | Oklahoma | 40039 | 4329 | 106 |
1640103 | 1640103 | 2021-08-21 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1640104 | 1640104 | 2021-08-21 | Dewey | Oklahoma | 40043 | 590 | 14 |
1640105 | 1640105 | 2021-08-21 | Ellis | Oklahoma | 40045 | 376 | 6 |
1640106 | 1640106 | 2021-08-21 | Garfield | Oklahoma | 40047 | 8288 | 140 |
1640107 | 1640107 | 2021-08-21 | Garvin | Oklahoma | 40049 | 3991 | 81 |
1640108 | 1640108 | 2021-08-21 | Grady | Oklahoma | 40051 | 6562 | 133 |
1640109 | 1640109 | 2021-08-21 | Grant | Oklahoma | 40053 | 594 | 7 |
1640110 | 1640110 | 2021-08-21 | Greer | Oklahoma | 40055 | 608 | 22 |
1640111 | 1640111 | 2021-08-21 | Harmon | Oklahoma | 40057 | 341 | 6 |
1640112 | 1640112 | 2021-08-21 | Harper | Oklahoma | 40059 | 430 | 8 |
1640113 | 1640113 | 2021-08-21 | Haskell | Oklahoma | 40061 | 1489 | 19 |
1640114 | 1640114 | 2021-08-21 | Hughes | Oklahoma | 40063 | 1379 | 30 |
1640115 | 1640115 | 2021-08-21 | Jackson | Oklahoma | 40065 | 3292 | 56 |
1640116 | 1640116 | 2021-08-21 | Jefferson | Oklahoma | 40067 | 763 | 18 |
1640117 | 1640117 | 2021-08-21 | Johnston | Oklahoma | 40069 | 1593 | 38 |
1640118 | 1640118 | 2021-08-21 | Kay | Oklahoma | 40071 | 5795 | 132 |
1640119 | 1640119 | 2021-08-21 | Kingfisher | Oklahoma | 40073 | 2225 | 42 |
1640120 | 1640120 | 2021-08-21 | Kiowa | Oklahoma | 40075 | 892 | 27 |
1640121 | 1640121 | 2021-08-21 | Latimer | Oklahoma | 40077 | 1011 | 13 |
1640122 | 1640122 | 2021-08-21 | Le Flore | Oklahoma | 40079 | 6441 | 71 |
1640123 | 1640123 | 2021-08-21 | Lincoln | Oklahoma | 40081 | 3756 | 76 |
1640124 | 1640124 | 2021-08-21 | Logan | Oklahoma | 40083 | 4756 | 67 |
1640125 | 1640125 | 2021-08-21 | Love | Oklahoma | 40085 | 1677 | 23 |
1640126 | 1640126 | 2021-08-21 | Major | Oklahoma | 40093 | 1019 | 24 |
1640127 | 1640127 | 2021-08-21 | Marshall | Oklahoma | 40095 | 2289 | 24 |
1640128 | 1640128 | 2021-08-21 | Mayes | Oklahoma | 40097 | 5205 | 77 |
1640129 | 1640129 | 2021-08-21 | McClain | Oklahoma | 40087 | 6093 | 75 |
1640130 | 1640130 | 2021-08-21 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1640131 | 1640131 | 2021-08-21 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1640132 | 1640132 | 2021-08-21 | Murray | Oklahoma | 40099 | 2243 | 45 |
1640133 | 1640133 | 2021-08-21 | Muskogee | Oklahoma | 40101 | 10804 | 189 |
1640134 | 1640134 | 2021-08-21 | Noble | Oklahoma | 40103 | 1536 | 22 |
1640135 | 1640135 | 2021-08-21 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1640136 | 1640136 | 2021-08-21 | Okfuskee | Oklahoma | 40107 | 1971 | 32 |
1640137 | 1640137 | 2021-08-21 | Oklahoma | Oklahoma | 40109 | 96822 | 1346 |
1640138 | 1640138 | 2021-08-21 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1640139 | 1640139 | 2021-08-21 | Osage | Oklahoma | 40113 | 5556 | 86 |
1640140 | 1640140 | 2021-08-21 | Ottawa | Oklahoma | 40115 | 5172 | 81 |
1640141 | 1640141 | 2021-08-21 | Pawnee | Oklahoma | 40117 | 2137 | 54 |
1640142 | 1640142 | 2021-08-21 | Payne | Oklahoma | 40119 | 9597 | 77 |
1640143 | 1640143 | 2021-08-21 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1640144 | 1640144 | 2021-08-21 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1640145 | 1640145 | 2021-08-21 | Pottawatomie | Oklahoma | 40125 | 9301 | 134 |
1640146 | 1640146 | 2021-08-21 | Pushmataha | Oklahoma | 40127 | 1314 | 24 |
1640147 | 1640147 | 2021-08-21 | Roger Mills | Oklahoma | 40129 | 419 | 12 |
1640148 | 1640148 | 2021-08-21 | Rogers | Oklahoma | 40131 | 12735 | 203 |
1640149 | 1640149 | 2021-08-21 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1640150 | 1640150 | 2021-08-21 | Sequoyah | Oklahoma | 40135 | 5140 | 58 |
1640151 | 1640151 | 2021-08-21 | Stephens | Oklahoma | 40137 | 5562 | 107 |
1640152 | 1640152 | 2021-08-21 | Texas | Oklahoma | 40139 | 3625 | 35 |
1640153 | 1640153 | 2021-08-21 | Tillman | Oklahoma | 40141 | 861 | 18 |
1640154 | 1640154 | 2021-08-21 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1640155 | 1640155 | 2021-08-21 | Unknown | Oklahoma | 8695 | 0 | |
1640156 | 1640156 | 2021-08-21 | Wagoner | Oklahoma | 40145 | 9733 | 131 |
1640157 | 1640157 | 2021-08-21 | Washington | Oklahoma | 40147 | 6540 | 130 |
1640158 | 1640158 | 2021-08-21 | Washita | Oklahoma | 40149 | 1180 | 23 |
1640159 | 1640159 | 2021-08-21 | Woods | Oklahoma | 40151 | 1348 | 18 |
1640160 | 1640160 | 2021-08-21 | Woodward | Oklahoma | 40153 | 3262 | 38 |
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);