DBT Source: Extra Cnpj Dict
File location: s3://trase-storage/brazil/dictionaries/extra_cnpj_dict.csv
DBT source: trase-storage-raw.extra_cnpj_dict
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
No description
Details
| Column | Type | Description |
|---|---|---|
CNPJ |
VARCHAR |
|
COMPANY |
VARCHAR |
|
LEVEL |
VARCHAR |
|
GEOCODE |
VARCHAR |
IBGE's seven-digit code of the municipality the tax number is registered in, or 0 where it is not known. The Brazil soy model prefixes it with BR- to make the tax municipality's Trase ID, and reads every input against the 2023 municipal map whatever the year (see MUNICIPALITIES_ON_THE_2024_MAP in trase/models/brazil/soy_2023_2024_v27/constants.py), so it is checked against the 2023 edition of IBGE's Divisão Territorial Brasileira. |
COMMENT |
VARCHAR |
No data tests defined 🧐
Models
m0_seipcs_brazil_soy_2018m1_seipcs_brazil_soy_2018m2_6_0_seipcs_brazil_soy_2019m2_6_0_seipcs_brazil_soy_2020m2_6_1_seipcs_brazil_soy_2019m2_6_1_seipcs_brazil_soy_2020m2_6_1_seipcs_brazil_soy_2021m2_6_1_seipcs_brazil_soy_2022seipcs_brazil_corn_2015seipcs_brazil_corn_2016seipcs_brazil_corn_2017seipcs_brazil_corn_2019seipcs_brazil_soy_2004seipcs_brazil_soy_2005seipcs_brazil_soy_2006seipcs_brazil_soy_2007seipcs_brazil_soy_2008seipcs_brazil_soy_2009seipcs_brazil_soy_2010seipcs_brazil_soy_2011seipcs_brazil_soy_2012seipcs_brazil_soy_2013seipcs_brazil_soy_2014seipcs_brazil_soy_2015seipcs_brazil_soy_2016seipcs_brazil_soy_2017seipcs_brazil_soy_partial_by_year_branches_v27
-
Dbt source path:
memory.trase-storage-raw.extra_cnpj_dict -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml
-
Tags:
brazil_soy_2022_2025_update