ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-07" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1594607 | 1594607 | 2021-08-07 | Adair | Oklahoma | 40001 | 3601 | 45 |
1594608 | 1594608 | 2021-08-07 | Alfalfa | Oklahoma | 40003 | 1166 | 7 |
1594609 | 1594609 | 2021-08-07 | Atoka | Oklahoma | 40005 | 1972 | 28 |
1594610 | 1594610 | 2021-08-07 | Beaver | Oklahoma | 40007 | 475 | 6 |
1594611 | 1594611 | 2021-08-07 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1594612 | 1594612 | 2021-08-07 | Blaine | Oklahoma | 40011 | 1089 | 21 |
1594613 | 1594613 | 2021-08-07 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1594614 | 1594614 | 2021-08-07 | Caddo | Oklahoma | 40015 | 4130 | 96 |
1594615 | 1594615 | 2021-08-07 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1594616 | 1594616 | 2021-08-07 | Carter | Oklahoma | 40019 | 6875 | 132 |
1594617 | 1594617 | 2021-08-07 | Cherokee | Oklahoma | 40021 | 6118 | 79 |
1594618 | 1594618 | 2021-08-07 | Choctaw | Oklahoma | 40023 | 1743 | 27 |
1594619 | 1594619 | 2021-08-07 | Cimarron | Oklahoma | 40025 | 249 | 2 |
1594620 | 1594620 | 2021-08-07 | Cleveland | Oklahoma | 40027 | 32870 | 449 |
1594621 | 1594621 | 2021-08-07 | Coal | Oklahoma | 40029 | 738 | 15 |
1594622 | 1594622 | 2021-08-07 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1594623 | 1594623 | 2021-08-07 | Cotton | Oklahoma | 40033 | 713 | 16 |
1594624 | 1594624 | 2021-08-07 | Craig | Oklahoma | 40035 | 2358 | 20 |
1594625 | 1594625 | 2021-08-07 | Creek | Oklahoma | 40037 | 7892 | 169 |
1594626 | 1594626 | 2021-08-07 | Custer | Oklahoma | 40039 | 4197 | 105 |
1594627 | 1594627 | 2021-08-07 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1594628 | 1594628 | 2021-08-07 | Dewey | Oklahoma | 40043 | 568 | 14 |
1594629 | 1594629 | 2021-08-07 | Ellis | Oklahoma | 40045 | 374 | 6 |
1594630 | 1594630 | 2021-08-07 | Garfield | Oklahoma | 40047 | 8052 | 139 |
1594631 | 1594631 | 2021-08-07 | Garvin | Oklahoma | 40049 | 3874 | 79 |
1594632 | 1594632 | 2021-08-07 | Grady | Oklahoma | 40051 | 6220 | 131 |
1594633 | 1594633 | 2021-08-07 | Grant | Oklahoma | 40053 | 577 | 7 |
1594634 | 1594634 | 2021-08-07 | Greer | Oklahoma | 40055 | 598 | 22 |
1594635 | 1594635 | 2021-08-07 | Harmon | Oklahoma | 40057 | 335 | 6 |
1594636 | 1594636 | 2021-08-07 | Harper | Oklahoma | 40059 | 428 | 8 |
1594637 | 1594637 | 2021-08-07 | Haskell | Oklahoma | 40061 | 1381 | 18 |
1594638 | 1594638 | 2021-08-07 | Hughes | Oklahoma | 40063 | 1299 | 30 |
1594639 | 1594639 | 2021-08-07 | Jackson | Oklahoma | 40065 | 3219 | 56 |
1594640 | 1594640 | 2021-08-07 | Jefferson | Oklahoma | 40067 | 741 | 18 |
1594641 | 1594641 | 2021-08-07 | Johnston | Oklahoma | 40069 | 1519 | 37 |
1594642 | 1594642 | 2021-08-07 | Kay | Oklahoma | 40071 | 5561 | 128 |
1594643 | 1594643 | 2021-08-07 | Kingfisher | Oklahoma | 40073 | 2116 | 42 |
1594644 | 1594644 | 2021-08-07 | Kiowa | Oklahoma | 40075 | 856 | 27 |
1594645 | 1594645 | 2021-08-07 | Latimer | Oklahoma | 40077 | 925 | 13 |
1594646 | 1594646 | 2021-08-07 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1594647 | 1594647 | 2021-08-07 | Lincoln | Oklahoma | 40081 | 3509 | 74 |
1594648 | 1594648 | 2021-08-07 | Logan | Oklahoma | 40083 | 4523 | 66 |
1594649 | 1594649 | 2021-08-07 | Love | Oklahoma | 40085 | 1609 | 23 |
1594650 | 1594650 | 2021-08-07 | Major | Oklahoma | 40093 | 980 | 24 |
1594651 | 1594651 | 2021-08-07 | Marshall | Oklahoma | 40095 | 2193 | 23 |
1594652 | 1594652 | 2021-08-07 | Mayes | Oklahoma | 40097 | 4789 | 76 |
1594653 | 1594653 | 2021-08-07 | McClain | Oklahoma | 40087 | 5762 | 74 |
1594654 | 1594654 | 2021-08-07 | McCurtain | Oklahoma | 40089 | 4159 | 95 |
1594655 | 1594655 | 2021-08-07 | McIntosh | Oklahoma | 40091 | 2173 | 63 |
1594656 | 1594656 | 2021-08-07 | Murray | Oklahoma | 40099 | 2133 | 44 |
1594657 | 1594657 | 2021-08-07 | Muskogee | Oklahoma | 40101 | 10165 | 180 |
1594658 | 1594658 | 2021-08-07 | Noble | Oklahoma | 40103 | 1448 | 20 |
1594659 | 1594659 | 2021-08-07 | Nowata | Oklahoma | 40105 | 1237 | 20 |
1594660 | 1594660 | 2021-08-07 | Okfuskee | Oklahoma | 40107 | 1888 | 32 |
1594661 | 1594661 | 2021-08-07 | Oklahoma | Oklahoma | 40109 | 91719 | 1329 |
1594662 | 1594662 | 2021-08-07 | Okmulgee | Oklahoma | 40111 | 4192 | 87 |
1594663 | 1594663 | 2021-08-07 | Osage | Oklahoma | 40113 | 5130 | 84 |
1594664 | 1594664 | 2021-08-07 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1594665 | 1594665 | 2021-08-07 | Pawnee | Oklahoma | 40117 | 1949 | 53 |
1594666 | 1594666 | 2021-08-07 | Payne | Oklahoma | 40119 | 9076 | 77 |
1594667 | 1594667 | 2021-08-07 | Pittsburg | Oklahoma | 40121 | 4967 | 79 |
1594668 | 1594668 | 2021-08-07 | Pontotoc | Oklahoma | 40123 | 5370 | 80 |
1594669 | 1594669 | 2021-08-07 | Pottawatomie | Oklahoma | 40125 | 8871 | 133 |
1594670 | 1594670 | 2021-08-07 | Pushmataha | Oklahoma | 40127 | 1185 | 23 |
1594671 | 1594671 | 2021-08-07 | Roger Mills | Oklahoma | 40129 | 402 | 12 |
1594672 | 1594672 | 2021-08-07 | Rogers | Oklahoma | 40131 | 11834 | 198 |
1594673 | 1594673 | 2021-08-07 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1594674 | 1594674 | 2021-08-07 | Sequoyah | Oklahoma | 40135 | 4580 | 57 |
1594675 | 1594675 | 2021-08-07 | Stephens | Oklahoma | 40137 | 5207 | 107 |
1594676 | 1594676 | 2021-08-07 | Texas | Oklahoma | 40139 | 3595 | 35 |
1594677 | 1594677 | 2021-08-07 | Tillman | Oklahoma | 40141 | 838 | 17 |
1594678 | 1594678 | 2021-08-07 | Tulsa | Oklahoma | 40143 | 82644 | 1162 |
1594679 | 1594679 | 2021-08-07 | Unknown | Oklahoma | 7854 | 0 | |
1594680 | 1594680 | 2021-08-07 | Wagoner | Oklahoma | 40145 | 8907 | 125 |
1594681 | 1594681 | 2021-08-07 | Washington | Oklahoma | 40147 | 5929 | 123 |
1594682 | 1594682 | 2021-08-07 | Washita | Oklahoma | 40149 | 1136 | 23 |
1594683 | 1594683 | 2021-08-07 | Woods | Oklahoma | 40151 | 1278 | 18 |
1594684 | 1594684 | 2021-08-07 | Woodward | Oklahoma | 40153 | 3209 | 37 |
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);