ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-03-11" 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 |
---|---|---|---|---|---|---|---|
1110833 | 1110833 | 2021-03-11 | Adair | Oklahoma | 40001 | 3141 | 26 |
1110834 | 1110834 | 2021-03-11 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1110835 | 1110835 | 2021-03-11 | Atoka | Oklahoma | 40005 | 1785 | 13 |
1110836 | 1110836 | 2021-03-11 | Beaver | Oklahoma | 40007 | 450 | 6 |
1110837 | 1110837 | 2021-03-11 | Beckham | Oklahoma | 40009 | 2803 | 39 |
1110838 | 1110838 | 2021-03-11 | Blaine | Oklahoma | 40011 | 1007 | 8 |
1110839 | 1110839 | 2021-03-11 | Bryan | Oklahoma | 40013 | 5996 | 57 |
1110840 | 1110840 | 2021-03-11 | Caddo | Oklahoma | 40015 | 3867 | 61 |
1110841 | 1110841 | 2021-03-11 | Canadian | Oklahoma | 40017 | 16190 | 100 |
1110842 | 1110842 | 2021-03-11 | Carter | Oklahoma | 40019 | 5781 | 63 |
1110843 | 1110843 | 2021-03-11 | Cherokee | Oklahoma | 40021 | 5486 | 44 |
1110844 | 1110844 | 2021-03-11 | Choctaw | Oklahoma | 40023 | 1584 | 14 |
1110845 | 1110845 | 2021-03-11 | Cimarron | Oklahoma | 40025 | 202 | 1 |
1110846 | 1110846 | 2021-03-11 | Cleveland | Oklahoma | 40027 | 29117 | 282 |
1110847 | 1110847 | 2021-03-11 | Coal | Oklahoma | 40029 | 685 | 14 |
1110848 | 1110848 | 2021-03-11 | Comanche | Oklahoma | 40031 | 12355 | 145 |
1110849 | 1110849 | 2021-03-11 | Cotton | Oklahoma | 40033 | 659 | 14 |
1110850 | 1110850 | 2021-03-11 | Craig | Oklahoma | 40035 | 1905 | 11 |
1110851 | 1110851 | 2021-03-11 | Creek | Oklahoma | 40037 | 6671 | 121 |
1110852 | 1110852 | 2021-03-11 | Custer | Oklahoma | 40039 | 4037 | 72 |
1110853 | 1110853 | 2021-03-11 | Delaware | Oklahoma | 40041 | 4454 | 63 |
1110854 | 1110854 | 2021-03-11 | Dewey | Oklahoma | 40043 | 538 | 6 |
1110855 | 1110855 | 2021-03-11 | Ellis | Oklahoma | 40045 | 353 | 3 |
1110856 | 1110856 | 2021-03-11 | Garfield | Oklahoma | 40047 | 7652 | 82 |
1110857 | 1110857 | 2021-03-11 | Garvin | Oklahoma | 40049 | 3486 | 54 |
1110858 | 1110858 | 2021-03-11 | Grady | Oklahoma | 40051 | 5715 | 80 |
1110859 | 1110859 | 2021-03-11 | Grant | Oklahoma | 40053 | 542 | 7 |
1110860 | 1110860 | 2021-03-11 | Greer | Oklahoma | 40055 | 540 | 17 |
1110861 | 1110861 | 2021-03-11 | Harmon | Oklahoma | 40057 | 290 | 3 |
1110862 | 1110862 | 2021-03-11 | Harper | Oklahoma | 40059 | 410 | 4 |
1110863 | 1110863 | 2021-03-11 | Haskell | Oklahoma | 40061 | 1232 | 11 |
1110864 | 1110864 | 2021-03-11 | Hughes | Oklahoma | 40063 | 1176 | 18 |
1110865 | 1110865 | 2021-03-11 | Jackson | Oklahoma | 40065 | 2960 | 45 |
1110866 | 1110866 | 2021-03-11 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1110867 | 1110867 | 2021-03-11 | Johnston | Oklahoma | 40069 | 1336 | 20 |
1110868 | 1110868 | 2021-03-11 | Kay | Oklahoma | 40071 | 5116 | 83 |
1110869 | 1110869 | 2021-03-11 | Kingfisher | Oklahoma | 40073 | 2002 | 26 |
1110870 | 1110870 | 2021-03-11 | Kiowa | Oklahoma | 40075 | 802 | 16 |
1110871 | 1110871 | 2021-03-11 | Latimer | Oklahoma | 40077 | 826 | 9 |
1110872 | 1110872 | 2021-03-11 | Le Flore | Oklahoma | 40079 | 5447 | 46 |
1110873 | 1110873 | 2021-03-11 | Lincoln | Oklahoma | 40081 | 3114 | 57 |
1110874 | 1110874 | 2021-03-11 | Logan | Oklahoma | 40083 | 4041 | 31 |
1110875 | 1110875 | 2021-03-11 | Love | Oklahoma | 40085 | 1435 | 13 |
1110876 | 1110876 | 2021-03-11 | Major | Oklahoma | 40093 | 945 | 12 |
1110877 | 1110877 | 2021-03-11 | Marshall | Oklahoma | 40095 | 1882 | 12 |
1110878 | 1110878 | 2021-03-11 | Mayes | Oklahoma | 40097 | 4069 | 39 |
1110879 | 1110879 | 2021-03-11 | McClain | Oklahoma | 40087 | 5079 | 52 |
1110880 | 1110880 | 2021-03-11 | McCurtain | Oklahoma | 40089 | 3844 | 69 |
1110881 | 1110881 | 2021-03-11 | McIntosh | Oklahoma | 40091 | 1947 | 37 |
1110882 | 1110882 | 2021-03-11 | Murray | Oklahoma | 40099 | 1935 | 23 |
1110883 | 1110883 | 2021-03-11 | Muskogee | Oklahoma | 40101 | 9152 | 113 |
1110884 | 1110884 | 2021-03-11 | Noble | Oklahoma | 40103 | 1361 | 14 |
1110885 | 1110885 | 2021-03-11 | Nowata | Oklahoma | 40105 | 1116 | 16 |
1110886 | 1110886 | 2021-03-11 | Okfuskee | Oklahoma | 40107 | 1768 | 21 |
1110887 | 1110887 | 2021-03-11 | Oklahoma | Oklahoma | 40109 | 82321 | 791 |
1110888 | 1110888 | 2021-03-11 | Okmulgee | Oklahoma | 40111 | 3649 | 50 |
1110889 | 1110889 | 2021-03-11 | Osage | Oklahoma | 40113 | 4524 | 56 |
1110890 | 1110890 | 2021-03-11 | Ottawa | Oklahoma | 40115 | 3674 | 48 |
1110891 | 1110891 | 2021-03-11 | Pawnee | Oklahoma | 40117 | 1737 | 33 |
1110892 | 1110892 | 2021-03-11 | Payne | Oklahoma | 40119 | 8473 | 49 |
1110893 | 1110893 | 2021-03-11 | Pittsburg | Oklahoma | 40121 | 4504 | 42 |
1110894 | 1110894 | 2021-03-11 | Pontotoc | Oklahoma | 40123 | 4987 | 49 |
1110895 | 1110895 | 2021-03-11 | Pottawatomie | Oklahoma | 40125 | 8016 | 81 |
1110896 | 1110896 | 2021-03-11 | Pushmataha | Oklahoma | 40127 | 997 | 14 |
1110897 | 1110897 | 2021-03-11 | Roger Mills | Oklahoma | 40129 | 385 | 7 |
1110898 | 1110898 | 2021-03-11 | Rogers | Oklahoma | 40131 | 10012 | 124 |
1110899 | 1110899 | 2021-03-11 | Seminole | Oklahoma | 40133 | 2779 | 41 |
1110900 | 1110900 | 2021-03-11 | Sequoyah | Oklahoma | 40135 | 4004 | 32 |
1110901 | 1110901 | 2021-03-11 | Stephens | Oklahoma | 40137 | 4718 | 71 |
1110902 | 1110902 | 2021-03-11 | Texas | Oklahoma | 40139 | 3463 | 25 |
1110903 | 1110903 | 2021-03-11 | Tillman | Oklahoma | 40141 | 757 | 15 |
1110904 | 1110904 | 2021-03-11 | Tulsa | Oklahoma | 40143 | 71781 | 746 |
1110905 | 1110905 | 2021-03-11 | Unknown | Oklahoma | 8 | 0 | |
1110906 | 1110906 | 2021-03-11 | Wagoner | Oklahoma | 40145 | 7775 | 86 |
1110907 | 1110907 | 2021-03-11 | Washington | Oklahoma | 40147 | 4916 | 91 |
1110908 | 1110908 | 2021-03-11 | Washita | Oklahoma | 40149 | 1059 | 9 |
1110909 | 1110909 | 2021-03-11 | Woods | Oklahoma | 40151 | 1192 | 11 |
1110910 | 1110910 | 2021-03-11 | Woodward | Oklahoma | 40153 | 3104 | 20 |
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);