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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533488 | 2533488 | 2022-05-12 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-13 04:20:51 | Mexico, Mexico | |||
3444934 | 3444934 | 2022-05-11 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-12 04:20:54 | Mexico, Mexico | |||
3535551 | 3535551 | 2022-05-10 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-11 04:20:48 | Mexico, Mexico | |||
222086 | 222086 | 2022-05-09 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-10 04:20:50 | Mexico, Mexico | |||
2331471 | 2331471 | 2022-05-08 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-09 04:20:54 | Mexico, Mexico | |||
360433 | 360433 | 2022-05-07 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-08 04:20:49 | Mexico, Mexico | |||
1397784 | 1397784 | 2022-05-06 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-07 04:21:09 | Mexico, Mexico | |||
2598139 | 2598139 | 2022-05-05 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-06 04:21:00 | Mexico, Mexico | |||
3265588 | 3265588 | 2022-05-04 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-05 04:20:55 | Mexico, Mexico | |||
1572227 | 1572227 | 2022-05-03 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-04 04:20:59 | Mexico, Mexico | |||
463487 | 463487 | 2022-05-02 | Mexico | Mexico | 572091 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-03 04:21:00 | Mexico, Mexico | |||
3916126 | 3916126 | 2022-05-01 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-02 04:21:10 | Mexico, Mexico | |||
2840930 | 2840930 | 2022-04-30 | Mexico | Mexico | 572059 | 47211 | 0 | 19.4969 | -99.7233 | 2022-05-01 04:20:57 | Mexico, Mexico | |||
1157243 | 1157243 | 2022-04-29 | Mexico | Mexico | 571993 | 47204 | 0 | 19.4969 | -99.7233 | 2022-04-30 04:21:05 | Mexico, Mexico | |||
1696425 | 1696425 | 2022-04-28 | Mexico | Mexico | 571938 | 47200 | 0 | 19.4969 | -99.7233 | 2022-04-29 04:20:59 | Mexico, Mexico | |||
3851908 | 3851908 | 2022-04-27 | Mexico | Mexico | 571859 | 47197 | 0 | 19.4969 | -99.7233 | 2022-04-28 04:20:47 | Mexico, Mexico | |||
1326338 | 1326338 | 2022-04-26 | Mexico | Mexico | 571779 | 47191 | 0 | 19.4969 | -99.7233 | 2022-04-27 04:20:52 | Mexico, Mexico | |||
3722292 | 3722292 | 2022-04-25 | Mexico | Mexico | 571656 | 47185 | 0 | 19.4969 | -99.7233 | 2022-04-26 04:20:51 | Mexico, Mexico | |||
2028860 | 2028860 | 2022-04-24 | Mexico | Mexico | 571646 | 47185 | 0 | 19.4969 | -99.7233 | 2022-04-25 04:20:56 | Mexico, Mexico | |||
746435 | 746435 | 2022-04-23 | Mexico | Mexico | 571630 | 47185 | 0 | 19.4969 | -99.7233 | 2022-04-24 04:20:56 | Mexico, Mexico | |||
3436920 | 3436920 | 2022-04-22 | Mexico | Mexico | 571459 | 47179 | 0 | 19.4969 | -99.7233 | 2022-04-23 04:20:50 | Mexico, Mexico | |||
2892505 | 2892505 | 2022-04-21 | Mexico | Mexico | 571459 | 47179 | 0 | 19.4969 | -99.7233 | 2022-04-22 04:20:45 | Mexico, Mexico | |||
2307377 | 2307377 | 2022-04-20 | Mexico | Mexico | 571356 | 47177 | 0 | 19.4969 | -99.7233 | 2022-04-21 04:20:46 | Mexico, Mexico | |||
2251516 | 2251516 | 2022-04-19 | Mexico | Mexico | 571221 | 47173 | 0 | 19.4969 | -99.7233 | 2022-04-20 04:20:45 | Mexico, Mexico | |||
1846066 | 1846066 | 2022-04-18 | Mexico | Mexico | 571072 | 47169 | 0 | 19.4969 | -99.7233 | 2022-04-19 04:21:00 | Mexico, Mexico | |||
3417010 | 3417010 | 2022-04-17 | Mexico | Mexico | 571072 | 47169 | 0 | 19.4969 | -99.7233 | 2022-04-18 04:21:12 | Mexico, Mexico | |||
303959 | 303959 | 2022-04-16 | Mexico | Mexico | 570961 | 47169 | 0 | 19.4969 | -99.7233 | 2022-04-17 04:20:59 | Mexico, Mexico | |||
2669904 | 2669904 | 2022-04-15 | Mexico | Mexico | 570879 | 47163 | 0 | 19.4969 | -99.7233 | 2022-04-16 04:20:48 | Mexico, Mexico | |||
1223689 | 1223689 | 2022-04-14 | Mexico | Mexico | 570855 | 47163 | 0 | 19.4969 | -99.7233 | 2022-04-15 04:20:57 | Mexico, Mexico | |||
2442847 | 2442847 | 2022-04-13 | Mexico | Mexico | 570807 | 47160 | 0 | 19.4969 | -99.7233 | 2022-04-13 23:21:06 | Mexico, Mexico | |||
1948604 | 1948604 | 2022-04-12 | Mexico | Mexico | 570755 | 47159 | 0 | 19.4969 | -99.7233 | 2022-04-13 04:21:03 | Mexico, Mexico | |||
3206357 | 3206357 | 2022-04-11 | Mexico | Mexico | 570717 | 47149 | 0 | 19.4969 | -99.7233 | 2022-04-12 04:20:49 | Mexico, Mexico | |||
1576243 | 1576243 | 2022-04-10 | Mexico | Mexico | 570712 | 47148 | 0 | 19.4969 | -99.7233 | 2022-04-11 04:21:02 | Mexico, Mexico | |||
1652485 | 1652485 | 2022-04-09 | Mexico | Mexico | 570705 | 47148 | 0 | 19.4969 | -99.7233 | 2022-04-10 04:20:52 | Mexico, Mexico | |||
2115807 | 2115807 | 2022-04-08 | Mexico | Mexico | 570511 | 47141 | 0 | 19.4969 | -99.7233 | 2022-04-09 04:20:42 | Mexico, Mexico | |||
3320331 | 3320331 | 2022-04-07 | Mexico | Mexico | 570169 | 47129 | 0 | 19.4969 | -99.7233 | 2022-04-08 04:20:48 | Mexico, Mexico | |||
2800867 | 2800867 | 2022-04-06 | Mexico | Mexico | 546879 | 47122 | 0 | 19.4969 | -99.7233 | 2022-04-07 04:20:53 | Mexico, Mexico | |||
3867636 | 3867636 | 2022-04-05 | Mexico | Mexico | 539912 | 47114 | 0 | 19.4969 | -99.7233 | 2022-04-06 04:20:49 | Mexico, Mexico | |||
2748978 | 2748978 | 2022-04-04 | Mexico | Mexico | 539514 | 47103 | 0 | 19.4969 | -99.7233 | 2022-04-05 04:20:48 | Mexico, Mexico | |||
3730324 | 3730324 | 2022-04-03 | Mexico | Mexico | 539477 | 47102 | 0 | 19.4969 | -99.7233 | 2022-04-04 04:20:51 | Mexico, Mexico | |||
499759 | 499759 | 2022-04-02 | Mexico | Mexico | 539410 | 47101 | 0 | 19.4969 | -99.7233 | 2022-04-03 04:20:48 | Mexico, Mexico | |||
3350744 | 3350744 | 2022-04-01 | Mexico | Mexico | 538981 | 47100 | 0 | 19.4969 | -99.7233 | 2022-04-02 04:20:47 | Mexico, Mexico | |||
1540049 | 1540049 | 2022-03-31 | Mexico | Mexico | 538731 | 47089 | 0 | 19.4969 | -99.7233 | 2022-04-01 04:20:28 | Mexico, Mexico | |||
2478062 | 2478062 | 2022-03-30 | Mexico | Mexico | 538133 | 47077 | 0 | 19.4969 | -99.7233 | 2022-03-31 04:20:56 | Mexico, Mexico | |||
158103 | 158103 | 2022-03-29 | Mexico | Mexico | 538133 | 47077 | 0 | 19.4969 | -99.7233 | 2022-03-30 04:20:45 | Mexico, Mexico | |||
1436674 | 1436674 | 2022-03-28 | Mexico | Mexico | 537848 | 47074 | 0 | 19.4969 | -99.7233 | 2022-03-29 04:20:46 | Mexico, Mexico | |||
876355 | 876355 | 2022-03-27 | Mexico | Mexico | 537814 | 47072 | 0 | 19.4969 | -99.7233 | 2022-03-28 04:20:33 | Mexico, Mexico | |||
2163638 | 2163638 | 2022-03-26 | Mexico | Mexico | 537547 | 47046 | 0 | 19.4969 | -99.7233 | 2022-03-27 04:20:47 | Mexico, Mexico | |||
1720574 | 1720574 | 2022-03-25 | Mexico | Mexico | 537547 | 47046 | 0 | 19.4969 | -99.7233 | 2022-03-26 04:20:23 | Mexico, Mexico | |||
1468191 | 1468191 | 2022-03-24 | Mexico | Mexico | 536754 | 47021 | 0 | 19.4969 | -99.7233 | 2022-03-25 04:20:46 | Mexico, Mexico | |||
3022365 | 3022365 | 2022-03-23 | Mexico | Mexico | 536293 | 47007 | 0 | 19.4969 | -99.7233 | 2022-03-24 04:20:43 | Mexico, Mexico | |||
1905287 | 1905287 | 2022-03-22 | Mexico | Mexico | 536293 | 47007 | 0 | 19.4969 | -99.7233 | 2022-03-23 04:20:48 | Mexico, Mexico | |||
3238418 | 3238418 | 2022-03-21 | Mexico | Mexico | 536226 | 47004 | 0 | 19.4969 | -99.7233 | 2022-03-22 04:20:54 | Mexico, Mexico | |||
24491 | 24491 | 2022-03-20 | Mexico | Mexico | 536209 | 47000 | 0 | 19.4969 | -99.7233 | 2022-03-21 04:20:50 | Mexico, Mexico | |||
1656501 | 1656501 | 2022-03-19 | Mexico | Mexico | 535680 | 46985 | 0 | 19.4969 | -99.7233 | 2022-03-20 04:20:45 | Mexico, Mexico | |||
336027 | 336027 | 2022-03-18 | Mexico | Mexico | 534963 | 46979 | 0 | 19.4969 | -99.7233 | 2022-03-19 04:20:47 | Mexico, Mexico | |||
694480 | 694480 | 2022-03-17 | Mexico | Mexico | 534963 | 46979 | 0 | 19.4969 | -99.7233 | 2022-03-18 04:20:55 | Mexico, Mexico | |||
2319423 | 2319423 | 2022-03-16 | Mexico | Mexico | 533118 | 46932 | 0 | 19.4969 | -99.7233 | 2022-03-17 04:20:56 | Mexico, Mexico | |||
261623 | 261623 | 2022-03-15 | Mexico | Mexico | 532287 | 46901 | 0 | 19.4969 | -99.7233 | 2022-03-16 04:20:50 | Mexico, Mexico | |||
2263982 | 2263982 | 2022-03-14 | Mexico | Mexico | 532287 | 46901 | 0 | 19.4969 | -99.7233 | 2022-03-15 04:20:47 | Mexico, Mexico | |||
3628048 | 3628048 | 2022-03-13 | Mexico | Mexico | 532225 | 46901 | 0 | 19.4969 | -99.7233 | 2022-03-14 04:20:46 | Mexico, Mexico | |||
950956 | 950956 | 2022-03-12 | Mexico | Mexico | 532146 | 46898 | 0 | 19.4969 | -99.7233 | 2022-03-13 04:20:49 | Mexico, Mexico | |||
356417 | 356417 | 2022-03-11 | Mexico | Mexico | 530449 | 46808 | 0 | 19.4969 | -99.7233 | 2022-03-12 04:20:50 | Mexico, Mexico | |||
1865569 | 1865569 | 2022-03-10 | Mexico | Mexico | 530449 | 46808 | 0 | 19.4969 | -99.7233 | 2022-03-11 04:20:50 | Mexico, Mexico | |||
2140264 | 2140264 | 2022-03-09 | Mexico | Mexico | 529522 | 46780 | 0 | 19.4969 | -99.7233 | 2022-03-10 04:20:48 | Mexico, Mexico | |||
919775 | 919775 | 2022-03-08 | Mexico | Mexico | 528556 | 46737 | 0 | 19.4969 | -99.7233 | 2022-03-09 04:20:59 | Mexico, Mexico | |||
1548062 | 1548062 | 2022-03-07 | Mexico | Mexico | 527517 | 46693 | 0 | 19.4969 | -99.7233 | 2022-03-08 04:20:54 | Mexico, Mexico | |||
2199731 | 2199731 | 2022-03-06 | Mexico | Mexico | 527402 | 46687 | 0 | 19.4969 | -99.7233 | 2022-03-07 04:20:47 | Mexico, Mexico | |||
2092188 | 2092188 | 2022-03-05 | Mexico | Mexico | 526586 | 46661 | 0 | 19.4969 | -99.7233 | 2022-03-06 04:20:49 | Mexico, Mexico | |||
2665888 | 2665888 | 2022-03-04 | Mexico | Mexico | 525233 | 46608 | 0 | 19.4969 | -99.7233 | 2022-03-05 04:21:10 | Mexico, Mexico | |||
1644453 | 1644453 | 2022-03-03 | Mexico | Mexico | 523913 | 46566 | 0 | 19.4969 | -99.7233 | 2022-03-04 04:21:09 | Mexico, Mexico | |||
2525456 | 2525456 | 2022-03-02 | Mexico | Mexico | 522350 | 46522 | 0 | 19.4969 | -99.7233 | 2022-03-03 04:21:01 | Mexico, Mexico | |||
1992750 | 1992750 | 2022-03-01 | Mexico | Mexico | 522350 | 46522 | 0 | 19.4969 | -99.7233 | 2022-03-02 04:21:07 | Mexico, Mexico | |||
942924 | 942924 | 2022-02-28 | Mexico | Mexico | 520870 | 46459 | 0 | 19.4969 | -99.7233 | 2022-03-01 04:21:09 | Mexico, Mexico | |||
2733115 | 2733115 | 2022-02-27 | Mexico | Mexico | 520748 | 46451 | 0 | 19.4969 | -99.7233 | 2022-02-28 04:21:05 | Mexico, Mexico | |||
3046268 | 3046268 | 2022-02-26 | Mexico | Mexico | 520475 | 46444 | 0 | 19.4969 | -99.7233 | 2022-02-27 04:21:04 | Mexico, Mexico | |||
574923 | 574923 | 2022-02-25 | Mexico | Mexico | 519091 | 46408 | 0 | 19.4969 | -99.7233 | 2022-02-26 04:21:12 | Mexico, Mexico | |||
1511499 | 1511499 | 2022-02-24 | Mexico | Mexico | 517439 | 46359 | 0 | 19.4969 | -99.7233 | 2022-02-25 04:21:11 | Mexico, Mexico | |||
1057940 | 1057940 | 2022-02-23 | Mexico | Mexico | 515361 | 46304 | 0 | 19.4969 | -99.7233 | 2022-02-24 04:21:14 | Mexico, Mexico | |||
2446863 | 2446863 | 2022-02-22 | Mexico | Mexico | 511527 | 46211 | 0 | 19.4969 | -99.7233 | 2022-02-23 04:21:09 | Mexico, Mexico | |||
3718276 | 3718276 | 2022-02-21 | Mexico | Mexico | 511247 | 46201 | 0 | 19.4969 | -99.7233 | 2022-02-22 04:21:01 | Mexico, Mexico | |||
3912110 | 3912110 | 2022-02-20 | Mexico | Mexico | 511247 | 46201 | 0 | 19.4969 | -99.7233 | 2022-02-21 04:21:05 | Mexico, Mexico | |||
3875668 | 3875668 | 2022-02-19 | Mexico | Mexico | 510796 | 46187 | 0 | 19.4969 | -99.7233 | 2022-02-20 04:21:00 | Mexico, Mexico | |||
3855924 | 3855924 | 2022-02-18 | Mexico | Mexico | 506607 | 46050 | 0 | 19.4969 | -99.7233 | 2022-02-19 04:21:11 | Mexico, Mexico | |||
1298143 | 1298143 | 2022-02-17 | Mexico | Mexico | 506607 | 46050 | 0 | 19.4969 | -99.7233 | 2022-02-18 04:21:04 | Mexico, Mexico | |||
3820529 | 3820529 | 2022-02-16 | Mexico | Mexico | 504124 | 46005 | 0 | 19.4969 | -99.7233 | 2022-02-17 04:20:56 | Mexico, Mexico | |||
3671743 | 3671743 | 2022-02-15 | Mexico | Mexico | 500149 | 45896 | 0 | 19.4969 | -99.7233 | 2022-02-16 04:21:10 | Mexico, Mexico | |||
2641844 | 2641844 | 2022-02-14 | Mexico | Mexico | 499545 | 45860 | 0 | 19.4969 | -99.7233 | 2022-02-15 04:21:09 | Mexico, Mexico | |||
186161 | 186161 | 2022-02-13 | Mexico | Mexico | 498917 | 45849 | 0 | 19.4969 | -99.7233 | 2022-02-14 04:20:51 | Mexico, Mexico | |||
316007 | 316007 | 2022-02-12 | Mexico | Mexico | 498917 | 45849 | 0 | 19.4969 | -99.7233 | 2022-02-13 04:21:00 | Mexico, Mexico | |||
233333 | 233333 | 2022-02-11 | Mexico | Mexico | 493040 | 45764 | 0 | 19.4969 | -99.7233 | 2022-02-12 04:21:06 | Mexico, Mexico | |||
1464175 | 1464175 | 2022-02-10 | Mexico | Mexico | 489567 | 45694 | 0 | 19.4969 | -99.7233 | 2022-02-11 04:21:09 | Mexico, Mexico | |||
3074136 | 3074136 | 2022-02-09 | Mexico | Mexico | 489567 | 45694 | 0 | 19.4969 | -99.7233 | 2022-02-10 04:21:14 | Mexico, Mexico | |||
1362443 | 1362443 | 2022-02-08 | Mexico | Mexico | 487575 | 45631 | 0 | 19.4969 | -99.7233 | 2022-02-09 04:21:04 | Mexico, Mexico | |||
71181 | 71181 | 2022-02-07 | Mexico | Mexico | 487038 | 45616 | 0 | 19.4969 | -99.7233 | 2022-02-08 04:21:15 | Mexico, Mexico | |||
2012797 | 2012797 | 2022-02-06 | Mexico | Mexico | 486369 | 45602 | 0 | 19.4969 | -99.7233 | 2022-02-07 04:21:05 | Mexico, Mexico | |||
1294126 | 1294126 | 2022-02-05 | Mexico | Mexico | 485744 | 45588 | 0 | 19.4969 | -99.7233 | 2022-02-06 04:21:00 | Mexico, Mexico | |||
2327454 | 2327454 | 2022-02-04 | Mexico | Mexico | 482592 | 45538 | 0 | 19.4969 | -99.7233 | 2022-02-05 04:21:05 | Mexico, Mexico | |||
2474045 | 2474045 | 2022-02-03 | Mexico | Mexico | 475491 | 45464 | 0 | 19.4969 | -99.7233 | 2022-02-04 04:21:10 | Mexico, Mexico | |||
459470 | 459470 | 2022-02-02 | Mexico | Mexico | 470962 | 45408 | 0 | 19.4969 | -99.7233 | 2022-02-03 04:21:21 | 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]);