SIH/SUS - Hospital Admissions Municipalities 2024
Monthly 2024 hospital admissions by municipality in Brazil for health analysis.
@kaggle.andersonfranca_sistema_de_informaes_hospitalares_sus
Monthly 2024 hospital admissions by municipality in Brazil for health analysis.
@kaggle.andersonfranca_sistema_de_informaes_hospitalares_sus
CREATE TABLE rd202401 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202411 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" VARCHAR,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202409 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" VARCHAR,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202407 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202404 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202402 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202403 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202406 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202405 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202410 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" VARCHAR,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202408 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" BIGINT,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
CREATE TABLE rd202412 (
"uf_zi" BIGINT,
"ano_cmpt" BIGINT,
"mes_cmpt" BIGINT,
"espec" BIGINT,
"cgc_hosp" DOUBLE,
"n_aih" BIGINT,
"ident" BIGINT,
"cep" BIGINT,
"munic_res" BIGINT,
"nasc" BIGINT,
"sexo" BIGINT,
"uti_mes_in" BIGINT,
"uti_mes_an" BIGINT,
"uti_mes_al" BIGINT,
"uti_mes_to" BIGINT,
"marca_uti" BIGINT,
"uti_int_in" BIGINT,
"uti_int_an" BIGINT,
"uti_int_al" BIGINT,
"uti_int_to" BIGINT,
"diar_acom" BIGINT,
"qt_diarias" BIGINT,
"proc_solic" BIGINT,
"proc_rea" BIGINT,
"val_sh" DOUBLE,
"val_sp" DOUBLE,
"val_sadt" DOUBLE,
"val_rn" DOUBLE,
"val_acomp" DOUBLE,
"val_ortp" DOUBLE,
"val_sangue" DOUBLE,
"val_sadtsr" DOUBLE,
"val_transp" DOUBLE,
"val_obsang" DOUBLE,
"val_ped1ac" DOUBLE,
"val_tot" DOUBLE,
"val_uti" DOUBLE,
"us_tot" DOUBLE,
"dt_inter" BIGINT,
"dt_saida" BIGINT,
"diag_princ" VARCHAR,
"diag_secun" BIGINT,
"cobranca" BIGINT,
"natureza" BIGINT,
"nat_jur" BIGINT,
"gestao" BIGINT,
"rubrica" BIGINT,
"ind_vdrl" BIGINT,
"munic_mov" BIGINT,
"cod_idade" BIGINT,
"idade" BIGINT,
"dias_perm" BIGINT,
"morte" BIGINT,
"nacional" BIGINT,
"num_proc" VARCHAR,
"car_int" BIGINT,
"tot_pt_sp" BIGINT,
"cpf_aut" VARCHAR,
"homonimo" BIGINT,
"num_filhos" BIGINT,
"instru" BIGINT,
"cid_notif" VARCHAR,
"contracep1" BIGINT,
"contracep2" BIGINT,
"gestrisco" BIGINT,
"insc_pn" BIGINT,
"seq_aih5" BIGINT,
"cbor" BIGINT,
"cnaer" BIGINT,
"vincprev" BIGINT,
"gestor_cod" BIGINT,
"gestor_tp" BIGINT,
"gestor_cpf" BIGINT,
"gestor_dt" VARCHAR,
"cnes" BIGINT,
"cnpj_mant" DOUBLE,
"infehosp" VARCHAR,
"cid_asso" BIGINT,
"cid_morte" BIGINT,
"complex" BIGINT,
"financ" BIGINT,
"faec_tp" DOUBLE,
"regct" BIGINT,
"raca_cor" BIGINT,
"etnia" VARCHAR,
"sequencia" BIGINT,
"remessa" VARCHAR,
"aud_just" VARCHAR,
"sis_just" VARCHAR,
"val_sh_fed" DOUBLE,
"val_sp_fed" DOUBLE,
"val_sh_ges" DOUBLE,
"val_sp_ges" DOUBLE,
"val_uci" DOUBLE,
"marca_uci" BIGINT,
"diagsec1" VARCHAR,
"diagsec2" VARCHAR,
"diagsec3" VARCHAR,
"diagsec4" VARCHAR,
"diagsec5" VARCHAR
);
Anyone who has the link will be able to view this.