daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where country_or_region = "Peru" and "last_update" is on date 2021-02-08 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-02-07 | Peru | Amazonas | 20066 | 637 | 0 | 19429 | -5.077253 | -78.050172 | 2021-02-08 05:22:39 | Amazonas, Peru | ||
2021-02-07 | Peru | Ancash | 38868 | 3375 | 0 | 35493 | -9.407125 | -77.67179499999997 | 2021-02-08 05:22:39 | Ancash, Peru | ||
2021-02-07 | Peru | Apurimac | 10093 | 532 | 0 | 9561 | -14.027713 | -72.975378 | 2021-02-08 05:22:39 | Apurimac, Peru | ||
2021-02-07 | Peru | Arequipa | 55531 | 4892 | 0 | 50639 | -15.843524 | -72.475539 | 2021-02-08 05:22:39 | Arequipa, Peru | ||
2021-02-07 | Peru | Ayacucho | 17479 | 943 | 0 | 16536 | -14.091648 | -74.08344 | 2021-02-08 05:22:39 | Ayacucho, Peru | ||
2021-02-07 | Peru | Cajamarca | 29641 | 1831 | 0 | 27810 | -6.430284 | -78.74559599999998 | 2021-02-08 05:22:39 | Cajamarca, Peru | ||
2021-02-07 | Peru | Callao | 50895 | 5954 | 0 | 44941 | -11.954609 | -77.136042 | 2021-02-08 05:22:39 | Callao, Peru | ||
2021-02-07 | Peru | Cusco | 30464 | 1894 | 0 | 28570 | -13.191068 | -72.153609 | 2021-02-08 05:22:39 | Cusco, Peru | ||
2021-02-07 | Peru | Huancavelica | 8772 | 478 | 0 | 8294 | -13.023888 | -75.00277 | 2021-02-08 05:22:39 | Huancavelica, Peru | ||
2021-02-07 | Peru | Huanuco | 23878 | 1580 | 0 | 22298 | -9.421676 | -76.040642 | 2021-02-08 05:22:39 | Huanuco, Peru | ||
2021-02-07 | Peru | Ica | 37433 | 4430 | 0 | 33003 | -14.235097 | -75.574821 | 2021-02-08 05:22:39 | Ica, Peru | ||
2021-02-07 | Peru | Junin | 37305 | 3142 | 0 | 34163 | -11.541783 | -74.876968 | 2021-02-08 05:22:39 | Junin, Peru | ||
2021-02-07 | Peru | La Libertad | 41292 | 5373 | 0 | 35919 | -7.92139 | -78.370238 | 2021-02-08 05:22:39 | La Libertad, Peru | ||
2021-02-07 | Peru | Lambayeque | 36340 | 5094 | 0 | 31246 | -6.353049 | -79.824113 | 2021-02-08 05:22:39 | Lambayeque, Peru | ||
2021-02-07 | Peru | Lima | 536546 | 48827 | 0 | 487719 | -11.766533 | -76.60449799999998 | 2021-02-08 05:22:39 | Lima, Peru | ||
2021-02-07 | Peru | Loreto | 27921 | 2918 | 0 | 25003 | -4.124847 | -74.424115 | 2021-02-08 05:22:39 | Loreto, Peru | ||
2021-02-07 | Peru | Madre de Dios | 9832 | 168 | 0 | 9664 | -11.972699 | -70.53171999999998 | 2021-02-08 05:22:39 | Madre de Dios, Peru | ||
2021-02-07 | Peru | Moquegua | 18461 | 1061 | 0 | 17400 | -16.860271 | -70.839046 | 2021-02-08 05:22:39 | Moquegua, Peru | ||
2021-02-07 | Peru | Pasco | 8404 | 498 | 0 | 7906 | -10.39655 | -75.307635 | 2021-02-08 05:22:39 | Pasco, Peru | ||
2021-02-07 | Peru | Piura | 47301 | 7073 | 0 | 40228 | -5.133361 | -80.335861 | 2021-02-08 05:22:39 | Piura, Peru | ||
2021-02-07 | Peru | Puno | 21823 | 1834 | 0 | 19989 | -14.995826999999998 | -69.922726 | 2021-02-08 05:22:39 | Puno, Peru | ||
2021-02-07 | Peru | San Martin | 28151 | 1692 | 0 | 26459 | -7.039531 | -76.729127 | 2021-02-08 05:22:39 | San Martin, Peru | ||
2021-02-07 | Peru | Tacna | 17782 | 1056 | 0 | 16726 | -17.644160999999997 | -70.27756 | 2021-02-08 05:22:39 | Tacna, Peru | ||
2021-02-07 | Peru | Tumbes | 10607 | 858 | 0 | 9749 | -3.857496 | -80.54525500000003 | 2021-02-08 05:22:39 | Tumbes, Peru | ||
2021-02-07 | Peru | Ucayali | 21813 | 1722 | 0 | 20091 | -9.621718 | -73.444929 | 2021-02-08 05:22:39 | Ucayali, Peru | ||
2021-02-07 | Peru | Unknown | 0 | 0 | 1089040 | 0 | 2021-02-08 05:22:39 | Unknown, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;