ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-10-15" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
633786 | 633786 | 2020-10-15 | Adair | Oklahoma | 40001 | 715 | 11 |
633787 | 633787 | 2020-10-15 | Alfalfa | Oklahoma | 40003 | 101 | 0 |
633788 | 633788 | 2020-10-15 | Atoka | Oklahoma | 40005 | 373 | 1 |
633789 | 633789 | 2020-10-15 | Beaver | Oklahoma | 40007 | 76 | 0 |
633790 | 633790 | 2020-10-15 | Beckham | Oklahoma | 40009 | 737 | 8 |
633791 | 633791 | 2020-10-15 | Blaine | Oklahoma | 40011 | 166 | 1 |
633792 | 633792 | 2020-10-15 | Bryan | Oklahoma | 40013 | 1286 | 5 |
633793 | 633793 | 2020-10-15 | Caddo | Oklahoma | 40015 | 1022 | 23 |
633794 | 633794 | 2020-10-15 | Canadian | Oklahoma | 40017 | 3073 | 20 |
633795 | 633795 | 2020-10-15 | Carter | Oklahoma | 40019 | 703 | 9 |
633796 | 633796 | 2020-10-15 | Cherokee | Oklahoma | 40021 | 1279 | 8 |
633797 | 633797 | 2020-10-15 | Choctaw | Oklahoma | 40023 | 393 | 2 |
633798 | 633798 | 2020-10-15 | Cimarron | Oklahoma | 40025 | 32 | 0 |
633799 | 633799 | 2020-10-15 | Cleveland | Oklahoma | 40027 | 7337 | 85 |
633800 | 633800 | 2020-10-15 | Coal | Oklahoma | 40029 | 78 | 0 |
633801 | 633801 | 2020-10-15 | Comanche | Oklahoma | 40031 | 1990 | 15 |
633802 | 633802 | 2020-10-15 | Cotton | Oklahoma | 40033 | 77 | 3 |
633803 | 633803 | 2020-10-15 | Craig | Oklahoma | 40035 | 585 | 2 |
633804 | 633804 | 2020-10-15 | Creek | Oklahoma | 40037 | 1413 | 36 |
633805 | 633805 | 2020-10-15 | Custer | Oklahoma | 40039 | 968 | 2 |
633806 | 633806 | 2020-10-15 | Delaware | Oklahoma | 40041 | 1085 | 27 |
633807 | 633807 | 2020-10-15 | Dewey | Oklahoma | 40043 | 76 | 1 |
633808 | 633808 | 2020-10-15 | Ellis | Oklahoma | 40045 | 15 | 0 |
633809 | 633809 | 2020-10-15 | Garfield | Oklahoma | 40047 | 2131 | 23 |
633810 | 633810 | 2020-10-15 | Garvin | Oklahoma | 40049 | 547 | 6 |
633811 | 633811 | 2020-10-15 | Grady | Oklahoma | 40051 | 1414 | 13 |
633812 | 633812 | 2020-10-15 | Grant | Oklahoma | 40053 | 72 | 1 |
633813 | 633813 | 2020-10-15 | Greer | Oklahoma | 40055 | 128 | 8 |
633814 | 633814 | 2020-10-15 | Harmon | Oklahoma | 40057 | 61 | 0 |
633815 | 633815 | 2020-10-15 | Harper | Oklahoma | 40059 | 44 | 1 |
633816 | 633816 | 2020-10-15 | Haskell | Oklahoma | 40061 | 342 | 5 |
633817 | 633817 | 2020-10-15 | Hughes | Oklahoma | 40063 | 345 | 4 |
633818 | 633818 | 2020-10-15 | Jackson | Oklahoma | 40065 | 980 | 11 |
633819 | 633819 | 2020-10-15 | Jefferson | Oklahoma | 40067 | 63 | 0 |
633820 | 633820 | 2020-10-15 | Johnston | Oklahoma | 40069 | 251 | 4 |
633821 | 633821 | 2020-10-15 | Kay | Oklahoma | 40071 | 775 | 15 |
633822 | 633822 | 2020-10-15 | Kingfisher | Oklahoma | 40073 | 460 | 2 |
633823 | 633823 | 2020-10-15 | Kiowa | Oklahoma | 40075 | 145 | 2 |
633824 | 633824 | 2020-10-15 | Latimer | Oklahoma | 40077 | 166 | 2 |
633825 | 633825 | 2020-10-15 | Le Flore | Oklahoma | 40079 | 1495 | 21 |
633826 | 633826 | 2020-10-15 | Lincoln | Oklahoma | 40081 | 670 | 10 |
633827 | 633827 | 2020-10-15 | Logan | Oklahoma | 40083 | 696 | 2 |
633828 | 633828 | 2020-10-15 | Love | Oklahoma | 40085 | 242 | 1 |
633829 | 633829 | 2020-10-15 | Major | Oklahoma | 40093 | 128 | 2 |
633830 | 633830 | 2020-10-15 | Marshall | Oklahoma | 40095 | 235 | 2 |
633831 | 633831 | 2020-10-15 | Mayes | Oklahoma | 40097 | 857 | 11 |
633832 | 633832 | 2020-10-15 | McClain | Oklahoma | 40087 | 1135 | 8 |
633833 | 633833 | 2020-10-15 | McCurtain | Oklahoma | 40089 | 1474 | 37 |
633834 | 633834 | 2020-10-15 | McIntosh | Oklahoma | 40091 | 429 | 8 |
633835 | 633835 | 2020-10-15 | Murray | Oklahoma | 40099 | 239 | 2 |
633836 | 633836 | 2020-10-15 | Muskogee | Oklahoma | 40101 | 2133 | 27 |
633837 | 633837 | 2020-10-15 | Noble | Oklahoma | 40103 | 167 | 3 |
633838 | 633838 | 2020-10-15 | Nowata | Oklahoma | 40105 | 207 | 4 |
633839 | 633839 | 2020-10-15 | Okfuskee | Oklahoma | 40107 | 232 | 6 |
633840 | 633840 | 2020-10-15 | Oklahoma | Oklahoma | 40109 | 21260 | 212 |
633841 | 633841 | 2020-10-15 | Okmulgee | Oklahoma | 40111 | 1002 | 8 |
633842 | 633842 | 2020-10-15 | Osage | Oklahoma | 40113 | 1266 | 13 |
633843 | 633843 | 2020-10-15 | Ottawa | Oklahoma | 40115 | 1098 | 8 |
633844 | 633844 | 2020-10-15 | Pawnee | Oklahoma | 40117 | 294 | 5 |
633845 | 633845 | 2020-10-15 | Payne | Oklahoma | 40119 | 2618 | 9 |
633846 | 633846 | 2020-10-15 | Pittsburg | Oklahoma | 40121 | 1110 | 20 |
633847 | 633847 | 2020-10-15 | Pontotoc | Oklahoma | 40123 | 591 | 4 |
633848 | 633848 | 2020-10-15 | Pottawatomie | Oklahoma | 40125 | 1851 | 11 |
633849 | 633849 | 2020-10-15 | Pushmataha | Oklahoma | 40127 | 233 | 4 |
633850 | 633850 | 2020-10-15 | Roger Mills | Oklahoma | 40129 | 81 | 2 |
633851 | 633851 | 2020-10-15 | Rogers | Oklahoma | 40131 | 2206 | 53 |
633852 | 633852 | 2020-10-15 | Seminole | Oklahoma | 40133 | 655 | 6 |
633853 | 633853 | 2020-10-15 | Sequoyah | Oklahoma | 40135 | 1083 | 13 |
633854 | 633854 | 2020-10-15 | Stephens | Oklahoma | 40137 | 562 | 8 |
633855 | 633855 | 2020-10-15 | Texas | Oklahoma | 40139 | 1698 | 10 |
633856 | 633856 | 2020-10-15 | Tillman | Oklahoma | 40141 | 127 | 2 |
633857 | 633857 | 2020-10-15 | Tulsa | Oklahoma | 40143 | 19888 | 182 |
633858 | 633858 | 2020-10-15 | Unknown | Oklahoma | 21 | 0 | |
633859 | 633859 | 2020-10-15 | Wagoner | Oklahoma | 40145 | 1722 | 27 |
633860 | 633860 | 2020-10-15 | Washington | Oklahoma | 40147 | 1174 | 41 |
633861 | 633861 | 2020-10-15 | Washita | Oklahoma | 40149 | 140 | 0 |
633862 | 633862 | 2020-10-15 | Woods | Oklahoma | 40151 | 137 | 0 |
633863 | 633863 | 2020-10-15 | Woodward | Oklahoma | 40153 | 1176 | 5 |
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);