ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 453 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1644252 | 1644252 | 2021-08-22 | Ferry | Washington | 53019 | 453 | 9 |
1641002 | 1641002 | 2021-08-21 | Ferry | Washington | 53019 | 453 | 9 |
1637752 | 1637752 | 2021-08-20 | Ferry | Washington | 53019 | 453 | 9 |
891066 | 891066 | 2021-01-02 | Pend Oreille | Washington | 53051 | 453 | 4 |
887819 | 887819 | 2021-01-01 | Pend Oreille | Washington | 53051 | 453 | 4 |
884574 | 884574 | 2020-12-31 | Pend Oreille | Washington | 53051 | 453 | 4 |
521307 | 521307 | 2020-09-10 | Kittitas | Washington | 53037 | 453 | 21 |
518070 | 518070 | 2020-09-09 | Kittitas | Washington | 53037 | 453 | 21 |
514835 | 514835 | 2020-09-08 | Kittitas | Washington | 53037 | 453 | 21 |
511602 | 511602 | 2020-09-07 | Kittitas | Washington | 53037 | 453 | 21 |
508369 | 508369 | 2020-09-06 | Kittitas | Washington | 53037 | 453 | 21 |
408276 | 408276 | 2020-08-06 | Cowlitz | Washington | 53015 | 453 | 5 |
405056 | 405056 | 2020-08-05 | Cowlitz | Washington | 53015 | 453 | 5 |
401838 | 401838 | 2020-08-04 | Cowlitz | Washington | 53015 | 453 | 5 |
243095 | 243095 | 2020-06-15 | Whatcom | Washington | 53073 | 453 | 38 |
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);