johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31,389 rows where country_or_region = "Mexico" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Aguascalientes 954
- Baja California 954
- Baja California Sur 954
- Campeche 954
- Chiapas 954
- Chihuahua 954
- Ciudad de Mexico 954
- Coahuila 954
- Colima 954
- Durango 954
- Guanajuato 954
- Guerrero 954
- Hidalgo 954
- Jalisco 954
- Mexico 954
- Michoacan 954
- Morelos 954
- Nayarit 954
- Nuevo Leon 954
- Oaxaca 954
- Puebla 954
- Queretaro 954
- Quintana Roo 954
- San Luis Potosi 954
- Sinaloa 954
- Sonora 954
- Tabasco 954
- Tamaulipas 954
- Tlaxcala 954
- Veracruz 954
- …
day (date) >30 ✖
- 2020-11-12 33
- 2020-11-13 33
- 2020-11-14 33
- 2020-11-15 33
- 2020-11-16 33
- 2020-11-17 33
- 2020-11-19 33
- 2020-11-20 33
- 2020-11-21 33
- 2020-11-22 33
- 2020-11-23 33
- 2020-11-24 33
- 2020-11-25 33
- 2020-11-26 33
- 2020-11-28 33
- 2020-11-29 33
- 2020-11-30 33
- 2020-12-01 33
- 2020-12-02 33
- 2020-12-04 33
- 2020-12-05 33
- 2020-12-06 33
- 2020-12-07 33
- 2020-12-08 33
- 2020-12-09 33
- 2020-12-10 33
- 2020-12-11 33
- 2020-12-12 33
- 2020-12-13 33
- 2020-12-14 33
- …
country_or_region 1
- Mexico · 31,289 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
522961 | 522961 | 2021-06-09 | Mexico | Unknown | 0 | 0 | 1946477 | 0 | 2021-06-10 04:23:17 | Unknown, Mexico | ||||
530809 | 530809 | 2021-02-22 | Mexico | Unknown | 0 | 0 | 1602024 | 0 | 2021-02-23 05:23:41 | Unknown, Mexico | ||||
534841 | 534841 | 2021-10-27 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-28 04:22:08 | Unknown, Mexico | |||||
538859 | 538859 | 2022-10-26 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-27 04:22:01 | Unknown, Mexico | |||||
542875 | 542875 | 2022-12-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-16 04:21:01 | Unknown, Mexico | |||||
550879 | 550879 | 2021-12-08 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-09 04:22:49 | Unknown, Mexico | |||||
554895 | 554895 | 2022-01-16 | Mexico | Unknown | 0 | 0 | 0 | 2022-01-17 04:21:08 | Unknown, Mexico | |||||
558913 | 558913 | 2022-06-16 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-17 04:20:56 | Unknown, Mexico | |||||
563071 | 563071 | 2021-06-22 | Mexico | Unknown | 0 | 0 | 1977071 | 0 | 2021-06-23 04:21:46 | Unknown, Mexico | ||||
567209 | 567209 | 2021-10-29 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-30 04:22:03 | Unknown, Mexico | |||||
574938 | 574938 | 2022-02-25 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-26 04:21:12 | Unknown, Mexico | |||||
578936 | 578936 | 2021-07-13 | Mexico | Unknown | 0 | 0 | 2056317 | 0 | 2021-07-14 04:21:35 | Unknown, Mexico | ||||
589732 | 589732 | 2021-08-08 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-09 04:21:24 | Unknown, Mexico | |||||
593765 | 593765 | 2022-07-01 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-02 04:21:16 | Unknown, Mexico | |||||
597779 | 597779 | 2021-10-19 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-20 04:21:00 | Unknown, Mexico | |||||
601795 | 601795 | 2021-09-23 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-24 04:21:44 | Unknown, Mexico | |||||
605792 | 605792 | 2021-04-09 | Mexico | Unknown | 0 | 0 | 1804914 | 0 | 2021-04-10 04:20:59 | Unknown, Mexico | ||||
613791 | 613791 | 2021-02-08 | Mexico | Unknown | 0 | 0 | 1501580 | 0 | 2021-02-09 05:23:30 | Unknown, Mexico | ||||
617969 | 617969 | 2022-11-05 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-06 04:21:24 | Unknown, Mexico | |||||
621985 | 621985 | 2022-05-22 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-26 04:20:50 | Unknown, Mexico | |||||
625982 | 625982 | 2021-07-10 | Mexico | Unknown | 0 | 0 | 2041418 | 0 | 2021-07-11 04:21:43 | Unknown, Mexico | ||||
630015 | 630015 | 2022-07-12 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-13 04:20:58 | Unknown, Mexico | |||||
634029 | 634029 | 2021-10-13 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-14 04:21:29 | Unknown, Mexico | |||||
638027 | 638027 | 2021-03-31 | Mexico | Unknown | 0 | 0 | 1773236 | 0 | 2021-04-01 04:27:05 | Unknown, Mexico | ||||
642042 | 642042 | 2021-09-07 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-08 04:21:31 | Unknown, Mexico | |||||
646055 | 646055 | 2021-05-05 | Mexico | Unknown | 0 | 0 | 1877347 | 0 | 2021-05-06 04:20:38 | Unknown, Mexico | ||||
650070 | 650070 | 2021-08-09 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-10 04:21:27 | Unknown, Mexico | |||||
654101 | 654101 | 2021-10-22 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-23 04:21:32 | Unknown, Mexico | |||||
658420 | 658420 | 2022-05-13 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-14 04:20:48 | Unknown, Mexico | |||||
670406 | 670406 | 2022-07-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-22 04:21:15 | Unknown, Mexico | |||||
674422 | 674422 | 2022-07-30 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-31 04:21:02 | Unknown, Mexico | |||||
678415 | 678415 | 2020-11-23 | Mexico | Unknown | 0 | 0 | 784693 | 0 | 2020-11-24 05:27:31 | Unknown, Mexico | ||||
682446 | 682446 | 2021-10-24 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-25 04:22:31 | Unknown, Mexico | |||||
686462 | 686462 | 2021-11-13 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-14 04:21:31 | Unknown, Mexico | |||||
690480 | 690480 | 2022-12-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-24 04:21:02 | Unknown, Mexico | |||||
694495 | 694495 | 2022-03-17 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-18 04:20:55 | Unknown, Mexico | |||||
698510 | 698510 | 2021-11-04 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-05 04:21:54 | Unknown, Mexico | |||||
702508 | 702508 | 2021-03-16 | Mexico | Unknown | 0 | 0 | 1716135 | 0 | 2021-03-17 05:25:07 | Unknown, Mexico | ||||
706540 | 706540 | 2021-09-29 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-30 04:21:20 | Unknown, Mexico | |||||
710557 | 710557 | 2022-11-01 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-02 04:22:09 | Unknown, Mexico | |||||
714571 | 714571 | 2021-11-12 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-13 04:21:38 | Unknown, Mexico | |||||
718589 | 718589 | 2022-12-04 | Mexico | Unknown | 7616 | 30 | 0 | 2022-12-05 04:20:58 | Unknown, Mexico | |||||
722603 | 722603 | 2021-11-20 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-21 04:22:13 | Unknown, Mexico | |||||
726601 | 726601 | 2021-05-22 | Mexico | Unknown | 0 | 0 | 1912690 | 0 | 2021-05-23 04:20:51 | Unknown, Mexico | ||||
730633 | 730633 | 2021-12-27 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-28 04:21:47 | Unknown, Mexico | |||||
738404 | 738404 | 2020-12-02 | Mexico | Unknown | 0 | 0 | 836567 | 0 | 2020-12-03 05:28:22 | Unknown, Mexico | ||||
742417 | 742417 | 2021-02-20 | Mexico | Unknown | 0 | 0 | 1590696 | 0 | 2021-02-21 05:24:33 | Unknown, Mexico | ||||
746450 | 746450 | 2022-04-23 | Mexico | Unknown | 0 | 0 | 0 | 2022-04-24 04:20:56 | Unknown, Mexico | |||||
758433 | 758433 | 2021-11-26 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-27 04:22:45 | Unknown, Mexico | |||||
766423 | 766423 | 2020-12-29 | Mexico | Unknown | 0 | 0 | 1058429 | 0 | 2020-12-30 05:22:34 | Unknown, Mexico | ||||
770454 | 770454 | 2021-10-23 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-24 04:21:22 | Unknown, Mexico | |||||
774451 | 774451 | 2021-01-12 | Mexico | Unknown | 0 | 0 | 1168354 | 0 | 2021-01-13 05:22:15 | Unknown, Mexico | ||||
778465 | 778465 | 2021-07-08 | Mexico | Unknown | 0 | 0 | 2031875 | 0 | 2021-07-09 04:21:21 | Unknown, Mexico | ||||
782496 | 782496 | 2021-12-13 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-14 04:22:38 | Unknown, Mexico | |||||
790486 | 790486 | 2021-02-04 | Mexico | Unknown | 0 | 0 | 1450237 | 0 | 2021-02-05 05:22:38 | Unknown, Mexico | ||||
794521 | 794521 | 2022-10-24 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Mexico | |||||
798535 | 798535 | 2021-12-22 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, Mexico | |||||
809680 | 809680 | 2021-09-20 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-21 04:21:26 | Unknown, Mexico | |||||
821673 | 821673 | 2020-11-19 | Mexico | Unknown | 0 | 0 | 766361 | 0 | 2020-11-20 05:26:28 | Unknown, Mexico | ||||
825687 | 825687 | 2021-06-06 | Mexico | Unknown | 0 | 0 | 1939596 | 0 | 2021-06-07 04:22:51 | Unknown, Mexico | ||||
829701 | 829701 | 2021-07-09 | Mexico | Unknown | 0 | 0 | 2036776 | 0 | 2021-07-10 04:21:25 | Unknown, Mexico | ||||
833734 | 833734 | 2022-12-02 | Mexico | Unknown | 7616 | 30 | 0 | 2022-12-03 04:21:02 | Unknown, Mexico | |||||
845673 | 845673 | 2020-12-12 | Mexico | Unknown | 0 | 0 | 911965 | 0 | 2020-12-13 05:27:20 | Unknown, Mexico | ||||
849706 | 849706 | 2022-11-02 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-03 04:22:05 | Unknown, Mexico | |||||
853722 | 853722 | 2022-09-30 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-01 04:23:01 | Unknown, Mexico | |||||
860780 | 860780 | 2020-12-11 | Mexico | Unknown | 0 | 0 | 904042 | 0 | 2020-12-12 05:26:19 | Unknown, Mexico | ||||
864419 | 864419 | 2020-01-23 | Mexico | 0 | 0 | 0 | 1/23/20 17:00 | |||||||
864873 | 864873 | 2020-11-12 | Mexico | Unknown | 0 | 0 | 736197 | 0 | 2020-11-13 05:25:30 | Unknown, Mexico | ||||
868906 | 868906 | 2022-12-11 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-12 04:21:01 | Unknown, Mexico | |||||
876370 | 876370 | 2022-03-27 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-28 04:20:33 | Unknown, Mexico | |||||
880387 | 880387 | 2022-08-05 | Mexico | Unknown | 0 | 0 | 0 | 2022-08-06 04:20:56 | Unknown, Mexico | |||||
888223 | 888223 | 2021-04-26 | Mexico | Unknown | 0 | 0 | 1853789 | 0 | 2021-04-27 04:20:52 | Unknown, Mexico | ||||
896254 | 896254 | 2022-07-24 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-25 04:20:51 | Unknown, Mexico | |||||
900270 | 900270 | 2022-07-22 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-23 04:20:53 | Unknown, Mexico | |||||
904284 | 904284 | 2021-11-24 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-25 04:22:33 | Unknown, Mexico | |||||
908281 | 908281 | 2021-01-19 | Mexico | Unknown | 0 | 0 | 1251782 | 0 | 2021-01-20 05:21:54 | Unknown, Mexico | ||||
912315 | 912315 | 2022-10-29 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-30 04:22:14 | Unknown, Mexico | |||||
919790 | 919790 | 2022-03-08 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-09 04:20:59 | Unknown, Mexico | |||||
923785 | 923785 | 2020-11-26 | Mexico | Unknown | 0 | 0 | 803581 | 0 | 2020-11-27 05:26:53 | Unknown, Mexico | ||||
927796 | 927796 | 2020-12-21 | Mexico | Unknown | 0 | 0 | 987328 | 0 | 2020-12-22 05:22:33 | Unknown, Mexico | ||||
934906 | 934906 | 2021-10-16 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-17 04:21:29 | Unknown, Mexico | |||||
938924 | 938924 | 2022-06-25 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-26 04:21:02 | Unknown, Mexico | |||||
942939 | 942939 | 2022-02-28 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-01 04:21:09 | Unknown, Mexico | |||||
946956 | 946956 | 2022-06-14 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-15 04:20:54 | Unknown, Mexico | |||||
950971 | 950971 | 2022-03-12 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-13 04:20:49 | Unknown, Mexico | |||||
954968 | 954968 | 2021-04-25 | Mexico | Unknown | 0 | 0 | 1850680 | 0 | 2021-04-26 04:21:04 | Unknown, Mexico | ||||
959002 | 959002 | 2022-07-19 | Mexico | Unknown | 0 | 0 | 0 | 2022-07-20 04:20:59 | Unknown, Mexico | |||||
963018 | 963018 | 2022-09-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-09-10 04:21:10 | Unknown, Mexico | |||||
971026 | 971026 | 2022-06-01 | Mexico | Unknown | 0 | 0 | 0 | 2022-06-02 05:20:39 | Unknown, Mexico | |||||
975021 | 975021 | 2021-02-06 | Mexico | Unknown | 0 | 0 | 1482138 | 0 | 2021-02-07 05:23:00 | Unknown, Mexico | ||||
979054 | 979054 | 2022-02-01 | Mexico | Unknown | 0 | 0 | 0 | 2022-02-02 04:21:09 | Unknown, Mexico | |||||
983052 | 983052 | 2021-04-17 | Mexico | Unknown | 0 | 0 | 1826646 | 0 | 2021-04-18 04:20:41 | Unknown, Mexico | ||||
987084 | 987084 | 2021-10-04 | Mexico | Unknown | 0 | 0 | 0 | 2021-10-05 04:21:27 | Unknown, Mexico | |||||
991101 | 991101 | 2022-08-16 | Mexico | Unknown | 0 | 0 | 0 | 2022-08-17 04:20:59 | Unknown, Mexico | |||||
998542 | 998542 | 2021-03-01 | Mexico | Unknown | 0 | 0 | 1639943 | 0 | 2021-03-02 05:23:30 | Unknown, Mexico | ||||
1006397 | 1006397 | 2020-12-06 | Mexico | Unknown | 0 | 0 | 866186 | 0 | 2020-12-07 05:26:14 | Unknown, Mexico | ||||
1010408 | 1010408 | 2020-12-30 | Mexico | Unknown | 0 | 0 | 1066771 | 0 | 2020-12-31 05:22:49 | Unknown, Mexico | ||||
1014439 | 1014439 | 2021-11-21 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-22 04:22:20 | Unknown, Mexico | |||||
1018457 | 1018457 | 2022-12-24 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-25 04:21:04 | Unknown, Mexico | |||||
1022473 | 1022473 | 2022-11-04 | Mexico | Unknown | 0 | 0 | 0 | 2022-11-05 04:21:52 | Unknown, 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]);