COVID-19 Open Datasets For Brazil

SARS, Flu-Like Syndrome and officially reported COVID-19 datasets.

@kaggle.cprete_covid19_open_datasets_for_brazil

Table List

2 tables(121.44 MB)

Srag 01–06

@kaggle.cprete_covid19_open_datasets_for_brazil.srag_01_06

19.35 MB
217925 rows
143 columns
Only the first 100 columns are shown

nu_notific NU NOTIFIC	dt_notific DT NOTIFIC	sem_not SEM NOT	dt_sin_pri DT SIN PRI	sem_pri SEM PRI	sg_uf_not SG UF NOT	id_regiona ID REGIONA	co_regiona CO REGIONA	id_municip ID MUNICIP	co_mun_not CO MUN NOT	id_unidade ID UNIDADE	co_uni_not CO UNI NOT	cs_sexo CS SEXO	dt_nasc DT NASC	nu_idade_n NU IDADE N	tp_idade TP IDADE	cod_idade COD IDADE	cs_gestant CS GESTANT	cs_raca CS RACA	cs_etinia CS ETINIA	cs_escol_n CS ESCOL N	id_pais ID PAIS	co_pais CO PAIS	sg_uf SG UF	id_rg_resi ID RG RESI	co_rg_resi CO RG RESI	id_mn_resi ID MN RESI	co_mun_res CO MUN RES	cs_zona CS ZONA	surto_sg SURTO SG	nosocomial NOSOCOMIAL	ave_suino AVE SUINO	febre FEBRE	tosse TOSSE	garganta GARGANTA	dispneia DISPNEIA	desc_resp DESC RESP	saturacao SATURACAO	diarreia DIARREIA	vomito VOMITO	outro_sin OUTRO SIN	outro_des OUTRO DES	puerpera PUERPERA	cardiopati CARDIOPATI	hematologi HEMATOLOGI	sind_down SIND DOWN	hepatica HEPATICA	asma ASMA	diabetes DIABETES	neurologic NEUROLOGIC	pneumopati PNEUMOPATI	imunodepre IMUNODEPRE	renal RENAL	obesidade OBESIDADE	out_morbi OUT MORBI	morb_desc MORB DESC	vacina VACINA	dt_ut_dose DT UT DOSE	mae_vac MAE VAC	dt_vac_mae DT VAC MAE	antiviral ANTIVIRAL	tp_antivir TP ANTIVIR	out_antiv OUT ANTIV	dt_antivir DT ANTIVIR	hospital HOSPITAL	dt_interna DT INTERNA	sg_uf_inte SG UF INTE	id_rg_inte ID RG INTE	co_rg_inte CO RG INTE	id_mn_inte ID MN INTE	co_mu_inte CO MU INTE	nm_un_inte NM UN INTE	co_un_inte CO UN INTE	uti UTI	dt_entuti DT ENTUTI	dt_saiduti DT SAIDUTI	suport_ven SUPORT VEN	raiox_res RAIOX RES	raiox_out RAIOX OUT	dt_raiox DT RAIOX	amostra AMOSTRA	dt_coleta DT COLETA	tp_amostra TP AMOSTRA	out_amost OUT AMOST	requi_gal REQUI GAL	if_resul IF RESUL	dt_if DT IF	pos_if_flu POS IF FLU	tp_flu_if TP FLU IF	pos_if_out POS IF OUT	if_para3 IF PARA3
315778971760	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Thu Nov 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	47	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL SANTA CATARINA	2688603	M	Sun Dec 10 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	46	3	3046	6	1	nan	9	BRASIL	1	SP	GVE I CAPITAL	1331	SAO PAULO	355030	1	2	2	2	1	1	2	2	2	2	2	2	1	MIALGIA														nan	9			nan	1	1	nan	2019-11-23 00:00:00	1	2019-11-22 00:00:00	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL SANTA CATARINA	2688603	2	nan		3	9	nan	nan	1	2019-11-22 00:00:00	1	nan		2	Fri Nov 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)
315778983536	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Fri Nov 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	46	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL SANTA CATARINA	2688603	M	Tue May 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	6	2	2006	6	9	nan	5	BRASIL	1	SP	GVE I CAPITAL	1331	SAO PAULO	355030	1	9	9	9	2	1	2	1	1	2	2	2	9	nan	9	9	9	9	9	9	9	9	9	9	9	9	1	TRIGEMELA RNPT 32 SEMANAS	9			nan	2		nan	nan	1	2019-11-21 00:00:00	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL SANTA CATARINA	2688603	1	2019-11-21 00:00:00		2	1	nan	2019-11-21 00:00:00	2	nan		nan
315778997513	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Sat Nov 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	44	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL SANTA CATARINA	2688603	M	Tue Feb 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	9	2	2009	6	9	nan	5	BRASIL	1	SP	GVE I CAPITAL	1331	SAO PAULO	355030	1	9	9	9	2	1	2	1	1	1	2	2	9	nan														nan	9			nan	2		nan	nan	1	2019-11-23 00:00:00	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL SANTA CATARINA	2688603	2	nan		2	9	nan	nan	1	2019-11-23 00:00:00	1	nan		1	Sat Nov 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2		1	1
315779008162	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Wed Nov 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	47	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSPITAL OSWALDO CRUZ	2076950	F	Tue Jan 10 1933 00:00:00 GMT+0000 (Coordinated Universal Time)	86	3	3086	9	9	nan	9	BRASIL	1	SP	GVE I CAPITAL	1331	SAO PAULO	355030	1	9	9	9	1	1	9	1	9	9	9	9	9	nan	9	1	9	9	9	9	9	9	9	9	9	9	9	nan	9			nan	9		nan	nan	1	2019-11-22 00:00:00	nan	nan		nan		nan		2	nan		9	9	nan	nan	1	2019-11-22 00:00:00	1	nan		1	Fri Nov 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	9
315779111812	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Fri Dec 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	52	AC	REGIONAL DO BAIXO ACRE	1938	RIO BRANCO	120040	HOSPITAL GERAL DE CLINICAS DE RIO BRANCO	2001578	F	Sat Jun 01 1957 00:00:00 GMT+0000 (Coordinated Universal Time)	62	3	3062	5	4	nan	3	BRASIL	1	AC	REGIONAL DO BAIXO ACRE	1938	RIO BRANCO	120040	1	2	2	2	1	1	2	1	1	2	2	2	2	nan														nan	2			nan	2		nan	nan	1	2020-01-01 00:00:00	nan	nan		nan		nan		2	nan		2	6	nan	nan	1	2020-01-01 00:00:00	1	nan	200108000001	4
315779601509	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Mon Dec 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSP MUN JABAQUARA ARTUR RIBEIRO DE SABOYA	2081970	M	Fri May 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	2007	6		nan	5	BRASIL	1	SP	GVE I CAPITAL	1331	SAO PAULO	355030	1	9	2	2	1	1	9	1	1	2	2	2	2	nan														nan	2			nan	1	1	nan	2020-01-01 00:00:00	1	2020-01-01 00:00:00	SP	GVE I CAPITAL	1331	SAO PAULO	355030	HOSP MUN JABAQUARA ARTUR RIBEIRO DE SABOYA	2081970	2	nan		2	4	nan	2020-01-01 00:00:00	1	2020-01-01 00:00:00	1	nan	200106000007	4
315779617056	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Sun Dec 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1	PR	09RS FOZ DO IGUACU	1363	FOZ DO IGUACU	410830	HOSPITAL MUNICIPAL PADRE GERMANO LAUCK	5061989	F	Mon Jul 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5	2	2005	6	1	nan	5	BRASIL	1	PR	09RS FOZ DO IGUACU	1363	FOZ DO IGUACU	410830	1	2	2	2	1	1	2	1	1	2	2	1	2	nan														nan			2	nan	2		nan	nan	1	2020-01-02 00:00:00	PR	09RS FOZ DO IGUACU	1363	FOZ DO IGUACU	410830	HOSPITAL MUNICIPAL PADRE GERMANO LAUCK	5061989	2	nan		2	1	nan	2020-01-02 00:00:00	1	2020-01-02 00:00:00	1	nan	200903000010	4
315779653550	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Wed Dec 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	51	BA	NUCLEO REGIONAL DE SAUDE LESTE	1380	SALVADOR	292740	INSTITUTO COUTO MAIA	5428	M	Fri May 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	7	2	2007	6	4	nan	5	BRASIL	1	BA	NUCLEO REGIONAL DE SAUDE LESTE	1380	SALVADOR	292740	1	2	2		1	1	2	1	1	2	2	2	2	nan	2	2	2	2	2	1	2	2	2	2	2	2	2	nan				nan	2		nan	nan	1	2019-12-31 00:00:00	BA	NUCLEO REGIONAL DE SAUDE LESTE	1380	SALVADOR	292740	INSTITUTO COUTO MAIA	5428	1	2019-12-31 00:00:00		2	5	nan	2019-12-29 00:00:00	1	2020-01-01 00:00:00	1	nan		5
315779686594	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Sun Dec 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1	RS	018 CRS	1605	TORRES	432150	HOSPITAL BENEFICENTE NOSSA SENHORA DOS NAVEGANTES	2707950	F	Mon Dec 24 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	35	3	3035	2	1	nan	4	BRASIL	1	RS	002 CRS	1607	PORTO ALEGRE	431490	1	2	2	2	1	1	2	1	1	1	2	2	1	FADIGA	2	2	2	2	2	2	2	2	2	2	2	2	1	GESTANTE	1	Thu Oct 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)		nan	1	1	nan	2019-12-31 00:00:00	1	2019-12-31 00:00:00	RS	018 CRS	1605	TORRES	432150	HOSPITAL BENEFICENTE NOSSA SENHORA DOS NAVEGANTES	2707950	1	2020-01-07 00:00:00	Sat Jan 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	2	nan	nan	1	2019-12-31 00:00:00	1	nan	201817000001	4
315779694324	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Fri Dec 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	52	PR	10RS CASCAVEL	1364	CASCAVEL	410480	HOSPITAL DE ENSINO SAO LUCAS	2738309	M	Sun Aug 23 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	66	3	3066	6	1	nan	1	BRASIL	1	PR	20RS TOLEDO	1374	SANTA HELENA	412350	2	2	2	2	1	2	2	1	1	1	2	2	2	nan	2	2	2	2	2	2	2	2	1	2	2	2	2	nan	9			nan	1	1	nan	2019-12-27 00:00:00	1	2019-12-27 00:00:00	PR	10RS CASCAVEL	1364	CASCAVEL	410480	HOSPITAL DE ENSINO SAO LUCAS	2738309	1	2019-12-27 00:00:00	Mon Jan 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	6	nan	nan	1	2019-12-27 00:00:00	1	nan	201001000015	4


CREATE TABLE srag_01_06 (
  "nu_notific" BIGINT,
  "dt_notific" TIMESTAMP,
  "sem_not" BIGINT,
  "dt_sin_pri" TIMESTAMP,
  "sem_pri" BIGINT,
  "sg_uf_not" VARCHAR,
  "id_regiona" VARCHAR,
  "co_regiona" DOUBLE,
  "id_municip" VARCHAR,
  "co_mun_not" BIGINT,
  "id_unidade" VARCHAR,
  "co_uni_not" BIGINT,
  "cs_sexo" VARCHAR,
  "dt_nasc" TIMESTAMP,
  "nu_idade_n" BIGINT,
  "tp_idade" BIGINT,
  "cod_idade" BIGINT,
  "cs_gestant" BIGINT,
  "cs_raca" DOUBLE,
  "cs_etinia" VARCHAR,
  "cs_escol_n" DOUBLE,
  "id_pais" VARCHAR,
  "co_pais" BIGINT,
  "sg_uf" VARCHAR,
  "id_rg_resi" VARCHAR,
  "co_rg_resi" DOUBLE,
  "id_mn_resi" VARCHAR,
  "co_mun_res" DOUBLE,
  "cs_zona" DOUBLE,
  "surto_sg" DOUBLE,
  "nosocomial" DOUBLE,
  "ave_suino" DOUBLE,
  "febre" DOUBLE,
  "tosse" DOUBLE,
  "garganta" DOUBLE,
  "dispneia" DOUBLE,
  "desc_resp" DOUBLE,
  "saturacao" DOUBLE,
  "diarreia" DOUBLE,
  "vomito" DOUBLE,
  "outro_sin" DOUBLE,
  "outro_des" VARCHAR,
  "puerpera" DOUBLE,
  "cardiopati" DOUBLE,
  "hematologi" DOUBLE,
  "sind_down" DOUBLE,
  "hepatica" DOUBLE,
  "asma" DOUBLE,
  "diabetes" DOUBLE,
  "neurologic" DOUBLE,
  "pneumopati" DOUBLE,
  "imunodepre" DOUBLE,
  "renal" DOUBLE,
  "obesidade" DOUBLE,
  "obes_imc" DOUBLE,
  "out_morbi" DOUBLE,
  "morb_desc" VARCHAR,
  "vacina" DOUBLE,
  "dt_ut_dose" TIMESTAMP,
  "mae_vac" DOUBLE,
  "dt_vac_mae" VARCHAR,
  "m_amamenta" DOUBLE,
  "dt_doseuni" TIMESTAMP,
  "dt_1_dose" TIMESTAMP,
  "dt_2_dose" TIMESTAMP,
  "antiviral" DOUBLE,
  "tp_antivir" DOUBLE,
  "out_antiv" VARCHAR,
  "dt_antivir" VARCHAR,
  "hospital" DOUBLE,
  "dt_interna" VARCHAR,
  "sg_uf_inte" VARCHAR,
  "id_rg_inte" VARCHAR,
  "co_rg_inte" DOUBLE,
  "id_mn_inte" VARCHAR,
  "co_mu_inte" DOUBLE,
  "nm_un_inte" VARCHAR,
  "co_un_inte" DOUBLE,
  "uti" DOUBLE,
  "dt_entuti" VARCHAR,
  "dt_saiduti" TIMESTAMP,
  "suport_ven" DOUBLE,
  "raiox_res" DOUBLE,
  "raiox_out" VARCHAR,
  "dt_raiox" VARCHAR,
  "amostra" DOUBLE,
  "dt_coleta" VARCHAR,
  "tp_amostra" DOUBLE,
  "out_amost" VARCHAR,
  "requi_gal" DOUBLE,
  "if_resul" DOUBLE,
  "dt_if" TIMESTAMP,
  "pos_if_flu" DOUBLE,
  "tp_flu_if" DOUBLE,
  "pos_if_out" DOUBLE,
  "if_vsr" DOUBLE,
  "if_para1" DOUBLE,
  "if_para2" DOUBLE,
  "if_para3" DOUBLE,
  "if_adeno" DOUBLE
);