johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Ancash" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, longitude, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
485 | 485 | 2021-12-02 | Peru | Ancash | 79129 | 6713 | 0 | -9.407125 | -77.67179499999997 | 2021-12-03 04:23:05 | Ancash, Peru | |||
4501 | 4501 | 2021-10-28 | Peru | Ancash | 77754 | 6670 | 0 | -9.407125 | -77.67179499999997 | 2021-10-29 04:22:03 | Ancash, Peru | |||
16509 | 16509 | 2021-09-18 | Peru | Ancash | 76460 | 6624 | 0 | -9.407125 | -77.67179499999997 | 2021-09-19 04:21:34 | Ancash, Peru | |||
24556 | 24556 | 2022-03-20 | Peru | Ancash | 125135 | 7072 | 0 | -9.407125 | -77.67179499999997 | 2022-03-21 04:20:50 | Ancash, Peru | |||
28571 | 28571 | 2021-11-11 | Peru | Ancash | 78097 | 6685 | 0 | -9.407125 | -77.67179499999997 | 2021-11-12 04:22:01 | Ancash, Peru | |||
32570 | 32570 | 2021-08-25 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-08-26 04:21:28 | Ancash, Peru | |||
43863 | 43863 | 2021-11-02 | Peru | Ancash | 77931 | 6678 | 0 | -9.407125 | -77.67179499999997 | 2021-11-03 06:22:09 | Ancash, Peru | |||
63220 | 63220 | 2022-11-12 | Peru | Ancash | 149164 | 7374 | 0 | -9.407125 | -77.671795 | 2022-11-13 04:21:14 | Ancash, Peru | |||
67215 | 67215 | 2021-09-01 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-09-02 04:21:15 | Ancash, Peru | |||
71246 | 71246 | 2022-02-07 | Peru | Ancash | 118229 | 6912 | 0 | -9.407125 | -77.67179499999997 | 2022-02-08 04:21:15 | Ancash, Peru | |||
87280 | 87280 | 2021-11-09 | Peru | Ancash | 78097 | 6685 | 0 | -9.407125 | -77.67179499999997 | 2021-11-10 04:21:38 | Ancash, Peru | |||
91298 | 91298 | 2022-07-23 | Peru | Ancash | 137177 | 7229 | 0 | -9.407125 | -77.671795 | 2022-07-24 04:20:47 | Ancash, Peru | |||
99481 | 99481 | 2022-01-14 | Peru | Ancash | 82465 | 6773 | 0 | -9.407125 | -77.67179499999997 | 2022-01-15 04:21:07 | Ancash, Peru | |||
103480 | 103480 | 2021-08-15 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-16 04:21:31 | Ancash, Peru | |||
114908 | 114908 | 2022-09-06 | Peru | Ancash | 147488 | 7330 | 0 | -9.407125 | -77.671795 | 2022-09-07 04:20:59 | Ancash, Peru | |||
126888 | 126888 | 2022-01-09 | Peru | Ancash | 82465 | 6773 | 0 | -9.407125 | -77.67179499999997 | 2022-01-10 04:22:07 | Ancash, Peru | |||
130908 | 130908 | 2022-10-04 | Peru | Ancash | 148683 | 7359 | 0 | -9.407125 | -77.671795 | 2022-10-05 04:23:06 | Ancash, Peru | |||
138126 | 138126 | 2021-12-04 | Peru | Ancash | 79129 | 6713 | 0 | -9.407125 | -77.67179499999997 | 2021-12-05 04:22:25 | Ancash, Peru | |||
142144 | 142144 | 2022-07-09 | Peru | Ancash | 131917 | 7205 | 0 | -9.407125 | -77.671795 | 2022-07-10 04:20:54 | Ancash, Peru | |||
150139 | 150139 | 2021-11-29 | Peru | Ancash | 79129 | 6713 | 0 | -9.407125 | -77.67179499999997 | 2021-11-30 04:22:53 | Ancash, Peru | |||
158168 | 158168 | 2022-03-29 | Peru | Ancash | 126039 | 7105 | 0 | -9.407125 | -77.67179499999997 | 2022-03-30 04:20:45 | Ancash, Peru | |||
162183 | 162183 | 2021-11-19 | Peru | Ancash | 78395 | 6697 | 0 | -9.407125 | -77.67179499999997 | 2021-11-20 04:22:17 | Ancash, Peru | |||
166201 | 166201 | 2022-06-21 | Peru | Ancash | 129674 | 7196 | 0 | -9.407125 | -77.671795 | 2022-06-22 04:20:54 | Ancash, Peru | |||
178180 | 178180 | 2021-09-02 | Peru | Ancash | 75681 | 6584 | 0 | -9.407125 | -77.67179499999997 | 2021-09-03 04:21:20 | Ancash, Peru | |||
186226 | 186226 | 2022-02-13 | Peru | Ancash | 118229 | 6912 | 0 | -9.407125 | -77.67179499999997 | 2022-02-14 04:20:51 | Ancash, Peru | |||
198417 | 198417 | 2022-10-19 | Peru | Ancash | 148797 | 7364 | 0 | -9.407125 | -77.671795 | 2022-10-20 04:22:59 | Ancash, Peru | |||
218138 | 218138 | 2022-12-26 | Peru | Ancash | 157448 | 7332 | 0 | -9.407125 | -77.671795 | 2022-12-27 04:21:07 | Ancash, Peru | |||
222151 | 222151 | 2022-05-09 | Peru | Ancash | 128016 | 7153 | 0 | -9.407125 | -77.671795 | 2022-05-10 04:20:50 | Ancash, Peru | |||
229383 | 229383 | 2022-05-31 | Peru | Ancash | 128720 | 7182 | 0 | -9.407125 | -77.671795 | 2022-06-01 04:20:55 | Ancash, Peru | |||
233398 | 233398 | 2022-02-11 | Peru | Ancash | 118229 | 6912 | 0 | -9.407125 | -77.67179499999997 | 2022-02-12 04:21:06 | Ancash, Peru | |||
245423 | 245423 | 2021-08-17 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-18 04:21:35 | Ancash, Peru | |||
249437 | 249437 | 2021-09-04 | Peru | Ancash | 76005 | 6604 | 0 | -9.407125 | -77.67179499999997 | 2021-09-05 04:21:33 | Ancash, Peru | |||
253470 | 253470 | 2022-09-08 | Peru | Ancash | 147488 | 7330 | 0 | -9.407125 | -77.671795 | 2022-09-09 04:21:11 | Ancash, Peru | |||
257488 | 257488 | 2022-12-10 | Peru | Ancash | 152753 | 7311 | 0 | -9.407125 | -77.671795 | 2022-12-11 04:20:50 | Ancash, Peru | |||
261688 | 261688 | 2022-03-15 | Peru | Ancash | 125135 | 7072 | 0 | -9.407125 | -77.67179499999997 | 2022-03-16 04:20:50 | Ancash, Peru | |||
276338 | 276338 | 2021-11-03 | Peru | Ancash | 77931 | 6678 | 0 | -9.407125 | -77.67179499999997 | 2021-11-04 04:22:20 | Ancash, Peru | |||
288151 | 288151 | 2021-10-31 | Peru | Ancash | 77754 | 6670 | 0 | -9.407125 | -77.67179499999997 | 2021-11-01 04:22:01 | Ancash, Peru | |||
292171 | 292171 | 2022-11-15 | Peru | Ancash | 149443 | 7364 | 0 | -9.407125 | -77.671795 | 2022-11-16 04:21:09 | Ancash, Peru | |||
304024 | 304024 | 2022-04-16 | Peru | Ancash | 126995 | 7124 | 0 | -9.407125 | -77.67179499999997 | 2022-04-17 04:20:59 | Ancash, Peru | |||
308043 | 308043 | 2022-12-13 | Peru | Ancash | 152753 | 7311 | 0 | -9.407125 | -77.671795 | 2022-12-14 04:21:04 | Ancash, Peru | |||
312059 | 312059 | 2022-11-13 | Peru | Ancash | 149164 | 7374 | 0 | -9.407125 | -77.671795 | 2022-11-14 04:21:09 | Ancash, Peru | |||
316072 | 316072 | 2022-02-12 | Peru | Ancash | 118229 | 6912 | 0 | -9.407125 | -77.67179499999997 | 2022-02-13 04:21:00 | Ancash, Peru | |||
320091 | 320091 | 2022-10-30 | Peru | Ancash | 148941 | 7367 | 0 | -9.407125 | -77.671795 | 2022-10-31 04:21:36 | Ancash, Peru | |||
328065 | 328065 | 2022-12-27 | Peru | Ancash | 157448 | 7332 | 0 | -9.407125 | -77.671795 | 2022-12-28 04:21:04 | Ancash, Peru | |||
336092 | 336092 | 2022-03-18 | Peru | Ancash | 125135 | 7072 | 0 | -9.407125 | -77.67179499999997 | 2022-03-19 04:20:47 | Ancash, Peru | |||
348455 | 348455 | 2022-12-14 | Peru | Ancash | 155329 | 7317 | 0 | -9.407125 | -77.671795 | 2022-12-15 04:20:58 | Ancash, Peru | |||
356482 | 356482 | 2022-03-11 | Peru | Ancash | 124283 | 7046 | 0 | -9.407125 | -77.67179499999997 | 2022-03-12 04:20:50 | Ancash, Peru | |||
360498 | 360498 | 2022-05-07 | Peru | Ancash | 127867 | 7150 | 0 | -9.407125 | -77.671795 | 2022-05-08 04:20:49 | Ancash, Peru | |||
372355 | 372355 | 2022-09-13 | Peru | Ancash | 147922 | 7339 | 0 | -9.407125 | -77.671795 | 2022-09-14 04:20:44 | Ancash, Peru | |||
384382 | 384382 | 2022-09-23 | Peru | Ancash | 148234 | 7346 | 0 | -9.407125 | -77.671795 | 2022-09-24 04:21:40 | Ancash, Peru | |||
396423 | 396423 | 2022-10-07 | Peru | Ancash | 148683 | 7359 | 0 | -9.407125 | -77.671795 | 2022-10-08 04:22:56 | Ancash, Peru | |||
404449 | 404449 | 2021-12-07 | Peru | Ancash | 79636 | 6722 | 0 | -9.407125 | -77.67179499999997 | 2021-12-08 04:22:46 | Ancash, Peru | |||
419494 | 419494 | 2022-09-18 | Peru | Ancash | 147922 | 7339 | 0 | -9.407125 | -77.671795 | 2022-09-19 04:21:49 | Ancash, Peru | |||
423506 | 423506 | 2021-10-10 | Peru | Ancash | 77287 | 6654 | 0 | -9.407125 | -77.67179499999997 | 2021-10-11 04:21:31 | Ancash, Peru | |||
431516 | 431516 | 2022-11-03 | Peru | Ancash | 149041 | 7368 | 0 | -9.407125 | -77.671795 | 2022-11-04 04:22:11 | Ancash, Peru | |||
443510 | 443510 | 2021-10-20 | Peru | Ancash | 77576 | 6665 | 0 | -9.407125 | -77.67179499999997 | 2021-10-21 04:21:18 | Ancash, Peru | |||
447526 | 447526 | 2021-11-17 | Peru | Ancash | 78395 | 6697 | 0 | -9.407125 | -77.67179499999997 | 2021-11-18 04:21:33 | Ancash, Peru | |||
451546 | 451546 | 2022-12-21 | Peru | Ancash | 155329 | 7317 | 0 | -9.407125 | -77.671795 | 2022-12-22 04:20:56 | Ancash, Peru | |||
459535 | 459535 | 2022-02-02 | Peru | Ancash | 98814 | 6821 | 0 | -9.407125 | -77.67179499999997 | 2022-02-03 04:21:21 | Ancash, Peru | |||
463552 | 463552 | 2022-05-02 | Peru | Ancash | 127552 | 7140 | 0 | -9.407125 | -77.671795 | 2022-05-03 04:21:00 | Ancash, Peru | |||
467567 | 467567 | 2021-10-07 | Peru | Ancash | 77193 | 6653 | 0 | -9.407125 | -77.67179499999997 | 2021-10-08 04:21:25 | Ancash, Peru | |||
475599 | 475599 | 2022-06-26 | Peru | Ancash | 129674 | 7196 | 0 | -9.407125 | -77.671795 | 2022-06-27 04:21:00 | Ancash, Peru | |||
479749 | 479749 | 2022-11-08 | Peru | Ancash | 149164 | 7374 | 0 | -9.407125 | -77.671795 | 2022-11-09 04:21:22 | Ancash, Peru | |||
487779 | 487779 | 2022-11-25 | Peru | Ancash | 149879 | 7366 | 0 | -9.407125 | -77.671795 | 2022-11-26 04:21:11 | Ancash, Peru | |||
491791 | 491791 | 2021-10-14 | Peru | Ancash | 77358 | 6657 | 0 | -9.407125 | -77.67179499999997 | 2021-10-15 04:21:26 | Ancash, Peru | |||
495807 | 495807 | 2021-11-06 | Peru | Ancash | 78013 | 6680 | 0 | -9.407125 | -77.67179499999997 | 2021-11-07 04:21:53 | Ancash, Peru | |||
499824 | 499824 | 2022-04-02 | Peru | Ancash | 126039 | 7105 | 0 | -9.407125 | -77.67179499999997 | 2022-04-03 04:20:48 | Ancash, Peru | |||
503843 | 503843 | 2022-12-17 | Peru | Ancash | 155329 | 7317 | 0 | -9.407125 | -77.671795 | 2022-12-18 04:21:03 | Ancash, Peru | |||
507838 | 507838 | 2021-08-14 | Peru | Ancash | 75179 | 6561 | 0 | -9.407125 | -77.67179499999997 | 2021-08-15 04:21:41 | Ancash, Peru | |||
511852 | 511852 | 2021-08-19 | Peru | Ancash | 75410 | 6567 | 0 | -9.407125 | -77.67179499999997 | 2021-08-20 04:21:33 | Ancash, Peru | |||
515887 | 515887 | 2022-10-15 | Peru | Ancash | 148797 | 7364 | 0 | -9.407125 | -77.671795 | 2022-10-16 04:22:39 | Ancash, Peru | |||
534891 | 534891 | 2021-10-27 | Peru | Ancash | 77754 | 6670 | 0 | -9.407125 | -77.67179499999997 | 2021-10-28 04:22:08 | Ancash, Peru | |||
538911 | 538911 | 2022-10-26 | Peru | Ancash | 148941 | 7367 | 0 | -9.407125 | -77.671795 | 2022-10-27 04:22:01 | Ancash, Peru | |||
542927 | 542927 | 2022-12-15 | Peru | Ancash | 155329 | 7317 | 0 | -9.407125 | -77.671795 | 2022-12-16 04:21:01 | Ancash, Peru | |||
550929 | 550929 | 2021-12-08 | Peru | Ancash | 79636 | 6722 | 0 | -9.407125 | -77.67179499999997 | 2021-12-09 04:22:49 | Ancash, Peru | |||
554945 | 554945 | 2022-01-16 | Peru | Ancash | 88759 | 6789 | 0 | -9.407125 | -77.67179499999997 | 2022-01-17 04:21:08 | Ancash, Peru | |||
558963 | 558963 | 2022-06-16 | Peru | Ancash | 129278 | 7191 | 0 | -9.407125 | -77.671795 | 2022-06-17 04:20:56 | Ancash, Peru | |||
567259 | 567259 | 2021-10-29 | Peru | Ancash | 77754 | 6670 | 0 | -9.407125 | -77.67179499999997 | 2021-10-30 04:22:03 | Ancash, Peru | |||
574988 | 574988 | 2022-02-25 | Peru | Ancash | 122948 | 7006 | 0 | -9.407125 | -77.67179499999997 | 2022-02-26 04:21:12 | Ancash, Peru | |||
589782 | 589782 | 2021-08-08 | Peru | Ancash | 74960 | 6555 | 0 | -9.407125 | -77.67179499999997 | 2021-08-09 04:21:24 | Ancash, Peru | |||
593815 | 593815 | 2022-07-01 | Peru | Ancash | 130436 | 7200 | 0 | -9.407125 | -77.671795 | 2022-07-02 04:21:16 | 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 | |||
618021 | 618021 | 2022-11-05 | Peru | Ancash | 149041 | 7368 | 0 | -9.407125 | -77.671795 | 2022-11-06 04:21:24 | Ancash, Peru | |||
622035 | 622035 | 2022-05-22 | Peru | Ancash | 128241 | 7172 | 0 | -9.407125 | -77.671795 | 2022-05-26 04:20:50 | Ancash, Peru | |||
630065 | 630065 | 2022-07-12 | Peru | Ancash | 134053 | 7218 | 0 | -9.407125 | -77.671795 | 2022-07-13 04:20:58 | Ancash, Peru | |||
634079 | 634079 | 2021-10-13 | Peru | Ancash | 77358 | 6657 | 0 | -9.407125 | -77.67179499999997 | 2021-10-14 04:21:29 | Ancash, Peru | |||
642092 | 642092 | 2021-09-07 | Peru | Ancash | 76120 | 6615 | 0 | -9.407125 | -77.67179499999997 | 2021-09-08 04:21:31 | 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 | |||
658470 | 658470 | 2022-05-13 | Peru | Ancash | 128016 | 7153 | 0 | -9.407125 | -77.671795 | 2022-05-14 04:20:48 | Ancash, Peru | |||
670456 | 670456 | 2022-07-21 | Peru | Ancash | 137177 | 7229 | 0 | -9.407125 | -77.671795 | 2022-07-22 04:21:15 | Ancash, Peru | |||
674472 | 674472 | 2022-07-30 | Peru | Ancash | 139917 | 7246 | 0 | -9.407125 | -77.671795 | 2022-07-31 04:21:02 | 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 | |||
690532 | 690532 | 2022-12-23 | Peru | Ancash | 155329 | 7317 | 0 | -9.407125 | -77.671795 | 2022-12-24 04:21:02 | 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 | |||
706590 | 706590 | 2021-09-29 | Peru | Ancash | 76852 | 6637 | 0 | -9.407125 | -77.67179499999997 | 2021-09-30 04:21:20 | Ancash, Peru | |||
710609 | 710609 | 2022-11-01 | Peru | Ancash | 149041 | 7368 | 0 | -9.407125 | -77.671795 | 2022-11-02 04:22:09 | 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]);