johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where country_or_region = "Peru" and deaths = 882 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update (date)
province_or_state 3
- Madre de Dios 14
- Cajamarca 1
- Tumbes 1
country_or_region 1
- Peru · 16 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3551823 | 3551823 | 2022-11-27 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-28 04:21:02 | Madre de Dios, Peru | |||
2100303 | 2100303 | 2022-11-26 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-27 04:21:05 | Madre de Dios, Peru | |||
487794 | 487794 | 2022-11-25 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-26 04:21:11 | Madre de Dios, Peru | |||
3523623 | 3523623 | 2022-11-24 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-25 04:21:06 | Madre de Dios, Peru | |||
3312406 | 3312406 | 2022-11-23 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-24 04:21:09 | Madre de Dios, Peru | |||
1620447 | 1620447 | 2022-11-22 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-23 04:21:06 | Madre de Dios, Peru | |||
3460335 | 3460335 | 2022-11-21 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-22 04:20:47 | Madre de Dios, Peru | |||
1640520 | 1640520 | 2022-11-20 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-21 04:21:05 | Madre de Dios, Peru | |||
2064077 | 2064077 | 2022-11-19 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-20 04:21:08 | Madre de Dios, Peru | |||
1755471 | 1755471 | 2022-11-18 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-19 04:21:14 | Madre de Dios, Peru | |||
3026464 | 3026464 | 2022-11-17 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-18 04:21:15 | Madre de Dios, Peru | |||
2486175 | 2486175 | 2022-11-16 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-17 04:21:11 | Madre de Dios, Peru | |||
292186 | 292186 | 2022-11-15 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-16 04:21:09 | Madre de Dios, Peru | |||
3597216 | 3597216 | 2022-11-14 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-15 04:21:16 | Madre de Dios, Peru | |||
3539632 | 3539632 | 2021-02-12 | Peru | Tumbes | 10756 | 882 | 0 | 9874 | -3.857496 | -80.54525500000003 | 2021-02-13 05:22:12 | Tumbes, Peru | ||
3923036 | 3923036 | 2020-08-09 | Peru | Cajamarca | 8422 | 882 | 0 | 7540 | -6.430284 | -78.74559599999998 | 2020-08-10 04:34:55 | Cajamarca, 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]);