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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1692408 | 1692408 | 2022-01-10 | Mexico | Mexico | 393546 | 44896 | 0 | 19.4969 | -99.7233 | 2022-01-11 04:22:01 | Mexico, Mexico | |||
126823 | 126823 | 2022-01-09 | Mexico | Mexico | 393546 | 44896 | 0 | 19.4969 | -99.7233 | 2022-01-10 04:22:07 | Mexico, Mexico | |||
1215658 | 1215658 | 2022-01-08 | Mexico | Mexico | 393097 | 44894 | 0 | 19.4969 | -99.7233 | 2022-01-09 04:21:46 | Mexico, Mexico | |||
1389751 | 1389751 | 2022-01-07 | Mexico | Mexico | 390829 | 44872 | 0 | 19.4969 | -99.7233 | 2022-01-08 04:21:53 | Mexico, Mexico | |||
2610138 | 2610138 | 2022-01-06 | Mexico | Mexico | 389005 | 44865 | 0 | 19.4969 | -99.7233 | 2022-01-07 04:22:09 | 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 | |||
1700440 | 1700440 | 2022-01-03 | Mexico | Mexico | 384959 | 44837 | 0 | 19.4969 | -99.7233 | 2022-01-04 04:22:17 | Mexico, Mexico | |||
3519523 | 3519523 | 2022-01-02 | Mexico | Mexico | 384759 | 44836 | 0 | 19.4969 | -99.7233 | 2022-01-03 02:22:25 | Mexico, Mexico | |||
2167653 | 2167653 | 2022-01-01 | Mexico | Mexico | 384693 | 44836 | 0 | 19.4969 | -99.7233 | 2022-01-02 04:20:52 | Mexico, Mexico | |||
2777084 | 2777084 | 2021-12-31 | Mexico | Mexico | 384119 | 44835 | 0 | 19.4969 | -99.7233 | 2022-01-01 04:22:14 | Mexico, Mexico | |||
3998741 | 3998741 | 2021-12-30 | Mexico | Mexico | 382995 | 44822 | 0 | 19.4969 | -99.7233 | 2021-12-31 04:21:50 | Mexico, Mexico | |||
1668548 | 1668548 | 2021-12-29 | Mexico | Mexico | 382615 | 44817 | 0 | 19.4969 | -99.7233 | 2021-12-30 04:21:25 | Mexico, Mexico | |||
1432657 | 1432657 | 2021-12-28 | Mexico | Mexico | 382355 | 44816 | 0 | 19.4969 | -99.7233 | 2021-12-29 03:21:43 | Mexico, Mexico | |||
730618 | 730618 | 2021-12-27 | Mexico | Mexico | 382312 | 44815 | 0 | 19.4969 | -99.7233 | 2021-12-28 04:21:47 | Mexico, Mexico | |||
2111790 | 2111790 | 2021-12-26 | Mexico | Mexico | 382264 | 44815 | 0 | 19.4969 | -99.7233 | 2021-12-27 04:21:58 | Mexico, Mexico | |||
3605162 | 3605162 | 2021-12-25 | Mexico | Mexico | 382264 | 44815 | 0 | 19.4969 | -99.7233 | 2021-12-26 04:21:50 | Mexico, Mexico | |||
2963480 | 2963480 | 2021-12-24 | Mexico | Mexico | 382071 | 44810 | 0 | 19.4969 | -99.7233 | 2021-12-25 04:21:37 | Mexico, Mexico | |||
3816512 | 3816512 | 2021-12-23 | Mexico | Mexico | 381659 | 44779 | 0 | 19.4969 | -99.7233 | 2021-12-24 04:21:34 | Mexico, Mexico | |||
798520 | 798520 | 2021-12-22 | Mexico | Mexico | 381460 | 44747 | 0 | 19.4969 | -99.7233 | 2021-12-23 04:21:21 | Mexico, Mexico | |||
3828560 | 3828560 | 2021-12-21 | Mexico | Mexico | 381317 | 44677 | 0 | 19.4969 | -99.7233 | 2021-12-22 04:21:54 | Mexico, Mexico | |||
1254863 | 1254863 | 2021-12-20 | Mexico | Mexico | 381317 | 44677 | 0 | 19.4969 | -99.7233 | 2021-12-21 03:21:27 | Mexico, Mexico | |||
2903806 | 2903806 | 2021-12-19 | Mexico | Mexico | 381255 | 44673 | 0 | 19.4969 | -99.7233 | 2021-12-20 04:21:43 | Mexico, Mexico | |||
1258879 | 1258879 | 2021-12-18 | Mexico | Mexico | 381127 | 44609 | 0 | 19.4969 | -99.7233 | 2021-12-19 04:21:11 | Mexico, Mexico | |||
2398907 | 2398907 | 2021-12-17 | Mexico | Mexico | 380976 | 44578 | 0 | 19.4969 | -99.7233 | 2021-12-18 02:22:20 | Mexico, Mexico | |||
1716445 | 1716445 | 2021-12-16 | Mexico | Mexico | 380976 | 44578 | 0 | 19.4969 | -99.7233 | 2021-12-17 04:22:14 | Mexico, Mexico | |||
3496279 | 3496279 | 2021-12-15 | Mexico | Mexico | 380842 | 44558 | 0 | 19.4969 | -99.7233 | 2021-12-16 04:22:11 | Mexico, Mexico | |||
2088064 | 2088064 | 2021-12-14 | Mexico | Mexico | 380556 | 44508 | 0 | 19.4969 | -99.7233 | 2021-12-15 03:22:16 | Mexico, Mexico | |||
782481 | 782481 | 2021-12-13 | Mexico | Mexico | 380473 | 44504 | 0 | 19.4969 | -99.7233 | 2021-12-14 04:22:38 | Mexico, Mexico | |||
1660516 | 1660516 | 2021-12-12 | Mexico | Mexico | 380360 | 44503 | 0 | 19.4969 | -99.7233 | 2021-12-13 04:22:02 | Mexico, Mexico | |||
1664532 | 1664532 | 2021-12-11 | Mexico | Mexico | 380234 | 44496 | 0 | 19.4969 | -99.7233 | 2021-12-12 04:22:12 | Mexico, Mexico | |||
3655684 | 3655684 | 2021-12-10 | Mexico | Mexico | 380122 | 44470 | 0 | 19.4969 | -99.7233 | 2021-12-11 04:22:45 | Mexico, Mexico | |||
1078015 | 1078015 | 2021-12-09 | Mexico | Mexico | 380122 | 44470 | 0 | 19.4969 | -99.7233 | 2021-12-10 04:22:28 | Mexico, Mexico | |||
550864 | 550864 | 2021-12-08 | Mexico | Mexico | 379834 | 44446 | 0 | 19.4969 | -99.7233 | 2021-12-09 04:22:49 | Mexico, Mexico | |||
404384 | 404384 | 2021-12-07 | Mexico | Mexico | 379714 | 44433 | 0 | 19.4969 | -99.7233 | 2021-12-08 04:22:46 | Mexico, Mexico | |||
1030466 | 1030466 | 2021-12-06 | Mexico | Mexico | 379714 | 44433 | 0 | 19.4969 | -99.7233 | 2021-12-07 04:22:34 | Mexico, Mexico | |||
1740629 | 1740629 | 2021-12-05 | Mexico | Mexico | 379674 | 44430 | 0 | 19.4969 | -99.7233 | 2021-12-06 04:22:34 | Mexico, Mexico | |||
138061 | 138061 | 2021-12-04 | Mexico | Mexico | 379477 | 44412 | 0 | 19.4969 | -99.7233 | 2021-12-05 04:22:25 | Mexico, Mexico | |||
2195714 | 2195714 | 2021-12-03 | Mexico | Mexico | 379477 | 44412 | 0 | 19.4969 | -99.7233 | 2021-12-04 04:22:18 | Mexico, Mexico | |||
420 | 420 | 2021-12-02 | Mexico | Mexico | 379161 | 44373 | 0 | 19.4969 | -99.7233 | 2021-12-03 04:23:05 | Mexico, Mexico | |||
1145019 | 1145019 | 2021-12-01 | Mexico | Mexico | 379161 | 44373 | 0 | 19.4969 | -99.7233 | 2021-12-02 04:22:37 | Mexico, Mexico | |||
3401531 | 3401531 | 2021-11-30 | Mexico | Mexico | 378889 | 44351 | 0 | 19.4969 | -99.7233 | 2021-12-01 04:22:29 | Mexico, Mexico | |||
150074 | 150074 | 2021-11-29 | Mexico | Mexico | 378889 | 44351 | 0 | 19.4969 | -99.7233 | 2021-11-30 04:22:53 | Mexico, Mexico | |||
1231720 | 1231720 | 2021-11-28 | Mexico | Mexico | 378745 | 44344 | 0 | 19.4969 | -99.7233 | 2021-11-29 04:22:30 | Mexico, Mexico | |||
1358427 | 1358427 | 2021-11-27 | Mexico | Mexico | 378627 | 44328 | 0 | 19.4969 | -99.7233 | 2021-11-28 04:22:43 | Mexico, Mexico | |||
758418 | 758418 | 2021-11-26 | Mexico | Mexico | 378627 | 44328 | 0 | 19.4969 | -99.7233 | 2021-11-27 04:22:45 | Mexico, Mexico | |||
1802835 | 1802835 | 2021-11-25 | Mexico | Mexico | 378402 | 44318 | 0 | 19.4969 | -99.7233 | 2021-11-26 04:22:33 | Mexico, Mexico | |||
904269 | 904269 | 2021-11-24 | Mexico | Mexico | 377949 | 44288 | 0 | 19.4969 | -99.7233 | 2021-11-25 04:22:33 | Mexico, Mexico | |||
3070119 | 3070119 | 2021-11-23 | Mexico | Mexico | 377780 | 44270 | 0 | 19.4969 | -99.7233 | 2021-11-24 04:22:14 | Mexico, Mexico | |||
3749217 | 3749217 | 2021-11-22 | Mexico | Mexico | 377780 | 44270 | 0 | 19.4969 | -99.7233 | 2021-11-23 04:22:39 | Mexico, Mexico | |||
1014424 | 1014424 | 2021-11-21 | Mexico | Mexico | 377543 | 44256 | 0 | 19.4969 | -99.7233 | 2021-11-22 04:22:20 | Mexico, Mexico | |||
722588 | 722588 | 2021-11-20 | Mexico | Mexico | 377398 | 44232 | 0 | 19.4969 | -99.7233 | 2021-11-21 04:22:13 | Mexico, Mexico | |||
162118 | 162118 | 2021-11-19 | Mexico | Mexico | 377251 | 44219 | 0 | 19.4969 | -99.7233 | 2021-11-20 04:22:17 | Mexico, Mexico | |||
3289005 | 3289005 | 2021-11-18 | Mexico | Mexico | 377251 | 44219 | 0 | 19.4969 | -99.7233 | 2021-11-19 04:21:40 | Mexico, Mexico | |||
447461 | 447461 | 2021-11-17 | Mexico | Mexico | 377001 | 44187 | 0 | 19.4969 | -99.7233 | 2021-11-18 04:21:33 | Mexico, Mexico | |||
3342711 | 3342711 | 2021-11-16 | Mexico | Mexico | 376696 | 44131 | 0 | 19.4969 | -99.7233 | 2021-11-17 04:21:48 | Mexico, Mexico | |||
2287547 | 2287547 | 2021-11-15 | Mexico | Mexico | 376632 | 44124 | 0 | 19.4969 | -99.7233 | 2021-11-16 04:21:10 | Mexico, Mexico | |||
1322321 | 1322321 | 2021-11-14 | Mexico | Mexico | 376573 | 44117 | 0 | 19.4969 | -99.7233 | 2021-11-15 04:21:36 | Mexico, Mexico | |||
686447 | 686447 | 2021-11-13 | Mexico | Mexico | 376397 | 44101 | 0 | 19.4969 | -99.7233 | 2021-11-14 04:21:31 | Mexico, Mexico | |||
714556 | 714556 | 2021-11-12 | Mexico | Mexico | 376227 | 44080 | 0 | 19.4969 | -99.7233 | 2021-11-13 04:21:38 | Mexico, Mexico | |||
28506 | 28506 | 2021-11-11 | Mexico | Mexico | 376227 | 44080 | 0 | 19.4969 | -99.7233 | 2021-11-12 04:22:01 | Mexico, Mexico | |||
2844945 | 2844945 | 2021-11-10 | Mexico | Mexico | 375816 | 44040 | 0 | 19.4969 | -99.7233 | 2021-11-11 04:21:45 | Mexico, Mexico | |||
87215 | 87215 | 2021-11-09 | Mexico | Mexico | 375816 | 44040 | 0 | 19.4969 | -99.7233 | 2021-11-10 04:21:38 | Mexico, Mexico | |||
3639643 | 3639643 | 2021-11-08 | Mexico | Mexico | 375577 | 44017 | 0 | 19.4969 | -99.7233 | 2021-11-09 04:21:36 | Mexico, Mexico | |||
2000751 | 2000751 | 2021-11-07 | Mexico | Mexico | 375577 | 44017 | 0 | 19.4969 | -99.7233 | 2021-11-08 04:21:43 | Mexico, Mexico | |||
495742 | 495742 | 2021-11-06 | Mexico | Mexico | 375464 | 44011 | 0 | 19.4969 | -99.7233 | 2021-11-07 04:21:53 | Mexico, Mexico | |||
3121597 | 3121597 | 2021-11-05 | Mexico | Mexico | 374952 | 43977 | 0 | 19.4969 | -99.7233 | 2021-11-06 04:21:51 | Mexico, Mexico | |||
698495 | 698495 | 2021-11-04 | Mexico | Mexico | 374655 | 43952 | 0 | 19.4969 | -99.7233 | 2021-11-05 04:21:54 | Mexico, Mexico | |||
276273 | 276273 | 2021-11-03 | Mexico | Mexico | 374397 | 43941 | 0 | 19.4969 | -99.7233 | 2021-11-04 04:22:20 | Mexico, Mexico | |||
43798 | 43798 | 2021-11-02 | Mexico | Mexico | 374157 | 43910 | 0 | 19.4969 | -99.7233 | 2021-11-03 06:22:09 | Mexico, Mexico | |||
3511494 | 3511494 | 2021-11-01 | Mexico | Mexico | 374088 | 43899 | 0 | 19.4969 | -99.7233 | 2021-11-02 04:22:03 | Mexico, Mexico | |||
288086 | 288086 | 2021-10-31 | Mexico | Mexico | 374088 | 43899 | 0 | 19.4969 | -99.7233 | 2021-11-01 04:22:01 | Mexico, Mexico | |||
2721092 | 2721092 | 2021-10-30 | Mexico | Mexico | 373942 | 43894 | 0 | 19.4969 | -99.7233 | 2021-10-31 04:22:08 | Mexico, Mexico | |||
567194 | 567194 | 2021-10-29 | Mexico | Mexico | 373715 | 43847 | 0 | 19.4969 | -99.7233 | 2021-10-30 04:22:03 | Mexico, Mexico | |||
4436 | 4436 | 2021-10-28 | Mexico | Mexico | 373484 | 43821 | 0 | 19.4969 | -99.7233 | 2021-10-29 04:22:03 | Mexico, Mexico | |||
534826 | 534826 | 2021-10-27 | Mexico | Mexico | 372888 | 43757 | 0 | 19.4969 | -99.7233 | 2021-10-28 04:22:08 | Mexico, Mexico | |||
3492263 | 3492263 | 2021-10-26 | Mexico | Mexico | 372580 | 43731 | 0 | 19.4969 | -99.7233 | 2021-10-27 04:22:32 | Mexico, Mexico | |||
3793985 | 3793985 | 2021-10-25 | Mexico | Mexico | 372580 | 43731 | 0 | 19.4969 | -99.7233 | 2021-10-26 04:22:09 | Mexico, Mexico | |||
682431 | 682431 | 2021-10-24 | Mexico | Mexico | 372355 | 43673 | 0 | 19.4969 | -99.7233 | 2021-10-25 04:22:31 | Mexico, Mexico | |||
770439 | 770439 | 2021-10-23 | Mexico | Mexico | 372355 | 43673 | 0 | 19.4969 | -99.7233 | 2021-10-24 04:21:22 | Mexico, Mexico | |||
654086 | 654086 | 2021-10-22 | Mexico | Mexico | 372079 | 43635 | 0 | 19.4969 | -99.7233 | 2021-10-23 04:21:32 | Mexico, Mexico | |||
2123833 | 2123833 | 2021-10-21 | Mexico | Mexico | 371762 | 43622 | 0 | 19.4969 | -99.7233 | 2021-10-22 04:21:14 | Mexico, Mexico | |||
443445 | 443445 | 2021-10-20 | Mexico | Mexico | 371418 | 43605 | 0 | 19.4969 | -99.7233 | 2021-10-21 04:21:18 | Mexico, Mexico | |||
597764 | 597764 | 2021-10-19 | Mexico | Mexico | 371129 | 43584 | 0 | 19.4969 | -99.7233 | 2021-10-20 04:21:00 | Mexico, Mexico | |||
2043941 | 2043941 | 2021-10-18 | Mexico | Mexico | 370671 | 43536 | 0 | 19.4969 | -99.7233 | 2021-10-19 04:20:54 | Mexico, Mexico | |||
1909302 | 1909302 | 2021-10-17 | Mexico | Mexico | 370598 | 43527 | 0 | 19.4969 | -99.7233 | 2021-10-18 04:21:10 | Mexico, Mexico | |||
934891 | 934891 | 2021-10-16 | Mexico | Mexico | 370460 | 43534 | 0 | 19.4969 | -99.7233 | 2021-10-17 04:21:29 | Mexico, Mexico | |||
2943446 | 2943446 | 2021-10-15 | Mexico | Mexico | 369995 | 43520 | 0 | 19.4969 | -99.7233 | 2021-10-16 04:21:15 | Mexico, Mexico | |||
491726 | 491726 | 2021-10-14 | Mexico | Mexico | 369465 | 43492 | 0 | 19.4969 | -99.7233 | 2021-10-15 04:21:26 | Mexico, Mexico | |||
634014 | 634014 | 2021-10-13 | Mexico | Mexico | 368845 | 43439 | 0 | 19.4969 | -99.7233 | 2021-10-14 04:21:29 | Mexico, Mexico | |||
1491692 | 1491692 | 2021-10-12 | Mexico | Mexico | 368273 | 43412 | 0 | 19.4969 | -99.7233 | 2021-10-13 04:20:51 | Mexico, Mexico | |||
3007425 | 3007425 | 2021-10-11 | Mexico | Mexico | 367552 | 43335 | 0 | 19.4969 | -99.7233 | 2021-10-12 04:21:09 | Mexico, Mexico | |||
423441 | 423441 | 2021-10-10 | Mexico | Mexico | 367426 | 43327 | 0 | 19.4969 | -99.7233 | 2021-10-11 04:21:31 | Mexico, Mexico | |||
2876298 | 2876298 | 2021-10-09 | Mexico | Mexico | 366831 | 43288 | 0 | 19.4969 | -99.7233 | 2021-10-10 04:21:38 | Mexico, Mexico | |||
2959464 | 2959464 | 2021-10-08 | Mexico | Mexico | 366831 | 43288 | 0 | 19.4969 | -99.7233 | 2021-10-09 04:21:34 | Mexico, Mexico | |||
467502 | 467502 | 2021-10-07 | Mexico | Mexico | 366045 | 43241 | 0 | 19.4969 | -99.7233 | 2021-10-08 04:21:25 | Mexico, Mexico | |||
2458882 | 2458882 | 2021-10-06 | Mexico | Mexico | 364588 | 43063 | 0 | 19.4969 | -99.7233 | 2021-10-07 04:21:36 | Mexico, Mexico | |||
3832576 | 3832576 | 2021-10-05 | Mexico | Mexico | 363937 | 42904 | 0 | 19.4969 | -99.7233 | 2021-10-06 04:21:33 | Mexico, Mexico | |||
987069 | 987069 | 2021-10-04 | Mexico | Mexico | 363937 | 42904 | 0 | 19.4969 | -99.7233 | 2021-10-05 04:21:27 | Mexico, Mexico | |||
1274379 | 1274379 | 2021-10-03 | Mexico | Mexico | 363489 | 42748 | 0 | 19.4969 | -99.7233 | 2021-10-04 04:21:31 | 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]);