johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Puglia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235360 | 2235360 | 2022-06-12 | Italy | Puglia | 1147883 | 8555 | 0 | 41.12559576 | 16.86736689 | 2022-06-13 04:21:14 | Puglia, Italy | |||
3141558 | 3141558 | 2022-06-11 | Italy | Puglia | 1146752 | 8553 | 0 | 41.12559576 | 16.86736689 | 2022-06-12 04:20:53 | Puglia, Italy | |||
1944474 | 1944474 | 2022-06-10 | Italy | Puglia | 1145285 | 8552 | 0 | 41.12559576 | 16.86736689 | 2022-06-11 04:21:01 | Puglia, Italy | |||
3157613 | 3157613 | 2022-06-09 | Italy | Puglia | 1143925 | 8550 | 0 | 41.12559576 | 16.86736689 | 2022-06-10 04:20:55 | Puglia, Italy | |||
1421080 | 1421080 | 2022-06-08 | Italy | Puglia | 1142378 | 8545 | 0 | 41.12559576 | 16.86736689 | 2022-06-09 04:20:54 | Puglia, Italy | |||
3726194 | 3726194 | 2022-06-07 | Italy | Puglia | 1141031 | 8533 | 0 | 41.12559576 | 16.86736689 | 2022-06-08 04:20:55 | Puglia, Italy | |||
3887596 | 3887596 | 2022-06-06 | Italy | Puglia | 1139293 | 8529 | 0 | 41.12559576 | 16.86736689 | 2022-06-07 04:21:08 | Puglia, Italy | |||
3507365 | 3507365 | 2022-06-05 | Italy | Puglia | 1138662 | 8528 | 0 | 41.12559576 | 16.86736689 | 2022-06-06 04:20:57 | Puglia, Italy | |||
3527442 | 3527442 | 2022-06-04 | Italy | Puglia | 1137800 | 8523 | 0 | 41.12559576 | 16.86736689 | 2022-06-05 04:20:55 | Puglia, Italy | |||
3133528 | 3133528 | 2022-06-03 | Italy | Puglia | 1136215 | 8517 | 0 | 41.12559576 | 16.86736689 | 2022-06-04 04:20:58 | Puglia, Italy | |||
3578603 | 3578603 | 2022-06-02 | Italy | Puglia | 1135785 | 8515 | 0 | 41.12559576 | 16.86736689 | 2022-06-03 04:20:58 | Puglia, Italy | |||
970896 | 970896 | 2022-06-01 | Italy | Puglia | 1134580 | 8507 | 0 | 41.12559576 | 16.86736689 | 2022-06-02 05:20:39 | Puglia, Italy | |||
229203 | 229203 | 2022-05-31 | Italy | Puglia | 1133374 | 8504 | 0 | 41.12559576 | 16.86736689 | 2022-06-01 04:20:55 | Puglia, Italy | |||
3185968 | 3185968 | 2022-05-30 | Italy | Puglia | 1131618 | 8493 | 0 | 41.12559576 | 16.86736689 | 2022-05-31 04:20:51 | Puglia, Italy | |||
3198117 | 3198117 | 2022-05-29 | Italy | Puglia | 1131100 | 8492 | 0 | 41.12559576 | 16.86736689 | 2022-05-30 04:20:50 | Puglia, Italy | |||
2724995 | 2724995 | 2022-05-28 | Italy | Puglia | 1130144 | 8491 | 0 | 41.12559576 | 16.86736689 | 2022-05-29 04:20:53 | Puglia, Italy | |||
1314176 | 1314176 | 2022-05-27 | Italy | Puglia | 1129043 | 8485 | 0 | 41.12559576 | 16.86736689 | 2022-05-28 04:21:07 | Puglia, Italy | |||
1849968 | 1849968 | 2022-05-26 | Italy | Puglia | 1127434 | 8471 | 0 | 41.12559576 | 16.86736689 | 2022-05-27 04:20:56 | Puglia, Italy | |||
2047844 | 2047844 | 2022-05-25 | Italy | Puglia | 1125956 | 8467 | 0 | 41.12559576 | 16.86736689 | 2022-05-26 04:20:50 | Puglia, Italy | |||
2999282 | 2999282 | 2022-05-24 | Italy | Puglia | 1124395 | 8456 | 0 | 41.12559576 | 16.86736689 | 2022-05-25 04:20:56 | Puglia, Italy | |||
3593003 | 3593003 | 2022-05-23 | Italy | Puglia | 1121988 | 8442 | 0 | 41.12559576 | 16.86736689 | 2022-05-24 04:20:57 | Puglia, Italy | |||
621855 | 621855 | 2022-05-22 | Italy | Puglia | 1125956 | 8467 | 0 | 41.12559576 | 16.86736689 | 2022-05-26 04:20:50 | Puglia, Italy | |||
1109551 | 1109551 | 2022-05-21 | Italy | Puglia | 1120220 | 8442 | 0 | 41.12559576 | 16.86736689 | 2022-05-22 04:20:52 | Puglia, Italy | |||
1169175 | 1169175 | 2022-05-20 | Italy | Puglia | 1118588 | 8439 | 0 | 41.12559576 | 16.86736689 | 2022-05-21 04:20:58 | Puglia, Italy | |||
3895938 | 3895938 | 2022-05-19 | Italy | Puglia | 1116827 | 8433 | 0 | 41.12559576 | 16.86736689 | 2022-05-20 04:20:57 | Puglia, Italy | |||
1184722 | 1184722 | 2022-05-18 | Italy | Puglia | 1114959 | 8420 | 0 | 41.12559576 | 16.86736689 | 2022-05-19 04:20:54 | Puglia, Italy | |||
3582619 | 3582619 | 2022-05-17 | Italy | Puglia | 1113071 | 8411 | 0 | 41.12559576 | 16.86736689 | 2022-05-18 04:20:50 | Puglia, Italy | |||
1503576 | 1503576 | 2022-05-16 | Italy | Puglia | 1109716 | 8397 | 0 | 41.12559576 | 16.86736689 | 2022-05-17 04:20:59 | Puglia, Italy | |||
2083935 | 2083935 | 2022-05-15 | Italy | Puglia | 1108902 | 8396 | 0 | 41.12559576 | 16.86736689 | 2022-05-16 04:20:47 | Puglia, Italy | |||
3354646 | 3354646 | 2022-05-14 | Italy | Puglia | 1107179 | 8393 | 0 | 41.12559576 | 16.86736689 | 2022-05-15 04:20:53 | Puglia, Italy | |||
658291 | 658291 | 2022-05-13 | Italy | Puglia | 1104883 | 8386 | 0 | 41.12559576 | 16.86736689 | 2022-05-14 04:20:48 | Puglia, Italy | |||
2533374 | 2533374 | 2022-05-12 | Italy | Puglia | 1102284 | 8377 | 0 | 41.12559576 | 16.86736689 | 2022-05-13 04:20:51 | Puglia, Italy | |||
3444820 | 3444820 | 2022-05-11 | Italy | Puglia | 1099404 | 8368 | 0 | 41.12559576 | 16.86736689 | 2022-05-12 04:20:54 | Puglia, Italy | |||
3535437 | 3535437 | 2022-05-10 | Italy | Puglia | 1096731 | 8360 | 0 | 41.12559576 | 16.86736689 | 2022-05-11 04:20:48 | Puglia, Italy | |||
221972 | 221972 | 2022-05-09 | Italy | Puglia | 1092617 | 8353 | 0 | 41.12559576 | 16.86736689 | 2022-05-10 04:20:50 | Puglia, Italy | |||
2331357 | 2331357 | 2022-05-08 | Italy | Puglia | 1091408 | 8349 | 0 | 41.12559576 | 16.86736689 | 2022-05-09 04:20:54 | Puglia, Italy | |||
360319 | 360319 | 2022-05-07 | Italy | Puglia | 1089351 | 8346 | 0 | 41.12559576 | 16.86736689 | 2022-05-08 04:20:49 | Puglia, Italy | |||
1397670 | 1397670 | 2022-05-06 | Italy | Puglia | 1086402 | 8337 | 0 | 41.12559576 | 16.86736689 | 2022-05-07 04:21:09 | Puglia, Italy | |||
2598025 | 2598025 | 2022-05-05 | Italy | Puglia | 1083293 | 8331 | 0 | 41.12559576 | 16.86736689 | 2022-05-06 04:21:00 | Puglia, Italy | |||
3265474 | 3265474 | 2022-05-04 | Italy | Puglia | 1079385 | 8319 | 0 | 41.12559576 | 16.86736689 | 2022-05-05 04:20:55 | Puglia, Italy | |||
1572113 | 1572113 | 2022-05-03 | Italy | Puglia | 1076284 | 8309 | 0 | 41.12559576 | 16.86736689 | 2022-05-04 04:20:59 | Puglia, Italy | |||
463373 | 463373 | 2022-05-02 | Italy | Puglia | 1071518 | 8293 | 0 | 41.12559576 | 16.86736689 | 2022-05-03 04:21:00 | Puglia, Italy | |||
3916012 | 3916012 | 2022-05-01 | Italy | Puglia | 1069433 | 8285 | 0 | 41.12559576 | 16.86736689 | 2022-05-02 04:21:10 | Puglia, Italy | |||
2840816 | 2840816 | 2022-04-30 | Italy | Puglia | 1066603 | 8275 | 0 | 41.12559576 | 16.86736689 | 2022-05-01 04:20:57 | Puglia, Italy | |||
1157129 | 1157129 | 2022-04-29 | Italy | Puglia | 1062351 | 8258 | 0 | 41.12559576 | 16.86736689 | 2022-04-30 04:21:05 | Puglia, Italy | |||
1696311 | 1696311 | 2022-04-28 | Italy | Puglia | 1058128 | 8256 | 0 | 41.12559576 | 16.86736689 | 2022-04-29 04:20:59 | Puglia, Italy | |||
3851794 | 3851794 | 2022-04-27 | Italy | Puglia | 1053835 | 8253 | 0 | 41.12559576 | 16.86736689 | 2022-04-28 04:20:47 | Puglia, Italy | |||
1326224 | 1326224 | 2022-04-26 | Italy | Puglia | 1045805 | 8229 | 0 | 41.12559576 | 16.86736689 | 2022-04-27 04:20:52 | Puglia, Italy | |||
3722178 | 3722178 | 2022-04-25 | Italy | Puglia | 1042769 | 8225 | 0 | 41.12559576 | 16.86736689 | 2022-04-26 04:20:51 | Puglia, Italy | |||
2028746 | 2028746 | 2022-04-24 | Italy | Puglia | 1040836 | 8220 | 0 | 41.12559576 | 16.86736689 | 2022-04-25 04:20:56 | Puglia, Italy | |||
746321 | 746321 | 2022-04-23 | Italy | Puglia | 1036240 | 8220 | 0 | 41.12559576 | 16.86736689 | 2022-04-24 04:20:56 | Puglia, Italy | |||
3436806 | 3436806 | 2022-04-22 | Italy | Puglia | 1030131 | 8210 | 0 | 41.12559576 | 16.86736689 | 2022-04-23 04:20:50 | Puglia, Italy | |||
2892391 | 2892391 | 2022-04-21 | Italy | Puglia | 1024328 | 8201 | 0 | 41.12559576 | 16.86736689 | 2022-04-22 04:20:45 | Puglia, Italy | |||
2307263 | 2307263 | 2022-04-20 | Italy | Puglia | 1018468 | 8190 | 0 | 41.12559576 | 16.86736689 | 2022-04-21 04:20:46 | Puglia, Italy | |||
2251402 | 2251402 | 2022-04-19 | Italy | Puglia | 1009581 | 8170 | 0 | 41.12559576 | 16.86736689 | 2022-04-20 04:20:45 | Puglia, Italy | |||
1845952 | 1845952 | 2022-04-18 | Italy | Puglia | 1007349 | 8167 | 0 | 41.12559576 | 16.86736689 | 2022-04-19 04:21:00 | Puglia, Italy | |||
3416896 | 3416896 | 2022-04-17 | Italy | Puglia | 1005981 | 8163 | 0 | 41.12559576 | 16.86736689 | 2022-04-18 04:21:12 | Puglia, Italy | |||
303845 | 303845 | 2022-04-16 | Italy | Puglia | 1002188 | 8156 | 0 | 41.12559576 | 16.86736689 | 2022-04-17 04:20:59 | Puglia, Italy | |||
2669790 | 2669790 | 2022-04-15 | Italy | Puglia | 996911 | 8137 | 0 | 41.12559576 | 16.86736689 | 2022-04-16 04:20:48 | Puglia, Italy | |||
1223575 | 1223575 | 2022-04-14 | Italy | Puglia | 992477 | 8122 | 0 | 41.12559576 | 16.86736689 | 2022-04-15 04:20:57 | Puglia, Italy | |||
2442733 | 2442733 | 2022-04-13 | Italy | Puglia | 987280 | 8108 | 0 | 41.12559576 | 16.86736689 | 2022-04-13 23:21:06 | Puglia, Italy | |||
1948490 | 1948490 | 2022-04-12 | Italy | Puglia | 983378 | 8100 | 0 | 41.12559576 | 16.86736689 | 2022-04-13 04:21:03 | Puglia, Italy | |||
3206243 | 3206243 | 2022-04-11 | Italy | Puglia | 975598 | 8079 | 0 | 41.12559576 | 16.86736689 | 2022-04-12 04:20:49 | Puglia, Italy | |||
1576129 | 1576129 | 2022-04-10 | Italy | Puglia | 973739 | 8070 | 0 | 41.12559576 | 16.86736689 | 2022-04-11 04:21:02 | Puglia, Italy | |||
1652371 | 1652371 | 2022-04-09 | Italy | Puglia | 969602 | 8063 | 0 | 41.12559576 | 16.86736689 | 2022-04-10 04:20:52 | Puglia, Italy | |||
2115693 | 2115693 | 2022-04-08 | Italy | Puglia | 964124 | 8054 | 0 | 41.12559576 | 16.86736689 | 2022-04-09 04:20:42 | Puglia, Italy | |||
3320217 | 3320217 | 2022-04-07 | Italy | Puglia | 958772 | 8045 | 0 | 41.12559576 | 16.86736689 | 2022-04-08 04:20:48 | Puglia, Italy | |||
2800753 | 2800753 | 2022-04-06 | Italy | Puglia | 953194 | 8031 | 0 | 41.12559576 | 16.86736689 | 2022-04-07 04:20:53 | Puglia, Italy | |||
3867522 | 3867522 | 2022-04-05 | Italy | Puglia | 947421 | 8015 | 0 | 41.12559576 | 16.86736689 | 2022-04-06 04:20:49 | Puglia, Italy | |||
2748864 | 2748864 | 2022-04-04 | Italy | Puglia | 938980 | 8005 | 0 | 41.12559576 | 16.86736689 | 2022-04-05 04:20:48 | Puglia, Italy | |||
3730210 | 3730210 | 2022-04-03 | Italy | Puglia | 936297 | 7999 | 0 | 41.12559576 | 16.86736689 | 2022-04-04 04:20:51 | Puglia, Italy | |||
499645 | 499645 | 2022-04-02 | Italy | Puglia | 931368 | 7989 | 0 | 41.12559576 | 16.86736689 | 2022-04-03 04:20:48 | Puglia, Italy | |||
3350630 | 3350630 | 2022-04-01 | Italy | Puglia | 924698 | 7974 | 0 | 41.12559576 | 16.86736689 | 2022-04-02 04:20:47 | Puglia, Italy | |||
1539935 | 1539935 | 2022-03-31 | Italy | Puglia | 917826 | 7965 | 0 | 41.12559576 | 16.86736689 | 2022-04-01 04:20:28 | Puglia, Italy | |||
2477948 | 2477948 | 2022-03-30 | Italy | Puglia | 910697 | 7949 | 0 | 41.12559576 | 16.86736689 | 2022-03-31 04:20:56 | Puglia, Italy | |||
157989 | 157989 | 2022-03-29 | Italy | Puglia | 903014 | 7937 | 0 | 41.12559576 | 16.86736689 | 2022-03-30 04:20:45 | Puglia, Italy | |||
1436560 | 1436560 | 2022-03-28 | Italy | Puglia | 892209 | 7927 | 0 | 41.12559576 | 16.86736689 | 2022-03-29 04:20:46 | Puglia, Italy | |||
876241 | 876241 | 2022-03-27 | Italy | Puglia | 889418 | 7923 | 0 | 41.12559576 | 16.86736689 | 2022-03-28 04:20:33 | Puglia, Italy | |||
2163524 | 2163524 | 2022-03-26 | Italy | Puglia | 883273 | 7921 | 0 | 41.12559576 | 16.86736689 | 2022-03-27 04:20:47 | Puglia, Italy | |||
1720460 | 1720460 | 2022-03-25 | Italy | Puglia | 875364 | 7910 | 0 | 41.12559576 | 16.86736689 | 2022-03-26 04:20:23 | Puglia, Italy | |||
1468077 | 1468077 | 2022-03-24 | Italy | Puglia | 867522 | 7896 | 0 | 41.12559576 | 16.86736689 | 2022-03-25 04:20:46 | Puglia, Italy | |||
3022251 | 3022251 | 2022-03-23 | Italy | Puglia | 859102 | 7882 | 0 | 41.12559576 | 16.86736689 | 2022-03-24 04:20:43 | Puglia, Italy | |||
1905173 | 1905173 | 2022-03-22 | Italy | Puglia | 851832 | 7875 | 0 | 41.12559576 | 16.86736689 | 2022-03-23 04:20:48 | Puglia, Italy | |||
3238304 | 3238304 | 2022-03-21 | Italy | Puglia | 839825 | 7862 | 0 | 41.12559576 | 16.86736689 | 2022-03-22 04:20:54 | Puglia, Italy | |||
24377 | 24377 | 2022-03-20 | Italy | Puglia | 836805 | 7858 | 0 | 41.12559576 | 16.86736689 | 2022-03-21 04:20:50 | Puglia, Italy | |||
1656387 | 1656387 | 2022-03-19 | Italy | Puglia | 830341 | 7854 | 0 | 41.12559576 | 16.86736689 | 2022-03-20 04:20:45 | Puglia, Italy | |||
335913 | 335913 | 2022-03-18 | Italy | Puglia | 822949 | 7850 | 0 | 41.12559576 | 16.86736689 | 2022-03-19 04:20:47 | Puglia, Italy | |||
694366 | 694366 | 2022-03-17 | Italy | Puglia | 814428 | 7840 | 0 | 41.12559576 | 16.86736689 | 2022-03-18 04:20:55 | Puglia, Italy | |||
2319309 | 2319309 | 2022-03-16 | Italy | Puglia | 805869 | 7838 | 0 | 41.12559576 | 16.86736689 | 2022-03-17 04:20:56 | Puglia, Italy | |||
261509 | 261509 | 2022-03-15 | Italy | Puglia | 798870 | 7821 | 0 | 41.12559576 | 16.86736689 | 2022-03-16 04:20:50 | Puglia, Italy | |||
2263868 | 2263868 | 2022-03-14 | Italy | Puglia | 790659 | 7812 | 0 | 41.12559576 | 16.86736689 | 2022-03-15 04:20:47 | Puglia, Italy | |||
3627934 | 3627934 | 2022-03-13 | Italy | Puglia | 787313 | 7801 | 0 | 41.12559576 | 16.86736689 | 2022-03-14 04:20:46 | Puglia, Italy | |||
950842 | 950842 | 2022-03-12 | Italy | Puglia | 782891 | 7799 | 0 | 41.12559576 | 16.86736689 | 2022-03-13 04:20:49 | Puglia, Italy | |||
356303 | 356303 | 2022-03-11 | Italy | Puglia | 777543 | 7779 | 0 | 41.12559576 | 16.86736689 | 2022-03-12 04:20:50 | Puglia, Italy | |||
1865455 | 1865455 | 2022-03-10 | Italy | Puglia | 772795 | 7767 | 0 | 41.12559576 | 16.86736689 | 2022-03-11 04:20:50 | Puglia, Italy | |||
2140150 | 2140150 | 2022-03-09 | Italy | Puglia | 768082 | 7760 | 0 | 41.12559576 | 16.86736689 | 2022-03-10 04:20:48 | Puglia, Italy | |||
919661 | 919661 | 2022-03-08 | Italy | Puglia | 763927 | 7745 | 0 | 41.12559576 | 16.86736689 | 2022-03-09 04:20:59 | Puglia, Italy | |||
1547948 | 1547948 | 2022-03-07 | Italy | Puglia | 757901 | 7725 | 0 | 41.12559576 | 16.86736689 | 2022-03-08 04:20:54 | Puglia, Italy | |||
2199617 | 2199617 | 2022-03-06 | Italy | Puglia | 756171 | 7724 | 0 | 41.12559576 | 16.86736689 | 2022-03-07 04:20:47 | Puglia, Italy | |||
2092074 | 2092074 | 2022-03-05 | Italy | Puglia | 753242 | 7722 | 0 | 41.12559576 | 16.86736689 | 2022-03-06 04:20:49 | Puglia, Italy |
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]);