ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-16" 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 |
---|---|---|---|---|---|---|---|
1623842 | 1623842 | 2021-08-16 | Adair | Oklahoma | 40001 | 3776 | 46 |
1623843 | 1623843 | 2021-08-16 | Alfalfa | Oklahoma | 40003 | 1178 | 7 |
1623844 | 1623844 | 2021-08-16 | Atoka | Oklahoma | 40005 | 2078 | 28 |
1623845 | 1623845 | 2021-08-16 | Beaver | Oklahoma | 40007 | 480 | 6 |
1623846 | 1623846 | 2021-08-16 | Beckham | Oklahoma | 40009 | 2986 | 58 |
1623847 | 1623847 | 2021-08-16 | Blaine | Oklahoma | 40011 | 1111 | 21 |
1623848 | 1623848 | 2021-08-16 | Bryan | Oklahoma | 40013 | 6879 | 80 |
1623849 | 1623849 | 2021-08-16 | Caddo | Oklahoma | 40015 | 4210 | 97 |
1623850 | 1623850 | 2021-08-16 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1623851 | 1623851 | 2021-08-16 | Carter | Oklahoma | 40019 | 7092 | 132 |
1623852 | 1623852 | 2021-08-16 | Cherokee | Oklahoma | 40021 | 6381 | 79 |
1623853 | 1623853 | 2021-08-16 | Choctaw | Oklahoma | 40023 | 1809 | 28 |
1623854 | 1623854 | 2021-08-16 | Cimarron | Oklahoma | 40025 | 255 | 2 |
1623855 | 1623855 | 2021-08-16 | Cleveland | Oklahoma | 40027 | 33753 | 454 |
1623856 | 1623856 | 2021-08-16 | Coal | Oklahoma | 40029 | 784 | 15 |
1623857 | 1623857 | 2021-08-16 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1623858 | 1623858 | 2021-08-16 | Cotton | Oklahoma | 40033 | 732 | 16 |
1623859 | 1623859 | 2021-08-16 | Craig | Oklahoma | 40035 | 2446 | 20 |
1623860 | 1623860 | 2021-08-16 | Creek | Oklahoma | 40037 | 8173 | 169 |
1623861 | 1623861 | 2021-08-16 | Custer | Oklahoma | 40039 | 4257 | 106 |
1623862 | 1623862 | 2021-08-16 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1623863 | 1623863 | 2021-08-16 | Dewey | Oklahoma | 40043 | 582 | 14 |
1623864 | 1623864 | 2021-08-16 | Ellis | Oklahoma | 40045 | 374 | 6 |
1623865 | 1623865 | 2021-08-16 | Garfield | Oklahoma | 40047 | 8176 | 140 |
1623866 | 1623866 | 2021-08-16 | Garvin | Oklahoma | 40049 | 3929 | 80 |
1623867 | 1623867 | 2021-08-16 | Grady | Oklahoma | 40051 | 6330 | 131 |
1623868 | 1623868 | 2021-08-16 | Grant | Oklahoma | 40053 | 586 | 7 |
1623869 | 1623869 | 2021-08-16 | Greer | Oklahoma | 40055 | 603 | 22 |
1623870 | 1623870 | 2021-08-16 | Harmon | Oklahoma | 40057 | 340 | 6 |
1623871 | 1623871 | 2021-08-16 | Harper | Oklahoma | 40059 | 429 | 8 |
1623872 | 1623872 | 2021-08-16 | Haskell | Oklahoma | 40061 | 1423 | 19 |
1623873 | 1623873 | 2021-08-16 | Hughes | Oklahoma | 40063 | 1336 | 30 |
1623874 | 1623874 | 2021-08-16 | Jackson | Oklahoma | 40065 | 3254 | 56 |
1623875 | 1623875 | 2021-08-16 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1623876 | 1623876 | 2021-08-16 | Johnston | Oklahoma | 40069 | 1553 | 38 |
1623877 | 1623877 | 2021-08-16 | Kay | Oklahoma | 40071 | 5671 | 129 |
1623878 | 1623878 | 2021-08-16 | Kingfisher | Oklahoma | 40073 | 2170 | 42 |
1623879 | 1623879 | 2021-08-16 | Kiowa | Oklahoma | 40075 | 872 | 27 |
1623880 | 1623880 | 2021-08-16 | Latimer | Oklahoma | 40077 | 971 | 13 |
1623881 | 1623881 | 2021-08-16 | Le Flore | Oklahoma | 40079 | 6274 | 71 |
1623882 | 1623882 | 2021-08-16 | Lincoln | Oklahoma | 40081 | 3622 | 75 |
1623883 | 1623883 | 2021-08-16 | Logan | Oklahoma | 40083 | 4649 | 67 |
1623884 | 1623884 | 2021-08-16 | Love | Oklahoma | 40085 | 1639 | 23 |
1623885 | 1623885 | 2021-08-16 | Major | Oklahoma | 40093 | 999 | 24 |
1623886 | 1623886 | 2021-08-16 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1623887 | 1623887 | 2021-08-16 | Mayes | Oklahoma | 40097 | 4985 | 77 |
1623888 | 1623888 | 2021-08-16 | McClain | Oklahoma | 40087 | 5911 | 74 |
1623889 | 1623889 | 2021-08-16 | McCurtain | Oklahoma | 40089 | 4289 | 95 |
1623890 | 1623890 | 2021-08-16 | McIntosh | Oklahoma | 40091 | 2226 | 63 |
1623891 | 1623891 | 2021-08-16 | Murray | Oklahoma | 40099 | 2190 | 45 |
1623892 | 1623892 | 2021-08-16 | Muskogee | Oklahoma | 40101 | 10454 | 187 |
1623893 | 1623893 | 2021-08-16 | Noble | Oklahoma | 40103 | 1496 | 21 |
1623894 | 1623894 | 2021-08-16 | Nowata | Oklahoma | 40105 | 1300 | 20 |
1623895 | 1623895 | 2021-08-16 | Okfuskee | Oklahoma | 40107 | 1933 | 32 |
1623896 | 1623896 | 2021-08-16 | Oklahoma | Oklahoma | 40109 | 94069 | 1335 |
1623897 | 1623897 | 2021-08-16 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1623898 | 1623898 | 2021-08-16 | Osage | Oklahoma | 40113 | 5345 | 86 |
1623899 | 1623899 | 2021-08-16 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1623900 | 1623900 | 2021-08-16 | Pawnee | Oklahoma | 40117 | 2035 | 53 |
1623901 | 1623901 | 2021-08-16 | Payne | Oklahoma | 40119 | 9326 | 77 |
1623902 | 1623902 | 2021-08-16 | Pittsburg | Oklahoma | 40121 | 5091 | 80 |
1623903 | 1623903 | 2021-08-16 | Pontotoc | Oklahoma | 40123 | 5477 | 80 |
1623904 | 1623904 | 2021-08-16 | Pottawatomie | Oklahoma | 40125 | 9069 | 133 |
1623905 | 1623905 | 2021-08-16 | Pushmataha | Oklahoma | 40127 | 1242 | 24 |
1623906 | 1623906 | 2021-08-16 | Roger Mills | Oklahoma | 40129 | 411 | 12 |
1623907 | 1623907 | 2021-08-16 | Rogers | Oklahoma | 40131 | 12281 | 199 |
1623908 | 1623908 | 2021-08-16 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1623909 | 1623909 | 2021-08-16 | Sequoyah | Oklahoma | 40135 | 4859 | 57 |
1623910 | 1623910 | 2021-08-16 | Stephens | Oklahoma | 40137 | 5387 | 107 |
1623911 | 1623911 | 2021-08-16 | Texas | Oklahoma | 40139 | 3605 | 35 |
1623912 | 1623912 | 2021-08-16 | Tillman | Oklahoma | 40141 | 844 | 17 |
1623913 | 1623913 | 2021-08-16 | Tulsa | Oklahoma | 40143 | 85186 | 1180 |
1623914 | 1623914 | 2021-08-16 | Unknown | Oklahoma | 15617 | 0 | |
1623915 | 1623915 | 2021-08-16 | Wagoner | Oklahoma | 40145 | 9340 | 126 |
1623916 | 1623916 | 2021-08-16 | Washington | Oklahoma | 40147 | 6229 | 124 |
1623917 | 1623917 | 2021-08-16 | Washita | Oklahoma | 40149 | 1147 | 23 |
1623918 | 1623918 | 2021-08-16 | Woods | Oklahoma | 40151 | 1304 | 18 |
1623919 | 1623919 | 2021-08-16 | Woodward | Oklahoma | 40153 | 3228 | 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);