ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59,923 rows where state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 148
- 40109 141
- 40065 140
- 40027 139
- 40071 139
- 40119 139
- 40017 138
- 40117 137
- 40039 135
- 40051 135
- 40083 135
- 40087 135
- 40147 135
- 40049 134
- 40101 132
- 40103 132
- 40123 131
- 40097 130
- 40145 130
- 40001 129
- 40013 129
- 40019 129
- 40037 129
- 40041 129
- 40113 129
- 40125 129
- 40137 129
- 40031 128
- 40035 128
- 40081 128
- …
county >30
- Tulsa 148
- Oklahoma 141
- Jackson 140
- Cleveland 139
- Kay 139
- Payne 139
- Canadian 138
- Pawnee 137
- Custer 135
- Grady 135
- Logan 135
- McClain 135
- Washington 135
- Garvin 134
- Muskogee 132
- Noble 132
- Pontotoc 131
- Mayes 130
- Wagoner 130
- Adair 129
- Bryan 129
- Carter 129
- Creek 129
- Delaware 129
- Osage 129
- Pottawatomie 129
- Stephens 129
- Comanche 128
- Craig 128
- Lincoln 128
- …
state 1
- Oklahoma · 9,160 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388065 | 388065 | 2020-07-31 | Adair | Oklahoma | 40001 | 283 | 5 |
388066 | 388066 | 2020-07-31 | Alfalfa | Oklahoma | 40003 | 4 | 0 |
388067 | 388067 | 2020-07-31 | Atoka | Oklahoma | 40005 | 60 | 0 |
388068 | 388068 | 2020-07-31 | Beaver | Oklahoma | 40007 | 36 | 0 |
388069 | 388069 | 2020-07-31 | Beckham | Oklahoma | 40009 | 42 | 0 |
388070 | 388070 | 2020-07-31 | Blaine | Oklahoma | 40011 | 45 | 0 |
388071 | 388071 | 2020-07-31 | Bryan | Oklahoma | 40013 | 374 | 1 |
388072 | 388072 | 2020-07-31 | Caddo | Oklahoma | 40015 | 348 | 14 |
388073 | 388073 | 2020-07-31 | Canadian | Oklahoma | 40017 | 1009 | 5 |
388074 | 388074 | 2020-07-31 | Carter | Oklahoma | 40019 | 289 | 3 |
388075 | 388075 | 2020-07-31 | Cherokee | Oklahoma | 40021 | 301 | 1 |
388076 | 388076 | 2020-07-31 | Choctaw | Oklahoma | 40023 | 160 | 1 |
388077 | 388077 | 2020-07-31 | Cimarron | Oklahoma | 40025 | 1 | 0 |
388078 | 388078 | 2020-07-31 | Cleveland | Oklahoma | 40027 | 2555 | 49 |
388079 | 388079 | 2020-07-31 | Coal | Oklahoma | 40029 | 28 | 0 |
388080 | 388080 | 2020-07-31 | Comanche | Oklahoma | 40031 | 756 | 10 |
388081 | 388081 | 2020-07-31 | Cotton | Oklahoma | 40033 | 17 | 2 |
388082 | 388082 | 2020-07-31 | Craig | Oklahoma | 40035 | 69 | 0 |
388083 | 388083 | 2020-07-31 | Creek | Oklahoma | 40037 | 473 | 13 |
388084 | 388084 | 2020-07-31 | Custer | Oklahoma | 40039 | 185 | 0 |
388085 | 388085 | 2020-07-31 | Delaware | Oklahoma | 40041 | 390 | 19 |
388086 | 388086 | 2020-07-31 | Dewey | Oklahoma | 40043 | 7 | 0 |
388087 | 388087 | 2020-07-31 | Ellis | Oklahoma | 40045 | 3 | 0 |
388088 | 388088 | 2020-07-31 | Garfield | Oklahoma | 40047 | 330 | 4 |
388089 | 388089 | 2020-07-31 | Garvin | Oklahoma | 40049 | 197 | 4 |
388090 | 388090 | 2020-07-31 | Grady | Oklahoma | 40051 | 397 | 6 |
388091 | 388091 | 2020-07-31 | Grant | Oklahoma | 40053 | 11 | 0 |
388092 | 388092 | 2020-07-31 | Greer | Oklahoma | 40055 | 80 | 7 |
388093 | 388093 | 2020-07-31 | Harmon | Oklahoma | 40057 | 22 | 0 |
388094 | 388094 | 2020-07-31 | Harper | Oklahoma | 40059 | 5 | 0 |
388095 | 388095 | 2020-07-31 | Haskell | Oklahoma | 40061 | 35 | 0 |
388096 | 388096 | 2020-07-31 | Hughes | Oklahoma | 40063 | 100 | 1 |
388097 | 388097 | 2020-07-31 | Jackson | Oklahoma | 40065 | 468 | 3 |
388098 | 388098 | 2020-07-31 | Jefferson | Oklahoma | 40067 | 29 | 0 |
388099 | 388099 | 2020-07-31 | Johnston | Oklahoma | 40069 | 39 | 0 |
388100 | 388100 | 2020-07-31 | Kay | Oklahoma | 40071 | 207 | 10 |
388101 | 388101 | 2020-07-31 | Kingfisher | Oklahoma | 40073 | 101 | 0 |
388102 | 388102 | 2020-07-31 | Kiowa | Oklahoma | 40075 | 24 | 1 |
388103 | 388103 | 2020-07-31 | Latimer | Oklahoma | 40077 | 64 | 1 |
388104 | 388104 | 2020-07-31 | Le Flore | Oklahoma | 40079 | 218 | 1 |
388105 | 388105 | 2020-07-31 | Lincoln | Oklahoma | 40081 | 118 | 2 |
388106 | 388106 | 2020-07-31 | Logan | Oklahoma | 40083 | 170 | 1 |
388107 | 388107 | 2020-07-31 | Love | Oklahoma | 40085 | 64 | 0 |
388108 | 388108 | 2020-07-31 | Major | Oklahoma | 40093 | 26 | 1 |
388109 | 388109 | 2020-07-31 | Marshall | Oklahoma | 40095 | 93 | 0 |
388110 | 388110 | 2020-07-31 | Mayes | Oklahoma | 40097 | 271 | 6 |
388111 | 388111 | 2020-07-31 | McClain | Oklahoma | 40087 | 383 | 4 |
388112 | 388112 | 2020-07-31 | McCurtain | Oklahoma | 40089 | 815 | 25 |
388113 | 388113 | 2020-07-31 | McIntosh | Oklahoma | 40091 | 143 | 1 |
388114 | 388114 | 2020-07-31 | Murray | Oklahoma | 40099 | 59 | 0 |
388115 | 388115 | 2020-07-31 | Muskogee | Oklahoma | 40101 | 416 | 16 |
388116 | 388116 | 2020-07-31 | Noble | Oklahoma | 40103 | 77 | 2 |
388117 | 388117 | 2020-07-31 | Nowata | Oklahoma | 40105 | 51 | 1 |
388118 | 388118 | 2020-07-31 | Okfuskee | Oklahoma | 40107 | 53 | 0 |
388119 | 388119 | 2020-07-31 | Oklahoma | Oklahoma | 40109 | 8910 | 97 |
388120 | 388120 | 2020-07-31 | Okmulgee | Oklahoma | 40111 | 370 | 2 |
388121 | 388121 | 2020-07-31 | Osage | Oklahoma | 40113 | 351 | 11 |
388122 | 388122 | 2020-07-31 | Ottawa | Oklahoma | 40115 | 327 | 2 |
388123 | 388123 | 2020-07-31 | Pawnee | Oklahoma | 40117 | 116 | 3 |
388124 | 388124 | 2020-07-31 | Payne | Oklahoma | 40119 | 651 | 3 |
388125 | 388125 | 2020-07-31 | Pittsburg | Oklahoma | 40121 | 171 | 3 |
388126 | 388126 | 2020-07-31 | Pontotoc | Oklahoma | 40123 | 164 | 2 |
388127 | 388127 | 2020-07-31 | Pottawatomie | Oklahoma | 40125 | 359 | 6 |
388128 | 388128 | 2020-07-31 | Pushmataha | Oklahoma | 40127 | 89 | 0 |
388129 | 388129 | 2020-07-31 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
388130 | 388130 | 2020-07-31 | Rogers | Oklahoma | 40131 | 756 | 14 |
388131 | 388131 | 2020-07-31 | Seminole | Oklahoma | 40133 | 187 | 5 |
388132 | 388132 | 2020-07-31 | Sequoyah | Oklahoma | 40135 | 220 | 4 |
388133 | 388133 | 2020-07-31 | Stephens | Oklahoma | 40137 | 168 | 2 |
388134 | 388134 | 2020-07-31 | Texas | Oklahoma | 40139 | 1031 | 7 |
388135 | 388135 | 2020-07-31 | Tillman | Oklahoma | 40141 | 53 | 1 |
388136 | 388136 | 2020-07-31 | Tulsa | Oklahoma | 40143 | 8710 | 98 |
388137 | 388137 | 2020-07-31 | Wagoner | Oklahoma | 40145 | 686 | 22 |
388138 | 388138 | 2020-07-31 | Washington | Oklahoma | 40147 | 557 | 39 |
388139 | 388139 | 2020-07-31 | Washita | Oklahoma | 40149 | 24 | 0 |
388140 | 388140 | 2020-07-31 | Woods | Oklahoma | 40151 | 15 | 0 |
388141 | 388141 | 2020-07-31 | Woodward | Oklahoma | 40153 | 32 | 0 |
384848 | 384848 | 2020-07-30 | Adair | Oklahoma | 40001 | 274 | 5 |
384849 | 384849 | 2020-07-30 | Alfalfa | Oklahoma | 40003 | 4 | 0 |
384850 | 384850 | 2020-07-30 | Atoka | Oklahoma | 40005 | 60 | 0 |
384851 | 384851 | 2020-07-30 | Beaver | Oklahoma | 40007 | 36 | 0 |
384852 | 384852 | 2020-07-30 | Beckham | Oklahoma | 40009 | 41 | 0 |
384853 | 384853 | 2020-07-30 | Blaine | Oklahoma | 40011 | 39 | 0 |
384854 | 384854 | 2020-07-30 | Bryan | Oklahoma | 40013 | 368 | 1 |
384855 | 384855 | 2020-07-30 | Caddo | Oklahoma | 40015 | 332 | 14 |
384856 | 384856 | 2020-07-30 | Canadian | Oklahoma | 40017 | 988 | 5 |
384857 | 384857 | 2020-07-30 | Carter | Oklahoma | 40019 | 285 | 3 |
384858 | 384858 | 2020-07-30 | Cherokee | Oklahoma | 40021 | 292 | 1 |
384859 | 384859 | 2020-07-30 | Choctaw | Oklahoma | 40023 | 161 | 1 |
384860 | 384860 | 2020-07-30 | Cimarron | Oklahoma | 40025 | 1 | 0 |
384861 | 384861 | 2020-07-30 | Cleveland | Oklahoma | 40027 | 2487 | 47 |
384862 | 384862 | 2020-07-30 | Coal | Oklahoma | 40029 | 27 | 0 |
384863 | 384863 | 2020-07-30 | Comanche | Oklahoma | 40031 | 751 | 10 |
384864 | 384864 | 2020-07-30 | Cotton | Oklahoma | 40033 | 17 | 2 |
384865 | 384865 | 2020-07-30 | Craig | Oklahoma | 40035 | 68 | 0 |
384866 | 384866 | 2020-07-30 | Creek | Oklahoma | 40037 | 468 | 12 |
384867 | 384867 | 2020-07-30 | Custer | Oklahoma | 40039 | 173 | 0 |
384868 | 384868 | 2020-07-30 | Delaware | Oklahoma | 40041 | 385 | 19 |
384869 | 384869 | 2020-07-30 | Dewey | Oklahoma | 40043 | 7 | 0 |
384870 | 384870 | 2020-07-30 | Ellis | Oklahoma | 40045 | 3 | 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);