johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where province_or_state = "Valle d'Aosta" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331903 | 331903 | 2021-08-04 | Italy | Valle d'Aosta | 11808 | 473 | 11244 | 91 | 45.73750286 | 7.320149366 | 2021-08-05 04:21:51 | Valle d'Aosta, Italy | ||
3468174 | 3468174 | 2021-08-03 | Italy | Valle d'Aosta | 11799 | 473 | 11243 | 83 | 45.73750286 | 7.320149366 | 2021-08-04 04:21:25 | Valle d'Aosta, Italy | ||
3015347 | 3015347 | 2021-08-01 | Italy | Valle d'Aosta | 11769 | 473 | 11238 | 58 | 45.73750286 | 7.320149366 | 2021-08-02 04:21:36 | Valle d'Aosta, Italy | ||
3683448 | 3683448 | 2021-08-02 | Italy | Valle d'Aosta | 11771 | 473 | 11238 | 60 | 45.73750286 | 7.320149366 | 2021-08-03 04:21:39 | Valle d'Aosta, Italy | ||
3903970 | 3903970 | 2021-07-31 | Italy | Valle d'Aosta | 11765 | 473 | 11235 | 57 | 45.73750286 | 7.320149366 | 2021-08-01 04:21:50 | Valle d'Aosta, Italy | ||
3296175 | 3296175 | 2021-07-30 | Italy | Valle d'Aosta | 11761 | 473 | 11228 | 60 | 45.73750286 | 7.320149366 | 2021-07-31 04:21:35 | Valle d'Aosta, Italy | ||
408291 | 408291 | 2021-07-28 | Italy | Valle d'Aosta | 11751 | 473 | 11227 | 51 | 45.73750286 | 7.320149366 | 2021-07-29 04:21:33 | Valle d'Aosta, Italy | ||
3385386 | 3385386 | 2021-07-29 | Italy | Valle d'Aosta | 11755 | 473 | 11227 | 55 | 45.73750286 | 7.320149366 | 2021-07-30 04:21:34 | Valle d'Aosta, Italy | ||
1306152 | 1306152 | 2021-07-27 | Italy | Valle d'Aosta | 11748 | 473 | 11224 | 51 | 45.73750286 | 7.320149366 | 2021-07-28 04:21:39 | Valle d'Aosta, Italy | ||
1378504 | 1378504 | 2021-07-25 | Italy | Valle d'Aosta | 11743 | 473 | 11224 | 46 | 45.73750286 | 7.320149366 | 2021-07-26 04:21:28 | Valle d'Aosta, Italy | ||
3218295 | 3218295 | 2021-07-26 | Italy | Valle d'Aosta | 11743 | 473 | 11224 | 46 | 45.73750286 | 7.320149366 | 2021-07-27 04:21:18 | Valle d'Aosta, Italy | ||
1330244 | 1330244 | 2021-07-24 | Italy | Valle d'Aosta | 11738 | 473 | 11220 | 45 | 45.73750286 | 7.320149366 | 2021-07-25 04:22:12 | Valle d'Aosta, Italy | ||
3137548 | 3137548 | 2021-07-23 | Italy | Valle d'Aosta | 11732 | 473 | 11219 | 40 | 45.73750286 | 7.320149366 | 2021-07-24 00:21:36 | Valle d'Aosta, Italy | ||
3476308 | 3476308 | 2021-07-22 | Italy | Valle d'Aosta | 11720 | 473 | 11219 | 28 | 45.73750286 | 7.320149366 | 2021-07-23 04:21:29 | Valle d'Aosta, Italy | ||
3331527 | 3331527 | 2021-07-21 | Italy | Valle d'Aosta | 11716 | 473 | 11217 | 26 | 45.73750286 | 7.320149366 | 2021-07-22 04:21:19 | Valle d'Aosta, Italy | ||
2371508 | 2371508 | 2021-07-20 | Italy | Valle d'Aosta | 11715 | 473 | 11214 | 28 | 45.73750286 | 7.320149366 | 2021-07-21 04:21:40 | Valle d'Aosta, Italy | ||
483587 | 483587 | 2021-07-19 | Italy | Valle d'Aosta | 11712 | 473 | 11213 | 26 | 45.73750286 | 7.320149366 | 2021-07-20 04:21:48 | Valle d'Aosta, Italy | ||
2673810 | 2673810 | 2021-07-18 | Italy | Valle d'Aosta | 11712 | 473 | 11213 | 26 | 45.73750286 | 7.320149366 | 2021-07-19 04:21:24 | Valle d'Aosta, Italy | ||
2947353 | 2947353 | 2021-07-16 | Italy | Valle d'Aosta | 11708 | 473 | 11213 | 22 | 45.73750286 | 7.320149366 | 2021-07-17 04:22:22 | Valle d'Aosta, Italy | ||
3706122 | 3706122 | 2021-07-17 | Italy | Valle d'Aosta | 11710 | 473 | 11213 | 24 | 45.73750286 | 7.320149366 | 2021-07-18 04:22:07 | Valle d'Aosta, Italy | ||
296009 | 296009 | 2021-07-15 | Italy | Valle d'Aosta | 11703 | 473 | 11211 | 19 | 45.73750286 | 7.320149366 | 2021-07-16 04:21:22 | Valle d'Aosta, Italy | ||
3631954 | 3631954 | 2021-07-14 | Italy | Valle d'Aosta | 11703 | 473 | 11211 | 19 | 45.73750286 | 7.320149366 | 2021-07-15 04:21:48 | Valle d'Aosta, Italy | ||
578829 | 578829 | 2021-07-13 | Italy | Valle d'Aosta | 11703 | 474 | 11210 | 19 | 45.73750286 | 7.320149366 | 2021-07-14 04:21:35 | Valle d'Aosta, Italy | ||
625875 | 625875 | 2021-07-10 | Italy | Valle d'Aosta | 11700 | 473 | 11207 | 20 | 45.73750286 | 7.320149366 | 2021-07-11 04:21:43 | Valle d'Aosta, Italy | ||
3659591 | 3659591 | 2021-07-11 | Italy | Valle d'Aosta | 11702 | 473 | 11207 | 22 | 45.73750286 | 7.320149366 | 2021-07-12 04:21:34 | Valle d'Aosta, Italy | ||
3741078 | 3741078 | 2021-07-12 | Italy | Valle d'Aosta | 11702 | 473 | 11207 | 22 | 45.73750286 | 7.320149366 | 2021-07-13 04:21:18 | Valle d'Aosta, Italy | ||
829594 | 829594 | 2021-07-09 | Italy | Valle d'Aosta | 11700 | 473 | 11204 | 23 | 45.73750286 | 7.320149366 | 2021-07-10 04:21:25 | Valle d'Aosta, Italy | ||
778358 | 778358 | 2021-07-08 | Italy | Valle d'Aosta | 11699 | 473 | 11202 | 24 | 45.73750286 | 7.320149366 | 2021-07-09 04:21:21 | Valle d'Aosta, Italy | ||
1440580 | 1440580 | 2021-07-07 | Italy | Valle d'Aosta | 11697 | 473 | 11202 | 22 | 45.73750286 | 7.320149366 | 2021-07-08 04:21:26 | Valle d'Aosta, Italy | ||
2693685 | 2693685 | 2021-07-06 | Italy | Valle d'Aosta | 11696 | 473 | 11201 | 22 | 45.73750286 | 7.320149366 | 2021-07-07 04:21:20 | Valle d'Aosta, Italy | ||
1165165 | 1165165 | 2021-07-04 | Italy | Valle d'Aosta | 11696 | 473 | 11191 | 32 | 45.73750286 | 7.320149366 | 2021-07-05 04:21:28 | Valle d'Aosta, Italy | ||
1932434 | 1932434 | 2021-07-05 | Italy | Valle d'Aosta | 11696 | 473 | 11191 | 32 | 45.73750286 | 7.320149366 | 2021-07-06 04:21:32 | Valle d'Aosta, Italy | ||
1495599 | 1495599 | 2021-07-03 | Italy | Valle d'Aosta | 11696 | 473 | 11189 | 34 | 45.73750286 | 7.320149366 | 2021-07-04 04:21:38 | Valle d'Aosta, Italy | ||
2071914 | 2071914 | 2021-07-02 | Italy | Valle d'Aosta | 11693 | 473 | 11186 | 34 | 45.73750286 | 7.320149366 | 2021-07-03 04:21:37 | Valle d'Aosta, Italy | ||
2764930 | 2764930 | 2021-07-01 | Italy | Valle d'Aosta | 11693 | 473 | 11184 | 36 | 45.73750286 | 7.320149366 | 2021-07-02 04:21:47 | Valle d'Aosta, Italy | ||
1893138 | 1893138 | 2021-06-30 | Italy | Valle d'Aosta | 11691 | 473 | 11183 | 35 | 45.73750286 | 7.320149366 | 2021-07-01 04:21:19 | Valle d'Aosta, Italy | ||
400261 | 400261 | 2021-06-29 | Italy | Valle d'Aosta | 11688 | 473 | 11178 | 37 | 45.73750286 | 7.320149366 | 2021-06-30 04:21:41 | Valle d'Aosta, Italy | ||
3125504 | 3125504 | 2021-06-28 | Italy | Valle d'Aosta | 11685 | 473 | 11177 | 35 | 45.73750286 | 7.320149366 | 2021-06-29 04:21:28 | Valle d'Aosta, Italy | ||
2589999 | 2589999 | 2021-06-27 | Italy | Valle d'Aosta | 11685 | 473 | 11176 | 36 | 45.73750286 | 7.320149366 | 2021-06-28 04:21:29 | Valle d'Aosta, Italy | ||
1712322 | 1712322 | 2021-06-25 | Italy | Valle d'Aosta | 11683 | 473 | 11173 | 37 | 45.73750286 | 7.320149366 | 2021-06-26 04:21:43 | Valle d'Aosta, Italy | ||
3958503 | 3958503 | 2021-06-26 | Italy | Valle d'Aosta | 11683 | 473 | 11173 | 37 | 45.73750286 | 7.320149366 | 2021-06-27 04:21:39 | Valle d'Aosta, Italy | ||
2295447 | 2295447 | 2021-06-24 | Italy | Valle d'Aosta | 11678 | 473 | 11170 | 35 | 45.73750286 | 7.320149366 | 2021-06-25 04:21:33 | Valle d'Aosta, Italy | ||
2422887 | 2422887 | 2021-06-23 | Italy | Valle d'Aosta | 11676 | 473 | 11165 | 38 | 45.73750286 | 7.320149366 | 2021-06-24 04:21:55 | Valle d'Aosta, Italy | ||
562964 | 562964 | 2021-06-22 | Italy | Valle d'Aosta | 11675 | 473 | 11157 | 45 | 45.73750286 | 7.320149366 | 2021-06-23 04:21:46 | Valle d'Aosta, Italy | ||
3358666 | 3358666 | 2021-06-21 | Italy | Valle d'Aosta | 11674 | 472 | 11150 | 52 | 45.73750286 | 7.320149366 | 2021-06-22 04:21:34 | Valle d'Aosta, Italy | ||
2884365 | 2884365 | 2021-06-20 | Italy | Valle d'Aosta | 11674 | 472 | 11145 | 57 | 45.73750286 | 7.320149366 | 2021-06-21 04:21:41 | Valle d'Aosta, Italy | ||
107448 | 107448 | 2021-06-19 | Italy | Valle d'Aosta | 11670 | 472 | 11137 | 61 | 45.73750286 | 7.320149366 | 2021-06-20 04:21:48 | Valle d'Aosta, Italy | ||
1125591 | 1125591 | 2021-06-18 | Italy | Valle d'Aosta | 11667 | 472 | 11131 | 64 | 45.73750286 | 7.320149366 | 2021-06-19 04:22:33 | Valle d'Aosta, Italy | ||
2911169 | 2911169 | 2021-06-17 | Italy | Valle d'Aosta | 11665 | 472 | 11119 | 74 | 45.73750286 | 7.320149366 | 2021-06-18 04:22:16 | Valle d'Aosta, Italy | ||
3030287 | 3030287 | 2021-06-16 | Italy | Valle d'Aosta | 11662 | 472 | 11109 | 81 | 45.73750286 | 7.320149366 | 2021-06-17 04:22:36 | Valle d'Aosta, Italy | ||
2339393 | 2339393 | 2021-06-15 | Italy | Valle d'Aosta | 11661 | 472 | 11099 | 90 | 45.73750286 | 7.320149366 | 2021-06-16 04:22:32 | Valle d'Aosta, Italy | ||
1564089 | 1564089 | 2021-06-14 | Italy | Valle d'Aosta | 11658 | 472 | 11090 | 96 | 45.73750286 | 7.320149366 | 2021-06-15 04:22:22 | Valle d'Aosta, Italy | ||
3381372 | 3381372 | 2021-06-13 | Italy | Valle d'Aosta | 11656 | 472 | 11089 | 95 | 45.73750286 | 7.320149366 | 2021-06-14 04:22:46 | Valle d'Aosta, Italy | ||
1736506 | 1736506 | 2021-06-12 | Italy | Valle d'Aosta | 11655 | 472 | 11082 | 101 | 45.73750286 | 7.320149366 | 2021-06-13 04:22:44 | Valle d'Aosta, Italy | ||
3970547 | 3970547 | 2021-06-11 | Italy | Valle d'Aosta | 11653 | 472 | 11069 | 112 | 45.73750286 | 7.320149366 | 2021-06-12 04:22:22 | Valle d'Aosta, Italy | ||
2716969 | 2716969 | 2021-06-10 | Italy | Valle d'Aosta | 11649 | 472 | 11061 | 116 | 45.73750286 | 7.320149366 | 2021-06-11 04:23:20 | Valle d'Aosta, Italy | ||
522854 | 522854 | 2021-06-09 | Italy | Valle d'Aosta | 11641 | 472 | 11051 | 118 | 45.73750286 | 7.320149366 | 2021-06-10 04:23:17 | Valle d'Aosta, Italy | ||
3472294 | 3472294 | 2021-06-08 | Italy | Valle d'Aosta | 11637 | 472 | 11035 | 130 | 45.73750286 | 7.320149366 | 2021-06-09 04:23:31 | Valle d'Aosta, Italy | ||
3145578 | 3145578 | 2021-06-07 | Italy | Valle d'Aosta | 11629 | 472 | 11006 | 151 | 45.73750286 | 7.320149366 | 2021-06-08 04:22:35 | Valle d'Aosta, Italy | ||
825580 | 825580 | 2021-06-06 | Italy | Valle d'Aosta | 11626 | 472 | 11005 | 149 | 45.73750286 | 7.320149366 | 2021-06-07 04:22:51 | Valle d'Aosta, Italy | ||
2585985 | 2585985 | 2021-06-05 | Italy | Valle d'Aosta | 11621 | 472 | 10989 | 160 | 45.73750286 | 7.320149366 | 2021-06-06 04:24:03 | Valle d'Aosta, Italy | ||
2315299 | 2315299 | 2021-06-04 | Italy | Valle d'Aosta | 11616 | 472 | 10977 | 167 | 45.73750286 | 7.320149366 | 2021-06-05 04:23:03 | Valle d'Aosta, Italy | ||
1448584 | 1448584 | 2021-06-03 | Italy | Valle d'Aosta | 11611 | 472 | 10957 | 182 | 45.73750286 | 7.320149366 | 2021-06-04 04:23:37 | Valle d'Aosta, Italy | ||
1708308 | 1708308 | 2021-06-02 | Italy | Valle d'Aosta | 11609 | 472 | 10933 | 204 | 45.73750286 | 7.320149366 | 2021-06-03 04:23:32 | Valle d'Aosta, Italy | ||
2104126 | 2104126 | 2021-06-01 | Italy | Valle d'Aosta | 11601 | 472 | 10917 | 212 | 45.73750286 | 7.320149366 | 2021-06-02 04:24:34 | Valle d'Aosta, Italy | ||
1188742 | 1188742 | 2021-05-31 | Italy | Valle d'Aosta | 11593 | 472 | 10885 | 236 | 45.73750286 | 7.320149366 | 2021-06-01 04:23:09 | Valle d'Aosta, Italy | ||
3089419 | 3089419 | 2021-05-30 | Italy | Valle d'Aosta | 11583 | 472 | 10883 | 228 | 45.73750286 | 7.320149366 | 2021-05-31 03:08:59 | Valle d'Aosta, Italy | ||
50788 | 50788 | 2021-05-29 | Italy | Valle d'Aosta | 11567 | 472 | 10868 | 227 | 45.73750286 | 7.320149366 | 2021-05-30 04:20:55 | Valle d'Aosta, Italy | ||
20367 | 20367 | 2021-05-28 | Italy | Valle d'Aosta | 11545 | 472 | 10853 | 220 | 45.73750286 | 7.320149366 | 2021-05-29 04:20:41 | Valle d'Aosta, Italy | ||
1806742 | 1806742 | 2021-05-27 | Italy | Valle d'Aosta | 11541 | 472 | 10834 | 235 | 45.73750286 | 7.320149366 | 2021-05-28 04:20:36 | Valle d'Aosta, Italy | ||
1310166 | 1310166 | 2021-05-26 | Italy | Valle d'Aosta | 11534 | 472 | 10820 | 242 | 45.73750286 | 7.320149366 | 2021-05-27 04:20:59 | Valle d'Aosta, Italy | ||
83092 | 83092 | 2021-05-25 | Italy | Valle d'Aosta | 11525 | 472 | 10795 | 258 | 45.73750286 | 7.320149366 | 2021-05-26 04:20:35 | Valle d'Aosta, Italy | ||
1413054 | 1413054 | 2021-05-24 | Italy | Valle d'Aosta | 11504 | 471 | 10748 | 285 | 45.73750286 | 7.320149366 | 2021-05-25 04:21:08 | Valle d'Aosta, Italy | ||
1771340 | 1771340 | 2021-05-23 | Italy | Valle d'Aosta | 11499 | 471 | 10733 | 295 | 45.73750286 | 7.320149366 | 2021-05-24 04:20:53 | Valle d'Aosta, Italy | ||
726495 | 726495 | 2021-05-22 | Italy | Valle d'Aosta | 11484 | 471 | 10698 | 315 | 45.73750286 | 7.320149366 | 2021-05-23 04:20:51 | Valle d'Aosta, Italy | ||
1952510 | 1952510 | 2021-05-21 | Italy | Valle d'Aosta | 11456 | 471 | 10660 | 325 | 45.73750286 | 7.320149366 | 2021-05-22 04:20:45 | Valle d'Aosta, Italy | ||
1913209 | 1913209 | 2021-05-20 | Italy | Valle d'Aosta | 11443 | 471 | 10628 | 344 | 45.73750286 | 7.320149366 | 2021-05-21 04:20:43 | Valle d'Aosta, Italy | ||
2255730 | 2255730 | 2021-05-19 | Italy | Valle d'Aosta | 11425 | 471 | 10600 | 354 | 45.73750286 | 7.320149366 | 2021-05-20 04:21:05 | Valle d'Aosta, Italy | ||
2390768 | 2390768 | 2021-05-18 | Italy | Valle d'Aosta | 11402 | 469 | 10546 | 387 | 45.73750286 | 7.320149366 | 2021-05-19 04:20:42 | Valle d'Aosta, Italy | ||
3574593 | 3574593 | 2021-05-17 | Italy | Valle d'Aosta | 11393 | 468 | 10483 | 442 | 45.73750286 | 7.320149366 | 2021-05-18 04:20:33 | Valle d'Aosta, Italy | ||
2939323 | 2939323 | 2021-05-16 | Italy | Valle d'Aosta | 11384 | 467 | 10466 | 451 | 45.73750286 | 7.320149366 | 2021-05-17 04:20:34 | Valle d'Aosta, Italy | ||
1872953 | 1872953 | 2021-05-15 | Italy | Valle d'Aosta | 11364 | 467 | 10425 | 472 | 45.73750286 | 7.320149366 | 2021-05-16 04:20:49 | Valle d'Aosta, Italy | ||
1081922 | 1081922 | 2021-05-14 | Italy | Valle d'Aosta | 11354 | 466 | 10372 | 516 | 45.73750286 | 7.320149366 | 2021-05-15 04:20:58 | Valle d'Aosta, Italy | ||
3054188 | 3054188 | 2021-05-13 | Italy | Valle d'Aosta | 11311 | 466 | 10342 | 503 | 45.73750286 | 7.320149366 | 2021-05-14 04:20:41 | Valle d'Aosta, Italy | ||
2004658 | 2004658 | 2021-05-12 | Italy | Valle d'Aosta | 11282 | 466 | 10303 | 513 | 45.73750286 | 7.320149366 | 2021-05-13 04:20:51 | Valle d'Aosta, Italy | ||
3954489 | 3954489 | 2021-05-11 | Italy | Valle d'Aosta | 11259 | 464 | 10261 | 534 | 45.73750286 | 7.320149366 | 2021-05-12 04:21:29 | Valle d'Aosta, Italy | ||
2820768 | 2820768 | 2021-05-10 | Italy | Valle d'Aosta | 11236 | 463 | 10205 | 568 | 45.73750286 | 7.320149366 | 2021-05-11 04:20:41 | Valle d'Aosta, Italy | ||
1425100 | 1425100 | 2021-05-09 | Italy | Valle d'Aosta | 11217 | 462 | 10163 | 592 | 45.73750286 | 7.320149366 | 2021-05-10 04:20:38 | Valle d'Aosta, Italy | ||
1551968 | 1551968 | 2021-05-08 | Italy | Valle d'Aosta | 11209 | 462 | 10142 | 605 | 45.73750286 | 7.320149366 | 2021-05-09 04:20:35 | Valle d'Aosta, Italy | ||
2502026 | 2502026 | 2021-05-07 | Italy | Valle d'Aosta | 11169 | 461 | 10078 | 630 | 45.73750286 | 7.320149366 | 2021-05-08 04:21:04 | Valle d'Aosta, Italy | ||
3113482 | 3113482 | 2021-05-06 | Italy | Valle d'Aosta | 11118 | 461 | 10047 | 610 | 45.73750286 | 7.320149366 | 2021-05-07 04:20:40 | Valle d'Aosta, Italy | ||
645949 | 645949 | 2021-05-05 | Italy | Valle d'Aosta | 11078 | 460 | 9988 | 630 | 45.73750286 | 7.320149366 | 2021-05-06 04:20:38 | Valle d'Aosta, Italy | ||
3675649 | 3675649 | 2021-05-04 | Italy | Valle d'Aosta | 11066 | 459 | 9922 | 685 | 45.73750286 | 7.320149366 | 2021-05-05 04:20:43 | Valle d'Aosta, Italy | ||
2760916 | 2760916 | 2021-05-03 | Italy | Valle d'Aosta | 11041 | 459 | 9867 | 715 | 45.73750286 | 7.320149366 | 2021-05-04 04:20:34 | Valle d'Aosta, Italy | ||
2450769 | 2450769 | 2021-05-02 | Italy | Valle d'Aosta | 11013 | 459 | 9856 | 698 | 45.73750286 | 7.320149366 | 2021-05-03 04:20:39 | Valle d'Aosta, Italy | ||
2824782 | 2824782 | 2021-05-01 | Italy | Valle d'Aosta | 10990 | 459 | 9804 | 727 | 45.73750286 | 7.320149366 | 2021-05-02 04:20:48 | Valle d'Aosta, Italy | ||
380190 | 380190 | 2021-04-30 | Italy | Valle d'Aosta | 10932 | 458 | 9725 | 749 | 45.73750286 | 7.320149366 | 2021-05-01 04:20:47 | Valle d'Aosta, Italy | ||
1636313 | 1636313 | 2021-04-29 | Italy | Valle d'Aosta | 10884 | 455 | 9665 | 764 | 45.73750286 | 7.320149366 | 2021-04-30 04:21:03 | Valle d'Aosta, Italy | ||
3393392 | 3393392 | 2021-04-28 | Italy | Valle d'Aosta | 10823 | 455 | 9618 | 750 | 45.73750286 | 7.320149366 | 2021-04-29 04:20:55 | Valle d'Aosta, Italy | ||
3702108 | 3702108 | 2021-04-27 | Italy | Valle d'Aosta | 10786 | 454 | 9549 | 783 | 45.73750286 | 7.320149366 | 2021-04-28 04:20:32 | Valle d'Aosta, 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]);