// tools & projects

Things I’ve built

Alongside research and advisory work, I build tools to help the people who need it — journalists, regulators, researchers, and anyone trying to understand how platforms actually work.

Live

Show Me The Data

An interactive guide to platform data — built to demystify how social media companies collect, store, and expose data, for everyone from journalists to regulators. Includes a live SQL playground and API demos using real platform schemas.

  • SQLWrite and run queries against synthetic platform data in your browser
  • APILive demos connecting to platform APIs with real responses
  • DSAPlatform-by-platform breakdowns of what data is legally accessible under the DSA
  • 101No-jargon introductions to data schemas, access methods, and research use cases
show-me-the-data.com

Learn how to access and analyze platform data for studies, publications, and understanding online information ecosystems.

// other projects

Research · USC Neely Center

Social Media Index

A large-scale longitudinal and nationally representative survey of US adults on their experiences with social media platforms and social technologies.

Platform rankings across four user experience dimensions, January 2025 — Neely Social Media Index
Coming Soon

What Could Go Wrong

A satirical social media tycoon simulation game about incentives, tradeoffs, and unintended consequences in platform design. You build it. Then it escapes you.

What Could Go Wrong screenshot — title
What Could Go Wrong screenshot — game start
What Could Go Wrong screenshot — standup
What Could Go Wrong screenshot — squishy bank
What Could Go Wrong screenshot — vc
What Could Go Wrong screenshot — court
What Could Go Wrong screenshot — monthly report
What Could Go Wrong screenshot — flywheel
Wishlist on Steam — coming soon