johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Peru" and province_or_state = "Lima" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
443523 | 443523 | 2021-10-20 | Peru | Lima | 955774 | 88616 | 0 | -11.766533 | -76.60449799999998 | 2021-10-21 04:21:18 | Lima, Peru | |||
597842 | 597842 | 2021-10-19 | Peru | Lima | 954749 | 88576 | 0 | -11.766533 | -76.60449799999998 | 2021-10-20 04:21:00 | Lima, Peru | |||
2044019 | 2044019 | 2021-10-18 | Peru | Lima | 954749 | 88576 | 0 | -11.766533 | -76.60449799999998 | 2021-10-19 04:20:54 | Lima, Peru | |||
1909380 | 1909380 | 2021-10-17 | Peru | Lima | 954749 | 88576 | 0 | -11.766533 | -76.60449799999998 | 2021-10-18 04:21:10 | Lima, Peru | |||
934969 | 934969 | 2021-10-16 | Peru | Lima | 953897 | 88554 | 0 | -11.766533 | -76.60449799999998 | 2021-10-17 04:21:29 | Lima, Peru | |||
2943524 | 2943524 | 2021-10-15 | Peru | Lima | 953897 | 88554 | 0 | -11.766533 | -76.60449799999998 | 2021-10-16 04:21:15 | Lima, Peru | |||
491804 | 491804 | 2021-10-14 | Peru | Lima | 952925 | 88544 | 0 | -11.766533 | -76.60449799999998 | 2021-10-15 04:21:26 | Lima, Peru | |||
634092 | 634092 | 2021-10-13 | Peru | Lima | 952925 | 88544 | 0 | -11.766533 | -76.60449799999998 | 2021-10-14 04:21:29 | Lima, Peru | |||
1491770 | 1491770 | 2021-10-12 | Peru | Lima | 952925 | 88544 | 0 | -11.766533 | -76.60449799999998 | 2021-10-13 04:20:51 | Lima, Peru | |||
3007503 | 3007503 | 2021-10-11 | Peru | Lima | 952334 | 88515 | 0 | -11.766533 | -76.60449799999998 | 2021-10-12 04:21:09 | Lima, Peru | |||
423519 | 423519 | 2021-10-10 | Peru | Lima | 952334 | 88515 | 0 | -11.766533 | -76.60449799999998 | 2021-10-11 04:21:31 | Lima, Peru | |||
2876376 | 2876376 | 2021-10-09 | Peru | Lima | 951732 | 88498 | 0 | -11.766533 | -76.60449799999998 | 2021-10-10 04:21:38 | Lima, Peru | |||
2959542 | 2959542 | 2021-10-08 | Peru | Lima | 951732 | 88498 | 0 | -11.766533 | -76.60449799999998 | 2021-10-09 04:21:34 | Lima, Peru | |||
467580 | 467580 | 2021-10-07 | Peru | Lima | 950856 | 88454 | 0 | -11.766533 | -76.60449799999998 | 2021-10-08 04:21:25 | Lima, Peru | |||
2458960 | 2458960 | 2021-10-06 | Peru | Lima | 949770 | 88416 | 0 | -11.766533 | -76.60449799999998 | 2021-10-07 04:21:36 | Lima, Peru | |||
3832654 | 3832654 | 2021-10-05 | Peru | Lima | 949770 | 88416 | 0 | -11.766533 | -76.60449799999998 | 2021-10-06 04:21:33 | Lima, Peru | |||
987147 | 987147 | 2021-10-04 | Peru | Lima | 949770 | 88416 | 0 | -11.766533 | -76.60449799999998 | 2021-10-05 04:21:27 | Lima, Peru | |||
1274457 | 1274457 | 2021-10-03 | Peru | Lima | 948989 | 88402 | 0 | -11.766533 | -76.60449799999998 | 2021-10-04 04:21:31 | Lima, Peru | |||
3928210 | 3928210 | 2021-10-02 | Peru | Lima | 948989 | 88402 | 0 | -11.766533 | -76.60449799999998 | 2021-10-03 04:21:24 | Lima, Peru | |||
2132190 | 2132190 | 2021-10-01 | Peru | Lima | 948038 | 88365 | 0 | -11.766533 | -76.60449799999998 | 2021-10-02 04:21:25 | Lima, Peru | |||
2773147 | 2773147 | 2021-09-30 | Peru | Lima | 948038 | 88365 | 0 | -11.766533 | -76.60449799999998 | 2021-10-01 04:21:35 | Lima, Peru | |||
706603 | 706603 | 2021-09-29 | Peru | Lima | 947099 | 88342 | 0 | -11.766533 | -76.60449799999998 | 2021-09-30 04:21:20 | Lima, Peru | |||
1334445 | 1334445 | 2021-09-28 | Peru | Lima | 947099 | 88342 | 0 | -11.766533 | -76.60449799999998 | 2021-09-29 04:21:45 | Lima, Peru | |||
1235814 | 1235814 | 2021-09-27 | Peru | Lima | 947099 | 88342 | 0 | -11.766533 | -76.60449799999998 | 2021-09-28 04:21:28 | Lima, Peru | |||
2076115 | 2076115 | 2021-09-26 | Peru | Lima | 946232 | 88314 | 0 | -11.766533 | -76.60449799999998 | 2021-09-27 04:21:16 | Lima, Peru | |||
1724667 | 1724667 | 2021-09-25 | Peru | Lima | 946232 | 88314 | 0 | -11.766533 | -76.60449799999998 | 2021-09-26 04:21:29 | Lima, Peru | |||
1921387 | 1921387 | 2021-09-24 | Peru | Lima | 945879 | 88314 | 0 | -11.766533 | -76.60449799999998 | 2021-09-25 04:21:31 | Lima, Peru | |||
601858 | 601858 | 2021-09-23 | Peru | Lima | 945364 | 88296 | 0 | -11.766533 | -76.60449799999998 | 2021-09-24 04:21:44 | Lima, Peru | |||
3011502 | 3011502 | 2021-09-22 | Peru | Lima | 944983 | 88278 | 0 | -11.766533 | -76.60449799999998 | 2021-09-23 04:21:43 | Lima, Peru | |||
3757640 | 3757640 | 2021-09-21 | Peru | Lima | 944983 | 88278 | 0 | -11.766533 | -76.60449799999998 | 2021-09-22 04:21:45 | Lima, Peru | |||
809743 | 809743 | 2021-09-20 | Peru | Lima | 944631 | 88281 | 0 | -11.766533 | -76.60449799999998 | 2021-09-21 04:21:26 | Lima, Peru | |||
1814942 | 1814942 | 2021-09-19 | Peru | Lima | 944293 | 88270 | 0 | -11.766533 | -76.60449799999998 | 2021-09-20 04:21:22 | Lima, Peru | |||
16522 | 16522 | 2021-09-18 | Peru | Lima | 943682 | 88246 | 0 | -11.766533 | -76.60449799999998 | 2021-09-19 04:21:34 | Lima, Peru | |||
2618207 | 2618207 | 2021-09-17 | Peru | Lima | 942383 | 88208 | 0 | -11.766533 | -76.60449799999998 | 2021-09-18 04:21:24 | Lima, Peru | |||
2808915 | 2808915 | 2021-09-16 | Peru | Lima | 942383 | 88208 | 0 | -11.766533 | -76.60449799999998 | 2021-09-17 04:21:46 | Lima, Peru | |||
1374660 | 1374660 | 2021-09-15 | Peru | Lima | 942383 | 88208 | 0 | -11.766533 | -76.60449799999998 | 2021-09-16 04:22:19 | Lima, Peru | |||
2462959 | 2462959 | 2021-09-14 | Peru | Lima | 941840 | 88177 | 0 | -11.766533 | -76.60449799999998 | 2021-09-15 03:22:37 | Lima, Peru | |||
1385798 | 1385798 | 2021-09-13 | Peru | Lima | 941840 | 88177 | 0 | -11.766533 | -76.60449799999998 | 2021-09-14 04:21:41 | Lima, Peru | |||
1885167 | 1885167 | 2021-09-12 | Peru | Lima | 941544 | 88172 | 0 | -11.766533 | -76.60449799999998 | 2021-09-13 04:21:15 | Lima, Peru | |||
3806070 | 3806070 | 2021-09-11 | Peru | Lima | 940843 | 88134 | 0 | -11.766533 | -76.60449799999998 | 2021-09-12 04:21:13 | Lima, Peru | |||
3449010 | 3449010 | 2021-09-10 | Peru | Lima | 940843 | 88134 | 0 | -11.766533 | -76.60449799999998 | 2021-09-11 04:21:30 | Lima, Peru | |||
1262956 | 1262956 | 2021-09-09 | Peru | Lima | 940843 | 88134 | 0 | -11.766533 | -76.60449799999998 | 2021-09-10 04:21:20 | Lima, Peru | |||
2279326 | 2279326 | 2021-09-08 | Peru | Lima | 940119 | 88116 | 0 | -11.766533 | -76.60449799999998 | 2021-09-09 04:21:27 | Lima, Peru | |||
642105 | 642105 | 2021-09-07 | Peru | Lima | 940119 | 88116 | 0 | -11.766533 | -76.60449799999998 | 2021-09-08 04:21:31 | Lima, Peru | |||
3194168 | 3194168 | 2021-09-06 | Peru | Lima | 939506 | 88097 | 0 | -11.766533 | -76.60449799999998 | 2021-09-07 04:21:35 | Lima, Peru | |||
3281036 | 3281036 | 2021-09-05 | Peru | Lima | 939506 | 88097 | 0 | -11.766533 | -76.60449799999998 | 2021-09-06 04:21:22 | Lima, Peru | |||
249450 | 249450 | 2021-09-04 | Peru | Lima | 938781 | 88069 | 0 | -11.766533 | -76.60449799999998 | 2021-09-05 04:21:33 | Lima, Peru | |||
3974731 | 3974731 | 2021-09-03 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-09-04 04:21:28 | Lima, Peru | |||
178193 | 178193 | 2021-09-02 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-09-03 04:21:20 | Lima, Peru | |||
67228 | 67228 | 2021-09-01 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-09-02 04:21:15 | Lima, Peru | |||
2068070 | 2068070 | 2021-08-31 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-09-01 04:21:38 | Lima, Peru | |||
1775524 | 1775524 | 2021-08-30 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-31 04:21:46 | Lima, Peru | |||
3892098 | 3892098 | 2021-08-29 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-30 04:21:23 | Lima, Peru | |||
2793201 | 2793201 | 2021-08-28 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-29 04:21:14 | Lima, Peru | |||
2923360 | 2923360 | 2021-08-27 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-28 04:21:28 | Lima, Peru | |||
1596374 | 1596374 | 2021-08-26 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-27 04:21:37 | Lima, Peru | |||
32583 | 32583 | 2021-08-25 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-26 04:21:28 | Lima, Peru | |||
3105622 | 3105622 | 2021-08-24 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-25 04:21:41 | Lima, Peru | |||
3165793 | 3165793 | 2021-08-23 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-24 04:21:19 | Lima, Peru | |||
2175720 | 2175720 | 2021-08-22 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-23 04:21:27 | Lima, Peru | |||
3555816 | 3555816 | 2021-08-21 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-22 04:21:29 | Lima, Peru | |||
1854158 | 1854158 | 2021-08-20 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-21 04:21:38 | Lima, Peru | |||
511865 | 511865 | 2021-08-19 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-20 04:21:33 | Lima, Peru | |||
2518344 | 2518344 | 2021-08-18 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-19 04:21:15 | Lima, Peru | |||
245436 | 245436 | 2021-08-17 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-18 04:21:35 | Lima, Peru | |||
1604399 | 1604399 | 2021-08-16 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-17 04:21:49 | Lima, Peru | |||
103493 | 103493 | 2021-08-15 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-16 04:21:31 | Lima, Peru | |||
507851 | 507851 | 2021-08-14 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-15 04:21:41 | Lima, Peru | |||
1483723 | 1483723 | 2021-08-13 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-14 04:21:25 | Lima, Peru | |||
2899853 | 2899853 | 2021-08-12 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-13 04:21:24 | Lima, Peru | |||
1342457 | 1342457 | 2021-08-11 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-12 04:21:25 | Lima, Peru | |||
2351604 | 2351604 | 2021-08-10 | Peru | Lima | 928624 | 87606 | 0 | -11.766533 | -76.60449799999998 | 2021-08-11 04:21:58 | Lima, Peru | |||
650133 | 650133 | 2021-08-09 | Peru | Lima | 926866 | 87526 | 0 | -11.766533 | -76.60449799999998 | 2021-08-10 04:21:27 | Lima, Peru | |||
589795 | 589795 | 2021-08-08 | Peru | Lima | 926866 | 87526 | 0 | -11.766533 | -76.60449799999998 | 2021-08-09 04:21:24 | Lima, Peru | |||
2203807 | 2203807 | 2021-08-07 | Peru | Lima | 926866 | 87526 | 0 | -11.766533 | -76.60449799999998 | 2021-08-08 04:21:33 | Lima, Peru | |||
1117757 | 1117757 | 2021-08-06 | Peru | Lima | 926866 | 87526 | 0 | -11.766533 | -76.60449799999998 | 2021-08-07 04:21:30 | Lima, Peru | |||
1956694 | 1956694 | 2021-08-05 | Peru | Lima | 925649 | 87475 | 0 | -11.766533 | -76.60449799999998 | 2021-08-06 04:21:18 | Lima, Peru | |||
332073 | 332073 | 2021-08-04 | Peru | Lima | 925649 | 87475 | 0 | 838174 | -11.766533 | -76.60449799999998 | 2021-08-05 04:21:51 | Lima, Peru | ||
3468344 | 3468344 | 2021-08-03 | Peru | Lima | 925015 | 87444 | 0 | 837571 | -11.766533 | -76.60449799999998 | 2021-08-04 04:21:25 | Lima, Peru | ||
3683618 | 3683618 | 2021-08-02 | Peru | Lima | 923458 | 87380 | 0 | 836078 | -11.766533 | -76.60449799999998 | 2021-08-03 04:21:39 | Lima, Peru | ||
3015517 | 3015517 | 2021-08-01 | Peru | Lima | 923458 | 87380 | 0 | 836078 | -11.766533 | -76.60449799999998 | 2021-08-02 04:21:36 | Lima, Peru | ||
3904140 | 3904140 | 2021-07-31 | Peru | Lima | 923458 | 87380 | 0 | 836078 | -11.766533 | -76.60449799999998 | 2021-08-01 04:21:50 | Lima, Peru | ||
3296345 | 3296345 | 2021-07-30 | Peru | Lima | 923458 | 87380 | 0 | 836078 | -11.766533 | -76.60449799999998 | 2021-07-31 04:21:35 | Lima, Peru | ||
3385556 | 3385556 | 2021-07-29 | Peru | Lima | 923276 | 87343 | 0 | 835933 | -11.766533 | -76.60449799999998 | 2021-07-30 04:21:34 | Lima, Peru | ||
408461 | 408461 | 2021-07-28 | Peru | Lima | 923276 | 87343 | 0 | 835933 | -11.766533 | -76.60449799999998 | 2021-07-29 04:21:33 | Lima, Peru | ||
1306322 | 1306322 | 2021-07-27 | Peru | Lima | 922257 | 87259 | 0 | 834998 | -11.766533 | -76.60449799999998 | 2021-07-28 04:21:39 | Lima, Peru | ||
3218465 | 3218465 | 2021-07-26 | Peru | Lima | 922257 | 87259 | 0 | 834998 | -11.766533 | -76.60449799999998 | 2021-07-27 04:21:18 | Lima, Peru | ||
1378674 | 1378674 | 2021-07-25 | Peru | Lima | 919435 | 87128 | 0 | 832307 | -11.766533 | -76.60449799999998 | 2021-07-26 04:21:28 | Lima, Peru | ||
1330414 | 1330414 | 2021-07-24 | Peru | Lima | 919435 | 87128 | 0 | 832307 | -11.766533 | -76.60449799999998 | 2021-07-25 04:22:12 | Lima, Peru | ||
3137718 | 3137718 | 2021-07-23 | Peru | Lima | 919435 | 87128 | 0 | 832307 | -11.766533 | -76.60449799999998 | 2021-07-24 00:21:36 | Lima, Peru | ||
3476478 | 3476478 | 2021-07-22 | Peru | Lima | 919435 | 87128 | 0 | 832307 | -11.766533 | -76.60449799999998 | 2021-07-23 04:21:29 | Lima, Peru | ||
3331697 | 3331697 | 2021-07-21 | Peru | Lima | 919228 | 87090 | 0 | 832138 | -11.766533 | -76.60449799999998 | 2021-07-22 04:21:19 | Lima, Peru | ||
2371678 | 2371678 | 2021-07-20 | Peru | Lima | 919228 | 87090 | 0 | 832138 | -11.766533 | -76.60449799999998 | 2021-07-21 04:21:40 | Lima, Peru | ||
483757 | 483757 | 2021-07-19 | Peru | Lima | 919228 | 87090 | 0 | 832138 | -11.766533 | -76.60449799999998 | 2021-07-20 04:21:48 | Lima, Peru | ||
2673980 | 2673980 | 2021-07-18 | Peru | Lima | 918784 | 87062 | 0 | 831722 | -11.766533 | -76.60449799999998 | 2021-07-19 04:21:24 | Lima, Peru | ||
3706292 | 3706292 | 2021-07-17 | Peru | Lima | 917806 | 87038 | 0 | 830768 | -11.766533 | -76.60449799999998 | 2021-07-18 04:22:07 | Lima, Peru | ||
2947523 | 2947523 | 2021-07-16 | Peru | Lima | 917806 | 87038 | 0 | 830768 | -11.766533 | -76.60449799999998 | 2021-07-17 04:22:22 | Lima, Peru | ||
296179 | 296179 | 2021-07-15 | Peru | Lima | 917121 | 87014 | 0 | 830107 | -11.766533 | -76.60449799999998 | 2021-07-16 04:21:22 | Lima, Peru | ||
3632124 | 3632124 | 2021-07-14 | Peru | Lima | 917121 | 87014 | 0 | 830107 | -11.766533 | -76.60449799999998 | 2021-07-15 04:21:48 | Lima, Peru | ||
578999 | 578999 | 2021-07-13 | Peru | Lima | 915866 | 86943 | 0 | 828923 | -11.766533 | -76.60449799999998 | 2021-07-14 04:21:35 | Lima, 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]);