johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Ciudad de Mexico" sorted by latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423433 | 423433 | 2021-10-10 | Mexico | Ciudad de Mexico | 956755 | 39453 | 0 | 19.4326 | -99.1332 | 2021-10-11 04:21:31 | Ciudad de Mexico, Mexico | |||
427415 | 427415 | 2020-09-07 | Mexico | Ciudad de Mexico | 105610 | 10900 | 87156 | 7554 | 19.4326 | -99.1332 | 2020-09-08 04:28:25 | Ciudad de Mexico, Mexico | ||
431441 | 431441 | 2022-11-03 | Mexico | Ciudad de Mexico | 1747014 | 43606 | 0 | 19.4326 | -99.1332 | 2022-11-04 04:22:11 | Ciudad de Mexico, Mexico | |||
435436 | 435436 | 2021-01-21 | Mexico | Ciudad de Mexico | 432631 | 20298 | 0 | 412333 | 19.4326 | -99.1332 | 2021-01-22 05:22:10 | Ciudad de Mexico, Mexico | ||
442397 | 442397 | 2020-07-26 | Mexico | Ciudad de Mexico | 68903 | 8693 | 53227 | 6983 | 19.4326 | -99.1332 | 2020-07-27 04:35:02 | Ciudad de Mexico, Mexico | ||
443437 | 443437 | 2021-10-20 | Mexico | Ciudad de Mexico | 964604 | 39685 | 0 | 19.4326 | -99.1332 | 2021-10-21 04:21:18 | Ciudad de Mexico, Mexico | |||
447453 | 447453 | 2021-11-17 | Mexico | Ciudad de Mexico | 978471 | 40031 | 0 | 19.4326 | -99.1332 | 2021-11-18 04:21:33 | Ciudad de Mexico, Mexico | |||
451471 | 451471 | 2022-12-21 | Mexico | Ciudad de Mexico | 1774057 | 43665 | 0 | 19.4326 | -99.1332 | 2022-12-22 04:20:56 | Ciudad de Mexico, Mexico | |||
458422 | 458422 | 2020-08-07 | Mexico | Ciudad de Mexico | 78898 | 9309 | 63252 | 6337 | 19.4326 | -99.1332 | 2020-08-08 04:34:53 | Ciudad de Mexico, Mexico | ||
459462 | 459462 | 2022-02-02 | Mexico | Ciudad de Mexico | 1233164 | 41086 | 0 | 19.4326 | -99.1332 | 2022-02-03 04:21:21 | Ciudad de Mexico, Mexico | |||
463479 | 463479 | 2022-05-02 | Mexico | Ciudad de Mexico | 1397483 | 42795 | 0 | 19.4326 | -99.1332 | 2022-05-03 04:21:00 | Ciudad de Mexico, Mexico | |||
467494 | 467494 | 2021-10-07 | Mexico | Ciudad de Mexico | 953861 | 39396 | 0 | 19.4326 | -99.1332 | 2021-10-08 04:21:25 | Ciudad de Mexico, Mexico | |||
471492 | 471492 | 2021-02-19 | Mexico | Ciudad de Mexico | 536058 | 25990 | 0 | 510068 | 19.4326 | -99.1332 | 2021-02-20 05:22:51 | Ciudad de Mexico, Mexico | ||
475526 | 475526 | 2022-06-26 | Mexico | Ciudad de Mexico | 1472239 | 42906 | 0 | 19.4326 | -99.1332 | 2022-06-27 04:21:00 | Ciudad de Mexico, Mexico | |||
479674 | 479674 | 2022-11-08 | Mexico | Ciudad de Mexico | 1747959 | 43609 | 0 | 19.4326 | -99.1332 | 2022-11-09 04:21:22 | Ciudad de Mexico, Mexico | |||
483671 | 483671 | 2021-07-19 | Mexico | Ciudad de Mexico | 733303 | 35153 | 0 | 698150 | 19.4326 | -99.1332 | 2021-07-20 04:21:48 | Ciudad de Mexico, Mexico | ||
487704 | 487704 | 2022-11-25 | Mexico | Ciudad de Mexico | 1752242 | 43617 | 0 | 19.4326 | -99.1332 | 2022-11-26 04:21:11 | Ciudad de Mexico, Mexico | |||
491718 | 491718 | 2021-10-14 | Mexico | Ciudad de Mexico | 960463 | 39581 | 0 | 19.4326 | -99.1332 | 2021-10-15 04:21:26 | Ciudad de Mexico, Mexico | |||
495734 | 495734 | 2021-11-06 | Mexico | Ciudad de Mexico | 974295 | 39933 | 0 | 19.4326 | -99.1332 | 2021-11-07 04:21:53 | Ciudad de Mexico, Mexico | |||
499751 | 499751 | 2022-04-02 | Mexico | Ciudad de Mexico | 1387287 | 42625 | 0 | 19.4326 | -99.1332 | 2022-04-03 04:20:48 | Ciudad de Mexico, Mexico | |||
503768 | 503768 | 2022-12-17 | Mexico | Ciudad de Mexico | 1771353 | 43661 | 0 | 19.4326 | -99.1332 | 2022-12-18 04:21:03 | Ciudad de Mexico, Mexico | |||
507765 | 507765 | 2021-08-14 | Mexico | Ciudad de Mexico | 843818 | 36564 | 0 | 19.4326 | -99.1332 | 2021-08-15 04:21:41 | Ciudad de Mexico, Mexico | |||
511779 | 511779 | 2021-08-19 | Mexico | Ciudad de Mexico | 860233 | 36909 | 0 | 19.4326 | -99.1332 | 2021-08-20 04:21:33 | Ciudad de Mexico, Mexico | |||
515812 | 515812 | 2022-10-15 | Mexico | Ciudad de Mexico | 1743399 | 43592 | 0 | 19.4326 | -99.1332 | 2022-10-16 04:22:39 | Ciudad de Mexico, Mexico | |||
522938 | 522938 | 2021-06-09 | Mexico | Ciudad de Mexico | 664844 | 34311 | 0 | 630533 | 19.4326 | -99.1332 | 2021-06-10 04:23:17 | Ciudad de Mexico, Mexico | ||
529781 | 529781 | 2020-07-04 | Mexico | Ciudad de Mexico | 51658 | 6921 | 40731 | 4006 | 19.4326 | -99.1332 | 2020-07-05 04:33:46 | Ciudad de Mexico, Mexico | ||
530786 | 530786 | 2021-02-22 | Mexico | Ciudad de Mexico | 540628 | 26345 | 0 | 514283 | 19.4326 | -99.1332 | 2021-02-23 05:23:41 | Ciudad de Mexico, Mexico | ||
534818 | 534818 | 2021-10-27 | Mexico | Ciudad de Mexico | 968481 | 39767 | 0 | 19.4326 | -99.1332 | 2021-10-28 04:22:08 | Ciudad de Mexico, Mexico | |||
538836 | 538836 | 2022-10-26 | Mexico | Ciudad de Mexico | 1745758 | 43604 | 0 | 19.4326 | -99.1332 | 2022-10-27 04:22:01 | Ciudad de Mexico, Mexico | |||
542852 | 542852 | 2022-12-15 | Mexico | Ciudad de Mexico | 1766348 | 43653 | 0 | 19.4326 | -99.1332 | 2022-12-16 04:21:01 | Ciudad de Mexico, Mexico | |||
546832 | 546832 | 2020-09-12 | Mexico | Ciudad de Mexico | 110809 | 11199 | 91232 | 8378 | 19.4326 | -99.1332 | 2020-09-13 04:30:52 | Ciudad de Mexico, Mexico | ||
550856 | 550856 | 2021-12-08 | Mexico | Ciudad de Mexico | 987409 | 40190 | 0 | 19.4326 | -99.1332 | 2021-12-09 04:22:49 | Ciudad de Mexico, Mexico | |||
554872 | 554872 | 2022-01-16 | Mexico | Ciudad de Mexico | 1095354 | 40461 | 0 | 19.4326 | -99.1332 | 2022-01-17 04:21:08 | Ciudad de Mexico, Mexico | |||
558890 | 558890 | 2022-06-16 | Mexico | Ciudad de Mexico | 1436008 | 42861 | 0 | 19.4326 | -99.1332 | 2022-06-17 04:20:56 | Ciudad de Mexico, Mexico | |||
563048 | 563048 | 2021-06-22 | Mexico | Ciudad de Mexico | 674922 | 34484 | 0 | 640438 | 19.4326 | -99.1332 | 2021-06-23 04:21:46 | Ciudad de Mexico, Mexico | ||
567186 | 567186 | 2021-10-29 | Mexico | Ciudad de Mexico | 970519 | 39843 | 0 | 19.4326 | -99.1332 | 2021-10-30 04:22:03 | Ciudad de Mexico, Mexico | |||
573923 | 573923 | 2020-06-06 | Mexico | Ciudad de Mexico | 30223 | 3696 | 22254 | 4273 | 19.4326 | -99.1332 | 2020-06-07 03:53:30 | Ciudad de Mexico, Mexico | ||
574915 | 574915 | 2022-02-25 | Mexico | Ciudad de Mexico | 1345276 | 42047 | 0 | 19.4326 | -99.1332 | 2022-02-26 04:21:12 | Ciudad de Mexico, Mexico | |||
578913 | 578913 | 2021-07-13 | Mexico | Ciudad de Mexico | 713909 | 34992 | 0 | 678917 | 19.4326 | -99.1332 | 2021-07-14 04:21:35 | Ciudad de Mexico, Mexico | ||
582910 | 582910 | 2020-08-13 | Mexico | Ciudad de Mexico | 83683 | 9668 | 68031 | 5984 | 19.4326 | -99.1332 | 2020-08-14 04:51:19 | Ciudad de Mexico, Mexico | ||
589709 | 589709 | 2021-08-08 | Mexico | Ciudad de Mexico | 815833 | 36116 | 0 | 19.4326 | -99.1332 | 2021-08-09 04:21:24 | Ciudad de Mexico, Mexico | |||
593742 | 593742 | 2022-07-01 | Mexico | Ciudad de Mexico | 1500619 | 42930 | 0 | 19.4326 | -99.1332 | 2022-07-02 04:21:16 | Ciudad de Mexico, Mexico | |||
597756 | 597756 | 2021-10-19 | Mexico | Ciudad de Mexico | 963903 | 39672 | 0 | 19.4326 | -99.1332 | 2021-10-20 04:21:00 | Ciudad de Mexico, Mexico | |||
601772 | 601772 | 2021-09-23 | Mexico | Ciudad de Mexico | 937969 | 38722 | 0 | 19.4326 | -99.1332 | 2021-09-24 04:21:44 | Ciudad de Mexico, Mexico | |||
605769 | 605769 | 2021-04-09 | Mexico | Ciudad de Mexico | 618837 | 31025 | 0 | 587812 | 19.4326 | -99.1332 | 2021-04-10 04:20:59 | Ciudad de Mexico, Mexico | ||
609767 | 609767 | 2020-08-29 | Mexico | Ciudad de Mexico | 97256 | 10475 | 79032 | 7749 | 19.4326 | -99.1332 | 2020-08-30 04:28:22 | Ciudad de Mexico, Mexico | ||
613768 | 613768 | 2021-02-08 | Mexico | Ciudad de Mexico | 503290 | 23883 | 0 | 479407 | 19.4326 | -99.1332 | 2021-02-09 05:23:30 | Ciudad de Mexico, Mexico | ||
617946 | 617946 | 2022-11-05 | Mexico | Ciudad de Mexico | 1747462 | 43608 | 0 | 19.4326 | -99.1332 | 2022-11-06 04:21:24 | Ciudad de Mexico, Mexico | |||
621962 | 621962 | 2022-05-22 | Mexico | Ciudad de Mexico | 1405477 | 42826 | 0 | 19.4326 | -99.1332 | 2022-05-26 04:20:50 | Ciudad de Mexico, Mexico | |||
625959 | 625959 | 2021-07-10 | Mexico | Ciudad de Mexico | 707845 | 34911 | 0 | 672934 | 19.4326 | -99.1332 | 2021-07-11 04:21:43 | Ciudad de Mexico, Mexico | ||
629992 | 629992 | 2022-07-12 | Mexico | Ciudad de Mexico | 1567117 | 43004 | 0 | 19.4326 | -99.1332 | 2022-07-13 04:20:58 | Ciudad de Mexico, Mexico | |||
634006 | 634006 | 2021-10-13 | Mexico | Ciudad de Mexico | 959572 | 39542 | 0 | 19.4326 | -99.1332 | 2021-10-14 04:21:29 | Ciudad de Mexico, Mexico | |||
638004 | 638004 | 2021-03-31 | Mexico | Ciudad de Mexico | 608872 | 30534 | 0 | 578338 | 19.4326 | -99.1332 | 2021-04-01 04:27:05 | Ciudad de Mexico, Mexico | ||
642019 | 642019 | 2021-09-07 | Mexico | Ciudad de Mexico | 910820 | 38013 | 0 | 19.4326 | -99.1332 | 2021-09-08 04:21:31 | Ciudad de Mexico, Mexico | |||
646032 | 646032 | 2021-05-05 | Mexico | Ciudad de Mexico | 643861 | 32690 | 0 | 611171 | 19.4326 | -99.1332 | 2021-05-06 04:20:38 | Ciudad de Mexico, Mexico | ||
650047 | 650047 | 2021-08-09 | Mexico | Ciudad de Mexico | 817561 | 36171 | 0 | 19.4326 | -99.1332 | 2021-08-10 04:21:27 | Ciudad de Mexico, Mexico | |||
654078 | 654078 | 2021-10-22 | Mexico | Ciudad de Mexico | 966372 | 39719 | 0 | 19.4326 | -99.1332 | 2021-10-23 04:21:32 | Ciudad de Mexico, Mexico | |||
658397 | 658397 | 2022-05-13 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-14 04:20:48 | Ciudad de Mexico, Mexico | |||
662377 | 662377 | 2020-08-11 | Mexico | Ciudad de Mexico | 81618 | 9539 | 66461 | 5618 | 19.4326 | -99.1332 | 2020-08-12 04:27:29 | Ciudad de Mexico, Mexico | ||
666357 | 666357 | 2020-09-16 | Mexico | Ciudad de Mexico | 114268 | 11351 | 96327 | 6590 | 19.4326 | -99.1332 | 2020-09-17 04:22:00 | Ciudad de Mexico, Mexico | ||
670383 | 670383 | 2022-07-21 | Mexico | Ciudad de Mexico | 1629046 | 43147 | 0 | 19.4326 | -99.1332 | 2022-07-22 04:21:15 | Ciudad de Mexico, Mexico | |||
674399 | 674399 | 2022-07-30 | Mexico | Ciudad de Mexico | 1663786 | 43267 | 0 | 19.4326 | -99.1332 | 2022-07-31 04:21:02 | Ciudad de Mexico, Mexico | |||
678392 | 678392 | 2020-11-23 | Mexico | Ciudad de Mexico | 188343 | 13032 | 0 | 175311 | 19.4326 | -99.1332 | 2020-11-24 05:27:31 | Ciudad de Mexico, Mexico | ||
682423 | 682423 | 2021-10-24 | Mexico | Ciudad de Mexico | 967113 | 39723 | 0 | 19.4326 | -99.1332 | 2021-10-25 04:22:31 | Ciudad de Mexico, Mexico | |||
686439 | 686439 | 2021-11-13 | Mexico | Ciudad de Mexico | 976879 | 40012 | 0 | 19.4326 | -99.1332 | 2021-11-14 04:21:31 | Ciudad de Mexico, Mexico | |||
690457 | 690457 | 2022-12-23 | Mexico | Ciudad de Mexico | 1774057 | 43665 | 0 | 19.4326 | -99.1332 | 2022-12-24 04:21:02 | Ciudad de Mexico, Mexico | |||
694472 | 694472 | 2022-03-17 | Mexico | Ciudad de Mexico | 1377867 | 42509 | 0 | 19.4326 | -99.1332 | 2022-03-18 04:20:55 | Ciudad de Mexico, Mexico | |||
698487 | 698487 | 2021-11-04 | Mexico | Ciudad de Mexico | 972383 | 39898 | 0 | 19.4326 | -99.1332 | 2021-11-05 04:21:54 | Ciudad de Mexico, Mexico | |||
702485 | 702485 | 2021-03-16 | Mexico | Ciudad de Mexico | 585348 | 29257 | 0 | 556091 | 19.4326 | -99.1332 | 2021-03-17 05:25:07 | Ciudad de Mexico, Mexico | ||
706517 | 706517 | 2021-09-29 | Mexico | Ciudad de Mexico | 945914 | 38927 | 0 | 19.4326 | -99.1332 | 2021-09-30 04:21:20 | Ciudad de Mexico, Mexico | |||
710534 | 710534 | 2022-11-01 | Mexico | Ciudad de Mexico | 1746475 | 43605 | 0 | 19.4326 | -99.1332 | 2022-11-02 04:22:09 | Ciudad de Mexico, Mexico | |||
714548 | 714548 | 2021-11-12 | Mexico | Ciudad de Mexico | 976347 | 39992 | 0 | 19.4326 | -99.1332 | 2021-11-13 04:21:38 | Ciudad de Mexico, Mexico | |||
718566 | 718566 | 2022-12-04 | Mexico | Ciudad de Mexico | 1752242 | 43617 | 0 | 19.4326 | -99.1332 | 2022-12-05 04:20:58 | Ciudad de Mexico, Mexico | |||
722580 | 722580 | 2021-11-20 | Mexico | Ciudad de Mexico | 979658 | 40043 | 0 | 19.4326 | -99.1332 | 2021-11-21 04:22:13 | Ciudad de Mexico, Mexico | |||
726578 | 726578 | 2021-05-22 | Mexico | Ciudad de Mexico | 653784 | 33100 | 0 | 620684 | 19.4326 | -99.1332 | 2021-05-23 04:20:51 | Ciudad de Mexico, Mexico | ||
730610 | 730610 | 2021-12-27 | Mexico | Ciudad de Mexico | 995257 | 40313 | 0 | 19.4326 | -99.1332 | 2021-12-28 04:21:47 | Ciudad de Mexico, Mexico | |||
737378 | 737378 | 2020-06-12 | Mexico | Ciudad de Mexico | 35272 | 4401 | 26574 | 4297 | 19.4326 | -99.1332 | 2020-06-13 03:33:14 | Ciudad de Mexico, Mexico | ||
738381 | 738381 | 2020-12-02 | Mexico | Ciudad de Mexico | 215006 | 13746 | 0 | 201260 | 19.4326 | -99.1332 | 2020-12-03 05:28:22 | Ciudad de Mexico, Mexico | ||
742394 | 742394 | 2021-02-20 | Mexico | Ciudad de Mexico | 538974 | 26167 | 0 | 512807 | 19.4326 | -99.1332 | 2021-02-21 05:24:33 | Ciudad de Mexico, Mexico | ||
746427 | 746427 | 2022-04-23 | Mexico | Ciudad de Mexico | 1395351 | 42766 | 0 | 19.4326 | -99.1332 | 2022-04-24 04:20:56 | Ciudad de Mexico, Mexico | |||
753376 | 753376 | 2020-08-01 | Mexico | Ciudad de Mexico | 74314 | 8969 | 58373 | 6972 | 19.4326 | -99.1332 | 2020-08-02 04:34:47 | Ciudad de Mexico, Mexico | ||
754382 | 754382 | 2020-10-28 | Mexico | Ciudad de Mexico | 158518 | 14987 | 130804 | 12727 | 19.4326 | -99.1332 | 2020-10-29 04:24:49 | Ciudad de Mexico, Mexico | ||
758410 | 758410 | 2021-11-26 | Mexico | Ciudad de Mexico | 983222 | 40098 | 0 | 19.4326 | -99.1332 | 2021-11-27 04:22:45 | Ciudad de Mexico, Mexico | |||
762393 | 762393 | 2020-10-18 | Mexico | Ciudad de Mexico | 146952 | 14379 | 123952 | 8621 | 19.4326 | -99.1332 | 2020-10-19 04:24:16 | Ciudad de Mexico, Mexico | ||
766400 | 766400 | 2020-12-29 | Mexico | Ciudad de Mexico | 320251 | 16385 | 0 | 303866 | 19.4326 | -99.1332 | 2020-12-30 05:22:34 | Ciudad de Mexico, Mexico | ||
770431 | 770431 | 2021-10-23 | Mexico | Ciudad de Mexico | 967113 | 39723 | 0 | 19.4326 | -99.1332 | 2021-10-24 04:21:22 | Ciudad de Mexico, Mexico | |||
774428 | 774428 | 2021-01-12 | Mexico | Ciudad de Mexico | 374850 | 18502 | 0 | 356348 | 19.4326 | -99.1332 | 2021-01-13 05:22:15 | Ciudad de Mexico, Mexico | ||
778442 | 778442 | 2021-07-08 | Mexico | Ciudad de Mexico | 701281 | 34858 | 0 | 666423 | 19.4326 | -99.1332 | 2021-07-09 04:21:21 | Ciudad de Mexico, Mexico | ||
782473 | 782473 | 2021-12-13 | Mexico | Ciudad de Mexico | 989007 | 40224 | 0 | 19.4326 | -99.1332 | 2021-12-14 04:22:38 | Ciudad de Mexico, Mexico | |||
786456 | 786456 | 2020-10-15 | Mexico | Ciudad de Mexico | 143549 | 14236 | 121208 | 8105 | 19.4326 | -99.1332 | 2020-10-16 04:24:01 | Ciudad de Mexico, Mexico | ||
790463 | 790463 | 2021-02-04 | Mexico | Ciudad de Mexico | 488328 | 22916 | 0 | 465412 | 19.4326 | -99.1332 | 2021-02-05 05:22:38 | Ciudad de Mexico, Mexico | ||
794498 | 794498 | 2022-10-24 | Mexico | Ciudad de Mexico | 1745128 | 43600 | 0 | 19.4326 | -99.1332 | 2022-10-25 04:21:53 | Ciudad de Mexico, Mexico | |||
798512 | 798512 | 2021-12-22 | Mexico | Ciudad de Mexico | 991990 | 40282 | 0 | 19.4326 | -99.1332 | 2021-12-23 04:21:21 | Ciudad de Mexico, Mexico | |||
805234 | 805234 | 2020-06-01 | Mexico | Ciudad de Mexico | 25787 | 2713 | 19099 | 3975 | 19.4326 | -99.1332 | 2020-06-02 02:33:08 | Ciudad de Mexico, Mexico | ||
809657 | 809657 | 2021-09-20 | Mexico | Ciudad de Mexico | 931634 | 38610 | 0 | 19.4326 | -99.1332 | 2021-09-21 04:21:26 | Ciudad de Mexico, Mexico | |||
813655 | 813655 | 2020-09-05 | Mexico | Ciudad de Mexico | 104255 | 10825 | 85273 | 8157 | 19.4326 | -99.1332 | 2020-09-06 04:28:33 | Ciudad de Mexico, Mexico | ||
817646 | 817646 | 2020-10-09 | Mexico | Ciudad de Mexico | 138329 | 13919 | 116687 | 7723 | 19.4326 | -99.1332 | 2020-10-10 04:23:57 | Ciudad de Mexico, Mexico | ||
821650 | 821650 | 2020-11-19 | Mexico | Ciudad de Mexico | 183253 | 12836 | 0 | 170417 | 19.4326 | -99.1332 | 2020-11-20 05:26:28 | Ciudad de Mexico, Mexico | ||
825664 | 825664 | 2021-06-06 | Mexico | Ciudad de Mexico | 662992 | 34281 | 0 | 628711 | 19.4326 | -99.1332 | 2021-06-07 04:22:51 | Ciudad de Mexico, Mexico | ||
829678 | 829678 | 2021-07-09 | Mexico | Ciudad de Mexico | 704488 | 34886 | 0 | 669602 | 19.4326 | -99.1332 | 2021-07-10 04:21:25 | Ciudad de Mexico, Mexico |
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]);