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 = "Abruzzo" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- …
province_or_state 1
- Abruzzo · 403 ✖
country_or_region 1
- Italy · 403 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884346 | 2884346 | 2021-06-20 | Italy | Abruzzo | 74628 | 2509 | 70844 | 1275 | 42.35122196 | 13.39843823 | 2021-06-21 04:21:41 | Abruzzo, Italy | ||
107429 | 107429 | 2021-06-19 | Italy | Abruzzo | 74601 | 2509 | 70837 | 1255 | 42.35122196 | 13.39843823 | 2021-06-20 04:21:48 | Abruzzo, Italy | ||
1125572 | 1125572 | 2021-06-18 | Italy | Abruzzo | 74570 | 2507 | 70786 | 1277 | 42.35122196 | 13.39843823 | 2021-06-19 04:22:33 | Abruzzo, Italy | ||
2911150 | 2911150 | 2021-06-17 | Italy | Abruzzo | 74545 | 2507 | 70736 | 1302 | 42.35122196 | 13.39843823 | 2021-06-18 04:22:16 | Abruzzo, Italy | ||
3030268 | 3030268 | 2021-06-16 | Italy | Abruzzo | 74523 | 2506 | 70658 | 1359 | 42.35122196 | 13.39843823 | 2021-06-17 04:22:36 | Abruzzo, Italy | ||
2339374 | 2339374 | 2021-06-15 | Italy | Abruzzo | 74496 | 2503 | 70616 | 1377 | 42.35122196 | 13.39843823 | 2021-06-16 04:22:32 | Abruzzo, Italy | ||
1564070 | 1564070 | 2021-06-14 | Italy | Abruzzo | 74469 | 2502 | 70494 | 1473 | 42.35122196 | 13.39843823 | 2021-06-15 04:22:22 | Abruzzo, Italy | ||
3381353 | 3381353 | 2021-06-13 | Italy | Abruzzo | 74464 | 2502 | 70433 | 1529 | 42.35122196 | 13.39843823 | 2021-06-14 04:22:46 | Abruzzo, Italy | ||
1736487 | 1736487 | 2021-06-12 | Italy | Abruzzo | 74450 | 2502 | 70432 | 1516 | 42.35122196 | 13.39843823 | 2021-06-13 04:22:44 | Abruzzo, Italy | ||
3970528 | 3970528 | 2021-06-11 | Italy | Abruzzo | 74421 | 2500 | 70389 | 1532 | 42.35122196 | 13.39843823 | 2021-06-12 04:22:22 | Abruzzo, Italy | ||
2716950 | 2716950 | 2021-06-10 | Italy | Abruzzo | 74399 | 2499 | 70248 | 1652 | 42.35122196 | 13.39843823 | 2021-06-11 04:23:20 | Abruzzo, Italy | ||
522835 | 522835 | 2021-06-09 | Italy | Abruzzo | 74362 | 2498 | 70029 | 1835 | 42.35122196 | 13.39843823 | 2021-06-10 04:23:17 | Abruzzo, Italy | ||
3472275 | 3472275 | 2021-06-08 | Italy | Abruzzo | 74314 | 2498 | 69355 | 2461 | 42.35122196 | 13.39843823 | 2021-06-09 04:23:31 | Abruzzo, Italy | ||
3145559 | 3145559 | 2021-06-07 | Italy | Abruzzo | 74289 | 2496 | 67218 | 4575 | 42.35122196 | 13.39843823 | 2021-06-08 04:22:35 | Abruzzo, Italy | ||
825561 | 825561 | 2021-06-06 | Italy | Abruzzo | 74277 | 2491 | 66634 | 5152 | 42.35122196 | 13.39843823 | 2021-06-07 04:22:51 | Abruzzo, Italy | ||
2585966 | 2585966 | 2021-06-05 | Italy | Abruzzo | 74238 | 2490 | 66634 | 5114 | 42.35122196 | 13.39843823 | 2021-06-06 04:24:03 | Abruzzo, Italy | ||
2315280 | 2315280 | 2021-06-04 | Italy | Abruzzo | 74196 | 2490 | 66561 | 5145 | 42.35122196 | 13.39843823 | 2021-06-05 04:23:03 | Abruzzo, Italy | ||
1448565 | 1448565 | 2021-06-03 | Italy | Abruzzo | 74151 | 2486 | 66387 | 5278 | 42.35122196 | 13.39843823 | 2021-06-04 04:23:37 | Abruzzo, Italy | ||
1708289 | 1708289 | 2021-06-02 | Italy | Abruzzo | 74142 | 2484 | 66327 | 5331 | 42.35122196 | 13.39843823 | 2021-06-03 04:23:32 | Abruzzo, Italy | ||
2104107 | 2104107 | 2021-06-01 | Italy | Abruzzo | 74075 | 2484 | 66251 | 5340 | 42.35122196 | 13.39843823 | 2021-06-02 04:24:34 | Abruzzo, Italy | ||
1188723 | 1188723 | 2021-05-31 | Italy | Abruzzo | 74040 | 2482 | 66065 | 5493 | 42.35122196 | 13.39843823 | 2021-06-01 04:23:09 | Abruzzo, Italy | ||
3089400 | 3089400 | 2021-05-30 | Italy | Abruzzo | 74025 | 2480 | 65986 | 5559 | 42.35122196 | 13.39843823 | 2021-05-31 03:08:59 | Abruzzo, Italy | ||
50769 | 50769 | 2021-05-29 | Italy | Abruzzo | 73972 | 2480 | 65983 | 5509 | 42.35122196 | 13.39843823 | 2021-05-30 04:20:55 | Abruzzo, Italy | ||
20348 | 20348 | 2021-05-28 | Italy | Abruzzo | 73917 | 2478 | 65935 | 5504 | 42.35122196 | 13.39843823 | 2021-05-29 04:20:41 | Abruzzo, Italy | ||
1806723 | 1806723 | 2021-05-27 | Italy | Abruzzo | 73874 | 2475 | 65780 | 5619 | 42.35122196 | 13.39843823 | 2021-05-28 04:20:36 | Abruzzo, Italy | ||
1310147 | 1310147 | 2021-05-26 | Italy | Abruzzo | 73810 | 2473 | 65652 | 5685 | 42.35122196 | 13.39843823 | 2021-05-27 04:20:59 | Abruzzo, Italy | ||
83073 | 83073 | 2021-05-25 | Italy | Abruzzo | 73744 | 2471 | 65449 | 5824 | 42.35122196 | 13.39843823 | 2021-05-26 04:20:35 | Abruzzo, Italy | ||
1413035 | 1413035 | 2021-05-24 | Italy | Abruzzo | 73704 | 2469 | 65327 | 5908 | 42.35122196 | 13.39843823 | 2021-05-25 04:21:08 | Abruzzo, Italy | ||
1771321 | 1771321 | 2021-05-23 | Italy | Abruzzo | 73689 | 2468 | 65254 | 5967 | 42.35122196 | 13.39843823 | 2021-05-24 04:20:53 | Abruzzo, Italy | ||
726476 | 726476 | 2021-05-22 | Italy | Abruzzo | 73621 | 2466 | 65254 | 5901 | 42.35122196 | 13.39843823 | 2021-05-23 04:20:51 | Abruzzo, Italy | ||
1952491 | 1952491 | 2021-05-21 | Italy | Abruzzo | 73493 | 2465 | 65198 | 5830 | 42.35122196 | 13.39843823 | 2021-05-22 04:20:45 | Abruzzo, Italy | ||
1913190 | 1913190 | 2021-05-20 | Italy | Abruzzo | 73427 | 2463 | 65021 | 5943 | 42.35122196 | 13.39843823 | 2021-05-21 04:20:43 | Abruzzo, Italy | ||
2255711 | 2255711 | 2021-05-19 | Italy | Abruzzo | 73366 | 2465 | 64806 | 6095 | 42.35122196 | 13.39843823 | 2021-05-20 04:21:05 | Abruzzo, Italy | ||
2390749 | 2390749 | 2021-05-18 | Italy | Abruzzo | 73295 | 2460 | 64421 | 6414 | 42.35122196 | 13.39843823 | 2021-05-19 04:20:42 | Abruzzo, Italy | ||
3574574 | 3574574 | 2021-05-17 | Italy | Abruzzo | 73262 | 2457 | 63928 | 6877 | 42.35122196 | 13.39843823 | 2021-05-18 04:20:33 | Abruzzo, Italy | ||
2939304 | 2939304 | 2021-05-16 | Italy | Abruzzo | 73242 | 2454 | 63820 | 6968 | 42.35122196 | 13.39843823 | 2021-05-17 04:20:34 | Abruzzo, Italy | ||
1872934 | 1872934 | 2021-05-15 | Italy | Abruzzo | 73142 | 2453 | 63797 | 6892 | 42.35122196 | 13.39843823 | 2021-05-16 04:20:49 | Abruzzo, Italy | ||
1081903 | 1081903 | 2021-05-14 | Italy | Abruzzo | 73030 | 2452 | 63692 | 6886 | 42.35122196 | 13.39843823 | 2021-05-15 04:20:58 | Abruzzo, Italy | ||
3054169 | 3054169 | 2021-05-13 | Italy | Abruzzo | 72887 | 2450 | 63427 | 7010 | 42.35122196 | 13.39843823 | 2021-05-14 04:20:41 | Abruzzo, Italy | ||
2004639 | 2004639 | 2021-05-12 | Italy | Abruzzo | 72799 | 2447 | 63093 | 7259 | 42.35122196 | 13.39843823 | 2021-05-13 04:20:51 | Abruzzo, Italy | ||
3954470 | 3954470 | 2021-05-11 | Italy | Abruzzo | 72649 | 2447 | 62531 | 7671 | 42.35122196 | 13.39843823 | 2021-05-12 04:21:29 | Abruzzo, Italy | ||
2820749 | 2820749 | 2021-05-10 | Italy | Abruzzo | 72570 | 2438 | 62280 | 7852 | 42.35122196 | 13.39843823 | 2021-05-11 04:20:41 | Abruzzo, Italy | ||
1425081 | 1425081 | 2021-05-09 | Italy | Abruzzo | 72516 | 2437 | 62132 | 7947 | 42.35122196 | 13.39843823 | 2021-05-10 04:20:38 | Abruzzo, Italy | ||
1551949 | 1551949 | 2021-05-08 | Italy | Abruzzo | 72371 | 2434 | 62115 | 7822 | 42.35122196 | 13.39843823 | 2021-05-09 04:20:35 | Abruzzo, Italy | ||
2502007 | 2502007 | 2021-05-07 | Italy | Abruzzo | 72286 | 2428 | 61947 | 7911 | 42.35122196 | 13.39843823 | 2021-05-08 04:21:04 | Abruzzo, Italy | ||
3113463 | 3113463 | 2021-05-06 | Italy | Abruzzo | 72090 | 2422 | 61506 | 8162 | 42.35122196 | 13.39843823 | 2021-05-07 04:20:40 | Abruzzo, Italy | ||
645930 | 645930 | 2021-05-05 | Italy | Abruzzo | 71916 | 2422 | 61333 | 8161 | 42.35122196 | 13.39843823 | 2021-05-06 04:20:38 | Abruzzo, Italy | ||
3675630 | 3675630 | 2021-05-04 | Italy | Abruzzo | 71724 | 2420 | 60938 | 8366 | 42.35122196 | 13.39843823 | 2021-05-05 04:20:43 | Abruzzo, Italy | ||
2760897 | 2760897 | 2021-05-03 | Italy | Abruzzo | 71640 | 2415 | 60613 | 8612 | 42.35122196 | 13.39843823 | 2021-05-04 04:20:34 | Abruzzo, Italy | ||
2450750 | 2450750 | 2021-05-02 | Italy | Abruzzo | 71603 | 2412 | 60458 | 8733 | 42.35122196 | 13.39843823 | 2021-05-03 04:20:39 | Abruzzo, Italy | ||
2824763 | 2824763 | 2021-05-01 | Italy | Abruzzo | 71444 | 2408 | 60457 | 8579 | 42.35122196 | 13.39843823 | 2021-05-02 04:20:48 | Abruzzo, Italy | ||
380171 | 380171 | 2021-04-30 | Italy | Abruzzo | 71218 | 2403 | 60432 | 8383 | 42.35122196 | 13.39843823 | 2021-05-01 04:20:47 | Abruzzo, Italy | ||
1636294 | 1636294 | 2021-04-29 | Italy | Abruzzo | 71067 | 2397 | 60119 | 8551 | 42.35122196 | 13.39843823 | 2021-04-30 04:21:03 | Abruzzo, Italy | ||
3393373 | 3393373 | 2021-04-28 | Italy | Abruzzo | 70873 | 2391 | 59926 | 8556 | 42.35122196 | 13.39843823 | 2021-04-29 04:20:55 | Abruzzo, Italy | ||
3702089 | 3702089 | 2021-04-27 | Italy | Abruzzo | 70696 | 2385 | 59697 | 8614 | 42.35122196 | 13.39843823 | 2021-04-28 04:20:32 | Abruzzo, Italy | ||
888098 | 888098 | 2021-04-26 | Italy | Abruzzo | 70615 | 2377 | 59181 | 9057 | 42.35122196 | 13.39843823 | 2021-04-27 04:20:52 | Abruzzo, Italy | ||
954843 | 954843 | 2021-04-25 | Italy | Abruzzo | 70519 | 2376 | 58998 | 9145 | 42.35122196 | 13.39843823 | 2021-04-26 04:21:04 | Abruzzo, Italy | ||
3923990 | 3923990 | 2021-04-24 | Italy | Abruzzo | 70340 | 2369 | 58961 | 9010 | 42.35122196 | 13.39843823 | 2021-04-25 04:20:32 | Abruzzo, Italy | ||
1409021 | 1409021 | 2021-04-23 | Italy | Abruzzo | 70203 | 2360 | 58607 | 9236 | 42.35122196 | 13.39843823 | 2021-04-24 04:20:38 | Abruzzo, Italy | ||
1568084 | 1568084 | 2021-04-22 | Italy | Abruzzo | 70045 | 2355 | 58270 | 9420 | 42.35122196 | 13.39843823 | 2021-04-23 04:20:52 | Abruzzo, Italy | ||
3242305 | 3242305 | 2021-04-21 | Italy | Abruzzo | 69812 | 2347 | 57951 | 9514 | 42.35122196 | 13.39843823 | 2021-04-22 04:20:53 | Abruzzo, Italy | ||
2020701 | 2020701 | 2021-04-20 | Italy | Abruzzo | 69650 | 2345 | 57800 | 9505 | 42.35122196 | 13.39843823 | 2021-04-21 04:21:14 | Abruzzo, Italy | ||
2410822 | 2410822 | 2021-04-19 | Italy | Abruzzo | 69480 | 2337 | 57385 | 9758 | 42.35122196 | 13.39843823 | 2021-04-20 04:20:41 | Abruzzo, Italy | ||
3129499 | 3129499 | 2021-04-18 | Italy | Abruzzo | 69384 | 2333 | 56951 | 10100 | 42.35122196 | 13.39843823 | 2021-04-19 04:20:57 | Abruzzo, Italy | ||
982927 | 982927 | 2021-04-17 | Italy | Abruzzo | 69126 | 2329 | 56926 | 9871 | 42.35122196 | 13.39843823 | 2021-04-18 04:20:41 | Abruzzo, Italy | ||
170022 | 170022 | 2021-04-16 | Italy | Abruzzo | 68948 | 2315 | 56737 | 9896 | 42.35122196 | 13.39843823 | 2021-04-17 04:20:40 | Abruzzo, Italy | ||
2548853 | 2548853 | 2021-04-15 | Italy | Abruzzo | 68741 | 2298 | 56211 | 10232 | 42.35122196 | 13.39843823 | 2021-04-16 04:20:46 | Abruzzo, Italy | ||
1841923 | 1841923 | 2021-04-14 | Italy | Abruzzo | 68527 | 2293 | 55968 | 10266 | 42.35122196 | 13.39843823 | 2021-04-15 04:20:54 | Abruzzo, Italy | ||
2571657 | 2571657 | 2021-04-13 | Italy | Abruzzo | 68265 | 2269 | 55735 | 10261 | 42.35122196 | 13.39843823 | 2021-04-14 04:20:41 | Abruzzo, Italy | ||
36408 | 36408 | 2021-04-12 | Italy | Abruzzo | 68091 | 2248 | 55433 | 10410 | 42.35122196 | 13.39843823 | 2021-04-13 04:20:37 | Abruzzo, Italy | ||
3883567 | 3883567 | 2021-04-11 | Italy | Abruzzo | 68002 | 2243 | 55299 | 10460 | 42.35122196 | 13.39843823 | 2021-04-12 04:21:00 | Abruzzo, Italy | ||
2983235 | 2983235 | 2021-04-10 | Italy | Abruzzo | 67743 | 2240 | 55277 | 10226 | 42.35122196 | 13.39843823 | 2021-04-11 04:20:56 | Abruzzo, Italy | ||
605667 | 605667 | 2021-04-09 | Italy | Abruzzo | 67506 | 2227 | 55076 | 10203 | 42.35122196 | 13.39843823 | 2021-04-10 04:20:59 | Abruzzo, Italy | ||
2645731 | 2645731 | 2021-04-08 | Italy | Abruzzo | 67155 | 2212 | 54656 | 10287 | 42.35122196 | 13.39843823 | 2021-04-09 04:21:13 | Abruzzo, Italy | ||
2247373 | 2247373 | 2021-04-07 | Italy | Abruzzo | 66878 | 2200 | 54281 | 10397 | 42.35122196 | 13.39843823 | 2021-04-08 04:21:13 | Abruzzo, Italy | ||
3003283 | 3003283 | 2021-04-06 | Italy | Abruzzo | 66660 | 2187 | 53902 | 10571 | 42.35122196 | 13.39843823 | 2021-04-07 04:20:53 | Abruzzo, Italy | ||
3085278 | 3085278 | 2021-04-05 | Italy | Abruzzo | 66613 | 2173 | 53724 | 10716 | 42.35122196 | 13.39843823 | 2021-04-06 04:20:32 | Abruzzo, Italy | ||
388201 | 388201 | 2021-04-04 | Italy | Abruzzo | 66594 | 2169 | 53697 | 10728 | 42.35122196 | 13.39843823 | 2021-04-05 04:20:35 | Abruzzo, Italy | ||
3710117 | 3710117 | 2021-04-03 | Italy | Abruzzo | 66156 | 2166 | 53691 | 10299 | 42.35122196 | 13.39843823 | 2021-04-04 04:20:49 | Abruzzo, Italy | ||
241233 | 241233 | 2021-04-02 | Italy | Abruzzo | 65931 | 2151 | 53440 | 10340 | 42.35122196 | 13.39843823 | 2021-04-03 04:20:44 | Abruzzo, Italy | ||
1302030 | 1302030 | 2021-04-01 | Italy | Abruzzo | 65508 | 2145 | 53222 | 10141 | 42.35122196 | 13.39843823 | 2021-04-02 04:20:36 | Abruzzo, Italy | ||
637902 | 637902 | 2021-03-31 | Italy | Abruzzo | 65237 | 2136 | 52969 | 10132 | 42.35122196 | 13.39843823 | 2021-04-01 04:27:05 | Abruzzo, Italy | ||
3643531 | 3643531 | 2021-03-30 | Italy | Abruzzo | 64924 | 2125 | 52539 | 10260 | 42.35122196 | 13.39843823 | 2021-03-31 04:26:25 | Abruzzo, Italy | ||
1289984 | 1289984 | 2021-03-29 | Italy | Abruzzo | 64774 | 2100 | 52112 | 10562 | 42.35122196 | 13.39843823 | 2021-03-30 04:26:23 | Abruzzo, Italy | ||
1535906 | 1535906 | 2021-03-28 | Italy | Abruzzo | 64550 | 2083 | 51801 | 10666 | 42.35122196 | 13.39843823 | 2021-03-29 04:28:35 | Abruzzo, Italy | ||
1219546 | 1219546 | 2021-03-27 | Italy | Abruzzo | 64281 | 2074 | 51794 | 10413 | 42.35122196 | 13.39843823 | 2021-03-28 05:28:10 | Abruzzo, Italy | ||
1880964 | 1880964 | 2021-03-26 | Italy | Abruzzo | 63933 | 2072 | 51411 | 10450 | 42.35122196 | 13.39843823 | 2021-03-27 05:25:04 | Abruzzo, Italy | ||
1980594 | 1980594 | 2021-03-25 | Italy | Abruzzo | 63541 | 2067 | 50987 | 10487 | 42.35122196 | 13.39843823 | 2021-03-26 05:26:55 | Abruzzo, Italy | ||
2780972 | 2780972 | 2021-03-24 | Italy | Abruzzo | 63231 | 2052 | 50528 | 10651 | 42.35122196 | 13.39843823 | 2021-03-25 05:27:00 | Abruzzo, Italy | ||
1798617 | 1798617 | 2021-03-23 | Italy | Abruzzo | 62902 | 2041 | 49966 | 10895 | 42.35122196 | 13.39843823 | 2021-03-24 05:25:40 | Abruzzo, Italy | ||
1203785 | 1203785 | 2021-03-22 | Italy | Abruzzo | 62714 | 2023 | 49623 | 11068 | 42.35122196 | 13.39843823 | 2021-03-23 05:26:18 | Abruzzo, Italy | ||
3369307 | 3369307 | 2021-03-21 | Italy | Abruzzo | 62525 | 2016 | 49327 | 11182 | 42.35122196 | 13.39843823 | 2021-03-22 05:25:43 | Abruzzo, Italy | ||
1744517 | 1744517 | 2021-03-20 | Italy | Abruzzo | 62172 | 2007 | 49292 | 10873 | 42.35122196 | 13.39843823 | 2021-03-21 05:25:44 | Abruzzo, Italy | ||
3420897 | 3420897 | 2021-03-19 | Italy | Abruzzo | 61803 | 1972 | 48868 | 10963 | 42.35122196 | 13.39843823 | 2021-03-20 05:25:46 | Abruzzo, Italy | ||
3452835 | 3452835 | 2021-03-18 | Italy | Abruzzo | 61387 | 1943 | 48342 | 11102 | 42.35122196 | 13.39843823 | 2021-03-19 05:26:09 | Abruzzo, Italy | ||
3621059 | 3621059 | 2021-03-17 | Italy | Abruzzo | 60928 | 1934 | 47316 | 11678 | 42.35122196 | 13.39843823 | 2021-03-18 05:26:22 | Abruzzo, Italy | ||
702383 | 702383 | 2021-03-16 | Italy | Abruzzo | 60626 | 1924 | 46330 | 12372 | 42.35122196 | 13.39843823 | 2021-03-17 05:25:07 | Abruzzo, Italy | ||
2055861 | 2055861 | 2021-03-15 | Italy | Abruzzo | 60416 | 1911 | 45699 | 12806 | 42.35122196 | 13.39843823 | 2021-03-16 05:25:13 | Abruzzo, Italy | ||
1732473 | 1732473 | 2021-03-14 | Italy | Abruzzo | 60088 | 1901 | 45347 | 12840 | 42.35122196 | 13.39843823 | 2021-03-15 05:25:51 | Abruzzo, Italy | ||
1580130 | 1580130 | 2021-03-13 | Italy | Abruzzo | 59765 | 1894 | 45235 | 12636 | 42.35122196 | 13.39843823 | 2021-03-14 05:25:37 | Abruzzo, 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]);