Registration, area, economic activity, and responsibility records for Brazilian construction works.
Retrieve this dataset with query_dataset() using the name "cno".
cno <- query_dataset("cno")
cno$constructionsDetails
Source: Receita Federal do Brasil - Cadastro Nacional de Obras
URL: https://dados.gov.br/dados/conjuntos-dados/cadastro-nacional-de-obras-cno
Geography: Brazil
Frequency: annual snapshots
Coverage: November 2018-present, including migrated CEI records with earlier start dates
Access mode:
queryTables:
"constructions","areas","cnaes","responsibilities"
Column names are normalized to English and text is trimmed. Mechanical source defects are fixed: 1900-01-01 sentinel dates and invalid Plus Codes become NA, and exact duplicate area rows are dropped. Each fix is counted in the snapshot manifest. Valid but anomalous values, such as area outliers and unusual state labels, are retained.
Table "constructions" (Constructions)
One row per CNO registration.
- cno
Twelve-digit CNO registration identifier. Stored as character to preserve leading zeroes.
- country_code
Three-digit country code published by Receita Federal.
- country_name
Country name published by Receita Federal.
- start_date
Declared start date of the construction work. The 1900-01-01 sentinel is converted to NA.
- responsibility_start_date
Start date of the current responsibility period.
- registration_date
Date on which the work was registered in CNO.
- linked_cno
Linked CNO registration when supplied by Receita Federal.
- postal_code
Postal code for works in Brazil. Stored as character.
- responsible_tax_id
Fourteen-digit identifier of the responsible legal person. Receita Federal suppresses CPF values.
- responsible_role_code
Four-digit code for the responsible party's role.
- construction_name
Name assigned to the construction, not the responsible party's name.
- municipality_tom_code
Four-digit Receita Federal TOM municipality code, not an IBGE municipality code. See code_muni.
- municipality_name
Municipality name published by Receita Federal.
- street_type
Street type.
- street_name
Street name.
- street_number
Street number or other source value such as S/N.
- neighborhood
Neighborhood name.
- state
State field as published. Usually a two-letter UF abbreviation; source anomalies are retained.
- postal_box
Postal box for works outside Brazil.
- address_complement
Additional address information.
- measurement_unit
Unit used to measure the work.
- total_area
Total measurement reported for the work, expressed in measurement_unit. Source outliers are retained.
- status_code
Two-digit CNO status code.
- status_date
Date associated with the current status.
- responsible_legal_name
Legal name of the responsible legal person when published.
- plus_code
Plus Code (Open Location Code) in upper case. Full and short codes are kept; values that are not valid Plus Codes, such as 00000000+00, are converted to NA.
- code_muni
Seven-digit IBGE municipality code, joined from the Receita Federal TOM-to-IBGE table. Compatible with geobr. NA for works abroad and for TOM codes missing from that table.
Table "areas" (Construction Areas)
Area records classified by category, destination, structure, and area type.
- cno
CNO registration identifier joining to constructions.cno.
- construction_category
Category reported for the construction area.
- destination
Intended use reported for the work area.
- structure_type
Construction structure type.
- area_type
Principal or complementary area.
- complementary_area_type
Complementary-area classification, when applicable.
- area
Reported area in square metres. Exact duplicate rows are dropped; outliers are retained.
Table "cnaes" (Economic Activities)
CNAE economic activities associated with each construction work.
- cno
CNO registration identifier joining to constructions.cno.
- cnae
Seven-digit CNAE activity code. Stored as character.
- registration_date
Date on which the activity was registered.
Table "responsibilities" (Responsibility Periods)
Responsible-party roles and their periods for each construction work.
- cno
CNO registration identifier joining to constructions.cno.
- start_date
Start date of the responsibility period.
- end_date
End date of the responsibility period, when applicable.
- registration_date
Date on which the responsibility was registered.
- responsible_role_code
Four-digit code for the responsible party's role.
- responsible_tax_id
Fourteen-digit identifier of the responsible legal person. Receita Federal suppresses CPF values.
See also
get_dataset(), query_dataset(), list_datasets(), get_dataset_info()
Other datasets:
abecip,
abrainc,
bcb_realestate,
bcb_series,
cement,
fgv_ibre,
mcmv,
paic,
pim_pf_construction,
pnad_housing,
rppi,
rppi_bis,
secovi,
siconfi_taxes,
sinapi