ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-24" 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 |
---|---|---|---|---|---|---|---|
1649831 | 1649831 | 2021-08-24 | Adair | Oklahoma | 40001 | 3931 | 47 |
1649832 | 1649832 | 2021-08-24 | Alfalfa | Oklahoma | 40003 | 1195 | 7 |
1649833 | 1649833 | 2021-08-24 | Atoka | Oklahoma | 40005 | 2142 | 28 |
1649834 | 1649834 | 2021-08-24 | Beaver | Oklahoma | 40007 | 482 | 6 |
1649835 | 1649835 | 2021-08-24 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1649836 | 1649836 | 2021-08-24 | Blaine | Oklahoma | 40011 | 1134 | 21 |
1649837 | 1649837 | 2021-08-24 | Bryan | Oklahoma | 40013 | 7087 | 80 |
1649838 | 1649838 | 2021-08-24 | Caddo | Oklahoma | 40015 | 4343 | 97 |
1649839 | 1649839 | 2021-08-24 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1649840 | 1649840 | 2021-08-24 | Carter | Oklahoma | 40019 | 7252 | 133 |
1649841 | 1649841 | 2021-08-24 | Cherokee | Oklahoma | 40021 | 6717 | 80 |
1649842 | 1649842 | 2021-08-24 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1649843 | 1649843 | 2021-08-24 | Cimarron | Oklahoma | 40025 | 263 | 2 |
1649844 | 1649844 | 2021-08-24 | Cleveland | Oklahoma | 40027 | 34799 | 457 |
1649845 | 1649845 | 2021-08-24 | Coal | Oklahoma | 40029 | 804 | 15 |
1649846 | 1649846 | 2021-08-24 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1649847 | 1649847 | 2021-08-24 | Cotton | Oklahoma | 40033 | 754 | 16 |
1649848 | 1649848 | 2021-08-24 | Craig | Oklahoma | 40035 | 2522 | 21 |
1649849 | 1649849 | 2021-08-24 | Creek | Oklahoma | 40037 | 8480 | 171 |
1649850 | 1649850 | 2021-08-24 | Custer | Oklahoma | 40039 | 4329 | 106 |
1649851 | 1649851 | 2021-08-24 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1649852 | 1649852 | 2021-08-24 | Dewey | Oklahoma | 40043 | 590 | 14 |
1649853 | 1649853 | 2021-08-24 | Ellis | Oklahoma | 40045 | 376 | 6 |
1649854 | 1649854 | 2021-08-24 | Garfield | Oklahoma | 40047 | 8288 | 140 |
1649855 | 1649855 | 2021-08-24 | Garvin | Oklahoma | 40049 | 3991 | 81 |
1649856 | 1649856 | 2021-08-24 | Grady | Oklahoma | 40051 | 6562 | 133 |
1649857 | 1649857 | 2021-08-24 | Grant | Oklahoma | 40053 | 594 | 7 |
1649858 | 1649858 | 2021-08-24 | Greer | Oklahoma | 40055 | 608 | 22 |
1649859 | 1649859 | 2021-08-24 | Harmon | Oklahoma | 40057 | 341 | 6 |
1649860 | 1649860 | 2021-08-24 | Harper | Oklahoma | 40059 | 430 | 8 |
1649861 | 1649861 | 2021-08-24 | Haskell | Oklahoma | 40061 | 1489 | 19 |
1649862 | 1649862 | 2021-08-24 | Hughes | Oklahoma | 40063 | 1379 | 30 |
1649863 | 1649863 | 2021-08-24 | Jackson | Oklahoma | 40065 | 3292 | 56 |
1649864 | 1649864 | 2021-08-24 | Jefferson | Oklahoma | 40067 | 763 | 18 |
1649865 | 1649865 | 2021-08-24 | Johnston | Oklahoma | 40069 | 1593 | 38 |
1649866 | 1649866 | 2021-08-24 | Kay | Oklahoma | 40071 | 5795 | 132 |
1649867 | 1649867 | 2021-08-24 | Kingfisher | Oklahoma | 40073 | 2225 | 42 |
1649868 | 1649868 | 2021-08-24 | Kiowa | Oklahoma | 40075 | 892 | 27 |
1649869 | 1649869 | 2021-08-24 | Latimer | Oklahoma | 40077 | 1011 | 13 |
1649870 | 1649870 | 2021-08-24 | Le Flore | Oklahoma | 40079 | 6441 | 71 |
1649871 | 1649871 | 2021-08-24 | Lincoln | Oklahoma | 40081 | 3756 | 76 |
1649872 | 1649872 | 2021-08-24 | Logan | Oklahoma | 40083 | 4756 | 67 |
1649873 | 1649873 | 2021-08-24 | Love | Oklahoma | 40085 | 1677 | 23 |
1649874 | 1649874 | 2021-08-24 | Major | Oklahoma | 40093 | 1019 | 24 |
1649875 | 1649875 | 2021-08-24 | Marshall | Oklahoma | 40095 | 2289 | 24 |
1649876 | 1649876 | 2021-08-24 | Mayes | Oklahoma | 40097 | 5205 | 77 |
1649877 | 1649877 | 2021-08-24 | McClain | Oklahoma | 40087 | 6093 | 75 |
1649878 | 1649878 | 2021-08-24 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1649879 | 1649879 | 2021-08-24 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1649880 | 1649880 | 2021-08-24 | Murray | Oklahoma | 40099 | 2243 | 45 |
1649881 | 1649881 | 2021-08-24 | Muskogee | Oklahoma | 40101 | 10804 | 189 |
1649882 | 1649882 | 2021-08-24 | Noble | Oklahoma | 40103 | 1536 | 22 |
1649883 | 1649883 | 2021-08-24 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1649884 | 1649884 | 2021-08-24 | Okfuskee | Oklahoma | 40107 | 1971 | 32 |
1649885 | 1649885 | 2021-08-24 | Oklahoma | Oklahoma | 40109 | 96822 | 1346 |
1649886 | 1649886 | 2021-08-24 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1649887 | 1649887 | 2021-08-24 | Osage | Oklahoma | 40113 | 5556 | 86 |
1649888 | 1649888 | 2021-08-24 | Ottawa | Oklahoma | 40115 | 5172 | 81 |
1649889 | 1649889 | 2021-08-24 | Pawnee | Oklahoma | 40117 | 2137 | 54 |
1649890 | 1649890 | 2021-08-24 | Payne | Oklahoma | 40119 | 9597 | 77 |
1649891 | 1649891 | 2021-08-24 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1649892 | 1649892 | 2021-08-24 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1649893 | 1649893 | 2021-08-24 | Pottawatomie | Oklahoma | 40125 | 9301 | 134 |
1649894 | 1649894 | 2021-08-24 | Pushmataha | Oklahoma | 40127 | 1314 | 24 |
1649895 | 1649895 | 2021-08-24 | Roger Mills | Oklahoma | 40129 | 419 | 12 |
1649896 | 1649896 | 2021-08-24 | Rogers | Oklahoma | 40131 | 12735 | 203 |
1649897 | 1649897 | 2021-08-24 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1649898 | 1649898 | 2021-08-24 | Sequoyah | Oklahoma | 40135 | 5140 | 58 |
1649899 | 1649899 | 2021-08-24 | Stephens | Oklahoma | 40137 | 5562 | 107 |
1649900 | 1649900 | 2021-08-24 | Texas | Oklahoma | 40139 | 3625 | 35 |
1649901 | 1649901 | 2021-08-24 | Tillman | Oklahoma | 40141 | 861 | 18 |
1649902 | 1649902 | 2021-08-24 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1649903 | 1649903 | 2021-08-24 | Unknown | Oklahoma | 16707 | 0 | |
1649904 | 1649904 | 2021-08-24 | Wagoner | Oklahoma | 40145 | 9733 | 131 |
1649905 | 1649905 | 2021-08-24 | Washington | Oklahoma | 40147 | 6540 | 130 |
1649906 | 1649906 | 2021-08-24 | Washita | Oklahoma | 40149 | 1180 | 23 |
1649907 | 1649907 | 2021-08-24 | Woods | Oklahoma | 40151 | 1348 | 18 |
1649908 | 1649908 | 2021-08-24 | Woodward | Oklahoma | 40153 | 3262 | 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);