ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2020-08-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 |
---|---|---|---|---|---|---|---|
468646 | 468646 | 2020-08-25 | Adair | Oklahoma | 40001 | 413 | 6 |
468647 | 468647 | 2020-08-25 | Alfalfa | Oklahoma | 40003 | 12 | 0 |
468648 | 468648 | 2020-08-25 | Atoka | Oklahoma | 40005 | 101 | 1 |
468649 | 468649 | 2020-08-25 | Beaver | Oklahoma | 40007 | 42 | 0 |
468650 | 468650 | 2020-08-25 | Beckham | Oklahoma | 40009 | 118 | 1 |
468651 | 468651 | 2020-08-25 | Blaine | Oklahoma | 40011 | 62 | 0 |
468652 | 468652 | 2020-08-25 | Bryan | Oklahoma | 40013 | 559 | 3 |
468653 | 468653 | 2020-08-25 | Caddo | Oklahoma | 40015 | 513 | 20 |
468654 | 468654 | 2020-08-25 | Canadian | Oklahoma | 40017 | 1433 | 11 |
468655 | 468655 | 2020-08-25 | Carter | Oklahoma | 40019 | 396 | 6 |
468656 | 468656 | 2020-08-25 | Cherokee | Oklahoma | 40021 | 589 | 4 |
468657 | 468657 | 2020-08-25 | Choctaw | Oklahoma | 40023 | 229 | 1 |
468658 | 468658 | 2020-08-25 | Cimarron | Oklahoma | 40025 | 14 | 0 |
468659 | 468659 | 2020-08-25 | Cleveland | Oklahoma | 40027 | 3581 | 63 |
468660 | 468660 | 2020-08-25 | Coal | Oklahoma | 40029 | 50 | 0 |
468661 | 468661 | 2020-08-25 | Comanche | Oklahoma | 40031 | 1181 | 11 |
468662 | 468662 | 2020-08-25 | Cotton | Oklahoma | 40033 | 25 | 2 |
468663 | 468663 | 2020-08-25 | Craig | Oklahoma | 40035 | 108 | 1 |
468664 | 468664 | 2020-08-25 | Creek | Oklahoma | 40037 | 758 | 19 |
468665 | 468665 | 2020-08-25 | Custer | Oklahoma | 40039 | 292 | 0 |
468666 | 468666 | 2020-08-25 | Delaware | Oklahoma | 40041 | 511 | 20 |
468667 | 468667 | 2020-08-25 | Dewey | Oklahoma | 40043 | 19 | 0 |
468668 | 468668 | 2020-08-25 | Ellis | Oklahoma | 40045 | 6 | 0 |
468669 | 468669 | 2020-08-25 | Garfield | Oklahoma | 40047 | 795 | 9 |
468670 | 468670 | 2020-08-25 | Garvin | Oklahoma | 40049 | 255 | 4 |
468671 | 468671 | 2020-08-25 | Grady | Oklahoma | 40051 | 499 | 7 |
468672 | 468672 | 2020-08-25 | Grant | Oklahoma | 40053 | 22 | 0 |
468673 | 468673 | 2020-08-25 | Greer | Oklahoma | 40055 | 86 | 8 |
468674 | 468674 | 2020-08-25 | Harmon | Oklahoma | 40057 | 37 | 0 |
468675 | 468675 | 2020-08-25 | Harper | Oklahoma | 40059 | 17 | 0 |
468676 | 468676 | 2020-08-25 | Haskell | Oklahoma | 40061 | 151 | 2 |
468677 | 468677 | 2020-08-25 | Hughes | Oklahoma | 40063 | 199 | 3 |
468678 | 468678 | 2020-08-25 | Jackson | Oklahoma | 40065 | 570 | 7 |
468679 | 468679 | 2020-08-25 | Jefferson | Oklahoma | 40067 | 34 | 0 |
468680 | 468680 | 2020-08-25 | Johnston | Oklahoma | 40069 | 70 | 0 |
468681 | 468681 | 2020-08-25 | Kay | Oklahoma | 40071 | 291 | 11 |
468682 | 468682 | 2020-08-25 | Kingfisher | Oklahoma | 40073 | 238 | 0 |
468683 | 468683 | 2020-08-25 | Kiowa | Oklahoma | 40075 | 40 | 1 |
468684 | 468684 | 2020-08-25 | Latimer | Oklahoma | 40077 | 107 | 2 |
468685 | 468685 | 2020-08-25 | Le Flore | Oklahoma | 40079 | 560 | 3 |
468686 | 468686 | 2020-08-25 | Lincoln | Oklahoma | 40081 | 276 | 5 |
468687 | 468687 | 2020-08-25 | Logan | Oklahoma | 40083 | 268 | 1 |
468688 | 468688 | 2020-08-25 | Love | Oklahoma | 40085 | 88 | 0 |
468689 | 468689 | 2020-08-25 | Major | Oklahoma | 40093 | 43 | 1 |
468690 | 468690 | 2020-08-25 | Marshall | Oklahoma | 40095 | 127 | 1 |
468691 | 468691 | 2020-08-25 | Mayes | Oklahoma | 40097 | 395 | 8 |
468692 | 468692 | 2020-08-25 | McClain | Oklahoma | 40087 | 540 | 4 |
468693 | 468693 | 2020-08-25 | McCurtain | Oklahoma | 40089 | 968 | 29 |
468694 | 468694 | 2020-08-25 | McIntosh | Oklahoma | 40091 | 225 | 4 |
468695 | 468695 | 2020-08-25 | Murray | Oklahoma | 40099 | 87 | 0 |
468696 | 468696 | 2020-08-25 | Muskogee | Oklahoma | 40101 | 681 | 16 |
468697 | 468697 | 2020-08-25 | Noble | Oklahoma | 40103 | 99 | 2 |
468698 | 468698 | 2020-08-25 | Nowata | Oklahoma | 40105 | 81 | 1 |
468699 | 468699 | 2020-08-25 | Okfuskee | Oklahoma | 40107 | 91 | 3 |
468700 | 468700 | 2020-08-25 | Oklahoma | Oklahoma | 40109 | 12765 | 145 |
468701 | 468701 | 2020-08-25 | Okmulgee | Oklahoma | 40111 | 578 | 4 |
468702 | 468702 | 2020-08-25 | Osage | Oklahoma | 40113 | 602 | 12 |
468703 | 468703 | 2020-08-25 | Ottawa | Oklahoma | 40115 | 476 | 4 |
468704 | 468704 | 2020-08-25 | Pawnee | Oklahoma | 40117 | 197 | 3 |
468705 | 468705 | 2020-08-25 | Payne | Oklahoma | 40119 | 950 | 5 |
468706 | 468706 | 2020-08-25 | Pittsburg | Oklahoma | 40121 | 545 | 14 |
468707 | 468707 | 2020-08-25 | Pontotoc | Oklahoma | 40123 | 227 | 2 |
468708 | 468708 | 2020-08-25 | Pottawatomie | Oklahoma | 40125 | 766 | 9 |
468709 | 468709 | 2020-08-25 | Pushmataha | Oklahoma | 40127 | 121 | 1 |
468710 | 468710 | 2020-08-25 | Roger Mills | Oklahoma | 40129 | 13 | 1 |
468711 | 468711 | 2020-08-25 | Rogers | Oklahoma | 40131 | 1224 | 31 |
468712 | 468712 | 2020-08-25 | Seminole | Oklahoma | 40133 | 294 | 5 |
468713 | 468713 | 2020-08-25 | Sequoyah | Oklahoma | 40135 | 520 | 6 |
468714 | 468714 | 2020-08-25 | Stephens | Oklahoma | 40137 | 237 | 4 |
468715 | 468715 | 2020-08-25 | Texas | Oklahoma | 40139 | 1114 | 7 |
468716 | 468716 | 2020-08-25 | Tillman | Oklahoma | 40141 | 63 | 1 |
468717 | 468717 | 2020-08-25 | Tulsa | Oklahoma | 40143 | 12559 | 127 |
468718 | 468718 | 2020-08-25 | Unknown | Oklahoma | 7 | 0 | |
468719 | 468719 | 2020-08-25 | Wagoner | Oklahoma | 40145 | 1075 | 23 |
468720 | 468720 | 2020-08-25 | Washington | Oklahoma | 40147 | 746 | 39 |
468721 | 468721 | 2020-08-25 | Washita | Oklahoma | 40149 | 42 | 0 |
468722 | 468722 | 2020-08-25 | Woods | Oklahoma | 40151 | 24 | 0 |
468723 | 468723 | 2020-08-25 | Woodward | Oklahoma | 40153 | 75 | 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);