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 = "Emilia-Romagna" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002634 | 4002634 | 2022-10-08 | Italy | Emilia-Romagna | 1892394 | 18066 | 0 | 44.49436681 | 11.3417208 | 2022-10-09 04:21:16 | Emilia-Romagna, Italy | |||
3998617 | 3998617 | 2021-12-30 | Italy | Emilia-Romagna | 526757 | 14207 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-31 04:21:50 | Emilia-Romagna, Italy | |||
3994602 | 3994602 | 2022-09-27 | Italy | Emilia-Romagna | 1856353 | 18025 | 0 | 44.49436681 | 11.3417208 | 2022-09-28 04:23:01 | Emilia-Romagna, Italy | |||
3990592 | 3990592 | 2020-10-20 | Italy | Emilia-Romagna | 41917 | 4523 | 27226 | 10168 | 44.49436681 | 11.3417208 | 2020-10-21 04:24:14 | Emilia-Romagna, Italy | ||
3986591 | 3986591 | 2022-09-15 | Italy | Emilia-Romagna | 1840265 | 17970 | 0 | 44.49436681 | 11.3417208 | 2022-09-16 04:21:19 | Emilia-Romagna, Italy | |||
3982575 | 3982575 | 2022-06-15 | Italy | Emilia-Romagna | 1511020 | 17021 | 0 | 44.49436681 | 11.3417208 | 2022-06-16 04:20:55 | Emilia-Romagna, Italy | |||
3978559 | 3978559 | 2021-02-10 | Italy | Emilia-Romagna | 230078 | 9951 | 178414 | 41713 | 44.49436681 | 11.3417208 | 2021-02-11 05:23:55 | Emilia-Romagna, Italy | ||
3974546 | 3974546 | 2021-09-03 | Italy | Emilia-Romagna | 413508 | 13375 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-04 04:21:28 | Emilia-Romagna, Italy | |||
3970532 | 3970532 | 2021-06-11 | Italy | Emilia-Romagna | 385457 | 13230 | 363523 | 8704 | 44.49436681 | 11.3417208 | 2021-06-12 04:22:22 | Emilia-Romagna, Italy | ||
3966517 | 3966517 | 2022-07-05 | Italy | Emilia-Romagna | 1600308 | 17142 | 0 | 44.49436681 | 11.3417208 | 2022-07-06 04:20:58 | Emilia-Romagna, Italy | |||
3962502 | 3962502 | 2021-03-10 | Italy | Emilia-Romagna | 287136 | 10914 | 216774 | 59448 | 44.49436681 | 11.3417208 | 2021-03-11 05:25:48 | Emilia-Romagna, Italy | ||
3958488 | 3958488 | 2021-06-26 | Italy | Emilia-Romagna | 386634 | 13256 | 369543 | 3835 | 44.49436681 | 11.3417208 | 2021-06-27 04:21:39 | Emilia-Romagna, Italy | ||
3954474 | 3954474 | 2021-05-11 | Italy | Emilia-Romagna | 376939 | 13031 | 335032 | 28876 | 44.49436681 | 11.3417208 | 2021-05-12 04:21:29 | Emilia-Romagna, Italy | ||
3950459 | 3950459 | 2022-08-17 | Italy | Emilia-Romagna | 1798024 | 17759 | 0 | 44.49436681 | 11.3417208 | 2022-08-18 04:21:11 | Emilia-Romagna, Italy | |||
3940026 | 3940026 | 2022-06-30 | Italy | Emilia-Romagna | 1571638 | 17103 | 0 | 44.49436681 | 11.3417208 | 2022-07-01 04:21:10 | Emilia-Romagna, Italy | |||
3936010 | 3936010 | 2022-12-09 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-10 04:21:02 | Emilia-Romagna, Italy | |||
3932008 | 3932008 | 2020-08-30 | Italy | Emilia-Romagna | 31805 | 4459 | 24478 | 2868 | 44.49436681 | 11.3417208 | 2020-08-31 04:28:27 | Emilia-Romagna, Italy | ||
3928008 | 3928008 | 2021-10-02 | Italy | Emilia-Romagna | 424365 | 13477 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-03 04:21:24 | Emilia-Romagna, Italy | |||
3923994 | 3923994 | 2021-04-24 | Italy | Emilia-Romagna | 363782 | 12761 | 298618 | 52403 | 44.49436681 | 11.3417208 | 2021-04-25 04:20:32 | Emilia-Romagna, Italy | ||
3923091 | 3923091 | 2020-08-09 | Italy | Emilia-Romagna | 30121 | 4295 | 24066 | 1760 | 44.49436681 | 11.3417208 | 2020-08-10 04:34:55 | Emilia-Romagna, Italy | ||
3916002 | 3916002 | 2022-05-01 | Italy | Emilia-Romagna | 1415062 | 16631 | 0 | 44.49436681 | 11.3417208 | 2022-05-02 04:21:10 | Emilia-Romagna, Italy | |||
3911986 | 3911986 | 2022-02-20 | Italy | Emilia-Romagna | 1167308 | 15741 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-21 04:21:05 | Emilia-Romagna, Italy | |||
3907970 | 3907970 | 2022-08-11 | Italy | Emilia-Romagna | 1789249 | 17695 | 0 | 44.49436681 | 11.3417208 | 2022-08-12 04:20:54 | Emilia-Romagna, Italy | |||
3903955 | 3903955 | 2021-07-31 | Italy | Emilia-Romagna | 394328 | 13282 | 373914 | 7132 | 44.49436681 | 11.3417208 | 2021-08-01 04:21:50 | Emilia-Romagna, Italy | ||
3899942 | 3899942 | 2021-01-09 | Italy | Emilia-Romagna | 188701 | 8279 | 122054 | 58368 | 44.49436681 | 11.3417208 | 2021-01-10 05:22:12 | Emilia-Romagna, Italy | ||
3895928 | 3895928 | 2022-05-19 | Italy | Emilia-Romagna | 1468581 | 16839 | 0 | 44.49436681 | 11.3417208 | 2022-05-20 04:20:57 | Emilia-Romagna, Italy | |||
3891913 | 3891913 | 2021-08-29 | Italy | Emilia-Romagna | 410893 | 13353 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-30 04:21:23 | Emilia-Romagna, Italy | |||
3887586 | 3887586 | 2022-06-06 | Italy | Emilia-Romagna | 1494491 | 16976 | 0 | 44.49436681 | 11.3417208 | 2022-06-07 04:21:08 | Emilia-Romagna, Italy | |||
3883571 | 3883571 | 2021-04-11 | Italy | Emilia-Romagna | 350988 | 12380 | 271983 | 66625 | 44.49436681 | 11.3417208 | 2021-04-12 04:21:00 | Emilia-Romagna, Italy | ||
3879558 | 3879558 | 2021-01-14 | Italy | Emilia-Romagna | 197086 | 8590 | 132548 | 55948 | 44.49436681 | 11.3417208 | 2021-01-15 05:22:24 | Emilia-Romagna, Italy | ||
3875544 | 3875544 | 2022-02-19 | Italy | Emilia-Romagna | 1164370 | 15726 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-20 04:21:00 | Emilia-Romagna, Italy | |||
3871528 | 3871528 | 2022-07-31 | Italy | Emilia-Romagna | 1759194 | 17503 | 0 | 44.49436681 | 11.3417208 | 2022-08-01 04:21:03 | Emilia-Romagna, Italy | |||
3867512 | 3867512 | 2022-04-05 | Italy | Emilia-Romagna | 1301617 | 16314 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-06 04:20:49 | Emilia-Romagna, Italy | |||
3866672 | 3866672 | 2020-06-03 | Italy | Emilia-Romagna | 27842 | 4147 | 20856 | 2839 | 44.49436681 | 11.341720800000001 | 2020-06-04 02:33:14 | Emilia-Romagna, Italy | ||
3859813 | 3859813 | 2020-12-04 | Italy | Emilia-Romagna | 130009 | 6022 | 53931 | 70056 | 44.49436681 | 11.3417208 | 2020-12-05 05:27:36 | Emilia-Romagna, Italy | ||
3855800 | 3855800 | 2022-02-18 | Italy | Emilia-Romagna | 1161043 | 15705 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-19 04:21:11 | Emilia-Romagna, Italy | |||
3851784 | 3851784 | 2022-04-27 | Italy | Emilia-Romagna | 1395288 | 16588 | 0 | 44.49436681 | 11.3417208 | 2022-04-28 04:20:47 | Emilia-Romagna, Italy | |||
3847770 | 3847770 | 2020-12-13 | Italy | Emilia-Romagna | 144755 | 6572 | 73421 | 64762 | 44.49436681 | 11.3417208 | 2020-12-14 05:26:27 | Emilia-Romagna, Italy | ||
3840477 | 3840477 | 2022-01-15 | Italy | Emilia-Romagna | 789044 | 14536 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-16 04:21:12 | Emilia-Romagna, Italy | |||
3836464 | 3836464 | 2020-11-21 | Italy | Emilia-Romagna | 103064 | 5312 | 32672 | 65080 | 44.49436681 | 11.3417208 | 2020-11-22 05:25:45 | Emilia-Romagna, Italy | ||
3832452 | 3832452 | 2021-10-05 | Italy | Emilia-Romagna | 425088 | 13489 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-06 04:21:33 | Emilia-Romagna, Italy | |||
3828436 | 3828436 | 2021-12-21 | Italy | Emilia-Romagna | 494201 | 14049 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-22 04:21:54 | Emilia-Romagna, Italy | |||
3824421 | 3824421 | 2022-09-10 | Italy | Emilia-Romagna | 1834705 | 17947 | 0 | 44.49436681 | 11.3417208 | 2022-09-11 04:20:50 | Emilia-Romagna, Italy | |||
3820405 | 3820405 | 2022-02-16 | Italy | Emilia-Romagna | 1154135 | 15640 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-17 04:20:56 | Emilia-Romagna, Italy | |||
3816388 | 3816388 | 2021-12-23 | Italy | Emilia-Romagna | 499123 | 14082 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-24 04:21:34 | Emilia-Romagna, Italy | |||
3809899 | 3809899 | 2022-01-28 | Italy | Emilia-Romagna | 1013749 | 14980 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-29 04:21:10 | Emilia-Romagna, Italy | |||
3805885 | 3805885 | 2021-09-11 | Italy | Emilia-Romagna | 417342 | 13408 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-12 04:21:13 | Emilia-Romagna, Italy | |||
3801879 | 3801879 | 2020-10-05 | Italy | Emilia-Romagna | 36089 | 4487 | 26556 | 5046 | 44.49436681 | 11.3417208 | 2020-10-06 04:23:33 | Emilia-Romagna, Italy | ||
3797878 | 3797878 | 2022-08-20 | Italy | Emilia-Romagna | 1804062 | 17795 | 0 | 44.49436681 | 11.3417208 | 2022-08-21 04:20:44 | Emilia-Romagna, Italy | |||
3793861 | 3793861 | 2021-10-25 | Italy | Emilia-Romagna | 430099 | 13559 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-26 04:22:09 | Emilia-Romagna, Italy | |||
3792958 | 3792958 | 2020-08-05 | Italy | Emilia-Romagna | 29897 | 4291 | 23997 | 1609 | 44.49436681 | 11.3417208 | 2020-08-06 04:35:02 | Emilia-Romagna, Italy | ||
3785878 | 3785878 | 2020-10-11 | Italy | Emilia-Romagna | 37681 | 4495 | 26837 | 6349 | 44.49436681 | 11.3417208 | 2020-10-12 04:23:45 | Emilia-Romagna, Italy | ||
3781885 | 3781885 | 2020-10-13 | Italy | Emilia-Romagna | 38356 | 4498 | 26982 | 6876 | 44.49436681 | 11.3417208 | 2020-10-14 04:24:05 | Emilia-Romagna, Italy | ||
3777886 | 3777886 | 2020-12-27 | Italy | Emilia-Romagna | 166327 | 7493 | 100659 | 58175 | 44.49436681 | 11.3417208 | 2020-12-28 05:22:06 | Emilia-Romagna, Italy | ||
3773873 | 3773873 | 2022-08-30 | Italy | Emilia-Romagna | 1819487 | 17883 | 0 | 44.49436681 | 11.3417208 | 2022-08-31 04:20:57 | Emilia-Romagna, Italy | |||
3769859 | 3769859 | 2020-12-22 | Italy | Emilia-Romagna | 158345 | 7188 | 91411 | 59746 | 44.49436681 | 11.3417208 | 2020-12-23 05:22:03 | Emilia-Romagna, Italy | ||
3765846 | 3765846 | 2022-09-11 | Italy | Emilia-Romagna | 1835813 | 17952 | 0 | 44.49436681 | 11.3417208 | 2022-09-12 04:20:58 | Emilia-Romagna, Italy | |||
3761566 | 3761566 | 2020-12-28 | Italy | Emilia-Romagna | 167077 | 7524 | 101255 | 58298 | 44.49436681 | 11.3417208 | 2020-12-29 05:22:37 | Emilia-Romagna, Italy | ||
3757455 | 3757455 | 2021-09-21 | Italy | Emilia-Romagna | 421071 | 13440 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-22 04:21:45 | Emilia-Romagna, Italy | |||
3753440 | 3753440 | 2022-10-13 | Italy | Emilia-Romagna | 1910554 | 18114 | 0 | 44.49436681 | 11.3417208 | 2022-10-14 04:22:28 | Emilia-Romagna, Italy | |||
3749093 | 3749093 | 2021-11-22 | Italy | Emilia-Romagna | 446463 | 13710 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-23 04:22:39 | Emilia-Romagna, Italy | |||
3745078 | 3745078 | 2022-09-07 | Italy | Emilia-Romagna | 1830728 | 17932 | 0 | 44.49436681 | 11.3417208 | 2022-09-08 04:21:02 | Emilia-Romagna, Italy | |||
3741063 | 3741063 | 2021-07-12 | Italy | Emilia-Romagna | 387715 | 13268 | 372251 | 2196 | 44.49436681 | 11.3417208 | 2021-07-13 04:21:18 | Emilia-Romagna, Italy | ||
3737511 | 3737511 | 2020-07-12 | Italy | Emilia-Romagna | 28940 | 4269 | 23491 | 1180 | 44.49436681 | 11.341720800000001 | 2020-07-13 04:43:04 | Emilia-Romagna, Italy | ||
3730200 | 3730200 | 2022-04-03 | Italy | Emilia-Romagna | 1295322 | 16285 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-04 04:20:51 | Emilia-Romagna, Italy | |||
3726184 | 3726184 | 2022-06-07 | Italy | Emilia-Romagna | 1495765 | 16981 | 0 | 44.49436681 | 11.3417208 | 2022-06-08 04:20:55 | Emilia-Romagna, Italy | |||
3722168 | 3722168 | 2022-04-25 | Italy | Emilia-Romagna | 1390164 | 16548 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-26 04:20:51 | Emilia-Romagna, Italy | |||
3718152 | 3718152 | 2022-02-21 | Italy | Emilia-Romagna | 1169416 | 15754 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-22 04:21:01 | Emilia-Romagna, Italy | |||
3714136 | 3714136 | 2022-12-06 | Italy | Emilia-Romagna | 2045976 | 18531 | 0 | 44.49436681 | 11.3417208 | 2022-12-07 04:20:58 | Emilia-Romagna, Italy | |||
3710121 | 3710121 | 2021-04-03 | Italy | Emilia-Romagna | 341218 | 12078 | 256660 | 72480 | 44.49436681 | 11.3417208 | 2021-04-04 04:20:49 | Emilia-Romagna, Italy | ||
3706107 | 3706107 | 2021-07-17 | Italy | Emilia-Romagna | 388479 | 13268 | 372723 | 2488 | 44.49436681 | 11.3417208 | 2021-07-18 04:22:07 | Emilia-Romagna, Italy | ||
3702093 | 3702093 | 2021-04-27 | Italy | Emilia-Romagna | 366432 | 12820 | 305809 | 47803 | 44.49436681 | 11.3417208 | 2021-04-28 04:20:32 | Emilia-Romagna, Italy | ||
3695472 | 3695472 | 2020-12-31 | Italy | Emilia-Romagna | 171512 | 7738 | 106428 | 57346 | 44.49436681 | 11.3417208 | 2021-01-01 05:23:07 | Emilia-Romagna, Italy | ||
3691461 | 3691461 | 2020-12-24 | Italy | Emilia-Romagna | 161163 | 7335 | 96529 | 57299 | 44.49436681 | 11.3417208 | 2020-12-25 05:22:48 | Emilia-Romagna, Italy | ||
3687447 | 3687447 | 2022-01-13 | Italy | Emilia-Romagna | 750971 | 14486 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-14 04:21:54 | Emilia-Romagna, Italy | |||
3683433 | 3683433 | 2021-08-02 | Italy | Emilia-Romagna | 395489 | 13285 | 374148 | 8056 | 44.49436681 | 11.3417208 | 2021-08-03 04:21:39 | Emilia-Romagna, Italy | ||
3682546 | 3682546 | 2020-06-18 | Italy | Emilia-Romagna | 28143 | 4219 | 22643 | 1281 | 44.49436681 | 11.341720800000001 | 2020-06-19 04:33:17 | Emilia-Romagna, Italy | ||
3675634 | 3675634 | 2021-05-04 | Italy | Emilia-Romagna | 372262 | 12940 | 320194 | 39128 | 44.49436681 | 11.3417208 | 2021-05-05 04:20:43 | Emilia-Romagna, Italy | ||
3671619 | 3671619 | 2022-02-15 | Italy | Emilia-Romagna | 1150149 | 15619 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-16 04:21:10 | Emilia-Romagna, Italy | |||
3667604 | 3667604 | 2021-03-06 | Italy | Emilia-Romagna | 276601 | 10746 | 213413 | 52442 | 44.49436681 | 11.3417208 | 2021-03-07 05:21:54 | Emilia-Romagna, Italy | ||
3663590 | 3663590 | 2021-03-09 | Italy | Emilia-Romagna | 285021 | 10871 | 215754 | 58396 | 44.49436681 | 11.3417208 | 2021-03-10 05:24:35 | Emilia-Romagna, Italy | ||
3659576 | 3659576 | 2021-07-11 | Italy | Emilia-Romagna | 387597 | 13268 | 372102 | 2227 | 44.49436681 | 11.3417208 | 2021-07-12 04:21:34 | Emilia-Romagna, Italy | ||
3655560 | 3655560 | 2021-12-10 | Italy | Emilia-Romagna | 470881 | 13886 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-11 04:22:45 | Emilia-Romagna, Italy | |||
3651551 | 3651551 | 2020-10-24 | Italy | Emilia-Romagna | 45542 | 4557 | 27343 | 13642 | 44.49436681 | 11.3417208 | 2020-10-25 04:24:36 | Emilia-Romagna, Italy | ||
3647550 | 3647550 | 2022-08-14 | Italy | Emilia-Romagna | 1794843 | 17722 | 0 | 44.49436681 | 11.3417208 | 2022-08-15 04:20:59 | Emilia-Romagna, Italy | |||
3643535 | 3643535 | 2021-03-30 | Italy | Emilia-Romagna | 334343 | 11859 | 249404 | 73080 | 44.49436681 | 11.3417208 | 2021-03-31 04:26:25 | Emilia-Romagna, Italy | ||
3639519 | 3639519 | 2021-11-08 | Italy | Emilia-Romagna | 435837 | 13627 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-09 04:21:36 | Emilia-Romagna, Italy | |||
3638768 | 3638768 | 2020-05-30 | Italy | Emilia-Romagna | 27759 | 4107 | 20373 | 3279 | 44.49436681 | 11.341720800000001 | 2020-05-31 02:32:45 | Emilia-Romagna, Italy | ||
3631939 | 3631939 | 2021-07-14 | Italy | Emilia-Romagna | 387906 | 13268 | 372458 | 2180 | 44.49436681 | 11.3417208 | 2021-07-15 04:21:48 | Emilia-Romagna, Italy | ||
3627924 | 3627924 | 2022-03-13 | Italy | Emilia-Romagna | 1215649 | 16068 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-14 04:20:46 | Emilia-Romagna, Italy | |||
3621063 | 3621063 | 2021-03-17 | Italy | Emilia-Romagna | 306324 | 11236 | 225473 | 69615 | 44.49436681 | 11.3417208 | 2021-03-18 05:26:22 | Emilia-Romagna, Italy | ||
3617048 | 3617048 | 2022-08-01 | Italy | Emilia-Romagna | 1761791 | 17521 | 0 | 44.49436681 | 11.3417208 | 2022-08-02 04:20:53 | Emilia-Romagna, Italy | |||
3613031 | 3613031 | 2022-01-12 | Italy | Emilia-Romagna | 730330 | 14448 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-13 08:00:09 | Emilia-Romagna, Italy | |||
3612128 | 3612128 | 2020-08-06 | Italy | Emilia-Romagna | 29954 | 4291 | 24011 | 1652 | 44.49436681 | 11.3417208 | 2020-08-07 04:35:11 | Emilia-Romagna, Italy | ||
3605038 | 3605038 | 2021-12-25 | Italy | Emilia-Romagna | 505738 | 14126 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-26 04:21:50 | Emilia-Romagna, Italy | |||
3601023 | 3601023 | 2021-02-17 | Italy | Emilia-Romagna | 239091 | 10213 | 193610 | 35268 | 44.49436681 | 11.3417208 | 2021-02-18 05:22:58 | Emilia-Romagna, Italy | ||
3597009 | 3597009 | 2022-11-14 | Italy | Emilia-Romagna | 1981780 | 18333 | 0 | 44.49436681 | 11.3417208 | 2022-11-15 04:21:16 | Emilia-Romagna, Italy | |||
3592993 | 3592993 | 2022-05-23 | Italy | Emilia-Romagna | 1475747 | 16872 | 0 | 44.49436681 | 11.3417208 | 2022-05-24 04:20:57 | Emilia-Romagna, Italy | |||
3582609 | 3582609 | 2022-05-17 | Italy | Emilia-Romagna | 1463050 | 16821 | 0 | 44.49436681 | 11.3417208 | 2022-05-18 04:20:50 | Emilia-Romagna, Italy | |||
3578593 | 3578593 | 2022-06-02 | Italy | Emilia-Romagna | 1488357 | 16952 | 0 | 44.49436681 | 11.3417208 | 2022-06-03 04:20:58 | Emilia-Romagna, 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]);