# CNES: Datapackage

resources:
  - name: TB_ESTABELECIMENTO
    description: >
      LFCES004
      Estabelecimentos de Saúde
    path: "./"
    profile: tabular-data-resource
    schema:
      fields:
        - name: CO_ATIVIDADE
          type: string
          _type_pandas: cateogry
          _type_sql: CHAR(2)
        - name: CO_ATIVIDADE_PRINCIPAL
          type: Int64
          _type_sql: VARCHAR2(3)
        - name: CO_CEP
          type: Int64
          _type_sql: VARCHAR2(8)
        - name: CO_CLIENTELA
          type: Int64
          _type_sql: CHAR(2)
        - name: CO_CNES
          type: Int64
          _type_sql: VARCHAR2(7)
        - name: CO_CPFDIRETORCLN
          type: Int64
          _type_sql: VARCHAR2(11)
        - name: CO_DISTRITO_ADMINISTRATIVO
          type: category
          # _type_sql: 
        - name: CO_DISTRITO_SANITARIO
          type: category
          # _type_sql: 
        - name: CO_ESTADO_GESTOR
          type: Int64
          # _type_sql: 
        - name: CO_MICRO_REGIAO
          type: category
          # _type_sql: 
        - name: CO_MOTIVO_DESAB
          type: Int64
          # _type_sql: 
        - name: CO_MUNICIPIO_GESTOR
          type: Int64
          # _type_sql: 
        - name: CO_NATUREZA_JUR
          type: Int64
          # _type_sql: 
        - name: CO_REGIAO_SAUDE
          type: category
          # _type_sql: 
        - name: CO_TIPO_ESTABELECIMENTO
          type: Int64
          # _type_sql: 
        - name: CO_TIPO_UNIDADE
          type: Int64
          # _type_sql: 
        - name: CO_TURNO_ATENDIMENTO
          type: Int64
          # _type_sql: 
        - name: CO_UNIDADE
          type: category
          # _type_sql: 
        - name: CO_USUARIO
          type: category
          # _type_sql: 
        - name: DT_ATUALIZACAO
          type: datetime64[D]
          format: "%d/%m/%Y"
          # _type_sql: 
        - name: DT_ATUALIZACAO_ORIGEM
          type: datetime64[D]
          format: "%d/%m/%Y"
          # _type_sql: 
        - name: DT_ATU_GEO
          type: datetime64[D]
          format: "%d/%m/%Y"
          # _type_sql: 
        # - name: DT_EXPEDICAO
        #   type: datetime64[D]
        #   format: "%d/%m/%Y"
        #  # _type_sql: 
        # - name: DT_VAL_LIC_SANI
        #   type: datetime64[D]
        #   format: "%d/%m/%Y"
        #  # _type_sql: 
        - name: NIVEL_DEP
          type: Int64
          # _type_sql: 
        - name: NO_BAIRRO
          type: category
          # _type_sql: 
        - name: NO_COMPLEMENTO
          type: string_
          # _type_sql: 
        - name: NO_EMAIL
          type: category
          # _type_sql: 
        - name: NO_FANTASIA
          type: category
          # _type_sql: 
        - name: NO_FANTASIA_ABREV
          type: string_
          # _type_sql: 
        - name: NO_LOGRADOURO
          type: string_
          # _type_sql: 
        - name: NO_RAZAO_SOCIAL
          type: string_
          # _type_sql: 
        - name: NO_URL
          type: string_
          # _type_sql: 
        - name: NO_USUARIO_GEO
          type: category
          # _type_sql: 
        - name: NU_ALVARA
          type: string_
          # _type_sql: 
        - name: NU_CNPJ
          type: category
          # _type_sql: 
        - name: NU_CNPJ_MANTENEDORA
          type: string
          _type_pandas: U
          _type_sql: char(14)
        - name: NU_CPF
          type: category
          # _type_sql: 
        - name: NU_ENDERECO
          type: string_
          # _type_sql: 
        - name: NU_FAX
          type: string_
          # _type_sql: 
        - name: NU_LATITUDE
          type: string_
          # _type_sql: 
        - name: NU_LONGITUDE
          type: string_
          # _type_sql: 
        - name: NU_TELEFONE
          type: string_
          # _type_sql: 
        - name: REG_DIRETORCLN
          type: string_
          # _type_sql: 
        - name: ST_ADESAO_FILANTROP
          type: string_
          # _type_sql: 
        - name: ST_CONEXAO_INTERNET
          type: string_
          # _type_sql: 
        - name: ST_CONTRATO_FORMALIZADO
          type: string_
          # _type_sql: 
        - name: ST_GERACREDITO_GERENTE_SGIF
          type: string_
          # _type_sql: 
        - name: TP_ESTAB_SEMPRE_ABERTO
          type: category
          # _type_sql: 
        - name: TP_GESTAO
          type: category
          # _type_sql: 
        - name: TP_LIC_SANI
          type: category
          # _type_sql: 
        - name: TP_ORGAO_EXPEDIDOR
          type: category
          # _type_sql: 
        - name: TP_PFPJ
          type: category
          # _type_sql: 
        - name: TP_UNIDADE
          type: category
          # _type_sql: