Jonathan Gerhardson

I use public records, data analysis, and open-source tools to help me write stories about people and governments. Based in western Massachusetts.

Selected Reporting

Data Projects

Heatmap of surveillance cameras overlaid on median household income
Interactive map popup showing camera location and embedded video

Chicopee Surveillance Map

An interactive map of hundreds of surveillance cameras deployed by Chicopee Police using the Axon Fusus network, overlaid with Census income data. Built from audit logs obtained through a public records request. Accompanies reporting for The Shoestring. Camera locations were confirmed via in-person observation (see video).

Choropleth map of Massachusetts opioid settlement spending by municipality
Entity explorer with sortable municipal spending data
Full-text search across settlement expenditures
Expenditure detail view with program descriptions

Opioid Settlement Dashboard

An interactive dashboard tracking reported expenditures for Opioid Remediation and Recovery settlement funds across municipalities and the state executive branch. Includes data for FY2023 throughg FY2025, with full-text search, sortable tables, and spending breakdowns, and a choropleth map. Created for the Boston Institute for Nonprofit Journalism as part of my ongoing coverage of how this settlement money is being used. My initial reporting on this topic helped BINJ secure a grant from the Data-Driven Reporting Project. I also appeared on MuckRock's FOIA Friday series to discuss some challenges I faced in obtaining records from Care Mass, the public-private partnership that held these records last year.

Code & Tools

federal-agent querying DoD ice cream spending via Claude Code

federal-agent

Claude Code skill · Python

A skill for Claude Code that queries federal procurement data from FPDS, USAspending.gov, and SAM.gov. Lets you search contracts by agency, vendor, or NAICS code, analyze spending patterns, and cross-reference sources through natural language.

Terminal showing cthru spending and commbuys_cli vendor search results

commbuys_cli & cthru_cli

CLI tools · Python

Two command-line tools for querying state financial data in Massachusetts. commbuys_cli searches bid solicitations, contracts, and vendors on the COMMBUYS procurement portal. cthru_cli queries spending, payroll, and retirement data from CTHRUspending.mass.gov. Both support filtering, multiple output formats, and JSON export.

Mass.gov update bot Bluesky profile with daily posts

Mass.gov Update Bot

@massgovupdatesbot.bsky.social · Python

Scrapes mass.gov/sitemap.xml daily and posts a summary of updated pages to Bluesky. Tracks hundreds of state government website changes per day, and logs each day's changes to a csv file.

This is part of a larger pipeline for discovering potential news leads beyond agency press releases, that is still a work in progress.

reccomend_from_archive web interface showing playlist recommendations

reccomend_from_archive

Web app & CLI · Python

(Personal/for fun project) A music recommender that analyzes your Spotify streaming history against scraped Spotify metadata for over 250 million tracks released by Anna's Archive and finds tracks you'll like based on your listening history, using an algorithm you control.
Note: no music is streamed or stored, only metadata.