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

16 rows where cand_office_st = "MA" and cand_pty_affiliation = "UNK" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

cand_pty_affiliation 1

  • UNK · 16 ✖

cand_office_st 1

cand_office 1

  • H 16
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
H0MA03038,2010 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2010
H0MA03038,2012 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2012
H0MA03038,2014 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2014
H0MA03038,2016 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2016
H0MA03038,2018 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2018
H0MA05090,2010 H0MA05090 CLARK, ROBERT MICHAEL UNK 2010 MA H 05 C C C00481143 2010
H0MA05090,2012 H0MA05090 CLARK, ROBERT MICHAEL UNK 2010 MA H 05 C P C00481143 2012
H6MA09131,2010 H6MA09131 DUNKELBARGER, PHILIP L UNK 2010 MA H 09 C C C00481929 2010
H6MA09131,2012 H6MA09131 DUNKELBARGER, PHILIP L UNK 2010 MA H 09 C P C00481929 2012
H6MA09131,2014 H6MA09131 DUNKELBARGER, PHILIP L UNK 2010 MA H 09 C P C00481929 2014
H8MA02066,2018 H8MA02066 GORDY, PAUL VINCENT UNK 2018 MA H 02 C N C00634444 2018
H8MA02066,2020 H8MA02066 GORDY, PAUL VINCENT UNK 2018 MA H 02 C N C00634444 2020
H6MA10147,2012 H6MA10147 WHITE, PETER A UNK 2012 MA H 09 C N C00478701 2012
H6MA10147,2014 H6MA10147 WHITE, PETER A UNK 2012 MA H 09 C N C00478701 2014
H6MA10147,2016 H6MA10147 WHITE, PETER A UNK 2012 MA H 09 C N C00478701 2016
H6MA10147,2018 H6MA10147 WHITE, PETER A UNK 2012 MA H 09 C N C00478701 2018

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);