johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Ancash" sorted by longitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
567259 | 567259 | 2021-10-29 | Peru | Ancash | 77754 | 6670 | 0 | -9.407125 | -77.67179499999997 | 2021-10-30 04:22:03 | Ancash, Peru | |||
573845 | 573845 | 2020-06-06 | Peru | Ancash | 5290 | 736 | 0 | 4554 | -9.407125 | -77.67179499999997 | 2020-06-07 03:53:30 | Ancash, Peru | ||
574988 | 574988 | 2022-02-25 | Peru | Ancash | 122948 | 7006 | 0 | -9.407125 | -77.67179499999997 | 2022-02-26 04:21:12 | Ancash, Peru | |||
578986 | 578986 | 2021-07-13 | Peru | Ancash | 73801 | 6490 | 0 | 67311 | -9.407125 | -77.67179499999997 | 2021-07-14 04:21:35 | Ancash, Peru | ||
582979 | 582979 | 2020-08-13 | Peru | Ancash | 14473 | 2022 | 0 | 12451 | -9.407125 | -77.67179499999997 | 2020-08-14 04:51:19 | Ancash, Peru | ||
589782 | 589782 | 2021-08-08 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-09 04:21:24 | Ancash, Peru | |||
597829 | 597829 | 2021-10-19 | Peru | Ancash | 77497 | 6660 | 0 | -9.407125 | -77.67179499999997 | 2021-10-20 04:21:00 | Ancash, Peru | |||
601845 | 601845 | 2021-09-23 | Peru | Ancash | 76639 | 6629 | 0 | -9.407125 | -77.67179499999997 | 2021-09-24 04:21:44 | Ancash, Peru | |||
605840 | 605840 | 2021-04-09 | Peru | Ancash | 54607 | 4563 | 0 | 50044 | -9.407125 | -77.67179499999997 | 2021-04-10 04:20:59 | Ancash, Peru | ||
609836 | 609836 | 2020-08-29 | Peru | Ancash | 17846 | 2247 | 0 | 15599 | -9.407125 | -77.67179499999997 | 2020-08-30 04:28:22 | Ancash, Peru | ||
613839 | 613839 | 2021-02-08 | Peru | Ancash | 38868 | 3396 | 0 | 35472 | -9.407125 | -77.67179499999997 | 2021-02-09 05:23:30 | Ancash, Peru | ||
626032 | 626032 | 2021-07-10 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-11 04:21:43 | Ancash, Peru | ||
634079 | 634079 | 2021-10-13 | Peru | Ancash | 77358 | 6657 | 0 | -9.407125 | -77.67179499999997 | 2021-10-14 04:21:29 | Ancash, Peru | |||
638075 | 638075 | 2021-03-31 | Peru | Ancash | 50871 | 4301 | 0 | 46570 | -9.407125 | -77.67179499999997 | 2021-04-01 04:27:05 | Ancash, Peru | ||
642092 | 642092 | 2021-09-07 | Peru | Ancash | 76120 | 6615 | 0 | -9.407125 | -77.67179499999997 | 2021-09-08 04:21:31 | Ancash, Peru | |||
646103 | 646103 | 2021-05-05 | Peru | Ancash | 63613 | 5540 | 0 | 58073 | -9.407125 | -77.67179499999997 | 2021-05-06 04:20:38 | Ancash, Peru | ||
650120 | 650120 | 2021-08-09 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-10 04:21:27 | Ancash, Peru | |||
654151 | 654151 | 2021-10-22 | Peru | Ancash | 77576 | 6665 | 0 | -9.407125 | -77.67179499999997 | 2021-10-23 04:21:32 | Ancash, Peru | |||
662447 | 662447 | 2020-08-11 | Peru | Ancash | 14230 | 1997 | 0 | 12233 | -9.407125 | -77.67179499999997 | 2020-08-12 04:27:29 | Ancash, Peru | ||
678462 | 678462 | 2020-11-23 | Peru | Ancash | 28243 | 2725 | 0 | 25518 | -9.407125 | -77.67179499999997 | 2020-11-24 05:27:31 | Ancash, Peru | ||
682496 | 682496 | 2021-10-24 | Peru | Ancash | 77660 | 6667 | 0 | -9.407125 | -77.67179499999997 | 2021-10-25 04:22:31 | Ancash, Peru | |||
686512 | 686512 | 2021-11-13 | Peru | Ancash | 78218 | 6687 | 0 | -9.407125 | -77.67179499999997 | 2021-11-14 04:21:31 | Ancash, Peru | |||
694545 | 694545 | 2022-03-17 | Peru | Ancash | 125135 | 7072 | 0 | -9.407125 | -77.67179499999997 | 2022-03-18 04:20:55 | Ancash, Peru | |||
698560 | 698560 | 2021-11-04 | Peru | Ancash | 78013 | 6680 | 0 | -9.407125 | -77.67179499999997 | 2021-11-05 04:21:54 | Ancash, Peru | |||
702556 | 702556 | 2021-03-16 | Peru | Ancash | 45226 | 3964 | 0 | 41262 | -9.407125 | -77.67179499999997 | 2021-03-17 05:25:07 | Ancash, Peru | ||
706590 | 706590 | 2021-09-29 | Peru | Ancash | 76852 | 6637 | 0 | -9.407125 | -77.67179499999997 | 2021-09-30 04:21:20 | Ancash, Peru | |||
714621 | 714621 | 2021-11-12 | Peru | Ancash | 78218 | 6687 | 0 | -9.407125 | -77.67179499999997 | 2021-11-13 04:21:38 | Ancash, Peru | |||
722653 | 722653 | 2021-11-20 | Peru | Ancash | 78580 | 6700 | 0 | -9.407125 | -77.67179499999997 | 2021-11-21 04:22:13 | Ancash, Peru | |||
726649 | 726649 | 2021-05-22 | Peru | Ancash | 67932 | 5988 | 0 | 61944 | -9.407125 | -77.67179499999997 | 2021-05-23 04:20:51 | Ancash, Peru | ||
730683 | 730683 | 2021-12-27 | Peru | Ancash | 81076 | 6760 | 0 | -9.407125 | -77.67179499999997 | 2021-12-28 04:21:47 | Ancash, Peru | |||
737291 | 737291 | 2020-06-12 | Peru | Ancash | 5885 | 868 | 0 | 5017 | -9.407125 | -77.67179499999997 | 2020-06-13 03:33:14 | Ancash, Peru | ||
738451 | 738451 | 2020-12-02 | Peru | Ancash | 28748 | 2746 | 0 | 26002 | -9.407125 | -77.67179499999997 | 2020-12-03 05:28:22 | Ancash, Peru | ||
742465 | 742465 | 2021-02-20 | Peru | Ancash | 41265 | 3576 | 0 | 37689 | -9.407125 | -77.67179499999997 | 2021-02-21 05:24:33 | Ancash, Peru | ||
746500 | 746500 | 2022-04-23 | Peru | Ancash | 127252 | 7133 | 0 | -9.407125 | -77.67179499999997 | 2022-04-24 04:20:56 | Ancash, Peru | |||
753289 | 753289 | 2020-08-01 | Peru | Ancash | 11796 | 1833 | 0 | 9963 | -9.407125 | -77.67179499999997 | 2020-08-02 04:34:47 | Ancash, Peru | ||
754451 | 754451 | 2020-10-28 | Peru | Ancash | 25799 | 2631 | 0 | 23168 | -9.407125 | -77.67179499999997 | 2020-10-29 04:24:49 | Ancash, Peru | ||
758483 | 758483 | 2021-11-26 | Peru | Ancash | 78840 | 6711 | 0 | -9.407125 | -77.67179499999997 | 2021-11-27 04:22:45 | Ancash, Peru | |||
762462 | 762462 | 2020-10-18 | Peru | Ancash | 24710 | 2600 | 0 | 22110 | -9.407125 | -77.67179499999997 | 2020-10-19 04:24:16 | Ancash, Peru | ||
766470 | 766470 | 2020-12-29 | Peru | Ancash | 30743 | 2869 | 0 | 27874 | -9.407125 | -77.67179499999997 | 2020-12-30 05:22:34 | Ancash, Peru | ||
770504 | 770504 | 2021-10-23 | Peru | Ancash | 77660 | 6667 | 0 | -9.407125 | -77.67179499999997 | 2021-10-24 04:21:22 | Ancash, Peru | |||
774498 | 774498 | 2021-01-12 | Peru | Ancash | 32119 | 2987 | 0 | 29132 | -9.407125 | -77.67179499999997 | 2021-01-13 05:22:15 | Ancash, Peru | ||
778515 | 778515 | 2021-07-08 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-09 04:21:21 | Ancash, Peru | ||
782546 | 782546 | 2021-12-13 | Peru | Ancash | 80082 | 6735 | 0 | -9.407125 | -77.67179499999997 | 2021-12-14 04:22:38 | Ancash, Peru | |||
786525 | 786525 | 2020-10-15 | Peru | Ancash | 24446 | 2586 | 0 | 21860 | -9.407125 | -77.67179499999997 | 2020-10-16 04:24:01 | Ancash, Peru | ||
790534 | 790534 | 2021-02-04 | Peru | Ancash | 37724 | 3332 | 0 | 34392 | -9.407125 | -77.67179499999997 | 2021-02-05 05:22:38 | Ancash, Peru | ||
798585 | 798585 | 2021-12-22 | Peru | Ancash | 80554 | 6749 | 0 | -9.407125 | -77.67179499999997 | 2021-12-23 04:21:21 | Ancash, Peru | |||
805157 | 805157 | 2020-06-01 | Peru | Ancash | 4444 | 631 | 0 | 3813 | -9.407125 | -77.67179499999997 | 2020-06-02 02:33:08 | Ancash, Peru | ||
809730 | 809730 | 2021-09-20 | Peru | Ancash | 76586 | 6627 | 0 | -9.407125 | -77.67179499999997 | 2021-09-21 04:21:26 | Ancash, Peru | |||
813724 | 813724 | 2020-09-05 | Peru | Ancash | 19104 | 2328 | 0 | 16776 | -9.407125 | -77.67179499999997 | 2020-09-06 04:28:33 | Ancash, Peru | ||
817715 | 817715 | 2020-10-09 | Peru | Ancash | 23549 | 2558 | 0 | 20991 | -9.407125 | -77.67179499999997 | 2020-10-10 04:23:57 | Ancash, Peru | ||
821720 | 821720 | 2020-11-19 | Peru | Ancash | 27833 | 2711 | 0 | 25122 | -9.407125 | -77.67179499999997 | 2020-11-20 05:26:28 | Ancash, Peru | ||
825735 | 825735 | 2021-06-06 | Peru | Ancash | 70086 | 6199 | 0 | 63887 | -9.407125 | -77.67179499999997 | 2021-06-07 04:22:51 | Ancash, Peru | ||
829751 | 829751 | 2021-07-09 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-10 04:21:25 | Ancash, Peru | ||
837760 | 837760 | 2020-08-17 | Peru | Ancash | 15327 | 2082 | 0 | 13245 | -9.407125 | -77.67179499999997 | 2020-08-18 04:27:56 | Ancash, Peru | ||
844544 | 844544 | 2020-07-22 | Peru | Ancash | 10609 | 1630 | 0 | 8979 | -9.407125 | -77.67179499999997 | 2020-07-23 05:15:04 | Ancash, Peru | ||
845720 | 845720 | 2020-12-12 | Peru | Ancash | 29356 | 2785 | 0 | 26571 | -9.407125 | -77.67179499999997 | 2020-12-13 05:27:20 | Ancash, Peru | ||
860827 | 860827 | 2020-12-11 | Peru | Ancash | 29336 | 2783 | 0 | 26553 | -9.407125 | -77.67179499999997 | 2020-12-12 05:26:19 | Ancash, Peru | ||
864920 | 864920 | 2020-11-12 | Peru | Ancash | 27374 | 2687 | 0 | 24687 | -9.407125 | -77.67179499999997 | 2020-11-13 05:25:30 | Ancash, Peru | ||
876420 | 876420 | 2022-03-27 | Peru | Ancash | 126039 | 7105 | 0 | -9.407125 | -77.67179499999997 | 2022-03-28 04:20:33 | Ancash, Peru | |||
887107 | 887107 | 2020-07-07 | Peru | Ancash | 8918 | 1346 | 0 | 7572 | -9.407125 | -77.67179499999997 | 2020-07-08 05:33:48 | Ancash, Peru | ||
888271 | 888271 | 2021-04-26 | Peru | Ancash | 61172 | 5212 | 0 | 55960 | -9.407125 | -77.67179499999997 | 2021-04-27 04:20:52 | Ancash, Peru | ||
892269 | 892269 | 2020-11-05 | Peru | Ancash | 26857 | 2662 | 0 | 24195 | -9.407125 | -77.67179499999997 | 2020-11-06 05:24:55 | Ancash, Peru | ||
904334 | 904334 | 2021-11-24 | Peru | Ancash | 78580 | 6700 | 0 | -9.407125 | -77.67179499999997 | 2021-11-25 04:22:33 | Ancash, Peru | |||
908328 | 908328 | 2021-01-19 | Peru | Ancash | 33668 | 3063 | 0 | 30605 | -9.407125 | -77.67179499999997 | 2021-01-20 05:21:54 | Ancash, Peru | ||
919840 | 919840 | 2022-03-08 | Peru | Ancash | 124283 | 7046 | 0 | -9.407125 | -77.67179499999997 | 2022-03-09 04:20:59 | Ancash, Peru | |||
923832 | 923832 | 2020-11-26 | Peru | Ancash | 28307 | 2732 | 0 | 25575 | -9.407125 | -77.67179499999997 | 2020-11-27 05:26:53 | Ancash, Peru | ||
927843 | 927843 | 2020-12-21 | Peru | Ancash | 30039 | 2830 | 0 | 27209 | -9.407125 | -77.67179499999997 | 2020-12-22 05:22:33 | Ancash, Peru | ||
934956 | 934956 | 2021-10-16 | Peru | Ancash | 77443 | 6658 | 0 | -9.407125 | -77.67179499999997 | 2021-10-17 04:21:29 | Ancash, Peru | |||
942989 | 942989 | 2022-02-28 | Peru | Ancash | 123965 | 7037 | 0 | -9.407125 | -77.67179499999997 | 2022-03-01 04:21:09 | Ancash, Peru | |||
951021 | 951021 | 2022-03-12 | Peru | Ancash | 124283 | 7046 | 0 | -9.407125 | -77.67179499999997 | 2022-03-13 04:20:49 | Ancash, Peru | |||
955016 | 955016 | 2021-04-25 | Peru | Ancash | 60734 | 5180 | 0 | 55554 | -9.407125 | -77.67179499999997 | 2021-04-26 04:21:04 | Ancash, Peru | ||
967045 | 967045 | 2020-09-29 | Peru | Ancash | 22661 | 2516 | 0 | 20145 | -9.407125 | -77.67179499999997 | 2020-09-30 04:23:33 | Ancash, Peru | ||
975069 | 975069 | 2021-02-06 | Peru | Ancash | 38346 | 3367 | 0 | 34979 | -9.407125 | -77.67179499999997 | 2021-02-07 05:23:00 | Ancash, Peru | ||
979104 | 979104 | 2022-02-01 | Peru | Ancash | 98814 | 6821 | 0 | -9.407125 | -77.67179499999997 | 2022-02-02 04:21:09 | Ancash, Peru | |||
983100 | 983100 | 2021-04-17 | Peru | Ancash | 57496 | 4865 | 0 | 52631 | -9.407125 | -77.67179499999997 | 2021-04-18 04:20:41 | Ancash, Peru | ||
987134 | 987134 | 2021-10-04 | Peru | Ancash | 77097 | 6644 | 0 | -9.407125 | -77.67179499999997 | 2021-10-05 04:21:27 | Ancash, Peru | |||
998590 | 998590 | 2021-03-01 | Peru | Ancash | 42507 | 3704 | 0 | 38803 | -9.407125 | -77.67179499999997 | 2021-03-02 05:23:30 | Ancash, Peru | ||
1005282 | 1005282 | 2020-07-09 | Peru | Ancash | 9185 | 1387 | 0 | 7798 | -9.407125 | -77.67179499999997 | 2020-07-10 04:34:24 | Ancash, Peru | ||
1006444 | 1006444 | 2020-12-06 | Peru | Ancash | 29063 | 2767 | 0 | 26296 | -9.407125 | -77.67179499999997 | 2020-12-07 05:26:14 | Ancash, Peru | ||
1010455 | 1010455 | 2020-12-30 | Peru | Ancash | 30782 | 2872 | 0 | 27910 | -9.407125 | -77.67179499999997 | 2020-12-31 05:22:49 | Ancash, Peru | ||
1014489 | 1014489 | 2021-11-21 | Peru | Ancash | 78580 | 6700 | 0 | -9.407125 | -77.67179499999997 | 2021-11-22 04:22:20 | Ancash, Peru | |||
1026500 | 1026500 | 2020-10-17 | Peru | Ancash | 24568 | 2595 | 0 | 21973 | -9.407125 | -77.67179499999997 | 2020-10-18 04:24:25 | Ancash, Peru | ||
1030531 | 1030531 | 2021-12-06 | Peru | Ancash | 79636 | 6722 | 0 | -9.407125 | -77.67179499999997 | 2021-12-07 04:22:34 | Ancash, Peru | |||
1034524 | 1034524 | 2020-12-15 | Peru | Ancash | 29666 | 2794 | 0 | 26872 | -9.407125 | -77.67179499999997 | 2020-12-16 05:28:04 | Ancash, Peru | ||
1041972 | 1041972 | 2020-10-07 | Peru | Ancash | 23351 | 2550 | 0 | 20801 | -9.407125 | -77.67179499999997 | 2020-10-08 04:23:56 | Ancash, Peru | ||
1045964 | 1045964 | 2020-09-30 | Peru | Ancash | 22728 | 2519 | 0 | 20209 | -9.407125 | -77.67179499999997 | 2020-10-01 04:23:42 | Ancash, Peru | ||
1053972 | 1053972 | 2020-10-23 | Peru | Ancash | 25339 | 2615 | 0 | 22724 | -9.407125 | -77.67179499999997 | 2020-10-24 04:24:46 | Ancash, Peru | ||
1058005 | 1058005 | 2022-02-23 | Peru | Ancash | 122948 | 7006 | 0 | -9.407125 | -77.67179499999997 | 2022-02-24 04:21:14 | Ancash, Peru | |||
1061998 | 1061998 | 2021-01-04 | Peru | Ancash | 31151 | 2909 | 0 | 28242 | -9.407125 | -77.67179499999997 | 2021-01-05 05:21:49 | Ancash, Peru | ||
1078080 | 1078080 | 2021-12-09 | Peru | Ancash | 79636 | 6722 | 0 | -9.407125 | -77.67179499999997 | 2021-12-10 04:22:28 | Ancash, Peru | |||
1082076 | 1082076 | 2021-05-14 | Peru | Ancash | 66090 | 5792 | 0 | 60298 | -9.407125 | -77.67179499999997 | 2021-05-15 04:20:58 | Ancash, Peru | ||
1090226 | 1090226 | 2021-03-03 | Peru | Ancash | 43142 | 3736 | 0 | 39406 | -9.407125 | -77.67179499999997 | 2021-03-04 05:24:24 | Ancash, Peru | ||
1094238 | 1094238 | 2021-01-20 | Peru | Ancash | 34319 | 3078 | 0 | 31241 | -9.407125 | -77.67179499999997 | 2021-01-21 05:22:01 | Ancash, Peru | ||
1105701 | 1105701 | 2020-09-02 | Peru | Ancash | 18605 | 2298 | 0 | 16307 | -9.407125 | -77.67179499999997 | 2020-09-03 04:28:22 | Ancash, Peru | ||
1113745 | 1113745 | 2022-01-11 | Peru | Ancash | 82465 | 6773 | 0 | -9.407125 | -77.67179499999997 | 2022-01-12 04:21:44 | Ancash, Peru | |||
1117744 | 1117744 | 2021-08-06 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-07 04:21:30 | Ancash, Peru | |||
1125748 | 1125748 | 2021-06-18 | Peru | Ancash | 71806 | 6369 | 0 | 65437 | -9.407125 | -77.67179499999997 | 2021-06-19 04:22:33 | Ancash, Peru | ||
1135874 | 1135874 | 2020-06-26 | Peru | Ancash | 7652 | 1139 | 0 | 6513 | -9.407125 | -77.67179499999997 | 2020-06-27 04:33:35 | Ancash, Peru | ||
1137034 | 1137034 | 2021-01-01 | Peru | Ancash | 30909 | 2886 | 0 | 28023 | -9.407125 | -77.67179499999997 | 2021-01-02 05:22:33 | Ancash, Peru | ||
1141068 | 1141068 | 2022-01-23 | Peru | Ancash | 88759 | 6789 | 0 | -9.407125 | -77.67179499999997 | 2022-01-24 04:21:12 | Ancash, 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]);