johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

6,297 rows where country_or_region = "Peru" sorted by day descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: combined_key, day (date), last_update (date)

province_or_state

country_or_region

  • Peru · 6,297 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298758 298758 2021-01-21 Peru Amazonas     19012 261 0 18751 -5.077253 -78.050172 2021-01-22 05:22:10 Amazonas, Peru
298759 298759 2021-01-21 Peru Ancash     34319 1591 0 32728 -9.407125 -77.67179499999997 2021-01-22 05:22:10 Ancash, Peru
298760 298760 2021-01-21 Peru Apurimac     8808 179 0 8629 -14.027713 -72.975378 2021-01-22 05:22:10 Apurimac, Peru
298761 298761 2021-01-21 Peru Arequipa     50709 1692 0 49017 -15.843524 -72.475539 2021-01-22 05:22:10 Arequipa, Peru
298762 298762 2021-01-21 Peru Ayacucho     16116 393 0 15723 -14.091648 -74.08344 2021-01-22 05:22:10 Ayacucho, Peru
298763 298763 2021-01-21 Peru Cajamarca     27050 643 0 26407 -6.430284 -78.74559599999998 2021-01-22 05:22:10 Cajamarca, Peru
298764 298764 2021-01-21 Peru Callao     45811 2037 0 43774 -11.954609 -77.136042 2021-01-22 05:22:10 Callao, Peru
298765 298765 2021-01-21 Peru Cusco     26678 571 0 26107 -13.191068 -72.153609 2021-01-22 05:22:10 Cusco, Peru
298766 298766 2021-01-21 Peru Huancavelica     8065 160 0 7905 -13.023888 -75.00277 2021-01-22 05:22:10 Huancavelica, Peru
298767 298767 2021-01-21 Peru Huanuco     22107 558 0 21549 -9.421676 -76.040642 2021-01-22 05:22:10 Huanuco, Peru
298768 298768 2021-01-21 Peru Ica     33757 1849 0 31908 -14.235097 -75.574821 2021-01-22 05:22:10 Ica, Peru
298769 298769 2021-01-21 Peru Junin     31281 1040 0 30241 -11.541783 -74.876968 2021-01-22 05:22:10 Junin, Peru
298770 298770 2021-01-21 Peru La Libertad     38819 2552 0 36267 -7.92139 -78.370238 2021-01-22 05:22:10 La Libertad, Peru
298771 298771 2021-01-21 Peru Lambayeque     34578 1990 0 32588 -6.353049 -79.824113 2021-01-22 05:22:10 Lambayeque, Peru
298772 298772 2021-01-21 Peru Lima     477590 17247 0 460343 -11.766533 -76.60449799999998 2021-01-22 05:22:10 Lima, Peru
298773 298773 2021-01-21 Peru Loreto     26755 1024 0 25731 -4.124847 -74.424115 2021-01-22 05:22:10 Loreto, Peru
298774 298774 2021-01-21 Peru Madre de Dios     9654 163 0 9491 -11.972699 -70.53171999999998 2021-01-22 05:22:10 Madre de Dios, Peru
298775 298775 2021-01-21 Peru Moquegua     17093 352 0 16741 -16.860271 -70.839046 2021-01-22 05:22:10 Moquegua, Peru
298776 298776 2021-01-21 Peru Pasco     7176 161 0 7015 -10.39655 -75.307635 2021-01-22 05:22:10 Pasco, Peru
298777 298777 2021-01-21 Peru Piura     44874 2268 0 42606 -5.133361 -80.335861 2021-01-22 05:22:10 Piura, Peru
298778 298778 2021-01-21 Peru Puno     19915 430 0 19485 -14.995826999999998 -69.922726 2021-01-22 05:22:10 Puno, Peru
298779 298779 2021-01-21 Peru San Martin     26584 812 0 25772 -7.039531 -76.729127 2021-01-22 05:22:10 San Martin, Peru
298780 298780 2021-01-21 Peru Tacna     15607 304 0 15303 -17.644160999999997 -70.27756 2021-01-22 05:22:10 Tacna, Peru
298781 298781 2021-01-21 Peru Tumbes     9890 363 0 9527 -3.857496 -80.54525500000003 2021-01-22 05:22:10 Tumbes, Peru
298782 298782 2021-01-21 Peru Ucayali     20966 404 0 20562 -9.621718 -73.444929 2021-01-22 05:22:10 Ucayali, Peru
298783 298783 2021-01-21 Peru Unknown     0 0 993509 -993509     2021-01-22 05:22:10 Unknown, Peru
889809 889809 2021-01-20 Peru Amazonas     19012 261 0 18751 -5.077253 -78.050172 2021-01-21 05:22:01 Amazonas, Peru
889810 889810 2021-01-20 Peru Ancash     34319 1591 0 32728 -9.407125 -77.67179499999997 2021-01-21 05:22:01 Ancash, Peru
889811 889811 2021-01-20 Peru Apurimac     8808 179 0 8629 -14.027713 -72.975378 2021-01-21 05:22:01 Apurimac, Peru
889812 889812 2021-01-20 Peru Arequipa     50709 1692 0 49017 -15.843524 -72.475539 2021-01-21 05:22:01 Arequipa, Peru
889813 889813 2021-01-20 Peru Ayacucho     16116 393 0 15723 -14.091648 -74.08344 2021-01-21 05:22:01 Ayacucho, Peru
889814 889814 2021-01-20 Peru Cajamarca     27050 643 0 26407 -6.430284 -78.74559599999998 2021-01-21 05:22:01 Cajamarca, Peru
889815 889815 2021-01-20 Peru Callao     45811 2037 0 43774 -11.954609 -77.136042 2021-01-21 05:22:01 Callao, Peru
889816 889816 2021-01-20 Peru Cusco     26678 571 0 26107 -13.191068 -72.153609 2021-01-21 05:22:01 Cusco, Peru
889817 889817 2021-01-20 Peru Huancavelica     8065 160 0 7905 -13.023888 -75.00277 2021-01-21 05:22:01 Huancavelica, Peru
889818 889818 2021-01-20 Peru Huanuco     22107 558 0 21549 -9.421676 -76.040642 2021-01-21 05:22:01 Huanuco, Peru
889819 889819 2021-01-20 Peru Ica     33757 1849 0 31908 -14.235097 -75.574821 2021-01-21 05:22:01 Ica, Peru
889820 889820 2021-01-20 Peru Junin     31281 1040 0 30241 -11.541783 -74.876968 2021-01-21 05:22:01 Junin, Peru
889821 889821 2021-01-20 Peru La Libertad     38819 2552 0 36267 -7.92139 -78.370238 2021-01-21 05:22:01 La Libertad, Peru
889822 889822 2021-01-20 Peru Lambayeque     34578 1990 0 32588 -6.353049 -79.824113 2021-01-21 05:22:01 Lambayeque, Peru
889823 889823 2021-01-20 Peru Lima     477590 17247 0 460343 -11.766533 -76.60449799999998 2021-01-21 05:22:01 Lima, Peru
889824 889824 2021-01-20 Peru Loreto     26755 1024 0 25731 -4.124847 -74.424115 2021-01-21 05:22:01 Loreto, Peru
889825 889825 2021-01-20 Peru Madre de Dios     9654 163 0 9491 -11.972699 -70.53171999999998 2021-01-21 05:22:01 Madre de Dios, Peru
889826 889826 2021-01-20 Peru Moquegua     17093 352 0 16741 -16.860271 -70.839046 2021-01-21 05:22:01 Moquegua, Peru
889827 889827 2021-01-20 Peru Pasco     7176 161 0 7015 -10.39655 -75.307635 2021-01-21 05:22:01 Pasco, Peru
889828 889828 2021-01-20 Peru Piura     44874 2268 0 42606 -5.133361 -80.335861 2021-01-21 05:22:01 Piura, Peru
889829 889829 2021-01-20 Peru Puno     19915 430 0 19485 -14.995826999999998 -69.922726 2021-01-21 05:22:01 Puno, Peru
889830 889830 2021-01-20 Peru San Martin     26584 812 0 25772 -7.039531 -76.729127 2021-01-21 05:22:01 San Martin, Peru
889831 889831 2021-01-20 Peru Tacna     15607 304 0 15303 -17.644160999999997 -70.27756 2021-01-21 05:22:01 Tacna, Peru
889832 889832 2021-01-20 Peru Tumbes     9890 363 0 9527 -3.857496 -80.54525500000003 2021-01-21 05:22:01 Tumbes, Peru
889833 889833 2021-01-20 Peru Ucayali     20966 404 0 20562 -9.621718 -73.444929 2021-01-21 05:22:01 Ucayali, Peru
889834 889834 2021-01-20 Peru Unknown     0 0 989367 -989367     2021-01-21 05:22:01 Unknown, Peru
318376 318376 2021-01-19 Peru Amazonas     18918 258 0 18660 -5.077253 -78.050172 2021-01-20 05:21:54 Amazonas, Peru
318377 318377 2021-01-19 Peru Ancash     33668 1577 0 32091 -9.407125 -77.67179499999997 2021-01-20 05:21:54 Ancash, Peru
318378 318378 2021-01-19 Peru Apurimac     8648 176 0 8472 -14.027713 -72.975378 2021-01-20 05:21:54 Apurimac, Peru
318379 318379 2021-01-19 Peru Arequipa     50258 1680 0 48578 -15.843524 -72.475539 2021-01-20 05:21:54 Arequipa, Peru
318380 318380 2021-01-19 Peru Ayacucho     15963 388 0 15575 -14.091648 -74.08344 2021-01-20 05:21:54 Ayacucho, Peru
318381 318381 2021-01-19 Peru Cajamarca     26503 636 0 25867 -6.430284 -78.74559599999998 2021-01-20 05:21:54 Cajamarca, Peru
318382 318382 2021-01-19 Peru Callao     45137 2024 0 43113 -11.954609 -77.136042 2021-01-20 05:21:54 Callao, Peru
318383 318383 2021-01-19 Peru Cusco     26355 563 0 25792 -13.191068 -72.153609 2021-01-20 05:21:54 Cusco, Peru
318384 318384 2021-01-19 Peru Huancavelica     8046 156 0 7890 -13.023888 -75.00277 2021-01-20 05:21:54 Huancavelica, Peru
318385 318385 2021-01-19 Peru Huanuco     21745 546 0 21199 -9.421676 -76.040642 2021-01-20 05:21:54 Huanuco, Peru
318386 318386 2021-01-19 Peru Ica     33331 1838 0 31493 -14.235097 -75.574821 2021-01-20 05:21:54 Ica, Peru
318387 318387 2021-01-19 Peru Junin     30725 1022 0 29703 -11.541783 -74.876968 2021-01-20 05:21:54 Junin, Peru
318388 318388 2021-01-19 Peru La Libertad     38662 2540 0 36122 -7.92139 -78.370238 2021-01-20 05:21:54 La Libertad, Peru
318389 318389 2021-01-19 Peru Lambayeque     34317 1978 0 32339 -6.353049 -79.824113 2021-01-20 05:21:54 Lambayeque, Peru
318390 318390 2021-01-19 Peru Lima     471155 17152 0 454003 -11.766533 -76.60449799999998 2021-01-20 05:21:54 Lima, Peru
318391 318391 2021-01-19 Peru Loreto     26677 1020 0 25657 -4.124847 -74.424115 2021-01-20 05:21:54 Loreto, Peru
318392 318392 2021-01-19 Peru Madre de Dios     9639 162 0 9477 -11.972699 -70.53171999999998 2021-01-20 05:21:54 Madre de Dios, Peru
318393 318393 2021-01-19 Peru Moquegua     16885 347 0 16538 -16.860271 -70.839046 2021-01-20 05:21:54 Moquegua, Peru
318394 318394 2021-01-19 Peru Pasco     7081 155 0 6926 -10.39655 -75.307635 2021-01-20 05:21:54 Pasco, Peru
318395 318395 2021-01-19 Peru Piura     44590 2258 0 42332 -5.133361 -80.335861 2021-01-20 05:21:54 Piura, Peru
318396 318396 2021-01-19 Peru Puno     19806 426 0 19380 -14.995826999999998 -69.922726 2021-01-20 05:21:54 Puno, Peru
318397 318397 2021-01-19 Peru San Martin     26433 809 0 25624 -7.039531 -76.729127 2021-01-20 05:21:54 San Martin, Peru
318398 318398 2021-01-19 Peru Tacna     15431 297 0 15134 -17.644160999999997 -70.27756 2021-01-20 05:21:54 Tacna, Peru
318399 318399 2021-01-19 Peru Tumbes     9781 360 0 9421 -3.857496 -80.54525500000003 2021-01-20 05:21:54 Tumbes, Peru
318400 318400 2021-01-19 Peru Ucayali     20813 402 0 20411 -9.621718 -73.444929 2021-01-20 05:21:54 Ucayali, Peru
318401 318401 2021-01-19 Peru Unknown     0 0 984726 -984726     2021-01-20 05:21:54 Unknown, Peru
570362 570362 2021-01-18 Peru Amazonas     18918 258 0 18660 -5.077253 -78.050172 2021-01-19 05:22:15 Amazonas, Peru
570363 570363 2021-01-18 Peru Ancash     33668 1577 0 32091 -9.407125 -77.67179499999997 2021-01-19 05:22:15 Ancash, Peru
570364 570364 2021-01-18 Peru Apurimac     8648 176 0 8472 -14.027713 -72.975378 2021-01-19 05:22:15 Apurimac, Peru
570365 570365 2021-01-18 Peru Arequipa     50258 1680 0 48578 -15.843524 -72.475539 2021-01-19 05:22:15 Arequipa, Peru
570366 570366 2021-01-18 Peru Ayacucho     15963 388 0 15575 -14.091648 -74.08344 2021-01-19 05:22:15 Ayacucho, Peru
570367 570367 2021-01-18 Peru Cajamarca     26503 636 0 25867 -6.430284 -78.74559599999998 2021-01-19 05:22:15 Cajamarca, Peru
570368 570368 2021-01-18 Peru Callao     45137 2024 0 43113 -11.954609 -77.136042 2021-01-19 05:22:15 Callao, Peru
570369 570369 2021-01-18 Peru Cusco     26355 563 0 25792 -13.191068 -72.153609 2021-01-19 05:22:15 Cusco, Peru
570370 570370 2021-01-18 Peru Huancavelica     8046 156 0 7890 -13.023888 -75.00277 2021-01-19 05:22:15 Huancavelica, Peru
570371 570371 2021-01-18 Peru Huanuco     21745 546 0 21199 -9.421676 -76.040642 2021-01-19 05:22:15 Huanuco, Peru
570372 570372 2021-01-18 Peru Ica     33331 1838 0 31493 -14.235097 -75.574821 2021-01-19 05:22:15 Ica, Peru
570373 570373 2021-01-18 Peru Junin     30725 1022 0 29703 -11.541783 -74.876968 2021-01-19 05:22:15 Junin, Peru
570374 570374 2021-01-18 Peru La Libertad     38662 2540 0 36122 -7.92139 -78.370238 2021-01-19 05:22:15 La Libertad, Peru
570375 570375 2021-01-18 Peru Lambayeque     34317 1978 0 32339 -6.353049 -79.824113 2021-01-19 05:22:15 Lambayeque, Peru
570376 570376 2021-01-18 Peru Lima     471155 17152 0 454003 -11.766533 -76.60449799999998 2021-01-19 05:22:15 Lima, Peru
570377 570377 2021-01-18 Peru Loreto     26677 1020 0 25657 -4.124847 -74.424115 2021-01-19 05:22:15 Loreto, Peru
570378 570378 2021-01-18 Peru Madre de Dios     9639 162 0 9477 -11.972699 -70.53171999999998 2021-01-19 05:22:15 Madre de Dios, Peru
570379 570379 2021-01-18 Peru Moquegua     16885 347 0 16538 -16.860271 -70.839046 2021-01-19 05:22:15 Moquegua, Peru
570380 570380 2021-01-18 Peru Pasco     7081 155 0 6926 -10.39655 -75.307635 2021-01-19 05:22:15 Pasco, Peru
570381 570381 2021-01-18 Peru Piura     44590 2258 0 42332 -5.133361 -80.335861 2021-01-19 05:22:15 Piura, Peru
570382 570382 2021-01-18 Peru Puno     19806 426 0 19380 -14.995826999999998 -69.922726 2021-01-19 05:22:15 Puno, Peru
570383 570383 2021-01-18 Peru San Martin     26433 809 0 25624 -7.039531 -76.729127 2021-01-19 05:22:15 San Martin, Peru

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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] INTEGER,
   [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]);