ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where date = "2020-06-10" 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 |
---|---|---|---|---|---|---|---|
226655 | 226655 | 2020-06-10 | Adair | Oklahoma | 40001 | 95 | 4 |
226656 | 226656 | 2020-06-10 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
226657 | 226657 | 2020-06-10 | Atoka | Oklahoma | 40005 | 5 | 0 |
226658 | 226658 | 2020-06-10 | Beaver | Oklahoma | 40007 | 27 | 0 |
226659 | 226659 | 2020-06-10 | Beckham | Oklahoma | 40009 | 7 | 0 |
226660 | 226660 | 2020-06-10 | Blaine | Oklahoma | 40011 | 9 | 0 |
226661 | 226661 | 2020-06-10 | Bryan | Oklahoma | 40013 | 46 | 1 |
226662 | 226662 | 2020-06-10 | Caddo | Oklahoma | 40015 | 173 | 10 |
226663 | 226663 | 2020-06-10 | Canadian | Oklahoma | 40017 | 144 | 3 |
226664 | 226664 | 2020-06-10 | Carter | Oklahoma | 40019 | 55 | 1 |
226665 | 226665 | 2020-06-10 | Cherokee | Oklahoma | 40021 | 37 | 1 |
226666 | 226666 | 2020-06-10 | Choctaw | Oklahoma | 40023 | 101 | 1 |
226667 | 226667 | 2020-06-10 | Cimarron | Oklahoma | 40025 | 1 | 0 |
226668 | 226668 | 2020-06-10 | Cleveland | Oklahoma | 40027 | 529 | 40 |
226669 | 226669 | 2020-06-10 | Coal | Oklahoma | 40029 | 5 | 0 |
226670 | 226670 | 2020-06-10 | Comanche | Oklahoma | 40031 | 312 | 3 |
226671 | 226671 | 2020-06-10 | Cotton | Oklahoma | 40033 | 5 | 2 |
226672 | 226672 | 2020-06-10 | Craig | Oklahoma | 40035 | 16 | 0 |
226673 | 226673 | 2020-06-10 | Creek | Oklahoma | 40037 | 102 | 7 |
226674 | 226674 | 2020-06-10 | Custer | Oklahoma | 40039 | 37 | 0 |
226675 | 226675 | 2020-06-10 | Delaware | Oklahoma | 40041 | 104 | 16 |
226676 | 226676 | 2020-06-10 | Dewey | Oklahoma | 40043 | 2 | 0 |
226677 | 226677 | 2020-06-10 | Garfield | Oklahoma | 40047 | 31 | 1 |
226678 | 226678 | 2020-06-10 | Garvin | Oklahoma | 40049 | 20 | 1 |
226679 | 226679 | 2020-06-10 | Grady | Oklahoma | 40051 | 115 | 3 |
226680 | 226680 | 2020-06-10 | Grant | Oklahoma | 40053 | 2 | 0 |
226681 | 226681 | 2020-06-10 | Greer | Oklahoma | 40055 | 66 | 7 |
226682 | 226682 | 2020-06-10 | Harper | Oklahoma | 40059 | 1 | 0 |
226683 | 226683 | 2020-06-10 | Haskell | Oklahoma | 40061 | 6 | 0 |
226684 | 226684 | 2020-06-10 | Hughes | Oklahoma | 40063 | 3 | 0 |
226685 | 226685 | 2020-06-10 | Jackson | Oklahoma | 40065 | 30 | 3 |
226686 | 226686 | 2020-06-10 | Jefferson | Oklahoma | 40067 | 4 | 0 |
226687 | 226687 | 2020-06-10 | Johnston | Oklahoma | 40069 | 3 | 0 |
226688 | 226688 | 2020-06-10 | Kay | Oklahoma | 40071 | 60 | 7 |
226689 | 226689 | 2020-06-10 | Kingfisher | Oklahoma | 40073 | 12 | 0 |
226690 | 226690 | 2020-06-10 | Kiowa | Oklahoma | 40075 | 6 | 0 |
226691 | 226691 | 2020-06-10 | Latimer | Oklahoma | 40077 | 5 | 1 |
226692 | 226692 | 2020-06-10 | Le Flore | Oklahoma | 40079 | 16 | 1 |
226693 | 226693 | 2020-06-10 | Lincoln | Oklahoma | 40081 | 22 | 2 |
226694 | 226694 | 2020-06-10 | Logan | Oklahoma | 40083 | 21 | 1 |
226695 | 226695 | 2020-06-10 | Love | Oklahoma | 40085 | 20 | 0 |
226696 | 226696 | 2020-06-10 | Major | Oklahoma | 40093 | 6 | 1 |
226697 | 226697 | 2020-06-10 | Marshall | Oklahoma | 40095 | 12 | 0 |
226698 | 226698 | 2020-06-10 | Mayes | Oklahoma | 40097 | 37 | 4 |
226699 | 226699 | 2020-06-10 | McClain | Oklahoma | 40087 | 110 | 4 |
226700 | 226700 | 2020-06-10 | McCurtain | Oklahoma | 40089 | 117 | 1 |
226701 | 226701 | 2020-06-10 | McIntosh | Oklahoma | 40091 | 14 | 1 |
226702 | 226702 | 2020-06-10 | Murray | Oklahoma | 40099 | 6 | 0 |
226703 | 226703 | 2020-06-10 | Muskogee | Oklahoma | 40101 | 67 | 7 |
226704 | 226704 | 2020-06-10 | Noble | Oklahoma | 40103 | 7 | 0 |
226705 | 226705 | 2020-06-10 | Nowata | Oklahoma | 40105 | 24 | 1 |
226706 | 226706 | 2020-06-10 | Okfuskee | Oklahoma | 40107 | 6 | 0 |
226707 | 226707 | 2020-06-10 | Oklahoma | Oklahoma | 40109 | 1436 | 64 |
226708 | 226708 | 2020-06-10 | Okmulgee | Oklahoma | 40111 | 29 | 0 |
226709 | 226709 | 2020-06-10 | Osage | Oklahoma | 40113 | 103 | 8 |
226710 | 226710 | 2020-06-10 | Ottawa | Oklahoma | 40115 | 35 | 2 |
226711 | 226711 | 2020-06-10 | Pawnee | Oklahoma | 40117 | 35 | 2 |
226712 | 226712 | 2020-06-10 | Payne | Oklahoma | 40119 | 55 | 1 |
226713 | 226713 | 2020-06-10 | Pittsburg | Oklahoma | 40121 | 44 | 3 |
226714 | 226714 | 2020-06-10 | Pontotoc | Oklahoma | 40123 | 20 | 2 |
226715 | 226715 | 2020-06-10 | Pottawatomie | Oklahoma | 40125 | 66 | 4 |
226716 | 226716 | 2020-06-10 | Pushmataha | Oklahoma | 40127 | 6 | 0 |
226717 | 226717 | 2020-06-10 | Rogers | Oklahoma | 40131 | 92 | 5 |
226718 | 226718 | 2020-06-10 | Seminole | Oklahoma | 40133 | 30 | 3 |
226719 | 226719 | 2020-06-10 | Sequoyah | Oklahoma | 40135 | 19 | 3 |
226720 | 226720 | 2020-06-10 | Stephens | Oklahoma | 40137 | 43 | 1 |
226721 | 226721 | 2020-06-10 | Texas | Oklahoma | 40139 | 955 | 6 |
226722 | 226722 | 2020-06-10 | Tillman | Oklahoma | 40141 | 23 | 1 |
226723 | 226723 | 2020-06-10 | Tulsa | Oklahoma | 40143 | 1308 | 61 |
226724 | 226724 | 2020-06-10 | Wagoner | Oklahoma | 40145 | 161 | 17 |
226725 | 226725 | 2020-06-10 | Washington | Oklahoma | 40147 | 343 | 37 |
226726 | 226726 | 2020-06-10 | Washita | Oklahoma | 40149 | 2 | 0 |
226727 | 226727 | 2020-06-10 | Woods | Oklahoma | 40151 | 5 | 0 |
226728 | 226728 | 2020-06-10 | Woodward | Oklahoma | 40153 | 8 | 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);