ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where date = "2020-07-25" 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 |
---|---|---|---|---|---|---|---|
368772 | 368772 | 2020-07-25 | Adair | Oklahoma | 40001 | 227 | 5 |
368773 | 368773 | 2020-07-25 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
368774 | 368774 | 2020-07-25 | Atoka | Oklahoma | 40005 | 55 | 0 |
368775 | 368775 | 2020-07-25 | Beaver | Oklahoma | 40007 | 36 | 0 |
368776 | 368776 | 2020-07-25 | Beckham | Oklahoma | 40009 | 30 | 0 |
368777 | 368777 | 2020-07-25 | Blaine | Oklahoma | 40011 | 27 | 0 |
368778 | 368778 | 2020-07-25 | Bryan | Oklahoma | 40013 | 303 | 1 |
368779 | 368779 | 2020-07-25 | Caddo | Oklahoma | 40015 | 272 | 12 |
368780 | 368780 | 2020-07-25 | Canadian | Oklahoma | 40017 | 795 | 4 |
368781 | 368781 | 2020-07-25 | Carter | Oklahoma | 40019 | 243 | 3 |
368782 | 368782 | 2020-07-25 | Cherokee | Oklahoma | 40021 | 211 | 1 |
368783 | 368783 | 2020-07-25 | Choctaw | Oklahoma | 40023 | 152 | 1 |
368784 | 368784 | 2020-07-25 | Cimarron | Oklahoma | 40025 | 1 | 0 |
368785 | 368785 | 2020-07-25 | Cleveland | Oklahoma | 40027 | 2048 | 41 |
368786 | 368786 | 2020-07-25 | Coal | Oklahoma | 40029 | 24 | 0 |
368787 | 368787 | 2020-07-25 | Comanche | Oklahoma | 40031 | 659 | 9 |
368788 | 368788 | 2020-07-25 | Cotton | Oklahoma | 40033 | 16 | 2 |
368789 | 368789 | 2020-07-25 | Craig | Oklahoma | 40035 | 53 | 0 |
368790 | 368790 | 2020-07-25 | Creek | Oklahoma | 40037 | 341 | 12 |
368791 | 368791 | 2020-07-25 | Custer | Oklahoma | 40039 | 158 | 0 |
368792 | 368792 | 2020-07-25 | Delaware | Oklahoma | 40041 | 351 | 19 |
368793 | 368793 | 2020-07-25 | Dewey | Oklahoma | 40043 | 4 | 0 |
368794 | 368794 | 2020-07-25 | Ellis | Oklahoma | 40045 | 4 | 0 |
368795 | 368795 | 2020-07-25 | Garfield | Oklahoma | 40047 | 227 | 3 |
368796 | 368796 | 2020-07-25 | Garvin | Oklahoma | 40049 | 172 | 4 |
368797 | 368797 | 2020-07-25 | Grady | Oklahoma | 40051 | 352 | 6 |
368798 | 368798 | 2020-07-25 | Grant | Oklahoma | 40053 | 6 | 0 |
368799 | 368799 | 2020-07-25 | Greer | Oklahoma | 40055 | 78 | 7 |
368800 | 368800 | 2020-07-25 | Harmon | Oklahoma | 40057 | 5 | 0 |
368801 | 368801 | 2020-07-25 | Harper | Oklahoma | 40059 | 4 | 0 |
368802 | 368802 | 2020-07-25 | Haskell | Oklahoma | 40061 | 24 | 0 |
368803 | 368803 | 2020-07-25 | Hughes | Oklahoma | 40063 | 53 | 1 |
368804 | 368804 | 2020-07-25 | Jackson | Oklahoma | 40065 | 346 | 3 |
368805 | 368805 | 2020-07-25 | Jefferson | Oklahoma | 40067 | 23 | 0 |
368806 | 368806 | 2020-07-25 | Johnston | Oklahoma | 40069 | 28 | 0 |
368807 | 368807 | 2020-07-25 | Kay | Oklahoma | 40071 | 172 | 9 |
368808 | 368808 | 2020-07-25 | Kingfisher | Oklahoma | 40073 | 75 | 0 |
368809 | 368809 | 2020-07-25 | Kiowa | Oklahoma | 40075 | 23 | 1 |
368810 | 368810 | 2020-07-25 | Latimer | Oklahoma | 40077 | 37 | 1 |
368811 | 368811 | 2020-07-25 | Le Flore | Oklahoma | 40079 | 120 | 1 |
368812 | 368812 | 2020-07-25 | Lincoln | Oklahoma | 40081 | 74 | 2 |
368813 | 368813 | 2020-07-25 | Logan | Oklahoma | 40083 | 143 | 1 |
368814 | 368814 | 2020-07-25 | Love | Oklahoma | 40085 | 60 | 0 |
368815 | 368815 | 2020-07-25 | Major | Oklahoma | 40093 | 22 | 1 |
368816 | 368816 | 2020-07-25 | Marshall | Oklahoma | 40095 | 59 | 0 |
368817 | 368817 | 2020-07-25 | Mayes | Oklahoma | 40097 | 234 | 5 |
368818 | 368818 | 2020-07-25 | McClain | Oklahoma | 40087 | 336 | 4 |
368819 | 368819 | 2020-07-25 | McCurtain | Oklahoma | 40089 | 762 | 20 |
368820 | 368820 | 2020-07-25 | McIntosh | Oklahoma | 40091 | 124 | 1 |
368821 | 368821 | 2020-07-25 | Murray | Oklahoma | 40099 | 49 | 0 |
368822 | 368822 | 2020-07-25 | Muskogee | Oklahoma | 40101 | 316 | 16 |
368823 | 368823 | 2020-07-25 | Noble | Oklahoma | 40103 | 71 | 2 |
368824 | 368824 | 2020-07-25 | Nowata | Oklahoma | 40105 | 45 | 1 |
368825 | 368825 | 2020-07-25 | Okfuskee | Oklahoma | 40107 | 33 | 0 |
368826 | 368826 | 2020-07-25 | Oklahoma | Oklahoma | 40109 | 7415 | 90 |
368827 | 368827 | 2020-07-25 | Okmulgee | Oklahoma | 40111 | 280 | 0 |
368828 | 368828 | 2020-07-25 | Osage | Oklahoma | 40113 | 284 | 10 |
368829 | 368829 | 2020-07-25 | Ottawa | Oklahoma | 40115 | 260 | 2 |
368830 | 368830 | 2020-07-25 | Pawnee | Oklahoma | 40117 | 101 | 3 |
368831 | 368831 | 2020-07-25 | Payne | Oklahoma | 40119 | 583 | 3 |
368832 | 368832 | 2020-07-25 | Pittsburg | Oklahoma | 40121 | 125 | 3 |
368833 | 368833 | 2020-07-25 | Pontotoc | Oklahoma | 40123 | 124 | 2 |
368834 | 368834 | 2020-07-25 | Pottawatomie | Oklahoma | 40125 | 270 | 6 |
368835 | 368835 | 2020-07-25 | Pushmataha | Oklahoma | 40127 | 53 | 0 |
368836 | 368836 | 2020-07-25 | Roger Mills | Oklahoma | 40129 | 6 | 0 |
368837 | 368837 | 2020-07-25 | Rogers | Oklahoma | 40131 | 577 | 12 |
368838 | 368838 | 2020-07-25 | Seminole | Oklahoma | 40133 | 127 | 5 |
368839 | 368839 | 2020-07-25 | Sequoyah | Oklahoma | 40135 | 138 | 3 |
368840 | 368840 | 2020-07-25 | Stephens | Oklahoma | 40137 | 142 | 1 |
368841 | 368841 | 2020-07-25 | Texas | Oklahoma | 40139 | 1016 | 7 |
368842 | 368842 | 2020-07-25 | Tillman | Oklahoma | 40141 | 43 | 1 |
368843 | 368843 | 2020-07-25 | Tulsa | Oklahoma | 40143 | 7307 | 90 |
368844 | 368844 | 2020-07-25 | Wagoner | Oklahoma | 40145 | 562 | 20 |
368845 | 368845 | 2020-07-25 | Washington | Oklahoma | 40147 | 526 | 39 |
368846 | 368846 | 2020-07-25 | Washita | Oklahoma | 40149 | 17 | 0 |
368847 | 368847 | 2020-07-25 | Woods | Oklahoma | 40151 | 14 | 0 |
368848 | 368848 | 2020-07-25 | Woodward | Oklahoma | 40153 | 27 | 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);