-- 1,290 People Are Running for President — anatomy of the FEC Candidate Master File.
-- Source table: public.fec_candidates.
-- Snapshot: 2026-06-22.
-- Aggregate-only: these GROUP BY queries publish counts, not individual names.

SELECT office, count(*) FROM fec_candidates GROUP BY office ORDER BY 2 DESC;
-- H 5,626; P 1,290; S 1,163

SELECT party_affiliation, count(*) FROM fec_candidates GROUP BY party_affiliation ORDER BY 2 DESC;
-- Major parties: DEM 3,238; REP 3,218.
-- Neither major party: 1,623 total (including IND 617 and LIB 144, plus minor labels).

SELECT incumbent_challenger_status, count(*) FROM fec_candidates GROUP BY incumbent_challenger_status ORDER BY 2 DESC;
-- C 4,932; O 1,697; I 736; blank 714
