Skip to content

mariorz/covid19-mx-time-series

master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
doc
 
 
 
 
 
 
 
 
 
 
 
 
 
 

covid19-mx-time-series

This project generates time series data of the COVID-19 epidemic for every state in Mexico.

Data Organization

Basic

The basic set of files are located in the root data directory. These time series are aggregated by the date in which they were officially published, as opposed to symptom onset, or hospital admission date. They are also aggregated by the state in which the patient was treated, as opposed to their state of residence. These are probably the series that would make more sense to compare against other international time series, like the ones published by JHU CSSE.

filename description
covid19_deaths_mx.csv Confirmed deaths aggregated by date of official publication.
covid19_confirmed_mx.csv Confirmed cases aggregated by date of official publication.
covid19_negatives_mx.csv Cases that tested negative aggregated by date of official publication.
covid19_suspects_mx.csv Suspect cases aggregated by date of official publication.
⚠️ On dates of official publication
It is worth noting that there is a considerable lag (up to 14 days) between when the patients are treated and when they are officially published as confirmed cases. These lags do seem to affect the shape of the resulting curves. Further analysis on this issue can be found here.

Full

The full set of time series files are located in the data/full directory.

These time series are aggregated either by the state in which the patient was treated in the data/full/by_hospital_state directory, or by their state of residence in the data/full/by_residency_state directory.

Each of these directories include the following time series CSV files according to case classification and the dates in which they are aggregated by. They are all updated using the latest published official db snapshot. This means that a case that started symptoms onset on date X, but had their case officially published as confirmed on date X+15, will be counted on date X for the files aggregated by date of symptoms onset. However, this update to date X will occur on day X+15.

filename description
confirmed_by_symptoms_date_mx.csv Confirmed cases aggregated by date of symptoms onset.
suspects_by_symptoms_date_mx.csv Suspect cases aggregated by date of symptoms onset.
negatives_by_symptoms_date_mx.csv Cases that tested negative aggregated by date of symptoms onset.
hospitalized_confirmed_by_symptoms_date_mx.csv Hospitalized cases confirmed aggregated by date of symptoms onset.
hospitalized_confirmed_by_admission_date_mx.csv Hospitalized cases confirmed aggregated by date of hospital admission.
hospitalized_suspects_by_symptoms_date_mx.csv Hospitalized suspect cases aggregated by date of symptoms onset.
hospitalized_suspects_by_admission_date_mx.csv Hospitalized suspect cases aggregated by date of hospital admission.
deaths_confirmed_by_symptoms_date_mx.csv Confirmed deaths aggregated by date of symptoms onset.
deaths_confirmed_by_admission_date_mx.csv Confirmed deaths aggregated by date of hospital admission.
deaths_confirmed_by_death_date_mx.csv Confirmed deaths aggregated by date of death.
deaths_suspects_by_symptoms_date_mx.csv Suspect deaths aggregated by date of symptoms onset.
deaths_suspects_by_admission_date_mx.csv Suspect deaths aggregated by date of hospital admission.
deaths_suspects_by_death_date_mx.csv Suspect deaths aggregated by date of death.
deaths_negatives_by_symptoms_date_mx.csv Deaths that tested negative aggregated by date of symptoms onset.
deaths_negatives_by_admission_date_mx.csv Deaths that tested negative aggregated by date of hospital admission.
deaths_negatives_by_death_date_mx.csv Deaths that tested negative aggregated by date of death.

Dates

Date format used is dd/mm/yyyy

How we gather the data

The techniques we use for generating the time series have evolved as the availability of oficial and semi-oficial data has changed.

At first Mexico's Secretaría de Salud published only daily reports (as PDFs) of confirmed and suspected cases.

These files were readily transcribed into more parsable formats by at least a couple of great projects:

Unfortunately these reports did not include deaths for each state in Mexico.

Secretaría de Salud also published an interactive map which included the complete accumulated tolls for each state, which they would update daily at: https://ncov.sinave.gob.mx/mapa.aspx

We would extract the JSON source file used by this map daily, and used that to generate CSV files that include all relevant counts for each state in Mexico as time series.

As of March 20th, this map, and its JSON source file, has been replaced by a new map which only displays information for the different incidence rates, but no total counts.

However, Secretaría de Salud has stared publishing a daily database snapshot, with the disaggregated information for each patient case it studies at https://www.gob.mx/salud/documentos/datos-abiertos-152127

We now use these daily snapshots to generate our different time series.

Missing Data (Affecting only the series generated by date of official publication)

Data for days prior to when this project started running (02-04-2020) were reconstructed from carranco-sga/Mexico-COVID-19, another project that transcribes oficial pdf data into CSV files, with the following caveats:

  1. Missing suspect cases from 29-02-2020 to 13-03-2020, as per carranco-sga/Mexico-COVID-19#1
  2. There is no tracking of negative cases

Incorrect Data (Affecting only the series generated by date of official publication)

On April 12th Secretaría de Salud published data that contradicts the negative cases data published on the day before by showing a reduction in numbers for a few states. This appears to be some sort of error on their part as even their presented numbers for total studied cases fail to add up correctly.

Releases

No releases published

Packages

No packages published