search

covidatlas / li

Next-generation serverless crawler for COVID-19 data
Apache License 2.0
57 stars 33 forks source link

Machine-readable case data for Mexico are available at state and municipality level #489

Open pwrose opened 4 years ago

pwrose commented 4 years ago

It would be great to ingest detailed data for Mexico. They are available as .csv files at the state and municipality level here:

https://coronavirus.gob.mx/datos/#DownZCSV

jzohrab commented 4 years ago

Thanks @pwrose, this is great, especially as the situation in Mexico gets worse.

The actual links for download are, e.g for Aug 9:

https://coronavirus.gob.mx/datos/Downloads/Files/Casos_Diarios_Municipio_Confirmados_20200809.csv https://coronavirus.gob.mx/datos/Downloads/Files/Casos_Diarios_Municipio_Defunciones_20200809.csv

To be safe we could download for the previous date, hopefully the files are there every day.

There's another link, https://datos.gob.mx/busca/dataset/informacion-referente-a-casos-covid-19-en-mexico, which has a link to a zip -- http://187.191.75.115/gobmx/salud/datos_abiertos/datos_abiertos_covid19.zip -- but that continually fails for me in Canada. Does it work for you?

jzohrab commented 4 years ago

Actually I think the links under "Casos diarios por Estado + Nacional" are better. I'm not sure what the municipio data is, it doesn't total up nearly to what is expected.

Links: Downloads/Files/Casos_Diarios_Estado_Nacional_Defunciones_20200809.csv Downloads/Files/Casos_Diarios_Estado_Nacional_Confirmados_20200809.csv

pwrose commented 4 years ago

@JZ The Estado_Nacional files list the cases by state, whereas the Municipio files list the cases at a more fine-grained level by municipalities. They are both very important.

It would be great if both could be incorporated.

Thanks @JZ for looking into this.

On Sun, Aug 9, 2020 at 7:34 PM JZ notifications@github.com wrote:

Actually I think the links under "Casos diarios por Estado + Nacional" are better. I'm not sure what the municipio data is, it doesn't total up nearly to what is expected.

Links: Downloads/Files/Casos_Diarios_Estado_Nacional_Defunciones_20200809.csv Downloads/Files/Casos_Diarios_Estado_Nacional_Confirmados_20200809.csv

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://urldefense.com/v3/__https://github.com/covidatlas/li/issues/489*issuecomment-671138542__;Iw!!Mih3wA!QKdxqCP0ccW2kldS128-j9Km79KY0CnFO5T6KZJERQpptAeBOcPwc87Ru3wqyvM$, or unsubscribe https://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AA53AEBYXZOUACTHQK77MI3R75MCNANCNFSM4PZJSFKA__;!!Mih3wA!QKdxqCP0ccW2kldS128-j9Km79KY0CnFO5T6KZJERQpptAeBOcPwc87RKQNvM10$ .

jzohrab commented 4 years ago

Hi @pwrose - in https://github.com/covidatlas/li/pull/563 I added a source for Mexico Estado/Nacional, which maps clearly to our data model.

We don't currently have a clear model for finer-grained data than that (e.g., cities, municipal, etc), so I'm going to defer that work as there is so much else to do!

I'll mark this issue as needs-verification and assign it to you, to verify that it's in the report (may take a day or two to get launched and to generate fully). Then we should close this issue, and open up a new one for the municipal data ... I can't give a timeframe as we have a huge backlog to handle.

Cheers and thanks for the data links. jz