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-08 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
513913 | 513913 | 2020-09-08 | Adair | Oklahoma | 40001 | 505 | 10 |
513914 | 513914 | 2020-09-08 | Alfalfa | Oklahoma | 40003 | 19 | 0 |
513915 | 513915 | 2020-09-08 | Atoka | Oklahoma | 40005 | 170 | 1 |
513916 | 513916 | 2020-09-08 | Beaver | Oklahoma | 40007 | 45 | 0 |
513917 | 513917 | 2020-09-08 | Beckham | Oklahoma | 40009 | 138 | 1 |
513918 | 513918 | 2020-09-08 | Blaine | Oklahoma | 40011 | 88 | 1 |
513919 | 513919 | 2020-09-08 | Bryan | Oklahoma | 40013 | 669 | 3 |
513920 | 513920 | 2020-09-08 | Caddo | Oklahoma | 40015 | 606 | 20 |
513921 | 513921 | 2020-09-08 | Canadian | Oklahoma | 40017 | 1644 | 13 |
513922 | 513922 | 2020-09-08 | Carter | Oklahoma | 40019 | 436 | 7 |
513923 | 513923 | 2020-09-08 | Cherokee | Oklahoma | 40021 | 791 | 7 |
513924 | 513924 | 2020-09-08 | Choctaw | Oklahoma | 40023 | 259 | 2 |
513925 | 513925 | 2020-09-08 | Cimarron | Oklahoma | 40025 | 19 | 0 |
513926 | 513926 | 2020-09-08 | Cleveland | Oklahoma | 40027 | 4551 | 66 |
513927 | 513927 | 2020-09-08 | Coal | Oklahoma | 40029 | 63 | 0 |
513928 | 513928 | 2020-09-08 | Comanche | Oklahoma | 40031 | 1304 | 11 |
513929 | 513929 | 2020-09-08 | Cotton | Oklahoma | 40033 | 51 | 2 |
513930 | 513930 | 2020-09-08 | Craig | Oklahoma | 40035 | 175 | 1 |
513931 | 513931 | 2020-09-08 | Creek | Oklahoma | 40037 | 904 | 22 |
513932 | 513932 | 2020-09-08 | Custer | Oklahoma | 40039 | 369 | 0 |
513933 | 513933 | 2020-09-08 | Delaware | Oklahoma | 40041 | 595 | 22 |
513934 | 513934 | 2020-09-08 | Dewey | Oklahoma | 40043 | 24 | 1 |
513935 | 513935 | 2020-09-08 | Ellis | Oklahoma | 40045 | 6 | 0 |
513936 | 513936 | 2020-09-08 | Garfield | Oklahoma | 40047 | 1184 | 14 |
513937 | 513937 | 2020-09-08 | Garvin | Oklahoma | 40049 | 284 | 4 |
513938 | 513938 | 2020-09-08 | Grady | Oklahoma | 40051 | 583 | 7 |
513939 | 513939 | 2020-09-08 | Grant | Oklahoma | 40053 | 30 | 0 |
513940 | 513940 | 2020-09-08 | Greer | Oklahoma | 40055 | 91 | 8 |
513941 | 513941 | 2020-09-08 | Harmon | Oklahoma | 40057 | 40 | 0 |
513942 | 513942 | 2020-09-08 | Harper | Oklahoma | 40059 | 22 | 0 |
513943 | 513943 | 2020-09-08 | Haskell | Oklahoma | 40061 | 191 | 4 |
513944 | 513944 | 2020-09-08 | Hughes | Oklahoma | 40063 | 238 | 4 |
513945 | 513945 | 2020-09-08 | Jackson | Oklahoma | 40065 | 626 | 9 |
513946 | 513946 | 2020-09-08 | Jefferson | Oklahoma | 40067 | 37 | 0 |
513947 | 513947 | 2020-09-08 | Johnston | Oklahoma | 40069 | 120 | 2 |
513948 | 513948 | 2020-09-08 | Kay | Oklahoma | 40071 | 374 | 12 |
513949 | 513949 | 2020-09-08 | Kingfisher | Oklahoma | 40073 | 289 | 2 |
513950 | 513950 | 2020-09-08 | Kiowa | Oklahoma | 40075 | 52 | 1 |
513951 | 513951 | 2020-09-08 | Latimer | Oklahoma | 40077 | 117 | 2 |
513952 | 513952 | 2020-09-08 | Le Flore | Oklahoma | 40079 | 789 | 10 |
513953 | 513953 | 2020-09-08 | Lincoln | Oklahoma | 40081 | 334 | 9 |
513954 | 513954 | 2020-09-08 | Logan | Oklahoma | 40083 | 331 | 1 |
513955 | 513955 | 2020-09-08 | Love | Oklahoma | 40085 | 130 | 1 |
513956 | 513956 | 2020-09-08 | Major | Oklahoma | 40093 | 57 | 1 |
513957 | 513957 | 2020-09-08 | Marshall | Oklahoma | 40095 | 140 | 1 |
513958 | 513958 | 2020-09-08 | Mayes | Oklahoma | 40097 | 469 | 10 |
513959 | 513959 | 2020-09-08 | McClain | Oklahoma | 40087 | 639 | 4 |
513960 | 513960 | 2020-09-08 | McCurtain | Oklahoma | 40089 | 1109 | 31 |
513961 | 513961 | 2020-09-08 | McIntosh | Oklahoma | 40091 | 252 | 4 |
513962 | 513962 | 2020-09-08 | Murray | Oklahoma | 40099 | 97 | 1 |
513963 | 513963 | 2020-09-08 | Muskogee | Oklahoma | 40101 | 1476 | 17 |
513964 | 513964 | 2020-09-08 | Noble | Oklahoma | 40103 | 118 | 2 |
513965 | 513965 | 2020-09-08 | Nowata | Oklahoma | 40105 | 117 | 1 |
513966 | 513966 | 2020-09-08 | Okfuskee | Oklahoma | 40107 | 111 | 3 |
513967 | 513967 | 2020-09-08 | Oklahoma | Oklahoma | 40109 | 14416 | 168 |
513968 | 513968 | 2020-09-08 | Okmulgee | Oklahoma | 40111 | 678 | 5 |
513969 | 513969 | 2020-09-08 | Osage | Oklahoma | 40113 | 710 | 12 |
513970 | 513970 | 2020-09-08 | Ottawa | Oklahoma | 40115 | 638 | 4 |
513971 | 513971 | 2020-09-08 | Pawnee | Oklahoma | 40117 | 230 | 3 |
513972 | 513972 | 2020-09-08 | Payne | Oklahoma | 40119 | 1557 | 5 |
513973 | 513973 | 2020-09-08 | Pittsburg | Oklahoma | 40121 | 651 | 18 |
513974 | 513974 | 2020-09-08 | Pontotoc | Oklahoma | 40123 | 269 | 3 |
513975 | 513975 | 2020-09-08 | Pottawatomie | Oklahoma | 40125 | 970 | 9 |
513976 | 513976 | 2020-09-08 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
513977 | 513977 | 2020-09-08 | Roger Mills | Oklahoma | 40129 | 14 | 1 |
513978 | 513978 | 2020-09-08 | Rogers | Oklahoma | 40131 | 1454 | 42 |
513979 | 513979 | 2020-09-08 | Seminole | Oklahoma | 40133 | 354 | 5 |
513980 | 513980 | 2020-09-08 | Sequoyah | Oklahoma | 40135 | 636 | 8 |
513981 | 513981 | 2020-09-08 | Stephens | Oklahoma | 40137 | 279 | 4 |
513982 | 513982 | 2020-09-08 | Texas | Oklahoma | 40139 | 1252 | 7 |
513983 | 513983 | 2020-09-08 | Tillman | Oklahoma | 40141 | 72 | 1 |
513984 | 513984 | 2020-09-08 | Tulsa | Oklahoma | 40143 | 14473 | 140 |
513985 | 513985 | 2020-09-08 | Unknown | Oklahoma | 45 | 0 | |
513986 | 513986 | 2020-09-08 | Wagoner | Oklahoma | 40145 | 1250 | 23 |
513987 | 513987 | 2020-09-08 | Washington | Oklahoma | 40147 | 888 | 40 |
513988 | 513988 | 2020-09-08 | Washita | Oklahoma | 40149 | 45 | 0 |
513989 | 513989 | 2020-09-08 | Woods | Oklahoma | 40151 | 31 | 0 |
513990 | 513990 | 2020-09-08 | Woodward | Oklahoma | 40153 | 132 | 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);