fec_candidates
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10,890 rows where cand_office = "P" sorted by cand_name
This data as json, CSV (advanced)
Suggested facets: cand_ici, cand_status, cycle
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| P60016383,2024 | P60016383 | "VAL" VALMA PAUL | REP | 2024 | US | P | C | N | C00588541 | 2024 | |
| P40014052,2024 | P40014052 | 212 N HALF W. JOHN, RODNEY HOWARD MR. | IND | 2024 | US | P | 00 | C | N | C00843664 | 2024 |
| P40014052,2026 | P40014052 | 212 N HALF W. JOHN, RODNEY HOWARD MR. | IND | 2024 | US | P | 00 | C | N | C00843664 | 2026 |
| P40013393,2024 | P40013393 | 375 ROB ROY DR, DAVID J SR SR | DEM | 2024 | US | P | 00 | C | N | C00841965 | 2024 |
| P40013401,2024 | P40013401 | 375 ROB ROY DR, DAVID J SR SR | DEM | 2024 | US | P | 00 | C | N | C00841965 | 2024 |
| P40013393,2026 | P40013393 | 375 ROB ROY DR, DAVID J SR SR | DEM | 2024 | US | P | 00 | C | N | C00841965 | 2026 |
| P40013401,2026 | P40013401 | 375 ROB ROY DR, DAVID J SR SR | DEM | 2024 | US | P | 00 | C | N | C00841965 | 2026 |
| P00011569,2020 | P00011569 | 753, JO | NNE | 2020 | US | P | 00 | C | N | C00631770 | 2020 |
| P00011569,2022 | P00011569 | 753, JO | NNE | 2020 | US | P | 00 | C | N | C00631770 | 2022 |
| P60013794,2016 | P60013794 | A WANDRLUSTR, DOT COM | NAP | 2016 | US | P | 00 | O | N | 2016 | |
| P80002926,2010 | P80002926 | AARON, LAURA DAVIS | DEM | 2008 | US | P | 00 | C | N | C00415679 | 2010 |
| P80002926,2012 | P80002926 | AARON, LAURA DAVIS | DEM | 2008 | US | P | 00 | O | N | C00415679 | 2012 |
| P80002926,2014 | P80002926 | AARON, LAURA DAVIS | DEM | 2008 | US | P | 00 | O | N | C00415679 | 2014 |
| P80002926,2016 | P80002926 | AARON, LAURA DAVIS | DEM | 2008 | US | P | 00 | O | N | C00415679 | 2016 |
| P60016326,2016 | P60016326 | ABABIY, JON | PAF | 2016 | US | P | 00 | O | N | 2016 | |
| P40008203,2024 | P40008203 | ABAIR, REBECCA GAIL MS. | REP | 2024 | US | P | 00 | C | N | C00864736 | 2024 |
| P40008203,2026 | P40008203 | ABAIR, REBECCA GAIL MS. | REP | 2024 | US | P | 00 | C | N | C00864736 | 2026 |
| P40008203,2022 | P40008203 | ABAIR, REBECCA GAIL MS. | REP | 2024 | US | P | 00 | N | C00818385 | 2022 | |
| P40009169,2024 | P40009169 | ABAIR, REBECCA GAIL MS. PHD | REP | 2024 | US | P | 00 | C | N | C00864736 | 2024 |
| P40009169,2026 | P40009169 | ABAIR, REBECCA GAIL MS. PHD | REP | 2024 | US | P | 00 | C | N | C00864736 | 2026 |
| P40009169,2022 | P40009169 | ABAIR, REBECCA GAIL MS. PHD | REP | 2024 | US | P | 00 | N | C00818385 | 2022 | |
| P60005840,2016 | P60005840 | ABBOTT, GIFFORD WHEELER JR | IND | 2016 | US | P | 00 | O | N | 2016 | |
| P60012838,2016 | P60012838 | ABDULHAMID, AMMAR | IND | 2016 | US | P | 00 | O | N | 2016 | |
| P40013088,2024 | P40013088 | ABDULLAHI, FUAD | AIP | 2024 | US | P | 00 | C | N | 2024 | |
| P40014888,2024 | P40014888 | ABEL, JESSICA L | REP | 2024 | US | P | 00 | C | N | 2024 | |
| P40020059,2024 | P40020059 | ABITTAN, ALEXANDER | DEM | 2024 | US | P | 00 | C | N | C00879700 | 2024 |
| P40020059,2026 | P40020059 | ABITTAN, ALEXANDER | DEM | 2024 | US | P | 00 | C | N | C00879700 | 2026 |
| P60014461,2016 | P60014461 | ABLEIDINGER, PHILL ALEXANDER | DEM | 2016 | US | P | 00 | O | N | C00585851 | 2016 |
| P60014461,2018 | P60014461 | ABLEIDINGER, PHILL ALEXANDER | DEM | 2016 | US | P | 00 | O | N | C00585851 | 2018 |
| P60020690,2016 | P60020690 | ABLO, ANDY | IND | 2016 | US | P | 00 | O | N | C00613554 | 2016 |
| P60020690,2018 | P60020690 | ABLO, ANDY | IND | 2016 | US | P | 00 | O | N | C00613554 | 2018 |
| P60005766,2024 | P60005766 | ABOVE, ZERO, NONE OF THE | W | 2016 | US | P | 00 | O | N | C00572032 | 2024 |
| P60005766,2026 | P60005766 | ABOVE, ZERO, NONE OF THE | W | 2016 | US | P | 00 | O | N | C00572032 | 2026 |
| P60005766,2020 | P60005766 | ABOVE, ZERO, NONE OF THE | W | 2016 | US | P | 00 | O | N | C00572032 | 2020 |
| P60005766,2022 | P60005766 | ABOVE, ZERO, NONE OF THE | W | 2016 | US | P | 00 | O | N | C00572032 | 2022 |
| P60005766,2016 | P60005766 | ABOVE, ZERO, NONE OF THE | W | 2016 | US | P | 00 | O | N | C00572032 | 2016 |
| P60005766,2018 | P60005766 | ABOVE, ZERO, NONE OF THE | W | 2016 | US | P | 00 | O | N | C00572032 | 2018 |
| P60022233,2016 | P60022233 | ABOZAID, ABDULRAQEEB | DEM | 2016 | US | P | 00 | O | N | 2016 | |
| P60022290,2016 | P60022290 | ABOZAID, ABDULRAQEEBB MR. | IND | 2016 | US | P | 00 | O | N | C00622092 | 2016 |
| P60022290,2018 | P60022290 | ABOZAID, ABDULRAQEEBB MR. | IND | 2016 | US | P | 00 | O | N | C00622092 | 2018 |
| P40006546,2024 | P40006546 | ABRAHAM, TERRANCE | IND | 2024 | US | P | 00 | C | N | 2024 | |
| P40006546,2022 | P40006546 | ABRAHAM, TERRANCE | IND | 2024 | US | P | 00 | N | 2022 | ||
| P40006538,2024 | P40006538 | ABRAHAM, TERRANCE MORKEECH | AIP | 2024 | US | P | 00 | C | N | 2024 | |
| P40007429,2024 | P40007429 | ABRAHAM, TERRANCE MORKEECH | IND | 2024 | US | P | 00 | C | N | C00806166 | 2024 |
| P40007429,2026 | P40007429 | ABRAHAM, TERRANCE MORKEECH | IND | 2024 | US | P | 00 | C | N | C00806166 | 2026 |
| P40006538,2022 | P40006538 | ABRAHAM, TERRANCE MORKEECH | AIP | 2024 | US | P | 00 | N | 2022 | ||
| P40007429,2022 | P40007429 | ABRAHAM, TERRANCE MORKEECH | IND | 2024 | US | P | 00 | N | C00806166 | 2022 | |
| P60024031,2024 | P60024031 | ABRAMS, JUSTIN | APF | 2025 | US | P | 00 | N | C00877910 | 2024 | |
| P60024031,2026 | P60024031 | ABRAMS, JUSTIN | APF | 2025 | US | P | 00 | C | N | C00877910 | 2026 |
| P00012732,2024 | P00012732 | ABRAMSON, MAX | VET | 2020 | US | P | 00 | C | N | C00723262 | 2024 |
| P00012732,2020 | P00012732 | ABRAMSON, MAX | VET | 2020 | US | P | 00 | C | N | C00723262 | 2020 |
| P00012732,2022 | P00012732 | ABRAMSON, MAX | VET | 2020 | US | P | 00 | C | N | C00723262 | 2022 |
| P00006270,2024 | P00006270 | ABRAUGH, MATTHEW M. MR. | NON | 2020 | US | P | 00 | C | N | C00653931 | 2024 |
| P00006270,2020 | P00006270 | ABRAUGH, MATTHEW M. MR. | NON | 2020 | US | P | 00 | C | N | C00653931 | 2020 |
| P00006270,2022 | P00006270 | ABRAUGH, MATTHEW M. MR. | NON | 2020 | US | P | 00 | C | N | C00653931 | 2022 |
| P00006270,2018 | P00006270 | ABRAUGH, MATTHEW M. MR. | NON | 2020 | US | P | 00 | N | C00653931 | 2018 | |
| P40011710,2024 | P40011710 | ACEVEDO DIAZ PARES MIRANDA, VANDERELMO | STA | 2024 | US | P | 00 | C | N | 2024 | |
| P40011769,2024 | P40011769 | ACEVEDO DIAZ PARES MIRANDA, VANDERELMO | STA | 2024 | US | P | 00 | C | N | 2024 | |
| P40007163,2024 | P40007163 | ACEVEDO DIAZ, VANDERELMO JAMES ACEVEDO | W | 2024 | US | P | 00 | C | N | 2024 | |
| P40007163,2022 | P40007163 | ACEVEDO DIAZ, VANDERELMO JAMES ACEVEDO VANDY SR. | W | 2024 | US | P | 00 | N | 2022 | ||
| P00009217,2024 | P00009217 | ACKER, BRANDON W | DEM | 2020 | US | P | 00 | C | N | C00693770 | 2024 |
| P00009217,2020 | P00009217 | ACKER, BRANDON W | DEM | 2020 | US | P | 00 | C | N | C00693770 | 2020 |
| P00009217,2022 | P00009217 | ACKER, BRANDON W | DEM | 2020 | US | P | 00 | C | N | C00693770 | 2022 |
| P00014241,2024 | P00014241 | ACKER, RYAN | NON | 2020 | US | P | 00 | C | N | C00726448 | 2024 |
| P00014241,2020 | P00014241 | ACKER, RYAN | NON | 2020 | US | P | 00 | C | N | C00726448 | 2020 |
| P00014241,2022 | P00014241 | ACKER, RYAN | NON | 2020 | US | P | 00 | C | N | C00726448 | 2022 |
| P00008979,2020 | P00008979 | ACORD, ROBERT BRADFORD LEE | DEM | 2020 | US | P | 00 | C | N | 2020 | |
| P00008979,2018 | P00008979 | ACORD, ROBERT BRADFORD LEE | DEM | 2020 | US | P | 00 | N | 2018 | ||
| P60020708,2016 | P60020708 | ACOSTA, MARIO | AIP | 2016 | US | P | 00 | O | N | 2016 | |
| P00016469,2024 | P00016469 | ADALIA, ZOILO MR | DGR | 2020 | US | P | 00 | C | N | 2024 | |
| P00016469,2020 | P00016469 | ADALIA, ZOILO MR | DGR | 2020 | US | P | 00 | C | N | 2020 | |
| P00016469,2022 | P00016469 | ADALIA, ZOILO MR | DGR | 2020 | US | P | 00 | C | N | 2022 | |
| P40019499,2024 | P40019499 | ADAMCZYK, SELMA M | IND | 2024 | US | P | 00 | C | N | C00873422 | 2024 |
| P40019499,2026 | P40019499 | ADAMCZYK, SELMA M | IND | 2024 | US | P | 00 | C | N | C00873422 | 2026 |
| P40013443,2026 | P40013443 | ADAMS EDWARDS, RACHEL | OTH | 2028 | US | P | 00 | N | C00843169 | 2026 | |
| P40013443,2024 | P40013443 | ADAMS EDWARDS, RACHEL AZELL DR. | OTH | 2024 | US | P | 00 | C | N | C00843169 | 2024 |
| P60019965,2016 | P60019965 | ADAMS III, PHILIP MONROE | OTH | 2016 | US | P | 00 | O | N | C00609685 | 2016 |
| P60019965,2018 | P60019965 | ADAMS III, PHILIP MONROE | OTH | 2016 | US | P | 00 | O | N | C00609685 | 2018 |
| P20003232,2012 | P20003232 | ADAMS, DOROTHY ANN | 2012 | US | P | 00 | C | N | C00500231 | 2012 | |
| P20003232,2014 | P20003232 | ADAMS, DOROTHY ANN | 2012 | US | P | 00 | C | N | C00500231 | 2014 | |
| P20003232,2016 | P20003232 | ADAMS, DOROTHY ANN | 2012 | US | P | 00 | C | N | C00500231 | 2016 | |
| P00015529,2020 | P00015529 | ADAMS, EMILY ROSE MS | DEM | 2020 | US | P | 00 | C | N | 2020 | |
| P00015529,2022 | P00015529 | ADAMS, EMILY ROSE MS | DEM | 2020 | US | P | 00 | C | N | 2022 | |
| P60009008,2016 | P60009008 | ADAMS, JACK LYNN | REP | 2016 | US | P | 00 | O | N | C00582106 | 2016 |
| P40011090,2024 | P40011090 | ADAMS, LINCOLN CHAMBERS | REP | 2024 | US | P | 00 | C | N | 2024 | |
| P60019304,2016 | P60019304 | ADAMS, PAUL R | IND | 2016 | US | P | 00 | O | N | C00606830 | 2016 |
| P60019304,2018 | P60019304 | ADAMS, PAUL R | IND | 2016 | US | P | 00 | O | N | C00606830 | 2018 |
| P80004625,2010 | P80004625 | ADAMS, STEPHEN PAUL | IND | 2008 | US | P | 00 | C | N | C00438036 | 2010 |
| P60014453,2016 | P60014453 | ADAMS, THOMAS ALAN MR | IND | 2016 | US | P | 00 | O | N | 2016 | |
| P60013992,2016 | P60013992 | ADDVENSKY, MICHAEL EDWARD | REP | 2016 | US | P | 00 | O | N | 2016 | |
| P60004793,2010 | P60004793 | ADESHINA, YINKA ABOSEDE | DEM | 2016 | US | P | 00 | C | N | C00489195 | 2010 |
| P60004793,2012 | P60004793 | ADESHINA, YINKA ABOSEDE | REP | 2012 | US | P | 00 | C | N | C00489195 | 2012 |
| P60004793,2014 | P60004793 | ADESHINA, YINKA ABOSEDE | REP | 2016 | US | P | 00 | O | C | C00489195 | 2014 |
| P60004793,2016 | P60004793 | ADESHINA, YINKA ABOSEDE | REP | 2016 | US | P | 00 | O | C | C00489195 | 2016 |
| P60004793,2018 | P60004793 | ADESHINA, YINKA ABOSEDE | REP | 2016 | US | P | 00 | O | P | C00489195 | 2018 |
| P00009563,2024 | P00009563 | AEBI, ESTHER CAROLINE | DEM | 2020 | US | P | 00 | C | N | C00694885 | 2024 |
| P00009563,2020 | P00009563 | AEBI, ESTHER CAROLINE | DEM | 2020 | US | P | 00 | C | N | C00694885 | 2020 |
| P00009563,2022 | P00009563 | AEBI, ESTHER CAROLINE | DEM | 2020 | US | P | 00 | C | N | C00694885 | 2022 |
| P40017493,2024 | P40017493 | AFRICACANA, QUINCI | REP | 2024 | US | P | 00 | C | N | 2024 | |
| P40017493,2026 | P40017493 | AFRICACANA, QUINCI | REP | 2024 | US | P | 00 | C | N | 2026 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);