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

8 rows where cand_office_st = "TX" and cand_pty_affiliation = "UNK" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

cand_pty_affiliation 1

cand_office_st 1

cand_office 1

  • H 8
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
H2TX35086,2012 H2TX35086 ALVARADO, SIMON UNK 2012 TX H 35 C C C00528000 2012
H2TX35086,2014 H2TX35086 ALVARADO, SIMON UNK 2012 TX H 35 C P C00528000 2014
H6TX03242,2026 H6TX03242 BLACK, BRITTANY UNK 2026 TX H 03 C N C00928580 2026
H8TX02166,2018 H8TX02166 CRENSHAW, DANIEL UNK 2018 TX H 02 O C C00660795 2018
H6TX01279,2016 H6TX01279 CULLER, RENEE UNK 2016 TX H 01 C N   2016
H6TX00131,2014 H6TX00131 PETER, RICHARD UNK 2016 TX H     N   2014
H8TX03065,2010 H8TX03065 PIERCE, HARRY UNK 2010 TX H 03 C N C00445718 2010
H2TX04090,2012 H2TX04090 ROSTEK, FRED UNK 2012 TX H 04 C N   2012

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