Name: CBHPM 2008/2010 Brazilian Codes Medical Procedures
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

CBHPM 2008/2010 Brazilian Codes Medical Procedures

Part of Mobile Medical App MEDcodigos TUSS SUS CID CBHPM, the great database of medical codes in Brazil , give you all information from Public Unique Health System procedures table (SIGTAP SUS) and Private Hierarchic Brazilian Medical Procedure table CBHPM/TUSS used for Private Supplementary H Health System.

4415 medical procedures with 51 characteristically info for single one procedure , based in CBHPM Brazilian Medical Association biannual publication.

Dr Eric Grossi MD Neurosurgeon and Rookie developer in JS, C# an Xamarin

Tables

Cbhpm0810set2020

@kaggle.medcodigos_cbhpm_20082010_brazilian_codes_medical_procedures.cbhpm0810set2020

478.97 kB
4,415 rows
52 columns

CREATE TABLE cbhpm0810set2020 (
  "codigo" BIGINT,
  "rol_ans_18" VARCHAR,
  "procedimento" VARCHAR,
  "porte" VARCHAR,
  "aux" VARCHAR,
  "porte_anestesico" VARCHAR,
  "vanest08" VARCHAR,
  "vanest10" VARCHAR,
  "vporte08" VARCHAR,
  "vporte10" VARCHAR,
  "uco" VARCHAR,
  "especialidade" VARCHAR,
  "valor_total08" VARCHAR,
  "valortotal10" VARCHAR,
  "esp_sub" VARCHAR,
  "subgrupo" VARCHAR,
  "pac" VARCHAR,
  "dutn" DOUBLE,
  "linkdut" VARCHAR,
  "site" VARCHAR,
  "imagem1" VARCHAR,
  "imagem2" VARCHAR,
  "filmem2" VARCHAR,
  "vfilmetotal08_10" VARCHAR,
  "vuco08" VARCHAR,
  "vuco10" VARCHAR,
  "vaux108" VARCHAR,
  "vaux208" VARCHAR,
  "vaux308" VARCHAR,
  "vcirurg_ncia08" VARCHAR,
  "vapart08" VARCHAR,
  "vanestaux08" VARCHAR,
  "anesimtaux" VARCHAR,
  "v1aux10" VARCHAR,
  "v2aux10" VARCHAR,
  "v3aux10" VARCHAR,
  "vurg_ncia10" VARCHAR,
  "vapart10" VARCHAR,
  "vanestaux10" VARCHAR,
  "vproced_acesso08" VARCHAR  -- Vproced\u003dacesso08,
  "vprocdifacesso08" VARCHAR,
  "vproced_acesso10" VARCHAR  -- Vproced\u003dacesso10,
  "vprocdifacesso10" VARCHAR,
  "marcado" BOOLEAN,
  "fav" VARCHAR,
  "ultratop" VARCHAR,
  "codsus" DOUBLE,
  "descsus" VARCHAR,
  "proced2" VARCHAR,
  "codtuss2" BIGINT,
  "codamb92" DOUBLE,
  "cidsus" VARCHAR
);