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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3741248 | 3741248 | 2021-07-12 | Peru | Lima | 915866 | 86943 | 0 | 828923 | -11.766533 | -76.60449799999998 | 2021-07-13 04:21:18 | Lima, Peru | ||
3659761 | 3659761 | 2021-07-11 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-12 04:21:34 | Lima, Peru | ||
626045 | 626045 | 2021-07-10 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-11 04:21:43 | Lima, Peru | ||
829764 | 829764 | 2021-07-09 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-10 04:21:25 | Lima, Peru | ||
778528 | 778528 | 2021-07-08 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-09 04:21:21 | Lima, Peru | ||
1440750 | 1440750 | 2021-07-07 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-08 04:21:26 | Lima, Peru | ||
2693855 | 2693855 | 2021-07-06 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-07 04:21:20 | Lima, Peru | ||
1932604 | 1932604 | 2021-07-05 | Peru | Lima | 911402 | 86605 | 0 | 824797 | -11.766533 | -76.60449799999998 | 2021-07-06 04:21:32 | Lima, Peru | ||
1165335 | 1165335 | 2021-07-04 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-07-05 04:21:28 | Lima, Peru | ||
1495769 | 1495769 | 2021-07-03 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-07-04 04:21:38 | Lima, Peru | ||
2072084 | 2072084 | 2021-07-02 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-07-03 04:21:37 | Lima, Peru | ||
2765100 | 2765100 | 2021-07-01 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-07-02 04:21:47 | Lima, Peru | ||
1893308 | 1893308 | 2021-06-30 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-07-01 04:21:19 | Lima, Peru | ||
400431 | 400431 | 2021-06-29 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-30 04:21:41 | Lima, Peru | ||
3125674 | 3125674 | 2021-06-28 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-29 04:21:28 | Lima, Peru | ||
2590169 | 2590169 | 2021-06-27 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-28 04:21:29 | Lima, Peru | ||
3958673 | 3958673 | 2021-06-26 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-27 04:21:39 | Lima, Peru | ||
1712492 | 1712492 | 2021-06-25 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-26 04:21:43 | Lima, Peru | ||
2295617 | 2295617 | 2021-06-24 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-25 04:21:33 | Lima, Peru | ||
2423057 | 2423057 | 2021-06-23 | Peru | Lima | 903371 | 85995 | 0 | 817376 | -11.766533 | -76.60449799999998 | 2021-06-24 04:21:55 | Lima, Peru | ||
563134 | 563134 | 2021-06-22 | Peru | Lima | 899569 | 85692 | 0 | 813877 | -11.766533 | -76.60449799999998 | 2021-06-23 04:21:46 | Lima, Peru | ||
3358836 | 3358836 | 2021-06-21 | Peru | Lima | 899569 | 85692 | 0 | 813877 | -11.766533 | -76.60449799999998 | 2021-06-22 04:21:34 | Lima, Peru | ||
2884535 | 2884535 | 2021-06-20 | Peru | Lima | 899569 | 85692 | 0 | 813877 | -11.766533 | -76.60449799999998 | 2021-06-21 04:21:41 | Lima, Peru | ||
107618 | 107618 | 2021-06-19 | Peru | Lima | 899569 | 85692 | 0 | 813877 | -11.766533 | -76.60449799999998 | 2021-06-20 04:21:48 | Lima, Peru | ||
1125761 | 1125761 | 2021-06-18 | Peru | Lima | 899569 | 85692 | 0 | 813877 | -11.766533 | -76.60449799999998 | 2021-06-19 04:22:33 | Lima, Peru | ||
2911339 | 2911339 | 2021-06-17 | Peru | Lima | 899569 | 85692 | 0 | 813877 | -11.766533 | -76.60449799999998 | 2021-06-18 04:22:16 | Lima, Peru | ||
3030455 | 3030455 | 2021-06-16 | Peru | Lima | 893816 | 85421 | 0 | 808395 | -11.766533 | -76.60449799999998 | 2021-06-17 04:22:36 | Lima, Peru | ||
2339561 | 2339561 | 2021-06-15 | Peru | Lima | 893816 | 85421 | 0 | 808395 | -11.766533 | -76.60449799999998 | 2021-06-16 04:22:32 | Lima, Peru | ||
1564257 | 1564257 | 2021-06-14 | Peru | Lima | 893816 | 85421 | 0 | 808395 | -11.766533 | -76.60449799999998 | 2021-06-15 04:22:22 | Lima, Peru | ||
3381540 | 3381540 | 2021-06-13 | Peru | Lima | 892420 | 85263 | 0 | 807157 | -11.766533 | -76.60449799999998 | 2021-06-14 04:22:46 | Lima, Peru | ||
1736674 | 1736674 | 2021-06-12 | Peru | Lima | 892420 | 85263 | 0 | 807157 | -11.766533 | -76.60449799999998 | 2021-06-13 04:22:44 | Lima, Peru | ||
3970715 | 3970715 | 2021-06-11 | Peru | Lima | 891716 | 85186 | 0 | 806530 | -11.766533 | -76.60449799999998 | 2021-06-12 04:22:22 | Lima, Peru | ||
2717137 | 2717137 | 2021-06-10 | Peru | Lima | 890539 | 85079 | 0 | 805460 | -11.766533 | -76.60449799999998 | 2021-06-11 04:23:20 | Lima, Peru | ||
523022 | 523022 | 2021-06-09 | Peru | Lima | 889711 | 84996 | 0 | 804715 | -11.766533 | -76.60449799999998 | 2021-06-10 04:23:17 | Lima, Peru | ||
3472462 | 3472462 | 2021-06-08 | Peru | Lima | 888325 | 84811 | 0 | 803514 | -11.766533 | -76.60449799999998 | 2021-06-09 04:23:31 | Lima, Peru | ||
3145746 | 3145746 | 2021-06-07 | Peru | Lima | 888325 | 84811 | 0 | 803514 | -11.766533 | -76.60449799999998 | 2021-06-08 04:22: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]);