daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31,389 rows where country_or_region = "Mexico" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
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
- …
country_or_region 1
- Mexico · 31,389 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
2020-03-07 | Mexico | 6 | 0 | 1 | 23.0 | -102.0 | 2020-03-06T16:43:04 | |||||
2020-03-04 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
2020-03-03 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
2020-03-21 | Mexico | 203 | 2 | 4 | 23.6345 | -102.5528 | 2020-03-21T12:13:19 | |||||
2020-03-01 | Mexico | 5 | 0 | 0 | 23.0 | -102.0 | 2020-03-01T23:33:03 | |||||
2020-03-09 | Mexico | 7 | 0 | 1 | 23.0 | -102.0 | 2020-03-08T05:13:06 | |||||
2020-01-23 | Mexico | 0 | 0 | 0 | 1/23/20 17:00 | |||||||
2020-03-02 | Mexico | 5 | 0 | 0 | 23.0 | -102.0 | 2020-03-01T23:33:03 | |||||
2020-03-18 | Mexico | 93 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-18T10:53:02 | |||||
2020-03-15 | Mexico | 41 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-15T18:20:18 | |||||
2020-03-19 | Mexico | 118 | 1 | 4 | 23.6345 | -102.5528 | 2020-03-19T10:53:03 | |||||
2020-03-08 | Mexico | 7 | 0 | 1 | 23.0 | -102.0 | 2020-03-08T05:13:06 | |||||
2020-03-14 | Mexico | 26 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-14T20:53:02 | |||||
2020-03-11 | Mexico | 8 | 0 | 4 | 23.0 | -102.0 | 2020-03-11T21:13:24 | |||||
2020-03-16 | Mexico | 53 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-16T14:38:45 | |||||
2020-03-12 | Mexico | 12 | 0 | 4 | 23.0 | -102.0 | 2020-03-12T05:13:03 | |||||
2020-02-28 | Mexico | 1 | 0 | 0 | 2020-02-28T15:03:26 | |||||||
2020-03-06 | Mexico | 6 | 0 | 1 | 23.0 | -102.0 | 2020-03-06T16:43:04 | |||||
2020-02-29 | Mexico | 4 | 0 | 0 | 2020-02-29T21:13:17 | |||||||
2020-03-20 | Mexico | 164 | 1 | 4 | 23.6345 | -102.5528 | 2020-03-20T14:13:08 | |||||
2020-03-10 | Mexico | 7 | 0 | 4 | 23.0 | -102.0 | 2020-03-10T05:13:07 | |||||
2020-03-13 | Mexico | 12 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-11T20:00:00 | |||||
2020-03-17 | Mexico | 82 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-17T10:53:03 | |||||
2021-12-02 | Mexico | Aguascalientes | 37220 | 2941 | 0 | 21.8853 | -102.2916 | 2021-12-03 04:23:05 | Aguascalientes, Mexico | |||
2021-10-28 | Mexico | Aguascalientes | 35722 | 2853 | 0 | 21.8853 | -102.2916 | 2021-10-29 04:22:03 | Aguascalientes, Mexico | |||
2020-10-25 | Mexico | Aguascalientes | 9040 | 810 | 7310 | 920 | 21.8853 | -102.2916 | 2020-10-26 04:25:02 | Aguascalientes, Mexico | ||
2021-01-26 | Mexico | Aguascalientes | 20172 | 1624 | 0 | 18548 | 21.8853 | -102.2916 | 2021-01-27 05:23:41 | Aguascalientes, Mexico | ||
2021-09-18 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-19 04:21:34 | Aguascalientes, Mexico | |||
2021-05-28 | Mexico | Aguascalientes | 26492 | 2418 | 0 | 24074 | 21.8853 | -102.2916 | 2021-05-29 04:20:41 | Aguascalientes, Mexico | ||
2022-03-20 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-21 04:20:50 | Aguascalientes, Mexico | |||
2021-11-11 | Mexico | Aguascalientes | 36280 | 2891 | 0 | 21.8853 | -102.2916 | 2021-11-12 04:22:01 | Aguascalientes, Mexico | |||
2021-08-25 | Mexico | Aguascalientes | 30389 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-26 04:21:28 | Aguascalientes, Mexico | |||
2021-04-12 | Mexico | Aguascalientes | 25353 | 2273 | 0 | 23080 | 21.8853 | -102.2916 | 2021-04-13 04:20:37 | Aguascalientes, Mexico | ||
2021-11-02 | Mexico | Aguascalientes | 35846 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-03 06:22:09 | Aguascalientes, Mexico | |||
2021-05-29 | Mexico | Aguascalientes | 26501 | 2418 | 0 | 24083 | 21.8853 | -102.2916 | 2021-05-30 04:20:55 | Aguascalientes, Mexico | ||
2021-03-07 | Mexico | Aguascalientes | 23462 | 2035 | 0 | 21427 | 21.8853 | -102.2916 | 2021-03-08 05:24:48 | Aguascalientes, Mexico | ||
2020-07-23 | Mexico | Aguascalientes | 3620 | 224 | 2889 | 507 | 21.8853 | -102.2916 | 2020-07-24 03:34:53 | Aguascalientes, Mexico | ||
2022-11-12 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-13 04:21:14 | Aguascalientes, Mexico | |||
2021-09-01 | Mexico | Aguascalientes | 31186 | 2611 | 0 | 21.8853 | -102.2916 | 2021-09-02 04:21:15 | Aguascalientes, Mexico | |||
2022-02-07 | Mexico | Aguascalientes | 53290 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-08 04:21:15 | Aguascalientes, Mexico | |||
2020-12-03 | Mexico | Aguascalientes | 14083 | 1123 | 0 | 12960 | 21.8853 | -102.2916 | 2020-12-04 05:27:27 | Aguascalientes, Mexico | ||
2020-10-14 | Mexico | Aguascalientes | 8054 | 725 | 6741 | 588 | 21.8853 | -102.2916 | 2020-10-15 04:24:28 | Aguascalientes, Mexico | ||
2021-05-25 | Mexico | Aguascalientes | 26454 | 2409 | 0 | 24045 | 21.8853 | -102.2916 | 2021-05-26 04:20:35 | Aguascalientes, Mexico | ||
2021-11-09 | Mexico | Aguascalientes | 36148 | 2888 | 0 | 21.8853 | -102.2916 | 2021-11-10 04:21:38 | Aguascalientes, Mexico | |||
2022-07-23 | Mexico | Aguascalientes | 77059 | 3526 | 0 | 21.8853 | -102.2916 | 2022-07-24 04:20:47 | Aguascalientes, Mexico | |||
2020-08-04 | Mexico | Aguascalientes | 4229 | 269 | 3600 | 360 | 21.8853 | -102.2916 | 2020-08-05 04:34:43 | Aguascalientes, Mexico | ||
2022-01-14 | Mexico | Aguascalientes | 42387 | 3070 | 0 | 21.8853 | -102.2916 | 2022-01-15 04:21:07 | Aguascalientes, Mexico | |||
2021-08-15 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-16 04:21:31 | Aguascalientes, Mexico | |||
2021-06-19 | Mexico | Aguascalientes | 26688 | 2456 | 0 | 24232 | 21.8853 | -102.2916 | 2021-06-20 04:21:48 | Aguascalientes, Mexico | ||
2022-09-06 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-07 04:20:59 | Aguascalientes, Mexico | |||
2020-07-19 | Mexico | Aguascalientes | 3417 | 207 | 2654 | 556 | 21.8853 | -102.2916 | 2020-07-20 05:34:40 | Aguascalientes, Mexico | ||
2020-11-18 | Mexico | Aguascalientes | 11235 | 962 | 0 | 10273 | 21.8853 | -102.2916 | 2020-11-19 05:25:23 | Aguascalientes, Mexico | ||
2022-01-09 | Mexico | Aguascalientes | 41186 | 3048 | 0 | 21.8853 | -102.2916 | 2022-01-10 04:22:07 | Aguascalientes, Mexico | |||
2022-10-04 | Mexico | Aguascalientes | 84529 | 3585 | 0 | 21.8853 | -102.2916 | 2022-10-05 04:23:06 | Aguascalientes, Mexico | |||
2021-12-04 | Mexico | Aguascalientes | 37363 | 2946 | 0 | 21.8853 | -102.2916 | 2021-12-05 04:22:25 | Aguascalientes, Mexico | |||
2022-07-09 | Mexico | Aguascalientes | 72104 | 3522 | 0 | 21.8853 | -102.2916 | 2022-07-10 04:20:54 | Aguascalientes, Mexico | |||
2020-08-15 | Mexico | Aguascalientes | 4771 | 324 | 4087 | 360 | 21.8853 | -102.2916 | 2020-08-16 04:27:42 | Aguascalientes, Mexico | ||
2021-11-29 | Mexico | Aguascalientes | 37083 | 2929 | 0 | 21.8853 | -102.2916 | 2021-11-30 04:22:53 | Aguascalientes, Mexico | |||
2021-01-08 | Mexico | Aguascalientes | 17612 | 1428 | 0 | 16184 | 21.8853 | -102.2916 | 2021-01-09 05:22:18 | Aguascalientes, Mexico | ||
2022-03-29 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-30 04:20:45 | Aguascalientes, Mexico | |||
2021-11-19 | Mexico | Aguascalientes | 36579 | 2902 | 0 | 21.8853 | -102.2916 | 2021-11-20 04:22:17 | Aguascalientes, Mexico | |||
2022-06-21 | Mexico | Aguascalientes | 68954 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-22 04:20:54 | Aguascalientes, Mexico | |||
2021-04-16 | Mexico | Aguascalientes | 25605 | 2309 | 0 | 23296 | 21.8853 | -102.2916 | 2021-04-17 04:20:40 | Aguascalientes, Mexico | ||
2020-07-27 | Mexico | Aguascalientes | 3777 | 243 | 3122 | 412 | 21.8853 | -102.2916 | 2020-07-28 04:58:43 | Aguascalientes, Mexico | ||
2021-09-02 | Mexico | Aguascalientes | 31341 | 2621 | 0 | 21.8853 | -102.2916 | 2021-09-03 04:21:20 | Aguascalientes, Mexico | |||
2021-02-21 | Mexico | Aguascalientes | 22621 | 1950 | 0 | 20671 | 21.8853 | -102.2916 | 2021-02-22 05:24:21 | Aguascalientes, Mexico | ||
2022-02-13 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-14 04:20:51 | Aguascalientes, Mexico | |||
2021-01-11 | Mexico | Aguascalientes | 17752 | 1447 | 0 | 16305 | 21.8853 | -102.2916 | 2021-01-12 05:22:15 | Aguascalientes, Mexico | ||
2020-08-31 | Mexico | Aguascalientes | 5631 | 405 | 4847 | 379 | 21.8853 | -102.2916 | 2020-09-01 04:28:31 | Aguascalientes, Mexico | ||
2022-10-19 | Mexico | Aguascalientes | 84615 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-20 04:22:59 | Aguascalientes, Mexico | |||
2020-12-25 | Mexico | Aguascalientes | 16499 | 1330 | 0 | 15169 | 21.8853 | -102.2916 | 2020-12-26 05:22:28 | Aguascalientes, Mexico | ||
2020-08-19 | Mexico | Aguascalientes | 4928 | 347 | 4206 | 375 | 21.8853 | -102.2916 | 2020-08-20 04:27:43 | Aguascalientes, Mexico | ||
2020-10-29 | Mexico | Aguascalientes | 9450 | 842 | 7719 | 889 | 21.8853 | -102.2916 | 2020-10-30 04:24:49 | Aguascalientes, Mexico | ||
2020-06-08 | Mexico | Aguascalientes | 1160 | 53 | 792 | 315 | 21.8853 | -102.2916 | 2020-06-09 03:33:03 | Aguascalientes, Mexico | ||
2022-12-26 | Mexico | Aguascalientes | 85637 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-27 04:21:07 | Aguascalientes, Mexico | |||
2022-05-09 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-10 04:20:50 | Aguascalientes, Mexico | |||
2022-05-31 | Mexico | Aguascalientes | 67535 | 3509 | 0 | 21.8853 | -102.2916 | 2022-06-01 04:20:55 | Aguascalientes, Mexico | |||
2022-02-11 | Mexico | Aguascalientes | 54439 | 3334 | 0 | 21.8853 | -102.2916 | 2022-02-12 04:21:06 | Aguascalientes, Mexico | |||
2021-01-18 | Mexico | Aguascalientes | 18519 | 1498 | 0 | 17021 | 21.8853 | -102.2916 | 2021-01-19 05:22:15 | Aguascalientes, Mexico | ||
2021-04-02 | Mexico | Aguascalientes | 24936 | 2162 | 0 | 22774 | 21.8853 | -102.2916 | 2021-04-03 04:20:44 | Aguascalientes, Mexico | ||
2021-08-17 | Mexico | Aguascalientes | 29348 | 2534 | 0 | 21.8853 | -102.2916 | 2021-08-18 04:21:35 | Aguascalientes, Mexico | |||
2021-09-04 | Mexico | Aguascalientes | 31675 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-05 04:21:33 | Aguascalientes, Mexico | |||
2022-09-08 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-09 04:21:11 | Aguascalientes, Mexico | |||
2022-12-10 | Mexico | Aguascalientes | 84925 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-11 04:20:50 | Aguascalientes, Mexico | |||
2022-03-15 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-16 04:20:50 | Aguascalientes, Mexico | |||
2020-05-21 | Mexico | Aguascalientes | 586 | 21 | 402 | 163 | 21.8853 | -102.2916 | 2020-05-22 02:36:51 | Aguascalientes, Mexico | ||
2020-11-10 | Mexico | Aguascalientes | 10866 | 902 | 8450 | 1514 | 21.8853 | -102.2916 | 2020-11-11 05:25:30 | Aguascalientes, Mexico | ||
2021-11-03 | Mexico | Aguascalientes | 35896 | 2876 | 0 | 21.8853 | -102.2916 | 2021-11-04 04:22:20 | Aguascalientes, Mexico | |||
2021-02-24 | Mexico | Aguascalientes | 22870 | 1984 | 0 | 20886 | 21.8853 | -102.2916 | 2021-02-25 05:24:57 | Aguascalientes, Mexico | ||
2020-06-15 | Mexico | Aguascalientes | 1467 | 71 | 1078 | 318 | 21.8853 | -102.2916 | 2020-06-16 04:33:09 | Aguascalientes, Mexico | ||
2021-10-31 | Mexico | Aguascalientes | 35837 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-01 04:22:01 | Aguascalientes, Mexico | |||
2022-11-15 | Mexico | Aguascalientes | 84638 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-16 04:21:09 | Aguascalientes, Mexico | |||
2021-07-15 | Mexico | Aguascalientes | 27011 | 2478 | 0 | 24533 | 21.8853 | -102.2916 | 2021-07-16 04:21:22 | Aguascalientes, Mexico | ||
2020-07-01 | Mexico | Aguascalientes | 2363 | 151 | 1877 | 335 | 21.8853 | -102.2916 | 2020-07-02 04:33:46 | Aguascalientes, Mexico | ||
2022-04-16 | Mexico | Aguascalientes | 65451 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-17 04:20:59 | Aguascalientes, Mexico | |||
2022-12-13 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-14 04:21:04 | Aguascalientes, Mexico | |||
2022-11-13 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-14 04:21:09 | Aguascalientes, Mexico | |||
2022-02-12 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-13 04:21:00 | Aguascalientes, Mexico | |||
2022-10-30 | Mexico | Aguascalientes | 84545 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-31 04:21:36 | Aguascalientes, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;