johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Mexico" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714556 | 714556 | 2021-11-12 | Mexico | Mexico | 376227 | 44080 | 0 | 19.4969 | -99.7233 | 2021-11-13 04:21:38 | Mexico, Mexico | |||
718574 | 718574 | 2022-12-04 | Mexico | Mexico | 704353 | 47931 | 0 | 19.4969 | -99.7233 | 2022-12-05 04:20:58 | Mexico, Mexico | |||
722588 | 722588 | 2021-11-20 | Mexico | Mexico | 377398 | 44232 | 0 | 19.4969 | -99.7233 | 2021-11-21 04:22:13 | Mexico, Mexico | |||
730618 | 730618 | 2021-12-27 | Mexico | Mexico | 382312 | 44815 | 0 | 19.4969 | -99.7233 | 2021-12-28 04:21:47 | Mexico, Mexico | |||
746435 | 746435 | 2022-04-23 | Mexico | Mexico | 571630 | 47185 | 0 | 19.4969 | -99.7233 | 2022-04-24 04:20:56 | Mexico, Mexico | |||
758418 | 758418 | 2021-11-26 | Mexico | Mexico | 378627 | 44328 | 0 | 19.4969 | -99.7233 | 2021-11-27 04:22:45 | Mexico, Mexico | |||
770439 | 770439 | 2021-10-23 | Mexico | Mexico | 372355 | 43673 | 0 | 19.4969 | -99.7233 | 2021-10-24 04:21:22 | Mexico, Mexico | |||
782481 | 782481 | 2021-12-13 | Mexico | Mexico | 380473 | 44504 | 0 | 19.4969 | -99.7233 | 2021-12-14 04:22:38 | Mexico, Mexico | |||
794506 | 794506 | 2022-10-24 | Mexico | Mexico | 703253 | 47913 | 0 | 19.4969 | -99.7233 | 2022-10-25 04:21:53 | Mexico, Mexico | |||
798520 | 798520 | 2021-12-22 | Mexico | Mexico | 381460 | 44747 | 0 | 19.4969 | -99.7233 | 2021-12-23 04:21:21 | Mexico, Mexico | |||
809665 | 809665 | 2021-09-20 | Mexico | Mexico | 353951 | 42018 | 0 | 19.4969 | -99.7233 | 2021-09-21 04:21:26 | Mexico, Mexico | |||
833719 | 833719 | 2022-12-02 | Mexico | Mexico | 704353 | 47931 | 0 | 19.4969 | -99.7233 | 2022-12-03 04:21:02 | Mexico, Mexico | |||
849691 | 849691 | 2022-11-02 | Mexico | Mexico | 703565 | 47919 | 0 | 19.4969 | -99.7233 | 2022-11-03 04:22:05 | Mexico, Mexico | |||
853707 | 853707 | 2022-09-30 | Mexico | Mexico | 701963 | 47870 | 0 | 19.4969 | -99.7233 | 2022-10-01 04:23:01 | Mexico, Mexico | |||
868891 | 868891 | 2022-12-11 | Mexico | Mexico | 707339 | 47940 | 0 | 19.4969 | -99.7233 | 2022-12-12 04:21:01 | Mexico, Mexico | |||
876355 | 876355 | 2022-03-27 | Mexico | Mexico | 537814 | 47072 | 0 | 19.4969 | -99.7233 | 2022-03-28 04:20:33 | Mexico, Mexico | |||
880372 | 880372 | 2022-08-05 | Mexico | Mexico | 676549 | 47655 | 0 | 19.4969 | -99.7233 | 2022-08-06 04:20:56 | Mexico, Mexico | |||
896239 | 896239 | 2022-07-24 | Mexico | Mexico | 658686 | 47537 | 0 | 19.4969 | -99.7233 | 2022-07-25 04:20:51 | Mexico, Mexico | |||
900255 | 900255 | 2022-07-22 | Mexico | Mexico | 655673 | 47516 | 0 | 19.4969 | -99.7233 | 2022-07-23 04:20:53 | Mexico, Mexico | |||
904269 | 904269 | 2021-11-24 | Mexico | Mexico | 377949 | 44288 | 0 | 19.4969 | -99.7233 | 2021-11-25 04:22:33 | Mexico, Mexico | |||
912300 | 912300 | 2022-10-29 | Mexico | Mexico | 703337 | 47914 | 0 | 19.4969 | -99.7233 | 2022-10-30 04:22:14 | Mexico, Mexico | |||
919775 | 919775 | 2022-03-08 | Mexico | Mexico | 528556 | 46737 | 0 | 19.4969 | -99.7233 | 2022-03-09 04:20:59 | Mexico, Mexico | |||
934891 | 934891 | 2021-10-16 | Mexico | Mexico | 370460 | 43534 | 0 | 19.4969 | -99.7233 | 2021-10-17 04:21:29 | Mexico, Mexico | |||
938909 | 938909 | 2022-06-25 | Mexico | Mexico | 591623 | 47357 | 0 | 19.4969 | -99.7233 | 2022-06-26 04:21:02 | Mexico, Mexico | |||
942924 | 942924 | 2022-02-28 | Mexico | Mexico | 520870 | 46459 | 0 | 19.4969 | -99.7233 | 2022-03-01 04:21:09 | Mexico, Mexico | |||
946941 | 946941 | 2022-06-14 | Mexico | Mexico | 579428 | 47331 | 0 | 19.4969 | -99.7233 | 2022-06-15 04:20:54 | Mexico, Mexico | |||
950956 | 950956 | 2022-03-12 | Mexico | Mexico | 532146 | 46898 | 0 | 19.4969 | -99.7233 | 2022-03-13 04:20:49 | Mexico, Mexico | |||
958987 | 958987 | 2022-07-19 | Mexico | Mexico | 646215 | 47479 | 0 | 19.4969 | -99.7233 | 2022-07-20 04:20:59 | Mexico, Mexico | |||
963003 | 963003 | 2022-09-09 | Mexico | Mexico | 697653 | 47825 | 0 | 19.4969 | -99.7233 | 2022-09-10 04:21:10 | Mexico, Mexico | |||
971011 | 971011 | 2022-06-01 | Mexico | Mexico | 574910 | 47303 | 0 | 19.4969 | -99.7233 | 2022-06-02 05:20:39 | Mexico, Mexico | |||
979039 | 979039 | 2022-02-01 | Mexico | Mexico | 470962 | 45408 | 0 | 19.4969 | -99.7233 | 2022-02-02 04:21:09 | Mexico, Mexico | |||
987069 | 987069 | 2021-10-04 | Mexico | Mexico | 363937 | 42904 | 0 | 19.4969 | -99.7233 | 2021-10-05 04:21:27 | Mexico, Mexico | |||
991086 | 991086 | 2022-08-16 | Mexico | Mexico | 687976 | 47730 | 0 | 19.4969 | -99.7233 | 2022-08-17 04:20:59 | Mexico, Mexico | |||
1014424 | 1014424 | 2021-11-21 | Mexico | Mexico | 377543 | 44256 | 0 | 19.4969 | -99.7233 | 2021-11-22 04:22:20 | Mexico, Mexico | |||
1018442 | 1018442 | 2022-12-24 | Mexico | Mexico | 713682 | 47966 | 0 | 19.4969 | -99.7233 | 2022-12-25 04:21:04 | Mexico, Mexico | |||
1022458 | 1022458 | 2022-11-04 | Mexico | Mexico | 703654 | 47919 | 0 | 19.4969 | -99.7233 | 2022-11-05 04:21:52 | Mexico, Mexico | |||
1030466 | 1030466 | 2021-12-06 | Mexico | Mexico | 379714 | 44433 | 0 | 19.4969 | -99.7233 | 2021-12-07 04:22:34 | Mexico, Mexico | |||
1049930 | 1049930 | 2022-11-06 | Mexico | Mexico | 703654 | 47919 | 0 | 19.4969 | -99.7233 | 2022-11-07 04:21:26 | Mexico, Mexico | |||
1057940 | 1057940 | 2022-02-23 | Mexico | Mexico | 515361 | 46304 | 0 | 19.4969 | -99.7233 | 2022-02-24 04:21:14 | Mexico, Mexico | |||
1065969 | 1065969 | 2022-07-28 | Mexico | Mexico | 664610 | 47562 | 0 | 19.4969 | -99.7233 | 2022-07-29 04:20:45 | Mexico, Mexico | |||
1069985 | 1069985 | 2022-08-07 | Mexico | Mexico | 679604 | 47675 | 0 | 19.4969 | -99.7233 | 2022-08-08 04:21:08 | Mexico, Mexico | |||
1074001 | 1074001 | 2022-12-28 | Mexico | Mexico | 715478 | 47985 | 0 | 19.4969 | -99.7233 | 2022-12-29 04:21:01 | Mexico, Mexico | |||
1078015 | 1078015 | 2021-12-09 | Mexico | Mexico | 380122 | 44470 | 0 | 19.4969 | -99.7233 | 2021-12-10 04:22:28 | Mexico, Mexico | |||
1086167 | 1086167 | 2022-08-09 | Mexico | Mexico | 681488 | 47691 | 0 | 19.4969 | -99.7233 | 2022-08-10 04:20:57 | Mexico, Mexico | |||
1098210 | 1098210 | 2022-08-03 | Mexico | Mexico | 675234 | 47641 | 0 | 19.4969 | -99.7233 | 2022-08-04 04:20:58 | Mexico, Mexico | |||
1109666 | 1109666 | 2022-05-21 | Mexico | Mexico | 572781 | 47267 | 0 | 19.4969 | -99.7233 | 2022-05-22 04:20:52 | Mexico, Mexico | |||
1113680 | 1113680 | 2022-01-11 | Mexico | Mexico | 396600 | 44911 | 0 | 19.4969 | -99.7233 | 2022-01-12 04:21:44 | Mexico, Mexico | |||
1117679 | 1117679 | 2021-08-06 | Mexico | Mexico | 301988 | 38700 | 0 | 19.4969 | -99.7233 | 2021-08-07 04:21:30 | Mexico, Mexico | |||
1141003 | 1141003 | 2022-01-23 | Mexico | Mexico | 444496 | 45074 | 0 | 19.4969 | -99.7233 | 2022-01-24 04:21:12 | Mexico, Mexico | |||
1145019 | 1145019 | 2021-12-01 | Mexico | Mexico | 379161 | 44373 | 0 | 19.4969 | -99.7233 | 2021-12-02 04:22:37 | Mexico, Mexico | |||
1149037 | 1149037 | 2022-12-12 | Mexico | Mexico | 707895 | 47941 | 0 | 19.4969 | -99.7233 | 2022-12-13 04:21:01 | Mexico, Mexico | |||
1157243 | 1157243 | 2022-04-29 | Mexico | Mexico | 571993 | 47204 | 0 | 19.4969 | -99.7233 | 2022-04-30 04:21:05 | Mexico, Mexico | |||
1161260 | 1161260 | 2022-08-18 | Mexico | Mexico | 688970 | 47740 | 0 | 19.4969 | -99.7233 | 2022-08-19 04:20:54 | Mexico, Mexico | |||
1169290 | 1169290 | 2022-05-20 | Mexico | Mexico | 572781 | 47267 | 0 | 19.4969 | -99.7233 | 2022-05-21 04:20:58 | Mexico, Mexico | |||
1184837 | 1184837 | 2022-05-18 | Mexico | Mexico | 572781 | 47267 | 0 | 19.4969 | -99.7233 | 2022-05-19 04:20:54 | Mexico, Mexico | |||
1199899 | 1199899 | 2022-07-06 | Mexico | Mexico | 612801 | 47384 | 0 | 19.4969 | -99.7233 | 2022-07-07 04:20:55 | Mexico, Mexico | |||
1211644 | 1211644 | 2022-07-11 | Mexico | Mexico | 624379 | 47405 | 0 | 19.4969 | -99.7233 | 2022-07-12 04:20:51 | Mexico, Mexico | |||
1215658 | 1215658 | 2022-01-08 | Mexico | Mexico | 393097 | 44894 | 0 | 19.4969 | -99.7233 | 2022-01-09 04:21:46 | Mexico, Mexico | |||
1223689 | 1223689 | 2022-04-14 | Mexico | Mexico | 570855 | 47163 | 0 | 19.4969 | -99.7233 | 2022-04-15 04:20:57 | Mexico, Mexico | |||
1227704 | 1227704 | 2022-01-24 | Mexico | Mexico | 445728 | 45081 | 0 | 19.4969 | -99.7233 | 2022-01-25 04:21:05 | Mexico, Mexico | |||
1231720 | 1231720 | 2021-11-28 | Mexico | Mexico | 378745 | 44344 | 0 | 19.4969 | -99.7233 | 2021-11-29 04:22:30 | Mexico, Mexico | |||
1235736 | 1235736 | 2021-09-27 | Mexico | Mexico | 359728 | 42389 | 0 | 19.4969 | -99.7233 | 2021-09-28 04:21:28 | Mexico, Mexico | |||
1239753 | 1239753 | 2022-11-28 | Mexico | Mexico | 704353 | 47931 | 0 | 19.4969 | -99.7233 | 2022-11-29 04:21:05 | Mexico, Mexico | |||
1250849 | 1250849 | 2022-08-23 | Mexico | Mexico | 692162 | 47769 | 0 | 19.4969 | -99.7233 | 2022-08-24 04:20:46 | Mexico, Mexico | |||
1254863 | 1254863 | 2021-12-20 | Mexico | Mexico | 381317 | 44677 | 0 | 19.4969 | -99.7233 | 2021-12-21 03:21:27 | Mexico, Mexico | |||
1258879 | 1258879 | 2021-12-18 | Mexico | Mexico | 381127 | 44609 | 0 | 19.4969 | -99.7233 | 2021-12-19 04:21:11 | Mexico, Mexico | |||
1262878 | 1262878 | 2021-09-09 | Mexico | Mexico | 346178 | 41530 | 0 | 19.4969 | -99.7233 | 2021-09-10 04:21:20 | Mexico, Mexico | |||
1274379 | 1274379 | 2021-10-03 | Mexico | Mexico | 363489 | 42748 | 0 | 19.4969 | -99.7233 | 2021-10-04 04:21:31 | Mexico, Mexico | |||
1282080 | 1282080 | 2022-01-05 | Mexico | Mexico | 387381 | 44861 | 0 | 19.4969 | -99.7233 | 2022-01-06 04:22:09 | Mexico, Mexico | |||
1286096 | 1286096 | 2022-01-04 | Mexico | Mexico | 386020 | 44851 | 0 | 19.4969 | -99.7233 | 2022-01-05 04:21:59 | Mexico, Mexico | |||
1294126 | 1294126 | 2022-02-05 | Mexico | Mexico | 485744 | 45588 | 0 | 19.4969 | -99.7233 | 2022-02-06 04:21:00 | Mexico, Mexico | |||
1298143 | 1298143 | 2022-02-17 | Mexico | Mexico | 506607 | 46050 | 0 | 19.4969 | -99.7233 | 2022-02-18 04:21:04 | Mexico, Mexico | |||
1314291 | 1314291 | 2022-05-27 | Mexico | Mexico | 573341 | 47288 | 0 | 19.4969 | -99.7233 | 2022-05-28 04:21:07 | Mexico, Mexico | |||
1318305 | 1318305 | 2022-01-26 | Mexico | Mexico | 449295 | 45116 | 0 | 19.4969 | -99.7233 | 2022-01-27 04:21:19 | Mexico, Mexico | |||
1322321 | 1322321 | 2021-11-14 | Mexico | Mexico | 376573 | 44117 | 0 | 19.4969 | -99.7233 | 2021-11-15 04:21:36 | Mexico, Mexico | |||
1326338 | 1326338 | 2022-04-26 | Mexico | Mexico | 571779 | 47191 | 0 | 19.4969 | -99.7233 | 2022-04-27 04:20:52 | Mexico, Mexico | |||
1334367 | 1334367 | 2021-09-28 | Mexico | Mexico | 360605 | 42438 | 0 | 19.4969 | -99.7233 | 2021-09-29 04:21:45 | Mexico, Mexico | |||
1342379 | 1342379 | 2021-08-11 | Mexico | Mexico | 308871 | 39067 | 0 | 19.4969 | -99.7233 | 2021-08-12 04:21:25 | Mexico, Mexico | |||
1346412 | 1346412 | 2022-08-10 | Mexico | Mexico | 681488 | 47691 | 0 | 19.4969 | -99.7233 | 2022-08-11 04:20:49 | Mexico, Mexico | |||
1358427 | 1358427 | 2021-11-27 | Mexico | Mexico | 378627 | 44328 | 0 | 19.4969 | -99.7233 | 2021-11-28 04:22:43 | Mexico, Mexico | |||
1362443 | 1362443 | 2022-02-08 | Mexico | Mexico | 487575 | 45631 | 0 | 19.4969 | -99.7233 | 2022-02-09 04:21:04 | Mexico, Mexico | |||
1366569 | 1366569 | 2022-10-28 | Mexico | Mexico | 703337 | 47914 | 0 | 19.4969 | -99.7233 | 2022-10-29 04:21:13 | Mexico, Mexico | |||
1370585 | 1370585 | 2022-09-21 | Mexico | Mexico | 700835 | 47851 | 0 | 19.4969 | -99.7233 | 2022-09-22 04:22:56 | Mexico, Mexico | |||
1374582 | 1374582 | 2021-09-15 | Mexico | Mexico | 351341 | 41868 | 0 | 19.4969 | -99.7233 | 2021-09-16 04:22:19 | Mexico, Mexico | |||
1385720 | 1385720 | 2021-09-13 | Mexico | Mexico | 348819 | 41698 | 0 | 19.4969 | -99.7233 | 2021-09-14 04:21:41 | Mexico, Mexico | |||
1389751 | 1389751 | 2022-01-07 | Mexico | Mexico | 390829 | 44872 | 0 | 19.4969 | -99.7233 | 2022-01-08 04:21:53 | Mexico, Mexico | |||
1393769 | 1393769 | 2022-09-02 | Mexico | Mexico | 696559 | 47813 | 0 | 19.4969 | -99.7233 | 2022-09-03 04:21:04 | Mexico, Mexico | |||
1397784 | 1397784 | 2022-05-06 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-07 04:21:09 | Mexico, Mexico | |||
1405135 | 1405135 | 2022-08-02 | Mexico | Mexico | 673226 | 47624 | 0 | 19.4969 | -99.7233 | 2022-08-03 04:20:59 | Mexico, Mexico | |||
1417179 | 1417179 | 2022-07-08 | Mexico | Mexico | 616079 | 47388 | 0 | 19.4969 | -99.7233 | 2022-07-09 04:20:59 | Mexico, Mexico | |||
1421195 | 1421195 | 2022-06-08 | Mexico | Mexico | 576830 | 47314 | 0 | 19.4969 | -99.7233 | 2022-06-09 04:20:54 | Mexico, Mexico | |||
1432657 | 1432657 | 2021-12-28 | Mexico | Mexico | 382355 | 44816 | 0 | 19.4969 | -99.7233 | 2021-12-29 03:21:43 | Mexico, Mexico | |||
1436674 | 1436674 | 2022-03-28 | Mexico | Mexico | 537848 | 47074 | 0 | 19.4969 | -99.7233 | 2022-03-29 04:20:46 | Mexico, Mexico | |||
1464175 | 1464175 | 2022-02-10 | Mexico | Mexico | 489567 | 45694 | 0 | 19.4969 | -99.7233 | 2022-02-11 04:21:09 | Mexico, Mexico | |||
1468191 | 1468191 | 2022-03-24 | Mexico | Mexico | 536754 | 47021 | 0 | 19.4969 | -99.7233 | 2022-03-25 04:20:46 | Mexico, Mexico | |||
1472206 | 1472206 | 2022-01-17 | Mexico | Mexico | 413167 | 44962 | 0 | 19.4969 | -99.7233 | 2022-01-18 04:21:04 | Mexico, Mexico | |||
1483645 | 1483645 | 2021-08-13 | Mexico | Mexico | 313286 | 39244 | 0 | 19.4969 | -99.7233 | 2021-08-14 04:21:25 | Mexico, Mexico | |||
1487678 | 1487678 | 2022-07-26 | Mexico | Mexico | 658936 | 47537 | 0 | 19.4969 | -99.7233 | 2022-07-27 04:21:04 | Mexico, Mexico | |||
1491692 | 1491692 | 2021-10-12 | Mexico | Mexico | 368273 | 43412 | 0 | 19.4969 | -99.7233 | 2021-10-13 04:20:51 | Mexico, Mexico | |||
1503691 | 1503691 | 2022-05-16 | Mexico | Mexico | 572781 | 47267 | 0 | 19.4969 | -99.7233 | 2022-05-17 04:20:59 | 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]);