fec_candidates

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

53 rows where cand_office = "P" and cand_pty_affiliation = "COM" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_election_yr, cand_ici, cand_pcc, cycle

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