For the historic files from 12 April 2020 check my repo: Covid-19 Mexico public information

Context

Official posted data from the Mexican Health Department.

Content

Confirmed cases -> casos_confirmados

Suspicious cases -> casos_sospechosos

Complete information -> covid-19_general_MX

Acknowledgements

Secretaría de Salud - Mexican Gobernment:
covid-19_general latest published information

historic covid-19_general

Independent suspicious and confirmed cases files stopped being distributed by the government on April 18th 2020 I'll add them again in case they publish them.

Tables

Casos Confirmados

@kaggle.lalish99_covid19_mx.casos_confirmados

2.58 MB
370712 rows
6 columns


CREATE TABLE casos_confirmados (
  "unnamed_0" BIGINT,
  "state" VARCHAR,
  "sex" VARCHAR,
  "age" BIGINT,
  "date" TIMESTAMP,
  "confirmed" BIGINT
);

Covid 19 General Mx

@kaggle.lalish99_covid19_mx.covid_19_general_mx

9.53 MB
879608 rows
26 columns


CREATE TABLE covid_19_general_mx (
  "unnamed_0" BIGINT,
  "sector" BIGINT,
  "entidad_um" BIGINT,
  "sexo" BIGINT,
  "entidad_res" BIGINT,
  "tipo_paciente" BIGINT,
  "fecha_ingreso" TIMESTAMP,
  "fecha_sintomas" TIMESTAMP,
  "fecha_def" VARCHAR,
  "intubado" BIGINT,
  "neumonia" BIGINT,
  "edad" BIGINT,
  "nacionalidad" BIGINT,
  "diabetes" BIGINT,
  "epoc" BIGINT,
  "asma" BIGINT,
  "inmusupr" BIGINT,
  "hipertension" BIGINT,
  "otra_con" BIGINT,
  "cardiovascular" BIGINT,
  "obesidad" BIGINT,
  "renal_cronica" BIGINT,
  "tabaquismo" BIGINT,
  "otro_caso" BIGINT,
  "resultado" BIGINT,
  "uci" BIGINT
);

Covid Mx

@kaggle.lalish99_covid19_mx.covid_mx

5.55 KB
147 rows
3 columns


CREATE TABLE covid_mx (
  "confirmed_cases" BIGINT,
  "deceased" BIGINT,
  "dates" TIMESTAMP
);

Entidades

@kaggle.lalish99_covid19_mx.entidades

3.67 KB
36 rows
3 columns


CREATE TABLE entidades (
  "clave_entidad" BIGINT,
  "entidad_federativa" VARCHAR,
  "abreviatura" VARCHAR
);

Nacionalidad

@kaggle.lalish99_covid19_mx.nacionalidad

2.17 KB
3 rows
2 columns


CREATE TABLE nacionalidad (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);

Origen

@kaggle.lalish99_covid19_mx.origen

2.16 KB
3 rows
2 columns


CREATE TABLE origen (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);

Resultado

@kaggle.lalish99_covid19_mx.resultado

2.23 KB
3 rows
2 columns


CREATE TABLE resultado (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);

Sector

@kaggle.lalish99_covid19_mx.sector

2.33 KB
14 rows
2 columns


CREATE TABLE sector (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);

Sexo

@kaggle.lalish99_covid19_mx.sexo

2.16 KB
3 rows
2 columns


CREATE TABLE sexo (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);

Si No

@kaggle.lalish99_covid19_mx.si_no

2.14 KB
5 rows
2 columns


CREATE TABLE si_no (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);

Tipo Paciente

@kaggle.lalish99_covid19_mx.tipo_paciente

2.18 KB
3 rows
2 columns


CREATE TABLE tipo_paciente (
  "clave" BIGINT,
  "descripci_n" VARCHAR
);