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 2020-06-05 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-04 | Peru | Amazonas | 680 | 46 | 0 | 634 | -5.077253 | -78.050172 | 2020-06-05 02:33:06 | Amazonas, Peru | ||
2020-06-04 | Peru | Ancash | 5048 | 702 | 0 | 4346 | -9.407125 | -77.67179499999997 | 2020-06-05 02:33:06 | Ancash, Peru | ||
2020-06-04 | Peru | Apurimac | 221 | 10 | 0 | 211 | -14.027713 | -72.975378 | 2020-06-05 02:33:06 | Apurimac, Peru | ||
2020-06-04 | Peru | Arequipa | 3961 | 207 | 0 | 3754 | -15.843523999999999 | -72.475539 | 2020-06-05 02:33:06 | Arequipa, Peru | ||
2020-06-04 | Peru | Ayacucho | 862 | 47 | 0 | 815 | -14.091648000000001 | -74.08344 | 2020-06-05 02:33:06 | Ayacucho, Peru | ||
2020-06-04 | Peru | Cajamarca | 882 | 49 | 0 | 833 | -6.4302839999999994 | -78.74559599999998 | 2020-06-05 02:33:06 | Cajamarca, Peru | ||
2020-06-04 | Peru | Callao | 13291 | 1819 | 0 | 11472 | -11.954609 | -77.136042 | 2020-06-05 02:33:06 | Callao, Peru | ||
2020-06-04 | Peru | Cusco | 1174 | 26 | 0 | 1148 | -13.191068 | -72.153609 | 2020-06-05 02:33:06 | Cusco, Peru | ||
2020-06-04 | Peru | Huancavelica | 487 | 21 | 0 | 466 | -13.023888000000001 | -75.00277 | 2020-06-05 02:33:06 | Huancavelica, Peru | ||
2020-06-04 | Peru | Huanuco | 1068 | 68 | 0 | 1000 | -9.421676 | -76.040642 | 2020-06-05 02:33:06 | Huanuco, Peru | ||
2020-06-04 | Peru | Ica | 3919 | 620 | 0 | 3299 | -14.235097 | -75.574821 | 2020-06-05 02:33:06 | Ica, Peru | ||
2020-06-04 | Peru | Junin | 2089 | 191 | 0 | 1898 | -11.541783 | -74.876968 | 2020-06-05 02:33:06 | Junin, Peru | ||
2020-06-04 | Peru | La Libertad | 5392 | 559 | 0 | 4833 | -7.92139 | -78.370238 | 2020-06-05 02:33:06 | La Libertad, Peru | ||
2020-06-04 | Peru | Lambayeque | 9440 | 1737 | 0 | 7703 | -6.3530489999999995 | -79.824113 | 2020-06-05 02:33:06 | Lambayeque, Peru | ||
2020-06-04 | Peru | Lima | 108680 | 11317 | 0 | 97363 | -11.766533 | -76.60449799999998 | 2020-06-05 02:33:06 | Lima, Peru | ||
2020-06-04 | Peru | Loreto | 5757 | 1929 | 0 | 3828 | -4.124847 | -74.424115 | 2020-06-05 02:33:06 | Loreto, Peru | ||
2020-06-04 | Peru | Madre de Dios | 600 | 8 | 0 | 592 | -11.972699 | -70.53171999999998 | 2020-06-05 02:33:06 | Madre de Dios, Peru | ||
2020-06-04 | Peru | Moquegua | 561 | 11 | 0 | 550 | -16.860271 | -70.839046 | 2020-06-05 02:33:06 | Moquegua, Peru | ||
2020-06-04 | Peru | Pasco | 512 | 24 | 0 | 488 | -10.39655 | -75.307635 | 2020-06-05 02:33:06 | Pasco, Peru | ||
2020-06-04 | Peru | Piura | 9510 | 2420 | 0 | 7090 | -5.133361 | -80.335861 | 2020-06-05 02:33:06 | Piura, Peru | ||
2020-06-04 | Peru | Puno | 422 | 21 | 0 | 401 | -14.995826999999998 | -69.922726 | 2020-06-05 02:33:06 | Puno, Peru | ||
2020-06-04 | Peru | San Martin | 1662 | 102 | 0 | 1560 | -7.039531 | -76.729127 | 2020-06-05 02:33:06 | San Martin, Peru | ||
2020-06-04 | Peru | Tacna | 468 | 16 | 0 | 452 | -17.644160999999997 | -70.27756 | 2020-06-05 02:33:06 | Tacna, Peru | ||
2020-06-04 | Peru | Tumbes | 1489 | 238 | 0 | 1251 | -3.857496 | -80.54525500000003 | 2020-06-05 02:33:06 | Tumbes, Peru | ||
2020-06-04 | Peru | Ucayali | 5023 | 837 | 0 | 4186 | -9.621718 | -73.444929 | 2020-06-05 02:33:06 | Ucayali, Peru | ||
2020-06-04 | Peru | Unknown | 0 | 0 | 76228 | 0 | 2020-06-05 02:33:06 | Unknown, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;