US Tariff: What didn't and What did do

Please find the full report here.

Source of Data

• U.S. Census Bureau, International Trade Datasets

• U.S. Department of the Treasury, Monthly Treasury Statement

• U.S. Bureau of Labor Statistics

Or, Use my transformed dataset in MotherDuck by the share link:

-- Run this snippet to attach database in MotherDuck
ATTACH 'md:_share/us_tariff/5e5d7ce4-fe48-487a-a05f-2dd92e9ac43d';

Reference

• Do Trump's Tariffs Make Sense? Douglas A.Irwin, Hayek Lecture Series

• Has Trump Actually Shrunk the Trade Deficit? TLDR News Global

• What are tariffs, and why are they rising? | Brookings

• Tariffs as a Major Revenue Source: Implications for Distribution and Growth | CEA | The White House

---

Get start

Dependences: dbt, duckdb (MotherDuck), Evidence BI.

Clone the repository and Create a MotherDuck account, add access token into repository secret.

Set up the development environment by .devcontainer, then run the following commands to build the data pipeline and reports:

dbt Pipeline

cd pipeline
dbt build
dbt docs generate

Reports

cd reports
npm run sources
npm run build 

Sructure

.
├── ingest/
├── data/
│
├── pipeline/
│   ├── analyses/
│   ├── macros/
│   ├── models/
│   ├── seeds/
│   ├── tests/
│   ├── dbt_project.yml
│   └── profiles.yml
│
├── reports/
│   ├── .evidence/customization
│   ├── build/
│   ├── pages/
│   ├── scripts/
│   ├── sources/
│   ├── evidence.config.yaml
│   ├── package-lock.json
│   └── package.json
│
├── .devcontainer/
├── .github/workflows
└── requirements.txt