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

13 rows where cand_office_st = "MA" and cand_pty_affiliation = "NNE" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

cand_pty_affiliation 1

  • NNE · 13 ✖

cand_office_st 1

cand_office 1

  • H 13
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
H6MA09180,2016 H6MA09180 HARRINGTON, PAUL J. NNE 2016 MA H 09 C C C00622605 2016
H6MA09180,2018 H6MA09180 HARRINGTON, PAUL J. NNE 2016 MA H 09 C P C00622605 2018
H4MA01059,2022 H4MA01059 MAYOCK, FREDERICK NNE 2022 MA H 01 C N C00565085 2022
H4MA01059,2024 H4MA01059 MAYOCK, FREDERICK NNE 2022 MA H 01 C N C00565085 2024
H2MA08058,2012 H2MA08058 ROMERO, KARLA NNE 2012 MA H 07 C N C00500629 2012
H2MA08058,2014 H2MA08058 ROMERO, KARLA NNE 2012 MA H 07 C N C00500629 2014
H2MA08058,2016 H2MA08058 ROMERO, KARLA NNE 2012 MA H 07 C N C00500629 2016
H2MA08058,2018 H2MA08058 ROMERO, KARLA NNE 2012 MA H 07 C N C00500629 2018
H4MA06124,2014 H4MA06124 STOCKWELL, CHRISTOPHER JOHN NNE 2014 MA H 06 C C C00565424 2014
H4MA06124,2016 H4MA06124 STOCKWELL, CHRISTOPHER JOHN NNE 2014 MA H 06 C P C00565424 2016
H4MA05167,2014 H4MA05167 WILT, WILLIAM F NNE 2014 MA H 05 O N C00557967 2014
H4MA05167,2016 H4MA05167 WILT, WILLIAM F NNE 2014 MA H 05 O N C00557967 2016
H4MA05167,2018 H4MA05167 WILT, WILLIAM F NNE 2014 MA H 05 O N C00557967 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);