covid-19-community icon indicating copy to clipboard operation
covid-19-community copied to clipboard

Download for MX COVID-19 confirmed cases and deaths fails

Open pwrose opened this issue 4 years ago • 5 comments

The URls to download the Mexican confirmed cases and death give a 404 error (see: https://github.com/covid-19-net/covid-19-community/blob/master/notebooks/dataprep/02d-GOBMXCases.ipynb).

We need to find out if there is a different way to download these data, e.g., from here

pwrose avatar Oct 14 '20 04:10 pwrose

Another resource may be: https://proyecto.li/

pwrose avatar Oct 14 '20 04:10 pwrose

The last successful download was on 2020-10-10

pwrose avatar Oct 14 '20 06:10 pwrose

From Melissa Floca at UCSD:

I think you will find them here:

https://datos.covid-19.conacyt.mx/

Click on "descargas" and it takes you here: https://www.gob.mx/salud/documentos/datos-abiertos-152127

Then it says "base de datos" and today's date and if you click on "Ver" you can download the data.

Proyecto Li has excess mortality statistics for the country that they have put together through freedom of information requests by state: https://proyecto.li/mortalidad

They should more than 2X the deaths that the official statistics show from COVID.

pwrose avatar Oct 15 '20 06:10 pwrose

Hi Peter, The data should have a variable called "entidad_res" that is the state of residence of the patient and another that is "municipio_res" that is the municipality of residence of the patient. States in Mexico are numbered 01 - 32 and municipalities are three digit numbers. So the capital of the state of Aguascalientes is Aguascalientes, Aguascalientes and it would be 01001. The values are in the attached in the tab for "catalogos de entidades" and "catalogos municipios" which I downloaded from the same website that I sent yesterday. Let me know if this is helpful and if not I can provide a bit more info. Copy of Catalogos_071020.xlsx

pwrose avatar Oct 15 '20 06:10 pwrose

Moved notebook to https://github.com/covid-19-net/covid-19-community/blob/master/notebooks/obsolete/02d-GOBMXCases.ipynb until it can be fixed.

pwrose avatar Apr 20 '21 17:04 pwrose