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-09-03 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
497747 | 497747 | 2020-09-03 | Adair | Oklahoma | 40001 | 483 | 10 |
497748 | 497748 | 2020-09-03 | Alfalfa | Oklahoma | 40003 | 14 | 0 |
497749 | 497749 | 2020-09-03 | Atoka | Oklahoma | 40005 | 153 | 1 |
497750 | 497750 | 2020-09-03 | Beaver | Oklahoma | 40007 | 44 | 0 |
497751 | 497751 | 2020-09-03 | Beckham | Oklahoma | 40009 | 129 | 1 |
497752 | 497752 | 2020-09-03 | Blaine | Oklahoma | 40011 | 79 | 1 |
497753 | 497753 | 2020-09-03 | Bryan | Oklahoma | 40013 | 624 | 3 |
497754 | 497754 | 2020-09-03 | Caddo | Oklahoma | 40015 | 580 | 20 |
497755 | 497755 | 2020-09-03 | Canadian | Oklahoma | 40017 | 1568 | 13 |
497756 | 497756 | 2020-09-03 | Carter | Oklahoma | 40019 | 418 | 7 |
497757 | 497757 | 2020-09-03 | Cherokee | Oklahoma | 40021 | 722 | 7 |
497758 | 497758 | 2020-09-03 | Choctaw | Oklahoma | 40023 | 253 | 2 |
497759 | 497759 | 2020-09-03 | Cimarron | Oklahoma | 40025 | 14 | 0 |
497760 | 497760 | 2020-09-03 | Cleveland | Oklahoma | 40027 | 4105 | 65 |
497761 | 497761 | 2020-09-03 | Coal | Oklahoma | 40029 | 60 | 0 |
497762 | 497762 | 2020-09-03 | Comanche | Oklahoma | 40031 | 1283 | 11 |
497763 | 497763 | 2020-09-03 | Cotton | Oklahoma | 40033 | 34 | 2 |
497764 | 497764 | 2020-09-03 | Craig | Oklahoma | 40035 | 144 | 1 |
497765 | 497765 | 2020-09-03 | Creek | Oklahoma | 40037 | 846 | 22 |
497766 | 497766 | 2020-09-03 | Custer | Oklahoma | 40039 | 336 | 0 |
497767 | 497767 | 2020-09-03 | Delaware | Oklahoma | 40041 | 556 | 22 |
497768 | 497768 | 2020-09-03 | Dewey | Oklahoma | 40043 | 24 | 1 |
497769 | 497769 | 2020-09-03 | Ellis | Oklahoma | 40045 | 6 | 0 |
497770 | 497770 | 2020-09-03 | Garfield | Oklahoma | 40047 | 1061 | 12 |
497771 | 497771 | 2020-09-03 | Garvin | Oklahoma | 40049 | 266 | 4 |
497772 | 497772 | 2020-09-03 | Grady | Oklahoma | 40051 | 547 | 7 |
497773 | 497773 | 2020-09-03 | Grant | Oklahoma | 40053 | 27 | 0 |
497774 | 497774 | 2020-09-03 | Greer | Oklahoma | 40055 | 88 | 8 |
497775 | 497775 | 2020-09-03 | Harmon | Oklahoma | 40057 | 40 | 0 |
497776 | 497776 | 2020-09-03 | Harper | Oklahoma | 40059 | 18 | 0 |
497777 | 497777 | 2020-09-03 | Haskell | Oklahoma | 40061 | 174 | 4 |
497778 | 497778 | 2020-09-03 | Hughes | Oklahoma | 40063 | 223 | 4 |
497779 | 497779 | 2020-09-03 | Jackson | Oklahoma | 40065 | 602 | 9 |
497780 | 497780 | 2020-09-03 | Jefferson | Oklahoma | 40067 | 36 | 0 |
497781 | 497781 | 2020-09-03 | Johnston | Oklahoma | 40069 | 99 | 2 |
497782 | 497782 | 2020-09-03 | Kay | Oklahoma | 40071 | 340 | 12 |
497783 | 497783 | 2020-09-03 | Kingfisher | Oklahoma | 40073 | 263 | 2 |
497784 | 497784 | 2020-09-03 | Kiowa | Oklahoma | 40075 | 46 | 1 |
497785 | 497785 | 2020-09-03 | Latimer | Oklahoma | 40077 | 114 | 2 |
497786 | 497786 | 2020-09-03 | Le Flore | Oklahoma | 40079 | 721 | 9 |
497787 | 497787 | 2020-09-03 | Lincoln | Oklahoma | 40081 | 314 | 9 |
497788 | 497788 | 2020-09-03 | Logan | Oklahoma | 40083 | 310 | 1 |
497789 | 497789 | 2020-09-03 | Love | Oklahoma | 40085 | 114 | 1 |
497790 | 497790 | 2020-09-03 | Major | Oklahoma | 40093 | 54 | 1 |
497791 | 497791 | 2020-09-03 | Marshall | Oklahoma | 40095 | 133 | 1 |
497792 | 497792 | 2020-09-03 | Mayes | Oklahoma | 40097 | 426 | 10 |
497793 | 497793 | 2020-09-03 | McClain | Oklahoma | 40087 | 599 | 4 |
497794 | 497794 | 2020-09-03 | McCurtain | Oklahoma | 40089 | 1056 | 30 |
497795 | 497795 | 2020-09-03 | McIntosh | Oklahoma | 40091 | 241 | 4 |
497796 | 497796 | 2020-09-03 | Murray | Oklahoma | 40099 | 90 | 1 |
497797 | 497797 | 2020-09-03 | Muskogee | Oklahoma | 40101 | 1408 | 17 |
497798 | 497798 | 2020-09-03 | Noble | Oklahoma | 40103 | 113 | 2 |
497799 | 497799 | 2020-09-03 | Nowata | Oklahoma | 40105 | 104 | 1 |
497800 | 497800 | 2020-09-03 | Okfuskee | Oklahoma | 40107 | 110 | 3 |
497801 | 497801 | 2020-09-03 | Oklahoma | Oklahoma | 40109 | 13791 | 158 |
497802 | 497802 | 2020-09-03 | Okmulgee | Oklahoma | 40111 | 640 | 5 |
497803 | 497803 | 2020-09-03 | Osage | Oklahoma | 40113 | 657 | 12 |
497804 | 497804 | 2020-09-03 | Ottawa | Oklahoma | 40115 | 555 | 4 |
497805 | 497805 | 2020-09-03 | Pawnee | Oklahoma | 40117 | 223 | 3 |
497806 | 497806 | 2020-09-03 | Payne | Oklahoma | 40119 | 1319 | 5 |
497807 | 497807 | 2020-09-03 | Pittsburg | Oklahoma | 40121 | 602 | 18 |
497808 | 497808 | 2020-09-03 | Pontotoc | Oklahoma | 40123 | 249 | 3 |
497809 | 497809 | 2020-09-03 | Pottawatomie | Oklahoma | 40125 | 887 | 9 |
497810 | 497810 | 2020-09-03 | Pushmataha | Oklahoma | 40127 | 131 | 1 |
497811 | 497811 | 2020-09-03 | Roger Mills | Oklahoma | 40129 | 14 | 1 |
497812 | 497812 | 2020-09-03 | Rogers | Oklahoma | 40131 | 1348 | 42 |
497813 | 497813 | 2020-09-03 | Seminole | Oklahoma | 40133 | 338 | 5 |
497814 | 497814 | 2020-09-03 | Sequoyah | Oklahoma | 40135 | 591 | 8 |
497815 | 497815 | 2020-09-03 | Stephens | Oklahoma | 40137 | 256 | 4 |
497816 | 497816 | 2020-09-03 | Texas | Oklahoma | 40139 | 1189 | 7 |
497817 | 497817 | 2020-09-03 | Tillman | Oklahoma | 40141 | 70 | 1 |
497818 | 497818 | 2020-09-03 | Tulsa | Oklahoma | 40143 | 13742 | 136 |
497819 | 497819 | 2020-09-03 | Unknown | Oklahoma | 40 | 0 | |
497820 | 497820 | 2020-09-03 | Wagoner | Oklahoma | 40145 | 1188 | 23 |
497821 | 497821 | 2020-09-03 | Washington | Oklahoma | 40147 | 816 | 40 |
497822 | 497822 | 2020-09-03 | Washita | Oklahoma | 40149 | 43 | 0 |
497823 | 497823 | 2020-09-03 | Woods | Oklahoma | 40151 | 26 | 0 |
497824 | 497824 | 2020-09-03 | Woodward | Oklahoma | 40153 | 100 | 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);