ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2022-01-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 |
---|---|---|---|---|---|---|---|
2091773 | 2091773 | 2022-01-07 | Adair | Oklahoma | 40001 | 5218 | 63 |
2091774 | 2091774 | 2022-01-07 | Alfalfa | Oklahoma | 40003 | 1452 | 10 |
2091775 | 2091775 | 2022-01-07 | Atoka | Oklahoma | 40005 | 2913 | 40 |
2091776 | 2091776 | 2022-01-07 | Beaver | Oklahoma | 40007 | 715 | 10 |
2091777 | 2091777 | 2022-01-07 | Beckham | Oklahoma | 40009 | 4321 | 84 |
2091778 | 2091778 | 2022-01-07 | Blaine | Oklahoma | 40011 | 1722 | 32 |
2091779 | 2091779 | 2022-01-07 | Bryan | Oklahoma | 40013 | 9656 | 118 |
2091780 | 2091780 | 2022-01-07 | Caddo | Oklahoma | 40015 | 5692 | 138 |
2091781 | 2091781 | 2022-01-07 | Canadian | Oklahoma | 40017 | 26560 | 315 |
2091782 | 2091782 | 2022-01-07 | Carter | Oklahoma | 40019 | 9810 | 201 |
2091783 | 2091783 | 2022-01-07 | Cherokee | Oklahoma | 40021 | 9622 | 127 |
2091784 | 2091784 | 2022-01-07 | Choctaw | Oklahoma | 40023 | 2883 | 52 |
2091785 | 2091785 | 2022-01-07 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2091786 | 2091786 | 2022-01-07 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2091787 | 2091787 | 2022-01-07 | Coal | Oklahoma | 40029 | 1129 | 20 |
2091788 | 2091788 | 2022-01-07 | Comanche | Oklahoma | 40031 | 22680 | 335 |
2091789 | 2091789 | 2022-01-07 | Cotton | Oklahoma | 40033 | 1044 | 23 |
2091790 | 2091790 | 2022-01-07 | Craig | Oklahoma | 40035 | 3379 | 38 |
2091791 | 2091791 | 2022-01-07 | Creek | Oklahoma | 40037 | 12601 | 282 |
2091792 | 2091792 | 2022-01-07 | Custer | Oklahoma | 40039 | 5835 | 136 |
2091793 | 2091793 | 2022-01-07 | Delaware | Oklahoma | 40041 | 8003 | 172 |
2091794 | 2091794 | 2022-01-07 | Dewey | Oklahoma | 40043 | 827 | 24 |
2091795 | 2091795 | 2022-01-07 | Ellis | Oklahoma | 40045 | 573 | 6 |
2091796 | 2091796 | 2022-01-07 | Garfield | Oklahoma | 40047 | 11092 | 222 |
2091797 | 2091797 | 2022-01-07 | Garvin | Oklahoma | 40049 | 5252 | 111 |
2091798 | 2091798 | 2022-01-07 | Grady | Oklahoma | 40051 | 9413 | 203 |
2091799 | 2091799 | 2022-01-07 | Grant | Oklahoma | 40053 | 758 | 8 |
2091800 | 2091800 | 2022-01-07 | Greer | Oklahoma | 40055 | 842 | 27 |
2091801 | 2091801 | 2022-01-07 | Harmon | Oklahoma | 40057 | 401 | 9 |
2091802 | 2091802 | 2022-01-07 | Harper | Oklahoma | 40059 | 567 | 10 |
2091803 | 2091803 | 2022-01-07 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2091804 | 2091804 | 2022-01-07 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2091805 | 2091805 | 2022-01-07 | Jackson | Oklahoma | 40065 | 4487 | 89 |
2091806 | 2091806 | 2022-01-07 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2091807 | 2091807 | 2022-01-07 | Johnston | Oklahoma | 40069 | 2087 | 49 |
2091808 | 2091808 | 2022-01-07 | Kay | Oklahoma | 40071 | 8683 | 175 |
2091809 | 2091809 | 2022-01-07 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2091810 | 2091810 | 2022-01-07 | Kiowa | Oklahoma | 40075 | 1284 | 46 |
2091811 | 2091811 | 2022-01-07 | Latimer | Oklahoma | 40077 | 1645 | 29 |
2091812 | 2091812 | 2022-01-07 | Le Flore | Oklahoma | 40079 | 8883 | 94 |
2091813 | 2091813 | 2022-01-07 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2091814 | 2091814 | 2022-01-07 | Logan | Oklahoma | 40083 | 7348 | 131 |
2091815 | 2091815 | 2022-01-07 | Love | Oklahoma | 40085 | 2142 | 30 |
2091816 | 2091816 | 2022-01-07 | Major | Oklahoma | 40093 | 1580 | 34 |
2091817 | 2091817 | 2022-01-07 | Marshall | Oklahoma | 40095 | 3014 | 31 |
2091818 | 2091818 | 2022-01-07 | Mayes | Oklahoma | 40097 | 7299 | 133 |
2091819 | 2091819 | 2022-01-07 | McClain | Oklahoma | 40087 | 8230 | 106 |
2091820 | 2091820 | 2022-01-07 | McCurtain | Oklahoma | 40089 | 6040 | 140 |
2091821 | 2091821 | 2022-01-07 | McIntosh | Oklahoma | 40091 | 3250 | 106 |
2091822 | 2091822 | 2022-01-07 | Murray | Oklahoma | 40099 | 2883 | 57 |
2091823 | 2091823 | 2022-01-07 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2091824 | 2091824 | 2022-01-07 | Noble | Oklahoma | 40103 | 2063 | 34 |
2091825 | 2091825 | 2022-01-07 | Nowata | Oklahoma | 40105 | 2038 | 34 |
2091826 | 2091826 | 2022-01-07 | Okfuskee | Oklahoma | 40107 | 2525 | 49 |
2091827 | 2091827 | 2022-01-07 | Oklahoma | Oklahoma | 40109 | 133205 | 1981 |
2091828 | 2091828 | 2022-01-07 | Okmulgee | Oklahoma | 40111 | 6772 | 155 |
2091829 | 2091829 | 2022-01-07 | Osage | Oklahoma | 40113 | 7975 | 141 |
2091830 | 2091830 | 2022-01-07 | Ottawa | Oklahoma | 40115 | 6725 | 104 |
2091831 | 2091831 | 2022-01-07 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2091832 | 2091832 | 2022-01-07 | Payne | Oklahoma | 40119 | 12970 | 127 |
2091833 | 2091833 | 2022-01-07 | Pittsburg | Oklahoma | 40121 | 7422 | 170 |
2091834 | 2091834 | 2022-01-07 | Pontotoc | Oklahoma | 40123 | 7658 | 108 |
2091835 | 2091835 | 2022-01-07 | Pottawatomie | Oklahoma | 40125 | 13791 | 224 |
2091836 | 2091836 | 2022-01-07 | Pushmataha | Oklahoma | 40127 | 1891 | 42 |
2091837 | 2091837 | 2022-01-07 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2091838 | 2091838 | 2022-01-07 | Rogers | Oklahoma | 40131 | 18111 | 316 |
2091839 | 2091839 | 2022-01-07 | Seminole | Oklahoma | 40133 | 4261 | 106 |
2091840 | 2091840 | 2022-01-07 | Sequoyah | Oklahoma | 40135 | 7248 | 94 |
2091841 | 2091841 | 2022-01-07 | Stephens | Oklahoma | 40137 | 8318 | 156 |
2091842 | 2091842 | 2022-01-07 | Texas | Oklahoma | 40139 | 4624 | 44 |
2091843 | 2091843 | 2022-01-07 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2091844 | 2091844 | 2022-01-07 | Tulsa | Oklahoma | 40143 | 118781 | 1816 |
2091845 | 2091845 | 2022-01-07 | Unknown | Oklahoma | 20808 | 2 | |
2091846 | 2091846 | 2022-01-07 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2091847 | 2091847 | 2022-01-07 | Washington | Oklahoma | 40147 | 9221 | 213 |
2091848 | 2091848 | 2022-01-07 | Washita | Oklahoma | 40149 | 1852 | 34 |
2091849 | 2091849 | 2022-01-07 | Woods | Oklahoma | 40151 | 1830 | 30 |
2091850 | 2091850 | 2022-01-07 | Woodward | Oklahoma | 40153 | 4247 | 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);