Skip to content

DBT: Hinrichsen 2007 2017

File location: s3://trase-storage/brazil/logistics/crushing_facilities/in/hinrichsen/HINRICHSEN_2007_2017.csv

DBT model name: hinrichsen_2007_2017

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Description

Crushing-capacity figures for 2006/2007, 2010, 2012 and 2017, hand-compiled from the corresponding JJ Hinrichsen PDFs (jjhinrichsen_2007_pdf, _2010_pdf, _2012_pdf, _2017_pdf) into one CSV; consumed by crushing_facilities_2003_2019.

Details

Column Type Description
YEAR VARCHAR
COMPANY VARCHAR
UF VARCHAR
MUNICIPALITY VARCHAR
GEOCODE VARCHAR
CAPACITY VARCHAR
STATUS VARCHAR
SOURCE VARCHAR

No data tests defined 🧐

Models

Sources

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "jjhinrichsen_2007_pdf")
    dbt.source("trase-storage-raw", "jjhinrichsen_2010_pdf")
    dbt.source("trase-storage-raw", "jjhinrichsen_2012_pdf")
    dbt.source("trase-storage-raw", "jjhinrichsen_2017_pdf")

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