ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where county = "Washington", deaths = 32 and state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
180760 | 180760 | 2020-05-26 | Washington | Rhode Island | 44009 | 486 | 32 |
177717 | 177717 | 2020-05-25 | Washington | Rhode Island | 44009 | 486 | 32 |
174673 | 174673 | 2020-05-24 | Washington | Rhode Island | 44009 | 486 | 32 |
171631 | 171631 | 2020-05-23 | Washington | Rhode Island | 44009 | 485 | 32 |
168592 | 168592 | 2020-05-22 | Washington | Rhode Island | 44009 | 482 | 32 |
165556 | 165556 | 2020-05-21 | Washington | Rhode Island | 44009 | 471 | 32 |
162527 | 162527 | 2020-05-20 | Washington | Rhode Island | 44009 | 462 | 32 |
159500 | 159500 | 2020-05-19 | Washington | Rhode Island | 44009 | 425 | 32 |
156479 | 156479 | 2020-05-18 | Washington | Rhode Island | 44009 | 425 | 32 |
153462 | 153462 | 2020-05-17 | Washington | Rhode Island | 44009 | 425 | 32 |
150451 | 150451 | 2020-05-16 | Washington | Rhode Island | 44009 | 425 | 32 |
147443 | 147443 | 2020-05-15 | Washington | Rhode Island | 44009 | 425 | 32 |
144442 | 144442 | 2020-05-14 | Washington | Rhode Island | 44009 | 425 | 32 |
141446 | 141446 | 2020-05-13 | Washington | Rhode Island | 44009 | 425 | 32 |
138450 | 138450 | 2020-05-12 | Washington | Rhode Island | 44009 | 411 | 32 |
135460 | 135460 | 2020-05-11 | Washington | Rhode Island | 44009 | 406 | 32 |
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);