ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-10-06" 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 |
---|---|---|---|---|---|---|---|
1789523 | 1789523 | 2021-10-06 | Adair | Oklahoma | 40001 | 4783 | 56 |
1789524 | 1789524 | 2021-10-06 | Alfalfa | Oklahoma | 40003 | 1272 | 7 |
1789525 | 1789525 | 2021-10-06 | Atoka | Oklahoma | 40005 | 2655 | 30 |
1789526 | 1789526 | 2021-10-06 | Beaver | Oklahoma | 40007 | 539 | 6 |
1789527 | 1789527 | 2021-10-06 | Beckham | Oklahoma | 40009 | 3302 | 62 |
1789528 | 1789528 | 2021-10-06 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1789529 | 1789529 | 2021-10-06 | Bryan | Oklahoma | 40013 | 8379 | 100 |
1789530 | 1789530 | 2021-10-06 | Caddo | Oklahoma | 40015 | 5039 | 106 |
1789531 | 1789531 | 2021-10-06 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1789532 | 1789532 | 2021-10-06 | Carter | Oklahoma | 40019 | 8683 | 156 |
1789533 | 1789533 | 2021-10-06 | Cherokee | Oklahoma | 40021 | 8816 | 100 |
1789534 | 1789534 | 2021-10-06 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1789535 | 1789535 | 2021-10-06 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1789536 | 1789536 | 2021-10-06 | Cleveland | Oklahoma | 40027 | 41981 | 527 |
1789537 | 1789537 | 2021-10-06 | Coal | Oklahoma | 40029 | 1006 | 19 |
1789538 | 1789538 | 2021-10-06 | Comanche | Oklahoma | 40031 | 20556 | 258 |
1789539 | 1789539 | 2021-10-06 | Cotton | Oklahoma | 40033 | 935 | 20 |
1789540 | 1789540 | 2021-10-06 | Craig | Oklahoma | 40035 | 2916 | 29 |
1789541 | 1789541 | 2021-10-06 | Creek | Oklahoma | 40037 | 10677 | 227 |
1789542 | 1789542 | 2021-10-06 | Custer | Oklahoma | 40039 | 4820 | 112 |
1789543 | 1789543 | 2021-10-06 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1789544 | 1789544 | 2021-10-06 | Dewey | Oklahoma | 40043 | 652 | 16 |
1789545 | 1789545 | 2021-10-06 | Ellis | Oklahoma | 40045 | 419 | 6 |
1789546 | 1789546 | 2021-10-06 | Garfield | Oklahoma | 40047 | 9672 | 153 |
1789547 | 1789547 | 2021-10-06 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1789548 | 1789548 | 2021-10-06 | Grady | Oklahoma | 40051 | 7808 | 153 |
1789549 | 1789549 | 2021-10-06 | Grant | Oklahoma | 40053 | 686 | 7 |
1789550 | 1789550 | 2021-10-06 | Greer | Oklahoma | 40055 | 732 | 23 |
1789551 | 1789551 | 2021-10-06 | Harmon | Oklahoma | 40057 | 357 | 6 |
1789552 | 1789552 | 2021-10-06 | Harper | Oklahoma | 40059 | 475 | 8 |
1789553 | 1789553 | 2021-10-06 | Haskell | Oklahoma | 40061 | 1812 | 25 |
1789554 | 1789554 | 2021-10-06 | Hughes | Oklahoma | 40063 | 1625 | 37 |
1789555 | 1789555 | 2021-10-06 | Jackson | Oklahoma | 40065 | 3749 | 65 |
1789556 | 1789556 | 2021-10-06 | Jefferson | Oklahoma | 40067 | 908 | 18 |
1789557 | 1789557 | 2021-10-06 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1789558 | 1789558 | 2021-10-06 | Kay | Oklahoma | 40071 | 6939 | 148 |
1789559 | 1789559 | 2021-10-06 | Kingfisher | Oklahoma | 40073 | 2525 | 44 |
1789560 | 1789560 | 2021-10-06 | Kiowa | Oklahoma | 40075 | 1090 | 29 |
1789561 | 1789561 | 2021-10-06 | Latimer | Oklahoma | 40077 | 1438 | 14 |
1789562 | 1789562 | 2021-10-06 | Le Flore | Oklahoma | 40079 | 7801 | 76 |
1789563 | 1789563 | 2021-10-06 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1789564 | 1789564 | 2021-10-06 | Logan | Oklahoma | 40083 | 5898 | 97 |
1789565 | 1789565 | 2021-10-06 | Love | Oklahoma | 40085 | 1949 | 26 |
1789566 | 1789566 | 2021-10-06 | Major | Oklahoma | 40093 | 1192 | 27 |
1789567 | 1789567 | 2021-10-06 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1789568 | 1789568 | 2021-10-06 | Mayes | Oklahoma | 40097 | 6527 | 101 |
1789569 | 1789569 | 2021-10-06 | McClain | Oklahoma | 40087 | 7242 | 91 |
1789570 | 1789570 | 2021-10-06 | McCurtain | Oklahoma | 40089 | 5526 | 111 |
1789571 | 1789571 | 2021-10-06 | McIntosh | Oklahoma | 40091 | 2804 | 79 |
1789572 | 1789572 | 2021-10-06 | Murray | Oklahoma | 40099 | 2544 | 51 |
1789573 | 1789573 | 2021-10-06 | Muskogee | Oklahoma | 40101 | 12985 | 239 |
1789574 | 1789574 | 2021-10-06 | Noble | Oklahoma | 40103 | 1834 | 28 |
1789575 | 1789575 | 2021-10-06 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1789576 | 1789576 | 2021-10-06 | Okfuskee | Oklahoma | 40107 | 2242 | 34 |
1789577 | 1789577 | 2021-10-06 | Oklahoma | Oklahoma | 40109 | 115750 | 1544 |
1789578 | 1789578 | 2021-10-06 | Okmulgee | Oklahoma | 40111 | 5660 | 116 |
1789579 | 1789579 | 2021-10-06 | Osage | Oklahoma | 40113 | 6677 | 115 |
1789580 | 1789580 | 2021-10-06 | Ottawa | Oklahoma | 40115 | 5913 | 87 |
1789581 | 1789581 | 2021-10-06 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1789582 | 1789582 | 2021-10-06 | Payne | Oklahoma | 40119 | 11677 | 97 |
1789583 | 1789583 | 2021-10-06 | Pittsburg | Oklahoma | 40121 | 6505 | 104 |
1789584 | 1789584 | 2021-10-06 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1789585 | 1789585 | 2021-10-06 | Pottawatomie | Oklahoma | 40125 | 11203 | 170 |
1789586 | 1789586 | 2021-10-06 | Pushmataha | Oklahoma | 40127 | 1717 | 34 |
1789587 | 1789587 | 2021-10-06 | Roger Mills | Oklahoma | 40129 | 476 | 12 |
1789588 | 1789588 | 2021-10-06 | Rogers | Oklahoma | 40131 | 15287 | 255 |
1789589 | 1789589 | 2021-10-06 | Seminole | Oklahoma | 40133 | 3681 | 91 |
1789590 | 1789590 | 2021-10-06 | Sequoyah | Oklahoma | 40135 | 6563 | 76 |
1789591 | 1789591 | 2021-10-06 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1789592 | 1789592 | 2021-10-06 | Texas | Oklahoma | 40139 | 3933 | 37 |
1789593 | 1789593 | 2021-10-06 | Tillman | Oklahoma | 40141 | 956 | 20 |
1789594 | 1789594 | 2021-10-06 | Tulsa | Oklahoma | 40143 | 104222 | 1482 |
1789595 | 1789595 | 2021-10-06 | Unknown | Oklahoma | 2045 | 0 | |
1789596 | 1789596 | 2021-10-06 | Wagoner | Oklahoma | 40145 | 12263 | 187 |
1789597 | 1789597 | 2021-10-06 | Washington | Oklahoma | 40147 | 8219 | 179 |
1789598 | 1789598 | 2021-10-06 | Washita | Oklahoma | 40149 | 1432 | 25 |
1789599 | 1789599 | 2021-10-06 | Woods | Oklahoma | 40151 | 1577 | 22 |
1789600 | 1789600 | 2021-10-06 | Woodward | Oklahoma | 40153 | 3615 | 40 |
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);