ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-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 |
---|---|---|---|---|---|---|---|
1662822 | 1662822 | 2021-08-28 | Adair | Oklahoma | 40001 | 4131 | 48 |
1662823 | 1662823 | 2021-08-28 | Alfalfa | Oklahoma | 40003 | 1209 | 7 |
1662824 | 1662824 | 2021-08-28 | Atoka | Oklahoma | 40005 | 2214 | 28 |
1662825 | 1662825 | 2021-08-28 | Beaver | Oklahoma | 40007 | 485 | 6 |
1662826 | 1662826 | 2021-08-28 | Beckham | Oklahoma | 40009 | 3022 | 58 |
1662827 | 1662827 | 2021-08-28 | Blaine | Oklahoma | 40011 | 1169 | 21 |
1662828 | 1662828 | 2021-08-28 | Bryan | Oklahoma | 40013 | 7246 | 83 |
1662829 | 1662829 | 2021-08-28 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1662830 | 1662830 | 2021-08-28 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1662831 | 1662831 | 2021-08-28 | Carter | Oklahoma | 40019 | 7441 | 134 |
1662832 | 1662832 | 2021-08-28 | Cherokee | Oklahoma | 40021 | 7088 | 82 |
1662833 | 1662833 | 2021-08-28 | Choctaw | Oklahoma | 40023 | 2006 | 30 |
1662834 | 1662834 | 2021-08-28 | Cimarron | Oklahoma | 40025 | 273 | 2 |
1662835 | 1662835 | 2021-08-28 | Cleveland | Oklahoma | 40027 | 35791 | 465 |
1662836 | 1662836 | 2021-08-28 | Coal | Oklahoma | 40029 | 822 | 17 |
1662837 | 1662837 | 2021-08-28 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1662838 | 1662838 | 2021-08-28 | Cotton | Oklahoma | 40033 | 766 | 16 |
1662839 | 1662839 | 2021-08-28 | Craig | Oklahoma | 40035 | 2583 | 21 |
1662840 | 1662840 | 2021-08-28 | Creek | Oklahoma | 40037 | 8750 | 179 |
1662841 | 1662841 | 2021-08-28 | Custer | Oklahoma | 40039 | 4392 | 106 |
1662842 | 1662842 | 2021-08-28 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1662843 | 1662843 | 2021-08-28 | Dewey | Oklahoma | 40043 | 601 | 14 |
1662844 | 1662844 | 2021-08-28 | Ellis | Oklahoma | 40045 | 379 | 6 |
1662845 | 1662845 | 2021-08-28 | Garfield | Oklahoma | 40047 | 8414 | 141 |
1662846 | 1662846 | 2021-08-28 | Garvin | Oklahoma | 40049 | 4115 | 82 |
1662847 | 1662847 | 2021-08-28 | Grady | Oklahoma | 40051 | 6768 | 133 |
1662848 | 1662848 | 2021-08-28 | Grant | Oklahoma | 40053 | 600 | 7 |
1662849 | 1662849 | 2021-08-28 | Greer | Oklahoma | 40055 | 617 | 22 |
1662850 | 1662850 | 2021-08-28 | Harmon | Oklahoma | 40057 | 341 | 6 |
1662851 | 1662851 | 2021-08-28 | Harper | Oklahoma | 40059 | 433 | 8 |
1662852 | 1662852 | 2021-08-28 | Haskell | Oklahoma | 40061 | 1561 | 19 |
1662853 | 1662853 | 2021-08-28 | Hughes | Oklahoma | 40063 | 1410 | 30 |
1662854 | 1662854 | 2021-08-28 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1662855 | 1662855 | 2021-08-28 | Jefferson | Oklahoma | 40067 | 775 | 18 |
1662856 | 1662856 | 2021-08-28 | Johnston | Oklahoma | 40069 | 1631 | 38 |
1662857 | 1662857 | 2021-08-28 | Kay | Oklahoma | 40071 | 5949 | 132 |
1662858 | 1662858 | 2021-08-28 | Kingfisher | Oklahoma | 40073 | 2281 | 43 |
1662859 | 1662859 | 2021-08-28 | Kiowa | Oklahoma | 40075 | 910 | 28 |
1662860 | 1662860 | 2021-08-28 | Latimer | Oklahoma | 40077 | 1057 | 13 |
1662861 | 1662861 | 2021-08-28 | Le Flore | Oklahoma | 40079 | 6703 | 71 |
1662862 | 1662862 | 2021-08-28 | Lincoln | Oklahoma | 40081 | 3882 | 79 |
1662863 | 1662863 | 2021-08-28 | Logan | Oklahoma | 40083 | 4904 | 70 |
1662864 | 1662864 | 2021-08-28 | Love | Oklahoma | 40085 | 1726 | 23 |
1662865 | 1662865 | 2021-08-28 | Major | Oklahoma | 40093 | 1043 | 24 |
1662866 | 1662866 | 2021-08-28 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1662867 | 1662867 | 2021-08-28 | Mayes | Oklahoma | 40097 | 5441 | 80 |
1662868 | 1662868 | 2021-08-28 | McClain | Oklahoma | 40087 | 6279 | 77 |
1662869 | 1662869 | 2021-08-28 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1662870 | 1662870 | 2021-08-28 | McIntosh | Oklahoma | 40091 | 2354 | 63 |
1662871 | 1662871 | 2021-08-28 | Murray | Oklahoma | 40099 | 2286 | 46 |
1662872 | 1662872 | 2021-08-28 | Muskogee | Oklahoma | 40101 | 11097 | 193 |
1662873 | 1662873 | 2021-08-28 | Noble | Oklahoma | 40103 | 1551 | 23 |
1662874 | 1662874 | 2021-08-28 | Nowata | Oklahoma | 40105 | 1439 | 22 |
1662875 | 1662875 | 2021-08-28 | Okfuskee | Oklahoma | 40107 | 2043 | 32 |
1662876 | 1662876 | 2021-08-28 | Oklahoma | Oklahoma | 40109 | 99695 | 1356 |
1662877 | 1662877 | 2021-08-28 | Okmulgee | Oklahoma | 40111 | 4708 | 91 |
1662878 | 1662878 | 2021-08-28 | Osage | Oklahoma | 40113 | 5714 | 92 |
1662879 | 1662879 | 2021-08-28 | Ottawa | Oklahoma | 40115 | 5267 | 82 |
1662880 | 1662880 | 2021-08-28 | Pawnee | Oklahoma | 40117 | 2199 | 55 |
1662881 | 1662881 | 2021-08-28 | Payne | Oklahoma | 40119 | 9909 | 79 |
1662882 | 1662882 | 2021-08-28 | Pittsburg | Oklahoma | 40121 | 5418 | 81 |
1662883 | 1662883 | 2021-08-28 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1662884 | 1662884 | 2021-08-28 | Pottawatomie | Oklahoma | 40125 | 9515 | 134 |
1662885 | 1662885 | 2021-08-28 | Pushmataha | Oklahoma | 40127 | 1371 | 25 |
1662886 | 1662886 | 2021-08-28 | Roger Mills | Oklahoma | 40129 | 427 | 12 |
1662887 | 1662887 | 2021-08-28 | Rogers | Oklahoma | 40131 | 13103 | 205 |
1662888 | 1662888 | 2021-08-28 | Seminole | Oklahoma | 40133 | 3228 | 82 |
1662889 | 1662889 | 2021-08-28 | Sequoyah | Oklahoma | 40135 | 5420 | 61 |
1662890 | 1662890 | 2021-08-28 | Stephens | Oklahoma | 40137 | 5699 | 108 |
1662891 | 1662891 | 2021-08-28 | Texas | Oklahoma | 40139 | 3660 | 35 |
1662892 | 1662892 | 2021-08-28 | Tillman | Oklahoma | 40141 | 873 | 18 |
1662893 | 1662893 | 2021-08-28 | Tulsa | Oklahoma | 40143 | 90347 | 1228 |
1662894 | 1662894 | 2021-08-28 | Unknown | Oklahoma | 12001 | 0 | |
1662895 | 1662895 | 2021-08-28 | Wagoner | Oklahoma | 40145 | 10036 | 140 |
1662896 | 1662896 | 2021-08-28 | Washington | Oklahoma | 40147 | 6824 | 132 |
1662897 | 1662897 | 2021-08-28 | Washita | Oklahoma | 40149 | 1215 | 23 |
1662898 | 1662898 | 2021-08-28 | Woods | Oklahoma | 40151 | 1388 | 18 |
1662899 | 1662899 | 2021-08-28 | Woodward | Oklahoma | 40153 | 3287 | 38 |
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);