ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-10-16" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637032 | 637032 | 2020-10-16 | Adair | Oklahoma | 40001 | 719 | 11 |
637033 | 637033 | 2020-10-16 | Alfalfa | Oklahoma | 40003 | 102 | 0 |
637034 | 637034 | 2020-10-16 | Atoka | Oklahoma | 40005 | 378 | 1 |
637035 | 637035 | 2020-10-16 | Beaver | Oklahoma | 40007 | 76 | 0 |
637036 | 637036 | 2020-10-16 | Beckham | Oklahoma | 40009 | 744 | 9 |
637037 | 637037 | 2020-10-16 | Blaine | Oklahoma | 40011 | 172 | 1 |
637038 | 637038 | 2020-10-16 | Bryan | Oklahoma | 40013 | 1303 | 5 |
637039 | 637039 | 2020-10-16 | Caddo | Oklahoma | 40015 | 1028 | 23 |
637040 | 637040 | 2020-10-16 | Canadian | Oklahoma | 40017 | 3227 | 20 |
637041 | 637041 | 2020-10-16 | Carter | Oklahoma | 40019 | 715 | 9 |
637042 | 637042 | 2020-10-16 | Cherokee | Oklahoma | 40021 | 1280 | 8 |
637043 | 637043 | 2020-10-16 | Choctaw | Oklahoma | 40023 | 418 | 2 |
637044 | 637044 | 2020-10-16 | Cimarron | Oklahoma | 40025 | 32 | 0 |
637045 | 637045 | 2020-10-16 | Cleveland | Oklahoma | 40027 | 7429 | 85 |
637046 | 637046 | 2020-10-16 | Coal | Oklahoma | 40029 | 79 | 0 |
637047 | 637047 | 2020-10-16 | Comanche | Oklahoma | 40031 | 2001 | 16 |
637048 | 637048 | 2020-10-16 | Cotton | Oklahoma | 40033 | 83 | 3 |
637049 | 637049 | 2020-10-16 | Craig | Oklahoma | 40035 | 591 | 2 |
637050 | 637050 | 2020-10-16 | Creek | Oklahoma | 40037 | 1426 | 36 |
637051 | 637051 | 2020-10-16 | Custer | Oklahoma | 40039 | 974 | 3 |
637052 | 637052 | 2020-10-16 | Delaware | Oklahoma | 40041 | 1114 | 27 |
637053 | 637053 | 2020-10-16 | Dewey | Oklahoma | 40043 | 77 | 1 |
637054 | 637054 | 2020-10-16 | Ellis | Oklahoma | 40045 | 18 | 0 |
637055 | 637055 | 2020-10-16 | Garfield | Oklahoma | 40047 | 2170 | 23 |
637056 | 637056 | 2020-10-16 | Garvin | Oklahoma | 40049 | 558 | 6 |
637057 | 637057 | 2020-10-16 | Grady | Oklahoma | 40051 | 1426 | 14 |
637058 | 637058 | 2020-10-16 | Grant | Oklahoma | 40053 | 74 | 1 |
637059 | 637059 | 2020-10-16 | Greer | Oklahoma | 40055 | 129 | 8 |
637060 | 637060 | 2020-10-16 | Harmon | Oklahoma | 40057 | 62 | 0 |
637061 | 637061 | 2020-10-16 | Harper | Oklahoma | 40059 | 46 | 1 |
637062 | 637062 | 2020-10-16 | Haskell | Oklahoma | 40061 | 346 | 5 |
637063 | 637063 | 2020-10-16 | Hughes | Oklahoma | 40063 | 353 | 4 |
637064 | 637064 | 2020-10-16 | Jackson | Oklahoma | 40065 | 991 | 11 |
637065 | 637065 | 2020-10-16 | Jefferson | Oklahoma | 40067 | 65 | 0 |
637066 | 637066 | 2020-10-16 | Johnston | Oklahoma | 40069 | 254 | 4 |
637067 | 637067 | 2020-10-16 | Kay | Oklahoma | 40071 | 782 | 15 |
637068 | 637068 | 2020-10-16 | Kingfisher | Oklahoma | 40073 | 472 | 2 |
637069 | 637069 | 2020-10-16 | Kiowa | Oklahoma | 40075 | 147 | 2 |
637070 | 637070 | 2020-10-16 | Latimer | Oklahoma | 40077 | 174 | 2 |
637071 | 637071 | 2020-10-16 | Le Flore | Oklahoma | 40079 | 1513 | 21 |
637072 | 637072 | 2020-10-16 | Lincoln | Oklahoma | 40081 | 687 | 10 |
637073 | 637073 | 2020-10-16 | Logan | Oklahoma | 40083 | 720 | 2 |
637074 | 637074 | 2020-10-16 | Love | Oklahoma | 40085 | 245 | 1 |
637075 | 637075 | 2020-10-16 | Major | Oklahoma | 40093 | 131 | 2 |
637076 | 637076 | 2020-10-16 | Marshall | Oklahoma | 40095 | 246 | 2 |
637077 | 637077 | 2020-10-16 | Mayes | Oklahoma | 40097 | 864 | 11 |
637078 | 637078 | 2020-10-16 | McClain | Oklahoma | 40087 | 1148 | 9 |
637079 | 637079 | 2020-10-16 | McCurtain | Oklahoma | 40089 | 1508 | 37 |
637080 | 637080 | 2020-10-16 | McIntosh | Oklahoma | 40091 | 438 | 8 |
637081 | 637081 | 2020-10-16 | Murray | Oklahoma | 40099 | 246 | 2 |
637082 | 637082 | 2020-10-16 | Muskogee | Oklahoma | 40101 | 2157 | 28 |
637083 | 637083 | 2020-10-16 | Noble | Oklahoma | 40103 | 169 | 3 |
637084 | 637084 | 2020-10-16 | Nowata | Oklahoma | 40105 | 215 | 4 |
637085 | 637085 | 2020-10-16 | Okfuskee | Oklahoma | 40107 | 250 | 6 |
637086 | 637086 | 2020-10-16 | Oklahoma | Oklahoma | 40109 | 21506 | 216 |
637087 | 637087 | 2020-10-16 | Okmulgee | Oklahoma | 40111 | 1033 | 8 |
637088 | 637088 | 2020-10-16 | Osage | Oklahoma | 40113 | 1285 | 13 |
637089 | 637089 | 2020-10-16 | Ottawa | Oklahoma | 40115 | 1113 | 8 |
637090 | 637090 | 2020-10-16 | Pawnee | Oklahoma | 40117 | 298 | 5 |
637091 | 637091 | 2020-10-16 | Payne | Oklahoma | 40119 | 2653 | 9 |
637092 | 637092 | 2020-10-16 | Pittsburg | Oklahoma | 40121 | 1119 | 20 |
637093 | 637093 | 2020-10-16 | Pontotoc | Oklahoma | 40123 | 610 | 4 |
637094 | 637094 | 2020-10-16 | Pottawatomie | Oklahoma | 40125 | 1874 | 11 |
637095 | 637095 | 2020-10-16 | Pushmataha | Oklahoma | 40127 | 241 | 4 |
637096 | 637096 | 2020-10-16 | Roger Mills | Oklahoma | 40129 | 82 | 2 |
637097 | 637097 | 2020-10-16 | Rogers | Oklahoma | 40131 | 2235 | 53 |
637098 | 637098 | 2020-10-16 | Seminole | Oklahoma | 40133 | 665 | 6 |
637099 | 637099 | 2020-10-16 | Sequoyah | Oklahoma | 40135 | 1108 | 13 |
637100 | 637100 | 2020-10-16 | Stephens | Oklahoma | 40137 | 574 | 8 |
637101 | 637101 | 2020-10-16 | Texas | Oklahoma | 40139 | 1704 | 10 |
637102 | 637102 | 2020-10-16 | Tillman | Oklahoma | 40141 | 133 | 2 |
637103 | 637103 | 2020-10-16 | Tulsa | Oklahoma | 40143 | 20102 | 183 |
637104 | 637104 | 2020-10-16 | Unknown | Oklahoma | 17 | 0 | |
637105 | 637105 | 2020-10-16 | Wagoner | Oklahoma | 40145 | 1731 | 27 |
637106 | 637106 | 2020-10-16 | Washington | Oklahoma | 40147 | 1186 | 41 |
637107 | 637107 | 2020-10-16 | Washita | Oklahoma | 40149 | 144 | 0 |
637108 | 637108 | 2020-10-16 | Woods | Oklahoma | 40151 | 140 | 0 |
637109 | 637109 | 2020-10-16 | Woodward | Oklahoma | 40153 | 1183 | 5 |
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);