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 = "Piura" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190237 | 190237 | 2021-01-11 | Peru | Piura | 43483 | 6504 | 0 | 36979 | -5.133361 | -80.335861 | 2021-01-12 05:22:15 | Piura, Peru | ||
2626040 | 2626040 | 2021-01-10 | Peru | Piura | 43251 | 6488 | 0 | 36763 | -5.133361 | -80.335861 | 2021-01-11 05:21:50 | Piura, Peru | ||
3900128 | 3900128 | 2021-01-09 | Peru | Piura | 43251 | 6467 | 0 | 36784 | -5.133361 | -80.335861 | 2021-01-10 05:22:12 | Piura, Peru | ||
154151 | 154151 | 2021-01-08 | Peru | Piura | 43251 | 6450 | 0 | 36801 | -5.133361 | -80.335861 | 2021-01-09 05:22:18 | Piura, Peru | ||
2541575 | 2541575 | 2021-01-07 | Peru | Piura | 42946 | 6435 | 0 | 36511 | -5.133361 | -80.335861 | 2021-01-08 05:22:42 | Piura, Peru | ||
2864884 | 2864884 | 2021-01-06 | Peru | Piura | 42946 | 6422 | 0 | 36524 | -5.133361 | -80.335861 | 2021-01-07 05:22:03 | Piura, Peru | ||
3034471 | 3034471 | 2021-01-05 | Peru | Piura | 42920 | 6404 | 0 | 36516 | -5.133361 | -80.335861 | 2021-01-06 05:22:16 | Piura, Peru | ||
1062016 | 1062016 | 2021-01-04 | Peru | Piura | 42920 | 6384 | 0 | 36536 | -5.133361 | -80.335861 | 2021-01-05 05:21:49 | Piura, Peru | ||
3230619 | 3230619 | 2021-01-03 | Peru | Piura | 42887 | 6373 | 0 | 36514 | -5.133361 | -80.335861 | 2021-01-04 05:22:02 | Piura, Peru | ||
2227688 | 2227688 | 2021-01-02 | Peru | Piura | 42790 | 6343 | 0 | 36447 | -5.133361 | -80.335861 | 2021-01-03 05:22:52 | Piura, Peru | ||
1137052 | 1137052 | 2021-01-01 | Peru | Piura | 42790 | 6328 | 0 | 36462 | -5.133361 | -80.335861 | 2021-01-02 05:22:33 | Piura, Peru | ||
3695658 | 3695658 | 2020-12-31 | Peru | Piura | 42790 | 6306 | 0 | 36484 | -5.133361 | -80.335861 | 2021-01-01 05:23:07 | Piura, Peru | ||
1010473 | 1010473 | 2020-12-30 | Peru | Piura | 42631 | 6289 | 0 | 36342 | -5.133361 | -80.335861 | 2020-12-31 05:22:49 | Piura, Peru | ||
766488 | 766488 | 2020-12-29 | Peru | Piura | 42571 | 6275 | 0 | 36296 | -5.133361 | -80.335861 | 2020-12-30 05:22:34 | Piura, Peru | ||
3761752 | 3761752 | 2020-12-28 | Peru | Piura | 42560 | 6255 | 0 | 36305 | -5.133361 | -80.335861 | 2020-12-29 05:22:37 | Piura, Peru | ||
3778072 | 3778072 | 2020-12-27 | Peru | Piura | 42524 | 6239 | 0 | 36285 | -5.133361 | -80.335861 | 2020-12-28 05:22:06 | Piura, Peru | ||
2223677 | 2223677 | 2020-12-26 | Peru | Piura | 42524 | 6224 | 0 | 36300 | -5.133361 | -80.335861 | 2020-12-27 05:22:55 | Piura, Peru | ||
202424 | 202424 | 2020-12-25 | Peru | Piura | 42468 | 6215 | 0 | 36253 | -5.133361 | -80.335861 | 2020-12-26 05:22:28 | Piura, Peru | ||
3691647 | 3691647 | 2020-12-24 | Peru | Piura | 42357 | 6205 | 0 | 36152 | -5.133361 | -80.335861 | 2020-12-25 05:22:48 | Piura, Peru | ||
2406999 | 2406999 | 2020-12-23 | Peru | Piura | 42357 | 6195 | 0 | 36162 | -5.133361 | -80.335861 | 2020-12-24 05:23:04 | Piura, Peru | ||
3770045 | 3770045 | 2020-12-22 | Peru | Piura | 42274 | 6184 | 0 | 36090 | -5.133361 | -80.335861 | 2020-12-23 05:22:03 | Piura, Peru | ||
927861 | 927861 | 2020-12-21 | Peru | Piura | 42257 | 6167 | 0 | 36090 | -5.133361 | -80.335861 | 2020-12-22 05:22:33 | Piura, Peru | ||
2119882 | 2119882 | 2020-12-20 | Peru | Piura | 42222 | 6151 | 0 | 36071 | -5.133361 | -80.335861 | 2020-12-21 05:27:58 | Piura, Peru | ||
2931389 | 2931389 | 2020-12-19 | Peru | Piura | 41893 | 6136 | 0 | 35757 | -5.133361 | -80.335861 | 2020-12-20 05:27:32 | Piura, Peru | ||
1901335 | 1901335 | 2020-12-18 | Peru | Piura | 41893 | 6126 | 0 | 35767 | -5.133361 | -80.335861 | 2020-12-19 05:27:52 | Piura, Peru | ||
2128161 | 2128161 | 2020-12-17 | Peru | Piura | 41893 | 6106 | 0 | 35787 | -5.133361 | -80.335861 | 2020-12-18 05:28:18 | Piura, Peru | ||
3149761 | 3149761 | 2020-12-16 | Peru | Piura | 41727 | 6094 | 0 | 35633 | -5.133361 | -80.335861 | 2020-12-17 05:28:12 | Piura, Peru | ||
1034542 | 1034542 | 2020-12-15 | Peru | Piura | 41727 | 6081 | 0 | 35646 | -5.133361 | -80.335861 | 2020-12-16 05:28:04 | Piura, Peru | ||
1751436 | 1751436 | 2020-12-14 | Peru | Piura | 41704 | 6061 | 0 | 35643 | -5.133361 | -80.335861 | 2020-12-15 05:26:38 | Piura, Peru | ||
3847956 | 3847956 | 2020-12-13 | Peru | Piura | 41598 | 6051 | 0 | 35547 | -5.133361 | -80.335861 | 2020-12-14 05:26:27 | Piura, Peru | ||
845738 | 845738 | 2020-12-12 | Peru | Piura | 41598 | 6038 | 0 | 35560 | -5.133361 | -80.335861 | 2020-12-13 05:27:20 | Piura, Peru | ||
860845 | 860845 | 2020-12-11 | Peru | Piura | 41522 | 6016 | 0 | 35506 | -5.133361 | -80.335861 | 2020-12-12 05:26:19 | Piura, Peru | ||
1600387 | 1600387 | 2020-12-10 | Peru | Piura | 41522 | 5997 | 0 | 35525 | -5.133361 | -80.335861 | 2020-12-11 05:26:59 | Piura, Peru | ||
2975396 | 2975396 | 2020-12-09 | Peru | Piura | 41410 | 5985 | 0 | 35425 | -5.133361 | -80.335861 | 2020-12-10 05:26:19 | Piura, Peru | ||
1818956 | 1818956 | 2020-12-08 | Peru | Piura | 41321 | 5965 | 0 | 35356 | -5.133361 | -80.335861 | 2020-12-09 05:28:01 | Piura, Peru | ||
2347592 | 2347592 | 2020-12-07 | Peru | Piura | 41321 | 5949 | 0 | 35372 | -5.133361 | -80.335861 | 2020-12-08 05:27:42 | Piura, Peru | ||
1006462 | 1006462 | 2020-12-06 | Peru | Piura | 41271 | 5933 | 0 | 35338 | -5.133361 | -80.335861 | 2020-12-07 05:26:14 | Piura, Peru | ||
1632471 | 1632471 | 2020-12-05 | Peru | Piura | 41224 | 5918 | 0 | 35306 | -5.133361 | -80.335861 | 2020-12-06 05:26:18 | Piura, Peru | ||
3859999 | 3859999 | 2020-12-04 | Peru | Piura | 41047 | 5900 | 0 | 35147 | -5.133361 | -80.335861 | 2020-12-05 05:27:36 | Piura, Peru | ||
75257 | 75257 | 2020-12-03 | Peru | Piura | 41047 | 5889 | 0 | 35158 | -5.133361 | -80.335861 | 2020-12-04 05:27:27 | Piura, Peru | ||
738469 | 738469 | 2020-12-02 | Peru | Piura | 40857 | 5869 | 0 | 34988 | -5.133361 | -80.335861 | 2020-12-03 05:28:22 | Piura, Peru | ||
2537563 | 2537563 | 2020-12-01 | Peru | Piura | 40857 | 5859 | 0 | 34998 | -5.133361 | -80.335861 | 2020-12-02 05:27:41 | Piura, Peru | ||
1584332 | 1584332 | 2020-11-30 | Peru | Piura | 40819 | 5838 | 0 | 34981 | -5.133361 | -80.335861 | 2020-12-01 05:26:18 | Piura, Peru | ||
3566735 | 3566735 | 2020-11-29 | Peru | Piura | 40819 | 5823 | 0 | 34996 | -5.133361 | -80.335861 | 2020-11-30 05:26:13 | Piura, Peru | ||
2935400 | 2935400 | 2020-11-28 | Peru | Piura | 40747 | 5813 | 0 | 34934 | -5.133361 | -80.335861 | 2020-11-29 05:25:55 | Piura, Peru | ||
392403 | 392403 | 2020-11-27 | Peru | Piura | 40495 | 5799 | 0 | 34696 | -5.133361 | -80.335861 | 2020-11-28 05:25:50 | Piura, Peru | ||
923850 | 923850 | 2020-11-26 | Peru | Piura | 40318 | 5786 | 0 | 34532 | -5.133361 | -80.335861 | 2020-11-27 05:26:53 | Piura, Peru | ||
1972755 | 1972755 | 2020-11-25 | Peru | Piura | 40318 | 5770 | 0 | 34548 | -5.133361 | -80.335861 | 2020-11-26 05:27:44 | Piura, Peru | ||
1350486 | 1350486 | 2020-11-24 | Peru | Piura | 40170 | 5758 | 0 | 34412 | -5.133361 | -80.335861 | 2020-11-25 05:27:20 | Piura, Peru | ||
678480 | 678480 | 2020-11-23 | Peru | Piura | 40160 | 5744 | 0 | 34416 | -5.133361 | -80.335861 | 2020-11-24 05:27:31 | Piura, Peru | ||
3190156 | 3190156 | 2020-11-22 | Peru | Piura | 40115 | 5729 | 0 | 34386 | -5.133361 | -80.335861 | 2020-11-23 05:25:26 | Piura, Peru | ||
3836650 | 3836650 | 2020-11-21 | Peru | Piura | 40115 | 5719 | 0 | 34396 | -5.133361 | -80.335861 | 2020-11-22 05:25:45 | Piura, Peru | ||
2701678 | 2701678 | 2020-11-20 | Peru | Piura | 39946 | 5711 | 0 | 34235 | -5.133361 | -80.335861 | 2020-11-21 05:25:51 | Piura, Peru | ||
821738 | 821738 | 2020-11-19 | Peru | Piura | 39724 | 5701 | 0 | 34023 | -5.133361 | -80.335861 | 2020-11-20 05:26:28 | Piura, Peru | ||
122872 | 122872 | 2020-11-18 | Peru | Piura | 39724 | 5685 | 0 | 34039 | -5.133361 | -80.335861 | 2020-11-19 05:25:23 | Piura, Peru | ||
3338760 | 3338760 | 2020-11-17 | Peru | Piura | 39634 | 5671 | 0 | 33963 | -5.133361 | -80.335861 | 2020-11-18 05:40:31 | Piura, Peru | ||
3169805 | 3169805 | 2020-11-16 | Peru | Piura | 39607 | 5659 | 0 | 33948 | -5.133361 | -80.335861 | 2020-11-17 05:25:54 | Piura, Peru | ||
2880373 | 2880373 | 2020-11-15 | Peru | Piura | 39535 | 5648 | 0 | 33887 | -5.133361 | -80.335861 | 2020-11-16 05:25:57 | Piura, Peru | ||
2915351 | 2915351 | 2020-11-14 | Peru | Piura | 39431 | 5640 | 0 | 33791 | -5.133361 | -80.335861 | 2020-11-15 05:26:53 | Piura, Peru | ||
2785173 | 2785173 | 2020-11-13 | Peru | Piura | 39339 | 5626 | 0 | 33713 | -5.133361 | -80.335861 | 2020-11-14 05:25:37 | Piura, Peru | ||
864938 | 864938 | 2020-11-12 | Peru | Piura | 39265 | 5618 | 0 | 33647 | -5.133361 | -80.335861 | 2020-11-13 05:25:30 | Piura, Peru | ||
3440982 | 3440982 | 2020-11-11 | Peru | Piura | 39158 | 5613 | 0 | 33545 | -5.133361 | -80.335861 | 2020-11-12 05:25:55 | Piura, Peru | ||
272322 | 272322 | 2020-11-10 | Peru | Piura | 39087 | 5607 | 0 | 33480 | -5.133361 | -80.335861 | 2020-11-11 05:25:30 | Piura, Peru | ||
1988799 | 1988799 | 2020-11-09 | Peru | Piura | 39038 | 5595 | 0 | 33443 | -5.133361 | -80.335861 | 2020-11-10 05:40:07 | Piura, Peru | ||
1728651 | 1728651 | 2020-11-08 | Peru | Piura | 38979 | 5589 | 0 | 33390 | -5.133361 | -80.335861 | 2020-11-09 05:25:45 | Piura, Peru | ||
1544111 | 1544111 | 2020-11-07 | Peru | Piura | 38917 | 5584 | 0 | 33333 | -5.133361 | -80.335861 | 2020-11-08 05:24:56 | Piura, Peru | ||
376349 | 376349 | 2020-11-06 | Peru | Piura | 38814 | 5571 | 0 | 33243 | -5.133361 | -80.335861 | 2020-11-07 05:24:52 | Piura, Peru | ||
892287 | 892287 | 2020-11-05 | Peru | Piura | 38814 | 5561 | 0 | 33253 | -5.133361 | -80.335861 | 2020-11-06 05:24:55 | Piura, Peru | ||
2919349 | 2919349 | 2020-11-04 | Peru | Piura | 38758 | 5551 | 0 | 33207 | -5.133361 | -80.335861 | 2020-11-05 06:05:03 | Piura, Peru | ||
2498186 | 2498186 | 2020-11-03 | Peru | Piura | 38440 | 5542 | 0 | 32898 | -5.133361 | -80.335861 | 2020-11-04 05:25:09 | Piura, Peru | ||
3304361 | 3304361 | 2020-11-02 | Peru | Piura | 38440 | 5533 | 0 | 32907 | -5.133361 | -80.335861 | 2020-11-03 06:00:16 | Piura, Peru | ||
3409610 | 3409610 | 2020-11-01 | Peru | Piura | 38440 | 5525 | 0 | 32915 | -5.133361 | -80.335861 | 2020-11-02 05:25:04 | Piura, Peru | ||
2080099 | 2080099 | 2020-10-31 | Peru | Piura | 38324 | 5519 | 0 | 32805 | -5.133361 | -80.335861 | 2020-11-01 04:36:19 | Piura, Peru | ||
2243552 | 2243552 | 2020-10-30 | Peru | Piura | 38226 | 5512 | 0 | 32714 | -5.133361 | -80.335861 | 2020-10-31 04:24:44 | Piura, Peru | ||
210407 | 210407 | 2020-10-29 | Peru | Piura | 38151 | 5505 | 0 | 32646 | -5.133361 | -80.335861 | 2020-10-30 04:24:49 | Piura, Peru | ||
754469 | 754469 | 2020-10-28 | Peru | Piura | 38079 | 5500 | 0 | 32579 | -5.133361 | -80.335861 | 2020-10-29 04:24:49 | Piura, Peru | ||
1452753 | 1452753 | 2020-10-27 | Peru | Piura | 38016 | 5495 | 0 | 32521 | -5.133361 | -80.335861 | 2020-10-28 04:24:39 | Piura, Peru | ||
3480477 | 3480477 | 2020-10-26 | Peru | Piura | 37983 | 5489 | 0 | 32494 | -5.133361 | -80.335861 | 2020-10-27 04:24:45 | Piura, Peru | ||
8498 | 8498 | 2020-10-25 | Peru | Piura | 37983 | 5487 | 0 | 32496 | -5.133361 | -80.335861 | 2020-10-26 04:25:02 | Piura, Peru | ||
3651735 | 3651735 | 2020-10-24 | Peru | Piura | 37787 | 5477 | 0 | 32310 | -5.133361 | -80.335861 | 2020-10-25 04:24:36 | Piura, Peru | ||
1053990 | 1053990 | 2020-10-23 | Peru | Piura | 37696 | 5471 | 0 | 32225 | -5.133361 | -80.335861 | 2020-10-24 04:24:46 | Piura, Peru | ||
1177660 | 1177660 | 2020-10-22 | Peru | Piura | 37696 | 5463 | 0 | 32233 | -5.133361 | -80.335861 | 2020-10-23 04:24:46 | Piura, Peru | ||
2191765 | 2191765 | 2020-10-21 | Peru | Piura | 37496 | 5454 | 0 | 32042 | -5.133361 | -80.335861 | 2020-10-22 04:24:27 | Piura, Peru | ||
3990776 | 3990776 | 2020-10-20 | Peru | Piura | 37433 | 5446 | 0 | 31987 | -5.133361 | -80.335861 | 2020-10-21 04:24:14 | Piura, Peru | ||
1794796 | 1794796 | 2020-10-19 | Peru | Piura | 37369 | 5438 | 0 | 31931 | -5.133361 | -80.335861 | 2020-10-20 04:24:22 | Piura, Peru | ||
762480 | 762480 | 2020-10-18 | Peru | Piura | 37266 | 5430 | 0 | 31836 | -5.133361 | -80.335861 | 2020-10-19 04:24:16 | Piura, Peru | ||
1026518 | 1026518 | 2020-10-17 | Peru | Piura | 37168 | 5417 | 0 | 31751 | -5.133361 | -80.335861 | 2020-10-18 04:24:25 | Piura, Peru | ||
2857013 | 2857013 | 2020-10-16 | Peru | Piura | 37101 | 5410 | 0 | 31691 | -5.133361 | -80.335861 | 2020-10-17 04:24:12 | Piura, Peru | ||
786543 | 786543 | 2020-10-15 | Peru | Piura | 37101 | 5405 | 0 | 31696 | -5.133361 | -80.335861 | 2020-10-16 04:24:01 | Piura, Peru | ||
79254 | 79254 | 2020-10-14 | Peru | Piura | 36943 | 5398 | 0 | 31545 | -5.133361 | -80.335861 | 2020-10-15 04:24:28 | Piura, Peru | ||
3782069 | 3782069 | 2020-10-13 | Peru | Piura | 36943 | 5392 | 0 | 31551 | -5.133361 | -80.335861 | 2020-10-14 04:24:05 | Piura, Peru | ||
2291609 | 2291609 | 2020-10-12 | Peru | Piura | 36714 | 5380 | 0 | 31334 | -5.133361 | -80.335861 | 2020-10-13 04:24:02 | Piura, Peru | ||
3786062 | 3786062 | 2020-10-11 | Peru | Piura | 36648 | 5366 | 0 | 31282 | -5.133361 | -80.335861 | 2020-10-12 04:23:45 | Piura, Peru | ||
2602200 | 2602200 | 2020-10-10 | Peru | Piura | 36445 | 5359 | 0 | 31086 | -5.133361 | -80.335861 | 2020-10-11 04:23:46 | Piura, Peru | ||
817733 | 817733 | 2020-10-09 | Peru | Piura | 36135 | 5346 | 0 | 30789 | -5.133361 | -80.335861 | 2020-10-10 04:23:57 | Piura, Peru | ||
2689848 | 2689848 | 2020-10-08 | Peru | Piura | 36028 | 5336 | 0 | 30692 | -5.133361 | -80.335861 | 2020-10-09 04:23:59 | Piura, Peru | ||
1041990 | 1041990 | 2020-10-07 | Peru | Piura | 35927 | 5328 | 0 | 30599 | -5.133361 | -80.335861 | 2020-10-08 04:23:56 | Piura, Peru | ||
3117651 | 3117651 | 2020-10-06 | Peru | Piura | 35809 | 5318 | 0 | 30491 | -5.133361 | -80.335861 | 2020-10-07 04:23:40 | Piura, Peru | ||
3802063 | 3802063 | 2020-10-05 | Peru | Piura | 35735 | 5314 | 0 | 30421 | -5.133361 | -80.335861 | 2020-10-06 04:23:33 | Piura, Peru | ||
1822953 | 1822953 | 2020-10-04 | Peru | Piura | 35469 | 5303 | 0 | 30166 | -5.133361 | -80.335861 | 2020-10-05 04:23:33 | Piura, 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]);