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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491568 | 1491568 | 2021-10-12 | Italy | Emilia-Romagna | 426771 | 13516 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-13 04:20:51 | Emilia-Romagna, Italy | |||
3007301 | 3007301 | 2021-10-11 | Italy | Emilia-Romagna | 426620 | 13514 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-12 04:21:09 | Emilia-Romagna, Italy | |||
423317 | 423317 | 2021-10-10 | Italy | Emilia-Romagna | 426429 | 13508 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-11 04:21:31 | Emilia-Romagna, Italy | |||
2876174 | 2876174 | 2021-10-09 | Italy | Emilia-Romagna | 426190 | 13504 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-10 04:21:38 | Emilia-Romagna, Italy | |||
2959340 | 2959340 | 2021-10-08 | Italy | Emilia-Romagna | 425923 | 13499 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-09 04:21:34 | Emilia-Romagna, Italy | |||
467378 | 467378 | 2021-10-07 | Italy | Emilia-Romagna | 425655 | 13496 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-08 04:21:25 | Emilia-Romagna, Italy | |||
2458758 | 2458758 | 2021-10-06 | Italy | Emilia-Romagna | 425367 | 13494 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-07 04:21:36 | 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 | |||
986945 | 986945 | 2021-10-04 | Italy | Emilia-Romagna | 424922 | 13485 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-05 04:21:27 | Emilia-Romagna, Italy | |||
1274255 | 1274255 | 2021-10-03 | Italy | Emilia-Romagna | 424678 | 13483 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-04 04:21:31 | 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 | |||
2131988 | 2131988 | 2021-10-01 | Italy | Emilia-Romagna | 424089 | 13477 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-02 04:21:25 | Emilia-Romagna, Italy | |||
2772945 | 2772945 | 2021-09-30 | Italy | Emilia-Romagna | 423738 | 13475 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-01 04:21:35 | Emilia-Romagna, Italy | |||
706401 | 706401 | 2021-09-29 | Italy | Emilia-Romagna | 423377 | 13470 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-30 04:21:20 | Emilia-Romagna, Italy | |||
1334243 | 1334243 | 2021-09-28 | Italy | Emilia-Romagna | 423119 | 13464 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-29 04:21:45 | Emilia-Romagna, Italy | |||
1235612 | 1235612 | 2021-09-27 | Italy | Emilia-Romagna | 422939 | 13462 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-28 04:21:28 | Emilia-Romagna, Italy | |||
2075913 | 2075913 | 2021-09-26 | Italy | Emilia-Romagna | 422652 | 13459 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-27 04:21:16 | Emilia-Romagna, Italy | |||
1724465 | 1724465 | 2021-09-25 | Italy | Emilia-Romagna | 422312 | 13458 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-26 04:21:29 | Emilia-Romagna, Italy | |||
1921185 | 1921185 | 2021-09-24 | Italy | Emilia-Romagna | 421975 | 13453 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-25 04:21:31 | Emilia-Romagna, Italy | |||
601656 | 601656 | 2021-09-23 | Italy | Emilia-Romagna | 421654 | 13451 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-24 04:21:44 | Emilia-Romagna, Italy | |||
3011317 | 3011317 | 2021-09-22 | Italy | Emilia-Romagna | 421323 | 13444 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-23 04:21:43 | 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 | |||
809558 | 809558 | 2021-09-20 | Italy | Emilia-Romagna | 420794 | 13438 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-21 04:21:26 | Emilia-Romagna, Italy | |||
1814757 | 1814757 | 2021-09-19 | Italy | Emilia-Romagna | 420461 | 13434 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-20 04:21:22 | Emilia-Romagna, Italy | |||
16337 | 16337 | 2021-09-18 | Italy | Emilia-Romagna | 420118 | 13432 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-19 04:21:34 | Emilia-Romagna, Italy | |||
2618022 | 2618022 | 2021-09-17 | Italy | Emilia-Romagna | 419717 | 13427 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-18 04:21:24 | Emilia-Romagna, Italy | |||
2808730 | 2808730 | 2021-09-16 | Italy | Emilia-Romagna | 419249 | 13420 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-17 04:21:46 | Emilia-Romagna, Italy | |||
1374475 | 1374475 | 2021-09-15 | Italy | Emilia-Romagna | 418885 | 13414 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-16 04:22:19 | Emilia-Romagna, Italy | |||
2462774 | 2462774 | 2021-09-14 | Italy | Emilia-Romagna | 418565 | 13411 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-15 03:22:37 | Emilia-Romagna, Italy | |||
1385613 | 1385613 | 2021-09-13 | Italy | Emilia-Romagna | 418257 | 13409 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-14 04:21:41 | Emilia-Romagna, Italy | |||
1884982 | 1884982 | 2021-09-12 | Italy | Emilia-Romagna | 417795 | 13408 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-13 04:21:15 | 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 | |||
3448825 | 3448825 | 2021-09-10 | Italy | Emilia-Romagna | 416844 | 13404 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-11 04:21:30 | Emilia-Romagna, Italy | |||
1262771 | 1262771 | 2021-09-09 | Italy | Emilia-Romagna | 416228 | 13399 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-10 04:21:20 | Emilia-Romagna, Italy | |||
2279141 | 2279141 | 2021-09-08 | Italy | Emilia-Romagna | 415783 | 13396 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-09 04:21:27 | Emilia-Romagna, Italy | |||
641920 | 641920 | 2021-09-07 | Italy | Emilia-Romagna | 415448 | 13388 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-08 04:21:31 | Emilia-Romagna, Italy | |||
3193983 | 3193983 | 2021-09-06 | Italy | Emilia-Romagna | 415057 | 13386 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-07 04:21:35 | Emilia-Romagna, Italy | |||
3280851 | 3280851 | 2021-09-05 | Italy | Emilia-Romagna | 414548 | 13383 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-06 04:21:22 | Emilia-Romagna, Italy | |||
249265 | 249265 | 2021-09-04 | Italy | Emilia-Romagna | 414052 | 13376 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-05 04:21:33 | 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 | |||
178008 | 178008 | 2021-09-02 | Italy | Emilia-Romagna | 412791 | 13372 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-03 04:21:20 | Emilia-Romagna, Italy | |||
67043 | 67043 | 2021-09-01 | Italy | Emilia-Romagna | 412269 | 13372 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-02 04:21:15 | Emilia-Romagna, Italy | |||
2067885 | 2067885 | 2021-08-31 | Italy | Emilia-Romagna | 411888 | 13369 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-01 04:21:38 | Emilia-Romagna, Italy | |||
1775339 | 1775339 | 2021-08-30 | Italy | Emilia-Romagna | 411436 | 13360 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-31 04:21:46 | 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 | |||
2793016 | 2793016 | 2021-08-28 | Italy | Emilia-Romagna | 410293 | 13347 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-29 04:21:14 | Emilia-Romagna, Italy | |||
2923175 | 2923175 | 2021-08-27 | Italy | Emilia-Romagna | 409607 | 13344 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-28 04:21:28 | Emilia-Romagna, Italy | |||
1596189 | 1596189 | 2021-08-26 | Italy | Emilia-Romagna | 408877 | 13337 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-27 04:21:37 | Emilia-Romagna, Italy | |||
32398 | 32398 | 2021-08-25 | Italy | Emilia-Romagna | 408320 | 13334 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-26 04:21:28 | Emilia-Romagna, Italy | |||
3105437 | 3105437 | 2021-08-24 | Italy | Emilia-Romagna | 407914 | 13327 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-25 04:21:41 | Emilia-Romagna, Italy | |||
3165608 | 3165608 | 2021-08-23 | Italy | Emilia-Romagna | 407449 | 13324 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-24 04:21:19 | Emilia-Romagna, Italy | |||
2175535 | 2175535 | 2021-08-22 | Italy | Emilia-Romagna | 406893 | 13321 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-23 04:21:27 | Emilia-Romagna, Italy | |||
3555631 | 3555631 | 2021-08-21 | Italy | Emilia-Romagna | 406338 | 13318 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-22 04:21:29 | Emilia-Romagna, Italy | |||
1853973 | 1853973 | 2021-08-20 | Italy | Emilia-Romagna | 405718 | 13316 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-21 04:21:38 | Emilia-Romagna, Italy | |||
511680 | 511680 | 2021-08-19 | Italy | Emilia-Romagna | 405084 | 13315 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-20 04:21:33 | Emilia-Romagna, Italy | |||
2518159 | 2518159 | 2021-08-18 | Italy | Emilia-Romagna | 404521 | 13312 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-19 04:21:15 | Emilia-Romagna, Italy | |||
245251 | 245251 | 2021-08-17 | Italy | Emilia-Romagna | 404078 | 13309 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-18 04:21:35 | Emilia-Romagna, Italy | |||
1604214 | 1604214 | 2021-08-16 | Italy | Emilia-Romagna | 403603 | 13302 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-17 04:21:49 | Emilia-Romagna, Italy | |||
103308 | 103308 | 2021-08-15 | Italy | Emilia-Romagna | 403150 | 13300 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-16 04:21:31 | Emilia-Romagna, Italy | |||
507666 | 507666 | 2021-08-14 | Italy | Emilia-Romagna | 402601 | 13299 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-15 04:21:41 | Emilia-Romagna, Italy | |||
1483538 | 1483538 | 2021-08-13 | Italy | Emilia-Romagna | 401842 | 13295 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-14 04:21:25 | Emilia-Romagna, Italy | |||
2899668 | 2899668 | 2021-08-12 | Italy | Emilia-Romagna | 401195 | 13292 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-13 04:21:24 | Emilia-Romagna, Italy | |||
1342272 | 1342272 | 2021-08-11 | Italy | Emilia-Romagna | 400565 | 13291 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-12 04:21:25 | Emilia-Romagna, Italy | |||
2351419 | 2351419 | 2021-08-10 | Italy | Emilia-Romagna | 400155 | 13290 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-11 04:21:58 | Emilia-Romagna, Italy | |||
649948 | 649948 | 2021-08-09 | Italy | Emilia-Romagna | 399704 | 13290 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-10 04:21:27 | Emilia-Romagna, Italy | |||
589610 | 589610 | 2021-08-08 | Italy | Emilia-Romagna | 399062 | 13289 | 0 | 44.49436681 | 11.3417208 | 2021-08-09 04:21:24 | Emilia-Romagna, Italy | |||
2203622 | 2203622 | 2021-08-07 | Italy | Emilia-Romagna | 398403 | 13289 | 0 | 44.49436681 | 11.3417208 | 2021-08-08 04:21:33 | Emilia-Romagna, Italy | |||
1117572 | 1117572 | 2021-08-06 | Italy | Emilia-Romagna | 397722 | 13287 | 0 | 44.49436681 | 11.3417208 | 2021-08-07 04:21:30 | Emilia-Romagna, Italy | |||
1956509 | 1956509 | 2021-08-05 | Italy | Emilia-Romagna | 397005 | 13286 | 0 | 44.49436681 | 11.3417208 | 2021-08-06 04:21:18 | Emilia-Romagna, Italy | |||
331888 | 331888 | 2021-08-04 | Italy | Emilia-Romagna | 396341 | 13286 | 374451 | 8604 | 44.49436681 | 11.3417208 | 2021-08-05 04:21:51 | Emilia-Romagna, Italy | ||
3468159 | 3468159 | 2021-08-03 | Italy | Emilia-Romagna | 395850 | 13285 | 374321 | 8244 | 44.49436681 | 11.3417208 | 2021-08-04 04:21:25 | 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 | ||
3015332 | 3015332 | 2021-08-01 | Italy | Emilia-Romagna | 394934 | 13283 | 374009 | 7642 | 44.49436681 | 11.3417208 | 2021-08-02 04:21:36 | 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 | ||
3296160 | 3296160 | 2021-07-30 | Italy | Emilia-Romagna | 393632 | 13282 | 373860 | 6490 | 44.49436681 | 11.3417208 | 2021-07-31 04:21:35 | Emilia-Romagna, Italy | ||
3385371 | 3385371 | 2021-07-29 | Italy | Emilia-Romagna | 393093 | 13281 | 373777 | 6035 | 44.49436681 | 11.3417208 | 2021-07-30 04:21:34 | Emilia-Romagna, Italy | ||
408276 | 408276 | 2021-07-28 | Italy | Emilia-Romagna | 392602 | 13281 | 373699 | 5622 | 44.49436681 | 11.3417208 | 2021-07-29 04:21:33 | Emilia-Romagna, Italy | ||
1306137 | 1306137 | 2021-07-27 | Italy | Emilia-Romagna | 392186 | 13279 | 373611 | 5296 | 44.49436681 | 11.3417208 | 2021-07-28 04:21:39 | Emilia-Romagna, Italy | ||
3218280 | 3218280 | 2021-07-26 | Italy | Emilia-Romagna | 391891 | 13277 | 373377 | 5237 | 44.49436681 | 11.3417208 | 2021-07-27 04:21:18 | Emilia-Romagna, Italy | ||
1378489 | 1378489 | 2021-07-25 | Italy | Emilia-Romagna | 391422 | 13273 | 373316 | 4833 | 44.49436681 | 11.3417208 | 2021-07-26 04:21:28 | Emilia-Romagna, Italy | ||
1330229 | 1330229 | 2021-07-24 | Italy | Emilia-Romagna | 390857 | 13272 | 373276 | 4309 | 44.49436681 | 11.3417208 | 2021-07-25 04:22:12 | Emilia-Romagna, Italy | ||
3137533 | 3137533 | 2021-07-23 | Italy | Emilia-Romagna | 390389 | 13272 | 373211 | 3906 | 44.49436681 | 11.3417208 | 2021-07-24 00:21:36 | Emilia-Romagna, Italy | ||
3476293 | 3476293 | 2021-07-22 | Italy | Emilia-Romagna | 389916 | 13272 | 373133 | 3511 | 44.49436681 | 11.3417208 | 2021-07-23 04:21:29 | Emilia-Romagna, Italy | ||
3331512 | 3331512 | 2021-07-21 | Italy | Emilia-Romagna | 389470 | 13270 | 372984 | 3216 | 44.49436681 | 11.3417208 | 2021-07-22 04:21:19 | Emilia-Romagna, Italy | ||
2371493 | 2371493 | 2021-07-20 | Italy | Emilia-Romagna | 389146 | 13269 | 372918 | 2959 | 44.49436681 | 11.3417208 | 2021-07-21 04:21:40 | Emilia-Romagna, Italy | ||
483572 | 483572 | 2021-07-19 | Italy | Emilia-Romagna | 388963 | 13268 | 372839 | 2856 | 44.49436681 | 11.3417208 | 2021-07-20 04:21:48 | Emilia-Romagna, Italy | ||
2673795 | 2673795 | 2021-07-18 | Italy | Emilia-Romagna | 388745 | 13268 | 372771 | 2706 | 44.49436681 | 11.3417208 | 2021-07-19 04:21:24 | 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 | ||
2947338 | 2947338 | 2021-07-16 | Italy | Emilia-Romagna | 388272 | 13268 | 372646 | 2358 | 44.49436681 | 11.3417208 | 2021-07-17 04:22:22 | Emilia-Romagna, Italy | ||
295994 | 295994 | 2021-07-15 | Italy | Emilia-Romagna | 388073 | 13268 | 372548 | 2257 | 44.49436681 | 11.3417208 | 2021-07-16 04:21:22 | 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 | ||
578814 | 578814 | 2021-07-13 | Italy | Emilia-Romagna | 387789 | 13268 | 372408 | 2113 | 44.49436681 | 11.3417208 | 2021-07-14 04:21:35 | 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 | ||
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 | ||
625860 | 625860 | 2021-07-10 | Italy | Emilia-Romagna | 387504 | 13268 | 372022 | 2214 | 44.49436681 | 11.3417208 | 2021-07-11 04:21:43 | Emilia-Romagna, Italy | ||
829579 | 829579 | 2021-07-09 | Italy | Emilia-Romagna | 387410 | 13266 | 371950 | 2194 | 44.49436681 | 11.3417208 | 2021-07-10 04:21:25 | Emilia-Romagna, Italy | ||
778343 | 778343 | 2021-07-08 | Italy | Emilia-Romagna | 387311 | 13266 | 371857 | 2188 | 44.49436681 | 11.3417208 | 2021-07-09 04:21:21 | Emilia-Romagna, Italy | ||
1440565 | 1440565 | 2021-07-07 | Italy | Emilia-Romagna | 387219 | 13264 | 371748 | 2207 | 44.49436681 | 11.3417208 | 2021-07-08 04:21:26 | Emilia-Romagna, Italy | ||
2693670 | 2693670 | 2021-07-06 | Italy | Emilia-Romagna | 387157 | 13264 | 371573 | 2320 | 44.49436681 | 11.3417208 | 2021-07-07 04:21:20 | Emilia-Romagna, Italy | ||
1932419 | 1932419 | 2021-07-05 | Italy | Emilia-Romagna | 387106 | 13264 | 371353 | 2489 | 44.49436681 | 11.3417208 | 2021-07-06 04:21:32 | 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]);