johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where confirmed = 3635, country_or_region = "US" and province_or_state = "Pennsylvania" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 5 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
801141 | 801141 | 2021-12-22 | US | Pennsylvania | Wyoming | 42131 | 3635 | 81 | 0 | 41.51955538 | -76.01074915 | 2021-12-23 04:21:21 | Wyoming, Pennsylvania, US | |
3056882 | 3056882 | 2021-05-13 | US | Pennsylvania | Snyder | 42109 | 3635 | 84 | 0 | 40.77129231 | -77.06840691 | 2021-05-14 04:20:41 | Snyder, Pennsylvania, US | |
2823449 | 2823449 | 2021-05-10 | US | Pennsylvania | McKean | 42083 | 3635 | 68 | 0 | 41.80938602 | -78.56478358 | 2021-05-11 04:20:41 | McKean, Pennsylvania, US | |
608387 | 608387 | 2021-04-09 | US | Pennsylvania | Venango | 42121 | 3635 | 90 | 0 | 41.40323442 | -79.75845449 | 2021-04-10 04:20:59 | Venango, Pennsylvania, US | |
1826659 | 1826659 | 2020-05-16 | US | Pennsylvania | Berks | 42011 | 3635 | 208 | 0 | 3427 | 40.41570541 | -75.92457766 | 2020-05-17 02:32:32 | Berks, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);