ITR — Balanço patrimonial: passivo e patrimônio líquido individual
Stable ID: cvm.cia_aberta.cia_aberta_itr/bpp_ind
Contexto semântico
Nome: ITR — Balanço patrimonial: passivo e patrimônio líquido individual
O que contém: Passivo e patrimônio líquido do balanço trimestral individual.
Por que consultar: Use para acompanhar as obrigações e o capital próprio da companhia isolada.
Escopo e limitações: Preserve visão individual, período e ordem do exercício.
Aliases e nomes oficiais: BPP_IND, bpp_ind, Passivo individual
Evidências:
catalogo/cvm.yml — cia_aberta_itr/bpp_indhttps://dados.cvm.gov.br/dataset/cia_aberta-doc-itr
Comece aqui: guia de acesso aos dados
Readiness (label, not a promise): declared:tolerada_com_residuo · materialized:none · queryable:unknown
Declared (catalog YAML)
| field | value |
|---|---|
dataset |
cia_aberta_itr |
| parte unica layout | zip_multi_tabela |
parte unica vigencia |
ate=(unknown — not declared anywhere), de=(unknown — not declared anywhere) |
chave (parte unica) |
cnpj_cia, dt_refer, versao, cd_conta, ds_conta, ordem_exerc |
chave_status (parte unica, declared) |
tolerada_com_residuo |
max_linhas_excedentes (parte unica) |
10000 |
max_grupos_residuais (parte unica) |
22 |
politica_dedup_silver (parte unica) |
keep_first |
source URL (parte unica) |
https://dados.cvm.gov.br/dados/CIA_ABERTA/DOC/ITR/DADOS/itr_cia_aberta_{aaaa}.zip |
Operator notes (verbatim from the catalog comments)
parte unica
# TOLERADA_COM_RESIDUO (re-medido com probe_dataset direto, chave final):
# 2024 = 487.974 linhas, excess exato=6.989 (5.166 grupos exatos), 14
# grupos RESIDUAIS (VL_CONTA diverge no mesmo cnpj_cia+dt_refer+versao+
# cd_conta+ds_conta+ordem_exerc — valores contraditos pela CVM, ver
# _residuos.json — corrige o numero de grupos residuais citado num
# comentario anterior, 16); 2025 = 1.070 excess exato, 0 residuais. Cap
# excesso exato 10.000 (~1,4x o maximo medido, 6.989); cap grupos
# residuais 22 (2024 mediu 14). Ver ARCHITECTURE.md Sec 6.12 (chave_status contract).
Observed runs (from meta/runs manifests)
Last good run:
| field | value |
|---|---|
timestamp |
20260820T030155 |
outcome |
written |
exit_code |
0 |
rows_written |
3640994 |
source_sha256 |
|
manifest_path |
C:\Users\plini\Repos\ciano-lake\data\meta\runs\cia_aberta_itr\20260820T030155.json |
competencia (scoped) |
(unscoped — not period-specific proof) |
Latest failed attempt (kept distinct from the last good run):
| field | value |
|---|---|
timestamp |
20260818T141332 |
outcome |
error |
exit_code |
1 |
error |
bpa_con: Quality check failed: [PASS] row_count: 181,678 rows (validates > 0) |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/181,678 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/181,678 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/181,678 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/181,678 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/181,678 null/empty (0.00%) | |
| [FAIL] uniqueness: 256 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (181,678 total, 181,422 distinct); bpa_ind: Quality check failed: [PASS] row_count: 276,195 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/276,195 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/276,195 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/276,195 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/276,195 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/276,195 null/empty (0.00%) | |
| [FAIL] uniqueness: 622 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (276,195 total, 275,573 distinct); bpp_con: Quality check failed: [PASS] row_count: 310,302 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/310,302 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/310,302 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/310,302 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/310,302 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/310,302 null/empty (0.00%) | |
| [FAIL] uniqueness: 440 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (310,302 total, 309,862 distinct); bpp_ind: Quality check failed: [PASS] row_count: 465,952 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/465,952 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/465,952 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/465,952 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/465,952 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/465,952 null/empty (0.00%) | |
| [FAIL] uniqueness: 1,070 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (465,952 total, 464,882 distinct); dfc_md_ind: Quality check failed: [PASS] row_count: 1,795 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/1,795 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/1,795 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/1,795 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/1,795 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/1,795 null/empty (0.00%) | |
| [FAIL] uniqueness: 14 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (1,795 total, 1,781 distinct); dfc_mi_con: Quality check failed: [PASS] row_count: 139,342 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/139,342 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/139,342 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/139,342 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/139,342 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/139,342 null/empty (0.00%) | |
| [FAIL] uniqueness: 122 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (139,342 total, 139,220 distinct); dfc_mi_ind: Quality check failed: [PASS] row_count: 189,402 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/189,402 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/189,402 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/189,402 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/189,402 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/189,402 null/empty (0.00%) | |
| [FAIL] uniqueness: 242 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (189,402 total, 189,160 distinct); dmpl_con: Quality check failed: [PASS] row_count: 623,847 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/623,847 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/623,847 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/623,847 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/623,847 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/623,847 null/empty (0.00%) | |
| [FAIL] uniqueness: 546,201 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (623,847 total, 77,646 distinct); dmpl_ind: Quality check failed: [PASS] row_count: 700,872 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/700,872 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/700,872 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/700,872 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/700,872 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/700,872 null/empty (0.00%) | |
| [FAIL] uniqueness: 585,046 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (700,872 total, 115,826 distinct); dra_con: Quality check failed: [PASS] row_count: 32,114 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/32,114 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/32,114 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/32,114 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/32,114 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/32,114 null/empty (0.00%) | |
| [FAIL] uniqueness: 12,864 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (32,114 total, 19,250 distinct); dra_ind: Quality check failed: [PASS] row_count: 33,000 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/33,000 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/33,000 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/33,000 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/33,000 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/33,000 null/empty (0.00%) | |
| [FAIL] uniqueness: 13,208 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (33,000 total, 19,792 distinct); dre_con: Quality check failed: [PASS] row_count: 156,900 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/156,900 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/156,900 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/156,900 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/156,900 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/156,900 null/empty (0.00%) | |
| [FAIL] uniqueness: 62,656 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (156,900 total, 94,244 distinct); dre_ind: Quality check failed: [PASS] row_count: 226,309 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/226,309 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/226,309 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/226,309 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/226,309 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/226,309 null/empty (0.00%) | |
| [FAIL] uniqueness: 90,403 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (226,309 total, 135,906 distinct); dva_con: Quality check failed: [PASS] row_count: 116,854 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/116,854 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/116,854 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/116,854 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/116,854 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/116,854 null/empty (0.00%) | |
| [FAIL] uniqueness: 200 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (116,854 total, 116,654 distinct); dva_ind: Quality check failed: [PASS] row_count: 173,507 rows (validates > 0) | |
| [PASS] null_rate_cnpj_cia: cnpj_cia: 0/173,507 null/empty (0.00%) | |
| [PASS] null_rate_dt_refer: dt_refer: 0/173,507 null/empty (0.00%) | |
| [PASS] null_rate_versao: versao: 0/173,507 null/empty (0.00%) | |
| [PASS] null_rate_cd_conta: cd_conta: 0/173,507 null/empty (0.00%) | |
| [PASS] null_rate_ordem_exerc: ordem_exerc: 0/173,507 null/empty (0.00%) | |
| [FAIL] uniqueness: 432 duplicate rows on key [cnpj_cia, dt_refer, versao, cd_conta, ordem_exerc] (173,507 total, 173,075 distinct) | |
manifest_path |
C:\Users\plini\Repos\ciano-lake\data\meta\runs\cia_aberta_itr\20260818T141332.json |
competencia (scoped) |
(unscoped) |
Observed residuals (tolerada_com_residuo evidence)
(none observed — either the table has no residual tolerance, or the coverage inventory has not run; absence is not proof of absence)
Materialized (coverage inventory, per environment)
(no coverage inventory available — run tools/coverage_inventory.py collect and pass the JSONL to the publisher; without it nothing is claimed about what physically exists)
Postgres-queryable
(unknown — publication state is a publisher fact, filled at publication time; it is never inferred from materialization)