ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 24 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
679233 | 679233 | 2020-10-29 | Ellis | Oklahoma | 40045 | 24 | 0 |
675990 | 675990 | 2020-10-28 | Ellis | Oklahoma | 40045 | 24 | 0 |
598189 | 598189 | 2020-10-04 | Unknown | Oklahoma | 24 | 0 | |
572199 | 572199 | 2020-09-26 | Cimarron | Oklahoma | 40025 | 24 | 0 |
568957 | 568957 | 2020-09-25 | Cimarron | Oklahoma | 40025 | 24 | 0 |
565716 | 565716 | 2020-09-24 | Cimarron | Oklahoma | 40025 | 24 | 0 |
562475 | 562475 | 2020-09-23 | Cimarron | Oklahoma | 40025 | 24 | 0 |
530122 | 530122 | 2020-09-13 | Harper | Oklahoma | 40059 | 24 | 0 |
526885 | 526885 | 2020-09-12 | Harper | Oklahoma | 40059 | 24 | 0 |
523649 | 523649 | 2020-09-11 | Harper | Oklahoma | 40059 | 24 | 0 |
520413 | 520413 | 2020-09-10 | Harper | Oklahoma | 40059 | 24 | 0 |
513934 | 513934 | 2020-09-08 | Dewey | Oklahoma | 40043 | 24 | 1 |
510701 | 510701 | 2020-09-07 | Dewey | Oklahoma | 40043 | 24 | 1 |
507468 | 507468 | 2020-09-06 | Dewey | Oklahoma | 40043 | 24 | 1 |
504236 | 504236 | 2020-09-05 | Dewey | Oklahoma | 40043 | 24 | 1 |
501002 | 501002 | 2020-09-04 | Dewey | Oklahoma | 40043 | 24 | 1 |
497768 | 497768 | 2020-09-03 | Dewey | Oklahoma | 40043 | 24 | 1 |
484840 | 484840 | 2020-08-30 | Grant | Oklahoma | 40053 | 24 | 0 |
484890 | 484890 | 2020-08-30 | Woods | Oklahoma | 40151 | 24 | 0 |
481605 | 481605 | 2020-08-29 | Grant | Oklahoma | 40053 | 24 | 0 |
481655 | 481655 | 2020-08-29 | Woods | Oklahoma | 40151 | 24 | 0 |
478421 | 478421 | 2020-08-28 | Woods | Oklahoma | 40151 | 24 | 0 |
475138 | 475138 | 2020-08-27 | Grant | Oklahoma | 40053 | 24 | 0 |
475188 | 475188 | 2020-08-27 | Woods | Oklahoma | 40151 | 24 | 0 |
471954 | 471954 | 2020-08-26 | Woods | Oklahoma | 40151 | 24 | 0 |
468722 | 468722 | 2020-08-25 | Woods | Oklahoma | 40151 | 24 | 0 |
462265 | 462265 | 2020-08-23 | Woods | Oklahoma | 40151 | 24 | 0 |
459037 | 459037 | 2020-08-22 | Woods | Oklahoma | 40151 | 24 | 0 |
455809 | 455809 | 2020-08-21 | Woods | Oklahoma | 40151 | 24 | 0 |
452581 | 452581 | 2020-08-20 | Woods | Oklahoma | 40151 | 24 | 0 |
397789 | 397789 | 2020-08-03 | Washita | Oklahoma | 40149 | 24 | 0 |
394526 | 394526 | 2020-08-02 | Harmon | Oklahoma | 40057 | 24 | 0 |
391310 | 391310 | 2020-08-01 | Harmon | Oklahoma | 40057 | 24 | 0 |
391356 | 391356 | 2020-08-01 | Washita | Oklahoma | 40149 | 24 | 0 |
388102 | 388102 | 2020-07-31 | Kiowa | Oklahoma | 40075 | 24 | 1 |
388139 | 388139 | 2020-07-31 | Washita | Oklahoma | 40149 | 24 | 0 |
384885 | 384885 | 2020-07-30 | Kiowa | Oklahoma | 40075 | 24 | 1 |
381667 | 381667 | 2020-07-29 | Kiowa | Oklahoma | 40075 | 24 | 1 |
378450 | 378450 | 2020-07-28 | Kiowa | Oklahoma | 40075 | 24 | 1 |
375233 | 375233 | 2020-07-27 | Kiowa | Oklahoma | 40075 | 24 | 1 |
371998 | 371998 | 2020-07-26 | Coal | Oklahoma | 40029 | 24 | 0 |
372021 | 372021 | 2020-07-26 | Kiowa | Oklahoma | 40075 | 24 | 1 |
368786 | 368786 | 2020-07-25 | Coal | Oklahoma | 40029 | 24 | 0 |
368802 | 368802 | 2020-07-25 | Haskell | Oklahoma | 40061 | 24 | 0 |
362362 | 362362 | 2020-07-23 | Blaine | Oklahoma | 40011 | 24 | 0 |
359156 | 359156 | 2020-07-22 | Blaine | Oklahoma | 40011 | 24 | 0 |
359204 | 359204 | 2020-07-22 | Okfuskee | Oklahoma | 40107 | 24 | 0 |
356000 | 356000 | 2020-07-21 | Okfuskee | Oklahoma | 40107 | 24 | 0 |
317681 | 317681 | 2020-07-09 | Murray | Oklahoma | 40099 | 24 | 0 |
298627 | 298627 | 2020-07-03 | Atoka | Oklahoma | 40005 | 24 | 0 |
298694 | 298694 | 2020-07-03 | Tillman | Oklahoma | 40141 | 24 | 1 |
295535 | 295535 | 2020-07-02 | Tillman | Oklahoma | 40141 | 24 | 1 |
273457 | 273457 | 2020-06-25 | Kingfisher | Oklahoma | 40073 | 24 | 0 |
254700 | 254700 | 2020-06-19 | Pontotoc | Oklahoma | 40123 | 24 | 2 |
251575 | 251575 | 2020-06-18 | Noble | Oklahoma | 40103 | 24 | 0 |
251585 | 251585 | 2020-06-18 | Pontotoc | Oklahoma | 40123 | 24 | 2 |
248449 | 248449 | 2020-06-17 | Lincoln | Oklahoma | 40081 | 24 | 2 |
248450 | 248450 | 2020-06-17 | Logan | Oklahoma | 40083 | 24 | 1 |
245337 | 245337 | 2020-06-16 | Logan | Oklahoma | 40083 | 24 | 1 |
242224 | 242224 | 2020-06-15 | Lincoln | Oklahoma | 40081 | 24 | 2 |
239115 | 239115 | 2020-06-14 | Lincoln | Oklahoma | 40081 | 24 | 2 |
229809 | 229809 | 2020-06-11 | Nowata | Oklahoma | 40105 | 24 | 1 |
226705 | 226705 | 2020-06-10 | Nowata | Oklahoma | 40105 | 24 | 1 |
223605 | 223605 | 2020-06-09 | Nowata | Oklahoma | 40105 | 24 | 1 |
220510 | 220510 | 2020-06-08 | Nowata | Oklahoma | 40105 | 24 | 0 |
217418 | 217418 | 2020-06-07 | Nowata | Oklahoma | 40105 | 24 | 0 |
214281 | 214281 | 2020-06-06 | Beaver | Oklahoma | 40007 | 24 | 0 |
211195 | 211195 | 2020-06-05 | Beaver | Oklahoma | 40007 | 24 | 0 |
208113 | 208113 | 2020-06-04 | Beaver | Oklahoma | 40007 | 24 | 0 |
205032 | 205032 | 2020-06-03 | Beaver | Oklahoma | 40007 | 24 | 0 |
201955 | 201955 | 2020-06-02 | Beaver | Oklahoma | 40007 | 24 | 0 |
198880 | 198880 | 2020-06-01 | Beaver | Oklahoma | 40007 | 24 | 0 |
195807 | 195807 | 2020-05-31 | Beaver | Oklahoma | 40007 | 24 | 0 |
192738 | 192738 | 2020-05-30 | Beaver | Oklahoma | 40007 | 24 | 0 |
189673 | 189673 | 2020-05-29 | Beaver | Oklahoma | 40007 | 24 | 0 |
189676 | 189676 | 2020-05-29 | Bryan | Oklahoma | 40013 | 24 | 1 |
189700 | 189700 | 2020-05-29 | Jackson | Oklahoma | 40065 | 24 | 3 |
186613 | 186613 | 2020-05-28 | Beaver | Oklahoma | 40007 | 24 | 0 |
186639 | 186639 | 2020-05-28 | Jackson | Oklahoma | 40065 | 24 | 3 |
186672 | 186672 | 2020-05-28 | Seminole | Oklahoma | 40133 | 24 | 2 |
183556 | 183556 | 2020-05-27 | Beaver | Oklahoma | 40007 | 24 | 0 |
183582 | 183582 | 2020-05-27 | Jackson | Oklahoma | 40065 | 24 | 2 |
180507 | 180507 | 2020-05-26 | Beaver | Oklahoma | 40007 | 24 | 0 |
180533 | 180533 | 2020-05-26 | Jackson | Oklahoma | 40065 | 24 | 2 |
177464 | 177464 | 2020-05-25 | Beaver | Oklahoma | 40007 | 24 | 0 |
174420 | 174420 | 2020-05-24 | Beaver | Oklahoma | 40007 | 24 | 0 |
171378 | 171378 | 2020-05-23 | Beaver | Oklahoma | 40007 | 24 | 0 |
168339 | 168339 | 2020-05-22 | Beaver | Oklahoma | 40007 | 24 | 0 |
165303 | 165303 | 2020-05-21 | Beaver | Oklahoma | 40007 | 24 | 0 |
165322 | 165322 | 2020-05-21 | Garfield | Oklahoma | 40047 | 24 | 1 |
162293 | 162293 | 2020-05-20 | Garfield | Oklahoma | 40047 | 24 | 1 |
153270 | 153270 | 2020-05-17 | Stephens | Oklahoma | 40137 | 24 | 1 |
150259 | 150259 | 2020-05-16 | Stephens | Oklahoma | 40137 | 24 | 1 |
132257 | 132257 | 2020-05-10 | Mayes | Oklahoma | 40097 | 24 | 4 |
129268 | 129268 | 2020-05-09 | Mayes | Oklahoma | 40097 | 24 | 4 |
126279 | 126279 | 2020-05-08 | Mayes | Oklahoma | 40097 | 24 | 4 |
123296 | 123296 | 2020-05-07 | Mayes | Oklahoma | 40097 | 24 | 4 |
120319 | 120319 | 2020-05-06 | Mayes | Oklahoma | 40097 | 24 | 4 |
117358 | 117358 | 2020-05-05 | Mayes | Oklahoma | 40097 | 24 | 4 |
114477 | 114477 | 2020-05-04 | Mayes | Oklahoma | 40097 | 24 | 4 |
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);