ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2020-08-17 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
442823 | 442823 | 2020-08-17 | Adair | Oklahoma | 40001 | 383 | 6 |
442824 | 442824 | 2020-08-17 | Alfalfa | Oklahoma | 40003 | 6 | 0 |
442825 | 442825 | 2020-08-17 | Atoka | Oklahoma | 40005 | 88 | 1 |
442826 | 442826 | 2020-08-17 | Beaver | Oklahoma | 40007 | 40 | 0 |
442827 | 442827 | 2020-08-17 | Beckham | Oklahoma | 40009 | 101 | 1 |
442828 | 442828 | 2020-08-17 | Blaine | Oklahoma | 40011 | 46 | 0 |
442829 | 442829 | 2020-08-17 | Bryan | Oklahoma | 40013 | 512 | 2 |
442830 | 442830 | 2020-08-17 | Caddo | Oklahoma | 40015 | 470 | 19 |
442831 | 442831 | 2020-08-17 | Canadian | Oklahoma | 40017 | 1339 | 9 |
442832 | 442832 | 2020-08-17 | Carter | Oklahoma | 40019 | 370 | 5 |
442833 | 442833 | 2020-08-17 | Cherokee | Oklahoma | 40021 | 535 | 2 |
442834 | 442834 | 2020-08-17 | Choctaw | Oklahoma | 40023 | 209 | 1 |
442835 | 442835 | 2020-08-17 | Cimarron | Oklahoma | 40025 | 11 | 0 |
442836 | 442836 | 2020-08-17 | Cleveland | Oklahoma | 40027 | 3215 | 58 |
442837 | 442837 | 2020-08-17 | Coal | Oklahoma | 40029 | 46 | 0 |
442838 | 442838 | 2020-08-17 | Comanche | Oklahoma | 40031 | 884 | 11 |
442839 | 442839 | 2020-08-17 | Cotton | Oklahoma | 40033 | 21 | 2 |
442840 | 442840 | 2020-08-17 | Craig | Oklahoma | 40035 | 94 | 1 |
442841 | 442841 | 2020-08-17 | Creek | Oklahoma | 40037 | 681 | 15 |
442842 | 442842 | 2020-08-17 | Custer | Oklahoma | 40039 | 241 | 0 |
442843 | 442843 | 2020-08-17 | Delaware | Oklahoma | 40041 | 473 | 20 |
442844 | 442844 | 2020-08-17 | Dewey | Oklahoma | 40043 | 13 | 0 |
442845 | 442845 | 2020-08-17 | Ellis | Oklahoma | 40045 | 5 | 0 |
442846 | 442846 | 2020-08-17 | Garfield | Oklahoma | 40047 | 617 | 8 |
442847 | 442847 | 2020-08-17 | Garvin | Oklahoma | 40049 | 242 | 4 |
442848 | 442848 | 2020-08-17 | Grady | Oklahoma | 40051 | 472 | 7 |
442849 | 442849 | 2020-08-17 | Grant | Oklahoma | 40053 | 17 | 0 |
442850 | 442850 | 2020-08-17 | Greer | Oklahoma | 40055 | 85 | 8 |
442851 | 442851 | 2020-08-17 | Harmon | Oklahoma | 40057 | 32 | 0 |
442852 | 442852 | 2020-08-17 | Harper | Oklahoma | 40059 | 13 | 0 |
442853 | 442853 | 2020-08-17 | Haskell | Oklahoma | 40061 | 88 | 1 |
442854 | 442854 | 2020-08-17 | Hughes | Oklahoma | 40063 | 179 | 2 |
442855 | 442855 | 2020-08-17 | Jackson | Oklahoma | 40065 | 538 | 7 |
442856 | 442856 | 2020-08-17 | Jefferson | Oklahoma | 40067 | 34 | 0 |
442857 | 442857 | 2020-08-17 | Johnston | Oklahoma | 40069 | 55 | 0 |
442858 | 442858 | 2020-08-17 | Kay | Oklahoma | 40071 | 267 | 11 |
442859 | 442859 | 2020-08-17 | Kingfisher | Oklahoma | 40073 | 160 | 0 |
442860 | 442860 | 2020-08-17 | Kiowa | Oklahoma | 40075 | 33 | 1 |
442861 | 442861 | 2020-08-17 | Latimer | Oklahoma | 40077 | 100 | 2 |
442862 | 442862 | 2020-08-17 | Le Flore | Oklahoma | 40079 | 436 | 1 |
442863 | 442863 | 2020-08-17 | Lincoln | Oklahoma | 40081 | 248 | 3 |
442864 | 442864 | 2020-08-17 | Logan | Oklahoma | 40083 | 244 | 1 |
442865 | 442865 | 2020-08-17 | Love | Oklahoma | 40085 | 83 | 0 |
442866 | 442866 | 2020-08-17 | Major | Oklahoma | 40093 | 40 | 1 |
442867 | 442867 | 2020-08-17 | Marshall | Oklahoma | 40095 | 121 | 1 |
442868 | 442868 | 2020-08-17 | Mayes | Oklahoma | 40097 | 368 | 8 |
442869 | 442869 | 2020-08-17 | McClain | Oklahoma | 40087 | 483 | 4 |
442870 | 442870 | 2020-08-17 | McCurtain | Oklahoma | 40089 | 896 | 28 |
442871 | 442871 | 2020-08-17 | McIntosh | Oklahoma | 40091 | 207 | 2 |
442872 | 442872 | 2020-08-17 | Murray | Oklahoma | 40099 | 82 | 0 |
442873 | 442873 | 2020-08-17 | Muskogee | Oklahoma | 40101 | 588 | 16 |
442874 | 442874 | 2020-08-17 | Noble | Oklahoma | 40103 | 92 | 2 |
442875 | 442875 | 2020-08-17 | Nowata | Oklahoma | 40105 | 63 | 1 |
442876 | 442876 | 2020-08-17 | Okfuskee | Oklahoma | 40107 | 83 | 1 |
442877 | 442877 | 2020-08-17 | Oklahoma | Oklahoma | 40109 | 11715 | 132 |
442878 | 442878 | 2020-08-17 | Okmulgee | Oklahoma | 40111 | 508 | 3 |
442879 | 442879 | 2020-08-17 | Osage | Oklahoma | 40113 | 564 | 12 |
442880 | 442880 | 2020-08-17 | Ottawa | Oklahoma | 40115 | 418 | 3 |
442881 | 442881 | 2020-08-17 | Pawnee | Oklahoma | 40117 | 168 | 3 |
442882 | 442882 | 2020-08-17 | Payne | Oklahoma | 40119 | 800 | 4 |
442883 | 442883 | 2020-08-17 | Pittsburg | Oklahoma | 40121 | 437 | 4 |
442884 | 442884 | 2020-08-17 | Pontotoc | Oklahoma | 40123 | 215 | 2 |
442885 | 442885 | 2020-08-17 | Pottawatomie | Oklahoma | 40125 | 595 | 9 |
442886 | 442886 | 2020-08-17 | Pushmataha | Oklahoma | 40127 | 116 | 0 |
442887 | 442887 | 2020-08-17 | Roger Mills | Oklahoma | 40129 | 9 | 1 |
442888 | 442888 | 2020-08-17 | Rogers | Oklahoma | 40131 | 1139 | 21 |
442889 | 442889 | 2020-08-17 | Seminole | Oklahoma | 40133 | 257 | 5 |
442890 | 442890 | 2020-08-17 | Sequoyah | Oklahoma | 40135 | 439 | 4 |
442891 | 442891 | 2020-08-17 | Stephens | Oklahoma | 40137 | 218 | 3 |
442892 | 442892 | 2020-08-17 | Texas | Oklahoma | 40139 | 1079 | 7 |
442893 | 442893 | 2020-08-17 | Tillman | Oklahoma | 40141 | 59 | 1 |
442894 | 442894 | 2020-08-17 | Tulsa | Oklahoma | 40143 | 11443 | 116 |
442895 | 442895 | 2020-08-17 | Unknown | Oklahoma | 2 | 0 | |
442896 | 442896 | 2020-08-17 | Wagoner | Oklahoma | 40145 | 968 | 23 |
442897 | 442897 | 2020-08-17 | Washington | Oklahoma | 40147 | 705 | 39 |
442898 | 442898 | 2020-08-17 | Washita | Oklahoma | 40149 | 35 | 0 |
442899 | 442899 | 2020-08-17 | Woods | Oklahoma | 40151 | 21 | 0 |
442900 | 442900 | 2020-08-17 | Woodward | Oklahoma | 40153 | 52 | 0 |
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);