ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where county = "Trumbull" and deaths = 493 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 |
---|---|---|---|---|---|---|---|
1633571 | 1633571 | 2021-08-19 | Trumbull | Ohio | 39155 | 17472 | 493 |
1630324 | 1630324 | 2021-08-18 | Trumbull | Ohio | 39155 | 17429 | 493 |
1627077 | 1627077 | 2021-08-17 | Trumbull | Ohio | 39155 | 17389 | 493 |
1623830 | 1623830 | 2021-08-16 | Trumbull | Ohio | 39155 | 17348 | 493 |
1620583 | 1620583 | 2021-08-15 | Trumbull | Ohio | 39155 | 17326 | 493 |
1617335 | 1617335 | 2021-08-14 | Trumbull | Ohio | 39155 | 17284 | 493 |
1614087 | 1614087 | 2021-08-13 | Trumbull | Ohio | 39155 | 17246 | 493 |
1610838 | 1610838 | 2021-08-12 | Trumbull | Ohio | 39155 | 17214 | 493 |
1607590 | 1607590 | 2021-08-11 | Trumbull | Ohio | 39155 | 17157 | 493 |
1604341 | 1604341 | 2021-08-10 | Trumbull | Ohio | 39155 | 17117 | 493 |
1601092 | 1601092 | 2021-08-09 | Trumbull | Ohio | 39155 | 17085 | 493 |
1597844 | 1597844 | 2021-08-08 | Trumbull | Ohio | 39155 | 17070 | 493 |
1594595 | 1594595 | 2021-08-07 | Trumbull | Ohio | 39155 | 17055 | 493 |
1591346 | 1591346 | 2021-08-06 | Trumbull | Ohio | 39155 | 17011 | 493 |
1588097 | 1588097 | 2021-08-05 | Trumbull | Ohio | 39155 | 16985 | 493 |
1584847 | 1584847 | 2021-08-04 | Trumbull | Ohio | 39155 | 16967 | 493 |
1581597 | 1581597 | 2021-08-03 | Trumbull | Ohio | 39155 | 16940 | 493 |
1578348 | 1578348 | 2021-08-02 | Trumbull | Ohio | 39155 | 16915 | 493 |
1575100 | 1575100 | 2021-08-01 | Trumbull | Ohio | 39155 | 16900 | 493 |
1571852 | 1571852 | 2021-07-31 | Trumbull | Ohio | 39155 | 16885 | 493 |
1568604 | 1568604 | 2021-07-30 | Trumbull | Ohio | 39155 | 16863 | 493 |
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);