johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where country_or_region = "Peru" and "last_update" is on date 2020-08-05 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date)
province_or_state 26
country_or_region 1
- Peru · 26 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98084 | 98084 | 2020-08-04 | Peru | Amazonas | 6340 | 349 | 0 | 5991 | -5.077253 | -78.050172 | 2020-08-05 04:34:43 | Amazonas, Peru | ||
98086 | 98086 | 2020-08-04 | Peru | Ancash | 12770 | 1886 | 0 | 10884 | -9.407125 | -77.67179499999997 | 2020-08-05 04:34:43 | Ancash, Peru | ||
98095 | 98095 | 2020-08-04 | Peru | Apurimac | 1029 | 69 | 0 | 960 | -14.027713 | -72.975378 | 2020-08-05 04:34:43 | Apurimac, Peru | ||
98099 | 98099 | 2020-08-04 | Peru | Arequipa | 15845 | 2406 | 0 | 13439 | -15.843524 | -72.475539 | 2020-08-05 04:34:43 | Arequipa, Peru | ||
98110 | 98110 | 2020-08-04 | Peru | Ayacucho | 4223 | 301 | 0 | 3922 | -14.091648 | -74.08344 | 2020-08-05 04:34:43 | Ayacucho, Peru | ||
98139 | 98139 | 2020-08-04 | Peru | Cajamarca | 6992 | 793 | 0 | 6199 | -6.430284 | -78.74559599999998 | 2020-08-05 04:34:43 | Cajamarca, Peru | ||
98142 | 98142 | 2020-08-04 | Peru | Callao | 21943 | 3699 | 0 | 18244 | -11.954609 | -77.136042 | 2020-08-05 04:34:43 | Callao, Peru | ||
98181 | 98181 | 2020-08-04 | Peru | Cusco | 5201 | 393 | 0 | 4808 | -13.191068 | -72.153609 | 2020-08-05 04:34:43 | Cusco, Peru | ||
98246 | 98246 | 2020-08-04 | Peru | Huancavelica | 1921 | 127 | 0 | 1794 | -13.023888 | -75.00277 | 2020-08-05 04:34:43 | Huancavelica, Peru | ||
98247 | 98247 | 2020-08-04 | Peru | Huanuco | 7084 | 536 | 0 | 6548 | -9.421676 | -76.040642 | 2020-08-05 04:34:43 | Huanuco, Peru | ||
98253 | 98253 | 2020-08-04 | Peru | Ica | 13615 | 2311 | 0 | 11304 | -14.235097 | -75.574821 | 2020-08-05 04:34:43 | Ica, Peru | ||
98272 | 98272 | 2020-08-04 | Peru | Junin | 8461 | 1244 | 0 | 7217 | -11.541783 | -74.876968 | 2020-08-05 04:34:43 | Junin, Peru | ||
98309 | 98309 | 2020-08-04 | Peru | La Libertad | 16089 | 3278 | 0 | 12811 | -7.92139 | -78.370238 | 2020-08-05 04:34:43 | La Libertad, Peru | ||
98313 | 98313 | 2020-08-04 | Peru | Lambayeque | 17801 | 2891 | 0 | 14910 | -6.353049 | -79.824113 | 2020-08-05 04:34:43 | Lambayeque, Peru | ||
98318 | 98318 | 2020-08-04 | Peru | Lima | 227717 | 27419 | 0 | 200298 | -11.766533 | -76.60449799999998 | 2020-08-05 04:34:43 | Lima, Peru | ||
98322 | 98322 | 2020-08-04 | Peru | Loreto | 11949 | 2494 | 0 | 9455 | -4.124847 | -74.424115 | 2020-08-05 04:34:43 | Loreto, Peru | ||
98329 | 98329 | 2020-08-04 | Peru | Madre de Dios | 3657 | 104 | 0 | 3553 | -11.972699 | -70.53171999999998 | 2020-08-05 04:34:43 | Madre de Dios, Peru | ||
98359 | 98359 | 2020-08-04 | Peru | Moquegua | 3461 | 351 | 0 | 3110 | -16.860271 | -70.839046 | 2020-08-05 04:34:43 | Moquegua, Peru | ||
98420 | 98420 | 2020-08-04 | Peru | Pasco | 2155 | 122 | 0 | 2033 | -10.39655 | -75.307635 | 2020-08-05 04:34:43 | Pasco, Peru | ||
98426 | 98426 | 2020-08-04 | Peru | Piura | 21694 | 4212 | 0 | 17482 | -5.133361 | -80.335861 | 2020-08-05 04:34:43 | Piura, Peru | ||
98437 | 98437 | 2020-08-04 | Peru | Puno | 2705 | 355 | 0 | 2350 | -14.995826999999998 | -69.922726 | 2020-08-05 04:34:43 | Puno, Peru | ||
98472 | 98472 | 2020-08-04 | Peru | San Martin | 9218 | 1155 | 0 | 8063 | -7.039531 | -76.729127 | 2020-08-05 04:34:43 | San Martin, Peru | ||
98508 | 98508 | 2020-08-04 | Peru | Tacna | 3288 | 227 | 0 | 3061 | -17.644160999999997 | -70.27756 | 2020-08-05 04:34:43 | Tacna, Peru | ||
98532 | 98532 | 2020-08-04 | Peru | Tumbes | 4352 | 547 | 0 | 3805 | -3.857496 | -80.54525500000003 | 2020-08-05 04:34:43 | Tumbes, Peru | ||
98537 | 98537 | 2020-08-04 | Peru | Ucayali | 10380 | 1249 | 0 | 9131 | -9.621718 | -73.444929 | 2020-08-05 04:34:43 | Ucayali, Peru | ||
98546 | 98546 | 2020-08-04 | Peru | Unknown | 0 | 0 | 302457 | 0 | 2020-08-05 04:34:43 | Unknown, 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]);