johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

33 rows where country_or_region = "Mexico" and "day" is on date 2022-06-03 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

country_or_region 1

  • Mexico · 33 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3133629 3133629 2022-06-03 Mexico Aguascalientes     67697 3509 0   21.8853 -102.2916 2022-06-04 04:20:58 Aguascalientes, Mexico
3133630 3133630 2022-06-03 Mexico Baja California     135087 12295 0   30.8406 -115.2838 2022-06-04 04:20:58 Baja California, Mexico
3133631 3133631 2022-06-03 Mexico Baja California Sur     104786 2684 0   26.0444 -111.6661 2022-06-04 04:20:58 Baja California Sur, Mexico
3133632 3133632 2022-06-03 Mexico Campeche     34333 2244 0   19.8301 -90.5349 2022-06-04 04:20:58 Campeche, Mexico
3133633 3133633 2022-06-03 Mexico Chiapas     39514 2413 0   16.7569 -93.1292 2022-06-04 04:20:58 Chiapas, Mexico
3133634 3133634 2022-06-03 Mexico Chihuahua     132251 9965 0   28.633 -106.0691 2022-06-04 04:20:58 Chihuahua, Mexico
3133635 3133635 2022-06-03 Mexico Ciudad de Mexico     1413767 42832 0   19.4326 -99.1332 2022-06-04 04:20:58 Ciudad de Mexico, Mexico
3133636 3133636 2022-06-03 Mexico Coahuila     145774 8806 0   27.0587 -101.7068 2022-06-04 04:20:58 Coahuila, Mexico
3133637 3133637 2022-06-03 Mexico Colima     55217 2202 0   19.1223 -104.0072 2022-06-04 04:20:58 Colima, Mexico
3133638 3133638 2022-06-03 Mexico Durango     68296 3639 0   24.5593 -104.6588 2022-06-04 04:20:58 Durango, Mexico
3133639 3133639 2022-06-03 Mexico Guanajuato     282884 14884 0   21.019 -101.2574 2022-06-04 04:20:58 Guanajuato, Mexico
3133640 3133640 2022-06-03 Mexico Guerrero     98416 6767 0   17.4392 -99.5451 2022-06-04 04:20:58 Guerrero, Mexico
3133641 3133641 2022-06-03 Mexico Hidalgo     94114 8421 0   20.0911 -98.7624 2022-06-04 04:20:58 Hidalgo, Mexico
3133642 3133642 2022-06-03 Mexico Jalisco     247249 19691 0   20.6595 -103.3494 2022-06-04 04:20:58 Jalisco, Mexico
3133643 3133643 2022-06-03 Mexico Mexico     575163 47304 0   19.4969 -99.7233 2022-06-04 04:20:58 Mexico, Mexico
3133644 3133644 2022-06-03 Mexico Michoacan     94349 8848 0   19.5665 -101.7068 2022-06-04 04:20:58 Michoacan, Mexico
3133645 3133645 2022-06-03 Mexico Morelos     70939 5279 0   18.6813 -99.1013 2022-06-04 04:20:58 Morelos, Mexico
3133646 3133646 2022-06-03 Mexico Nayarit     58776 3200 0   21.7514 -104.8455 2022-06-04 04:20:58 Nayarit, Mexico
3133647 3133647 2022-06-03 Mexico Nuevo Leon     321108 14991 0   25.5922 -99.9962 2022-06-04 04:20:58 Nuevo Leon, Mexico
3133648 3133648 2022-06-03 Mexico Oaxaca     120828 6201 0   17.0732 -96.7266 2022-06-04 04:20:58 Oaxaca, Mexico
3133649 3133649 2022-06-03 Mexico Puebla     170210 16462 0   19.0414 -98.2063 2022-06-04 04:20:58 Puebla, Mexico
3133650 3133650 2022-06-03 Mexico Queretaro     142794 6216 0   20.5888 -100.3899 2022-06-04 04:20:58 Queretaro, Mexico
3133651 3133651 2022-06-03 Mexico Quintana Roo     92709 4379 0   19.1817 -88.4791 2022-06-04 04:20:58 Quintana Roo, Mexico
3133652 3133652 2022-06-03 Mexico San Luis Potosi     187641 7491 0   22.1565 -100.9855 2022-06-04 04:20:58 San Luis Potosi, Mexico
3133653 3133653 2022-06-03 Mexico Sinaloa     124157 9754 0   25.1721 -107.4795 2022-06-04 04:20:58 Sinaloa, Mexico
3133654 3133654 2022-06-03 Mexico Sonora     164975 10137 0   29.2972 -110.3309 2022-06-04 04:20:58 Sonora, Mexico
3133655 3133655 2022-06-03 Mexico Tabasco     188997 6050 0   17.8409 -92.6189 2022-06-04 04:20:58 Tabasco, Mexico
3133656 3133656 2022-06-03 Mexico Tamaulipas     147259 8003 0   24.2669 -98.8363 2022-06-04 04:20:58 Tamaulipas, Mexico
3133657 3133657 2022-06-03 Mexico Tlaxcala     43943 3091 0   19.3139 -98.2404 2022-06-04 04:20:58 Tlaxcala, Mexico
3133658 3133658 2022-06-03 Mexico Unknown     0 0 0       2022-06-04 04:20:58 Unknown, Mexico
3133659 3133659 2022-06-03 Mexico Veracruz     180405 16534 0   19.1738 -96.1342 2022-06-04 04:20:58 Veracruz, Mexico
3133660 3133660 2022-06-03 Mexico Yucatan     110983 6815 0   20.7099 -89.0943 2022-06-04 04:20:58 Yucatan, Mexico
3133661 3133661 2022-06-03 Mexico Zacatecas     67784 3859 0   22.7709 -102.5832 2022-06-04 04:20:58 Zacatecas, Mexico

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);