fec_candidates

FEC candidate records — 64,000+ candidates for federal office with party, state, office, and election cycles.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

17 rows where cand_office = "S" and cand_pty_affiliation = "REF" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_id, cand_name, cand_election_yr, cand_ici, cand_pcc, cycle

cand_office_st 6

cand_pty_affiliation 1

  • REF · 17 ✖

cand_office 1

Link cand_id cand_name ▼ cand_pty_affiliation cand_election_yr cand_office_st cand_office cand_office_district cand_ici cand_status cand_pcc cycle
S0WA00399,2010 S0WA00399 BAKER, WILL REF 2010 WA S 00 C N   2010
S0WA00399,2012 S0WA00399 BAKER, WILL REF 2012 WA S 00 C N   2012
S0KS00133,2010 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2010
S0KS00133,2012 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2012
S0KS00133,2014 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2014
S0KS00133,2016 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2016
S0KS00133,2018 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2018
S4IL00362,2010 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2010
S4IL00362,2012 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2012
S4IL00362,2014 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2014
S4IL00362,2016 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2016
S4IL00362,2018 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2018
S0LA00287,2010 S0LA00287 MCSHAN , WILLIAM R. REF 2010 LA S 00 C N   2010
S4MS00062,2012 S4MS00062 O'HARA, SHAWN REF 2012 MS S 00 C N C00376210 2012
S4MS00062,2014 S4MS00062 O'HARA, SHAWN REF 2014 MS S 00 C N C00376210 2014
S4MS00062,2018 S4MS00062 O'HARA, SHAWN REF 2018 MS S 00 C N C00376210 2018
S0KY00412,2020 S0KY00412 PETTEYS, DEREK LEONARD REF 2020 KY S 00 C N C00730473 2020

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE fec_candidates (
    cand_id TEXT NOT NULL,
    cand_name TEXT,
    cand_pty_affiliation TEXT,
    cand_election_yr INTEGER,
    cand_office_st TEXT,
    cand_office TEXT,
    cand_office_district TEXT,
    cand_ici TEXT,
    cand_status TEXT,
    cand_pcc TEXT,
    cycle INTEGER NOT NULL,
    PRIMARY KEY (cand_id, cycle)
);
CREATE INDEX idx_fec_cand_name ON fec_candidates(cand_name);
CREATE INDEX idx_fec_cand_office ON fec_candidates(cand_office);
CREATE INDEX idx_fec_cand_state ON fec_candidates(cand_office_st);