ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 75 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
818803 | 818803 | 2020-12-11 | Unknown | Oklahoma | 75 | 0 | |
737668 | 737668 | 2020-11-16 | Unknown | Oklahoma | 75 | 0 | |
679239 | 679239 | 2020-10-29 | Harmon | Oklahoma | 40057 | 75 | 0 |
630544 | 630544 | 2020-10-14 | Beaver | Oklahoma | 40007 | 75 | 0 |
624076 | 624076 | 2020-10-12 | Dewey | Oklahoma | 40043 | 75 | 1 |
620833 | 620833 | 2020-10-11 | Dewey | Oklahoma | 40043 | 75 | 1 |
617591 | 617591 | 2020-10-10 | Dewey | Oklahoma | 40043 | 75 | 1 |
614349 | 614349 | 2020-10-09 | Dewey | Oklahoma | 40043 | 75 | 1 |
614392 | 614392 | 2020-10-09 | Roger Mills | Oklahoma | 40129 | 75 | 1 |
611101 | 611101 | 2020-10-08 | Coal | Oklahoma | 40029 | 75 | 0 |
611103 | 611103 | 2020-10-08 | Cotton | Oklahoma | 40033 | 75 | 3 |
611151 | 611151 | 2020-10-08 | Roger Mills | Oklahoma | 40129 | 75 | 1 |
607859 | 607859 | 2020-10-07 | Coal | Oklahoma | 40029 | 75 | 0 |
604616 | 604616 | 2020-10-06 | Coal | Oklahoma | 40029 | 75 | 0 |
598131 | 598131 | 2020-10-04 | Coal | Oklahoma | 40029 | 75 | 0 |
594888 | 594888 | 2020-10-03 | Coal | Oklahoma | 40029 | 75 | 0 |
588393 | 588393 | 2020-10-01 | Alfalfa | Oklahoma | 40003 | 75 | 0 |
572224 | 572224 | 2020-09-26 | Kiowa | Oklahoma | 40075 | 75 | 2 |
568982 | 568982 | 2020-09-25 | Kiowa | Oklahoma | 40075 | 75 | 2 |
556061 | 556061 | 2020-09-21 | Unknown | Oklahoma | 75 | 0 | |
491285 | 491285 | 2020-09-01 | Blaine | Oklahoma | 40011 | 75 | 1 |
488052 | 488052 | 2020-08-31 | Blaine | Oklahoma | 40011 | 75 | 1 |
468723 | 468723 | 2020-08-25 | Woodward | Oklahoma | 40153 | 75 | 0 |
462241 | 462241 | 2020-08-23 | Nowata | Oklahoma | 40105 | 75 | 1 |
423513 | 423513 | 2020-08-11 | Love | Oklahoma | 40085 | 75 | 0 |
420290 | 420290 | 2020-08-10 | Love | Oklahoma | 40085 | 75 | 0 |
417070 | 417070 | 2020-08-09 | Love | Oklahoma | 40085 | 75 | 0 |
413849 | 413849 | 2020-08-08 | Love | Oklahoma | 40085 | 75 | 0 |
368808 | 368808 | 2020-07-25 | Kingfisher | Oklahoma | 40073 | 75 | 0 |
340001 | 340001 | 2020-07-16 | Pawnee | Oklahoma | 40117 | 75 | 3 |
336786 | 336786 | 2020-07-15 | Le Flore | Oklahoma | 40079 | 75 | 1 |
336805 | 336805 | 2020-07-15 | Pawnee | Oklahoma | 40117 | 75 | 3 |
317673 | 317673 | 2020-07-09 | Logan | Oklahoma | 40083 | 75 | 1 |
295489 | 295489 | 2020-07-02 | Garfield | Oklahoma | 40047 | 75 | 2 |
276613 | 276613 | 2020-06-26 | Mayes | Oklahoma | 40097 | 75 | 4 |
270289 | 270289 | 2020-06-24 | Bryan | Oklahoma | 40013 | 75 | 1 |
270292 | 270292 | 2020-06-24 | Carter | Oklahoma | 40019 | 75 | 1 |
245358 | 245358 | 2020-06-16 | Pottawatomie | Oklahoma | 40125 | 75 | 4 |
205074 | 205074 | 2020-06-03 | McCurtain | Oklahoma | 40089 | 75 | 1 |
156224 | 156224 | 2020-05-18 | Adair | Oklahoma | 40001 | 75 | 3 |
153207 | 153207 | 2020-05-17 | Adair | Oklahoma | 40001 | 75 | 3 |
103002 | 103002 | 2020-04-30 | Osage | Oklahoma | 40113 | 75 | 8 |
83164 | 83164 | 2020-04-23 | Comanche | Oklahoma | 40031 | 75 | 1 |
74788 | 74788 | 2020-04-20 | Canadian | Oklahoma | 40017 | 75 | 3 |
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);