ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 8, fips = 40111 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 |
---|---|---|---|---|---|---|---|
669538 | 669538 | 2020-10-26 | Okmulgee | Oklahoma | 40111 | 1224 | 8 |
666294 | 666294 | 2020-10-25 | Okmulgee | Oklahoma | 40111 | 1219 | 8 |
663049 | 663049 | 2020-10-24 | Okmulgee | Oklahoma | 40111 | 1209 | 8 |
659805 | 659805 | 2020-10-23 | Okmulgee | Oklahoma | 40111 | 1182 | 8 |
656561 | 656561 | 2020-10-22 | Okmulgee | Oklahoma | 40111 | 1153 | 8 |
653316 | 653316 | 2020-10-21 | Okmulgee | Oklahoma | 40111 | 1140 | 8 |
650071 | 650071 | 2020-10-20 | Okmulgee | Oklahoma | 40111 | 1121 | 8 |
646827 | 646827 | 2020-10-19 | Okmulgee | Oklahoma | 40111 | 1090 | 8 |
643581 | 643581 | 2020-10-18 | Okmulgee | Oklahoma | 40111 | 1073 | 8 |
640333 | 640333 | 2020-10-17 | Okmulgee | Oklahoma | 40111 | 1058 | 8 |
637087 | 637087 | 2020-10-16 | Okmulgee | Oklahoma | 40111 | 1033 | 8 |
633841 | 633841 | 2020-10-15 | Okmulgee | Oklahoma | 40111 | 1002 | 8 |
630596 | 630596 | 2020-10-14 | Okmulgee | Oklahoma | 40111 | 988 | 8 |
627352 | 627352 | 2020-10-13 | Okmulgee | Oklahoma | 40111 | 979 | 8 |
624110 | 624110 | 2020-10-12 | Okmulgee | Oklahoma | 40111 | 959 | 8 |
620867 | 620867 | 2020-10-11 | Okmulgee | Oklahoma | 40111 | 955 | 8 |
617625 | 617625 | 2020-10-10 | Okmulgee | Oklahoma | 40111 | 951 | 8 |
614383 | 614383 | 2020-10-09 | Okmulgee | Oklahoma | 40111 | 937 | 8 |
611142 | 611142 | 2020-10-08 | Okmulgee | Oklahoma | 40111 | 931 | 8 |
607900 | 607900 | 2020-10-07 | Okmulgee | Oklahoma | 40111 | 911 | 8 |
604657 | 604657 | 2020-10-06 | Okmulgee | Oklahoma | 40111 | 899 | 8 |
601415 | 601415 | 2020-10-05 | Okmulgee | Oklahoma | 40111 | 893 | 8 |
598172 | 598172 | 2020-10-04 | Okmulgee | Oklahoma | 40111 | 890 | 8 |
594929 | 594929 | 2020-10-03 | Okmulgee | Oklahoma | 40111 | 889 | 8 |
591688 | 591688 | 2020-10-02 | Okmulgee | Oklahoma | 40111 | 876 | 8 |
588447 | 588447 | 2020-10-01 | Okmulgee | Oklahoma | 40111 | 864 | 8 |
585207 | 585207 | 2020-09-30 | Okmulgee | Oklahoma | 40111 | 852 | 8 |
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);