johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 284 and country_or_region = "Mexico" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key, last_update (date)
province_or_state 6
- Morelos 2
- Queretaro 2
- Quintana Roo 2
- Aguascalientes 1
- Colima 1
- Nayarit 1
country_or_region 1
- Mexico · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1544026 | 1544026 | 2020-11-07 | Mexico | Colima | 6797 | 762 | 5751 | 284 | 19.1223 | -104.0072 | 2020-11-08 05:24:56 | Colima, Mexico | ||
1544034 | 1544034 | 2020-11-07 | Mexico | Morelos | 7120 | 1229 | 5607 | 284 | 18.6813 | -99.1013 | 2020-11-08 05:24:56 | Morelos, Mexico | ||
2243476 | 2243476 | 2020-10-30 | Mexico | Nayarit | 6707 | 863 | 5560 | 284 | 21.7514 | -104.8455 | 2020-10-31 04:24:44 | Nayarit, Mexico | ||
1502828 | 1502828 | 2020-07-25 | Mexico | Morelos | 3832 | 812 | 2736 | 284 | 18.6813 | -99.1013 | 2020-07-26 04:35:00 | Morelos, Mexico | ||
1005629 | 1005629 | 2020-07-09 | Mexico | Queretaro | 2343 | 359 | 1700 | 284 | 20.5888 | -100.3899 | 2020-07-10 04:34:24 | Queretaro, Mexico | ||
2234343 | 2234343 | 2020-07-03 | Mexico | Aguascalientes | 2415 | 156 | 1975 | 284 | 21.8853 | -102.2916 | 2020-07-04 04:33:51 | Aguascalientes, Mexico | ||
2864052 | 2864052 | 2020-06-10 | Mexico | Quintana Roo | 2283 | 448 | 1551 | 284 | 19.1817 | -88.4791 | 2020-06-11 03:33:41 | Quintana Roo, Mexico | ||
805458 | 805458 | 2020-06-01 | Mexico | Quintana Roo | 1926 | 355 | 1287 | 284 | 19.1817 | -88.4791 | 2020-06-02 02:33:08 | Quintana Roo, Mexico | ||
268376 | 268376 | 2020-05-21 | Mexico | Queretaro | 592 | 61 | 247 | 284 | 20.5888 | -100.3899 | 2020-05-22 02:36:51 | Queretaro, 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]);