search

covid-19-net / covid-19-community

Community effort to build a Neo4j Knowledge Graph (KG) that links heterogeneous data about COVID-19
MIT License
119 stars 77 forks source link

Download for MX COVID-19 confirmed cases and deaths fails #192

Open pwrose opened 4 years ago

pwrose commented 4 years ago

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 commented 4 years ago

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

pwrose commented 4 years ago

The last successful download was on 2020-10-10

pwrose commented 4 years ago

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 commented 4 years ago

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 commented 3 years ago

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