ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-12-07" 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 |
---|---|---|---|---|---|---|---|
805750 | 805750 | 2020-12-07 | Adair | Oklahoma | 40001 | 1355 | 13 |
805751 | 805751 | 2020-12-07 | Alfalfa | Oklahoma | 40003 | 527 | 1 |
805752 | 805752 | 2020-12-07 | Atoka | Oklahoma | 40005 | 924 | 1 |
805753 | 805753 | 2020-12-07 | Beaver | Oklahoma | 40007 | 239 | 2 |
805754 | 805754 | 2020-12-07 | Beckham | Oklahoma | 40009 | 1490 | 17 |
805755 | 805755 | 2020-12-07 | Blaine | Oklahoma | 40011 | 478 | 2 |
805756 | 805756 | 2020-12-07 | Bryan | Oklahoma | 40013 | 3031 | 25 |
805757 | 805757 | 2020-12-07 | Caddo | Oklahoma | 40015 | 2208 | 34 |
805758 | 805758 | 2020-12-07 | Canadian | Oklahoma | 40017 | 7864 | 35 |
805759 | 805759 | 2020-12-07 | Carter | Oklahoma | 40019 | 1895 | 16 |
805760 | 805760 | 2020-12-07 | Cherokee | Oklahoma | 40021 | 2576 | 13 |
805761 | 805761 | 2020-12-07 | Choctaw | Oklahoma | 40023 | 764 | 4 |
805762 | 805762 | 2020-12-07 | Cimarron | Oklahoma | 40025 | 82 | 0 |
805763 | 805763 | 2020-12-07 | Cleveland | Oklahoma | 40027 | 14428 | 132 |
805764 | 805764 | 2020-12-07 | Coal | Oklahoma | 40029 | 337 | 2 |
805765 | 805765 | 2020-12-07 | Comanche | Oklahoma | 40031 | 5377 | 39 |
805766 | 805766 | 2020-12-07 | Cotton | Oklahoma | 40033 | 312 | 4 |
805767 | 805767 | 2020-12-07 | Craig | Oklahoma | 40035 | 1074 | 3 |
805768 | 805768 | 2020-12-07 | Creek | Oklahoma | 40037 | 2966 | 52 |
805769 | 805769 | 2020-12-07 | Custer | Oklahoma | 40039 | 2283 | 18 |
805770 | 805770 | 2020-12-07 | Delaware | Oklahoma | 40041 | 2130 | 39 |
805771 | 805771 | 2020-12-07 | Dewey | Oklahoma | 40043 | 287 | 1 |
805772 | 805772 | 2020-12-07 | Ellis | Oklahoma | 40045 | 252 | 0 |
805773 | 805773 | 2020-12-07 | Garfield | Oklahoma | 40047 | 4277 | 37 |
805774 | 805774 | 2020-12-07 | Garvin | Oklahoma | 40049 | 1730 | 18 |
805775 | 805775 | 2020-12-07 | Grady | Oklahoma | 40051 | 3071 | 23 |
805776 | 805776 | 2020-12-07 | Grant | Oklahoma | 40053 | 238 | 5 |
805777 | 805777 | 2020-12-07 | Greer | Oklahoma | 40055 | 301 | 8 |
805778 | 805778 | 2020-12-07 | Harmon | Oklahoma | 40057 | 151 | 0 |
805779 | 805779 | 2020-12-07 | Harper | Oklahoma | 40059 | 272 | 2 |
805780 | 805780 | 2020-12-07 | Haskell | Oklahoma | 40061 | 672 | 7 |
805781 | 805781 | 2020-12-07 | Hughes | Oklahoma | 40063 | 639 | 8 |
805782 | 805782 | 2020-12-07 | Jackson | Oklahoma | 40065 | 2040 | 35 |
805783 | 805783 | 2020-12-07 | Jefferson | Oklahoma | 40067 | 275 | 2 |
805784 | 805784 | 2020-12-07 | Johnston | Oklahoma | 40069 | 589 | 5 |
805785 | 805785 | 2020-12-07 | Kay | Oklahoma | 40071 | 2121 | 26 |
805786 | 805786 | 2020-12-07 | Kingfisher | Oklahoma | 40073 | 1024 | 7 |
805787 | 805787 | 2020-12-07 | Kiowa | Oklahoma | 40075 | 437 | 8 |
805788 | 805788 | 2020-12-07 | Latimer | Oklahoma | 40077 | 328 | 4 |
805789 | 805789 | 2020-12-07 | Le Flore | Oklahoma | 40079 | 2674 | 28 |
805790 | 805790 | 2020-12-07 | Lincoln | Oklahoma | 40081 | 1550 | 26 |
805791 | 805791 | 2020-12-07 | Logan | Oklahoma | 40083 | 1786 | 4 |
805792 | 805792 | 2020-12-07 | Love | Oklahoma | 40085 | 667 | 1 |
805793 | 805793 | 2020-12-07 | Major | Oklahoma | 40093 | 592 | 4 |
805794 | 805794 | 2020-12-07 | Marshall | Oklahoma | 40095 | 867 | 4 |
805795 | 805795 | 2020-12-07 | Mayes | Oklahoma | 40097 | 1814 | 21 |
805796 | 805796 | 2020-12-07 | McClain | Oklahoma | 40087 | 2770 | 19 |
805797 | 805797 | 2020-12-07 | McCurtain | Oklahoma | 40089 | 2395 | 47 |
805798 | 805798 | 2020-12-07 | McIntosh | Oklahoma | 40091 | 926 | 13 |
805799 | 805799 | 2020-12-07 | Murray | Oklahoma | 40099 | 774 | 6 |
805800 | 805800 | 2020-12-07 | Muskogee | Oklahoma | 40101 | 4789 | 37 |
805801 | 805801 | 2020-12-07 | Noble | Oklahoma | 40103 | 649 | 4 |
805802 | 805802 | 2020-12-07 | Nowata | Oklahoma | 40105 | 469 | 5 |
805803 | 805803 | 2020-12-07 | Okfuskee | Oklahoma | 40107 | 1100 | 15 |
805804 | 805804 | 2020-12-07 | Oklahoma | Oklahoma | 40109 | 44851 | 334 |
805805 | 805805 | 2020-12-07 | Okmulgee | Oklahoma | 40111 | 1955 | 25 |
805806 | 805806 | 2020-12-07 | Osage | Oklahoma | 40113 | 2217 | 19 |
805807 | 805807 | 2020-12-07 | Ottawa | Oklahoma | 40115 | 1953 | 25 |
805808 | 805808 | 2020-12-07 | Pawnee | Oklahoma | 40117 | 687 | 9 |
805809 | 805809 | 2020-12-07 | Payne | Oklahoma | 40119 | 4664 | 23 |
805810 | 805810 | 2020-12-07 | Pittsburg | Oklahoma | 40121 | 2053 | 21 |
805811 | 805811 | 2020-12-07 | Pontotoc | Oklahoma | 40123 | 2234 | 15 |
805812 | 805812 | 2020-12-07 | Pottawatomie | Oklahoma | 40125 | 4064 | 23 |
805813 | 805813 | 2020-12-07 | Pushmataha | Oklahoma | 40127 | 444 | 6 |
805814 | 805814 | 2020-12-07 | Roger Mills | Oklahoma | 40129 | 197 | 6 |
805815 | 805815 | 2020-12-07 | Rogers | Oklahoma | 40131 | 4644 | 68 |
805816 | 805816 | 2020-12-07 | Seminole | Oklahoma | 40133 | 1362 | 12 |
805817 | 805817 | 2020-12-07 | Sequoyah | Oklahoma | 40135 | 1923 | 14 |
805818 | 805818 | 2020-12-07 | Stephens | Oklahoma | 40137 | 1946 | 19 |
805819 | 805819 | 2020-12-07 | Texas | Oklahoma | 40139 | 2544 | 13 |
805820 | 805820 | 2020-12-07 | Tillman | Oklahoma | 40141 | 393 | 7 |
805821 | 805821 | 2020-12-07 | Tulsa | Oklahoma | 40143 | 36702 | 289 |
805822 | 805822 | 2020-12-07 | Unknown | Oklahoma | 58 | 0 | |
805823 | 805823 | 2020-12-07 | Wagoner | Oklahoma | 40145 | 3096 | 38 |
805824 | 805824 | 2020-12-07 | Washington | Oklahoma | 40147 | 2302 | 50 |
805825 | 805825 | 2020-12-07 | Washita | Oklahoma | 40149 | 517 | 2 |
805826 | 805826 | 2020-12-07 | Woods | Oklahoma | 40151 | 668 | 3 |
805827 | 805827 | 2020-12-07 | Woodward | Oklahoma | 40153 | 2049 | 8 |
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);