ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where county = "Garvin", deaths = 6 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 |
---|---|---|---|---|---|---|---|
692210 | 692210 | 2020-11-02 | Garvin | Oklahoma | 40049 | 791 | 6 |
688966 | 688966 | 2020-11-01 | Garvin | Oklahoma | 40049 | 774 | 6 |
685721 | 685721 | 2020-10-31 | Garvin | Oklahoma | 40049 | 752 | 6 |
682478 | 682478 | 2020-10-30 | Garvin | Oklahoma | 40049 | 721 | 6 |
679235 | 679235 | 2020-10-29 | Garvin | Oklahoma | 40049 | 699 | 6 |
675992 | 675992 | 2020-10-28 | Garvin | Oklahoma | 40049 | 689 | 6 |
672749 | 672749 | 2020-10-27 | Garvin | Oklahoma | 40049 | 679 | 6 |
669507 | 669507 | 2020-10-26 | Garvin | Oklahoma | 40049 | 661 | 6 |
666263 | 666263 | 2020-10-25 | Garvin | Oklahoma | 40049 | 653 | 6 |
663018 | 663018 | 2020-10-24 | Garvin | Oklahoma | 40049 | 632 | 6 |
659774 | 659774 | 2020-10-23 | Garvin | Oklahoma | 40049 | 613 | 6 |
656530 | 656530 | 2020-10-22 | Garvin | Oklahoma | 40049 | 606 | 6 |
653285 | 653285 | 2020-10-21 | Garvin | Oklahoma | 40049 | 597 | 6 |
650040 | 650040 | 2020-10-20 | Garvin | Oklahoma | 40049 | 588 | 6 |
646796 | 646796 | 2020-10-19 | Garvin | Oklahoma | 40049 | 574 | 6 |
643550 | 643550 | 2020-10-18 | Garvin | Oklahoma | 40049 | 569 | 6 |
640302 | 640302 | 2020-10-17 | Garvin | Oklahoma | 40049 | 561 | 6 |
637056 | 637056 | 2020-10-16 | Garvin | Oklahoma | 40049 | 558 | 6 |
633810 | 633810 | 2020-10-15 | Garvin | Oklahoma | 40049 | 547 | 6 |
630565 | 630565 | 2020-10-14 | Garvin | Oklahoma | 40049 | 529 | 6 |
627321 | 627321 | 2020-10-13 | Garvin | Oklahoma | 40049 | 514 | 6 |
624079 | 624079 | 2020-10-12 | Garvin | Oklahoma | 40049 | 504 | 6 |
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);