GovComp.app
projectSearch and browse government employee compensation across public sector jurisdictions
Visit govcomp.appBy the numbers
- Public employees
- 4.8M
- Agencies
- 24,014
- Jurisdictions
- 60
- Lines of code
- 20,540
- Built with
- Next.js 16, Supabase, Python
Why I built this
Government transparency is notoriously lacking, yet people naturally want to search for other people. I had tackled this exact problem before, building similar public records tools during my time at Graphiq, which was later acquired by Amazon, and again at thedataproject.ai. Back then, it was incredibly difficult to gather information from so many disparate government agencies, normalize the records, and present them in a unique and informative way. This time around, AI completely changed the equation. Standardizing the messy data became far easier, and the end product is significantly better. One of the biggest upgrades is the addition of semantic, or fuzzy, search. When you are dealing with thousands of public payroll ledgers across different jurisdictions, names are frequently misspelled or inconsistently formatted. Having an intelligent search layer is absolutely vital to making this kind of massive public database actually useful.
About GovComp.app
GovComp.app is a public records research tool that provides transparency into government employee compensation across federal, state, and local jurisdictions. The database allows users to search and browse 7.5M pay records of public sector workers, offering detailed insights into department medians, pay bands, and compensation components. It is designed for researchers, journalists, and citizens seeking verifiable data on government spending and public payroll ledgers. The platform aggregates 7.5M individual pay records from 60 published payroll ledgers, covering 18 statewide databases, 41 city and county governments, and the federal civilian workforce. Rather than merely presenting headline numbers, the application provides a transparent source trail by identifying the original public dataset and the date it was ingested. It maintains a strict editorial standard regarding identity matching, flagging ambiguous name matches as multi-record containers rather than incorrectly merging them into 1 person. This cautious presentation ensures that the public payroll data accurately reflects government spending without making unfounded biographical assumptions. Users can explore massive datasets, such as the non-defense civilian workforce of the federal government. For example, in 2024, the federal government reported 1,131,769 employees across 128 departments with a total payroll of $127.3B. The platform breaks this down to show that the Department of Veterans Affairs is the largest employer with 479,963 staff members, while agencies like the Commodity Futures Trading Commission offer the highest median total compensation. The tool also compares government pay against the local labor market using benchmark data from the Bureau of Labor Statistics. It shows that across 120 roles mapping to standard occupations, federal median base salaries run 20% above the median wage for similar work nationwide. The site extends its deep analysis to state-level jurisdictions. In the database for New York state public authorities, records show 112,831 employees across 41 departments generating a $10.7B payroll in 2024. The Metropolitan Transportation Authority dominates this jurisdiction with 81,028 workers. Similarly, the compensation data for Florida reveals a $5.8B payroll for 96,832 employees across 33 departments, with the Department of Corrections employing the largest share at 22,304 people. By analyzing these statewide figures against occupational benchmarks, the application reveals that median base salaries for public authority workers in New York and state employees in Florida run 5% below the median wage for equivalent private and public sector roles in their respective areas. Alongside federal and state records, the database indexes compensation details for 41 local governments, school districts, and specific regional authorities. Visitors can investigate the payroll allocations for major urban centers like the City of Chicago or the City of Los Angeles, as well as broad county governments such as Miami-Dade County. Each jurisdiction profile opens into department breakdowns, common job titles, and comprehensive source notes, ensuring that anyone inspecting a specific salary or verifying a highly compensated official can trace the number directly back to its original public record.