ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2020-08-21 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
455733 | 455733 | 2020-08-21 | Adair | Oklahoma | 40001 | 395 | 6 |
455734 | 455734 | 2020-08-21 | Alfalfa | Oklahoma | 40003 | 7 | 0 |
455735 | 455735 | 2020-08-21 | Atoka | Oklahoma | 40005 | 91 | 1 |
455736 | 455736 | 2020-08-21 | Beaver | Oklahoma | 40007 | 41 | 0 |
455737 | 455737 | 2020-08-21 | Beckham | Oklahoma | 40009 | 109 | 1 |
455738 | 455738 | 2020-08-21 | Blaine | Oklahoma | 40011 | 53 | 0 |
455739 | 455739 | 2020-08-21 | Bryan | Oklahoma | 40013 | 538 | 3 |
455740 | 455740 | 2020-08-21 | Caddo | Oklahoma | 40015 | 499 | 20 |
455741 | 455741 | 2020-08-21 | Canadian | Oklahoma | 40017 | 1393 | 9 |
455742 | 455742 | 2020-08-21 | Carter | Oklahoma | 40019 | 388 | 6 |
455743 | 455743 | 2020-08-21 | Cherokee | Oklahoma | 40021 | 562 | 3 |
455744 | 455744 | 2020-08-21 | Choctaw | Oklahoma | 40023 | 218 | 1 |
455745 | 455745 | 2020-08-21 | Cimarron | Oklahoma | 40025 | 14 | 0 |
455746 | 455746 | 2020-08-21 | Cleveland | Oklahoma | 40027 | 3469 | 62 |
455747 | 455747 | 2020-08-21 | Coal | Oklahoma | 40029 | 46 | 0 |
455748 | 455748 | 2020-08-21 | Comanche | Oklahoma | 40031 | 987 | 11 |
455749 | 455749 | 2020-08-21 | Cotton | Oklahoma | 40033 | 22 | 2 |
455750 | 455750 | 2020-08-21 | Craig | Oklahoma | 40035 | 98 | 1 |
455751 | 455751 | 2020-08-21 | Creek | Oklahoma | 40037 | 735 | 19 |
455752 | 455752 | 2020-08-21 | Custer | Oklahoma | 40039 | 257 | 0 |
455753 | 455753 | 2020-08-21 | Delaware | Oklahoma | 40041 | 493 | 20 |
455754 | 455754 | 2020-08-21 | Dewey | Oklahoma | 40043 | 18 | 0 |
455755 | 455755 | 2020-08-21 | Ellis | Oklahoma | 40045 | 6 | 0 |
455756 | 455756 | 2020-08-21 | Garfield | Oklahoma | 40047 | 704 | 9 |
455757 | 455757 | 2020-08-21 | Garvin | Oklahoma | 40049 | 250 | 4 |
455758 | 455758 | 2020-08-21 | Grady | Oklahoma | 40051 | 489 | 7 |
455759 | 455759 | 2020-08-21 | Grant | Oklahoma | 40053 | 18 | 0 |
455760 | 455760 | 2020-08-21 | Greer | Oklahoma | 40055 | 84 | 8 |
455761 | 455761 | 2020-08-21 | Harmon | Oklahoma | 40057 | 36 | 0 |
455762 | 455762 | 2020-08-21 | Harper | Oklahoma | 40059 | 14 | 0 |
455763 | 455763 | 2020-08-21 | Haskell | Oklahoma | 40061 | 139 | 2 |
455764 | 455764 | 2020-08-21 | Hughes | Oklahoma | 40063 | 191 | 3 |
455765 | 455765 | 2020-08-21 | Jackson | Oklahoma | 40065 | 555 | 7 |
455766 | 455766 | 2020-08-21 | Jefferson | Oklahoma | 40067 | 34 | 0 |
455767 | 455767 | 2020-08-21 | Johnston | Oklahoma | 40069 | 61 | 0 |
455768 | 455768 | 2020-08-21 | Kay | Oklahoma | 40071 | 281 | 11 |
455769 | 455769 | 2020-08-21 | Kingfisher | Oklahoma | 40073 | 192 | 0 |
455770 | 455770 | 2020-08-21 | Kiowa | Oklahoma | 40075 | 36 | 1 |
455771 | 455771 | 2020-08-21 | Latimer | Oklahoma | 40077 | 104 | 2 |
455772 | 455772 | 2020-08-21 | Le Flore | Oklahoma | 40079 | 504 | 3 |
455773 | 455773 | 2020-08-21 | Lincoln | Oklahoma | 40081 | 261 | 5 |
455774 | 455774 | 2020-08-21 | Logan | Oklahoma | 40083 | 259 | 1 |
455775 | 455775 | 2020-08-21 | Love | Oklahoma | 40085 | 83 | 0 |
455776 | 455776 | 2020-08-21 | Major | Oklahoma | 40093 | 42 | 1 |
455777 | 455777 | 2020-08-21 | Marshall | Oklahoma | 40095 | 124 | 1 |
455778 | 455778 | 2020-08-21 | Mayes | Oklahoma | 40097 | 383 | 8 |
455779 | 455779 | 2020-08-21 | McClain | Oklahoma | 40087 | 519 | 4 |
455780 | 455780 | 2020-08-21 | McCurtain | Oklahoma | 40089 | 929 | 29 |
455781 | 455781 | 2020-08-21 | McIntosh | Oklahoma | 40091 | 217 | 3 |
455782 | 455782 | 2020-08-21 | Murray | Oklahoma | 40099 | 84 | 0 |
455783 | 455783 | 2020-08-21 | Muskogee | Oklahoma | 40101 | 639 | 16 |
455784 | 455784 | 2020-08-21 | Noble | Oklahoma | 40103 | 93 | 2 |
455785 | 455785 | 2020-08-21 | Nowata | Oklahoma | 40105 | 73 | 1 |
455786 | 455786 | 2020-08-21 | Okfuskee | Oklahoma | 40107 | 90 | 3 |
455787 | 455787 | 2020-08-21 | Oklahoma | Oklahoma | 40109 | 12328 | 139 |
455788 | 455788 | 2020-08-21 | Okmulgee | Oklahoma | 40111 | 553 | 4 |
455789 | 455789 | 2020-08-21 | Osage | Oklahoma | 40113 | 589 | 12 |
455790 | 455790 | 2020-08-21 | Ottawa | Oklahoma | 40115 | 456 | 3 |
455791 | 455791 | 2020-08-21 | Pawnee | Oklahoma | 40117 | 186 | 3 |
455792 | 455792 | 2020-08-21 | Payne | Oklahoma | 40119 | 874 | 4 |
455793 | 455793 | 2020-08-21 | Pittsburg | Oklahoma | 40121 | 510 | 12 |
455794 | 455794 | 2020-08-21 | Pontotoc | Oklahoma | 40123 | 220 | 2 |
455795 | 455795 | 2020-08-21 | Pottawatomie | Oklahoma | 40125 | 640 | 9 |
455796 | 455796 | 2020-08-21 | Pushmataha | Oklahoma | 40127 | 119 | 0 |
455797 | 455797 | 2020-08-21 | Roger Mills | Oklahoma | 40129 | 10 | 1 |
455798 | 455798 | 2020-08-21 | Rogers | Oklahoma | 40131 | 1185 | 24 |
455799 | 455799 | 2020-08-21 | Seminole | Oklahoma | 40133 | 277 | 5 |
455800 | 455800 | 2020-08-21 | Sequoyah | Oklahoma | 40135 | 488 | 5 |
455801 | 455801 | 2020-08-21 | Stephens | Oklahoma | 40137 | 228 | 3 |
455802 | 455802 | 2020-08-21 | Texas | Oklahoma | 40139 | 1090 | 7 |
455803 | 455803 | 2020-08-21 | Tillman | Oklahoma | 40141 | 59 | 1 |
455804 | 455804 | 2020-08-21 | Tulsa | Oklahoma | 40143 | 12095 | 123 |
455805 | 455805 | 2020-08-21 | Unknown | Oklahoma | 17 | 0 | |
455806 | 455806 | 2020-08-21 | Wagoner | Oklahoma | 40145 | 1034 | 23 |
455807 | 455807 | 2020-08-21 | Washington | Oklahoma | 40147 | 729 | 39 |
455808 | 455808 | 2020-08-21 | Washita | Oklahoma | 40149 | 37 | 0 |
455809 | 455809 | 2020-08-21 | Woods | Oklahoma | 40151 | 24 | 0 |
455810 | 455810 | 2020-08-21 | Woodward | Oklahoma | 40153 | 71 | 0 |
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);