COVID-19 Brazilian Hospitals Clinical Data
Clinical data from 3 major hospitals in Brazil.
@kaggle.andrewmvd_covid19_brazil_hospitals
Clinical data from 3 major hospitals in Brazil.
@kaggle.andrewmvd_covid19_brazil_hospitals
CREATE TABLE hiae_clinical_exams (
"id_paciente" BIGINT,
"dt_coleta" TIMESTAMP,
"de_origem" VARCHAR,
"de_exame" VARCHAR,
"de_analito" VARCHAR,
"de_resultado" VARCHAR,
"cd_unidade" VARCHAR,
"de_valor_referencia" VARCHAR
);
CREATE TABLE hiae_patients (
"id_paciente" BIGINT,
"ic_sexo" VARCHAR,
"aa_nascimento" BIGINT,
"cd_pais" VARCHAR,
"cd_uf" VARCHAR,
"cd_municipio" VARCHAR,
"cd_distrito" VARCHAR
);
CREATE TABLE hsl_clinical_exams (
"id_paciente" VARCHAR,
"id_atendimento" VARCHAR,
"dt_coleta" VARCHAR,
"de_origem" VARCHAR,
"de_exame" VARCHAR,
"de_analito" VARCHAR,
"de_resultado" VARCHAR,
"cd_unidade" VARCHAR,
"de_valor_referencia" VARCHAR
);
CREATE TABLE hsl_encounters (
"id_paciente" VARCHAR,
"id_atendimento" VARCHAR,
"dt_atendimento" VARCHAR,
"de_tipo_atendimento" VARCHAR,
"id_clinica" BIGINT,
"de_clinica" VARCHAR,
"dt_desfecho" VARCHAR,
"de_desfecho" VARCHAR
);
CREATE TABLE hsl_patients (
"id_paciente" VARCHAR,
"ic_sexo" VARCHAR,
"aa_nascimento" BIGINT,
"cd_pais" VARCHAR,
"cd_uf" VARCHAR,
"cd_municipio" VARCHAR,
"cd_distrito" VARCHAR
);
Anyone who has the link will be able to view this.