ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11 rows where county = "Allegheny", deaths = 2 and state = "Pennsylvania" 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 |
---|---|---|---|---|---|---|---|
30092 | 30092 | 2020-04-03 | Allegheny | Pennsylvania | 42003 | 476 | 2 |
27759 | 27759 | 2020-04-02 | Allegheny | Pennsylvania | 42003 | 419 | 2 |
25487 | 25487 | 2020-04-01 | Allegheny | Pennsylvania | 42003 | 356 | 2 |
23289 | 23289 | 2020-03-31 | Allegheny | Pennsylvania | 42003 | 325 | 2 |
21154 | 21154 | 2020-03-30 | Allegheny | Pennsylvania | 42003 | 290 | 2 |
19104 | 19104 | 2020-03-29 | Allegheny | Pennsylvania | 42003 | 265 | 2 |
17166 | 17166 | 2020-03-28 | Allegheny | Pennsylvania | 42003 | 219 | 2 |
15319 | 15319 | 2020-03-27 | Allegheny | Pennsylvania | 42003 | 158 | 2 |
13573 | 13573 | 2020-03-26 | Allegheny | Pennsylvania | 42003 | 133 | 2 |
11955 | 11955 | 2020-03-25 | Allegheny | Pennsylvania | 42003 | 88 | 2 |
10493 | 10493 | 2020-03-24 | Allegheny | Pennsylvania | 42003 | 58 | 2 |
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);