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

7 rows where cand_office = "H", cand_office_st = "NV" and cand_pty_affiliation = "NON" 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

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
H6NV01232,2016 H6NV01232 D'SILVA, REUBEN NON 2016 NV H 01 C C C00612374 2016
H8NV03242,2018 H8NV03242 EISNER, GILBERT MR. NON 2018 NV H 03 O N C00669721 2018
H8NV03242,2020 H8NV03242 EISNER, GILBERT MR. NON 2018 NV H 03 O N C00669721 2020
H2NV03237,2022 H2NV03237 MORRIS, ROBERT BRUCE NON 2022 NV H 03 C N C00810671 2022
H2NV03237,2024 H2NV03237 MORRIS, ROBERT BRUCE NON 2022 NV H 03 C N C00810671 2024
H4NV01211,2024 H4NV01211 QUINCE, RONALD NON 2024 NV H 01 C C C00841098 2024
H4NV01211,2026 H4NV01211 QUINCE, RONALD NON 2024 NV H 01 C P C00841098 2026

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