Back to browse
A static SPA to query ATF / BATFE historic AFMER data

A static SPA to query ATF / BATFE historic AFMER data

by RyJones·Jun 9, 2026·2 points·0 comments

AI Analysis

●●SolidNiche GemCozy

20 years of personally collected ATF data now queryable in browser.

Strengths
  • Author collected raw AFMER data since 2005—unique longitudinal dataset.
  • Zero-server architecture means data loads and filters entirely client-side.
  • Built to verify manufacturer sales claims against official ATF reports.
Weaknesses
  • Niche audience limits broader appeal beyond firearms policy researchers.
  • Static site means no real-time updates when ATF publishes new reports.
Category
Target Audience

Journalists, researchers, policy analysts tracking firearms industry data

Post Description

I guided Claude to write an SPA to make the BATFE Annual Firearms Manufacturers And Export Report (AFMER) data easier to explore.

I have the raw data in https://github.com/ryjones/AFMER . I've been collecting the raw data since 2005 or 2006 as it became available.

I started grabbing the data years ago to interrogate claims firearms manufacturers were making in public about sales volumes against the data the BATFE publishes.

Similar Projects

SQL Query Optimizer

LLM-augmented SQL optimizer with schema context, but lacks benchmarks proving it beats manual EXPLAIN review.

Solve My ProblemShip It
hura17
103mo ago