ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-03-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 |
---|---|---|---|---|---|---|---|
1097849 | 1097849 | 2021-03-07 | Adair | Oklahoma | 40001 | 3130 | 25 |
1097850 | 1097850 | 2021-03-07 | Alfalfa | Oklahoma | 40003 | 1149 | 5 |
1097851 | 1097851 | 2021-03-07 | Atoka | Oklahoma | 40005 | 1784 | 13 |
1097852 | 1097852 | 2021-03-07 | Beaver | Oklahoma | 40007 | 448 | 6 |
1097853 | 1097853 | 2021-03-07 | Beckham | Oklahoma | 40009 | 2799 | 37 |
1097854 | 1097854 | 2021-03-07 | Blaine | Oklahoma | 40011 | 1005 | 8 |
1097855 | 1097855 | 2021-03-07 | Bryan | Oklahoma | 40013 | 5983 | 56 |
1097856 | 1097856 | 2021-03-07 | Caddo | Oklahoma | 40015 | 3857 | 58 |
1097857 | 1097857 | 2021-03-07 | Canadian | Oklahoma | 40017 | 16089 | 97 |
1097858 | 1097858 | 2021-03-07 | Carter | Oklahoma | 40019 | 5762 | 60 |
1097859 | 1097859 | 2021-03-07 | Cherokee | Oklahoma | 40021 | 5462 | 44 |
1097860 | 1097860 | 2021-03-07 | Choctaw | Oklahoma | 40023 | 1579 | 14 |
1097861 | 1097861 | 2021-03-07 | Cimarron | Oklahoma | 40025 | 203 | 1 |
1097862 | 1097862 | 2021-03-07 | Cleveland | Oklahoma | 40027 | 28977 | 274 |
1097863 | 1097863 | 2021-03-07 | Coal | Oklahoma | 40029 | 684 | 14 |
1097864 | 1097864 | 2021-03-07 | Comanche | Oklahoma | 40031 | 12244 | 140 |
1097865 | 1097865 | 2021-03-07 | Cotton | Oklahoma | 40033 | 658 | 13 |
1097866 | 1097866 | 2021-03-07 | Craig | Oklahoma | 40035 | 1898 | 11 |
1097867 | 1097867 | 2021-03-07 | Creek | Oklahoma | 40037 | 6647 | 117 |
1097868 | 1097868 | 2021-03-07 | Custer | Oklahoma | 40039 | 4031 | 72 |
1097869 | 1097869 | 2021-03-07 | Delaware | Oklahoma | 40041 | 4429 | 62 |
1097870 | 1097870 | 2021-03-07 | Dewey | Oklahoma | 40043 | 537 | 6 |
1097871 | 1097871 | 2021-03-07 | Ellis | Oklahoma | 40045 | 352 | 3 |
1097872 | 1097872 | 2021-03-07 | Garfield | Oklahoma | 40047 | 7619 | 78 |
1097873 | 1097873 | 2021-03-07 | Garvin | Oklahoma | 40049 | 3477 | 52 |
1097874 | 1097874 | 2021-03-07 | Grady | Oklahoma | 40051 | 5689 | 76 |
1097875 | 1097875 | 2021-03-07 | Grant | Oklahoma | 40053 | 540 | 7 |
1097876 | 1097876 | 2021-03-07 | Greer | Oklahoma | 40055 | 539 | 17 |
1097877 | 1097877 | 2021-03-07 | Harmon | Oklahoma | 40057 | 290 | 3 |
1097878 | 1097878 | 2021-03-07 | Harper | Oklahoma | 40059 | 408 | 4 |
1097879 | 1097879 | 2021-03-07 | Haskell | Oklahoma | 40061 | 1229 | 11 |
1097880 | 1097880 | 2021-03-07 | Hughes | Oklahoma | 40063 | 1171 | 17 |
1097881 | 1097881 | 2021-03-07 | Jackson | Oklahoma | 40065 | 2957 | 44 |
1097882 | 1097882 | 2021-03-07 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1097883 | 1097883 | 2021-03-07 | Johnston | Oklahoma | 40069 | 1335 | 20 |
1097884 | 1097884 | 2021-03-07 | Kay | Oklahoma | 40071 | 5102 | 81 |
1097885 | 1097885 | 2021-03-07 | Kingfisher | Oklahoma | 40073 | 1997 | 24 |
1097886 | 1097886 | 2021-03-07 | Kiowa | Oklahoma | 40075 | 801 | 16 |
1097887 | 1097887 | 2021-03-07 | Latimer | Oklahoma | 40077 | 818 | 9 |
1097888 | 1097888 | 2021-03-07 | Le Flore | Oklahoma | 40079 | 5425 | 44 |
1097889 | 1097889 | 2021-03-07 | Lincoln | Oklahoma | 40081 | 3099 | 54 |
1097890 | 1097890 | 2021-03-07 | Logan | Oklahoma | 40083 | 4019 | 28 |
1097891 | 1097891 | 2021-03-07 | Love | Oklahoma | 40085 | 1433 | 12 |
1097892 | 1097892 | 2021-03-07 | Major | Oklahoma | 40093 | 941 | 12 |
1097893 | 1097893 | 2021-03-07 | Marshall | Oklahoma | 40095 | 1875 | 12 |
1097894 | 1097894 | 2021-03-07 | Mayes | Oklahoma | 40097 | 4042 | 38 |
1097895 | 1097895 | 2021-03-07 | McClain | Oklahoma | 40087 | 5064 | 50 |
1097896 | 1097896 | 2021-03-07 | McCurtain | Oklahoma | 40089 | 3836 | 64 |
1097897 | 1097897 | 2021-03-07 | McIntosh | Oklahoma | 40091 | 1942 | 35 |
1097898 | 1097898 | 2021-03-07 | Murray | Oklahoma | 40099 | 1926 | 22 |
1097899 | 1097899 | 2021-03-07 | Muskogee | Oklahoma | 40101 | 9138 | 106 |
1097900 | 1097900 | 2021-03-07 | Noble | Oklahoma | 40103 | 1357 | 13 |
1097901 | 1097901 | 2021-03-07 | Nowata | Oklahoma | 40105 | 1113 | 16 |
1097902 | 1097902 | 2021-03-07 | Okfuskee | Oklahoma | 40107 | 1766 | 20 |
1097903 | 1097903 | 2021-03-07 | Oklahoma | Oklahoma | 40109 | 81713 | 758 |
1097904 | 1097904 | 2021-03-07 | Okmulgee | Oklahoma | 40111 | 3640 | 50 |
1097905 | 1097905 | 2021-03-07 | Osage | Oklahoma | 40113 | 4512 | 52 |
1097906 | 1097906 | 2021-03-07 | Ottawa | Oklahoma | 40115 | 3646 | 46 |
1097907 | 1097907 | 2021-03-07 | Pawnee | Oklahoma | 40117 | 1731 | 33 |
1097908 | 1097908 | 2021-03-07 | Payne | Oklahoma | 40119 | 8442 | 47 |
1097909 | 1097909 | 2021-03-07 | Pittsburg | Oklahoma | 40121 | 4476 | 39 |
1097910 | 1097910 | 2021-03-07 | Pontotoc | Oklahoma | 40123 | 4973 | 48 |
1097911 | 1097911 | 2021-03-07 | Pottawatomie | Oklahoma | 40125 | 7983 | 79 |
1097912 | 1097912 | 2021-03-07 | Pushmataha | Oklahoma | 40127 | 995 | 14 |
1097913 | 1097913 | 2021-03-07 | Roger Mills | Oklahoma | 40129 | 384 | 7 |
1097914 | 1097914 | 2021-03-07 | Rogers | Oklahoma | 40131 | 9974 | 119 |
1097915 | 1097915 | 2021-03-07 | Seminole | Oklahoma | 40133 | 2774 | 39 |
1097916 | 1097916 | 2021-03-07 | Sequoyah | Oklahoma | 40135 | 3984 | 31 |
1097917 | 1097917 | 2021-03-07 | Stephens | Oklahoma | 40137 | 4704 | 68 |
1097918 | 1097918 | 2021-03-07 | Texas | Oklahoma | 40139 | 3459 | 24 |
1097919 | 1097919 | 2021-03-07 | Tillman | Oklahoma | 40141 | 756 | 14 |
1097920 | 1097920 | 2021-03-07 | Tulsa | Oklahoma | 40143 | 71541 | 723 |
1097921 | 1097921 | 2021-03-07 | Unknown | Oklahoma | 5 | 0 | |
1097922 | 1097922 | 2021-03-07 | Wagoner | Oklahoma | 40145 | 7752 | 83 |
1097923 | 1097923 | 2021-03-07 | Washington | Oklahoma | 40147 | 4881 | 89 |
1097924 | 1097924 | 2021-03-07 | Washita | Oklahoma | 40149 | 1057 | 9 |
1097925 | 1097925 | 2021-03-07 | Woods | Oklahoma | 40151 | 1189 | 11 |
1097926 | 1097926 | 2021-03-07 | Woodward | Oklahoma | 40153 | 3098 | 18 |
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);