All projects

Robbins: Seattle Open-Data Explorer

Analytics EngineeringData Engineering
Screenshot of Robbins: Seattle Open-Data Explorer

Robbins is a multi-page explorer over public data about the Seattle metro, from the King County core out to Pierce and Snohomish. The interesting part is ingestion: it pulls from two different access patterns, Socrata's SODA API and ArcGIS FeatureServers, and lands both in a DuckDB warehouse modeled with dbt. It is the same architecture as Elvis, pointed at a harder data-sourcing problem.

What it proves

Multi-source ingestion and dimensional modeling, pulling two public-data APIs into one tested warehouse.

How it was built

Claude Code, multi-source ingestion across two public-data APIs, warehouse baked fresh on every deploy.

What is real, and where I was learning

What is real: both ingestion paths work, and the warehouse is modeled and tested. Where I was learning: it is a portfolio build, so the emphasis is on covering the ingestion patterns cleanly rather than on scale.

dbtDuckDBStreamlitAltairPyDeckRailway