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)
Suggested facets: last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
420 | 420 | 2021-12-02 | Mexico | Mexico | 379161 | 44373 | 0 | 19.4969 | -99.7233 | 2021-12-03 04:23:05 | Mexico, Mexico | |||
4436 | 4436 | 2021-10-28 | Mexico | Mexico | 373484 | 43821 | 0 | 19.4969 | -99.7233 | 2021-10-29 04:22:03 | Mexico, Mexico | |||
16444 | 16444 | 2021-09-18 | Mexico | Mexico | 352178 | 41924 | 0 | 19.4969 | -99.7233 | 2021-09-19 04:21:34 | Mexico, Mexico | |||
24491 | 24491 | 2022-03-20 | Mexico | Mexico | 536209 | 47000 | 0 | 19.4969 | -99.7233 | 2022-03-21 04:20:50 | Mexico, Mexico | |||
28506 | 28506 | 2021-11-11 | Mexico | Mexico | 376227 | 44080 | 0 | 19.4969 | -99.7233 | 2021-11-12 04:22:01 | Mexico, Mexico | |||
32505 | 32505 | 2021-08-25 | Mexico | Mexico | 330242 | 40312 | 0 | 19.4969 | -99.7233 | 2021-08-26 04:21:28 | Mexico, Mexico | |||
43798 | 43798 | 2021-11-02 | Mexico | Mexico | 374157 | 43910 | 0 | 19.4969 | -99.7233 | 2021-11-03 06:22:09 | Mexico, Mexico | |||
63153 | 63153 | 2022-11-12 | Mexico | Mexico | 703905 | 47925 | 0 | 19.4969 | -99.7233 | 2022-11-13 04:21:14 | Mexico, Mexico | |||
67150 | 67150 | 2021-09-01 | Mexico | Mexico | 337715 | 40927 | 0 | 19.4969 | -99.7233 | 2021-09-02 04:21:15 | Mexico, Mexico | |||
71181 | 71181 | 2022-02-07 | Mexico | Mexico | 487038 | 45616 | 0 | 19.4969 | -99.7233 | 2022-02-08 04:21:15 | Mexico, Mexico | |||
87215 | 87215 | 2021-11-09 | Mexico | Mexico | 375816 | 44040 | 0 | 19.4969 | -99.7233 | 2021-11-10 04:21:38 | Mexico, Mexico | |||
91233 | 91233 | 2022-07-23 | Mexico | Mexico | 658286 | 47534 | 0 | 19.4969 | -99.7233 | 2022-07-24 04:20:47 | Mexico, Mexico | |||
99416 | 99416 | 2022-01-14 | Mexico | Mexico | 403799 | 44929 | 0 | 19.4969 | -99.7233 | 2022-01-15 04:21:07 | Mexico, Mexico | |||
103415 | 103415 | 2021-08-15 | Mexico | Mexico | 315566 | 39344 | 0 | 19.4969 | -99.7233 | 2021-08-16 04:21:31 | Mexico, Mexico | |||
114843 | 114843 | 2022-09-06 | Mexico | Mexico | 697653 | 47825 | 0 | 19.4969 | -99.7233 | 2022-09-07 04:20:59 | Mexico, Mexico | |||
126823 | 126823 | 2022-01-09 | Mexico | Mexico | 393546 | 44896 | 0 | 19.4969 | -99.7233 | 2022-01-10 04:22:07 | Mexico, Mexico | |||
130841 | 130841 | 2022-10-04 | Mexico | Mexico | 702059 | 47878 | 0 | 19.4969 | -99.7233 | 2022-10-05 04:23:06 | Mexico, Mexico | |||
138061 | 138061 | 2021-12-04 | Mexico | Mexico | 379477 | 44412 | 0 | 19.4969 | -99.7233 | 2021-12-05 04:22:25 | Mexico, Mexico | |||
142079 | 142079 | 2022-07-09 | Mexico | Mexico | 623552 | 47405 | 0 | 19.4969 | -99.7233 | 2022-07-10 04:20:54 | Mexico, Mexico | |||
150074 | 150074 | 2021-11-29 | Mexico | Mexico | 378889 | 44351 | 0 | 19.4969 | -99.7233 | 2021-11-30 04:22:53 | Mexico, Mexico | |||
158103 | 158103 | 2022-03-29 | Mexico | Mexico | 538133 | 47077 | 0 | 19.4969 | -99.7233 | 2022-03-30 04:20:45 | Mexico, Mexico | |||
162118 | 162118 | 2021-11-19 | Mexico | Mexico | 377251 | 44219 | 0 | 19.4969 | -99.7233 | 2021-11-20 04:22:17 | Mexico, Mexico | |||
166136 | 166136 | 2022-06-21 | Mexico | Mexico | 584704 | 47344 | 0 | 19.4969 | -99.7233 | 2022-06-22 04:20:54 | Mexico, Mexico | |||
178115 | 178115 | 2021-09-02 | Mexico | Mexico | 339258 | 41026 | 0 | 19.4969 | -99.7233 | 2021-09-03 04:21:20 | Mexico, Mexico | |||
186161 | 186161 | 2022-02-13 | Mexico | Mexico | 498917 | 45849 | 0 | 19.4969 | -99.7233 | 2022-02-14 04:20:51 | Mexico, Mexico | |||
198350 | 198350 | 2022-10-19 | Mexico | Mexico | 702953 | 47903 | 0 | 19.4969 | -99.7233 | 2022-10-20 04:22:59 | Mexico, Mexico | |||
218071 | 218071 | 2022-12-26 | Mexico | Mexico | 713858 | 47967 | 0 | 19.4969 | -99.7233 | 2022-12-27 04:21:07 | Mexico, Mexico | |||
222086 | 222086 | 2022-05-09 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-10 04:20:50 | Mexico, Mexico | |||
229318 | 229318 | 2022-05-31 | Mexico | Mexico | 574679 | 47302 | 0 | 19.4969 | -99.7233 | 2022-06-01 04:20:55 | Mexico, Mexico | |||
233333 | 233333 | 2022-02-11 | Mexico | Mexico | 493040 | 45764 | 0 | 19.4969 | -99.7233 | 2022-02-12 04:21:06 | Mexico, Mexico | |||
245358 | 245358 | 2021-08-17 | Mexico | Mexico | 317821 | 39527 | 0 | 19.4969 | -99.7233 | 2021-08-18 04:21:35 | Mexico, Mexico | |||
249372 | 249372 | 2021-09-04 | Mexico | Mexico | 341759 | 41169 | 0 | 19.4969 | -99.7233 | 2021-09-05 04:21:33 | Mexico, Mexico | |||
253405 | 253405 | 2022-09-08 | Mexico | Mexico | 697653 | 47825 | 0 | 19.4969 | -99.7233 | 2022-09-09 04:21:11 | Mexico, Mexico | |||
257421 | 257421 | 2022-12-10 | Mexico | Mexico | 707339 | 47940 | 0 | 19.4969 | -99.7233 | 2022-12-11 04:20:50 | Mexico, Mexico | |||
261623 | 261623 | 2022-03-15 | Mexico | Mexico | 532287 | 46901 | 0 | 19.4969 | -99.7233 | 2022-03-16 04:20:50 | Mexico, Mexico | |||
276273 | 276273 | 2021-11-03 | Mexico | Mexico | 374397 | 43941 | 0 | 19.4969 | -99.7233 | 2021-11-04 04:22:20 | Mexico, Mexico | |||
288086 | 288086 | 2021-10-31 | Mexico | Mexico | 374088 | 43899 | 0 | 19.4969 | -99.7233 | 2021-11-01 04:22:01 | Mexico, Mexico | |||
292104 | 292104 | 2022-11-15 | Mexico | Mexico | 704012 | 47925 | 0 | 19.4969 | -99.7233 | 2022-11-16 04:21:09 | Mexico, Mexico | |||
303959 | 303959 | 2022-04-16 | Mexico | Mexico | 570961 | 47169 | 0 | 19.4969 | -99.7233 | 2022-04-17 04:20:59 | Mexico, Mexico | |||
307976 | 307976 | 2022-12-13 | Mexico | Mexico | 708261 | 47942 | 0 | 19.4969 | -99.7233 | 2022-12-14 04:21:04 | Mexico, Mexico | |||
311992 | 311992 | 2022-11-13 | Mexico | Mexico | 703905 | 47925 | 0 | 19.4969 | -99.7233 | 2022-11-14 04:21:09 | Mexico, Mexico | |||
316007 | 316007 | 2022-02-12 | Mexico | Mexico | 498917 | 45849 | 0 | 19.4969 | -99.7233 | 2022-02-13 04:21:00 | Mexico, Mexico | |||
320024 | 320024 | 2022-10-30 | Mexico | Mexico | 703489 | 47917 | 0 | 19.4969 | -99.7233 | 2022-10-31 04:21:36 | Mexico, Mexico | |||
327998 | 327998 | 2022-12-27 | Mexico | Mexico | 714760 | 47978 | 0 | 19.4969 | -99.7233 | 2022-12-28 04:21:04 | Mexico, Mexico | |||
336027 | 336027 | 2022-03-18 | Mexico | Mexico | 534963 | 46979 | 0 | 19.4969 | -99.7233 | 2022-03-19 04:20:47 | Mexico, Mexico | |||
348388 | 348388 | 2022-12-14 | Mexico | Mexico | 708261 | 47942 | 0 | 19.4969 | -99.7233 | 2022-12-15 04:20:58 | Mexico, Mexico | |||
356417 | 356417 | 2022-03-11 | Mexico | Mexico | 530449 | 46808 | 0 | 19.4969 | -99.7233 | 2022-03-12 04:20:50 | Mexico, Mexico | |||
360433 | 360433 | 2022-05-07 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-08 04:20:49 | Mexico, Mexico | |||
372288 | 372288 | 2022-09-13 | Mexico | Mexico | 699368 | 47837 | 0 | 19.4969 | -99.7233 | 2022-09-14 04:20:44 | Mexico, Mexico | |||
384315 | 384315 | 2022-09-23 | Mexico | Mexico | 701234 | 47857 | 0 | 19.4969 | -99.7233 | 2022-09-24 04:21:40 | Mexico, Mexico | |||
396356 | 396356 | 2022-10-07 | Mexico | Mexico | 702475 | 47884 | 0 | 19.4969 | -99.7233 | 2022-10-08 04:22:56 | Mexico, Mexico | |||
404384 | 404384 | 2021-12-07 | Mexico | Mexico | 379714 | 44433 | 0 | 19.4969 | -99.7233 | 2021-12-08 04:22:46 | Mexico, Mexico | |||
419427 | 419427 | 2022-09-18 | Mexico | Mexico | 700218 | 47849 | 0 | 19.4969 | -99.7233 | 2022-09-19 04:21:49 | Mexico, Mexico | |||
423441 | 423441 | 2021-10-10 | Mexico | Mexico | 367426 | 43327 | 0 | 19.4969 | -99.7233 | 2021-10-11 04:21:31 | Mexico, Mexico | |||
431449 | 431449 | 2022-11-03 | Mexico | Mexico | 703565 | 47919 | 0 | 19.4969 | -99.7233 | 2022-11-04 04:22:11 | Mexico, Mexico | |||
443445 | 443445 | 2021-10-20 | Mexico | Mexico | 371418 | 43605 | 0 | 19.4969 | -99.7233 | 2021-10-21 04:21:18 | Mexico, Mexico | |||
447461 | 447461 | 2021-11-17 | Mexico | Mexico | 377001 | 44187 | 0 | 19.4969 | -99.7233 | 2021-11-18 04:21:33 | Mexico, Mexico | |||
451479 | 451479 | 2022-12-21 | Mexico | Mexico | 710797 | 47956 | 0 | 19.4969 | -99.7233 | 2022-12-22 04:20:56 | Mexico, Mexico | |||
459470 | 459470 | 2022-02-02 | Mexico | Mexico | 470962 | 45408 | 0 | 19.4969 | -99.7233 | 2022-02-03 04:21:21 | Mexico, Mexico | |||
463487 | 463487 | 2022-05-02 | Mexico | Mexico | 572091 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-03 04:21:00 | Mexico, Mexico | |||
467502 | 467502 | 2021-10-07 | Mexico | Mexico | 366045 | 43241 | 0 | 19.4969 | -99.7233 | 2021-10-08 04:21:25 | Mexico, Mexico | |||
475534 | 475534 | 2022-06-26 | Mexico | Mexico | 591984 | 47358 | 0 | 19.4969 | -99.7233 | 2022-06-27 04:21:00 | Mexico, Mexico | |||
479682 | 479682 | 2022-11-08 | Mexico | Mexico | 703712 | 47919 | 0 | 19.4969 | -99.7233 | 2022-11-09 04:21:22 | Mexico, Mexico | |||
487712 | 487712 | 2022-11-25 | Mexico | Mexico | 704353 | 47931 | 0 | 19.4969 | -99.7233 | 2022-11-26 04:21:11 | Mexico, Mexico | |||
491726 | 491726 | 2021-10-14 | Mexico | Mexico | 369465 | 43492 | 0 | 19.4969 | -99.7233 | 2021-10-15 04:21:26 | Mexico, Mexico | |||
495742 | 495742 | 2021-11-06 | Mexico | Mexico | 375464 | 44011 | 0 | 19.4969 | -99.7233 | 2021-11-07 04:21:53 | Mexico, Mexico | |||
499759 | 499759 | 2022-04-02 | Mexico | Mexico | 539410 | 47101 | 0 | 19.4969 | -99.7233 | 2022-04-03 04:20:48 | Mexico, Mexico | |||
503776 | 503776 | 2022-12-17 | Mexico | Mexico | 710009 | 47952 | 0 | 19.4969 | -99.7233 | 2022-12-18 04:21:03 | Mexico, Mexico | |||
507773 | 507773 | 2021-08-14 | Mexico | Mexico | 315566 | 39344 | 0 | 19.4969 | -99.7233 | 2021-08-15 04:21:41 | Mexico, Mexico | |||
511787 | 511787 | 2021-08-19 | Mexico | Mexico | 322459 | 39798 | 0 | 19.4969 | -99.7233 | 2021-08-20 04:21:33 | Mexico, Mexico | |||
515820 | 515820 | 2022-10-15 | Mexico | Mexico | 702924 | 47902 | 0 | 19.4969 | -99.7233 | 2022-10-16 04:22:39 | Mexico, Mexico | |||
534826 | 534826 | 2021-10-27 | Mexico | Mexico | 372888 | 43757 | 0 | 19.4969 | -99.7233 | 2021-10-28 04:22:08 | Mexico, Mexico | |||
538844 | 538844 | 2022-10-26 | Mexico | Mexico | 703337 | 47914 | 0 | 19.4969 | -99.7233 | 2022-10-27 04:22:01 | Mexico, Mexico | |||
542860 | 542860 | 2022-12-15 | Mexico | Mexico | 708705 | 47944 | 0 | 19.4969 | -99.7233 | 2022-12-16 04:21:01 | Mexico, Mexico | |||
550864 | 550864 | 2021-12-08 | Mexico | Mexico | 379834 | 44446 | 0 | 19.4969 | -99.7233 | 2021-12-09 04:22:49 | Mexico, Mexico | |||
554880 | 554880 | 2022-01-16 | Mexico | Mexico | 411739 | 44954 | 0 | 19.4969 | -99.7233 | 2022-01-17 04:21:08 | Mexico, Mexico | |||
558898 | 558898 | 2022-06-16 | Mexico | Mexico | 581086 | 47336 | 0 | 19.4969 | -99.7233 | 2022-06-17 04:20:56 | Mexico, Mexico | |||
567194 | 567194 | 2021-10-29 | Mexico | Mexico | 373715 | 43847 | 0 | 19.4969 | -99.7233 | 2021-10-30 04:22:03 | Mexico, Mexico | |||
574923 | 574923 | 2022-02-25 | Mexico | Mexico | 519091 | 46408 | 0 | 19.4969 | -99.7233 | 2022-02-26 04:21:12 | Mexico, Mexico | |||
589717 | 589717 | 2021-08-08 | Mexico | Mexico | 304441 | 38791 | 0 | 19.4969 | -99.7233 | 2021-08-09 04:21:24 | Mexico, Mexico | |||
593750 | 593750 | 2022-07-01 | Mexico | Mexico | 602640 | 47368 | 0 | 19.4969 | -99.7233 | 2022-07-02 04:21:16 | Mexico, Mexico | |||
597764 | 597764 | 2021-10-19 | Mexico | Mexico | 371129 | 43584 | 0 | 19.4969 | -99.7233 | 2021-10-20 04:21:00 | Mexico, Mexico | |||
601780 | 601780 | 2021-09-23 | Mexico | Mexico | 357403 | 42236 | 0 | 19.4969 | -99.7233 | 2021-09-24 04:21:44 | Mexico, Mexico | |||
617954 | 617954 | 2022-11-05 | Mexico | Mexico | 703654 | 47919 | 0 | 19.4969 | -99.7233 | 2022-11-06 04:21:24 | Mexico, Mexico | |||
621970 | 621970 | 2022-05-22 | Mexico | Mexico | 573341 | 47288 | 0 | 19.4969 | -99.7233 | 2022-05-26 04:20:50 | Mexico, Mexico | |||
630000 | 630000 | 2022-07-12 | Mexico | Mexico | 628463 | 47417 | 0 | 19.4969 | -99.7233 | 2022-07-13 04:20:58 | Mexico, Mexico | |||
634014 | 634014 | 2021-10-13 | Mexico | Mexico | 368845 | 43439 | 0 | 19.4969 | -99.7233 | 2021-10-14 04:21:29 | Mexico, Mexico | |||
642027 | 642027 | 2021-09-07 | Mexico | Mexico | 343672 | 41345 | 0 | 19.4969 | -99.7233 | 2021-09-08 04:21:31 | Mexico, Mexico | |||
650055 | 650055 | 2021-08-09 | Mexico | Mexico | 304869 | 38842 | 0 | 19.4969 | -99.7233 | 2021-08-10 04:21:27 | Mexico, Mexico | |||
654086 | 654086 | 2021-10-22 | Mexico | Mexico | 372079 | 43635 | 0 | 19.4969 | -99.7233 | 2021-10-23 04:21:32 | Mexico, Mexico | |||
658405 | 658405 | 2022-05-13 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-14 04:20:48 | Mexico, Mexico | |||
670391 | 670391 | 2022-07-21 | Mexico | Mexico | 652613 | 47511 | 0 | 19.4969 | -99.7233 | 2022-07-22 04:21:15 | Mexico, Mexico | |||
674407 | 674407 | 2022-07-30 | Mexico | Mexico | 666695 | 47572 | 0 | 19.4969 | -99.7233 | 2022-07-31 04:21:02 | Mexico, Mexico | |||
682431 | 682431 | 2021-10-24 | Mexico | Mexico | 372355 | 43673 | 0 | 19.4969 | -99.7233 | 2021-10-25 04:22:31 | Mexico, Mexico | |||
686447 | 686447 | 2021-11-13 | Mexico | Mexico | 376397 | 44101 | 0 | 19.4969 | -99.7233 | 2021-11-14 04:21:31 | Mexico, Mexico | |||
690465 | 690465 | 2022-12-23 | Mexico | Mexico | 710797 | 47956 | 0 | 19.4969 | -99.7233 | 2022-12-24 04:21:02 | Mexico, Mexico | |||
694480 | 694480 | 2022-03-17 | Mexico | Mexico | 534963 | 46979 | 0 | 19.4969 | -99.7233 | 2022-03-18 04:20:55 | Mexico, Mexico | |||
698495 | 698495 | 2021-11-04 | Mexico | Mexico | 374655 | 43952 | 0 | 19.4969 | -99.7233 | 2021-11-05 04:21:54 | Mexico, Mexico | |||
706525 | 706525 | 2021-09-29 | Mexico | Mexico | 361544 | 42481 | 0 | 19.4969 | -99.7233 | 2021-09-30 04:21:20 | Mexico, Mexico | |||
710542 | 710542 | 2022-11-01 | Mexico | Mexico | 703489 | 47917 | 0 | 19.4969 | -99.7233 | 2022-11-02 04:22:09 | 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]);