daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Puglia" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-22 | Italy | Puglia | 4992 | 555 | 4001 | 436 | 41.12559576 | 16.86736689 | 2020-08-23 04:27:48 | Puglia, Italy | ||
2020-08-23 | Italy | Puglia | 5025 | 555 | 4003 | 467 | 41.12559576 | 16.86736689 | 2020-08-24 04:27:56 | Puglia, Italy | ||
2020-08-24 | Italy | Puglia | 5070 | 555 | 4010 | 505 | 41.12559576 | 16.86736689 | 2020-08-25 04:28:02 | Puglia, Italy | ||
2020-08-25 | Italy | Puglia | 5119 | 555 | 4016 | 548 | 41.12559576 | 16.86736689 | 2020-08-26 04:28:11 | Puglia, Italy | ||
2020-08-26 | Italy | Puglia | 5170 | 555 | 4018 | 597 | 41.12559576 | 16.86736689 | 2020-08-27 04:28:15 | Puglia, Italy | ||
2020-08-27 | Italy | Puglia | 5217 | 556 | 4024 | 637 | 41.12559576 | 16.86736689 | 2020-08-28 04:28:11 | Puglia, Italy | ||
2020-08-28 | Italy | Puglia | 5268 | 556 | 4028 | 684 | 41.12559576 | 16.86736689 | 2020-08-29 04:28:19 | Puglia, Italy | ||
2020-08-29 | Italy | Puglia | 5333 | 556 | 4029 | 748 | 41.12559576 | 16.86736689 | 2020-08-30 04:28:22 | Puglia, Italy | ||
2020-08-30 | Italy | Puglia | 5402 | 556 | 4029 | 817 | 41.12559576 | 16.86736689 | 2020-08-31 04:28:27 | Puglia, Italy | ||
2020-08-31 | Italy | Puglia | 5440 | 556 | 4040 | 844 | 41.12559576 | 16.86736689 | 2020-09-01 04:28:31 | Puglia, Italy | ||
2020-09-01 | Italy | Puglia | 5479 | 557 | 4062 | 860 | 41.12559576 | 16.86736689 | 2020-09-02 04:28:25 | Puglia, Italy | ||
2020-09-02 | Italy | Puglia | 5546 | 557 | 4067 | 922 | 41.12559576 | 16.86736689 | 2020-09-03 04:28:22 | Puglia, Italy | ||
2020-09-03 | Italy | Puglia | 5624 | 560 | 4078 | 986 | 41.12559576 | 16.86736689 | 2020-09-04 04:28:26 | Puglia, Italy | ||
2020-09-04 | Italy | Puglia | 5741 | 560 | 4095 | 1086 | 41.12559576 | 16.86736689 | 2020-09-05 04:28:19 | Puglia, Italy | ||
2020-09-05 | Italy | Puglia | 5796 | 562 | 4112 | 1122 | 41.12559576 | 16.86736689 | 2020-09-06 04:28:33 | Puglia, Italy | ||
2020-09-06 | Italy | Puglia | 5856 | 563 | 4126 | 1167 | 41.12559576 | 16.86736689 | 2020-09-07 04:28:30 | Puglia, Italy | ||
2020-09-07 | Italy | Puglia | 5899 | 565 | 4137 | 1197 | 41.12559576 | 16.86736689 | 2020-09-08 04:28:25 | Puglia, Italy | ||
2020-09-08 | Italy | Puglia | 6042 | 567 | 4154 | 1321 | 41.12559576 | 16.86736689 | 2020-09-09 04:28:48 | Puglia, Italy | ||
2020-09-09 | Italy | Puglia | 6139 | 567 | 4158 | 1414 | 41.12559576 | 16.86736689 | 2020-09-10 04:29:01 | Puglia, Italy | ||
2020-09-10 | Italy | Puglia | 6209 | 570 | 4169 | 1470 | 41.12559576 | 16.86736689 | 2020-09-11 04:46:23 | Puglia, Italy | ||
2020-09-11 | Italy | Puglia | 6291 | 570 | 4175 | 1546 | 41.12559576 | 16.86736689 | 2020-09-12 04:25:05 | Puglia, Italy | ||
2020-09-12 | Italy | Puglia | 6367 | 570 | 4198 | 1599 | 41.12559576 | 16.86736689 | 2020-09-13 04:30:52 | Puglia, Italy | ||
2020-09-13 | Italy | Puglia | 6449 | 570 | 4201 | 1678 | 41.12559576 | 16.86736689 | 2020-09-14 04:26:00 | Puglia, Italy | ||
2020-09-14 | Italy | Puglia | 6510 | 572 | 4225 | 1713 | 41.12559576 | 16.86736689 | 2020-09-15 03:22:50 | Puglia, Italy | ||
2020-09-15 | Italy | Puglia | 6586 | 573 | 4237 | 1776 | 41.12559576 | 16.86736689 | 2020-09-16 04:22:53 | Puglia, Italy | ||
2020-09-16 | Italy | Puglia | 6689 | 574 | 4252 | 1863 | 41.12559576 | 16.86736689 | 2020-09-17 04:22:00 | Puglia, Italy | ||
2020-09-17 | Italy | Puglia | 6752 | 575 | 4262 | 1915 | 41.12559576 | 16.86736689 | 2020-09-18 05:05:00 | Puglia, Italy | ||
2020-09-18 | Italy | Puglia | 6836 | 577 | 4273 | 1986 | 41.12559576 | 16.86736689 | 2020-09-19 04:22:00 | Puglia, Italy | ||
2020-09-19 | Italy | Puglia | 6944 | 578 | 4278 | 2088 | 41.12559576 | 16.86736689 | 2020-09-20 04:22:00 | Puglia, Italy | ||
2020-09-20 | Italy | Puglia | 6994 | 579 | 4287 | 2128 | 41.12559576 | 16.86736689 | 2020-09-21 04:23:00 | Puglia, Italy | ||
2020-09-21 | Italy | Puglia | 7075 | 580 | 4306 | 2189 | 41.12559576 | 16.86736689 | 2020-09-22 04:23:00 | Puglia, Italy | ||
2020-09-22 | Italy | Puglia | 7142 | 581 | 4371 | 2190 | 41.12559576 | 16.86736689 | 2020-09-23 04:23:00 | Puglia, Italy | ||
2020-09-23 | Italy | Puglia | 7231 | 583 | 4426 | 2222 | 41.12559576 | 16.86736689 | 2020-09-24 04:23:00 | Puglia, Italy | ||
2020-09-24 | Italy | Puglia | 7304 | 586 | 4455 | 2263 | 41.12559576 | 16.86736689 | 2020-09-25 04:23:00 | Puglia, Italy | ||
2020-09-25 | Italy | Puglia | 7394 | 587 | 4498 | 2309 | 41.12559576 | 16.86736689 | 2020-09-26 04:23:00 | Puglia, Italy | ||
2020-09-26 | Italy | Puglia | 7445 | 590 | 4518 | 2337 | 41.12559576 | 16.86736689 | 2020-09-27 04:23:00 | Puglia, Italy | ||
2020-09-27 | Italy | Puglia | 7521 | 590 | 4527 | 2404 | 41.12559576 | 16.86736689 | 2020-09-28 04:23:00 | Puglia, Italy | ||
2020-09-28 | Italy | Puglia | 7611 | 592 | 4600 | 2419 | 41.12559576 | 16.86736689 | 2020-09-29 04:23:42 | Puglia, Italy | ||
2020-09-29 | Italy | Puglia | 7687 | 592 | 4662 | 2433 | 41.12559576 | 16.86736689 | 2020-09-30 04:23:33 | Puglia, Italy | ||
2020-09-30 | Italy | Puglia | 7786 | 595 | 4675 | 2516 | 41.12559576 | 16.86736689 | 2020-10-01 04:23:42 | Puglia, Italy | ||
2020-10-01 | Italy | Puglia | 7900 | 596 | 4697 | 2607 | 41.12559576 | 16.86736689 | 2020-10-02 04:23:51 | Puglia, Italy | ||
2020-10-02 | Italy | Puglia | 7972 | 597 | 4712 | 2663 | 41.12559576 | 16.86736689 | 2020-10-03 04:23:40 | Puglia, Italy | ||
2020-10-03 | Italy | Puglia | 8083 | 598 | 4724 | 2761 | 41.12559576 | 16.86736689 | 2020-10-04 04:23:44 | Puglia, Italy | ||
2020-10-04 | Italy | Puglia | 8234 | 598 | 4739 | 2897 | 41.12559576 | 16.86736689 | 2020-10-05 04:23:33 | Puglia, Italy | ||
2020-10-05 | Italy | Puglia | 8317 | 599 | 4762 | 2956 | 41.12559576 | 16.86736689 | 2020-10-06 04:23:33 | Puglia, Italy | ||
2020-10-06 | Italy | Puglia | 8423 | 603 | 4829 | 2991 | 41.12559576 | 16.86736689 | 2020-10-07 04:23:40 | Puglia, Italy | ||
2020-10-07 | Italy | Puglia | 8619 | 603 | 4883 | 3133 | 41.12559576 | 16.86736689 | 2020-10-08 04:23:56 | Puglia, Italy | ||
2020-10-08 | Italy | Puglia | 8867 | 604 | 4929 | 3334 | 41.12559576 | 16.86736689 | 2020-10-09 04:23:59 | Puglia, Italy | ||
2020-10-09 | Italy | Puglia | 9116 | 606 | 4960 | 3550 | 41.12559576 | 16.86736689 | 2020-10-10 04:23:57 | Puglia, Italy | ||
2020-10-10 | Italy | Puglia | 9300 | 607 | 4982 | 3711 | 41.12559576 | 16.86736689 | 2020-10-11 04:23:46 | Puglia, Italy | ||
2020-10-11 | Italy | Puglia | 9512 | 608 | 5097 | 3807 | 41.12559576 | 16.86736689 | 2020-10-12 04:23:45 | Puglia, Italy | ||
2020-10-12 | Italy | Puglia | 9669 | 614 | 5142 | 3913 | 41.12559576 | 16.86736689 | 2020-10-13 04:24:02 | Puglia, Italy | ||
2020-10-13 | Italy | Puglia | 9849 | 616 | 5235 | 3998 | 41.12559576 | 16.86736689 | 2020-10-14 04:24:05 | Puglia, Italy | ||
2020-10-14 | Italy | Puglia | 10164 | 618 | 5317 | 4229 | 41.12559576 | 16.86736689 | 2020-10-15 04:24:28 | Puglia, Italy | ||
2020-10-15 | Italy | Puglia | 10421 | 625 | 5387 | 4409 | 41.12559576 | 16.86736689 | 2020-10-16 04:24:01 | Puglia, Italy | ||
2020-10-16 | Italy | Puglia | 10734 | 630 | 5431 | 4673 | 41.12559576 | 16.86736689 | 2020-10-17 04:24:12 | Puglia, Italy | ||
2020-10-17 | Italy | Puglia | 11084 | 632 | 5472 | 4980 | 41.12559576 | 16.86736689 | 2020-10-18 04:24:25 | Puglia, Italy | ||
2020-10-18 | Italy | Puglia | 11385 | 635 | 5517 | 5233 | 41.12559576 | 16.86736689 | 2020-10-19 04:24:16 | Puglia, Italy | ||
2020-10-19 | Italy | Puglia | 11706 | 639 | 5604 | 5463 | 41.12559576 | 16.86736689 | 2020-10-20 04:24:22 | Puglia, Italy | ||
2020-10-20 | Italy | Puglia | 12001 | 642 | 5629 | 5730 | 41.12559576 | 16.86736689 | 2020-10-21 04:24:14 | Puglia, Italy | ||
2020-10-21 | Italy | Puglia | 12325 | 644 | 5690 | 5991 | 41.12559576 | 16.86736689 | 2020-10-22 04:24:27 | Puglia, Italy | ||
2020-10-22 | Italy | Puglia | 12810 | 645 | 5886 | 6279 | 41.12559576 | 16.86736689 | 2020-10-23 04:24:46 | Puglia, Italy | ||
2020-10-23 | Italy | Puglia | 13400 | 646 | 5926 | 6828 | 41.12559576 | 16.86736689 | 2020-10-24 04:24:46 | Puglia, Italy | ||
2020-10-24 | Italy | Puglia | 14031 | 656 | 5977 | 7398 | 41.12559576 | 16.86736689 | 2020-10-25 04:24:36 | Puglia, Italy | ||
2020-10-25 | Italy | Puglia | 14546 | 663 | 6011 | 7872 | 41.12559576 | 16.86736689 | 2020-10-26 04:25:02 | Puglia, Italy | ||
2020-10-26 | Italy | Puglia | 14970 | 673 | 6018 | 8279 | 41.12559576 | 16.86736689 | 2020-10-27 04:24:45 | Puglia, Italy | ||
2020-10-27 | Italy | Puglia | 15581 | 686 | 6187 | 8708 | 41.12559576 | 16.86736689 | 2020-10-28 04:24:39 | Puglia, Italy | ||
2020-10-28 | Italy | Puglia | 16353 | 699 | 6217 | 9437 | 41.12559576 | 16.86736689 | 2020-10-29 04:24:49 | Puglia, Italy | ||
2020-10-29 | Italy | Puglia | 17069 | 706 | 6361 | 10002 | 41.12559576 | 16.86736689 | 2020-10-30 04:24:49 | Puglia, Italy | ||
2020-10-30 | Italy | Puglia | 17860 | 713 | 6448 | 10699 | 41.12559576 | 16.86736689 | 2020-10-31 04:24:44 | Puglia, Italy | ||
2020-10-31 | Italy | Puglia | 18622 | 723 | 6506 | 11393 | 41.12559576 | 16.86736689 | 2020-11-01 04:36:19 | Puglia, Italy | ||
2020-11-01 | Italy | Puglia | 19302 | 731 | 6539 | 12032 | 41.12559576 | 16.86736689 | 2020-11-02 05:25:04 | Puglia, Italy | ||
2020-11-02 | Italy | Puglia | 19928 | 740 | 6619 | 12569 | 41.12559576 | 16.86736689 | 2020-11-03 06:00:16 | Puglia, Italy | ||
2020-11-03 | Italy | Puglia | 21091 | 753 | 6813 | 13525 | 41.12559576 | 16.86736689 | 2020-11-04 05:25:09 | Puglia, Italy | ||
2020-11-04 | Italy | Puglia | 22085 | 763 | 7089 | 14233 | 41.12559576 | 16.86736689 | 2020-11-05 06:05:03 | Puglia, Italy | ||
2020-11-05 | Italy | Puglia | 22935 | 789 | 7323 | 14823 | 41.12559576 | 16.86736689 | 2020-11-06 05:24:55 | Puglia, Italy | ||
2020-11-06 | Italy | Puglia | 23881 | 802 | 7450 | 15629 | 41.12559576 | 16.86736689 | 2020-11-07 05:24:52 | Puglia, Italy | ||
2020-11-07 | Italy | Puglia | 24935 | 816 | 7546 | 16573 | 41.12559576 | 16.86736689 | 2020-11-08 05:24:56 | Puglia, Italy | ||
2020-11-08 | Italy | Puglia | 25701 | 837 | 7677 | 17187 | 41.12559576 | 16.86736689 | 2020-11-09 05:25:45 | Puglia, Italy | ||
2020-11-09 | Italy | Puglia | 26431 | 844 | 7774 | 17813 | 41.12559576 | 16.86736689 | 2020-11-10 05:40:07 | Puglia, Italy | ||
2020-11-10 | Italy | Puglia | 27676 | 869 | 7921 | 18886 | 41.12559576 | 16.86736689 | 2020-11-11 05:25:30 | Puglia, Italy | ||
2020-11-11 | Italy | Puglia | 29008 | 896 | 8013 | 20099 | 41.12559576 | 16.86736689 | 2020-11-12 05:25:55 | Puglia, Italy | ||
2020-11-12 | Italy | Puglia | 30442 | 935 | 8252 | 21255 | 41.12559576 | 16.86736689 | 2020-11-13 05:25:30 | Puglia, Italy | ||
2020-11-13 | Italy | Puglia | 31792 | 957 | 8324 | 22511 | 41.12559576 | 16.86736689 | 2020-11-14 05:25:37 | Puglia, Italy | ||
2020-11-14 | Italy | Puglia | 33533 | 973 | 8560 | 24000 | 41.12559576 | 16.86736689 | 2020-11-15 05:26:53 | Puglia, Italy | ||
2020-11-15 | Italy | Puglia | 34438 | 985 | 8751 | 24702 | 41.12559576 | 16.86736689 | 2020-11-16 05:25:57 | Puglia, Italy | ||
2020-11-16 | Italy | Puglia | 35482 | 1021 | 8936 | 25525 | 41.12559576 | 16.86736689 | 2020-11-17 05:25:54 | Puglia, Italy | ||
2020-11-17 | Italy | Puglia | 36716 | 1057 | 9052 | 26607 | 41.12559576 | 16.86736689 | 2020-11-18 05:40:31 | Puglia, Italy | ||
2020-11-18 | Italy | Puglia | 38084 | 1085 | 9385 | 27614 | 41.12559576 | 16.86736689 | 2020-11-19 05:25:23 | Puglia, Italy | ||
2020-11-19 | Italy | Puglia | 39347 | 1113 | 9734 | 28500 | 41.12559576 | 16.86736689 | 2020-11-20 05:26:28 | Puglia, Italy | ||
2020-11-20 | Italy | Puglia | 40803 | 1129 | 10240 | 29434 | 41.12559576 | 16.86736689 | 2020-11-21 05:25:51 | Puglia, Italy | ||
2020-11-21 | Italy | Puglia | 42180 | 1148 | 10612 | 30420 | 41.12559576 | 16.86736689 | 2020-11-22 05:25:45 | Puglia, Italy | ||
2020-11-22 | Italy | Puglia | 43507 | 1180 | 10975 | 31352 | 41.12559576 | 16.86736689 | 2020-11-23 05:25:26 | Puglia, Italy | ||
2020-11-23 | Italy | Puglia | 44487 | 1220 | 11288 | 31979 | 41.12559576 | 16.86736689 | 2020-11-24 05:27:31 | Puglia, Italy | ||
2020-11-24 | Italy | Puglia | 46054 | 1272 | 11823 | 32959 | 41.12559576 | 16.86736689 | 2020-11-25 05:27:20 | Puglia, Italy | ||
2020-11-25 | Italy | Puglia | 47565 | 1302 | 12192 | 34071 | 41.12559576 | 16.86736689 | 2020-11-26 05:27:44 | Puglia, Italy | ||
2020-11-26 | Italy | Puglia | 49001 | 1354 | 12668 | 34979 | 41.12559576 | 16.86736689 | 2020-11-27 05:26:53 | Puglia, Italy | ||
2020-11-27 | Italy | Puglia | 50738 | 1402 | 12919 | 36417 | 41.12559576 | 16.86736689 | 2020-11-28 05:25:50 | Puglia, Italy | ||
2020-11-28 | Italy | Puglia | 52311 | 1432 | 13225 | 37654 | 41.12559576 | 16.86736689 | 2020-11-29 05:25:55 | Puglia, Italy | ||
2020-11-29 | Italy | Puglia | 53218 | 1453 | 13521 | 38244 | 41.12559576 | 16.86736689 | 2020-11-30 05:26:13 | Puglia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;