Name: COVID-19 MX
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

COVID-19 MX

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.71 MB
370,712 rows
6 columns

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

Covid 19 General Mx

@kaggle.lalish99_covid19_mx.covid_19_general_mx

9.99 MB
879,608 rows
26 columns

CREATE TABLE covid_19_general_mx (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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.68 kB
147 rows
3 columns

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

Entidades

@kaggle.lalish99_covid19_mx.entidades

3.75 kB
36 rows
3 columns

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

Nacionalidad

@kaggle.lalish99_covid19_mx.nacionalidad

2.23 kB
3 rows
2 columns

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

Origen

@kaggle.lalish99_covid19_mx.origen

2.21 kB
3 rows
2 columns

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

Resultado

@kaggle.lalish99_covid19_mx.resultado

2.29 kB
3 rows
2 columns

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

Sector

@kaggle.lalish99_covid19_mx.sector

2.39 kB
14 rows
2 columns

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

Sexo

@kaggle.lalish99_covid19_mx.sexo

2.21 kB
3 rows
2 columns

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

Si No

@kaggle.lalish99_covid19_mx.si_no

2.19 kB
5 rows
2 columns

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

Tipo Paciente

@kaggle.lalish99_covid19_mx.tipo_paciente

2.24 kB
3 rows
2 columns

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