ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 79 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
773312 | 773312 | 2020-11-27 | Cimarron | Oklahoma | 40025 | 79 | 0 |
705186 | 705186 | 2020-11-06 | Harmon | Oklahoma | 40057 | 79 | 0 |
701943 | 701943 | 2020-11-05 | Harmon | Oklahoma | 40057 | 79 | 0 |
698699 | 698699 | 2020-11-04 | Harmon | Oklahoma | 40057 | 79 | 0 |
692214 | 692214 | 2020-11-02 | Harmon | Oklahoma | 40057 | 79 | 0 |
692215 | 692215 | 2020-11-02 | Harper | Oklahoma | 40059 | 79 | 2 |
650042 | 650042 | 2020-10-20 | Grant | Oklahoma | 40053 | 79 | 1 |
646793 | 646793 | 2020-10-19 | Dewey | Oklahoma | 40043 | 79 | 1 |
643529 | 643529 | 2020-10-18 | Beaver | Oklahoma | 40007 | 79 | 0 |
643540 | 643540 | 2020-10-18 | Coal | Oklahoma | 40029 | 79 | 0 |
640281 | 640281 | 2020-10-17 | Beaver | Oklahoma | 40007 | 79 | 0 |
640292 | 640292 | 2020-10-17 | Coal | Oklahoma | 40029 | 79 | 0 |
637046 | 637046 | 2020-10-16 | Coal | Oklahoma | 40029 | 79 | 0 |
627361 | 627361 | 2020-10-13 | Roger Mills | Oklahoma | 40129 | 79 | 2 |
601361 | 601361 | 2020-10-05 | Alfalfa | Oklahoma | 40003 | 79 | 0 |
588429 | 588429 | 2020-10-01 | Kiowa | Oklahoma | 40075 | 79 | 2 |
497752 | 497752 | 2020-09-03 | Blaine | Oklahoma | 40011 | 79 | 1 |
475189 | 475189 | 2020-08-27 | Woodward | Oklahoma | 40153 | 79 | 0 |
436420 | 436420 | 2020-08-15 | Murray | Oklahoma | 40099 | 79 | 0 |
433187 | 433187 | 2020-08-14 | Love | Oklahoma | 40085 | 79 | 0 |
433194 | 433194 | 2020-08-14 | Murray | Oklahoma | 40099 | 79 | 0 |
426696 | 426696 | 2020-08-12 | Atoka | Oklahoma | 40005 | 79 | 0 |
410604 | 410604 | 2020-08-07 | Craig | Oklahoma | 40035 | 79 | 0 |
384875 | 384875 | 2020-07-30 | Greer | Oklahoma | 40055 | 79 | 7 |
381657 | 381657 | 2020-07-29 | Greer | Oklahoma | 40055 | 79 | 7 |
381693 | 381693 | 2020-07-29 | Pushmataha | Oklahoma | 40127 | 79 | 0 |
378440 | 378440 | 2020-07-28 | Greer | Oklahoma | 40055 | 79 | 7 |
372020 | 372020 | 2020-07-26 | Kingfisher | Oklahoma | 40073 | 79 | 0 |
343208 | 343208 | 2020-07-17 | Sequoyah | Oklahoma | 40135 | 79 | 3 |
317680 | 317680 | 2020-07-09 | McIntosh | Oklahoma | 40091 | 79 | 1 |
304974 | 304974 | 2020-07-05 | Garfield | Oklahoma | 40047 | 79 | 2 |
292320 | 292320 | 2020-07-01 | Cherokee | Oklahoma | 40021 | 79 | 1 |
286052 | 286052 | 2020-06-29 | Mayes | Oklahoma | 40097 | 79 | 4 |
257800 | 257800 | 2020-06-20 | Kay | Oklahoma | 40071 | 79 | 7 |
251586 | 251586 | 2020-06-18 | Pottawatomie | Oklahoma | 40125 | 79 | 4 |
242234 | 242234 | 2020-06-15 | Muskogee | Oklahoma | 40101 | 79 | 8 |
211237 | 211237 | 2020-06-05 | McCurtain | Oklahoma | 40089 | 79 | 1 |
183614 | 183614 | 2020-05-27 | Rogers | Oklahoma | 40131 | 79 | 5 |
177485 | 177485 | 2020-05-25 | Grady | Oklahoma | 40051 | 79 | 3 |
168336 | 168336 | 2020-05-22 | Adair | Oklahoma | 40001 | 79 | 3 |
100111 | 100111 | 2020-04-29 | Comanche | Oklahoma | 40031 | 79 | 1 |
97262 | 97262 | 2020-04-28 | Comanche | Oklahoma | 40031 | 79 | 1 |
94424 | 94424 | 2020-04-27 | Comanche | Oklahoma | 40031 | 79 | 1 |
91598 | 91598 | 2020-04-26 | Comanche | Oklahoma | 40031 | 79 | 1 |
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);