DBT Source: Bronze Brazil Comtrade 2020
File location: s3://trase-storage/brazil/coffee/trade/2020/bronze/brazil_coffee_comtrade_2020.csv
DBT source: brazil_coffee.bronze_brazil_comtrade_2020
Explore on Metabase: Full table; summary statistics
Explore dependencies/lineage: link
Description
Downloaded from the UN Comtrade database, with the following options:
* Year: 2020
* HS Codes: 0901* (excluding 0901 which aggregates the others)
* Reporters: Brazil
* Partners; 2nd Partner: All
* Trade Flows: Export
* Modes of Transport: TOTAL modes of Transport
* Custom Codes: TOTAL custom procedure codes
* Aggregated by: None
* Note: Although there was another Comtrade source data available at s3://trase-storage/world/trade/statistical_data/comtrade/COMTRADE_2020.csv, it does not disaggregate by recipient country and includes all original columns, which might be useful.
* OBS: To compare volumes with BOL, use the NetWgt.
Details
| Column | Type | Description |
|---|---|---|
No data tests defined 🧐
Exposures
qa_brazil_coffee_trade_bol_2020(view exposure, view documentation)
-
Dbt source path:
trase_production.brazil_coffee.bronze_brazil_comtrade_2020 -
Source yml: trase/data_pipeline/models/brazil/coffee/sources.yml