Skip to content

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
TypeCode VARCHAR
FreqCode VARCHAR
RefPeriodId VARCHAR
RefYear VARCHAR
RefMonth VARCHAR
Period VARCHAR
ReporterCode VARCHAR
ReporterISO VARCHAR
ReporterDesc VARCHAR
FlowCode VARCHAR
FlowDesc VARCHAR
PartnerCode VARCHAR
PartnerISO VARCHAR
PartnerDesc VARCHAR
Partner2Code VARCHAR
Partner2ISO VARCHAR
Partner2Desc VARCHAR
ClassificationCode VARCHAR
ClassificationSearchCode VARCHAR
IsOriginalClassification VARCHAR
CmdCode VARCHAR
CmdDesc VARCHAR
AggrLevel VARCHAR
IsLeaf VARCHAR
CustomsCode VARCHAR
CustomsDesc VARCHAR
MosCode VARCHAR
MotCode VARCHAR
MotDesc VARCHAR
QtyUnitCode VARCHAR
QtyUnitAbbr VARCHAR
Qty VARCHAR
IsQtyEstimated VARCHAR
AltQtyUnitCode VARCHAR
AltQtyUnitAbbr VARCHAR
AltQty VARCHAR
IsAltQtyEstimated VARCHAR
NetWgt VARCHAR
IsNetWgtEstimated VARCHAR
GrossWgt VARCHAR
IsGrossWgtEstimated VARCHAR
Cifvalue VARCHAR
Fobvalue VARCHAR
PrimaryValue VARCHAR
LegacyEstimationFlag VARCHAR
IsReported VARCHAR
IsAggregate VARCHAR
column47 VARCHAR

No data tests defined 🧐

Exposures