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

6 rows where cand_office_st = "ND" and cand_pty_affiliation = "LIB" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_id, cand_election_yr, cand_ici, cand_status, cycle

cand_office 2

cand_pty_affiliation 1

cand_office_st 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
S0ND00119,2010 S0ND00119 HANSON, KEITH J. LIB 2010 ND S 00 O N   2010
S6ND00116,2016 S6ND00116 MARQUETTE, ROBERT N. LIB 2016 ND S 00 C N   2016
H2ND00149,2012 H2ND00149 OLSON, ERIC LIB 2012 ND H 00 O N   2012
H0ND00168,2020 H0ND00168 PETERSON, STEVEN JAMES LIB 2020 ND H 00 C N   2020
H4ND01028,2016 H4ND01028 SEAMAN, JACK LIB 2016 ND H 00 C N C00564609 2016
H4ND01028,2014 H4ND01028 SEAMAN, ROBERT J "JACK LIB 2014 ND H 00 C C C00564609 2014

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