ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where county = "Lebanon" and deaths = 294 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 |
---|---|---|---|---|---|---|---|
1477849 | 1477849 | 2021-07-02 | Lebanon | Pennsylvania | 42075 | 16204 | 294 |
1474603 | 1474603 | 2021-07-01 | Lebanon | Pennsylvania | 42075 | 16202 | 294 |
1471357 | 1471357 | 2021-06-30 | Lebanon | Pennsylvania | 42075 | 16201 | 294 |
1468112 | 1468112 | 2021-06-29 | Lebanon | Pennsylvania | 42075 | 16201 | 294 |
1464867 | 1464867 | 2021-06-28 | Lebanon | Pennsylvania | 42075 | 16197 | 294 |
1461622 | 1461622 | 2021-06-27 | Lebanon | Pennsylvania | 42075 | 16197 | 294 |
1458377 | 1458377 | 2021-06-26 | Lebanon | Pennsylvania | 42075 | 16196 | 294 |
1455132 | 1455132 | 2021-06-25 | Lebanon | Pennsylvania | 42075 | 16195 | 294 |
1451887 | 1451887 | 2021-06-24 | Lebanon | Pennsylvania | 42075 | 16193 | 294 |
1448641 | 1448641 | 2021-06-23 | Lebanon | Pennsylvania | 42075 | 16191 | 294 |
1445396 | 1445396 | 2021-06-22 | Lebanon | Pennsylvania | 42075 | 16187 | 294 |
1442151 | 1442151 | 2021-06-21 | Lebanon | Pennsylvania | 42075 | 16184 | 294 |
1438906 | 1438906 | 2021-06-20 | Lebanon | Pennsylvania | 42075 | 16182 | 294 |
1435659 | 1435659 | 2021-06-19 | Lebanon | Pennsylvania | 42075 | 16181 | 294 |
1432412 | 1432412 | 2021-06-18 | Lebanon | Pennsylvania | 42075 | 16181 | 294 |
1429166 | 1429166 | 2021-06-17 | Lebanon | Pennsylvania | 42075 | 16181 | 294 |
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);