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 = "P.A. Bolzano" sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2563851 | 2563851 | 2020-07-24 | Italy | P.A. Bolzano | 2687 | 292 | 2312 | 83 | 46.49933453 | 11.35662422 | 2020-07-25 04:47:39 | P.A. Bolzano, Italy | ||
2581971 | 2581971 | 2020-09-27 | Italy | P.A. Bolzano | 3489 | 292 | 2650 | 547 | 46.49933453 | 11.35662422 | 2020-09-28 04:23:00 | P.A. Bolzano, Italy | ||
2602023 | 2602023 | 2020-10-10 | Italy | P.A. Bolzano | 3980 | 292 | 2815 | 873 | 46.49933453 | 11.35662422 | 2020-10-11 04:23:46 | P.A. Bolzano, Italy | ||
2606015 | 2606015 | 2020-09-24 | Italy | P.A. Bolzano | 3386 | 292 | 2609 | 485 | 46.49933453 | 11.35662422 | 2020-09-25 04:23:00 | P.A. Bolzano, Italy | ||
2614023 | 2614023 | 2020-09-26 | Italy | P.A. Bolzano | 3467 | 292 | 2635 | 540 | 46.49933453 | 11.35662422 | 2020-09-27 04:23:00 | P.A. Bolzano, Italy | ||
2625179 | 2625179 | 2020-06-25 | Italy | P.A. Bolzano | 2634 | 292 | 2255 | 87 | 46.49933453 | 11.35662422 | 2020-06-26 04:33:43 | P.A. Bolzano, Italy | ||
2633013 | 2633013 | 2020-06-29 | Italy | P.A. Bolzano | 2639 | 292 | 2262 | 85 | 46.49933453 | 11.35662422 | 2020-06-30 04:33:48 | P.A. Bolzano, Italy | ||
2653758 | 2653758 | 2020-09-23 | Italy | P.A. Bolzano | 3366 | 292 | 2598 | 476 | 46.49933453 | 11.35662422 | 2020-09-24 04:23:00 | P.A. Bolzano, Italy | ||
2661765 | 2661765 | 2020-09-04 | Italy | P.A. Bolzano | 2973 | 292 | 2472 | 209 | 46.49933453 | 11.35662422 | 2020-09-05 04:28:19 | P.A. Bolzano, Italy | ||
2684985 | 2684985 | 2020-07-06 | Italy | P.A. Bolzano | 2647 | 292 | 2272 | 83 | 46.49933453 | 11.35662422 | 2020-07-07 04:34:00 | P.A. Bolzano, Italy | ||
2689671 | 2689671 | 2020-10-08 | Italy | P.A. Bolzano | 3803 | 292 | 2785 | 726 | 46.49933453 | 11.35662422 | 2020-10-09 04:23:59 | P.A. Bolzano, Italy | ||
2700819 | 2700819 | 2020-06-24 | Italy | P.A. Bolzano | 2634 | 292 | 2252 | 90 | 46.49933453 | 11.35662422 | 2020-06-25 05:26:54 | P.A. Bolzano, Italy | ||
2708696 | 2708696 | 2020-07-17 | Italy | P.A. Bolzano | 2682 | 292 | 2289 | 101 | 46.49933453 | 11.35662422 | 2020-07-18 04:34:45 | P.A. Bolzano, Italy | ||
2728992 | 2728992 | 2020-09-15 | Italy | P.A. Bolzano | 3156 | 292 | 2544 | 320 | 46.49933453 | 11.35662422 | 2020-09-16 04:22:53 | P.A. Bolzano, Italy | ||
2740297 | 2740297 | 2020-08-03 | Italy | P.A. Bolzano | 2734 | 292 | 2330 | 112 | 46.49933453 | 11.35662422 | 2020-08-04 04:41:59 | P.A. Bolzano, Italy | ||
2748174 | 2748174 | 2020-07-15 | Italy | P.A. Bolzano | 2677 | 292 | 2288 | 97 | 46.49933453 | 11.35662422 | 2020-07-16 04:44:59 | P.A. Bolzano, Italy | ||
2800074 | 2800074 | 2020-06-07 | Italy | P.A. Bolzano | 2603 | 292 | 2214 | 97 | 46.49933453 | 11.35662422 | 2020-06-08 03:33:22 | P.A. Bolzano, Italy | ||
2808049 | 2808049 | 2020-08-02 | Italy | P.A. Bolzano | 2728 | 292 | 2329 | 107 | 46.49933453 | 11.35662422 | 2020-08-03 04:34:35 | P.A. Bolzano, Italy | ||
2812738 | 2812738 | 2020-09-25 | Italy | P.A. Bolzano | 3438 | 292 | 2632 | 514 | 46.49933453 | 11.35662422 | 2020-09-26 04:23:00 | P.A. Bolzano, Italy | ||
2836806 | 2836806 | 2020-09-21 | Italy | P.A. Bolzano | 3321 | 292 | 2589 | 440 | 46.49933453 | 11.35662422 | 2020-09-22 04:23:00 | P.A. Bolzano, Italy | ||
2848829 | 2848829 | 2020-09-18 | Italy | P.A. Bolzano | 3255 | 292 | 2578 | 385 | 46.49933453 | 11.35662422 | 2020-09-19 04:22:00 | P.A. Bolzano, Italy | ||
2864021 | 2864021 | 2020-06-10 | Italy | P.A. Bolzano | 2604 | 292 | 2218 | 94 | 46.49933453 | 11.35662422 | 2020-06-11 03:33:41 | P.A. Bolzano, Italy | ||
2868703 | 2868703 | 2020-09-13 | Italy | P.A. Bolzano | 3128 | 292 | 2540 | 296 | 46.49933453 | 11.35662422 | 2020-09-14 04:26:00 | P.A. Bolzano, Italy | ||
2958657 | 2958657 | 2020-07-29 | Italy | P.A. Bolzano | 2696 | 292 | 2318 | 86 | 46.49933453 | 11.35662422 | 2020-07-30 04:35:05 | P.A. Bolzano, Italy | ||
2974536 | 2974536 | 2020-06-30 | Italy | P.A. Bolzano | 2639 | 292 | 2263 | 84 | 46.49933453 | 11.35662422 | 2020-07-01 04:33:52 | P.A. Bolzano, Italy | ||
2991261 | 2991261 | 2020-08-24 | Italy | P.A. Bolzano | 2884 | 292 | 2420 | 172 | 46.49933453 | 11.35662422 | 2020-08-25 04:28:02 | P.A. Bolzano, Italy | ||
3045467 | 3045467 | 2020-07-02 | Italy | P.A. Bolzano | 2642 | 292 | 2266 | 84 | 46.49933453 | 11.35662422 | 2020-07-03 04:33:54 | P.A. Bolzano, Italy | ||
3093410 | 3093410 | 2020-09-20 | Italy | P.A. Bolzano | 3301 | 292 | 2587 | 422 | 46.49933453 | 11.35662422 | 2020-09-21 04:23:00 | P.A. Bolzano, Italy | ||
3117474 | 3117474 | 2020-10-06 | Italy | P.A. Bolzano | 3679 | 292 | 2757 | 630 | 46.49933453 | 11.35662422 | 2020-10-07 04:23:40 | P.A. Bolzano, Italy | ||
3161610 | 3161610 | 2020-09-06 | Italy | P.A. Bolzano | 3003 | 292 | 2493 | 218 | 46.49933453 | 11.35662422 | 2020-09-07 04:28:30 | P.A. Bolzano, Italy | ||
3177997 | 3177997 | 2020-08-18 | Italy | P.A. Bolzano | 2804 | 292 | 2385 | 127 | 46.49933453 | 11.35662422 | 2020-08-19 04:27:00 | P.A. Bolzano, Italy | ||
3185273 | 3185273 | 2020-07-28 | Italy | P.A. Bolzano | 2692 | 292 | 2315 | 85 | 46.49933453 | 11.35662422 | 2020-07-29 04:35:11 | P.A. Bolzano, Italy | ||
3205395 | 3205395 | 2020-07-18 | Italy | P.A. Bolzano | 2683 | 292 | 2290 | 101 | 46.49933453 | 11.35662422 | 2020-07-19 04:34:58 | P.A. Bolzano, Italy | ||
3237615 | 3237615 | 2020-07-10 | Italy | P.A. Bolzano | 2658 | 292 | 2280 | 86 | 46.49933453 | 11.35662422 | 2020-07-11 04:34:26 | P.A. Bolzano, Italy | ||
3249437 | 3249437 | 2020-06-21 | Italy | P.A. Bolzano | 2622 | 292 | 2255 | 75 | 46.49933453 | 11.35662422 | 2020-06-22 04:33:20 | P.A. Bolzano, Italy | ||
3264782 | 3264782 | 2020-07-31 | Italy | P.A. Bolzano | 2717 | 292 | 2323 | 102 | 46.49933453 | 11.35662422 | 2020-08-01 04:36:27 | P.A. Bolzano, Italy | ||
3316207 | 3316207 | 2020-09-22 | Italy | P.A. Bolzano | 3329 | 292 | 2589 | 448 | 46.49933453 | 11.35662422 | 2020-09-23 04:23:00 | P.A. Bolzano, Italy | ||
3389378 | 3389378 | 2020-10-02 | Italy | P.A. Bolzano | 3589 | 292 | 2710 | 587 | 46.49933453 | 11.35662422 | 2020-10-03 04:23:40 | P.A. Bolzano, Italy | ||
3436117 | 3436117 | 2020-07-11 | Italy | P.A. Bolzano | 2661 | 292 | 2287 | 82 | 46.49933453 | 11.35662422 | 2020-07-12 04:34:30 | P.A. Bolzano, Italy | ||
3484294 | 3484294 | 2020-08-20 | Italy | P.A. Bolzano | 2832 | 292 | 2401 | 139 | 46.49933453 | 11.35662422 | 2020-08-21 04:27:41 | P.A. Bolzano, Italy | ||
3491459 | 3491459 | 2020-07-13 | Italy | P.A. Bolzano | 2673 | 292 | 2286 | 95 | 46.49933453 | 11.35662422 | 2020-07-14 04:34:46 | P.A. Bolzano, Italy | ||
3531439 | 3531439 | 2020-08-12 | Italy | P.A. Bolzano | 2779 | 292 | 2357 | 130 | 46.49933453 | 11.35662422 | 2020-08-13 04:29:15 | P.A. Bolzano, Italy | ||
3562557 | 3562557 | 2020-08-25 | Italy | P.A. Bolzano | 2893 | 292 | 2424 | 177 | 46.49933453 | 11.35662422 | 2020-08-26 04:28:11 | P.A. Bolzano, Italy | ||
3612348 | 3612348 | 2020-08-06 | Italy | P.A. Bolzano | 2757 | 292 | 2341 | 124 | 46.49933453 | 11.35662422 | 2020-08-07 04:35:11 | P.A. Bolzano, Italy | ||
3682757 | 3682757 | 2020-06-18 | Italy | P.A. Bolzano | 2613 | 292 | 2236 | 85 | 46.49933453 | 11.35662422 | 2020-06-19 04:33:17 | P.A. Bolzano, Italy | ||
3737722 | 3737722 | 2020-07-12 | Italy | P.A. Bolzano | 2666 | 292 | 2286 | 88 | 46.49933453 | 11.35662422 | 2020-07-13 04:43:04 | P.A. Bolzano, Italy | ||
3793178 | 3793178 | 2020-08-05 | Italy | P.A. Bolzano | 2745 | 292 | 2337 | 116 | 46.49933453 | 11.35662422 | 2020-08-06 04:35:02 | P.A. Bolzano, Italy | ||
3801886 | 3801886 | 2020-10-05 | Italy | P.A. Bolzano | 3662 | 292 | 2743 | 627 | 46.49933453 | 11.35662422 | 2020-10-06 04:23:33 | P.A. Bolzano, Italy | ||
3923311 | 3923311 | 2020-08-09 | Italy | P.A. Bolzano | 2773 | 292 | 2353 | 128 | 46.49933453 | 11.35662422 | 2020-08-10 04:34:55 | P.A. Bolzano, Italy | ||
3932015 | 3932015 | 2020-08-30 | Italy | P.A. Bolzano | 2932 | 292 | 2450 | 190 | 46.49933453 | 11.35662422 | 2020-08-31 04:28:27 | P.A. Bolzano, Italy | ||
79077 | 79077 | 2020-10-14 | Italy | P.A. Bolzano | 4267 | 293 | 2856 | 1118 | 46.49933453 | 11.35662422 | 2020-10-15 04:24:28 | P.A. Bolzano, Italy | ||
762303 | 762303 | 2020-10-18 | Italy | P.A. Bolzano | 4819 | 293 | 2919 | 1607 | 46.49933453 | 11.35662422 | 2020-10-19 04:24:16 | P.A. Bolzano, Italy | ||
786366 | 786366 | 2020-10-15 | Italy | P.A. Bolzano | 4365 | 293 | 2879 | 1193 | 46.49933453 | 11.35662422 | 2020-10-16 04:24:01 | P.A. Bolzano, Italy | ||
1026341 | 1026341 | 2020-10-17 | Italy | P.A. Bolzano | 4648 | 293 | 2911 | 1444 | 46.49933453 | 11.35662422 | 2020-10-18 04:24:25 | P.A. Bolzano, Italy | ||
2291432 | 2291432 | 2020-10-12 | Italy | P.A. Bolzano | 4109 | 293 | 2843 | 973 | 46.49933453 | 11.35662422 | 2020-10-13 04:24:02 | P.A. Bolzano, Italy | ||
2856836 | 2856836 | 2020-10-16 | Italy | P.A. Bolzano | 4493 | 293 | 2897 | 1303 | 46.49933453 | 11.35662422 | 2020-10-17 04:24:12 | P.A. Bolzano, Italy | ||
3781892 | 3781892 | 2020-10-13 | Italy | P.A. Bolzano | 4143 | 293 | 2856 | 994 | 46.49933453 | 11.35662422 | 2020-10-14 04:24:05 | P.A. Bolzano, Italy | ||
3785885 | 3785885 | 2020-10-11 | Italy | P.A. Bolzano | 4064 | 293 | 2831 | 940 | 46.49933453 | 11.35662422 | 2020-10-12 04:23:45 | P.A. Bolzano, Italy | ||
1794619 | 1794619 | 2020-10-19 | Italy | P.A. Bolzano | 4904 | 294 | 2920 | 1690 | 46.49933453 | 11.35662422 | 2020-10-20 04:24:22 | P.A. Bolzano, Italy | ||
3990599 | 3990599 | 2020-10-20 | Italy | P.A. Bolzano | 5113 | 295 | 2924 | 1894 | 46.49933453 | 11.35662422 | 2020-10-21 04:24:14 | P.A. Bolzano, Italy | ||
8321 | 8321 | 2020-10-25 | Italy | P.A. Bolzano | 6434 | 296 | 2951 | 3187 | 46.49933453 | 11.35662422 | 2020-10-26 04:25:02 | P.A. Bolzano, Italy | ||
1053813 | 1053813 | 2020-10-23 | Italy | P.A. Bolzano | 5818 | 296 | 2940 | 2582 | 46.49933453 | 11.35662422 | 2020-10-24 04:24:46 | P.A. Bolzano, Italy | ||
1177483 | 1177483 | 2020-10-22 | Italy | P.A. Bolzano | 5549 | 296 | 2935 | 2318 | 46.49933453 | 11.35662422 | 2020-10-23 04:24:46 | P.A. Bolzano, Italy | ||
2191588 | 2191588 | 2020-10-21 | Italy | P.A. Bolzano | 5302 | 296 | 2926 | 2080 | 46.49933453 | 11.35662422 | 2020-10-22 04:24:27 | P.A. Bolzano, Italy | ||
3651558 | 3651558 | 2020-10-24 | Italy | P.A. Bolzano | 6095 | 296 | 2943 | 2856 | 46.49933453 | 11.35662422 | 2020-10-25 04:24:36 | P.A. Bolzano, Italy | ||
3480300 | 3480300 | 2020-10-26 | Italy | P.A. Bolzano | 6755 | 299 | 2955 | 3501 | 46.49933453 | 11.35662422 | 2020-10-27 04:24:45 | P.A. Bolzano, Italy | ||
1452576 | 1452576 | 2020-10-27 | Italy | P.A. Bolzano | 6997 | 300 | 2959 | 3738 | 46.49933453 | 11.35662422 | 2020-10-28 04:24:39 | P.A. Bolzano, Italy | ||
754291 | 754291 | 2020-10-28 | Italy | P.A. Bolzano | 7187 | 304 | 2962 | 3921 | 46.49933453 | 11.35662422 | 2020-10-29 04:24:49 | P.A. Bolzano, Italy | ||
210229 | 210229 | 2020-10-29 | Italy | P.A. Bolzano | 7485 | 306 | 2962 | 4217 | 46.49933453 | 11.35662422 | 2020-10-30 04:24:49 | P.A. Bolzano, Italy | ||
2243374 | 2243374 | 2020-10-30 | Italy | P.A. Bolzano | 7835 | 308 | 2966 | 4561 | 46.49933453 | 11.35662422 | 2020-10-31 04:24:44 | P.A. Bolzano, Italy | ||
2079921 | 2079921 | 2020-10-31 | Italy | P.A. Bolzano | 8382 | 312 | 2970 | 5100 | 46.49933453 | 11.35662422 | 2020-11-01 04:36:19 | P.A. Bolzano, Italy | ||
3409432 | 3409432 | 2020-11-01 | Italy | P.A. Bolzano | 8916 | 315 | 2970 | 5631 | 46.49933453 | 11.35662422 | 2020-11-02 05:25:04 | P.A. Bolzano, Italy | ||
3304183 | 3304183 | 2020-11-02 | Italy | P.A. Bolzano | 9353 | 319 | 2974 | 6060 | 46.49933453 | 11.35662422 | 2020-11-03 06:00:16 | P.A. Bolzano, Italy | ||
2498008 | 2498008 | 2020-11-03 | Italy | P.A. Bolzano | 9848 | 320 | 2976 | 6552 | 46.49933453 | 11.35662422 | 2020-11-04 05:25:09 | P.A. Bolzano, Italy | ||
2919171 | 2919171 | 2020-11-04 | Italy | P.A. Bolzano | 10097 | 322 | 2979 | 6796 | 46.49933453 | 11.35662422 | 2020-11-05 06:05:03 | P.A. Bolzano, Italy | ||
892109 | 892109 | 2020-11-05 | Italy | P.A. Bolzano | 10859 | 326 | 2985 | 7548 | 46.49933453 | 11.35662422 | 2020-11-06 05:24:55 | P.A. Bolzano, Italy | ||
376171 | 376171 | 2020-11-06 | Italy | P.A. Bolzano | 11572 | 330 | 4196 | 7046 | 46.49933453 | 11.35662422 | 2020-11-07 05:24:52 | P.A. Bolzano, Italy | ||
1543933 | 1543933 | 2020-11-07 | Italy | P.A. Bolzano | 12345 | 337 | 4528 | 7480 | 46.49933453 | 11.35662422 | 2020-11-08 05:24:56 | P.A. Bolzano, Italy | ||
1728473 | 1728473 | 2020-11-08 | Italy | P.A. Bolzano | 13126 | 341 | 4798 | 7987 | 46.49933453 | 11.35662422 | 2020-11-09 05:25:45 | P.A. Bolzano, Italy | ||
1988621 | 1988621 | 2020-11-09 | Italy | P.A. Bolzano | 13709 | 345 | 4950 | 8414 | 46.49933453 | 11.35662422 | 2020-11-10 05:40:07 | P.A. Bolzano, Italy | ||
272144 | 272144 | 2020-11-10 | Italy | P.A. Bolzano | 14084 | 350 | 5071 | 8663 | 46.49933453 | 11.35662422 | 2020-11-11 05:25:30 | P.A. Bolzano, Italy | ||
3440804 | 3440804 | 2020-11-11 | Italy | P.A. Bolzano | 14470 | 359 | 5226 | 8885 | 46.49933453 | 11.35662422 | 2020-11-12 05:25:55 | P.A. Bolzano, Italy | ||
864759 | 864759 | 2020-11-12 | Italy | P.A. Bolzano | 15164 | 365 | 5564 | 9235 | 46.49933453 | 11.35662422 | 2020-11-13 05:25:30 | P.A. Bolzano, Italy | ||
2784994 | 2784994 | 2020-11-13 | Italy | P.A. Bolzano | 15984 | 374 | 5896 | 9714 | 46.49933453 | 11.35662422 | 2020-11-14 05:25:37 | P.A. Bolzano, Italy | ||
2915172 | 2915172 | 2020-11-14 | Italy | P.A. Bolzano | 16674 | 379 | 6236 | 10059 | 46.49933453 | 11.35662422 | 2020-11-15 05:26:53 | P.A. Bolzano, Italy | ||
2880194 | 2880194 | 2020-11-15 | Italy | P.A. Bolzano | 17302 | 398 | 6614 | 10290 | 46.49933453 | 11.35662422 | 2020-11-16 05:25:57 | P.A. Bolzano, Italy | ||
3169626 | 3169626 | 2020-11-16 | Italy | P.A. Bolzano | 17846 | 405 | 6873 | 10568 | 46.49933453 | 11.35662422 | 2020-11-17 05:25:54 | P.A. Bolzano, Italy | ||
3338581 | 3338581 | 2020-11-17 | Italy | P.A. Bolzano | 18104 | 414 | 6989 | 10701 | 46.49933453 | 11.35662422 | 2020-11-18 05:40:31 | P.A. Bolzano, Italy | ||
122693 | 122693 | 2020-11-18 | Italy | P.A. Bolzano | 18685 | 425 | 7359 | 10901 | 46.49933453 | 11.35662422 | 2020-11-19 05:25:23 | P.A. Bolzano, Italy | ||
821559 | 821559 | 2020-11-19 | Italy | P.A. Bolzano | 19381 | 438 | 7739 | 11204 | 46.49933453 | 11.35662422 | 2020-11-20 05:26:28 | P.A. Bolzano, Italy | ||
2701499 | 2701499 | 2020-11-20 | Italy | P.A. Bolzano | 20117 | 446 | 8160 | 11511 | 46.49933453 | 11.35662422 | 2020-11-21 05:25:51 | P.A. Bolzano, Italy | ||
3836471 | 3836471 | 2020-11-21 | Italy | P.A. Bolzano | 20665 | 462 | 8528 | 11675 | 46.49933453 | 11.35662422 | 2020-11-22 05:25:45 | P.A. Bolzano, Italy | ||
3189977 | 3189977 | 2020-11-22 | Italy | P.A. Bolzano | 21200 | 469 | 9107 | 11624 | 46.49933453 | 11.35662422 | 2020-11-23 05:25:26 | P.A. Bolzano, Italy | ||
678301 | 678301 | 2020-11-23 | Italy | P.A. Bolzano | 21460 | 474 | 9371 | 11615 | 46.49933453 | 11.35662422 | 2020-11-24 05:27:31 | P.A. Bolzano, Italy | ||
1350307 | 1350307 | 2020-11-24 | Italy | P.A. Bolzano | 21620 | 490 | 9474 | 11656 | 46.49933453 | 11.35662422 | 2020-11-25 05:27:20 | P.A. Bolzano, Italy | ||
1972576 | 1972576 | 2020-11-25 | Italy | P.A. Bolzano | 21961 | 498 | 9863 | 11600 | 46.49933453 | 11.35662422 | 2020-11-26 05:27:44 | P.A. Bolzano, Italy | ||
923671 | 923671 | 2020-11-26 | Italy | P.A. Bolzano | 22253 | 509 | 10294 | 11450 | 46.49933453 | 11.35662422 | 2020-11-27 05:26:53 | P.A. Bolzano, Italy | ||
392224 | 392224 | 2020-11-27 | Italy | P.A. Bolzano | 22663 | 520 | 10660 | 11483 | 46.49933453 | 11.35662422 | 2020-11-28 05:25:50 | P.A. Bolzano, Italy | ||
2935221 | 2935221 | 2020-11-28 | Italy | P.A. Bolzano | 23157 | 523 | 11076 | 11558 | 46.49933453 | 11.35662422 | 2020-11-29 05:25:55 | P.A. Bolzano, Italy | ||
3566556 | 3566556 | 2020-11-29 | Italy | P.A. Bolzano | 23594 | 530 | 11727 | 11337 | 46.49933453 | 11.35662422 | 2020-11-30 05:26:13 | P.A. Bolzano, 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]);