daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where country_or_region = "Peru" and "day" is on date 2020-10-17 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 26
country_or_region 1
- Peru · 26 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-17 | Peru | Amazonas | 15804 | 517 | 0 | 15287 | -5.077253 | -78.050172 | 2020-10-18 04:24:25 | Amazonas, Peru | ||
2020-10-17 | Peru | Ancash | 24568 | 2595 | 0 | 21973 | -9.407125 | -77.67179499999997 | 2020-10-18 04:24:25 | Ancash, Peru | ||
2020-10-17 | Peru | Apurimac | 5302 | 255 | 0 | 5047 | -14.027713 | -72.975378 | 2020-10-18 04:24:25 | Apurimac, Peru | ||
2020-10-17 | Peru | Arequipa | 43368 | 3925 | 0 | 39443 | -15.843524 | -72.475539 | 2020-10-18 04:24:25 | Arequipa, Peru | ||
2020-10-17 | Peru | Ayacucho | 12486 | 749 | 0 | 11737 | -14.091648 | -74.08344 | 2020-10-18 04:24:25 | Ayacucho, Peru | ||
2020-10-17 | Peru | Cajamarca | 21143 | 1402 | 0 | 19741 | -6.430284 | -78.74559599999998 | 2020-10-18 04:24:25 | Cajamarca, Peru | ||
2020-10-17 | Peru | Callao | 35233 | 4854 | 0 | 30379 | -11.954609 | -77.136042 | 2020-10-18 04:24:25 | Callao, Peru | ||
2020-10-17 | Peru | Cusco | 21479 | 1394 | 0 | 20085 | -13.191068 | -72.153609 | 2020-10-18 04:24:25 | Cusco, Peru | ||
2020-10-17 | Peru | Huancavelica | 7032 | 349 | 0 | 6683 | -13.023888 | -75.00277 | 2020-10-18 04:24:25 | Huancavelica, Peru | ||
2020-10-17 | Peru | Huanuco | 16661 | 910 | 0 | 15751 | -9.421676 | -76.040642 | 2020-10-18 04:24:25 | Huanuco, Peru | ||
2020-10-17 | Peru | Ica | 28884 | 3344 | 0 | 25540 | -14.235097 | -75.574821 | 2020-10-18 04:24:25 | Ica, Peru | ||
2020-10-17 | Peru | Junin | 21414 | 2184 | 0 | 19230 | -11.541783 | -74.876968 | 2020-10-18 04:24:25 | Junin, Peru | ||
2020-10-17 | Peru | La Libertad | 31005 | 4373 | 0 | 26632 | -7.92139 | -78.370238 | 2020-10-18 04:24:25 | La Libertad, Peru | ||
2020-10-17 | Peru | Lambayeque | 27348 | 3900 | 0 | 23448 | -6.353049 | -79.824113 | 2020-10-18 04:24:25 | Lambayeque, Peru | ||
2020-10-17 | Peru | Lima | 391515 | 38987 | 0 | 352528 | -11.766533 | -76.60449799999998 | 2020-10-18 04:24:25 | Lima, Peru | ||
2020-10-17 | Peru | Loreto | 20817 | 2676 | 0 | 18141 | -4.124847 | -74.424115 | 2020-10-18 04:24:25 | Loreto, Peru | ||
2020-10-17 | Peru | Madre de Dios | 8575 | 142 | 0 | 8433 | -11.972699 | -70.53171999999998 | 2020-10-18 04:24:25 | Madre de Dios, Peru | ||
2020-10-17 | Peru | Moquegua | 13795 | 797 | 0 | 12998 | -16.860271 | -70.839046 | 2020-10-18 04:24:25 | Moquegua, Peru | ||
2020-10-17 | Peru | Pasco | 5455 | 276 | 0 | 5179 | -10.39655 | -75.307635 | 2020-10-18 04:24:25 | Pasco, Peru | ||
2020-10-17 | Peru | Piura | 37168 | 5417 | 0 | 31751 | -5.133361 | -80.335861 | 2020-10-18 04:24:25 | Piura, Peru | ||
2020-10-17 | Peru | Puno | 16232 | 1367 | 0 | 14865 | -14.995826999999998 | -69.922726 | 2020-10-18 04:24:25 | Puno, Peru | ||
2020-10-17 | Peru | San Martin | 19658 | 1499 | 0 | 18159 | -7.039531 | -76.729127 | 2020-10-18 04:24:25 | San Martin, Peru | ||
2020-10-17 | Peru | Tacna | 12657 | 737 | 0 | 11920 | -17.644160999999997 | -70.27756 | 2020-10-18 04:24:25 | Tacna, Peru | ||
2020-10-17 | Peru | Tumbes | 7744 | 679 | 0 | 7065 | -3.857496 | -80.54525500000003 | 2020-10-18 04:24:25 | Tumbes, Peru | ||
2020-10-17 | Peru | Ucayali | 17074 | 1501 | 0 | 15573 | -9.621718 | -73.444929 | 2020-10-18 04:24:25 | Ucayali, Peru | ||
2020-10-17 | Peru | Unknown | 0 | 0 | 774356 | 0 | 2020-10-18 04:24:25 | Unknown, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;