ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-08-23" 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 |
---|---|---|---|---|---|---|---|
1646582 | 1646582 | 2021-08-23 | Adair | Oklahoma | 40001 | 3931 | 47 |
1646583 | 1646583 | 2021-08-23 | Alfalfa | Oklahoma | 40003 | 1195 | 7 |
1646584 | 1646584 | 2021-08-23 | Atoka | Oklahoma | 40005 | 2142 | 28 |
1646585 | 1646585 | 2021-08-23 | Beaver | Oklahoma | 40007 | 482 | 6 |
1646586 | 1646586 | 2021-08-23 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1646587 | 1646587 | 2021-08-23 | Blaine | Oklahoma | 40011 | 1134 | 21 |
1646588 | 1646588 | 2021-08-23 | Bryan | Oklahoma | 40013 | 7087 | 80 |
1646589 | 1646589 | 2021-08-23 | Caddo | Oklahoma | 40015 | 4343 | 97 |
1646590 | 1646590 | 2021-08-23 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1646591 | 1646591 | 2021-08-23 | Carter | Oklahoma | 40019 | 7252 | 133 |
1646592 | 1646592 | 2021-08-23 | Cherokee | Oklahoma | 40021 | 6717 | 80 |
1646593 | 1646593 | 2021-08-23 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1646594 | 1646594 | 2021-08-23 | Cimarron | Oklahoma | 40025 | 263 | 2 |
1646595 | 1646595 | 2021-08-23 | Cleveland | Oklahoma | 40027 | 34799 | 457 |
1646596 | 1646596 | 2021-08-23 | Coal | Oklahoma | 40029 | 804 | 15 |
1646597 | 1646597 | 2021-08-23 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1646598 | 1646598 | 2021-08-23 | Cotton | Oklahoma | 40033 | 754 | 16 |
1646599 | 1646599 | 2021-08-23 | Craig | Oklahoma | 40035 | 2522 | 21 |
1646600 | 1646600 | 2021-08-23 | Creek | Oklahoma | 40037 | 8480 | 171 |
1646601 | 1646601 | 2021-08-23 | Custer | Oklahoma | 40039 | 4329 | 106 |
1646602 | 1646602 | 2021-08-23 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1646603 | 1646603 | 2021-08-23 | Dewey | Oklahoma | 40043 | 590 | 14 |
1646604 | 1646604 | 2021-08-23 | Ellis | Oklahoma | 40045 | 376 | 6 |
1646605 | 1646605 | 2021-08-23 | Garfield | Oklahoma | 40047 | 8288 | 140 |
1646606 | 1646606 | 2021-08-23 | Garvin | Oklahoma | 40049 | 3991 | 81 |
1646607 | 1646607 | 2021-08-23 | Grady | Oklahoma | 40051 | 6562 | 133 |
1646608 | 1646608 | 2021-08-23 | Grant | Oklahoma | 40053 | 594 | 7 |
1646609 | 1646609 | 2021-08-23 | Greer | Oklahoma | 40055 | 608 | 22 |
1646610 | 1646610 | 2021-08-23 | Harmon | Oklahoma | 40057 | 341 | 6 |
1646611 | 1646611 | 2021-08-23 | Harper | Oklahoma | 40059 | 430 | 8 |
1646612 | 1646612 | 2021-08-23 | Haskell | Oklahoma | 40061 | 1489 | 19 |
1646613 | 1646613 | 2021-08-23 | Hughes | Oklahoma | 40063 | 1379 | 30 |
1646614 | 1646614 | 2021-08-23 | Jackson | Oklahoma | 40065 | 3292 | 56 |
1646615 | 1646615 | 2021-08-23 | Jefferson | Oklahoma | 40067 | 763 | 18 |
1646616 | 1646616 | 2021-08-23 | Johnston | Oklahoma | 40069 | 1593 | 38 |
1646617 | 1646617 | 2021-08-23 | Kay | Oklahoma | 40071 | 5795 | 132 |
1646618 | 1646618 | 2021-08-23 | Kingfisher | Oklahoma | 40073 | 2225 | 42 |
1646619 | 1646619 | 2021-08-23 | Kiowa | Oklahoma | 40075 | 892 | 27 |
1646620 | 1646620 | 2021-08-23 | Latimer | Oklahoma | 40077 | 1011 | 13 |
1646621 | 1646621 | 2021-08-23 | Le Flore | Oklahoma | 40079 | 6441 | 71 |
1646622 | 1646622 | 2021-08-23 | Lincoln | Oklahoma | 40081 | 3756 | 76 |
1646623 | 1646623 | 2021-08-23 | Logan | Oklahoma | 40083 | 4756 | 67 |
1646624 | 1646624 | 2021-08-23 | Love | Oklahoma | 40085 | 1677 | 23 |
1646625 | 1646625 | 2021-08-23 | Major | Oklahoma | 40093 | 1019 | 24 |
1646626 | 1646626 | 2021-08-23 | Marshall | Oklahoma | 40095 | 2289 | 24 |
1646627 | 1646627 | 2021-08-23 | Mayes | Oklahoma | 40097 | 5205 | 77 |
1646628 | 1646628 | 2021-08-23 | McClain | Oklahoma | 40087 | 6093 | 75 |
1646629 | 1646629 | 2021-08-23 | McCurtain | Oklahoma | 40089 | 4418 | 95 |
1646630 | 1646630 | 2021-08-23 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1646631 | 1646631 | 2021-08-23 | Murray | Oklahoma | 40099 | 2243 | 45 |
1646632 | 1646632 | 2021-08-23 | Muskogee | Oklahoma | 40101 | 10804 | 189 |
1646633 | 1646633 | 2021-08-23 | Noble | Oklahoma | 40103 | 1536 | 22 |
1646634 | 1646634 | 2021-08-23 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1646635 | 1646635 | 2021-08-23 | Okfuskee | Oklahoma | 40107 | 1971 | 32 |
1646636 | 1646636 | 2021-08-23 | Oklahoma | Oklahoma | 40109 | 96822 | 1346 |
1646637 | 1646637 | 2021-08-23 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1646638 | 1646638 | 2021-08-23 | Osage | Oklahoma | 40113 | 5556 | 86 |
1646639 | 1646639 | 2021-08-23 | Ottawa | Oklahoma | 40115 | 5172 | 81 |
1646640 | 1646640 | 2021-08-23 | Pawnee | Oklahoma | 40117 | 2137 | 54 |
1646641 | 1646641 | 2021-08-23 | Payne | Oklahoma | 40119 | 9597 | 77 |
1646642 | 1646642 | 2021-08-23 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1646643 | 1646643 | 2021-08-23 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1646644 | 1646644 | 2021-08-23 | Pottawatomie | Oklahoma | 40125 | 9301 | 134 |
1646645 | 1646645 | 2021-08-23 | Pushmataha | Oklahoma | 40127 | 1314 | 24 |
1646646 | 1646646 | 2021-08-23 | Roger Mills | Oklahoma | 40129 | 419 | 12 |
1646647 | 1646647 | 2021-08-23 | Rogers | Oklahoma | 40131 | 12735 | 203 |
1646648 | 1646648 | 2021-08-23 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1646649 | 1646649 | 2021-08-23 | Sequoyah | Oklahoma | 40135 | 5140 | 58 |
1646650 | 1646650 | 2021-08-23 | Stephens | Oklahoma | 40137 | 5562 | 107 |
1646651 | 1646651 | 2021-08-23 | Texas | Oklahoma | 40139 | 3625 | 35 |
1646652 | 1646652 | 2021-08-23 | Tillman | Oklahoma | 40141 | 861 | 18 |
1646653 | 1646653 | 2021-08-23 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1646654 | 1646654 | 2021-08-23 | Unknown | Oklahoma | 14913 | 0 | |
1646655 | 1646655 | 2021-08-23 | Wagoner | Oklahoma | 40145 | 9733 | 131 |
1646656 | 1646656 | 2021-08-23 | Washington | Oklahoma | 40147 | 6540 | 130 |
1646657 | 1646657 | 2021-08-23 | Washita | Oklahoma | 40149 | 1180 | 23 |
1646658 | 1646658 | 2021-08-23 | Woods | Oklahoma | 40151 | 1348 | 18 |
1646659 | 1646659 | 2021-08-23 | Woodward | Oklahoma | 40153 | 3262 | 38 |
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);