projects

filter by tool or technique

This website

This website

6/26/2025

I built this portfolio website myself using open-source tools and GitHub Pages

GitHub ActionsGitHub PagesReactTypeScriptNext.jsTailwind CSSMCP
Shot by a civilian wielding a police gun

Shot by a civilian wielding a police gun

5/16/2024

This multi-year investigation uncovered a hidden economy where used police guns are sold to members of the public.

FOIAFOIA automationPythonETLLLM
Majority-Black school districts have far less money to invest in buildings

Majority-Black school districts have far less money to invest in buildings

9/14/2023

I analyzed federal data to show that majority-Black districts receive half the per-pupil building investment and only a fraction of state capital funding compared with mostly White districts

PythonETL
enforce-notebook-run-order

enforce-notebook-run-order

5/30/2023

A Python-based pre-commit hook to force Jupyter notebooks to be run in the correct order

PythonPre-commit
Wage theft often goes unpunished despite state systems meant to combat it

Wage theft often goes unpunished despite state systems meant to combat it

1/24/2023

An investigation into failings at state labor departments to recover back pay on behalf of wage theft victims.

PythonFOIAETL
A "coin flip": Nearly half of U.S. murders go unsolved

A "coin flip": Nearly half of U.S. murders go unsolved

12/29/2022

I decoded and analyzed FBI homicide data to reveal that nearly half of U.S. murders go unsolved and that clearance rates are even worse for Black and Hispanic victims.

PythonETLDjangoFOIA
Hundreds of elementary students arrested at U.S. schools each year

Hundreds of elementary students arrested at U.S. schools each year

12/9/2022

I analyzed federal school-discipline data to expose that hundreds of elementary-age children are arrested each year — and that the burden falls heaviest on Black students and those with disabilities.

ETLPython
Half of all Texas school districts have no mental health services

Half of all Texas school districts have no mental health services

8/19/2022

I analyzed Texas Education Agency staffing data and telehealth rosters to reveal that half the state’s school districts — and more than 500,000 students — have no access to a school psychologist.

Python
Left in the Dark: The Failed Promise of Chicago Police Body Cameras

Left in the Dark: The Failed Promise of Chicago Police Body Cameras

2/3/2022

I analyzed internal records to show that Chicago Police officers failed to use body cameras tens of thousands of times — especially in Black and Latino neighborhoods.

PythonFOIA
stratuslogger

stratuslogger

12/10/2010

A Chrome extension that added integrated transcription features into the web UI for the Stratus content management system.

JavascriptReactChrome extension