Skip to content
Michael Lopez

Projects

A selection of data systems, tools, and products I've built, from production pipelines serving community partners to open-source packages and personal projects.

Civic Data & Infrastructure

Screenshot of Building CPAL's Data Function

The six-year story of building the Child Poverty Action Lab's data function from scratch: hiring the org's first data engineer, standing up a vendor-augmented team, selecting and migrating to Databricks, leading the data org through a CDO transition, and rolling AI-enabled workflows across the team. A leadership case study, not a pipeline write-up.

  • Scaled the data team from 1 analyst to 7
  • Led the data org through a CDO transition
  • Selected and migrated to Databricks; rolled out AI workflows org-wide
Data Leadership Team Building Data Strategy Databricks
Project details →
Screenshot of Dallas County Eviction Data

The eviction data workstream behind the Child Poverty Action Lab's housing work: turning messy county court records into a daily feed that 12+ partners (the Dallas Eviction Advocacy Center, the Princeton Eviction Lab, Dallas HHS) use to reach tenants facing displacement, and into the public transparency of North Texas Evictions. Built in R in 2020, then rebuilt on Databricks by our data engineering team as it scaled to four North Texas counties. What mattered was always who the data reaches.

  • 48,000+ Dallas filings a year turned into tenant outreach
  • ~800 tenants a year connected to legal representation
  • Feeds 12+ partners and North Texas Evictions
Housing & Eviction Public Records Partner Data Data for Outreach
Project details →
Screenshot of Dallas Homestead Exemption Map

Interactive R Shiny application mapping homestead exemption take-up rates across Dallas by census tract, zip code, and neighborhood. Filters by race/ethnicity and income level to surface disparities in who is claiming property tax savings. Built with Mapbox GL, sourcing data from the Dallas Central Appraisal District and American Community Survey.

  • Choropleth mapping by tract, zip, and neighborhood
  • Equity-focused filters by race/ethnicity and income
  • Downloadable report and open data
R Shiny Mapbox Housing GIS
Project details →
Screenshot of Dallas Block Walking Tool

The on-the-ground companion to the Homestead Exemption Map. Around a canvasser's location, it flags every parcel likely eligible for an unclaimed homestead exemption (worth hundreds to thousands of dollars a year per household), estimates the tax savings left on the table, and tracks outreach status door to door. Built with R Shiny and Mapbox GL on Dallas Central Appraisal District data, it's used by roughly 20 field-team members across CPAL's outreach partners.

  • Flags homes likely missing a homestead exemption, with projected savings
  • ~20 active field-team users across outreach partners
  • The door-to-door companion to the Homestead Exemption Map
R Shiny Mapbox Housing Field Outreach
Project details →

Personal & Community

Screenshot of Rodriguez Wellbeing & Counseling

Professional practice website for a licensed counselor and professor, offering counseling, clinical supervision, trauma-informed yoga, and speaking services. Fully bilingual (English/Spanish) with i18n routing, JSON-LD structured data, scroll-reveal animations, and a warm earthy design system.

  • Full English/Spanish bilingual support
  • JSON-LD structured data and strong SEO
  • Accessibility-first design with skip links and ARIA
Astro Tailwind CSS i18n Web Development
Project details →
Screenshot of DigiLab

A community-sourced tournament data platform for the global Digimon TCG scene. A 450+ member Discord and a network of volunteer organizers keep the data flowing; the platform turns it into regional meta analysis, scene-aware leaderboards, and blog deep-dives players use to prep for events. In its first six months: 5,000+ tournaments logged across 280 cities, 9,000+ players tracked, and around 1,000 daily active users. A public API powers external community tools. Built on Astro, Preact, and Neon Postgres.

  • 5,000+ tournaments logged · 450+ Discord community members
  • SSR Astro + Preact islands · Neon Postgres on Vercel edge
  • Public token-authenticated API and admin CRUD subdomain
Community Data Meta Analysis Data Insights Astro Neon Public API
Project details →

Open Source

Screenshot of atomtemplates

Open-source R package that standardizes project creation and handling. Streamlines setup of new data projects with consistent directory structure, documentation templates, and tooling. Used internally at CPAL to maintain consistency across the data team.

  • Consistent project scaffolding
  • Used across CPAL data team
  • Open source on GitHub
R Package Open Source DevTools
Project details →