Mexico COVID-19 Clinical Data
Epidemiology data for positive and negative COVID-19 cases in Mexico.
@kaggle.marianarfranklin_mexico_covid19_clinical_data
Epidemiology data for positive and negative COVID-19 cases in Mexico.
@kaggle.marianarfranklin_mexico_covid19_clinical_data
Note: I have preserved the original structure (column names and factors) as closely as possible to the official data, so that code is reproducible in cross-reference to the official sources.
CREATE TABLE mexico_covid19 (
"id" BIGINT,
"fecha_archivo" TIMESTAMP,
"id_registro" VARCHAR,
"entidad_um" BIGINT,
"entidad_res" BIGINT,
"resultado" BIGINT,
"delay" BIGINT,
"entidad_registro" BIGINT,
"entidad" VARCHAR,
"abr_ent" VARCHAR,
"fecha_actualizacion" TIMESTAMP,
"origen" BIGINT,
"sector" BIGINT,
"sexo" BIGINT,
"entidad_nac" BIGINT,
"municipio_res" DOUBLE,
"tipo_paciente" BIGINT,
"fecha_ingreso" TIMESTAMP,
"fecha_sintomas" TIMESTAMP,
"fecha_def" VARCHAR,
"intubado" BIGINT,
"neumonia" BIGINT,
"edad" BIGINT,
"nacionalidad" BIGINT,
"embarazo" BIGINT,
"habla_lengua_indig" BIGINT,
"diabetes" BIGINT,
"epoc" BIGINT,
"asma" BIGINT,
"inmusupr" BIGINT,
"hipertension" BIGINT,
"otra_com" BIGINT,
"cardiovascular" BIGINT,
"obesidad" BIGINT,
"renal_cronica" BIGINT,
"tabaquismo" BIGINT,
"otro_caso" BIGINT,
"migrante" BIGINT,
"pais_nacionalidad" VARCHAR,
"pais_origen" VARCHAR,
"uci" BIGINT
);Anyone who has the link will be able to view this.