ITR — Resultado abrangente consolidado
Stable ID: cvm.cia_aberta.cia_aberta_itr/dra_con
Contexto semântico
Nome: ITR — Resultado abrangente consolidado
O que contém: Linhas trimestrais do resultado abrangente em apresentação consolidada.
Por que consultar: Use para acompanhar efeitos abrangentes além do resultado do grupo.
Escopo e limitações: Não substitui a DRE consolidada.
Aliases e nomes oficiais: DRA_CON, dra_con, Resultado abrangente consolidado
Evidências:
catalogo/cvm.yml — cia_aberta_itr/dra_conhttps://dados.cvm.gov.br/dataset/cia_aberta-doc-itr
Comece aqui: guia de acesso aos dados
Readiness (label, not a promise): declared:tolerada · 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, dt_ini_exerc |
chave_status (parte unica, declared) |
tolerada |
max_linhas_excedentes (parte unica) |
500 |
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 (medido 2024/2025): chave ALARGADA com dt_ini_exerc —
# ITR traz 3 trimestres + comparativo no mesmo arquivo e a CVM
# falha em deixar cd_conta consistente entre eles (antes 13.386
# excess em 2024 e 12.864 em 2025, com grupos NAO exatos; agora
# fecha). 2024 = 256
# excess, 100% exatos; 2025 = 22 excess, 100% exatos. Cap 500 =
# ~2x o maximo medido. dt_ini_exerc com 0 nulos.
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)