ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-12-28" 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 |
---|---|---|---|---|---|---|---|
873905 | 873905 | 2020-12-28 | Adair | Oklahoma | 40001 | 1778 | 14 |
873906 | 873906 | 2020-12-28 | Alfalfa | Oklahoma | 40003 | 911 | 4 |
873907 | 873907 | 2020-12-28 | Atoka | Oklahoma | 40005 | 1258 | 3 |
873908 | 873908 | 2020-12-28 | Beaver | Oklahoma | 40007 | 300 | 2 |
873909 | 873909 | 2020-12-28 | Beckham | Oklahoma | 40009 | 1925 | 21 |
873910 | 873910 | 2020-12-28 | Blaine | Oklahoma | 40011 | 639 | 3 |
873911 | 873911 | 2020-12-28 | Bryan | Oklahoma | 40013 | 3816 | 32 |
873912 | 873912 | 2020-12-28 | Caddo | Oklahoma | 40015 | 2728 | 39 |
873913 | 873913 | 2020-12-28 | Canadian | Oklahoma | 40017 | 10351 | 50 |
873914 | 873914 | 2020-12-28 | Carter | Oklahoma | 40019 | 2631 | 17 |
873915 | 873915 | 2020-12-28 | Cherokee | Oklahoma | 40021 | 3531 | 17 |
873916 | 873916 | 2020-12-28 | Choctaw | Oklahoma | 40023 | 1052 | 6 |
873917 | 873917 | 2020-12-28 | Cimarron | Oklahoma | 40025 | 101 | 1 |
873918 | 873918 | 2020-12-28 | Cleveland | Oklahoma | 40027 | 18586 | 151 |
873919 | 873919 | 2020-12-28 | Coal | Oklahoma | 40029 | 461 | 4 |
873920 | 873920 | 2020-12-28 | Comanche | Oklahoma | 40031 | 6752 | 56 |
873921 | 873921 | 2020-12-28 | Cotton | Oklahoma | 40033 | 412 | 10 |
873922 | 873922 | 2020-12-28 | Craig | Oklahoma | 40035 | 1414 | 5 |
873923 | 873923 | 2020-12-28 | Creek | Oklahoma | 40037 | 3975 | 63 |
873924 | 873924 | 2020-12-28 | Custer | Oklahoma | 40039 | 2894 | 31 |
873925 | 873925 | 2020-12-28 | Delaware | Oklahoma | 40041 | 2815 | 44 |
873926 | 873926 | 2020-12-28 | Dewey | Oklahoma | 40043 | 402 | 3 |
873927 | 873927 | 2020-12-28 | Ellis | Oklahoma | 40045 | 302 | 1 |
873928 | 873928 | 2020-12-28 | Garfield | Oklahoma | 40047 | 5347 | 42 |
873929 | 873929 | 2020-12-28 | Garvin | Oklahoma | 40049 | 2230 | 18 |
873930 | 873930 | 2020-12-28 | Grady | Oklahoma | 40051 | 3750 | 36 |
873931 | 873931 | 2020-12-28 | Grant | Oklahoma | 40053 | 375 | 5 |
873932 | 873932 | 2020-12-28 | Greer | Oklahoma | 40055 | 371 | 9 |
873933 | 873933 | 2020-12-28 | Harmon | Oklahoma | 40057 | 199 | 0 |
873934 | 873934 | 2020-12-28 | Harper | Oklahoma | 40059 | 342 | 3 |
873935 | 873935 | 2020-12-28 | Haskell | Oklahoma | 40061 | 826 | 7 |
873936 | 873936 | 2020-12-28 | Hughes | Oklahoma | 40063 | 792 | 8 |
873937 | 873937 | 2020-12-28 | Jackson | Oklahoma | 40065 | 2315 | 36 |
873938 | 873938 | 2020-12-28 | Jefferson | Oklahoma | 40067 | 415 | 3 |
873939 | 873939 | 2020-12-28 | Johnston | Oklahoma | 40069 | 807 | 10 |
873940 | 873940 | 2020-12-28 | Kay | Oklahoma | 40071 | 3154 | 30 |
873941 | 873941 | 2020-12-28 | Kingfisher | Oklahoma | 40073 | 1335 | 10 |
873942 | 873942 | 2020-12-28 | Kiowa | Oklahoma | 40075 | 522 | 11 |
873943 | 873943 | 2020-12-28 | Latimer | Oklahoma | 40077 | 502 | 5 |
873944 | 873944 | 2020-12-28 | Le Flore | Oklahoma | 40079 | 3423 | 30 |
873945 | 873945 | 2020-12-28 | Lincoln | Oklahoma | 40081 | 2041 | 32 |
873946 | 873946 | 2020-12-28 | Logan | Oklahoma | 40083 | 2495 | 7 |
873947 | 873947 | 2020-12-28 | Love | Oklahoma | 40085 | 875 | 5 |
873948 | 873948 | 2020-12-28 | Major | Oklahoma | 40093 | 710 | 4 |
873949 | 873949 | 2020-12-28 | Marshall | Oklahoma | 40095 | 1088 | 6 |
873950 | 873950 | 2020-12-28 | Mayes | Oklahoma | 40097 | 2442 | 23 |
873951 | 873951 | 2020-12-28 | McClain | Oklahoma | 40087 | 3464 | 25 |
873952 | 873952 | 2020-12-28 | McCurtain | Oklahoma | 40089 | 2850 | 50 |
873953 | 873953 | 2020-12-28 | McIntosh | Oklahoma | 40091 | 1268 | 15 |
873954 | 873954 | 2020-12-28 | Murray | Oklahoma | 40099 | 1106 | 8 |
873955 | 873955 | 2020-12-28 | Muskogee | Oklahoma | 40101 | 6346 | 48 |
873956 | 873956 | 2020-12-28 | Noble | Oklahoma | 40103 | 946 | 7 |
873957 | 873957 | 2020-12-28 | Nowata | Oklahoma | 40105 | 660 | 8 |
873958 | 873958 | 2020-12-28 | Okfuskee | Oklahoma | 40107 | 1372 | 15 |
873959 | 873959 | 2020-12-28 | Oklahoma | Oklahoma | 40109 | 56748 | 424 |
873960 | 873960 | 2020-12-28 | Okmulgee | Oklahoma | 40111 | 2503 | 26 |
873961 | 873961 | 2020-12-28 | Osage | Oklahoma | 40113 | 2897 | 25 |
873962 | 873962 | 2020-12-28 | Ottawa | Oklahoma | 40115 | 2629 | 28 |
873963 | 873963 | 2020-12-28 | Pawnee | Oklahoma | 40117 | 989 | 10 |
873964 | 873964 | 2020-12-28 | Payne | Oklahoma | 40119 | 5676 | 27 |
873965 | 873965 | 2020-12-28 | Pittsburg | Oklahoma | 40121 | 2902 | 23 |
873966 | 873966 | 2020-12-28 | Pontotoc | Oklahoma | 40123 | 2997 | 23 |
873967 | 873967 | 2020-12-28 | Pottawatomie | Oklahoma | 40125 | 5386 | 33 |
873968 | 873968 | 2020-12-28 | Pushmataha | Oklahoma | 40127 | 598 | 6 |
873969 | 873969 | 2020-12-28 | Roger Mills | Oklahoma | 40129 | 250 | 6 |
873970 | 873970 | 2020-12-28 | Rogers | Oklahoma | 40131 | 6361 | 83 |
873971 | 873971 | 2020-12-28 | Seminole | Oklahoma | 40133 | 1764 | 18 |
873972 | 873972 | 2020-12-28 | Sequoyah | Oklahoma | 40135 | 2382 | 16 |
873973 | 873973 | 2020-12-28 | Stephens | Oklahoma | 40137 | 2860 | 23 |
873974 | 873974 | 2020-12-28 | Texas | Oklahoma | 40139 | 2926 | 16 |
873975 | 873975 | 2020-12-28 | Tillman | Oklahoma | 40141 | 535 | 8 |
873976 | 873976 | 2020-12-28 | Tulsa | Oklahoma | 40143 | 46999 | 376 |
873977 | 873977 | 2020-12-28 | Unknown | Oklahoma | 184 | 0 | |
873978 | 873978 | 2020-12-28 | Wagoner | Oklahoma | 40145 | 4448 | 44 |
873979 | 873979 | 2020-12-28 | Washington | Oklahoma | 40147 | 3063 | 58 |
873980 | 873980 | 2020-12-28 | Washita | Oklahoma | 40149 | 738 | 3 |
873981 | 873981 | 2020-12-28 | Woods | Oklahoma | 40151 | 921 | 4 |
873982 | 873982 | 2020-12-28 | Woodward | Oklahoma | 40153 | 2429 | 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);