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 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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40217 | 40217 | 2020-03-05 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
62567 | 62567 | 2020-03-07 | Mexico | 6 | 0 | 1 | 23.0 | -102.0 | 2020-03-06T16:43:04 | |||||
98884 | 98884 | 2020-03-04 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
261094 | 261094 | 2020-03-03 | Mexico | 5 | 0 | 1 | 23.0 | -102.0 | 2020-03-03T10:03:04 | |||||
339711 | 339711 | 2020-03-21 | Mexico | 203 | 2 | 4 | 23.6345 | -102.5528 | 2020-03-21T12:13:19 | |||||
562561 | 562561 | 2020-03-01 | Mexico | 5 | 0 | 0 | 23.0 | -102.0 | 2020-03-01T23:33:03 | |||||
657791 | 657791 | 2020-03-09 | Mexico | 7 | 0 | 1 | 23.0 | -102.0 | 2020-03-08T05:13:06 | |||||
864419 | 864419 | 2020-01-23 | Mexico | 0 | 0 | 0 | 1/23/20 17:00 | |||||||
1152705 | 1152705 | 2020-03-02 | Mexico | 5 | 0 | 0 | 23.0 | -102.0 | 2020-03-01T23:33:03 | |||||
1176974 | 1176974 | 2020-03-18 | Mexico | 93 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-18T10:53:02 | |||||
1463569 | 1463569 | 2020-03-15 | Mexico | 41 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-15T18:20:18 | |||||
1526973 | 1526973 | 2020-03-19 | Mexico | 118 | 1 | 4 | 23.6345 | -102.5528 | 2020-03-19T10:53:03 | |||||
1527304 | 1527304 | 2020-03-08 | Mexico | 7 | 0 | 1 | 23.0 | -102.0 | 2020-03-08T05:13:06 | |||||
2111205 | 2111205 | 2020-03-14 | Mexico | 26 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-14T20:53:02 | |||||
2127559 | 2127559 | 2020-03-11 | Mexico | 8 | 0 | 4 | 23.0 | -102.0 | 2020-03-11T21:13:24 | |||||
2255219 | 2255219 | 2020-03-16 | Mexico | 53 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-16T14:38:45 | |||||
2282980 | 2282980 | 2020-03-12 | Mexico | 12 | 0 | 4 | 23.0 | -102.0 | 2020-03-12T05:13:03 | |||||
2883998 | 2883998 | 2020-02-28 | Mexico | 1 | 0 | 0 | 2020-02-28T15:03:26 | |||||||
3177568 | 3177568 | 2020-03-06 | Mexico | 6 | 0 | 1 | 23.0 | -102.0 | 2020-03-06T16:43:04 | |||||
3205848 | 3205848 | 2020-02-29 | Mexico | 4 | 0 | 0 | 2020-02-29T21:13:17 | |||||||
3734009 | 3734009 | 2020-03-20 | Mexico | 164 | 1 | 4 | 23.6345 | -102.5528 | 2020-03-20T14:13:08 | |||||
3752930 | 3752930 | 2020-03-10 | Mexico | 7 | 0 | 4 | 23.0 | -102.0 | 2020-03-10T05:13:07 | |||||
3765442 | 3765442 | 2020-03-13 | Mexico | 12 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-11T20:00:00 | |||||
3891396 | 3891396 | 2020-03-17 | Mexico | 82 | 0 | 4 | 23.6345 | -102.5528 | 2020-03-17T10:53:03 | |||||
406 | 406 | 2021-12-02 | Mexico | Aguascalientes | 37220 | 2941 | 0 | 21.8853 | -102.2916 | 2021-12-03 04:23:05 | Aguascalientes, Mexico | |||
4422 | 4422 | 2021-10-28 | Mexico | Aguascalientes | 35722 | 2853 | 0 | 21.8853 | -102.2916 | 2021-10-29 04:22:03 | Aguascalientes, Mexico | |||
8405 | 8405 | 2020-10-25 | Mexico | Aguascalientes | 9040 | 810 | 7310 | 920 | 21.8853 | -102.2916 | 2020-10-26 04:25:02 | Aguascalientes, Mexico | ||
12414 | 12414 | 2021-01-26 | Mexico | Aguascalientes | 20172 | 1624 | 0 | 18548 | 21.8853 | -102.2916 | 2021-01-27 05:23:41 | Aguascalientes, Mexico | ||
16430 | 16430 | 2021-09-18 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-19 04:21:34 | Aguascalientes, Mexico | |||
20445 | 20445 | 2021-05-28 | Mexico | Aguascalientes | 26492 | 2418 | 0 | 24074 | 21.8853 | -102.2916 | 2021-05-29 04:20:41 | Aguascalientes, Mexico | ||
24477 | 24477 | 2022-03-20 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-21 04:20:50 | Aguascalientes, Mexico | |||
28492 | 28492 | 2021-11-11 | Mexico | Aguascalientes | 36280 | 2891 | 0 | 21.8853 | -102.2916 | 2021-11-12 04:22:01 | Aguascalientes, Mexico | |||
32491 | 32491 | 2021-08-25 | Mexico | Aguascalientes | 30389 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-26 04:21:28 | Aguascalientes, Mexico | |||
36504 | 36504 | 2021-04-12 | Mexico | Aguascalientes | 25353 | 2273 | 0 | 23080 | 21.8853 | -102.2916 | 2021-04-13 04:20:37 | Aguascalientes, Mexico | ||
43784 | 43784 | 2021-11-02 | Mexico | Aguascalientes | 35846 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-03 06:22:09 | Aguascalientes, Mexico | |||
50866 | 50866 | 2021-05-29 | Mexico | Aguascalientes | 26501 | 2418 | 0 | 24083 | 21.8853 | -102.2916 | 2021-05-30 04:20:55 | Aguascalientes, Mexico | ||
54879 | 54879 | 2021-03-07 | Mexico | Aguascalientes | 23462 | 2035 | 0 | 21427 | 21.8853 | -102.2916 | 2021-03-08 05:24:48 | Aguascalientes, Mexico | ||
62397 | 62397 | 2020-07-23 | Mexico | Aguascalientes | 3620 | 224 | 2889 | 507 | 21.8853 | -102.2916 | 2020-07-24 03:34:53 | Aguascalientes, Mexico | ||
63139 | 63139 | 2022-11-12 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-13 04:21:14 | Aguascalientes, Mexico | |||
67136 | 67136 | 2021-09-01 | Mexico | Aguascalientes | 31186 | 2611 | 0 | 21.8853 | -102.2916 | 2021-09-02 04:21:15 | Aguascalientes, Mexico | |||
71167 | 71167 | 2022-02-07 | Mexico | Aguascalientes | 53290 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-08 04:21:15 | Aguascalientes, Mexico | |||
75163 | 75163 | 2020-12-03 | Mexico | Aguascalientes | 14083 | 1123 | 0 | 12960 | 21.8853 | -102.2916 | 2020-12-04 05:27:27 | Aguascalientes, Mexico | ||
79161 | 79161 | 2020-10-14 | Mexico | Aguascalientes | 8054 | 725 | 6741 | 588 | 21.8853 | -102.2916 | 2020-10-15 04:24:28 | Aguascalientes, Mexico | ||
83169 | 83169 | 2021-05-25 | Mexico | Aguascalientes | 26454 | 2409 | 0 | 24045 | 21.8853 | -102.2916 | 2021-05-26 04:20:35 | Aguascalientes, Mexico | ||
87201 | 87201 | 2021-11-09 | Mexico | Aguascalientes | 36148 | 2888 | 0 | 21.8853 | -102.2916 | 2021-11-10 04:21:38 | Aguascalientes, Mexico | |||
91219 | 91219 | 2022-07-23 | Mexico | Aguascalientes | 77059 | 3526 | 0 | 21.8853 | -102.2916 | 2022-07-24 04:20:47 | Aguascalientes, Mexico | |||
98074 | 98074 | 2020-08-04 | Mexico | Aguascalientes | 4229 | 269 | 3600 | 360 | 21.8853 | -102.2916 | 2020-08-05 04:34:43 | Aguascalientes, Mexico | ||
99402 | 99402 | 2022-01-14 | Mexico | Aguascalientes | 42387 | 3070 | 0 | 21.8853 | -102.2916 | 2022-01-15 04:21:07 | Aguascalientes, Mexico | |||
103401 | 103401 | 2021-08-15 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-16 04:21:31 | Aguascalientes, Mexico | |||
107526 | 107526 | 2021-06-19 | Mexico | Aguascalientes | 26688 | 2456 | 0 | 24232 | 21.8853 | -102.2916 | 2021-06-20 04:21:48 | Aguascalientes, Mexico | ||
114829 | 114829 | 2022-09-06 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-07 04:20:59 | Aguascalientes, Mexico | |||
121667 | 121667 | 2020-07-19 | Mexico | Aguascalientes | 3417 | 207 | 2654 | 556 | 21.8853 | -102.2916 | 2020-07-20 05:34:40 | Aguascalientes, Mexico | ||
122778 | 122778 | 2020-11-18 | Mexico | Aguascalientes | 11235 | 962 | 0 | 10273 | 21.8853 | -102.2916 | 2020-11-19 05:25:23 | Aguascalientes, Mexico | ||
126809 | 126809 | 2022-01-09 | Mexico | Aguascalientes | 41186 | 3048 | 0 | 21.8853 | -102.2916 | 2022-01-10 04:22:07 | Aguascalientes, Mexico | |||
130827 | 130827 | 2022-10-04 | Mexico | Aguascalientes | 84529 | 3585 | 0 | 21.8853 | -102.2916 | 2022-10-05 04:23:06 | Aguascalientes, Mexico | |||
138047 | 138047 | 2021-12-04 | Mexico | Aguascalientes | 37363 | 2946 | 0 | 21.8853 | -102.2916 | 2021-12-05 04:22:25 | Aguascalientes, Mexico | |||
142065 | 142065 | 2022-07-09 | Mexico | Aguascalientes | 72104 | 3522 | 0 | 21.8853 | -102.2916 | 2022-07-10 04:20:54 | Aguascalientes, Mexico | |||
146045 | 146045 | 2020-08-15 | Mexico | Aguascalientes | 4771 | 324 | 4087 | 360 | 21.8853 | -102.2916 | 2020-08-16 04:27:42 | Aguascalientes, Mexico | ||
150060 | 150060 | 2021-11-29 | Mexico | Aguascalientes | 37083 | 2929 | 0 | 21.8853 | -102.2916 | 2021-11-30 04:22:53 | Aguascalientes, Mexico | |||
154057 | 154057 | 2021-01-08 | Mexico | Aguascalientes | 17612 | 1428 | 0 | 16184 | 21.8853 | -102.2916 | 2021-01-09 05:22:18 | Aguascalientes, Mexico | ||
158089 | 158089 | 2022-03-29 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-30 04:20:45 | Aguascalientes, Mexico | |||
162104 | 162104 | 2021-11-19 | Mexico | Aguascalientes | 36579 | 2902 | 0 | 21.8853 | -102.2916 | 2021-11-20 04:22:17 | Aguascalientes, Mexico | |||
166122 | 166122 | 2022-06-21 | Mexico | Aguascalientes | 68954 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-22 04:20:54 | Aguascalientes, Mexico | |||
170118 | 170118 | 2021-04-16 | Mexico | Aguascalientes | 25605 | 2309 | 0 | 23296 | 21.8853 | -102.2916 | 2021-04-17 04:20:40 | Aguascalientes, Mexico | ||
176985 | 176985 | 2020-07-27 | Mexico | Aguascalientes | 3777 | 243 | 3122 | 412 | 21.8853 | -102.2916 | 2020-07-28 04:58:43 | Aguascalientes, Mexico | ||
178101 | 178101 | 2021-09-02 | Mexico | Aguascalientes | 31341 | 2621 | 0 | 21.8853 | -102.2916 | 2021-09-03 04:21:20 | Aguascalientes, Mexico | |||
182114 | 182114 | 2021-02-21 | Mexico | Aguascalientes | 22621 | 1950 | 0 | 20671 | 21.8853 | -102.2916 | 2021-02-22 05:24:21 | Aguascalientes, Mexico | ||
186147 | 186147 | 2022-02-13 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-14 04:20:51 | Aguascalientes, Mexico | |||
190143 | 190143 | 2021-01-11 | Mexico | Aguascalientes | 17752 | 1447 | 0 | 16305 | 21.8853 | -102.2916 | 2021-01-12 05:22:15 | Aguascalientes, Mexico | ||
194140 | 194140 | 2020-08-31 | Mexico | Aguascalientes | 5631 | 405 | 4847 | 379 | 21.8853 | -102.2916 | 2020-09-01 04:28:31 | Aguascalientes, Mexico | ||
198336 | 198336 | 2022-10-19 | Mexico | Aguascalientes | 84615 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-20 04:22:59 | Aguascalientes, Mexico | |||
202330 | 202330 | 2020-12-25 | Mexico | Aguascalientes | 16499 | 1330 | 0 | 15169 | 21.8853 | -102.2916 | 2020-12-26 05:22:28 | Aguascalientes, Mexico | ||
206327 | 206327 | 2020-08-19 | Mexico | Aguascalientes | 4928 | 347 | 4206 | 375 | 21.8853 | -102.2916 | 2020-08-20 04:27:43 | Aguascalientes, Mexico | ||
210314 | 210314 | 2020-10-29 | Mexico | Aguascalientes | 9450 | 842 | 7719 | 889 | 21.8853 | -102.2916 | 2020-10-30 04:24:49 | Aguascalientes, Mexico | ||
216980 | 216980 | 2020-06-08 | Mexico | Aguascalientes | 1160 | 53 | 792 | 315 | 21.8853 | -102.2916 | 2020-06-09 03:33:03 | Aguascalientes, Mexico | ||
218057 | 218057 | 2022-12-26 | Mexico | Aguascalientes | 85637 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-27 04:21:07 | Aguascalientes, Mexico | |||
222072 | 222072 | 2022-05-09 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-10 04:20:50 | Aguascalientes, Mexico | |||
229304 | 229304 | 2022-05-31 | Mexico | Aguascalientes | 67535 | 3509 | 0 | 21.8853 | -102.2916 | 2022-06-01 04:20:55 | Aguascalientes, Mexico | |||
233319 | 233319 | 2022-02-11 | Mexico | Aguascalientes | 54439 | 3334 | 0 | 21.8853 | -102.2916 | 2022-02-12 04:21:06 | Aguascalientes, Mexico | |||
237315 | 237315 | 2021-01-18 | Mexico | Aguascalientes | 18519 | 1498 | 0 | 17021 | 21.8853 | -102.2916 | 2021-01-19 05:22:15 | Aguascalientes, Mexico | ||
241329 | 241329 | 2021-04-02 | Mexico | Aguascalientes | 24936 | 2162 | 0 | 22774 | 21.8853 | -102.2916 | 2021-04-03 04:20:44 | Aguascalientes, Mexico | ||
245344 | 245344 | 2021-08-17 | Mexico | Aguascalientes | 29348 | 2534 | 0 | 21.8853 | -102.2916 | 2021-08-18 04:21:35 | Aguascalientes, Mexico | |||
249358 | 249358 | 2021-09-04 | Mexico | Aguascalientes | 31675 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-05 04:21:33 | Aguascalientes, Mexico | |||
253391 | 253391 | 2022-09-08 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-09 04:21:11 | Aguascalientes, Mexico | |||
257407 | 257407 | 2022-12-10 | Mexico | Aguascalientes | 84925 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-11 04:20:50 | Aguascalientes, Mexico | |||
261609 | 261609 | 2022-03-15 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-16 04:20:50 | Aguascalientes, Mexico | |||
268216 | 268216 | 2020-05-21 | Mexico | Aguascalientes | 586 | 21 | 402 | 163 | 21.8853 | -102.2916 | 2020-05-22 02:36:51 | Aguascalientes, Mexico | ||
272229 | 272229 | 2020-11-10 | Mexico | Aguascalientes | 10866 | 902 | 8450 | 1514 | 21.8853 | -102.2916 | 2020-11-11 05:25:30 | Aguascalientes, Mexico | ||
276259 | 276259 | 2021-11-03 | Mexico | Aguascalientes | 35896 | 2876 | 0 | 21.8853 | -102.2916 | 2021-11-04 04:22:20 | Aguascalientes, Mexico | |||
280257 | 280257 | 2021-02-24 | Mexico | Aguascalientes | 22870 | 1984 | 0 | 20886 | 21.8853 | -102.2916 | 2021-02-25 05:24:57 | Aguascalientes, Mexico | ||
286956 | 286956 | 2020-06-15 | Mexico | Aguascalientes | 1467 | 71 | 1078 | 318 | 21.8853 | -102.2916 | 2020-06-16 04:33:09 | Aguascalientes, Mexico | ||
288072 | 288072 | 2021-10-31 | Mexico | Aguascalientes | 35837 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-01 04:22:01 | Aguascalientes, Mexico | |||
292090 | 292090 | 2022-11-15 | Mexico | Aguascalientes | 84638 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-16 04:21:09 | Aguascalientes, Mexico | |||
296087 | 296087 | 2021-07-15 | Mexico | Aguascalientes | 27011 | 2478 | 0 | 24533 | 21.8853 | -102.2916 | 2021-07-16 04:21:22 | Aguascalientes, Mexico | ||
302828 | 302828 | 2020-07-01 | Mexico | Aguascalientes | 2363 | 151 | 1877 | 335 | 21.8853 | -102.2916 | 2020-07-02 04:33:46 | Aguascalientes, Mexico | ||
303945 | 303945 | 2022-04-16 | Mexico | Aguascalientes | 65451 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-17 04:20:59 | Aguascalientes, Mexico | |||
307962 | 307962 | 2022-12-13 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-14 04:21:04 | Aguascalientes, Mexico | |||
311978 | 311978 | 2022-11-13 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-14 04:21:09 | Aguascalientes, Mexico | |||
315993 | 315993 | 2022-02-12 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-13 04:21:00 | Aguascalientes, Mexico | |||
320010 | 320010 | 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 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]);