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-09-12 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
526856 | 526856 | 2020-09-12 | Adair | Oklahoma | 40001 | 521 | 10 |
526857 | 526857 | 2020-09-12 | Alfalfa | Oklahoma | 40003 | 36 | 0 |
526858 | 526858 | 2020-09-12 | Atoka | Oklahoma | 40005 | 175 | 1 |
526859 | 526859 | 2020-09-12 | Beaver | Oklahoma | 40007 | 46 | 0 |
526860 | 526860 | 2020-09-12 | Beckham | Oklahoma | 40009 | 167 | 1 |
526861 | 526861 | 2020-09-12 | Blaine | Oklahoma | 40011 | 97 | 1 |
526862 | 526862 | 2020-09-12 | Bryan | Oklahoma | 40013 | 717 | 4 |
526863 | 526863 | 2020-09-12 | Caddo | Oklahoma | 40015 | 633 | 20 |
526864 | 526864 | 2020-09-12 | Canadian | Oklahoma | 40017 | 1716 | 13 |
526865 | 526865 | 2020-09-12 | Carter | Oklahoma | 40019 | 465 | 8 |
526866 | 526866 | 2020-09-12 | Cherokee | Oklahoma | 40021 | 864 | 7 |
526867 | 526867 | 2020-09-12 | Choctaw | Oklahoma | 40023 | 271 | 2 |
526868 | 526868 | 2020-09-12 | Cimarron | Oklahoma | 40025 | 18 | 0 |
526869 | 526869 | 2020-09-12 | Cleveland | Oklahoma | 40027 | 4919 | 67 |
526870 | 526870 | 2020-09-12 | Coal | Oklahoma | 40029 | 64 | 0 |
526871 | 526871 | 2020-09-12 | Comanche | Oklahoma | 40031 | 1380 | 12 |
526872 | 526872 | 2020-09-12 | Cotton | Oklahoma | 40033 | 63 | 2 |
526873 | 526873 | 2020-09-12 | Craig | Oklahoma | 40035 | 196 | 1 |
526874 | 526874 | 2020-09-12 | Creek | Oklahoma | 40037 | 964 | 27 |
526875 | 526875 | 2020-09-12 | Custer | Oklahoma | 40039 | 399 | 0 |
526876 | 526876 | 2020-09-12 | Delaware | Oklahoma | 40041 | 629 | 23 |
526877 | 526877 | 2020-09-12 | Dewey | Oklahoma | 40043 | 32 | 1 |
526878 | 526878 | 2020-09-12 | Ellis | Oklahoma | 40045 | 6 | 0 |
526879 | 526879 | 2020-09-12 | Garfield | Oklahoma | 40047 | 1276 | 17 |
526880 | 526880 | 2020-09-12 | Garvin | Oklahoma | 40049 | 308 | 4 |
526881 | 526881 | 2020-09-12 | Grady | Oklahoma | 40051 | 676 | 7 |
526882 | 526882 | 2020-09-12 | Grant | Oklahoma | 40053 | 31 | 0 |
526883 | 526883 | 2020-09-12 | Greer | Oklahoma | 40055 | 96 | 8 |
526884 | 526884 | 2020-09-12 | Harmon | Oklahoma | 40057 | 43 | 0 |
526885 | 526885 | 2020-09-12 | Harper | Oklahoma | 40059 | 24 | 0 |
526886 | 526886 | 2020-09-12 | Haskell | Oklahoma | 40061 | 207 | 4 |
526887 | 526887 | 2020-09-12 | Hughes | Oklahoma | 40063 | 257 | 4 |
526888 | 526888 | 2020-09-12 | Jackson | Oklahoma | 40065 | 646 | 9 |
526889 | 526889 | 2020-09-12 | Jefferson | Oklahoma | 40067 | 37 | 0 |
526890 | 526890 | 2020-09-12 | Johnston | Oklahoma | 40069 | 124 | 3 |
526891 | 526891 | 2020-09-12 | Kay | Oklahoma | 40071 | 408 | 13 |
526892 | 526892 | 2020-09-12 | Kingfisher | Oklahoma | 40073 | 298 | 2 |
526893 | 526893 | 2020-09-12 | Kiowa | Oklahoma | 40075 | 58 | 2 |
526894 | 526894 | 2020-09-12 | Latimer | Oklahoma | 40077 | 123 | 2 |
526895 | 526895 | 2020-09-12 | Le Flore | Oklahoma | 40079 | 848 | 16 |
526896 | 526896 | 2020-09-12 | Lincoln | Oklahoma | 40081 | 348 | 9 |
526897 | 526897 | 2020-09-12 | Logan | Oklahoma | 40083 | 355 | 1 |
526898 | 526898 | 2020-09-12 | Love | Oklahoma | 40085 | 142 | 1 |
526899 | 526899 | 2020-09-12 | Major | Oklahoma | 40093 | 65 | 1 |
526900 | 526900 | 2020-09-12 | Marshall | Oklahoma | 40095 | 147 | 1 |
526901 | 526901 | 2020-09-12 | Mayes | Oklahoma | 40097 | 487 | 10 |
526902 | 526902 | 2020-09-12 | McClain | Oklahoma | 40087 | 688 | 5 |
526903 | 526903 | 2020-09-12 | McCurtain | Oklahoma | 40089 | 1136 | 32 |
526904 | 526904 | 2020-09-12 | McIntosh | Oklahoma | 40091 | 271 | 4 |
526905 | 526905 | 2020-09-12 | Murray | Oklahoma | 40099 | 106 | 1 |
526906 | 526906 | 2020-09-12 | Muskogee | Oklahoma | 40101 | 1574 | 19 |
526907 | 526907 | 2020-09-12 | Noble | Oklahoma | 40103 | 129 | 2 |
526908 | 526908 | 2020-09-12 | Nowata | Oklahoma | 40105 | 120 | 2 |
526909 | 526909 | 2020-09-12 | Okfuskee | Oklahoma | 40107 | 118 | 4 |
526910 | 526910 | 2020-09-12 | Oklahoma | Oklahoma | 40109 | 15021 | 174 |
526911 | 526911 | 2020-09-12 | Okmulgee | Oklahoma | 40111 | 703 | 5 |
526912 | 526912 | 2020-09-12 | Osage | Oklahoma | 40113 | 729 | 13 |
526913 | 526913 | 2020-09-12 | Ottawa | Oklahoma | 40115 | 696 | 4 |
526914 | 526914 | 2020-09-12 | Pawnee | Oklahoma | 40117 | 229 | 3 |
526915 | 526915 | 2020-09-12 | Payne | Oklahoma | 40119 | 1738 | 5 |
526916 | 526916 | 2020-09-12 | Pittsburg | Oklahoma | 40121 | 698 | 19 |
526917 | 526917 | 2020-09-12 | Pontotoc | Oklahoma | 40123 | 290 | 3 |
526918 | 526918 | 2020-09-12 | Pottawatomie | Oklahoma | 40125 | 1035 | 9 |
526919 | 526919 | 2020-09-12 | Pushmataha | Oklahoma | 40127 | 134 | 1 |
526920 | 526920 | 2020-09-12 | Roger Mills | Oklahoma | 40129 | 16 | 1 |
526921 | 526921 | 2020-09-12 | Rogers | Oklahoma | 40131 | 1533 | 45 |
526922 | 526922 | 2020-09-12 | Seminole | Oklahoma | 40133 | 374 | 5 |
526923 | 526923 | 2020-09-12 | Sequoyah | Oklahoma | 40135 | 699 | 8 |
526924 | 526924 | 2020-09-12 | Stephens | Oklahoma | 40137 | 317 | 5 |
526925 | 526925 | 2020-09-12 | Texas | Oklahoma | 40139 | 1311 | 8 |
526926 | 526926 | 2020-09-12 | Tillman | Oklahoma | 40141 | 78 | 1 |
526927 | 526927 | 2020-09-12 | Tulsa | Oklahoma | 40143 | 15048 | 144 |
526928 | 526928 | 2020-09-12 | Unknown | Oklahoma | 45 | 0 | |
526929 | 526929 | 2020-09-12 | Wagoner | Oklahoma | 40145 | 1308 | 23 |
526930 | 526930 | 2020-09-12 | Washington | Oklahoma | 40147 | 907 | 40 |
526931 | 526931 | 2020-09-12 | Washita | Oklahoma | 40149 | 45 | 0 |
526932 | 526932 | 2020-09-12 | Woods | Oklahoma | 40151 | 32 | 0 |
526933 | 526933 | 2020-09-12 | Woodward | Oklahoma | 40153 | 149 | 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);