ITR — Demonstração do valor adicionado individual
Stable ID: cvm.cia_aberta.cia_aberta_itr/dva_ind
Contexto semântico
Nome: ITR — Demonstração do valor adicionado individual
O que contém: Valor gerado e distribuído pela companhia na divulgação trimestral individual.
Por que consultar: Use para acompanhar a distribuição de valor da entidade isolada.
Escopo e limitações: Preserve a visão individual e a competência trimestral.
Aliases e nomes oficiais: DVA_IND, dva_ind, Valor adicionado individual
Evidências:
catalogo/cvm.yml — cia_aberta_itr/dva_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) |
1800 |
max_grupos_residuais (parte unica) |
10 |
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 2026-09-08 noite, zips atuais no
# servidor): 2017 = 1 + 1; 2021 = 113 exatas + 6 residuais; 2023 =
# 1.532 exatas + 0 residuais (1.210 grupos). O cap 150 veio das
# medicoes 2017/2021 isoladas — 2023 estava escondida atras de
# sumario truncado. Caps 1.800/10.
# TOLERADA_COM_RESIDUO (re-medido 2026-09-08, zips atuais 2017/2021
# no servidor): 2017 (congelado) = 2 excess (1 exato + 1 residual
# VL_CONTA); 2021 = 119 (113 + 6). Status saiu de tolerada. Caps
# 150/10 (era 3.000/—).
# TOLERADA (medido 2024/2025): 2024 = 2.700 excess, 100% exatos;
# 2025 = 432 excess, 100% exatos. Cap 3.000 = ~1,1x o maximo
# medido. dt_ini_exerc no fecha.
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)