ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "Clatsop", deaths = 3 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919421 | 919421 | 2021-01-11 | Clatsop | Oregon | 41007 | 627 | 3 |
916176 | 916176 | 2021-01-10 | Clatsop | Oregon | 41007 | 626 | 3 |
912931 | 912931 | 2021-01-09 | Clatsop | Oregon | 41007 | 620 | 3 |
909686 | 909686 | 2021-01-08 | Clatsop | Oregon | 41007 | 615 | 3 |
906441 | 906441 | 2021-01-07 | Clatsop | Oregon | 41007 | 607 | 3 |
903195 | 903195 | 2021-01-06 | Clatsop | Oregon | 41007 | 606 | 3 |
899950 | 899950 | 2021-01-05 | Clatsop | Oregon | 41007 | 591 | 3 |
896705 | 896705 | 2021-01-04 | Clatsop | Oregon | 41007 | 588 | 3 |
893459 | 893459 | 2021-01-03 | Clatsop | Oregon | 41007 | 586 | 3 |
890213 | 890213 | 2021-01-02 | Clatsop | Oregon | 41007 | 580 | 3 |
886966 | 886966 | 2021-01-01 | Clatsop | Oregon | 41007 | 580 | 3 |
883721 | 883721 | 2020-12-31 | Clatsop | Oregon | 41007 | 553 | 3 |
880476 | 880476 | 2020-12-30 | Clatsop | Oregon | 41007 | 549 | 3 |
877231 | 877231 | 2020-12-29 | Clatsop | Oregon | 41007 | 538 | 3 |
873986 | 873986 | 2020-12-28 | Clatsop | Oregon | 41007 | 524 | 3 |
870741 | 870741 | 2020-12-27 | Clatsop | Oregon | 41007 | 524 | 3 |
867496 | 867496 | 2020-12-26 | Clatsop | Oregon | 41007 | 518 | 3 |
864251 | 864251 | 2020-12-25 | Clatsop | Oregon | 41007 | 518 | 3 |
861006 | 861006 | 2020-12-24 | Clatsop | Oregon | 41007 | 513 | 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);