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 2021-08-01 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3904126 | 3904126 | 2021-07-31 | Peru | Amazonas | 30705 | 1211 | 0 | 29494 | -5.077253 | -78.050172 | 2021-08-01 04:21:50 | Amazonas, Peru | ||
3904127 | 3904127 | 2021-07-31 | Peru | Ancash | 74688 | 6544 | 0 | 68144 | -9.407125 | -77.67179499999997 | 2021-08-01 04:21:50 | Ancash, Peru | ||
3904128 | 3904128 | 2021-07-31 | Peru | Apurimac | 25453 | 1461 | 0 | 23992 | -14.027713 | -72.975378 | 2021-08-01 04:21:50 | Apurimac, Peru | ||
3904129 | 3904129 | 2021-07-31 | Peru | Arequipa | 108950 | 9439 | 0 | 99511 | -15.843524 | -72.475539 | 2021-08-01 04:21:50 | Arequipa, Peru | ||
3904130 | 3904130 | 2021-07-31 | Peru | Ayacucho | 31846 | 2047 | 0 | 29799 | -14.091648 | -74.08344 | 2021-08-01 04:21:50 | Ayacucho, Peru | ||
3904131 | 3904131 | 2021-07-31 | Peru | Cajamarca | 63875 | 4014 | 0 | 59861 | -6.430284 | -78.74559599999998 | 2021-08-01 04:21:50 | Cajamarca, Peru | ||
3904132 | 3904132 | 2021-07-31 | Peru | Callao | 98350 | 9825 | 0 | 88525 | -11.954609 | -77.136042 | 2021-08-01 04:21:50 | Callao, Peru | ||
3904133 | 3904133 | 2021-07-31 | Peru | Cusco | 70230 | 4602 | 0 | 65628 | -13.191068 | -72.153609 | 2021-08-01 04:21:50 | Cusco, Peru | ||
3904134 | 3904134 | 2021-07-31 | Peru | Huancavelica | 15626 | 1124 | 0 | 14502 | -13.023888 | -75.00277 | 2021-08-01 04:21:50 | Huancavelica, Peru | ||
3904135 | 3904135 | 2021-07-31 | Peru | Huanuco | 34664 | 2645 | 0 | 32019 | -9.421676 | -76.040642 | 2021-08-01 04:21:50 | Huanuco, Peru | ||
3904136 | 3904136 | 2021-07-31 | Peru | Ica | 56249 | 8156 | 0 | 48093 | -14.235097 | -75.574821 | 2021-08-01 04:21:50 | Ica, Peru | ||
3904137 | 3904137 | 2021-07-31 | Peru | Junin | 81564 | 6853 | 0 | 74711 | -11.541783 | -74.876968 | 2021-08-01 04:21:50 | Junin, Peru | ||
3904138 | 3904138 | 2021-07-31 | Peru | La Libertad | 85544 | 10032 | 0 | 75512 | -7.92139 | -78.370238 | 2021-08-01 04:21:50 | La Libertad, Peru | ||
3904139 | 3904139 | 2021-07-31 | Peru | Lambayeque | 58726 | 8470 | 0 | 50256 | -6.353049 | -79.824113 | 2021-08-01 04:21:50 | Lambayeque, Peru | ||
3904140 | 3904140 | 2021-07-31 | Peru | Lima | 923458 | 87380 | 0 | 836078 | -11.766533 | -76.60449799999998 | 2021-08-01 04:21:50 | Lima, Peru | ||
3904141 | 3904141 | 2021-07-31 | Peru | Loreto | 43860 | 4127 | 0 | 39733 | -4.124847 | -74.424115 | 2021-08-01 04:21:50 | Loreto, Peru | ||
3904142 | 3904142 | 2021-07-31 | Peru | Madre de Dios | 13650 | 751 | 0 | 12899 | -11.972699 | -70.53171999999998 | 2021-08-01 04:21:50 | Madre de Dios, Peru | ||
3904143 | 3904143 | 2021-07-31 | Peru | Moquegua | 28225 | 1463 | 0 | 26762 | -16.860271 | -70.839046 | 2021-08-01 04:21:50 | Moquegua, Peru | ||
3904144 | 3904144 | 2021-07-31 | Peru | Pasco | 15162 | 1016 | 0 | 14146 | -10.39655 | -75.307635 | 2021-08-01 04:21:50 | Pasco, Peru | ||
3904145 | 3904145 | 2021-07-31 | Peru | Piura | 84506 | 11714 | 0 | 72792 | -5.133361 | -80.335861 | 2021-08-01 04:21:50 | Piura, Peru | ||
3904146 | 3904146 | 2021-07-31 | Peru | Puno | 37091 | 3917 | 0 | 33174 | -14.995826999999998 | -69.922726 | 2021-08-01 04:21:50 | Puno, Peru | ||
3904147 | 3904147 | 2021-07-31 | Peru | San Martin | 47408 | 2912 | 0 | 44496 | -7.039531 | -76.729127 | 2021-08-01 04:21:50 | San Martin, Peru | ||
3904148 | 3904148 | 2021-07-31 | Peru | Tacna | 29004 | 1925 | 0 | 27079 | -17.644160999999997 | -70.27756 | 2021-08-01 04:21:50 | Tacna, Peru | ||
3904149 | 3904149 | 2021-07-31 | Peru | Tumbes | 17903 | 1539 | 0 | 16364 | -3.857496 | -80.54525500000003 | 2021-08-01 04:21:50 | Tumbes, Peru | ||
3904150 | 3904150 | 2021-07-31 | Peru | Ucayali | 31858 | 3047 | 0 | 28811 | -9.621718 | -73.444929 | 2021-08-01 04:21:50 | Ucayali, Peru | ||
3904151 | 3904151 | 2021-07-31 | Peru | Unknown | 2798 | 139 | 2078316 | 0 | 2021-08-01 04:21:50 | 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]);