johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where country_or_region = "Peru" and "day" is on date 2022-06-18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3397581 | 3397581 | 2022-06-18 | Peru | Amazonas | 44241 | 1346 | 0 | -5.077253 | -78.050172 | 2022-06-19 04:20:51 | Amazonas, Peru | |||
3397582 | 3397582 | 2022-06-18 | Peru | Ancash | 129278 | 7191 | 0 | -9.407125 | -77.671795 | 2022-06-19 04:20:51 | Ancash, Peru | |||
3397583 | 3397583 | 2022-06-18 | Peru | Apurimac | 39105 | 1639 | 0 | -14.027713 | -72.975378 | 2022-06-19 04:20:51 | Apurimac, Peru | |||
3397584 | 3397584 | 2022-06-18 | Peru | Arequipa | 216555 | 10343 | 0 | -15.843524 | -72.475539 | 2022-06-19 04:20:51 | Arequipa, Peru | |||
3397585 | 3397585 | 2022-06-18 | Peru | Ayacucho | 48261 | 2336 | 0 | -14.091648 | -74.08344 | 2022-06-19 04:20:51 | Ayacucho, Peru | |||
3397586 | 3397586 | 2022-06-18 | Peru | Cajamarca | 96297 | 4474 | 0 | -6.430284 | -78.745596 | 2022-06-19 04:20:51 | Cajamarca, Peru | |||
3397587 | 3397587 | 2022-06-18 | Peru | Callao | 147537 | 10523 | 0 | -11.954609 | -77.136042 | 2022-06-19 04:20:51 | Callao, Peru | |||
3397588 | 3397588 | 2022-06-18 | Peru | Cusco | 117572 | 5179 | 0 | -13.191068 | -72.153609 | 2022-06-19 04:20:51 | Cusco, Peru | |||
3397589 | 3397589 | 2022-06-18 | Peru | Huancavelica | 25873 | 1275 | 0 | -13.023888 | -75.00277 | 2022-06-19 04:20:51 | Huancavelica, Peru | |||
3397590 | 3397590 | 2022-06-18 | Peru | Huanuco | 52227 | 2896 | 0 | -9.421676 | -76.040642 | 2022-06-19 04:20:51 | Huanuco, Peru | |||
3397591 | 3397591 | 2022-06-18 | Peru | Ica | 104083 | 8947 | 0 | -14.235097 | -75.574821 | 2022-06-19 04:20:51 | Ica, Peru | |||
3397592 | 3397592 | 2022-06-18 | Peru | Junin | 126621 | 7487 | 0 | -11.541783 | -74.876968 | 2022-06-19 04:20:51 | Junin, Peru | |||
3397593 | 3397593 | 2022-06-18 | Peru | La Libertad | 147153 | 10873 | 0 | -7.92139 | -78.370238 | 2022-06-19 04:20:51 | La Libertad, Peru | |||
3397594 | 3397594 | 2022-06-18 | Peru | Lambayeque | 105850 | 9251 | 0 | -6.353049 | -79.824113 | 2022-06-19 04:20:51 | Lambayeque, Peru | |||
3397595 | 3397595 | 2022-06-18 | Peru | Lima | 1632737 | 93376 | 0 | -11.766533 | -76.604498 | 2022-06-19 04:20:51 | Lima, Peru | |||
3397596 | 3397596 | 2022-06-18 | Peru | Loreto | 58014 | 4396 | 0 | -4.124847 | -74.424115 | 2022-06-19 04:20:51 | Loreto, Peru | |||
3397597 | 3397597 | 2022-06-18 | Peru | Madre de Dios | 17897 | 858 | 0 | -11.972699 | -70.53172 | 2022-06-19 04:20:51 | Madre de Dios, Peru | |||
3397598 | 3397598 | 2022-06-18 | Peru | Moquegua | 49149 | 1633 | 0 | -16.860271 | -70.839046 | 2022-06-19 04:20:51 | Moquegua, Peru | |||
3397599 | 3397599 | 2022-06-18 | Peru | Pasco | 24033 | 1108 | 0 | -10.39655 | -75.307635 | 2022-06-19 04:20:51 | Pasco, Peru | |||
3397600 | 3397600 | 2022-06-18 | Peru | Piura | 158817 | 13109 | 0 | -5.133361 | -80.335861 | 2022-06-19 04:20:51 | Piura, Peru | |||
3397601 | 3397601 | 2022-06-18 | Peru | Puno | 66476 | 4812 | 0 | -14.995827 | -69.922726 | 2022-06-19 04:20:51 | Puno, Peru | |||
3397602 | 3397602 | 2022-06-18 | Peru | San Martin | 61875 | 3169 | 0 | -7.039531 | -76.729127 | 2022-06-19 04:20:51 | San Martin, Peru | |||
3397603 | 3397603 | 2022-06-18 | Peru | Tacna | 54010 | 2144 | 0 | -17.644161 | -70.27756 | 2022-06-19 04:20:51 | Tacna, Peru | |||
3397604 | 3397604 | 2022-06-18 | Peru | Tumbes | 27618 | 1696 | 0 | -3.857496 | -80.545255 | 2022-06-19 04:20:51 | Tumbes, Peru | |||
3397605 | 3397605 | 2022-06-18 | Peru | Ucayali | 39603 | 3263 | 0 | -9.621718 | -73.444929 | 2022-06-19 04:20:51 | Ucayali, Peru | |||
3397606 | 3397606 | 2022-06-18 | Peru | Unknown | 6984 | 58 | 0 | 2022-06-19 04:20:51 | 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]);