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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070005 | 3070005 | 2021-11-23 | Italy | Puglia | 277715 | 6878 | 0 | 41.12559576 | 16.86736689 | 2021-11-24 04:22:14 | Puglia, Italy | |||
3749103 | 3749103 | 2021-11-22 | Italy | Puglia | 277466 | 6875 | 0 | 41.12559576 | 16.86736689 | 2021-11-23 04:22:39 | Puglia, Italy | |||
1014310 | 1014310 | 2021-11-21 | Italy | Puglia | 277380 | 6873 | 0 | 41.12559576 | 16.86736689 | 2021-11-22 04:22:20 | Puglia, Italy | |||
722474 | 722474 | 2021-11-20 | Italy | Puglia | 277262 | 6873 | 0 | 41.12559576 | 16.86736689 | 2021-11-21 04:22:13 | Puglia, Italy | |||
162004 | 162004 | 2021-11-19 | Italy | Puglia | 277005 | 6873 | 0 | 41.12559576 | 16.86736689 | 2021-11-20 04:22:17 | Puglia, Italy | |||
3288891 | 3288891 | 2021-11-18 | Italy | Puglia | 276721 | 6873 | 0 | 41.12559576 | 16.86736689 | 2021-11-19 04:21:40 | Puglia, Italy | |||
447347 | 447347 | 2021-11-17 | Italy | Puglia | 276488 | 6867 | 0 | 41.12559576 | 16.86736689 | 2021-11-18 04:21:33 | Puglia, Italy | |||
3342597 | 3342597 | 2021-11-16 | Italy | Puglia | 276109 | 6865 | 0 | 41.12559576 | 16.86736689 | 2021-11-17 04:21:48 | Puglia, Italy | |||
2287433 | 2287433 | 2021-11-15 | Italy | Puglia | 275948 | 6862 | 0 | 41.12559576 | 16.86736689 | 2021-11-16 04:21:10 | Puglia, Italy | |||
1322207 | 1322207 | 2021-11-14 | Italy | Puglia | 275816 | 6861 | 0 | 41.12559576 | 16.86736689 | 2021-11-15 04:21:36 | Puglia, Italy | |||
686333 | 686333 | 2021-11-13 | Italy | Puglia | 275692 | 6861 | 0 | 41.12559576 | 16.86736689 | 2021-11-14 04:21:31 | Puglia, Italy | |||
714442 | 714442 | 2021-11-12 | Italy | Puglia | 275415 | 6861 | 0 | 41.12559576 | 16.86736689 | 2021-11-13 04:21:38 | Puglia, Italy | |||
28392 | 28392 | 2021-11-11 | Italy | Puglia | 275150 | 6858 | 0 | 41.12559576 | 16.86736689 | 2021-11-12 04:22:01 | Puglia, Italy | |||
2844831 | 2844831 | 2021-11-10 | Italy | Puglia | 274888 | 6856 | 0 | 41.12559576 | 16.86736689 | 2021-11-11 04:21:45 | Puglia, Italy | |||
87101 | 87101 | 2021-11-09 | Italy | Puglia | 274595 | 6853 | 0 | 41.12559576 | 16.86736689 | 2021-11-10 04:21:38 | Puglia, Italy | |||
3639529 | 3639529 | 2021-11-08 | Italy | Puglia | 274354 | 6852 | 0 | 41.12559576 | 16.86736689 | 2021-11-09 04:21:36 | Puglia, Italy | |||
2000637 | 2000637 | 2021-11-07 | Italy | Puglia | 274204 | 6849 | 0 | 41.12559576 | 16.86736689 | 2021-11-08 04:21:43 | Puglia, Italy | |||
495628 | 495628 | 2021-11-06 | Italy | Puglia | 274038 | 6847 | 0 | 41.12559576 | 16.86736689 | 2021-11-07 04:21:53 | Puglia, Italy | |||
3121483 | 3121483 | 2021-11-05 | Italy | Puglia | 273799 | 6845 | 0 | 41.12559576 | 16.86736689 | 2021-11-06 04:21:51 | Puglia, Italy | |||
698381 | 698381 | 2021-11-04 | Italy | Puglia | 273548 | 6844 | 0 | 41.12559576 | 16.86736689 | 2021-11-05 04:21:54 | Puglia, Italy | |||
276159 | 276159 | 2021-11-03 | Italy | Puglia | 273324 | 6843 | 0 | 41.12559576 | 16.86736689 | 2021-11-04 04:22:20 | Puglia, Italy | |||
43684 | 43684 | 2021-11-02 | Italy | Puglia | 273092 | 6835 | 0 | 41.12559576 | 16.86736689 | 2021-11-03 06:22:09 | Puglia, Italy | |||
3511380 | 3511380 | 2021-11-01 | Italy | Puglia | 273009 | 6835 | 0 | 41.12559576 | 16.86736689 | 2021-11-02 04:22:03 | Puglia, Italy | |||
287972 | 287972 | 2021-10-31 | Italy | Puglia | 272914 | 6835 | 0 | 41.12559576 | 16.86736689 | 2021-11-01 04:22:01 | Puglia, Italy | |||
2720978 | 2720978 | 2021-10-30 | Italy | Puglia | 272730 | 6834 | 0 | 41.12559576 | 16.86736689 | 2021-10-31 04:22:08 | Puglia, Italy | |||
567080 | 567080 | 2021-10-29 | Italy | Puglia | 272529 | 6832 | 0 | 41.12559576 | 16.86736689 | 2021-10-30 04:22:03 | Puglia, Italy | |||
4322 | 4322 | 2021-10-28 | Italy | Puglia | 272296 | 6832 | 0 | 41.12559576 | 16.86736689 | 2021-10-29 04:22:03 | Puglia, Italy | |||
534712 | 534712 | 2021-10-27 | Italy | Puglia | 272081 | 6832 | 0 | 41.12559576 | 16.86736689 | 2021-10-28 04:22:08 | Puglia, Italy | |||
3492149 | 3492149 | 2021-10-26 | Italy | Puglia | 271816 | 6828 | 0 | 41.12559576 | 16.86736689 | 2021-10-27 04:22:32 | Puglia, Italy | |||
3793871 | 3793871 | 2021-10-25 | Italy | Puglia | 271538 | 6825 | 0 | 41.12559576 | 16.86736689 | 2021-10-26 04:22:09 | Puglia, Italy | |||
682317 | 682317 | 2021-10-24 | Italy | Puglia | 271456 | 6825 | 0 | 41.12559576 | 16.86736689 | 2021-10-25 04:22:31 | Puglia, Italy | |||
770325 | 770325 | 2021-10-23 | Italy | Puglia | 271329 | 6825 | 0 | 41.12559576 | 16.86736689 | 2021-10-24 04:21:22 | Puglia, Italy | |||
653972 | 653972 | 2021-10-22 | Italy | Puglia | 271126 | 6825 | 0 | 41.12559576 | 16.86736689 | 2021-10-23 04:21:32 | Puglia, Italy | |||
2123719 | 2123719 | 2021-10-21 | Italy | Puglia | 270916 | 6822 | 0 | 41.12559576 | 16.86736689 | 2021-10-22 04:21:14 | Puglia, Italy | |||
443331 | 443331 | 2021-10-20 | Italy | Puglia | 270749 | 6821 | 0 | 41.12559576 | 16.86736689 | 2021-10-21 04:21:18 | Puglia, Italy | |||
597650 | 597650 | 2021-10-19 | Italy | Puglia | 270602 | 6819 | 0 | 41.12559576 | 16.86736689 | 2021-10-20 04:21:00 | Puglia, Italy | |||
2043827 | 2043827 | 2021-10-18 | Italy | Puglia | 270475 | 6816 | 0 | 41.12559576 | 16.86736689 | 2021-10-19 04:20:54 | Puglia, Italy | |||
1909188 | 1909188 | 2021-10-17 | Italy | Puglia | 270433 | 6816 | 0 | 41.12559576 | 16.86736689 | 2021-10-18 04:21:10 | Puglia, Italy | |||
934777 | 934777 | 2021-10-16 | Italy | Puglia | 270367 | 6815 | 0 | 41.12559576 | 16.86736689 | 2021-10-17 04:21:29 | Puglia, Italy | |||
2943332 | 2943332 | 2021-10-15 | Italy | Puglia | 270233 | 6815 | 0 | 41.12559576 | 16.86736689 | 2021-10-16 04:21:15 | Puglia, Italy | |||
491612 | 491612 | 2021-10-14 | Italy | Puglia | 270131 | 6813 | 0 | 41.12559576 | 16.86736689 | 2021-10-15 04:21:26 | Puglia, Italy | |||
633900 | 633900 | 2021-10-13 | Italy | Puglia | 270038 | 6811 | 0 | 41.12559576 | 16.86736689 | 2021-10-14 04:21:29 | Puglia, Italy | |||
1491578 | 1491578 | 2021-10-12 | Italy | Puglia | 269952 | 6810 | 0 | 41.12559576 | 16.86736689 | 2021-10-13 04:20:51 | Puglia, Italy | |||
3007311 | 3007311 | 2021-10-11 | Italy | Puglia | 269834 | 6803 | 0 | 41.12559576 | 16.86736689 | 2021-10-12 04:21:09 | Puglia, Italy | |||
423327 | 423327 | 2021-10-10 | Italy | Puglia | 269758 | 6803 | 0 | 41.12559576 | 16.86736689 | 2021-10-11 04:21:31 | Puglia, Italy | |||
2876184 | 2876184 | 2021-10-09 | Italy | Puglia | 269696 | 6802 | 0 | 41.12559576 | 16.86736689 | 2021-10-10 04:21:38 | Puglia, Italy | |||
2959350 | 2959350 | 2021-10-08 | Italy | Puglia | 269578 | 6801 | 0 | 41.12559576 | 16.86736689 | 2021-10-09 04:21:34 | Puglia, Italy | |||
467388 | 467388 | 2021-10-07 | Italy | Puglia | 269465 | 6797 | 0 | 41.12559576 | 16.86736689 | 2021-10-08 04:21:25 | Puglia, Italy | |||
2458768 | 2458768 | 2021-10-06 | Italy | Puglia | 269371 | 6797 | 0 | 41.12559576 | 16.86736689 | 2021-10-07 04:21:36 | Puglia, Italy | |||
3832462 | 3832462 | 2021-10-05 | Italy | Puglia | 269228 | 6797 | 0 | 41.12559576 | 16.86736689 | 2021-10-06 04:21:33 | Puglia, Italy | |||
986955 | 986955 | 2021-10-04 | Italy | Puglia | 269102 | 6796 | 0 | 41.12559576 | 16.86736689 | 2021-10-05 04:21:27 | Puglia, Italy | |||
1274265 | 1274265 | 2021-10-03 | Italy | Puglia | 269038 | 6795 | 0 | 41.12559576 | 16.86736689 | 2021-10-04 04:21:31 | Puglia, Italy | |||
3928018 | 3928018 | 2021-10-02 | Italy | Puglia | 268950 | 6795 | 0 | 41.12559576 | 16.86736689 | 2021-10-03 04:21:24 | Puglia, Italy | |||
2131998 | 2131998 | 2021-10-01 | Italy | Puglia | 268812 | 6794 | 0 | 41.12559576 | 16.86736689 | 2021-10-02 04:21:25 | Puglia, Italy | |||
2772955 | 2772955 | 2021-09-30 | Italy | Puglia | 268640 | 6791 | 0 | 41.12559576 | 16.86736689 | 2021-10-01 04:21:35 | Puglia, Italy | |||
706411 | 706411 | 2021-09-29 | Italy | Puglia | 268521 | 6786 | 0 | 41.12559576 | 16.86736689 | 2021-09-30 04:21:20 | Puglia, Italy | |||
1334253 | 1334253 | 2021-09-28 | Italy | Puglia | 268369 | 6785 | 0 | 41.12559576 | 16.86736689 | 2021-09-29 04:21:45 | Puglia, Italy | |||
1235622 | 1235622 | 2021-09-27 | Italy | Puglia | 268244 | 6779 | 0 | 41.12559576 | 16.86736689 | 2021-09-28 04:21:28 | Puglia, Italy | |||
2075923 | 2075923 | 2021-09-26 | Italy | Puglia | 268187 | 6777 | 0 | 41.12559576 | 16.86736689 | 2021-09-27 04:21:16 | Puglia, Italy | |||
1724475 | 1724475 | 2021-09-25 | Italy | Puglia | 268048 | 6776 | 0 | 41.12559576 | 16.86736689 | 2021-09-26 04:21:29 | Puglia, Italy | |||
1921195 | 1921195 | 2021-09-24 | Italy | Puglia | 267862 | 6775 | 0 | 41.12559576 | 16.86736689 | 2021-09-25 04:21:31 | Puglia, Italy | |||
601666 | 601666 | 2021-09-23 | Italy | Puglia | 267705 | 6772 | 0 | 41.12559576 | 16.86736689 | 2021-09-24 04:21:44 | Puglia, Italy | |||
3011327 | 3011327 | 2021-09-22 | Italy | Puglia | 267567 | 6768 | 0 | 41.12559576 | 16.86736689 | 2021-09-23 04:21:43 | Puglia, Italy | |||
3757465 | 3757465 | 2021-09-21 | Italy | Puglia | 267371 | 6765 | 0 | 41.12559576 | 16.86736689 | 2021-09-22 04:21:45 | Puglia, Italy | |||
809568 | 809568 | 2021-09-20 | Italy | Puglia | 267261 | 6764 | 0 | 41.12559576 | 16.86736689 | 2021-09-21 04:21:26 | Puglia, Italy | |||
1814767 | 1814767 | 2021-09-19 | Italy | Puglia | 267201 | 6764 | 0 | 41.12559576 | 16.86736689 | 2021-09-20 04:21:22 | Puglia, Italy | |||
16347 | 16347 | 2021-09-18 | Italy | Puglia | 267037 | 6764 | 0 | 41.12559576 | 16.86736689 | 2021-09-19 04:21:34 | Puglia, Italy | |||
2618032 | 2618032 | 2021-09-17 | Italy | Puglia | 266881 | 6764 | 0 | 41.12559576 | 16.86736689 | 2021-09-18 04:21:24 | Puglia, Italy | |||
2808740 | 2808740 | 2021-09-16 | Italy | Puglia | 266706 | 6759 | 0 | 41.12559576 | 16.86736689 | 2021-09-17 04:21:46 | Puglia, Italy | |||
1374485 | 1374485 | 2021-09-15 | Italy | Puglia | 266458 | 6758 | 0 | 41.12559576 | 16.86736689 | 2021-09-16 04:22:19 | Puglia, Italy | |||
2462784 | 2462784 | 2021-09-14 | Italy | Puglia | 266269 | 6754 | 0 | 41.12559576 | 16.86736689 | 2021-09-15 03:22:37 | Puglia, Italy | |||
1385623 | 1385623 | 2021-09-13 | Italy | Puglia | 266082 | 6750 | 0 | 41.12559576 | 16.86736689 | 2021-09-14 04:21:41 | Puglia, Italy | |||
1884992 | 1884992 | 2021-09-12 | Italy | Puglia | 265994 | 6747 | 0 | 41.12559576 | 16.86736689 | 2021-09-13 04:21:15 | Puglia, Italy | |||
3805895 | 3805895 | 2021-09-11 | Italy | Puglia | 265867 | 6747 | 0 | 41.12559576 | 16.86736689 | 2021-09-12 04:21:13 | Puglia, Italy | |||
3448835 | 3448835 | 2021-09-10 | Italy | Puglia | 265645 | 6745 | 0 | 41.12559576 | 16.86736689 | 2021-09-11 04:21:30 | Puglia, Italy | |||
1262781 | 1262781 | 2021-09-09 | Italy | Puglia | 265445 | 6734 | 0 | 41.12559576 | 16.86736689 | 2021-09-10 04:21:20 | Puglia, Italy | |||
2279151 | 2279151 | 2021-09-08 | Italy | Puglia | 265267 | 6734 | 0 | 41.12559576 | 16.86736689 | 2021-09-09 04:21:27 | Puglia, Italy | |||
641930 | 641930 | 2021-09-07 | Italy | Puglia | 265024 | 6729 | 0 | 41.12559576 | 16.86736689 | 2021-09-08 04:21:31 | Puglia, Italy | |||
3193993 | 3193993 | 2021-09-06 | Italy | Puglia | 264905 | 6724 | 0 | 41.12559576 | 16.86736689 | 2021-09-07 04:21:35 | Puglia, Italy | |||
3280861 | 3280861 | 2021-09-05 | Italy | Puglia | 264783 | 6722 | 0 | 41.12559576 | 16.86736689 | 2021-09-06 04:21:22 | Puglia, Italy | |||
249275 | 249275 | 2021-09-04 | Italy | Puglia | 264627 | 6722 | 0 | 41.12559576 | 16.86736689 | 2021-09-05 04:21:33 | Puglia, Italy | |||
3974556 | 3974556 | 2021-09-03 | Italy | Puglia | 264399 | 6717 | 0 | 41.12559576 | 16.86736689 | 2021-09-04 04:21:28 | Puglia, Italy | |||
178018 | 178018 | 2021-09-02 | Italy | Puglia | 264061 | 6714 | 0 | 41.12559576 | 16.86736689 | 2021-09-03 04:21:20 | Puglia, Italy | |||
67053 | 67053 | 2021-09-01 | Italy | Puglia | 263852 | 6713 | 0 | 41.12559576 | 16.86736689 | 2021-09-02 04:21:15 | Puglia, Italy | |||
2067895 | 2067895 | 2021-08-31 | Italy | Puglia | 263554 | 6712 | 0 | 41.12559576 | 16.86736689 | 2021-09-01 04:21:38 | Puglia, Italy | |||
1775349 | 1775349 | 2021-08-30 | Italy | Puglia | 263334 | 6706 | 0 | 41.12559576 | 16.86736689 | 2021-08-31 04:21:46 | Puglia, Italy | |||
3891923 | 3891923 | 2021-08-29 | Italy | Puglia | 263229 | 6703 | 0 | 41.12559576 | 16.86736689 | 2021-08-30 04:21:23 | Puglia, Italy | |||
2793026 | 2793026 | 2021-08-28 | Italy | Puglia | 263031 | 6702 | 0 | 41.12559576 | 16.86736689 | 2021-08-29 04:21:14 | Puglia, Italy | |||
2923185 | 2923185 | 2021-08-27 | Italy | Puglia | 262727 | 6701 | 0 | 41.12559576 | 16.86736689 | 2021-08-28 04:21:28 | Puglia, Italy | |||
1596199 | 1596199 | 2021-08-26 | Italy | Puglia | 262425 | 6698 | 0 | 41.12559576 | 16.86736689 | 2021-08-27 04:21:37 | Puglia, Italy | |||
32408 | 32408 | 2021-08-25 | Italy | Puglia | 262141 | 6697 | 0 | 41.12559576 | 16.86736689 | 2021-08-26 04:21:28 | Puglia, Italy | |||
3105447 | 3105447 | 2021-08-24 | Italy | Puglia | 261814 | 6695 | 0 | 41.12559576 | 16.86736689 | 2021-08-25 04:21:41 | Puglia, Italy | |||
3165618 | 3165618 | 2021-08-23 | Italy | Puglia | 261641 | 6694 | 0 | 41.12559576 | 16.86736689 | 2021-08-24 04:21:19 | Puglia, Italy | |||
2175545 | 2175545 | 2021-08-22 | Italy | Puglia | 261497 | 6694 | 0 | 41.12559576 | 16.86736689 | 2021-08-23 04:21:27 | Puglia, Italy | |||
3555641 | 3555641 | 2021-08-21 | Italy | Puglia | 261236 | 6691 | 0 | 41.12559576 | 16.86736689 | 2021-08-22 04:21:29 | Puglia, Italy | |||
1853983 | 1853983 | 2021-08-20 | Italy | Puglia | 260872 | 6690 | 0 | 41.12559576 | 16.86736689 | 2021-08-21 04:21:38 | Puglia, Italy | |||
511690 | 511690 | 2021-08-19 | Italy | Puglia | 260525 | 6688 | 0 | 41.12559576 | 16.86736689 | 2021-08-20 04:21:33 | Puglia, Italy | |||
2518169 | 2518169 | 2021-08-18 | Italy | Puglia | 260308 | 6686 | 0 | 41.12559576 | 16.86736689 | 2021-08-19 04:21:15 | Puglia, Italy | |||
245261 | 245261 | 2021-08-17 | Italy | Puglia | 259950 | 6684 | 0 | 41.12559576 | 16.86736689 | 2021-08-18 04:21:35 | Puglia, Italy | |||
1604224 | 1604224 | 2021-08-16 | Italy | Puglia | 259785 | 6682 | 0 | 41.12559576 | 16.86736689 | 2021-08-17 04:21: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]);