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. 39 officials, 11,500 stock transactions, $4.5B in trade volume parsed from OGE filings into searchable, structured data, every row verified by an independent read.	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