johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where country_or_region = "Peru" and deaths = 1184 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update (date)
province_or_state 4
- Huancavelica 3
- Moquegua 2
- Cajamarca 1
- Ucayali 1
country_or_region 1
- Peru · 7 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2610210 | 2610210 | 2022-01-06 | Peru | Huancavelica | 16671 | 1184 | 0 | -13.023888000000001 | -75.00277 | 2022-01-07 04:22:09 | Huancavelica, Peru | |||
1282152 | 1282152 | 2022-01-05 | Peru | Huancavelica | 16671 | 1184 | 0 | -13.023888000000001 | -75.00277 | 2022-01-06 04:22:09 | Huancavelica, Peru | |||
1286168 | 1286168 | 2022-01-04 | Peru | Huancavelica | 16671 | 1184 | 0 | -13.023888000000001 | -75.00277 | 2022-01-05 04:21:59 | Huancavelica, Peru | |||
1409210 | 1409210 | 2021-04-23 | Peru | Moquegua | 22835 | 1184 | 0 | 21651 | -16.860271 | -70.839046 | 2021-04-24 04:20:38 | Moquegua, Peru | ||
1568273 | 1568273 | 2021-04-22 | Peru | Moquegua | 22835 | 1184 | 0 | 21651 | -16.860271 | -70.839046 | 2021-04-23 04:20:52 | Moquegua, Peru | ||
2661928 | 2661928 | 2020-09-04 | Peru | Cajamarca | 15812 | 1184 | 0 | 14628 | -6.430284 | -78.74559599999998 | 2020-09-05 04:28:19 | Cajamarca, Peru | ||
1503003 | 1503003 | 2020-07-25 | Peru | Ucayali | 9381 | 1184 | 0 | 8197 | -9.621718 | -73.444929 | 2020-07-26 04:35:00 | Ucayali, Peru |
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]);