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 = "Ancash" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462946 | 2462946 | 2021-09-14 | Peru | Ancash | 76285 | 6622 | 0 | -9.407125 | -77.67179499999997 | 2021-09-15 03:22:37 | Ancash, Peru | |||
1385785 | 1385785 | 2021-09-13 | Peru | Ancash | 76285 | 6622 | 0 | -9.407125 | -77.67179499999997 | 2021-09-14 04:21:41 | Ancash, Peru | |||
1885154 | 1885154 | 2021-09-12 | Peru | Ancash | 76248 | 6617 | 0 | -9.407125 | -77.67179499999997 | 2021-09-13 04:21:15 | Ancash, Peru | |||
3806057 | 3806057 | 2021-09-11 | Peru | Ancash | 76184 | 6617 | 0 | -9.407125 | -77.67179499999997 | 2021-09-12 04:21:13 | Ancash, Peru | |||
3448997 | 3448997 | 2021-09-10 | Peru | Ancash | 76184 | 6617 | 0 | -9.407125 | -77.67179499999997 | 2021-09-11 04:21:30 | Ancash, Peru | |||
1262943 | 1262943 | 2021-09-09 | Peru | Ancash | 76184 | 6617 | 0 | -9.407125 | -77.67179499999997 | 2021-09-10 04:21:20 | Ancash, Peru | |||
2279313 | 2279313 | 2021-09-08 | Peru | Ancash | 76120 | 6615 | 0 | -9.407125 | -77.67179499999997 | 2021-09-09 04:21:27 | Ancash, Peru | |||
642092 | 642092 | 2021-09-07 | Peru | Ancash | 76120 | 6615 | 0 | -9.407125 | -77.67179499999997 | 2021-09-08 04:21:31 | Ancash, Peru | |||
3194155 | 3194155 | 2021-09-06 | Peru | Ancash | 76079 | 6610 | 0 | -9.407125 | -77.67179499999997 | 2021-09-07 04:21:35 | Ancash, Peru | |||
3281023 | 3281023 | 2021-09-05 | Peru | Ancash | 76079 | 6610 | 0 | -9.407125 | -77.67179499999997 | 2021-09-06 04:21:22 | Ancash, Peru | |||
249437 | 249437 | 2021-09-04 | Peru | Ancash | 76005 | 6604 | 0 | -9.407125 | -77.67179499999997 | 2021-09-05 04:21:33 | Ancash, Peru | |||
3974718 | 3974718 | 2021-09-03 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-09-04 04:21:28 | Ancash, Peru | |||
178180 | 178180 | 2021-09-02 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-09-03 04:21:20 | Ancash, Peru | |||
67215 | 67215 | 2021-09-01 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-09-02 04:21:15 | Ancash, Peru | |||
2068057 | 2068057 | 2021-08-31 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-09-01 04:21:38 | Ancash, Peru | |||
1775511 | 1775511 | 2021-08-30 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-31 04:21:46 | Ancash, Peru | |||
3892085 | 3892085 | 2021-08-29 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-30 04:21:23 | Ancash, Peru | |||
2793188 | 2793188 | 2021-08-28 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-29 04:21:14 | Ancash, Peru | |||
2923347 | 2923347 | 2021-08-27 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-28 04:21:28 | Ancash, Peru | |||
1596361 | 1596361 | 2021-08-26 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-27 04:21:37 | Ancash, Peru | |||
32570 | 32570 | 2021-08-25 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-26 04:21:28 | Ancash, Peru | |||
3105609 | 3105609 | 2021-08-24 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-25 04:21:41 | Ancash, Peru | |||
3165780 | 3165780 | 2021-08-23 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-24 04:21:19 | Ancash, Peru | |||
2175707 | 2175707 | 2021-08-22 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-23 04:21:27 | Ancash, Peru | |||
3555803 | 3555803 | 2021-08-21 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-22 04:21:29 | Ancash, Peru | |||
1854145 | 1854145 | 2021-08-20 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-21 04:21:38 | Ancash, Peru | |||
511852 | 511852 | 2021-08-19 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-20 04:21:33 | Ancash, Peru | |||
2518331 | 2518331 | 2021-08-18 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-19 04:21:15 | Ancash, Peru | |||
245423 | 245423 | 2021-08-17 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-18 04:21:35 | Ancash, Peru | |||
1604386 | 1604386 | 2021-08-16 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-17 04:21:49 | Ancash, Peru | |||
103480 | 103480 | 2021-08-15 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-16 04:21:31 | Ancash, Peru | |||
507838 | 507838 | 2021-08-14 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-15 04:21:41 | Ancash, Peru | |||
1483710 | 1483710 | 2021-08-13 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-14 04:21:25 | Ancash, Peru | |||
2899840 | 2899840 | 2021-08-12 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-13 04:21:24 | Ancash, Peru | |||
1342444 | 1342444 | 2021-08-11 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-12 04:21:25 | Ancash, Peru | |||
2351591 | 2351591 | 2021-08-10 | Peru | Ancash | 75118 | 6559 | 0 | -9.407125 | -77.67179499999997 | 2021-08-11 04:21:58 | Ancash, Peru | |||
650120 | 650120 | 2021-08-09 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-10 04:21:27 | Ancash, Peru | |||
589782 | 589782 | 2021-08-08 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-09 04:21:24 | Ancash, Peru | |||
2203794 | 2203794 | 2021-08-07 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-08 04:21:33 | Ancash, Peru | |||
1117744 | 1117744 | 2021-08-06 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-07 04:21:30 | Ancash, Peru | |||
1956681 | 1956681 | 2021-08-05 | Peru | Ancash | 74855 | 6553 | 0 | -9.407125 | -77.67179499999997 | 2021-08-06 04:21:18 | Ancash, Peru | |||
332060 | 332060 | 2021-08-04 | Peru | Ancash | 74855 | 6553 | 0 | 68302 | -9.407125 | -77.67179499999997 | 2021-08-05 04:21:51 | Ancash, Peru | ||
3468331 | 3468331 | 2021-08-03 | Peru | Ancash | 74794 | 6549 | 0 | 68245 | -9.407125 | -77.67179499999997 | 2021-08-04 04:21:25 | Ancash, Peru | ||
3683605 | 3683605 | 2021-08-02 | Peru | Ancash | 74688 | 6544 | 0 | 68144 | -9.407125 | -77.67179499999997 | 2021-08-03 04:21:39 | Ancash, Peru | ||
3015504 | 3015504 | 2021-08-01 | Peru | Ancash | 74688 | 6544 | 0 | 68144 | -9.407125 | -77.67179499999997 | 2021-08-02 04:21:36 | Ancash, Peru | ||
3904127 | 3904127 | 2021-07-31 | Peru | Ancash | 74688 | 6544 | 0 | 68144 | -9.407125 | -77.67179499999997 | 2021-08-01 04:21:50 | Ancash, Peru | ||
3296332 | 3296332 | 2021-07-30 | Peru | Ancash | 74688 | 6544 | 0 | 68144 | -9.407125 | -77.67179499999997 | 2021-07-31 04:21:35 | Ancash, Peru | ||
3385543 | 3385543 | 2021-07-29 | Peru | Ancash | 74676 | 6544 | 0 | 68132 | -9.407125 | -77.67179499999997 | 2021-07-30 04:21:34 | Ancash, Peru | ||
408448 | 408448 | 2021-07-28 | Peru | Ancash | 74676 | 6544 | 0 | 68132 | -9.407125 | -77.67179499999997 | 2021-07-29 04:21:33 | Ancash, Peru | ||
1306309 | 1306309 | 2021-07-27 | Peru | Ancash | 74582 | 6536 | 0 | 68046 | -9.407125 | -77.67179499999997 | 2021-07-28 04:21:39 | Ancash, Peru | ||
3218452 | 3218452 | 2021-07-26 | Peru | Ancash | 74582 | 6536 | 0 | 68046 | -9.407125 | -77.67179499999997 | 2021-07-27 04:21:18 | Ancash, Peru | ||
1378661 | 1378661 | 2021-07-25 | Peru | Ancash | 74194 | 6510 | 0 | 67684 | -9.407125 | -77.67179499999997 | 2021-07-26 04:21:28 | Ancash, Peru | ||
1330401 | 1330401 | 2021-07-24 | Peru | Ancash | 74194 | 6510 | 0 | 67684 | -9.407125 | -77.67179499999997 | 2021-07-25 04:22:12 | Ancash, Peru | ||
3137705 | 3137705 | 2021-07-23 | Peru | Ancash | 74194 | 6510 | 0 | 67684 | -9.407125 | -77.67179499999997 | 2021-07-24 00:21:36 | Ancash, Peru | ||
3476465 | 3476465 | 2021-07-22 | Peru | Ancash | 74194 | 6510 | 0 | 67684 | -9.407125 | -77.67179499999997 | 2021-07-23 04:21:29 | Ancash, Peru | ||
3331684 | 3331684 | 2021-07-21 | Peru | Ancash | 74176 | 6504 | 0 | 67672 | -9.407125 | -77.67179499999997 | 2021-07-22 04:21:19 | Ancash, Peru | ||
2371665 | 2371665 | 2021-07-20 | Peru | Ancash | 74176 | 6504 | 0 | 67672 | -9.407125 | -77.67179499999997 | 2021-07-21 04:21:40 | Ancash, Peru | ||
483744 | 483744 | 2021-07-19 | Peru | Ancash | 74176 | 6504 | 0 | 67672 | -9.407125 | -77.67179499999997 | 2021-07-20 04:21:48 | Ancash, Peru | ||
2673967 | 2673967 | 2021-07-18 | Peru | Ancash | 74100 | 6504 | 0 | 67596 | -9.407125 | -77.67179499999997 | 2021-07-19 04:21:24 | Ancash, Peru | ||
3706279 | 3706279 | 2021-07-17 | Peru | Ancash | 73974 | 6503 | 0 | 67471 | -9.407125 | -77.67179499999997 | 2021-07-18 04:22:07 | Ancash, Peru | ||
2947510 | 2947510 | 2021-07-16 | Peru | Ancash | 73974 | 6503 | 0 | 67471 | -9.407125 | -77.67179499999997 | 2021-07-17 04:22:22 | Ancash, Peru | ||
296166 | 296166 | 2021-07-15 | Peru | Ancash | 73902 | 6501 | 0 | 67401 | -9.407125 | -77.67179499999997 | 2021-07-16 04:21:22 | Ancash, Peru | ||
3632111 | 3632111 | 2021-07-14 | Peru | Ancash | 73902 | 6501 | 0 | 67401 | -9.407125 | -77.67179499999997 | 2021-07-15 04:21:48 | 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 | ||
3741235 | 3741235 | 2021-07-12 | Peru | Ancash | 73801 | 6490 | 0 | 67311 | -9.407125 | -77.67179499999997 | 2021-07-13 04:21:18 | Ancash, Peru | ||
3659748 | 3659748 | 2021-07-11 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-12 04:21:34 | 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 | ||
829751 | 829751 | 2021-07-09 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-10 04:21:25 | 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 | ||
1440737 | 1440737 | 2021-07-07 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-08 04:21:26 | Ancash, Peru | ||
2693842 | 2693842 | 2021-07-06 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-07 04:21:20 | Ancash, Peru | ||
1932591 | 1932591 | 2021-07-05 | Peru | Ancash | 73266 | 6455 | 0 | 66811 | -9.407125 | -77.67179499999997 | 2021-07-06 04:21:32 | Ancash, Peru | ||
1165322 | 1165322 | 2021-07-04 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-07-05 04:21:28 | Ancash, Peru | ||
1495756 | 1495756 | 2021-07-03 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-07-04 04:21:38 | Ancash, Peru | ||
2072071 | 2072071 | 2021-07-02 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-07-03 04:21:37 | Ancash, Peru | ||
2765087 | 2765087 | 2021-07-01 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-07-02 04:21:47 | Ancash, Peru | ||
1893295 | 1893295 | 2021-06-30 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-07-01 04:21:19 | Ancash, Peru | ||
400418 | 400418 | 2021-06-29 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-30 04:21:41 | Ancash, Peru | ||
3125661 | 3125661 | 2021-06-28 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-29 04:21:28 | Ancash, Peru | ||
2590156 | 2590156 | 2021-06-27 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-28 04:21:29 | Ancash, Peru | ||
3958660 | 3958660 | 2021-06-26 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-27 04:21:39 | Ancash, Peru | ||
1712479 | 1712479 | 2021-06-25 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-26 04:21:43 | Ancash, Peru | ||
2295604 | 2295604 | 2021-06-24 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-25 04:21:33 | Ancash, Peru | ||
2423044 | 2423044 | 2021-06-23 | Peru | Ancash | 72252 | 6394 | 0 | 65858 | -9.407125 | -77.67179499999997 | 2021-06-24 04:21:55 | Ancash, Peru | ||
563121 | 563121 | 2021-06-22 | Peru | Ancash | 71806 | 6369 | 0 | 65437 | -9.407125 | -77.67179499999997 | 2021-06-23 04:21:46 | Ancash, Peru | ||
3358823 | 3358823 | 2021-06-21 | Peru | Ancash | 71806 | 6369 | 0 | 65437 | -9.407125 | -77.67179499999997 | 2021-06-22 04:21:34 | Ancash, Peru | ||
2884522 | 2884522 | 2021-06-20 | Peru | Ancash | 71806 | 6369 | 0 | 65437 | -9.407125 | -77.67179499999997 | 2021-06-21 04:21:41 | Ancash, Peru | ||
107605 | 107605 | 2021-06-19 | Peru | Ancash | 71806 | 6369 | 0 | 65437 | -9.407125 | -77.67179499999997 | 2021-06-20 04:21:48 | 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 | ||
2911326 | 2911326 | 2021-06-17 | Peru | Ancash | 71806 | 6369 | 0 | 65437 | -9.407125 | -77.67179499999997 | 2021-06-18 04:22:16 | Ancash, Peru | ||
3030442 | 3030442 | 2021-06-16 | Peru | Ancash | 71388 | 6342 | 0 | 65046 | -9.407125 | -77.67179499999997 | 2021-06-17 04:22:36 | Ancash, Peru | ||
2339548 | 2339548 | 2021-06-15 | Peru | Ancash | 71388 | 6342 | 0 | 65046 | -9.407125 | -77.67179499999997 | 2021-06-16 04:22:32 | Ancash, Peru | ||
1564244 | 1564244 | 2021-06-14 | Peru | Ancash | 71388 | 6342 | 0 | 65046 | -9.407125 | -77.67179499999997 | 2021-06-15 04:22:22 | Ancash, Peru | ||
3381527 | 3381527 | 2021-06-13 | Peru | Ancash | 71191 | 6312 | 0 | 64879 | -9.407125 | -77.67179499999997 | 2021-06-14 04:22:46 | Ancash, Peru | ||
1736661 | 1736661 | 2021-06-12 | Peru | Ancash | 71191 | 6312 | 0 | 64879 | -9.407125 | -77.67179499999997 | 2021-06-13 04:22:44 | Ancash, Peru | ||
3970702 | 3970702 | 2021-06-11 | Peru | Ancash | 71095 | 6309 | 0 | 64786 | -9.407125 | -77.67179499999997 | 2021-06-12 04:22:22 | Ancash, Peru | ||
2717124 | 2717124 | 2021-06-10 | Peru | Ancash | 70975 | 6295 | 0 | 64680 | -9.407125 | -77.67179499999997 | 2021-06-11 04:23:20 | Ancash, Peru | ||
523009 | 523009 | 2021-06-09 | Peru | Ancash | 70855 | 6283 | 0 | 64572 | -9.407125 | -77.67179499999997 | 2021-06-10 04:23:17 | Ancash, Peru | ||
3472449 | 3472449 | 2021-06-08 | Peru | Ancash | 70742 | 6265 | 0 | 64477 | -9.407125 | -77.67179499999997 | 2021-06-09 04:23:31 | Ancash, Peru | ||
3145733 | 3145733 | 2021-06-07 | Peru | Ancash | 70742 | 6265 | 0 | 64477 | -9.407125 | -77.67179499999997 | 2021-06-08 04:22:35 | 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]);