johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where country_or_region = "Mexico" and recovered = 633 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, last_update (date)
province_or_state 2
country_or_region 1
- Mexico · 11 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
303331 | 303331 | 2020-07-01 | Mexico | Zacatecas | 941 | 99 | 633 | 209 | 22.7709 | -102.5832 | 2020-07-02 04:33:46 | Zacatecas, Mexico | ||
1210590 | 1210590 | 2020-06-09 | Mexico | Baja California Sur | 812 | 47 | 633 | 132 | 26.0444 | -111.6661 | 2020-06-10 04:07:00 | Baja California Sur, Mexico | ||
2567132 | 2567132 | 2020-04-11 | Mexico | 3844 | 233 | 633 | 2978 | 23.6345 | -102.5528 | 2020-04-11 22:45:13 | Mexico | |||
1250317 | 1250317 | 2020-04-10 | Mexico | 3441 | 194 | 633 | 2614 | 23.6345 | -102.5528 | 2020-04-10 22:53:48 | Mexico | |||
3950054 | 3950054 | 2020-04-09 | Mexico | 3181 | 174 | 633 | 2374 | 23.6345 | -102.5528 | 2020-04-09 23:02:19 | Mexico | |||
3562161 | 3562161 | 2020-04-08 | Mexico | 2785 | 141 | 633 | 2011 | 23.6345 | -102.5528 | 2020-04-08 22:51:39 | Mexico | |||
3021836 | 3021836 | 2020-04-07 | Mexico | 2439 | 125 | 633 | 1681 | 23.6345 | -102.5528 | 2020-04-07 23:04:29 | Mexico | |||
3627518 | 3627518 | 2020-04-06 | Mexico | 2143 | 94 | 633 | 1416 | 23.6345 | -102.5528 | 4/6/20 23:21 | Mexico | |||
589206 | 589206 | 2020-04-05 | Mexico | 1890 | 79 | 633 | 1178 | 23.6345 | -102.5528 | 2020-04-05 23:06:26 | Mexico | |||
1750849 | 1750849 | 2020-04-04 | Mexico | 1688 | 60 | 633 | 995 | 23.6345 | -102.5528 | 4/4/20 23:34 | Mexico | |||
3740660 | 3740660 | 2020-04-03 | Mexico | 1510 | 50 | 633 | 827 | 23.6345 | -102.5528 | 2020-04-03 22:46:20 | 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]);