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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
3928132 | 3928132 | 2021-10-02 | Mexico | Mexico | 363489 | 42748 | 0 | 19.4969 | -99.7233 | 2021-10-03 04:21:24 | Mexico, Mexico | |||
2132112 | 2132112 | 2021-10-01 | Mexico | Mexico | 362908 | 42617 | 0 | 19.4969 | -99.7233 | 2021-10-02 04:21:25 | Mexico, Mexico | |||
2773069 | 2773069 | 2021-09-30 | Mexico | Mexico | 362226 | 42534 | 0 | 19.4969 | -99.7233 | 2021-10-01 04:21:35 | Mexico, Mexico | |||
706525 | 706525 | 2021-09-29 | Mexico | Mexico | 361544 | 42481 | 0 | 19.4969 | -99.7233 | 2021-09-30 04:21:20 | Mexico, Mexico | |||
1334367 | 1334367 | 2021-09-28 | Mexico | Mexico | 360605 | 42438 | 0 | 19.4969 | -99.7233 | 2021-09-29 04:21:45 | Mexico, Mexico | |||
1235736 | 1235736 | 2021-09-27 | Mexico | Mexico | 359728 | 42389 | 0 | 19.4969 | -99.7233 | 2021-09-28 04:21:28 | Mexico, Mexico | |||
2076037 | 2076037 | 2021-09-26 | Mexico | Mexico | 359427 | 42360 | 0 | 19.4969 | -99.7233 | 2021-09-27 04:21:16 | Mexico, Mexico | |||
1724589 | 1724589 | 2021-09-25 | Mexico | Mexico | 358284 | 42286 | 0 | 19.4969 | -99.7233 | 2021-09-26 04:21:29 | Mexico, Mexico | |||
1921309 | 1921309 | 2021-09-24 | Mexico | Mexico | 358284 | 42286 | 0 | 19.4969 | -99.7233 | 2021-09-25 04:21:31 | Mexico, Mexico | |||
601780 | 601780 | 2021-09-23 | Mexico | Mexico | 357403 | 42236 | 0 | 19.4969 | -99.7233 | 2021-09-24 04:21:44 | Mexico, Mexico | |||
3011424 | 3011424 | 2021-09-22 | Mexico | Mexico | 356361 | 42159 | 0 | 19.4969 | -99.7233 | 2021-09-23 04:21:43 | Mexico, Mexico | |||
3757562 | 3757562 | 2021-09-21 | Mexico | Mexico | 355193 | 42088 | 0 | 19.4969 | -99.7233 | 2021-09-22 04:21:45 | Mexico, Mexico | |||
809665 | 809665 | 2021-09-20 | Mexico | Mexico | 353951 | 42018 | 0 | 19.4969 | -99.7233 | 2021-09-21 04:21:26 | Mexico, Mexico | |||
1814864 | 1814864 | 2021-09-19 | Mexico | Mexico | 353717 | 42004 | 0 | 19.4969 | -99.7233 | 2021-09-20 04:21:22 | Mexico, Mexico | |||
16444 | 16444 | 2021-09-18 | Mexico | Mexico | 352178 | 41924 | 0 | 19.4969 | -99.7233 | 2021-09-19 04:21:34 | Mexico, Mexico | |||
2618129 | 2618129 | 2021-09-17 | Mexico | Mexico | 352178 | 41924 | 0 | 19.4969 | -99.7233 | 2021-09-18 04:21:24 | Mexico, Mexico | |||
2808837 | 2808837 | 2021-09-16 | Mexico | Mexico | 351710 | 41915 | 0 | 19.4969 | -99.7233 | 2021-09-17 04:21:46 | Mexico, Mexico | |||
1374582 | 1374582 | 2021-09-15 | Mexico | Mexico | 351341 | 41868 | 0 | 19.4969 | -99.7233 | 2021-09-16 04:22:19 | Mexico, Mexico | |||
2462881 | 2462881 | 2021-09-14 | Mexico | Mexico | 350144 | 41776 | 0 | 19.4969 | -99.7233 | 2021-09-15 03:22:37 | Mexico, Mexico | |||
1385720 | 1385720 | 2021-09-13 | Mexico | Mexico | 348819 | 41698 | 0 | 19.4969 | -99.7233 | 2021-09-14 04:21:41 | Mexico, Mexico | |||
1885089 | 1885089 | 2021-09-12 | Mexico | Mexico | 348617 | 41671 | 0 | 19.4969 | -99.7233 | 2021-09-13 04:21:15 | Mexico, Mexico | |||
3805992 | 3805992 | 2021-09-11 | Mexico | Mexico | 348366 | 41652 | 0 | 19.4969 | -99.7233 | 2021-09-12 04:21:13 | Mexico, Mexico | |||
3448932 | 3448932 | 2021-09-10 | Mexico | Mexico | 346178 | 41530 | 0 | 19.4969 | -99.7233 | 2021-09-11 04:21:30 | Mexico, Mexico | |||
1262878 | 1262878 | 2021-09-09 | Mexico | Mexico | 346178 | 41530 | 0 | 19.4969 | -99.7233 | 2021-09-10 04:21:20 | Mexico, Mexico | |||
2279248 | 2279248 | 2021-09-08 | Mexico | Mexico | 344980 | 41447 | 0 | 19.4969 | -99.7233 | 2021-09-09 04:21:27 | Mexico, Mexico | |||
642027 | 642027 | 2021-09-07 | Mexico | Mexico | 343672 | 41345 | 0 | 19.4969 | -99.7233 | 2021-09-08 04:21:31 | Mexico, Mexico | |||
3194090 | 3194090 | 2021-09-06 | Mexico | Mexico | 342383 | 41230 | 0 | 19.4969 | -99.7233 | 2021-09-07 04:21:35 | Mexico, Mexico | |||
3280958 | 3280958 | 2021-09-05 | Mexico | Mexico | 342096 | 41200 | 0 | 19.4969 | -99.7233 | 2021-09-06 04:21:22 | Mexico, Mexico | |||
249372 | 249372 | 2021-09-04 | Mexico | Mexico | 341759 | 41169 | 0 | 19.4969 | -99.7233 | 2021-09-05 04:21:33 | Mexico, Mexico | |||
3974653 | 3974653 | 2021-09-03 | Mexico | Mexico | 340608 | 41098 | 0 | 19.4969 | -99.7233 | 2021-09-04 04:21:28 | Mexico, Mexico | |||
178115 | 178115 | 2021-09-02 | Mexico | Mexico | 339258 | 41026 | 0 | 19.4969 | -99.7233 | 2021-09-03 04:21:20 | Mexico, Mexico | |||
67150 | 67150 | 2021-09-01 | Mexico | Mexico | 337715 | 40927 | 0 | 19.4969 | -99.7233 | 2021-09-02 04:21:15 | Mexico, Mexico | |||
2067992 | 2067992 | 2021-08-31 | Mexico | Mexico | 336402 | 40819 | 0 | 19.4969 | -99.7233 | 2021-09-01 04:21:38 | Mexico, Mexico | |||
1775446 | 1775446 | 2021-08-30 | Mexico | Mexico | 335654 | 40719 | 0 | 19.4969 | -99.7233 | 2021-08-31 04:21:46 | Mexico, Mexico | |||
3892020 | 3892020 | 2021-08-29 | Mexico | Mexico | 335436 | 40668 | 0 | 19.4969 | -99.7233 | 2021-08-30 04:21:23 | Mexico, Mexico | |||
2793123 | 2793123 | 2021-08-28 | Mexico | Mexico | 335058 | 40627 | 0 | 19.4969 | -99.7233 | 2021-08-29 04:21:14 | Mexico, Mexico | |||
2923282 | 2923282 | 2021-08-27 | Mexico | Mexico | 333488 | 40538 | 0 | 19.4969 | -99.7233 | 2021-08-28 04:21:28 | Mexico, Mexico | |||
1596296 | 1596296 | 2021-08-26 | Mexico | Mexico | 331980 | 40435 | 0 | 19.4969 | -99.7233 | 2021-08-27 04:21:37 | Mexico, Mexico | |||
32505 | 32505 | 2021-08-25 | Mexico | Mexico | 330242 | 40312 | 0 | 19.4969 | -99.7233 | 2021-08-26 04:21:28 | Mexico, Mexico | |||
3105544 | 3105544 | 2021-08-24 | Mexico | Mexico | 328336 | 40196 | 0 | 19.4969 | -99.7233 | 2021-08-25 04:21:41 | Mexico, Mexico | |||
3165715 | 3165715 | 2021-08-23 | Mexico | Mexico | 326857 | 40073 | 0 | 19.4969 | -99.7233 | 2021-08-24 04:21:19 | Mexico, Mexico | |||
2175642 | 2175642 | 2021-08-22 | Mexico | Mexico | 326509 | 40033 | 0 | 19.4969 | -99.7233 | 2021-08-23 04:21:27 | Mexico, Mexico | |||
3555738 | 3555738 | 2021-08-21 | Mexico | Mexico | 326070 | 40008 | 0 | 19.4969 | -99.7233 | 2021-08-22 04:21:29 | Mexico, Mexico | |||
1854080 | 1854080 | 2021-08-20 | Mexico | Mexico | 324281 | 39924 | 0 | 19.4969 | -99.7233 | 2021-08-21 04:21:38 | Mexico, Mexico | |||
511787 | 511787 | 2021-08-19 | Mexico | Mexico | 322459 | 39798 | 0 | 19.4969 | -99.7233 | 2021-08-20 04:21:33 | Mexico, Mexico | |||
2518266 | 2518266 | 2021-08-18 | Mexico | Mexico | 320511 | 39662 | 0 | 19.4969 | -99.7233 | 2021-08-19 04:21:15 | Mexico, Mexico | |||
245358 | 245358 | 2021-08-17 | Mexico | Mexico | 317821 | 39527 | 0 | 19.4969 | -99.7233 | 2021-08-18 04:21:35 | Mexico, Mexico | |||
1604321 | 1604321 | 2021-08-16 | Mexico | Mexico | 316549 | 39436 | 0 | 19.4969 | -99.7233 | 2021-08-17 04:21:49 | 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]);