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 combined_key
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423317 | 423317 | 2021-10-10 | Italy | Emilia-Romagna | 426429 | 13508 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-11 04:21:31 | Emilia-Romagna, Italy | |||
427318 | 427318 | 2020-09-07 | Italy | Emilia-Romagna | 32760 | 4464 | 24803 | 3493 | 44.49436681 | 11.3417208 | 2020-09-08 04:28:25 | Emilia-Romagna, Italy | ||
431324 | 431324 | 2022-11-03 | Italy | Emilia-Romagna | 1957498 | 18234 | 0 | 44.49436681 | 11.3417208 | 2022-11-04 04:22:11 | Emilia-Romagna, Italy | |||
435338 | 435338 | 2021-01-21 | Italy | Emilia-Romagna | 206578 | 9008 | 145533 | 52037 | 44.49436681 | 11.3417208 | 2021-01-22 05:22:10 | Emilia-Romagna, Italy | ||
442418 | 442418 | 2020-07-26 | Italy | Emilia-Romagna | 29522 | 4285 | 23793 | 1444 | 44.49436681 | 11.3417208 | 2020-07-27 04:35:02 | Emilia-Romagna, Italy | ||
443321 | 443321 | 2021-10-20 | Italy | Emilia-Romagna | 428483 | 13542 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-21 04:21:18 | Emilia-Romagna, Italy | |||
447337 | 447337 | 2021-11-17 | Italy | Emilia-Romagna | 441494 | 13680 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-18 04:21:33 | Emilia-Romagna, Italy | |||
451354 | 451354 | 2022-12-21 | Italy | Emilia-Romagna | 2083569 | 18730 | 0 | 44.49436681 | 11.3417208 | 2022-12-22 04:20:56 | Emilia-Romagna, Italy | |||
458443 | 458443 | 2020-08-07 | Italy | Emilia-Romagna | 30008 | 4292 | 24041 | 1675 | 44.49436681 | 11.3417208 | 2020-08-08 04:34:53 | Emilia-Romagna, Italy | ||
459346 | 459346 | 2022-02-02 | Italy | Emilia-Romagna | 1068696 | 15168 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-03 04:21:21 | Emilia-Romagna, Italy | |||
463363 | 463363 | 2022-05-02 | Italy | Emilia-Romagna | 1417599 | 16642 | 0 | 44.49436681 | 11.3417208 | 2022-05-03 04:21:00 | 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 | |||
471394 | 471394 | 2021-02-19 | Italy | Emilia-Romagna | 242462 | 10281 | 197244 | 34937 | 44.49436681 | 11.3417208 | 2021-02-20 05:22:51 | Emilia-Romagna, Italy | ||
475409 | 475409 | 2022-06-26 | Italy | Emilia-Romagna | 1551189 | 17069 | 0 | 44.49436681 | 11.3417208 | 2022-06-27 04:21:00 | Emilia-Romagna, Italy | |||
479557 | 479557 | 2022-11-08 | Italy | Emilia-Romagna | 1966155 | 18280 | 0 | 44.49436681 | 11.3417208 | 2022-11-09 04:21:22 | 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 | ||
487587 | 487587 | 2022-11-25 | Italy | Emilia-Romagna | 2023014 | 18457 | 0 | 44.49436681 | 11.3417208 | 2022-11-26 04:21:11 | Emilia-Romagna, Italy | |||
491602 | 491602 | 2021-10-14 | Italy | Emilia-Romagna | 427188 | 13524 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-15 04:21:26 | Emilia-Romagna, Italy | |||
495618 | 495618 | 2021-11-06 | Italy | Emilia-Romagna | 434736 | 13618 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-07 04:21:53 | Emilia-Romagna, Italy | |||
499635 | 499635 | 2022-04-02 | Italy | Emilia-Romagna | 1290959 | 16278 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-03 04:20:48 | Emilia-Romagna, Italy | |||
503651 | 503651 | 2022-12-17 | Italy | Emilia-Romagna | 2083569 | 18730 | 0 | 44.49436681 | 11.3417208 | 2022-12-18 04:21:03 | 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 | |||
511680 | 511680 | 2021-08-19 | Italy | Emilia-Romagna | 405084 | 13315 | 0 | 44.49436681 | 11.341720800000001 | 2021-08-20 04:21:33 | Emilia-Romagna, Italy | |||
515695 | 515695 | 2022-10-15 | Italy | Emilia-Romagna | 1917605 | 18127 | 0 | 44.49436681 | 11.3417208 | 2022-10-16 04:22:39 | Emilia-Romagna, Italy | |||
522839 | 522839 | 2021-06-09 | Italy | Emilia-Romagna | 385176 | 13221 | 361632 | 10323 | 44.49436681 | 11.3417208 | 2021-06-10 04:23:17 | Emilia-Romagna, Italy | ||
529801 | 529801 | 2020-07-04 | Italy | Emilia-Romagna | 28613 | 4267 | 23309 | 1037 | 44.49436681 | 11.341720800000001 | 2020-07-05 04:33:46 | Emilia-Romagna, Italy | ||
530688 | 530688 | 2021-02-22 | Italy | Emilia-Romagna | 247856 | 10368 | 200972 | 36516 | 44.49436681 | 11.3417208 | 2021-02-23 05:23:41 | Emilia-Romagna, Italy | ||
534702 | 534702 | 2021-10-27 | Italy | Emilia-Romagna | 430676 | 13577 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-28 04:22:08 | Emilia-Romagna, Italy | |||
538719 | 538719 | 2022-10-26 | Italy | Emilia-Romagna | 1949453 | 18212 | 0 | 44.49436681 | 11.3417208 | 2022-10-27 04:22:01 | Emilia-Romagna, Italy | |||
542735 | 542735 | 2022-12-15 | Italy | Emilia-Romagna | 2067550 | 18630 | 0 | 44.49436681 | 11.3417208 | 2022-12-16 04:21:01 | Emilia-Romagna, Italy | |||
546735 | 546735 | 2020-09-12 | Italy | Emilia-Romagna | 33363 | 4469 | 25067 | 3827 | 44.49436681 | 11.3417208 | 2020-09-13 04:30:52 | Emilia-Romagna, Italy | ||
550740 | 550740 | 2021-12-08 | Italy | Emilia-Romagna | 467571 | 13864 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-09 04:22:49 | Emilia-Romagna, Italy | |||
554756 | 554756 | 2022-01-16 | Italy | Emilia-Romagna | 805434 | 14556 | 0 | 44.49436681 | 11.341720800000001 | 2022-01-17 04:21:08 | Emilia-Romagna, Italy | |||
558773 | 558773 | 2022-06-16 | Italy | Emilia-Romagna | 1514692 | 17026 | 0 | 44.49436681 | 11.3417208 | 2022-06-17 04:20:56 | Emilia-Romagna, Italy | |||
562949 | 562949 | 2021-06-22 | Italy | Emilia-Romagna | 386389 | 13250 | 368236 | 4903 | 44.49436681 | 11.3417208 | 2021-06-23 04:21:46 | Emilia-Romagna, Italy | ||
567070 | 567070 | 2021-10-29 | Italy | Emilia-Romagna | 431494 | 13587 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-30 04:22:03 | Emilia-Romagna, Italy | |||
573941 | 573941 | 2020-06-06 | Italy | Emilia-Romagna | 27894 | 4171 | 21307 | 2416 | 44.49436681 | 11.3417208 | 2020-06-07 03:53:30 | Emilia-Romagna, Italy | ||
574799 | 574799 | 2022-02-25 | Italy | Emilia-Romagna | 1180240 | 15856 | 0 | 44.49436681 | 11.341720800000001 | 2022-02-26 04:21:12 | 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 | ||
582813 | 582813 | 2020-08-13 | Italy | Emilia-Romagna | 30257 | 4298 | 24132 | 1827 | 44.49436681 | 11.3417208 | 2020-08-14 04:51:19 | 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 | |||
593625 | 593625 | 2022-07-01 | Italy | Emilia-Romagna | 1578311 | 17110 | 0 | 44.49436681 | 11.3417208 | 2022-07-02 04:21:16 | Emilia-Romagna, Italy | |||
597640 | 597640 | 2021-10-19 | Italy | Emilia-Romagna | 428236 | 13538 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-20 04:21:00 | 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 | |||
605671 | 605671 | 2021-04-09 | Italy | Emilia-Romagna | 348305 | 12307 | 267780 | 68218 | 44.49436681 | 11.3417208 | 2021-04-10 04:20:59 | Emilia-Romagna, Italy | ||
609670 | 609670 | 2020-08-29 | Italy | Emilia-Romagna | 31696 | 4459 | 24468 | 2769 | 44.49436681 | 11.3417208 | 2020-08-30 04:28:22 | Emilia-Romagna, Italy | ||
613670 | 613670 | 2021-02-08 | Italy | Emilia-Romagna | 228198 | 9869 | 175556 | 42773 | 44.49436681 | 11.3417208 | 2021-02-09 05:23:30 | Emilia-Romagna, Italy | ||
617829 | 617829 | 2022-11-05 | Italy | Emilia-Romagna | 1966155 | 18280 | 0 | 44.49436681 | 11.3417208 | 2022-11-06 04:21:24 | Emilia-Romagna, Italy | |||
621845 | 621845 | 2022-05-22 | Italy | Emilia-Romagna | 1479045 | 16904 | 0 | 44.49436681 | 11.3417208 | 2022-05-26 04:20:50 | 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 | ||
629875 | 629875 | 2022-07-12 | Italy | Emilia-Romagna | 1650274 | 17214 | 0 | 44.49436681 | 11.3417208 | 2022-07-13 04:20:58 | Emilia-Romagna, Italy | |||
633890 | 633890 | 2021-10-13 | Italy | Emilia-Romagna | 426994 | 13521 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-14 04:21:29 | Emilia-Romagna, Italy | |||
637906 | 637906 | 2021-03-31 | Italy | Emilia-Romagna | 335820 | 11917 | 251468 | 72435 | 44.49436681 | 11.3417208 | 2021-04-01 04:27:05 | 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 | |||
645934 | 645934 | 2021-05-05 | Italy | Emilia-Romagna | 372817 | 12957 | 320778 | 39082 | 44.49436681 | 11.3417208 | 2021-05-06 04:20:38 | 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 | |||
653962 | 653962 | 2021-10-22 | Italy | Emilia-Romagna | 429090 | 13548 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-23 04:21:32 | Emilia-Romagna, Italy | |||
658281 | 658281 | 2022-05-13 | Italy | Emilia-Romagna | 1453448 | 16781 | 0 | 44.49436681 | 11.3417208 | 2022-05-14 04:20:48 | Emilia-Romagna, Italy | |||
662281 | 662281 | 2020-08-11 | Italy | Emilia-Romagna | 30179 | 4298 | 24091 | 1790 | 44.49436681 | 11.3417208 | 2020-08-12 04:27:29 | Emilia-Romagna, Italy | ||
666260 | 666260 | 2020-09-16 | Italy | Emilia-Romagna | 33862 | 4470 | 25213 | 4179 | 44.49436681 | 11.3417208 | 2020-09-17 04:22:00 | Emilia-Romagna, Italy | ||
670266 | 670266 | 2022-07-21 | Italy | Emilia-Romagna | 1713109 | 17335 | 0 | 44.49436681 | 11.3417208 | 2022-07-22 04:21:15 | Emilia-Romagna, Italy | |||
674282 | 674282 | 2022-07-30 | Italy | Emilia-Romagna | 1755934 | 17493 | 0 | 44.49436681 | 11.3417208 | 2022-07-31 04:21:02 | Emilia-Romagna, Italy | |||
678294 | 678294 | 2020-11-23 | Italy | Emilia-Romagna | 108073 | 5384 | 33309 | 69380 | 44.49436681 | 11.3417208 | 2020-11-24 05:27:31 | Emilia-Romagna, Italy | ||
682307 | 682307 | 2021-10-24 | Italy | Emilia-Romagna | 429737 | 13554 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-25 04:22:31 | Emilia-Romagna, Italy | |||
686323 | 686323 | 2021-11-13 | Italy | Emilia-Romagna | 438850 | 13655 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-14 04:21:31 | Emilia-Romagna, Italy | |||
690340 | 690340 | 2022-12-23 | Italy | Emilia-Romagna | 2095414 | 18849 | 0 | 44.49436681 | 11.3417208 | 2022-12-24 04:21:02 | Emilia-Romagna, Italy | |||
694356 | 694356 | 2022-03-17 | Italy | Emilia-Romagna | 1227339 | 16126 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-18 04:20:55 | Emilia-Romagna, Italy | |||
698371 | 698371 | 2021-11-04 | Italy | Emilia-Romagna | 433560 | 13614 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-05 04:21:54 | Emilia-Romagna, Italy | |||
702387 | 702387 | 2021-03-16 | Italy | Emilia-Romagna | 304314 | 11184 | 224138 | 68992 | 44.49436681 | 11.3417208 | 2021-03-17 05:25:07 | 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 | |||
710417 | 710417 | 2022-11-01 | Italy | Emilia-Romagna | 1957498 | 18234 | 0 | 44.49436681 | 11.3417208 | 2022-11-02 04:22:09 | Emilia-Romagna, Italy | |||
714432 | 714432 | 2021-11-12 | Italy | Emilia-Romagna | 438168 | 13648 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-13 04:21:38 | Emilia-Romagna, Italy | |||
718449 | 718449 | 2022-12-04 | Italy | Emilia-Romagna | 2045976 | 18531 | 0 | 44.49436681 | 11.3417208 | 2022-12-05 04:20:58 | Emilia-Romagna, Italy | |||
722464 | 722464 | 2021-11-20 | Italy | Emilia-Romagna | 444475 | 13698 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-21 04:22:13 | Emilia-Romagna, Italy | |||
726480 | 726480 | 2021-05-22 | Italy | Emilia-Romagna | 381776 | 13140 | 349298 | 19338 | 44.49436681 | 11.3417208 | 2021-05-23 04:20:51 | Emilia-Romagna, Italy | ||
730494 | 730494 | 2021-12-27 | Italy | Emilia-Romagna | 512130 | 14160 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-28 04:21:47 | Emilia-Romagna, Italy | |||
737398 | 737398 | 2020-06-12 | Italy | Emilia-Romagna | 28028 | 4196 | 22015 | 1817 | 44.49436681 | 11.341720800000001 | 2020-06-13 03:33:14 | Emilia-Romagna, Italy | ||
738283 | 738283 | 2020-12-02 | Italy | Emilia-Romagna | 126110 | 5874 | 48931 | 71305 | 44.49436681 | 11.3417208 | 2020-12-03 05:28:22 | Emilia-Romagna, Italy | ||
742296 | 742296 | 2021-02-20 | Italy | Emilia-Romagna | 244170 | 10304 | 198733 | 35133 | 44.49436681 | 11.3417208 | 2021-02-21 05:24:33 | Emilia-Romagna, Italy | ||
746311 | 746311 | 2022-04-23 | Italy | Emilia-Romagna | 1381571 | 16532 | 0 | 44.49436681 | 11.341720800000001 | 2022-04-24 04:20:56 | Emilia-Romagna, Italy | |||
753397 | 753397 | 2020-08-01 | Italy | Emilia-Romagna | 29726 | 4291 | 23925 | 1510 | 44.49436681 | 11.3417208 | 2020-08-02 04:34:47 | Emilia-Romagna, Italy | ||
754284 | 754284 | 2020-10-28 | Italy | Emilia-Romagna | 50494 | 4593 | 27671 | 18230 | 44.49436681 | 11.3417208 | 2020-10-29 04:24:49 | Emilia-Romagna, Italy | ||
758294 | 758294 | 2021-11-26 | Italy | Emilia-Romagna | 451021 | 13750 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-27 04:22:45 | Emilia-Romagna, Italy | |||
762296 | 762296 | 2020-10-18 | Italy | Emilia-Romagna | 40859 | 4515 | 27181 | 9163 | 44.49436681 | 11.3417208 | 2020-10-19 04:24:16 | Emilia-Romagna, Italy | ||
766302 | 766302 | 2020-12-29 | Italy | Emilia-Romagna | 167969 | 7614 | 103543 | 56812 | 44.49436681 | 11.3417208 | 2020-12-30 05:22:34 | Emilia-Romagna, Italy | ||
770315 | 770315 | 2021-10-23 | Italy | Emilia-Romagna | 429421 | 13551 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-24 04:21:22 | Emilia-Romagna, Italy | |||
774330 | 774330 | 2021-01-12 | Italy | Emilia-Romagna | 194395 | 8454 | 125749 | 60192 | 44.49436681 | 11.3417208 | 2021-01-13 05:22:15 | 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 | ||
782357 | 782357 | 2021-12-13 | Italy | Emilia-Romagna | 476413 | 13916 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-14 04:22:38 | Emilia-Romagna, Italy | |||
786359 | 786359 | 2020-10-15 | Italy | Emilia-Romagna | 39148 | 4503 | 27124 | 7521 | 44.49436681 | 11.3417208 | 2020-10-16 04:24:01 | Emilia-Romagna, Italy | ||
790365 | 790365 | 2021-02-04 | Italy | Emilia-Romagna | 222804 | 9714 | 169281 | 43809 | 44.49436681 | 11.3417208 | 2021-02-05 05:22:38 | Emilia-Romagna, Italy | ||
794381 | 794381 | 2022-10-24 | Italy | Emilia-Romagna | 1943921 | 18169 | 0 | 44.49436681 | 11.3417208 | 2022-10-25 04:21:53 | Emilia-Romagna, Italy | |||
798396 | 798396 | 2021-12-22 | Italy | Emilia-Romagna | 496266 | 14071 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-23 04:21:21 | Emilia-Romagna, Italy | |||
805251 | 805251 | 2020-06-01 | Italy | Emilia-Romagna | 27809 | 4124 | 20617 | 3068 | 44.49436681 | 11.341720800000001 | 2020-06-02 02:33:08 | 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 | |||
813558 | 813558 | 2020-09-05 | Italy | Emilia-Romagna | 32505 | 4464 | 24790 | 3251 | 44.49436681 | 11.3417208 | 2020-09-06 04:28:33 | Emilia-Romagna, Italy | ||
817549 | 817549 | 2020-10-09 | Italy | Emilia-Romagna | 36914 | 4493 | 26812 | 5609 | 44.49436681 | 11.3417208 | 2020-10-10 04:23:57 | Emilia-Romagna, Italy | ||
821552 | 821552 | 2020-11-19 | Italy | Emilia-Romagna | 97814 | 5218 | 31587 | 61009 | 44.49436681 | 11.3417208 | 2020-11-20 05:26:28 | Emilia-Romagna, Italy | ||
825565 | 825565 | 2021-06-06 | Italy | Emilia-Romagna | 384820 | 13209 | 360157 | 11454 | 44.49436681 | 11.3417208 | 2021-06-07 04:22:51 | 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 |
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]);