ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2020-09-04 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
500981 | 500981 | 2020-09-04 | Adair | Oklahoma | 40001 | 493 | 10 |
500982 | 500982 | 2020-09-04 | Alfalfa | Oklahoma | 40003 | 15 | 0 |
500983 | 500983 | 2020-09-04 | Atoka | Oklahoma | 40005 | 161 | 1 |
500984 | 500984 | 2020-09-04 | Beaver | Oklahoma | 40007 | 44 | 0 |
500985 | 500985 | 2020-09-04 | Beckham | Oklahoma | 40009 | 129 | 1 |
500986 | 500986 | 2020-09-04 | Blaine | Oklahoma | 40011 | 85 | 1 |
500987 | 500987 | 2020-09-04 | Bryan | Oklahoma | 40013 | 644 | 3 |
500988 | 500988 | 2020-09-04 | Caddo | Oklahoma | 40015 | 587 | 20 |
500989 | 500989 | 2020-09-04 | Canadian | Oklahoma | 40017 | 1599 | 13 |
500990 | 500990 | 2020-09-04 | Carter | Oklahoma | 40019 | 424 | 7 |
500991 | 500991 | 2020-09-04 | Cherokee | Oklahoma | 40021 | 739 | 7 |
500992 | 500992 | 2020-09-04 | Choctaw | Oklahoma | 40023 | 256 | 2 |
500993 | 500993 | 2020-09-04 | Cimarron | Oklahoma | 40025 | 14 | 0 |
500994 | 500994 | 2020-09-04 | Cleveland | Oklahoma | 40027 | 4179 | 66 |
500995 | 500995 | 2020-09-04 | Coal | Oklahoma | 40029 | 62 | 0 |
500996 | 500996 | 2020-09-04 | Comanche | Oklahoma | 40031 | 1286 | 11 |
500997 | 500997 | 2020-09-04 | Cotton | Oklahoma | 40033 | 42 | 2 |
500998 | 500998 | 2020-09-04 | Craig | Oklahoma | 40035 | 154 | 1 |
500999 | 500999 | 2020-09-04 | Creek | Oklahoma | 40037 | 860 | 22 |
501000 | 501000 | 2020-09-04 | Custer | Oklahoma | 40039 | 348 | 0 |
501001 | 501001 | 2020-09-04 | Delaware | Oklahoma | 40041 | 564 | 22 |
501002 | 501002 | 2020-09-04 | Dewey | Oklahoma | 40043 | 24 | 1 |
501003 | 501003 | 2020-09-04 | Ellis | Oklahoma | 40045 | 6 | 0 |
501004 | 501004 | 2020-09-04 | Garfield | Oklahoma | 40047 | 1084 | 14 |
501005 | 501005 | 2020-09-04 | Garvin | Oklahoma | 40049 | 269 | 4 |
501006 | 501006 | 2020-09-04 | Grady | Oklahoma | 40051 | 549 | 7 |
501007 | 501007 | 2020-09-04 | Grant | Oklahoma | 40053 | 27 | 0 |
501008 | 501008 | 2020-09-04 | Greer | Oklahoma | 40055 | 91 | 8 |
501009 | 501009 | 2020-09-04 | Harmon | Oklahoma | 40057 | 40 | 0 |
501010 | 501010 | 2020-09-04 | Harper | Oklahoma | 40059 | 19 | 0 |
501011 | 501011 | 2020-09-04 | Haskell | Oklahoma | 40061 | 178 | 4 |
501012 | 501012 | 2020-09-04 | Hughes | Oklahoma | 40063 | 226 | 4 |
501013 | 501013 | 2020-09-04 | Jackson | Oklahoma | 40065 | 614 | 9 |
501014 | 501014 | 2020-09-04 | Jefferson | Oklahoma | 40067 | 35 | 0 |
501015 | 501015 | 2020-09-04 | Johnston | Oklahoma | 40069 | 107 | 2 |
501016 | 501016 | 2020-09-04 | Kay | Oklahoma | 40071 | 348 | 12 |
501017 | 501017 | 2020-09-04 | Kingfisher | Oklahoma | 40073 | 274 | 2 |
501018 | 501018 | 2020-09-04 | Kiowa | Oklahoma | 40075 | 48 | 1 |
501019 | 501019 | 2020-09-04 | Latimer | Oklahoma | 40077 | 114 | 2 |
501020 | 501020 | 2020-09-04 | Le Flore | Oklahoma | 40079 | 732 | 10 |
501021 | 501021 | 2020-09-04 | Lincoln | Oklahoma | 40081 | 319 | 9 |
501022 | 501022 | 2020-09-04 | Logan | Oklahoma | 40083 | 316 | 1 |
501023 | 501023 | 2020-09-04 | Love | Oklahoma | 40085 | 117 | 1 |
501024 | 501024 | 2020-09-04 | Major | Oklahoma | 40093 | 57 | 1 |
501025 | 501025 | 2020-09-04 | Marshall | Oklahoma | 40095 | 133 | 1 |
501026 | 501026 | 2020-09-04 | Mayes | Oklahoma | 40097 | 437 | 10 |
501027 | 501027 | 2020-09-04 | McClain | Oklahoma | 40087 | 602 | 4 |
501028 | 501028 | 2020-09-04 | McCurtain | Oklahoma | 40089 | 1076 | 31 |
501029 | 501029 | 2020-09-04 | McIntosh | Oklahoma | 40091 | 242 | 4 |
501030 | 501030 | 2020-09-04 | Murray | Oklahoma | 40099 | 91 | 1 |
501031 | 501031 | 2020-09-04 | Muskogee | Oklahoma | 40101 | 1427 | 17 |
501032 | 501032 | 2020-09-04 | Noble | Oklahoma | 40103 | 115 | 2 |
501033 | 501033 | 2020-09-04 | Nowata | Oklahoma | 40105 | 107 | 1 |
501034 | 501034 | 2020-09-04 | Okfuskee | Oklahoma | 40107 | 109 | 3 |
501035 | 501035 | 2020-09-04 | Oklahoma | Oklahoma | 40109 | 13923 | 163 |
501036 | 501036 | 2020-09-04 | Okmulgee | Oklahoma | 40111 | 649 | 5 |
501037 | 501037 | 2020-09-04 | Osage | Oklahoma | 40113 | 666 | 12 |
501038 | 501038 | 2020-09-04 | Ottawa | Oklahoma | 40115 | 576 | 4 |
501039 | 501039 | 2020-09-04 | Pawnee | Oklahoma | 40117 | 223 | 3 |
501040 | 501040 | 2020-09-04 | Payne | Oklahoma | 40119 | 1396 | 5 |
501041 | 501041 | 2020-09-04 | Pittsburg | Oklahoma | 40121 | 619 | 18 |
501042 | 501042 | 2020-09-04 | Pontotoc | Oklahoma | 40123 | 253 | 3 |
501043 | 501043 | 2020-09-04 | Pottawatomie | Oklahoma | 40125 | 911 | 9 |
501044 | 501044 | 2020-09-04 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
501045 | 501045 | 2020-09-04 | Roger Mills | Oklahoma | 40129 | 14 | 1 |
501046 | 501046 | 2020-09-04 | Rogers | Oklahoma | 40131 | 1369 | 42 |
501047 | 501047 | 2020-09-04 | Seminole | Oklahoma | 40133 | 339 | 5 |
501048 | 501048 | 2020-09-04 | Sequoyah | Oklahoma | 40135 | 613 | 8 |
501049 | 501049 | 2020-09-04 | Stephens | Oklahoma | 40137 | 258 | 4 |
501050 | 501050 | 2020-09-04 | Texas | Oklahoma | 40139 | 1213 | 7 |
501051 | 501051 | 2020-09-04 | Tillman | Oklahoma | 40141 | 70 | 1 |
501052 | 501052 | 2020-09-04 | Tulsa | Oklahoma | 40143 | 13923 | 137 |
501053 | 501053 | 2020-09-04 | Unknown | Oklahoma | 54 | 0 | |
501054 | 501054 | 2020-09-04 | Wagoner | Oklahoma | 40145 | 1200 | 23 |
501055 | 501055 | 2020-09-04 | Washington | Oklahoma | 40147 | 846 | 40 |
501056 | 501056 | 2020-09-04 | Washita | Oklahoma | 40149 | 44 | 0 |
501057 | 501057 | 2020-09-04 | Woods | Oklahoma | 40151 | 26 | 0 |
501058 | 501058 | 2020-09-04 | Woodward | Oklahoma | 40153 | 106 | 0 |
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);