ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-12-14" 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 |
---|---|---|---|---|---|---|---|
2013761 | 2013761 | 2021-12-14 | Adair | Oklahoma | 40001 | 5056 | 63 |
2013762 | 2013762 | 2021-12-14 | Alfalfa | Oklahoma | 40003 | 1400 | 9 |
2013763 | 2013763 | 2021-12-14 | Atoka | Oklahoma | 40005 | 2825 | 40 |
2013764 | 2013764 | 2021-12-14 | Beaver | Oklahoma | 40007 | 636 | 9 |
2013765 | 2013765 | 2021-12-14 | Beckham | Oklahoma | 40009 | 3966 | 81 |
2013766 | 2013766 | 2021-12-14 | Blaine | Oklahoma | 40011 | 1645 | 32 |
2013767 | 2013767 | 2021-12-14 | Bryan | Oklahoma | 40013 | 9275 | 114 |
2013768 | 2013768 | 2021-12-14 | Caddo | Oklahoma | 40015 | 5435 | 137 |
2013769 | 2013769 | 2021-12-14 | Canadian | Oklahoma | 40017 | 24485 | 305 |
2013770 | 2013770 | 2021-12-14 | Carter | Oklahoma | 40019 | 9416 | 195 |
2013771 | 2013771 | 2021-12-14 | Cherokee | Oklahoma | 40021 | 9265 | 126 |
2013772 | 2013772 | 2021-12-14 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
2013773 | 2013773 | 2021-12-14 | Cimarron | Oklahoma | 40025 | 373 | 0 |
2013774 | 2013774 | 2021-12-14 | Cleveland | Oklahoma | 40027 | 45821 | 632 |
2013775 | 2013775 | 2021-12-14 | Coal | Oklahoma | 40029 | 1089 | 20 |
2013776 | 2013776 | 2021-12-14 | Comanche | Oklahoma | 40031 | 21627 | 329 |
2013777 | 2013777 | 2021-12-14 | Cotton | Oklahoma | 40033 | 1013 | 23 |
2013778 | 2013778 | 2021-12-14 | Craig | Oklahoma | 40035 | 3191 | 36 |
2013779 | 2013779 | 2021-12-14 | Creek | Oklahoma | 40037 | 11799 | 269 |
2013780 | 2013780 | 2021-12-14 | Custer | Oklahoma | 40039 | 5494 | 133 |
2013781 | 2013781 | 2021-12-14 | Delaware | Oklahoma | 40041 | 7737 | 166 |
2013782 | 2013782 | 2021-12-14 | Dewey | Oklahoma | 40043 | 747 | 22 |
2013783 | 2013783 | 2021-12-14 | Ellis | Oklahoma | 40045 | 540 | 6 |
2013784 | 2013784 | 2021-12-14 | Garfield | Oklahoma | 40047 | 10692 | 218 |
2013785 | 2013785 | 2021-12-14 | Garvin | Oklahoma | 40049 | 4973 | 106 |
2013786 | 2013786 | 2021-12-14 | Grady | Oklahoma | 40051 | 8734 | 195 |
2013787 | 2013787 | 2021-12-14 | Grant | Oklahoma | 40053 | 721 | 8 |
2013788 | 2013788 | 2021-12-14 | Greer | Oklahoma | 40055 | 797 | 26 |
2013789 | 2013789 | 2021-12-14 | Harmon | Oklahoma | 40057 | 383 | 9 |
2013790 | 2013790 | 2021-12-14 | Harper | Oklahoma | 40059 | 549 | 10 |
2013791 | 2013791 | 2021-12-14 | Haskell | Oklahoma | 40061 | 1905 | 30 |
2013792 | 2013792 | 2021-12-14 | Hughes | Oklahoma | 40063 | 1801 | 48 |
2013793 | 2013793 | 2021-12-14 | Jackson | Oklahoma | 40065 | 4287 | 89 |
2013794 | 2013794 | 2021-12-14 | Jefferson | Oklahoma | 40067 | 974 | 20 |
2013795 | 2013795 | 2021-12-14 | Johnston | Oklahoma | 40069 | 2021 | 49 |
2013796 | 2013796 | 2021-12-14 | Kay | Oklahoma | 40071 | 8041 | 172 |
2013797 | 2013797 | 2021-12-14 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
2013798 | 2013798 | 2021-12-14 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
2013799 | 2013799 | 2021-12-14 | Latimer | Oklahoma | 40077 | 1605 | 28 |
2013800 | 2013800 | 2021-12-14 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
2013801 | 2013801 | 2021-12-14 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2013802 | 2013802 | 2021-12-14 | Logan | Oklahoma | 40083 | 6441 | 122 |
2013803 | 2013803 | 2021-12-14 | Love | Oklahoma | 40085 | 2045 | 30 |
2013804 | 2013804 | 2021-12-14 | Major | Oklahoma | 40093 | 1448 | 33 |
2013805 | 2013805 | 2021-12-14 | Marshall | Oklahoma | 40095 | 2886 | 31 |
2013806 | 2013806 | 2021-12-14 | Mayes | Oklahoma | 40097 | 7103 | 131 |
2013807 | 2013807 | 2021-12-14 | McClain | Oklahoma | 40087 | 7775 | 107 |
2013808 | 2013808 | 2021-12-14 | McCurtain | Oklahoma | 40089 | 5895 | 138 |
2013809 | 2013809 | 2021-12-14 | McIntosh | Oklahoma | 40091 | 2992 | 101 |
2013810 | 2013810 | 2021-12-14 | Murray | Oklahoma | 40099 | 2731 | 57 |
2013811 | 2013811 | 2021-12-14 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
2013812 | 2013812 | 2021-12-14 | Noble | Oklahoma | 40103 | 1978 | 33 |
2013813 | 2013813 | 2021-12-14 | Nowata | Oklahoma | 40105 | 1889 | 32 |
2013814 | 2013814 | 2021-12-14 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
2013815 | 2013815 | 2021-12-14 | Oklahoma | Oklahoma | 40109 | 124882 | 1953 |
2013816 | 2013816 | 2021-12-14 | Okmulgee | Oklahoma | 40111 | 6431 | 151 |
2013817 | 2013817 | 2021-12-14 | Osage | Oklahoma | 40113 | 7318 | 136 |
2013818 | 2013818 | 2021-12-14 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
2013819 | 2013819 | 2021-12-14 | Pawnee | Oklahoma | 40117 | 2794 | 69 |
2013820 | 2013820 | 2021-12-14 | Payne | Oklahoma | 40119 | 12414 | 125 |
2013821 | 2013821 | 2021-12-14 | Pittsburg | Oklahoma | 40121 | 7122 | 166 |
2013822 | 2013822 | 2021-12-14 | Pontotoc | Oklahoma | 40123 | 7188 | 106 |
2013823 | 2013823 | 2021-12-14 | Pottawatomie | Oklahoma | 40125 | 12919 | 212 |
2013824 | 2013824 | 2021-12-14 | Pushmataha | Oklahoma | 40127 | 1861 | 40 |
2013825 | 2013825 | 2021-12-14 | Roger Mills | Oklahoma | 40129 | 632 | 12 |
2013826 | 2013826 | 2021-12-14 | Rogers | Oklahoma | 40131 | 16842 | 305 |
2013827 | 2013827 | 2021-12-14 | Seminole | Oklahoma | 40133 | 4066 | 107 |
2013828 | 2013828 | 2021-12-14 | Sequoyah | Oklahoma | 40135 | 6968 | 93 |
2013829 | 2013829 | 2021-12-14 | Stephens | Oklahoma | 40137 | 8033 | 150 |
2013830 | 2013830 | 2021-12-14 | Texas | Oklahoma | 40139 | 4369 | 41 |
2013831 | 2013831 | 2021-12-14 | Tillman | Oklahoma | 40141 | 1056 | 26 |
2013832 | 2013832 | 2021-12-14 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
2013833 | 2013833 | 2021-12-14 | Unknown | Oklahoma | 9662 | 2 | |
2013834 | 2013834 | 2021-12-14 | Wagoner | Oklahoma | 40145 | 13507 | 215 |
2013835 | 2013835 | 2021-12-14 | Washington | Oklahoma | 40147 | 8786 | 209 |
2013836 | 2013836 | 2021-12-14 | Washita | Oklahoma | 40149 | 1694 | 33 |
2013837 | 2013837 | 2021-12-14 | Woods | Oklahoma | 40151 | 1723 | 29 |
2013838 | 2013838 | 2021-12-14 | Woodward | Oklahoma | 40153 | 4100 | 55 |
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);