ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where date = "2021-03-23" 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 |
---|---|---|---|---|---|---|---|
1149793 | 1149793 | 2021-03-23 | Adair | Oklahoma | 40001 | 3145 | 26 |
1149794 | 1149794 | 2021-03-23 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1149795 | 1149795 | 2021-03-23 | Atoka | Oklahoma | 40005 | 1831 | 15 |
1149796 | 1149796 | 2021-03-23 | Beaver | Oklahoma | 40007 | 453 | 6 |
1149797 | 1149797 | 2021-03-23 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1149798 | 1149798 | 2021-03-23 | Blaine | Oklahoma | 40011 | 1012 | 8 |
1149799 | 1149799 | 2021-03-23 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1149800 | 1149800 | 2021-03-23 | Caddo | Oklahoma | 40015 | 3884 | 61 |
1149801 | 1149801 | 2021-03-23 | Canadian | Oklahoma | 40017 | 16254 | 102 |
1149802 | 1149802 | 2021-03-23 | Carter | Oklahoma | 40019 | 5825 | 65 |
1149803 | 1149803 | 2021-03-23 | Cherokee | Oklahoma | 40021 | 5500 | 44 |
1149804 | 1149804 | 2021-03-23 | Choctaw | Oklahoma | 40023 | 1592 | 14 |
1149805 | 1149805 | 2021-03-23 | Cimarron | Oklahoma | 40025 | 203 | 1 |
1149806 | 1149806 | 2021-03-23 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1149807 | 1149807 | 2021-03-23 | Coal | Oklahoma | 40029 | 686 | 14 |
1149808 | 1149808 | 2021-03-23 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1149809 | 1149809 | 2021-03-23 | Cotton | Oklahoma | 40033 | 659 | 14 |
1149810 | 1149810 | 2021-03-23 | Craig | Oklahoma | 40035 | 1916 | 11 |
1149811 | 1149811 | 2021-03-23 | Creek | Oklahoma | 40037 | 6685 | 121 |
1149812 | 1149812 | 2021-03-23 | Custer | Oklahoma | 40039 | 4044 | 72 |
1149813 | 1149813 | 2021-03-23 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1149814 | 1149814 | 2021-03-23 | Dewey | Oklahoma | 40043 | 538 | 6 |
1149815 | 1149815 | 2021-03-23 | Ellis | Oklahoma | 40045 | 353 | 3 |
1149816 | 1149816 | 2021-03-23 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1149817 | 1149817 | 2021-03-23 | Garvin | Oklahoma | 40049 | 3505 | 55 |
1149818 | 1149818 | 2021-03-23 | Grady | Oklahoma | 40051 | 5739 | 81 |
1149819 | 1149819 | 2021-03-23 | Grant | Oklahoma | 40053 | 543 | 7 |
1149820 | 1149820 | 2021-03-23 | Greer | Oklahoma | 40055 | 567 | 17 |
1149821 | 1149821 | 2021-03-23 | Harmon | Oklahoma | 40057 | 294 | 3 |
1149822 | 1149822 | 2021-03-23 | Harper | Oklahoma | 40059 | 409 | 4 |
1149823 | 1149823 | 2021-03-23 | Haskell | Oklahoma | 40061 | 1235 | 11 |
1149824 | 1149824 | 2021-03-23 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1149825 | 1149825 | 2021-03-23 | Jackson | Oklahoma | 40065 | 2973 | 46 |
1149826 | 1149826 | 2021-03-23 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1149827 | 1149827 | 2021-03-23 | Johnston | Oklahoma | 40069 | 1343 | 20 |
1149828 | 1149828 | 2021-03-23 | Kay | Oklahoma | 40071 | 5134 | 84 |
1149829 | 1149829 | 2021-03-23 | Kingfisher | Oklahoma | 40073 | 2004 | 26 |
1149830 | 1149830 | 2021-03-23 | Kiowa | Oklahoma | 40075 | 804 | 16 |
1149831 | 1149831 | 2021-03-23 | Latimer | Oklahoma | 40077 | 827 | 9 |
1149832 | 1149832 | 2021-03-23 | Le Flore | Oklahoma | 40079 | 5462 | 46 |
1149833 | 1149833 | 2021-03-23 | Lincoln | Oklahoma | 40081 | 3128 | 58 |
1149834 | 1149834 | 2021-03-23 | Logan | Oklahoma | 40083 | 4076 | 34 |
1149835 | 1149835 | 2021-03-23 | Love | Oklahoma | 40085 | 1441 | 13 |
1149836 | 1149836 | 2021-03-23 | Major | Oklahoma | 40093 | 948 | 12 |
1149837 | 1149837 | 2021-03-23 | Marshall | Oklahoma | 40095 | 1898 | 12 |
1149838 | 1149838 | 2021-03-23 | Mayes | Oklahoma | 40097 | 4084 | 40 |
1149839 | 1149839 | 2021-03-23 | McClain | Oklahoma | 40087 | 5102 | 54 |
1149840 | 1149840 | 2021-03-23 | McCurtain | Oklahoma | 40089 | 3860 | 70 |
1149841 | 1149841 | 2021-03-23 | McIntosh | Oklahoma | 40091 | 1951 | 38 |
1149842 | 1149842 | 2021-03-23 | Murray | Oklahoma | 40099 | 1942 | 23 |
1149843 | 1149843 | 2021-03-23 | Muskogee | Oklahoma | 40101 | 9181 | 113 |
1149844 | 1149844 | 2021-03-23 | Noble | Oklahoma | 40103 | 1362 | 14 |
1149845 | 1149845 | 2021-03-23 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1149846 | 1149846 | 2021-03-23 | Okfuskee | Oklahoma | 40107 | 1773 | 21 |
1149847 | 1149847 | 2021-03-23 | Oklahoma | Oklahoma | 40109 | 82710 | 810 |
1149848 | 1149848 | 2021-03-23 | Okmulgee | Oklahoma | 40111 | 3657 | 51 |
1149849 | 1149849 | 2021-03-23 | Osage | Oklahoma | 40113 | 4538 | 56 |
1149850 | 1149850 | 2021-03-23 | Ottawa | Oklahoma | 40115 | 3701 | 50 |
1149851 | 1149851 | 2021-03-23 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1149852 | 1149852 | 2021-03-23 | Payne | Oklahoma | 40119 | 8494 | 50 |
1149853 | 1149853 | 2021-03-23 | Pittsburg | Oklahoma | 40121 | 4538 | 45 |
1149854 | 1149854 | 2021-03-23 | Pontotoc | Oklahoma | 40123 | 4999 | 49 |
1149855 | 1149855 | 2021-03-23 | Pottawatomie | Oklahoma | 40125 | 8044 | 83 |
1149856 | 1149856 | 2021-03-23 | Pushmataha | Oklahoma | 40127 | 999 | 14 |
1149857 | 1149857 | 2021-03-23 | Roger Mills | Oklahoma | 40129 | 385 | 8 |
1149858 | 1149858 | 2021-03-23 | Rogers | Oklahoma | 40131 | 10072 | 126 |
1149859 | 1149859 | 2021-03-23 | Seminole | Oklahoma | 40133 | 2786 | 43 |
1149860 | 1149860 | 2021-03-23 | Sequoyah | Oklahoma | 40135 | 4017 | 34 |
1149861 | 1149861 | 2021-03-23 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1149862 | 1149862 | 2021-03-23 | Texas | Oklahoma | 40139 | 3473 | 25 |
1149863 | 1149863 | 2021-03-23 | Tillman | Oklahoma | 40141 | 762 | 16 |
1149864 | 1149864 | 2021-03-23 | Tulsa | Oklahoma | 40143 | 72005 | 761 |
1149865 | 1149865 | 2021-03-23 | Unknown | Oklahoma | 2853 | 0 | |
1149866 | 1149866 | 2021-03-23 | Wagoner | Oklahoma | 40145 | 7788 | 89 |
1149867 | 1149867 | 2021-03-23 | Washington | Oklahoma | 40147 | 4943 | 92 |
1149868 | 1149868 | 2021-03-23 | Washita | Oklahoma | 40149 | 1061 | 9 |
1149869 | 1149869 | 2021-03-23 | Woods | Oklahoma | 40151 | 1192 | 11 |
1149870 | 1149870 | 2021-03-23 | Woodward | Oklahoma | 40153 | 3114 | 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);