Skip to content

DBT Source: Dataliner Soy 2017 2019 Cleaned

File location: s3://trase-storage/brazil/trade/bol/2017/originals/DATALINER_SOY_2017_2019_cleaned.csv

DBT source: trase-storage-raw.dataliner_soy_2017_2019_cleaned

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Description

No description

Details

Column Type Description
Commodity_HS_Datamar/HS6 Code VARCHAR
Commodity_HS/HS8 Code VARCHAR
Cargo_Transport/Cargo Type VARCHAR
Cargo_Transport/Container Type VARCHAR
Period/YYYYMMDD VARCHAR
Vessel/IMO VARCHAR
Vessel/Vessel Name VARCHAR
Vessel/Vessel Type VARCHAR
Carrier/Carrier Agent VARCHAR
Carrier/Carrier Datamar Group SCAC VARCHAR
Carrier/Carrier Datamar VARCHAR
Carrier/Carrier Name VARCHAR
Company_Shipper/Shipper Name VARCHAR
Company_Shipper/Registration Number VARCHAR
Company_Shipper/Country Name VARCHAR
Company_Shipper/State VARCHAR
Company_Shipper/City VARCHAR
Company_Shipper/Street VARCHAR
Company_Shipper/Zip VARCHAR
Company_Forwarder/Forwarder Name VARCHAR
Company_Forwarder/Registration Number VARCHAR
Company_Forwarder/Type VARCHAR
Company_Forwarder/Country VARCHAR
Company_Forwarder/State VARCHAR
Company_Forwarder/City VARCHAR
Company_Forwarder/Street VARCHAR
Company_Forwarder/Zip VARCHAR
Company_Consignee/Consignee Name VARCHAR
Company_Consignee/Registration Number VARCHAR
Company_Consignee/Country VARCHAR
Company_Consignee/City VARCHAR
Company_Consignee/Neighborhood VARCHAR
Company_Consignee/State VARCHAR
Company_Consignee/State Name VARCHAR
Company_Consignee/Street VARCHAR
Company_Consignee/Type VARCHAR
Company_Consignee/Zip VARCHAR
Company_Notify/Notify Name VARCHAR
Company_Notify/Country VARCHAR
Company_Notify/State VARCHAR
Company_Notify/City VARCHAR
Company_Notify/Neighborhood VARCHAR
Company_Notify/Street VARCHAR
Company_Notify/Zip VARCHAR
Company_Notify/Registration Number VARCHAR
Commodity_HS_Datamar/HS8 Code VARCHAR
Place_and_Ports/DEST_Country VARCHAR
Place_and_Ports/DEST_Name VARCHAR
Place_and_Ports/DEST_Tradelane VARCHAR
Place_and_Ports/POD_Country VARCHAR
Place_and_Ports/POD_Name VARCHAR
Place_and_Ports/POD_Terminal VARCHAR
Place_and_Ports/POD_Tradelane VARCHAR
Place_and_Ports/POL_Country VARCHAR
Place_and_Ports/POL_Name VARCHAR
Place_and_Ports/POL_Terminal VARCHAR
Place_and_Ports/POL_Tradelane VARCHAR
Place_and_Ports/POMD_Country VARCHAR
Place_and_Ports/POMD_Name VARCHAR
Place_and_Ports/POMD_Tradelane VARCHAR
Place_and_Ports/POMO_Country VARCHAR
Place_and_Ports/POMO_Name VARCHAR
Place_and_Ports/POMO_Tradelane VARCHAR
Place_and_Ports/POR_Country VARCHAR
Place_and_Ports/POR_Name VARCHAR
Place_and_Ports/POR_Tradelane VARCHAR
Service/Service Name VARCHAR
Identification/ID_Datamar VARCHAR
WTKG VARCHAR
WTMT VARCHAR
TEU VARCHAR

No data tests defined 🧐

Models