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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
498 | 498 | 2021-12-02 | Peru | Lima | 977690 | 88865 | 0 | -11.766533 | -76.60449799999998 | 2021-12-03 04:23:05 | Lima, Peru | |||
4514 | 4514 | 2021-10-28 | Peru | Lima | 958685 | 88693 | 0 | -11.766533 | -76.60449799999998 | 2021-10-29 04:22:03 | Lima, Peru | |||
16522 | 16522 | 2021-09-18 | Peru | Lima | 943682 | 88246 | 0 | -11.766533 | -76.60449799999998 | 2021-09-19 04:21:34 | Lima, Peru | |||
24569 | 24569 | 2022-03-20 | Peru | Lima | 1601185 | 92695 | 0 | -11.766533 | -76.60449799999998 | 2022-03-21 04:20:50 | Lima, Peru | |||
28584 | 28584 | 2021-11-11 | Peru | Lima | 963492 | 88811 | 0 | -11.766533 | -76.60449799999998 | 2021-11-12 04:22:01 | Lima, Peru | |||
32583 | 32583 | 2021-08-25 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-08-26 04:21:28 | Lima, Peru | |||
43876 | 43876 | 2021-11-02 | Peru | Lima | 961121 | 88746 | 0 | -11.766533 | -76.60449799999998 | 2021-11-03 06:22:09 | Lima, Peru | |||
63233 | 63233 | 2022-11-12 | Peru | Lima | 1924404 | 94891 | 0 | -11.766533 | -76.604498 | 2022-11-13 04:21:14 | Lima, Peru | |||
67228 | 67228 | 2021-09-01 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-09-02 04:21:15 | Lima, Peru | |||
71259 | 71259 | 2022-02-07 | Peru | Lima | 1520242 | 91261 | 0 | -11.766533 | -76.60449799999998 | 2022-02-08 04:21:15 | Lima, Peru | |||
87293 | 87293 | 2021-11-09 | Peru | Lima | 963492 | 88811 | 0 | -11.766533 | -76.60449799999998 | 2021-11-10 04:21:38 | Lima, Peru | |||
91311 | 91311 | 2022-07-23 | Peru | Lima | 1715410 | 93586 | 0 | -11.766533 | -76.604498 | 2022-07-24 04:20:47 | Lima, Peru | |||
99494 | 99494 | 2022-01-14 | Peru | Lima | 1032720 | 89553 | 0 | -11.766533 | -76.60449799999998 | 2022-01-15 04:21:07 | Lima, Peru | |||
103493 | 103493 | 2021-08-15 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-16 04:21:31 | Lima, Peru | |||
114921 | 114921 | 2022-09-06 | Peru | Lima | 1898026 | 94331 | 0 | -11.766533 | -76.604498 | 2022-09-07 04:20:59 | Lima, Peru | |||
126901 | 126901 | 2022-01-09 | Peru | Lima | 1032720 | 89553 | 0 | -11.766533 | -76.60449799999998 | 2022-01-10 04:22:07 | Lima, Peru | |||
130921 | 130921 | 2022-10-04 | Peru | Lima | 1914338 | 94650 | 0 | -11.766533 | -76.604498 | 2022-10-05 04:23:06 | Lima, Peru | |||
138139 | 138139 | 2021-12-04 | Peru | Lima | 977690 | 88865 | 0 | -11.766533 | -76.60449799999998 | 2021-12-05 04:22:25 | Lima, Peru | |||
142157 | 142157 | 2022-07-09 | Peru | Lima | 1660472 | 93466 | 0 | -11.766533 | -76.604498 | 2022-07-10 04:20:54 | Lima, Peru | |||
150152 | 150152 | 2021-11-29 | Peru | Lima | 977690 | 88865 | 0 | -11.766533 | -76.60449799999998 | 2021-11-30 04:22:53 | Lima, Peru | |||
158181 | 158181 | 2022-03-29 | Peru | Lima | 1604357 | 92858 | 0 | -11.766533 | -76.60449799999998 | 2022-03-30 04:20:45 | Lima, Peru | |||
162196 | 162196 | 2021-11-19 | Peru | Lima | 968075 | 88905 | 0 | -11.766533 | -76.60449799999998 | 2021-11-20 04:22:17 | Lima, Peru | |||
166214 | 166214 | 2022-06-21 | Peru | Lima | 1639796 | 93408 | 0 | -11.766533 | -76.604498 | 2022-06-22 04:20:54 | Lima, Peru | |||
178193 | 178193 | 2021-09-02 | Peru | Lima | 934664 | 87891 | 0 | -11.766533 | -76.60449799999998 | 2021-09-03 04:21:20 | Lima, Peru | |||
186239 | 186239 | 2022-02-13 | Peru | Lima | 1520242 | 91261 | 0 | -11.766533 | -76.60449799999998 | 2022-02-14 04:20:51 | Lima, Peru | |||
198430 | 198430 | 2022-10-19 | Peru | Lima | 1916219 | 94708 | 0 | -11.766533 | -76.604498 | 2022-10-20 04:22:59 | Lima, Peru | |||
218151 | 218151 | 2022-12-26 | Peru | Lima | 2092563 | 96211 | 0 | -11.766533 | -76.604498 | 2022-12-27 04:21:07 | Lima, Peru | |||
222164 | 222164 | 2022-05-09 | Peru | Lima | 1617674 | 93149 | 0 | -11.766533 | -76.604498 | 2022-05-10 04:20:50 | Lima, Peru | |||
229396 | 229396 | 2022-05-31 | Peru | Lima | 1624970 | 93296 | 0 | -11.766533 | -76.604498 | 2022-06-01 04:20:55 | Lima, Peru | |||
233411 | 233411 | 2022-02-11 | Peru | Lima | 1520242 | 91261 | 0 | -11.766533 | -76.60449799999998 | 2022-02-12 04:21:06 | Lima, Peru | |||
245436 | 245436 | 2021-08-17 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-18 04:21:35 | Lima, Peru | |||
249450 | 249450 | 2021-09-04 | Peru | Lima | 938781 | 88069 | 0 | -11.766533 | -76.60449799999998 | 2021-09-05 04:21:33 | Lima, Peru | |||
253483 | 253483 | 2022-09-08 | Peru | Lima | 1898026 | 94331 | 0 | -11.766533 | -76.604498 | 2022-09-09 04:21:11 | Lima, Peru | |||
257501 | 257501 | 2022-12-10 | Peru | Lima | 2023023 | 95926 | 0 | -11.766533 | -76.604498 | 2022-12-11 04:20:50 | Lima, Peru | |||
261701 | 261701 | 2022-03-15 | Peru | Lima | 1601185 | 92695 | 0 | -11.766533 | -76.60449799999998 | 2022-03-16 04:20:50 | Lima, Peru | |||
276351 | 276351 | 2021-11-03 | Peru | Lima | 961121 | 88746 | 0 | -11.766533 | -76.60449799999998 | 2021-11-04 04:22:20 | Lima, Peru | |||
288164 | 288164 | 2021-10-31 | Peru | Lima | 958685 | 88693 | 0 | -11.766533 | -76.60449799999998 | 2021-11-01 04:22:01 | Lima, Peru | |||
292184 | 292184 | 2022-11-15 | Peru | Lima | 1932091 | 95062 | 0 | -11.766533 | -76.604498 | 2022-11-16 04:21:09 | Lima, Peru | |||
304037 | 304037 | 2022-04-16 | Peru | Lima | 1607124 | 92992 | 0 | -11.766533 | -76.60449799999998 | 2022-04-17 04:20:59 | Lima, Peru | |||
308056 | 308056 | 2022-12-13 | Peru | Lima | 2023023 | 95926 | 0 | -11.766533 | -76.604498 | 2022-12-14 04:21:04 | Lima, Peru | |||
312072 | 312072 | 2022-11-13 | Peru | Lima | 1924404 | 94891 | 0 | -11.766533 | -76.604498 | 2022-11-14 04:21:09 | Lima, Peru | |||
316085 | 316085 | 2022-02-12 | Peru | Lima | 1520242 | 91261 | 0 | -11.766533 | -76.60449799999998 | 2022-02-13 04:21:00 | Lima, Peru | |||
320104 | 320104 | 2022-10-30 | Peru | Lima | 1918510 | 94758 | 0 | -11.766533 | -76.604498 | 2022-10-31 04:21:36 | Lima, Peru | |||
328078 | 328078 | 2022-12-27 | Peru | Lima | 2092563 | 96211 | 0 | -11.766533 | -76.604498 | 2022-12-28 04:21:04 | Lima, Peru | |||
336105 | 336105 | 2022-03-18 | Peru | Lima | 1601185 | 92695 | 0 | -11.766533 | -76.60449799999998 | 2022-03-19 04:20:47 | Lima, Peru | |||
348468 | 348468 | 2022-12-14 | Peru | Lima | 2060576 | 96031 | 0 | -11.766533 | -76.604498 | 2022-12-15 04:20:58 | Lima, Peru | |||
356495 | 356495 | 2022-03-11 | Peru | Lima | 1594692 | 92474 | 0 | -11.766533 | -76.60449799999998 | 2022-03-12 04:20:50 | Lima, Peru | |||
360511 | 360511 | 2022-05-07 | Peru | Lima | 1615817 | 93122 | 0 | -11.766533 | -76.604498 | 2022-05-08 04:20:49 | Lima, Peru | |||
372368 | 372368 | 2022-09-13 | Peru | Lima | 1903802 | 94447 | 0 | -11.766533 | -76.604498 | 2022-09-14 04:20:44 | Lima, Peru | |||
384395 | 384395 | 2022-09-23 | Peru | Lima | 1907438 | 94523 | 0 | -11.766533 | -76.604498 | 2022-09-24 04:21:40 | Lima, Peru | |||
396436 | 396436 | 2022-10-07 | Peru | Lima | 1914338 | 94650 | 0 | -11.766533 | -76.604498 | 2022-10-08 04:22:56 | Lima, Peru | |||
404462 | 404462 | 2021-12-07 | Peru | Lima | 982487 | 88960 | 0 | -11.766533 | -76.60449799999998 | 2021-12-08 04:22:46 | Lima, Peru | |||
419507 | 419507 | 2022-09-18 | Peru | Lima | 1903802 | 94447 | 0 | -11.766533 | -76.604498 | 2022-09-19 04:21:49 | Lima, Peru | |||
423519 | 423519 | 2021-10-10 | Peru | Lima | 952334 | 88515 | 0 | -11.766533 | -76.60449799999998 | 2021-10-11 04:21:31 | Lima, Peru | |||
431529 | 431529 | 2022-11-03 | Peru | Lima | 1920890 | 94848 | 0 | -11.766533 | -76.604498 | 2022-11-04 04:22:11 | Lima, Peru | |||
443523 | 443523 | 2021-10-20 | Peru | Lima | 955774 | 88616 | 0 | -11.766533 | -76.60449799999998 | 2021-10-21 04:21:18 | Lima, Peru | |||
447539 | 447539 | 2021-11-17 | Peru | Lima | 968075 | 88905 | 0 | -11.766533 | -76.60449799999998 | 2021-11-18 04:21:33 | Lima, Peru | |||
451559 | 451559 | 2022-12-21 | Peru | Lima | 2060576 | 96031 | 0 | -11.766533 | -76.604498 | 2022-12-22 04:20:56 | Lima, Peru | |||
459548 | 459548 | 2022-02-02 | Peru | Lima | 1295823 | 90230 | 0 | -11.766533 | -76.60449799999998 | 2022-02-03 04:21:21 | Lima, Peru | |||
463565 | 463565 | 2022-05-02 | Peru | Lima | 1612542 | 93076 | 0 | -11.766533 | -76.604498 | 2022-05-03 04:21:00 | Lima, Peru | |||
467580 | 467580 | 2021-10-07 | Peru | Lima | 950856 | 88454 | 0 | -11.766533 | -76.60449799999998 | 2021-10-08 04:21:25 | Lima, Peru | |||
475612 | 475612 | 2022-06-26 | Peru | Lima | 1639796 | 93408 | 0 | -11.766533 | -76.604498 | 2022-06-27 04:21:00 | Lima, Peru | |||
479762 | 479762 | 2022-11-08 | Peru | Lima | 1924404 | 94891 | 0 | -11.766533 | -76.604498 | 2022-11-09 04:21:22 | Lima, Peru | |||
487792 | 487792 | 2022-11-25 | Peru | Lima | 1946120 | 95103 | 0 | -11.766533 | -76.604498 | 2022-11-26 04:21:11 | Lima, Peru | |||
491804 | 491804 | 2021-10-14 | Peru | Lima | 952925 | 88544 | 0 | -11.766533 | -76.60449799999998 | 2021-10-15 04:21:26 | Lima, Peru | |||
495820 | 495820 | 2021-11-06 | Peru | Lima | 962132 | 88779 | 0 | -11.766533 | -76.60449799999998 | 2021-11-07 04:21:53 | Lima, Peru | |||
499837 | 499837 | 2022-04-02 | Peru | Lima | 1604357 | 92858 | 0 | -11.766533 | -76.60449799999998 | 2022-04-03 04:20:48 | Lima, Peru | |||
503856 | 503856 | 2022-12-17 | Peru | Lima | 2060576 | 96031 | 0 | -11.766533 | -76.604498 | 2022-12-18 04:21:03 | Lima, Peru | |||
507851 | 507851 | 2021-08-14 | Peru | Lima | 929028 | 87629 | 0 | -11.766533 | -76.60449799999998 | 2021-08-15 04:21:41 | Lima, Peru | |||
511865 | 511865 | 2021-08-19 | Peru | Lima | 931451 | 87745 | 0 | -11.766533 | -76.60449799999998 | 2021-08-20 04:21:33 | Lima, Peru | |||
515900 | 515900 | 2022-10-15 | Peru | Lima | 1916219 | 94708 | 0 | -11.766533 | -76.604498 | 2022-10-16 04:22:39 | Lima, Peru | |||
534904 | 534904 | 2021-10-27 | Peru | Lima | 958685 | 88693 | 0 | -11.766533 | -76.60449799999998 | 2021-10-28 04:22:08 | Lima, Peru | |||
538924 | 538924 | 2022-10-26 | Peru | Lima | 1918510 | 94758 | 0 | -11.766533 | -76.604498 | 2022-10-27 04:22:01 | Lima, Peru | |||
542940 | 542940 | 2022-12-15 | Peru | Lima | 2060576 | 96031 | 0 | -11.766533 | -76.604498 | 2022-12-16 04:21:01 | Lima, Peru | |||
550942 | 550942 | 2021-12-08 | Peru | Lima | 982487 | 88960 | 0 | -11.766533 | -76.60449799999998 | 2021-12-09 04:22:49 | Lima, Peru | |||
554958 | 554958 | 2022-01-16 | Peru | Lima | 1132690 | 89734 | 0 | -11.766533 | -76.60449799999998 | 2022-01-17 04:21:08 | Lima, Peru | |||
558976 | 558976 | 2022-06-16 | Peru | Lima | 1632737 | 93376 | 0 | -11.766533 | -76.604498 | 2022-06-17 04:20:56 | Lima, Peru | |||
567272 | 567272 | 2021-10-29 | Peru | Lima | 958685 | 88693 | 0 | -11.766533 | -76.60449799999998 | 2021-10-30 04:22:03 | Lima, Peru | |||
575001 | 575001 | 2022-02-25 | Peru | Lima | 1582977 | 91987 | 0 | -11.766533 | -76.60449799999998 | 2022-02-26 04:21:12 | Lima, Peru | |||
589795 | 589795 | 2021-08-08 | Peru | Lima | 926866 | 87526 | 0 | -11.766533 | -76.60449799999998 | 2021-08-09 04:21:24 | Lima, Peru | |||
593828 | 593828 | 2022-07-01 | Peru | Lima | 1650146 | 93445 | 0 | -11.766533 | -76.604498 | 2022-07-02 04:21:16 | Lima, Peru | |||
597842 | 597842 | 2021-10-19 | Peru | Lima | 954749 | 88576 | 0 | -11.766533 | -76.60449799999998 | 2021-10-20 04:21:00 | Lima, Peru | |||
601858 | 601858 | 2021-09-23 | Peru | Lima | 945364 | 88296 | 0 | -11.766533 | -76.60449799999998 | 2021-09-24 04:21:44 | Lima, Peru | |||
618034 | 618034 | 2022-11-05 | Peru | Lima | 1920890 | 94848 | 0 | -11.766533 | -76.604498 | 2022-11-06 04:21:24 | Lima, Peru | |||
622048 | 622048 | 2022-05-22 | Peru | Lima | 1619813 | 93240 | 0 | -11.766533 | -76.604498 | 2022-05-26 04:20:50 | Lima, Peru | |||
630078 | 630078 | 2022-07-12 | Peru | Lima | 1680459 | 93527 | 0 | -11.766533 | -76.604498 | 2022-07-13 04:20:58 | Lima, Peru | |||
634092 | 634092 | 2021-10-13 | Peru | Lima | 952925 | 88544 | 0 | -11.766533 | -76.60449799999998 | 2021-10-14 04:21:29 | Lima, Peru | |||
642105 | 642105 | 2021-09-07 | Peru | Lima | 940119 | 88116 | 0 | -11.766533 | -76.60449799999998 | 2021-09-08 04:21:31 | Lima, Peru | |||
650133 | 650133 | 2021-08-09 | Peru | Lima | 926866 | 87526 | 0 | -11.766533 | -76.60449799999998 | 2021-08-10 04:21:27 | Lima, Peru | |||
654164 | 654164 | 2021-10-22 | Peru | Lima | 955774 | 88616 | 0 | -11.766533 | -76.60449799999998 | 2021-10-23 04:21:32 | Lima, Peru | |||
658483 | 658483 | 2022-05-13 | Peru | Lima | 1617674 | 93149 | 0 | -11.766533 | -76.604498 | 2022-05-14 04:20:48 | Lima, Peru | |||
670469 | 670469 | 2022-07-21 | Peru | Lima | 1715410 | 93586 | 0 | -11.766533 | -76.604498 | 2022-07-22 04:21:15 | Lima, Peru | |||
674485 | 674485 | 2022-07-30 | Peru | Lima | 1757424 | 93655 | 0 | -11.766533 | -76.604498 | 2022-07-31 04:21:02 | Lima, Peru | |||
682509 | 682509 | 2021-10-24 | Peru | Lima | 957296 | 88648 | 0 | -11.766533 | -76.60449799999998 | 2021-10-25 04:22:31 | Lima, Peru | |||
686525 | 686525 | 2021-11-13 | Peru | Lima | 965314 | 88858 | 0 | -11.766533 | -76.60449799999998 | 2021-11-14 04:21:31 | Lima, Peru | |||
690545 | 690545 | 2022-12-23 | Peru | Lima | 2060576 | 96031 | 0 | -11.766533 | -76.604498 | 2022-12-24 04:21:02 | Lima, Peru | |||
694558 | 694558 | 2022-03-17 | Peru | Lima | 1601185 | 92695 | 0 | -11.766533 | -76.60449799999998 | 2022-03-18 04:20:55 | Lima, Peru | |||
698573 | 698573 | 2021-11-04 | Peru | Lima | 962132 | 88779 | 0 | -11.766533 | -76.60449799999998 | 2021-11-05 04:21:54 | Lima, Peru | |||
706603 | 706603 | 2021-09-29 | Peru | Lima | 947099 | 88342 | 0 | -11.766533 | -76.60449799999998 | 2021-09-30 04:21:20 | Lima, Peru | |||
710622 | 710622 | 2022-11-01 | Peru | Lima | 1920890 | 94848 | 0 | -11.766533 | -76.604498 | 2022-11-02 04:22:09 | 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]);