ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
847945 | 847945 | 2020-12-20 | Adair | Oklahoma | 40001 | 1663 | 13 |
847946 | 847946 | 2020-12-20 | Alfalfa | Oklahoma | 40003 | 855 | 3 |
847947 | 847947 | 2020-12-20 | Atoka | Oklahoma | 40005 | 1162 | 3 |
847948 | 847948 | 2020-12-20 | Beaver | Oklahoma | 40007 | 285 | 2 |
847949 | 847949 | 2020-12-20 | Beckham | Oklahoma | 40009 | 1747 | 20 |
847950 | 847950 | 2020-12-20 | Blaine | Oklahoma | 40011 | 572 | 3 |
847951 | 847951 | 2020-12-20 | Bryan | Oklahoma | 40013 | 3539 | 27 |
847952 | 847952 | 2020-12-20 | Caddo | Oklahoma | 40015 | 2538 | 39 |
847953 | 847953 | 2020-12-20 | Canadian | Oklahoma | 40017 | 9550 | 45 |
847954 | 847954 | 2020-12-20 | Carter | Oklahoma | 40019 | 2354 | 16 |
847955 | 847955 | 2020-12-20 | Cherokee | Oklahoma | 40021 | 3284 | 15 |
847956 | 847956 | 2020-12-20 | Choctaw | Oklahoma | 40023 | 940 | 6 |
847957 | 847957 | 2020-12-20 | Cimarron | Oklahoma | 40025 | 101 | 1 |
847958 | 847958 | 2020-12-20 | Cleveland | Oklahoma | 40027 | 17096 | 142 |
847959 | 847959 | 2020-12-20 | Coal | Oklahoma | 40029 | 419 | 4 |
847960 | 847960 | 2020-12-20 | Comanche | Oklahoma | 40031 | 6302 | 50 |
847961 | 847961 | 2020-12-20 | Cotton | Oklahoma | 40033 | 377 | 9 |
847962 | 847962 | 2020-12-20 | Craig | Oklahoma | 40035 | 1317 | 5 |
847963 | 847963 | 2020-12-20 | Creek | Oklahoma | 40037 | 3630 | 57 |
847964 | 847964 | 2020-12-20 | Custer | Oklahoma | 40039 | 2639 | 27 |
847965 | 847965 | 2020-12-20 | Delaware | Oklahoma | 40041 | 2595 | 43 |
847966 | 847966 | 2020-12-20 | Dewey | Oklahoma | 40043 | 381 | 3 |
847967 | 847967 | 2020-12-20 | Ellis | Oklahoma | 40045 | 291 | 0 |
847968 | 847968 | 2020-12-20 | Garfield | Oklahoma | 40047 | 4927 | 41 |
847969 | 847969 | 2020-12-20 | Garvin | Oklahoma | 40049 | 2026 | 18 |
847970 | 847970 | 2020-12-20 | Grady | Oklahoma | 40051 | 3501 | 34 |
847971 | 847971 | 2020-12-20 | Grant | Oklahoma | 40053 | 326 | 5 |
847972 | 847972 | 2020-12-20 | Greer | Oklahoma | 40055 | 345 | 9 |
847973 | 847973 | 2020-12-20 | Harmon | Oklahoma | 40057 | 195 | 0 |
847974 | 847974 | 2020-12-20 | Harper | Oklahoma | 40059 | 326 | 3 |
847975 | 847975 | 2020-12-20 | Haskell | Oklahoma | 40061 | 761 | 7 |
847976 | 847976 | 2020-12-20 | Hughes | Oklahoma | 40063 | 726 | 8 |
847977 | 847977 | 2020-12-20 | Jackson | Oklahoma | 40065 | 2230 | 35 |
847978 | 847978 | 2020-12-20 | Jefferson | Oklahoma | 40067 | 361 | 2 |
847979 | 847979 | 2020-12-20 | Johnston | Oklahoma | 40069 | 735 | 5 |
847980 | 847980 | 2020-12-20 | Kay | Oklahoma | 40071 | 2788 | 28 |
847981 | 847981 | 2020-12-20 | Kingfisher | Oklahoma | 40073 | 1211 | 8 |
847982 | 847982 | 2020-12-20 | Kiowa | Oklahoma | 40075 | 503 | 10 |
847983 | 847983 | 2020-12-20 | Latimer | Oklahoma | 40077 | 430 | 4 |
847984 | 847984 | 2020-12-20 | Le Flore | Oklahoma | 40079 | 3169 | 28 |
847985 | 847985 | 2020-12-20 | Lincoln | Oklahoma | 40081 | 1896 | 30 |
847986 | 847986 | 2020-12-20 | Logan | Oklahoma | 40083 | 2197 | 6 |
847987 | 847987 | 2020-12-20 | Love | Oklahoma | 40085 | 797 | 1 |
847988 | 847988 | 2020-12-20 | Major | Oklahoma | 40093 | 659 | 4 |
847989 | 847989 | 2020-12-20 | Marshall | Oklahoma | 40095 | 1025 | 4 |
847990 | 847990 | 2020-12-20 | Mayes | Oklahoma | 40097 | 2202 | 22 |
847991 | 847991 | 2020-12-20 | McClain | Oklahoma | 40087 | 3208 | 21 |
847992 | 847992 | 2020-12-20 | McCurtain | Oklahoma | 40089 | 2664 | 50 |
847993 | 847993 | 2020-12-20 | McIntosh | Oklahoma | 40091 | 1143 | 14 |
847994 | 847994 | 2020-12-20 | Murray | Oklahoma | 40099 | 971 | 6 |
847995 | 847995 | 2020-12-20 | Muskogee | Oklahoma | 40101 | 5856 | 48 |
847996 | 847996 | 2020-12-20 | Noble | Oklahoma | 40103 | 863 | 5 |
847997 | 847997 | 2020-12-20 | Nowata | Oklahoma | 40105 | 594 | 8 |
847998 | 847998 | 2020-12-20 | Okfuskee | Oklahoma | 40107 | 1281 | 15 |
847999 | 847999 | 2020-12-20 | Oklahoma | Oklahoma | 40109 | 53080 | 398 |
848000 | 848000 | 2020-12-20 | Okmulgee | Oklahoma | 40111 | 2299 | 25 |
848001 | 848001 | 2020-12-20 | Osage | Oklahoma | 40113 | 2661 | 24 |
848002 | 848002 | 2020-12-20 | Ottawa | Oklahoma | 40115 | 2410 | 25 |
848003 | 848003 | 2020-12-20 | Pawnee | Oklahoma | 40117 | 906 | 9 |
848004 | 848004 | 2020-12-20 | Payne | Oklahoma | 40119 | 5371 | 25 |
848005 | 848005 | 2020-12-20 | Pittsburg | Oklahoma | 40121 | 2542 | 23 |
848006 | 848006 | 2020-12-20 | Pontotoc | Oklahoma | 40123 | 2682 | 17 |
848007 | 848007 | 2020-12-20 | Pottawatomie | Oklahoma | 40125 | 4826 | 26 |
848008 | 848008 | 2020-12-20 | Pushmataha | Oklahoma | 40127 | 516 | 6 |
848009 | 848009 | 2020-12-20 | Roger Mills | Oklahoma | 40129 | 240 | 6 |
848010 | 848010 | 2020-12-20 | Rogers | Oklahoma | 40131 | 5795 | 80 |
848011 | 848011 | 2020-12-20 | Seminole | Oklahoma | 40133 | 1609 | 15 |
848012 | 848012 | 2020-12-20 | Sequoyah | Oklahoma | 40135 | 2230 | 16 |
848013 | 848013 | 2020-12-20 | Stephens | Oklahoma | 40137 | 2525 | 20 |
848014 | 848014 | 2020-12-20 | Texas | Oklahoma | 40139 | 2829 | 15 |
848015 | 848015 | 2020-12-20 | Tillman | Oklahoma | 40141 | 491 | 8 |
848016 | 848016 | 2020-12-20 | Tulsa | Oklahoma | 40143 | 43673 | 350 |
848017 | 848017 | 2020-12-20 | Unknown | Oklahoma | 90 | 0 | |
848018 | 848018 | 2020-12-20 | Wagoner | Oklahoma | 40145 | 3924 | 42 |
848019 | 848019 | 2020-12-20 | Washington | Oklahoma | 40147 | 2842 | 53 |
848020 | 848020 | 2020-12-20 | Washita | Oklahoma | 40149 | 653 | 3 |
848021 | 848021 | 2020-12-20 | Woods | Oklahoma | 40151 | 789 | 4 |
848022 | 848022 | 2020-12-20 | Woodward | Oklahoma | 40153 | 2302 | 10 |
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);