Trevor Brown

Journalist turned developer based in Bloomington, IN.

I spent 15 years in newsrooms — reporting, building data tools, and turning public records into stories. Now I build the tech that makes that work possible.

Top Projects

Open Cabinet Financial disclosure tracker for U.S. executive-branch officials. 36 cabinet officials, 10,000+ stock transactions, $4.3B in trade volume parsed from OGE filings into searchable, structured data.	Delegation Decoded Congressional accountability tracker for all 535 voting members organized by state delegation — votes, committees, campaign money, STOCK Act trades and 2026 races, with a grounded Ask assistant that cites the records it read.
Capitol Releases Archival-grade database of every press release from all 535 members of Congress since January 2025 — 90,000+ records, four daily updates, deletion tombstones and Ask the record, RAG Q&A grounded in each member's own releases.	News Pulse Real-time global news monitor for journalists and OSINT analysts. 668 vetted sources across six platforms, surfaced through frequency-based surge detection rather than engagement ranking.
FOIA Tracker Federal FOIA backlog dashboard. Normalizes public FOIA.gov datasets (FY2008–FY2024 annual plus quarterly reports) into a queryable Next.js app that ranks federal agencies by backlog, backlog change, oldest pending requests, staffing context, and exemption invocations.	Portfolio My personal site — selected journalism clips, data visualizations, and the web projects above, with live demos and write-ups. Next.js, Tailwind, Vercel.

Also Shipped

• Keith Brown DDS — production dental practice site with an active Google Ads campaign and protected admin dashboard.
• AI Model Arena — side-by-side AI model comparison tool for prompting multiple models at once.
• Food Xpiry — AI-powered grocery expiration tracker.
• sort(id) — media ranking and sharing platform.
• StuddyBuddy — AI study platform for web developers.

Data Visualization — Oklahoma Watch

Selected interactive graphics from my reporting, published at Oklahoma Watch.

• As Some Oklahoma Churches Push Vaccines, Others Sow Misinformation, Doubt — Datawrapper. 1st Place Investigative Reporting, Oklahoma SPJ (2022).
• Hundreds of Bills Passed the Legislature. Just a Dozen Were Authored by Democrats. — Datawrapper.
• Amid COVID-19, Some Hospitals Continue Suing Patients Over Unpaid Bills — Tableau, Infogram.
• Which State Lawmakers Have the Biggest Campaign War Chests? — Tableau.
• Lost in the Pandemic: Oklahoma COVID-19 Digital Memorial — Flourish.
• Oklahoma Candidate & Legislator Financial Disclosures — Flourish, Tableau.

What I Build

• Data tools for journalism — searchable databases, public records trackers, interactive visualizations
• Newsroom tech — dashboards, content management, automation
• Web applications — production sites serving real users and real traffic

Stack

Next.js, React, TypeScript, Tailwind CSS, D3.js, Python, PostgreSQL, Vercel

Links

• Portfolio
• LinkedIn
• trevorbrown.web@gmail.com