The Baltimore Banner Feb. 2025

Transit nightmare: Thousands of Baltimore kids can’t get to school on time

I modeled over 4,000 unique routes and tracked live locations for every city bus 6 months for our investigation on Baltimore's universal school choice system and the transit system that struggles to support it. Part of the package of stories that won the 2025 Philip Meyer Journalism Award.

The Baltimore Banner Feb. 2025

Which Baltimore school is best for you? Compare routes using this tool.

The companion news app to our "Transit Nightmare" story. I modeled every possible route from each census tract to each Baltimore middle and high school to build a trip planning tool for students that shows them their fastest route, estimated travel time and their route's reliability.

The Baltimore Banner Apr. 2024

Key Bridge collapse could change rules for tugboats

Using ship location data I pulled in the direct aftermat of the Francis Scott Key Bridge crash, I identified inconsistencies in tug practices for this story on the lack of national tug regulations. Part of the package of story that won the 2024 IRE Award for investigations triggered by breaking news.

The Washington Post Sept. 2023

Lawmakers are spending way more to keep themselves safe. Is it enough?

I spent part of my time as an intern at the Washington Post writing a script to reliably OCR years of Senate office spending data. I analyzed that in combination with house spending data and FEC campaign finance data to tell a story about the massive increase in security spending after January 6th.

The Baltimore Banner Apr. 2025

Trump’s federal worker cuts are destabilizing the nation’s 2 richest Black counties

I set out to quantify the impact of federal worker cuts on the nation’s wealthiest Black counties. I used IPUMS microdata to chronicle Prince George's and Charles counties' 80-year transformation into upper-middle-class Black enclaves, examine the relationship between federal employment and household income in Black counties nationwide, and assess the economic impact of federal work for households in the counties.

The Baltimore Banner Feb. 2024

1 in 5 guns on Baltimore’s streets don’t have serial numbers. That’s a problem.

My colleague Lee Sanderlin and I were the first reporters to examine the Baltimore police's gun recovery records. I had to OCR hundreds of records to get details of each firearm. We used my analysis to tell a story about unserialized "Ghost guns" and their rise to prominence in Baltimore.

The Baltimore Banner June 2024

Baltimore’s flashiest developer wanted to expand nationally. Now he’s rethinking everything

Our profile of Brandon Chasen, the developer whose company was once named one of the fastest growing in the area. Used Baltimore's real property database and Maryland land records database to uncover the company's LLCs and high interest loans.

The Baltimore Banner July 2024

Why does Maryland dominate at the Olympics? Look at the bank accounts.

I found my way into NBC's hidden API containing every Olympian and the entire Olympic schedule. I scraped the data and used it in combination with U.S Census data to tell a story about why Maryland is so good at producing Olympians.

ProPublica Dec. 2021

He Was Filming on His Phone. Then a Deputy Attacked Him and Charged Him With Resisting Arrest.

My first investigative journalism project. I analyzed arrest data for the first time in this investigation into the Jefferson Parish, LA Police Department's use of so-called "cover charges".