Skip to content

DBT: Brazil Mdic Disaggregated 2019

File location: s3://trase-storage/brazil/trade/mdic/disaggregated/brazil_mdic_disaggregated_2019.csv

DBT model name: brazil_mdic_disaggregated_2019

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Relies on script: trase/models/brazil/customs_2019

Description

Brazil MDIC/SECOMEX Disaggregation

This dataset attempts to reconstruct the MDIC/SECOMEX trade export dataset to the level of information that was provided before 2018. To do so, it combines the post-2018 MDIC/SECOMEX trade export datasets with bills of lading.

This reconstruction is run as a model written in using the supply chain mapping tool: see trase/models/brazil/customs_2019/README.md.

History

It was last run by Nanxu Su for the update to the Brazil beef model to add the year 2020. Since we only needed the model output for beef, we filtered to beef commodity codes and wrote the file brazil_mdic_disaggregated_2020_beef.csv.

Details

Column Type Description
month VARCHAR
country_of_destination.name VARCHAR
hs4 VARCHAR
via VARCHAR
port.name VARCHAR
state.trase_id VARCHAR
hs6 VARCHAR
hs8 VARCHAR
exporter.municipality.trase_id VARCHAR
success VARCHAR
message VARCHAR
vol VARCHAR

No data tests defined 🧐

Not referenced by any model or exposure.

Models

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.ref("brazil_mdic_port_2019")
    dbt.ref("empresas_cadastro_2019")
    dbt.ref("brazil_mdic_municipality_2019")
    dbt.ref("brazil_bol_2019")

    raise NotImplementedError()
    return pd.DataFrame({"hello": ["world"]})