DBT Source: Municipality
File location: s3://trase-storage/brazil/dictionaries/municipality.csv
DBT source: trase-storage-raw.municipality
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
Brazilian municipalities (state_trase_id, trase_id, name): the 5,570
IBGE municipalities of 2013-2024 plus Trase placeholders such as BR-XXXXXXX
and the per-state unknown and aggregated regions. Read by the Brazil soy,
corn and LP models, among others.
We do not know where this file came from, and it is maintained by hand. Most
recently, in September 2026, Harry Biddle added Boa Esperança do Norte (MT,
BR-5101837), installed in 2025, with
trase/data/brazil/metadata/patches/add_boa_esperanca_do_norte_to_municipality_dictionary.py.
We are looking to move away from this file, towards a single municipality
table built from IBGE's Divisão Territorial Brasileira.
Details
| Column | Type | Description |
|---|---|---|
state_trase_id |
VARCHAR |
|
trase_id |
VARCHAR |
|
name |
VARCHAR |
No data tests defined 🧐
Models
crushing_facilities_2003_2024crushing_facilities_2003_2025m1_0_0_seipcs_brazil_soy_2019m1_0_0_seipcs_brazil_soy_2020m1_0_0_seipcs_brazil_soy_2021m1_0_0_seipcs_brazil_soy_2022m1_seipcs_brazil_soy_2018m2_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_soy_mdic_2004seipcs_brazil_soy_mdic_2005seipcs_brazil_soy_mdic_2006seipcs_brazil_soy_mdic_2007seipcs_brazil_soy_mdic_2008seipcs_brazil_soy_mdic_2009seipcs_brazil_soy_mdic_2010seipcs_brazil_soy_mdic_2011seipcs_brazil_soy_mdic_2012seipcs_brazil_soy_mdic_2013seipcs_brazil_soy_mdic_2014seipcs_brazil_soy_mdic_2015seipcs_brazil_soy_mdic_2016seipcs_brazil_soy_mdic_2017seipcs_brazil_soy_mdic_2018seipcs_brazil_soy_mdic_2019seipcs_brazil_soy_mdic_2020seipcs_brazil_soy_mdic_2021seipcs_brazil_soy_mdic_2022seipcs_brazil_soy_partial_by_year_branches_v27
Exposures
brazil_soy_qa_decision_sao_paulo_office_hubs(view exposure, view documentation)brazil_soy_qa_decision_unknown_flow_allocation(view exposure, view documentation)
-
Dbt source path:
memory.trase-storage-raw.municipality -
Source yml: trase/data_pipeline/models/_sources_trase_storage.yml
-
Tags:
brazil_soy_2022_2025_update