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

[pwrose]

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]

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]

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]

@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 ***@***.***> 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]

Hi @pwrose - in #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