home / openregs

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

22,776 rows where cand_pty_affiliation = "DEM" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_ici, cand_status, cycle

cand_office_st >30

  • CA 2,260
  • US 2,057
  • TX 1,486
  • NY 1,332
  • FL 1,184
  • IL 946
  • PA 761
  • NC 717
  • OH 686
  • MI 651
  • NJ 645
  • MD 627
  • GA 596
  • VA 527
  • IN 526
  • AZ 477
  • WA 450
  • CO 398
  • TN 386
  • MA 376
  • MO 362
  • WI 335
  • LA 307
  • NV 289
  • SC 281
  • KY 273
  • OR 271
  • AL 243
  • OK 231
  • NM 223
  • …

cand_office 3

  • H 17,684
  • S 3,035
  • P 2,057

cand_pty_affiliation 1

  • DEM · 22,776 ✖
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
H0NC07157,2024 H0NC07157 (TERRI) EVERETT, THERESA DEM 2020 NC H 07 C N C00756320 2024
H0NC07157,2020 H0NC07157 (TERRI) EVERETT, THERESA DEM 2020 NC H 07 C N C00756320 2020
H0NC07157,2022 H0NC07157 (TERRI) EVERETT, THERESA DEM 2020 NC H 07 C N C00756320 2022
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
H8CO06237,2018 H8CO06237 AARESTAD, DAVID DEM 2018 CO H 06 C C C00637678 2018
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
H6MI04188,2026 H6MI04188 AARON, RICHARD DEM 2026 MI H 04 C N C00898031 2026
H0FL21102,2020 H0FL21102 AARONS, ADAM DEM 2020 FL H 21 C N C00728949 2020
H2CA30291,2024 H2CA30291 AAZAMI, SHERVIN DEM 2024 CA H 32 C N C00766634 2024
H2CA30291,2022 H2CA30291 AAZAMI, SHERVIN DEM 2022 CA H 32 C C C00766634 2022
H2MT00039,2012 H2MT00039 ABARR, JOHN ALLEN DEM 2012 MT H 00 O N C00496802 2012
H2MT00039,2014 H2MT00039 ABARR, JOHN ALLEN DEM 2012 MT H 00 O N C00496802 2014
H2MT00039,2016 H2MT00039 ABARR, JOHN ALLEN DEM 2012 MT H 00 O N C00496802 2016
H2MT00039,2018 H2MT00039 ABARR, JOHN ALLEN DEM 2012 MT H 00 O N C00496802 2018
H4CA32152,2024 H4CA32152 ABBITT, DAVE DEM 2024 CA H 32 C N C00859025 2024
H4CA32152,2026 H4CA32152 ABBITT, DAVE DEM 2024 CA H 32 C N C00859025 2026
H4MI03201,2012 H4MI03201 ABBOTT, RICHARD ALLEN IV DEM 2014 MI H 03 C N   2012
H4MI03201,2014 H4MI03201 ABBOTT, RICHARD ALLEN IV DEM 2014 MI H 03 C N   2014
S8AZ00122,2020 S8AZ00122 ABBOUD, DEEDRA DEM 2018 AZ S 00 O P C00637454 2020
S8AZ00122,2018 S8AZ00122 ABBOUD, DEEDRA DEM 2018 AZ S 00 O C C00637454 2018
H8IL16062,2010 H8IL16062 ABBOUD, ROBERT DEM 2008 IL H 16 C C C00437251 2010
H8IL16062,2012 H8IL16062 ABBOUD, ROBERT DEM 2008 IL H 16 C P C00437251 2012
H2NY12197,2024 H2NY12197 ABDELHAMID, RANA DEM 2022 NY H 12 C P C00776658 2024
H2NY12197,2026 H2NY12197 ABDELHAMID, RANA DEM 2022 NY H 12 C P C00776658 2026
H2NY12197,2022 H2NY12197 ABDELHAMID, RANA DEM 2022 NY H 12 C C C00776658 2022
H8MN05163,2018 H8MN05163 ABDULAHI, JAMAL MR. DEM 2018 MN H 05 O C C00682351 2018
H2OH09197,2022 H2OH09197 ABDULLAHI, MUNIRA YASIN DEM 2022 OH H 09 C N   2022
H8GA06377,2020 H8GA06377 ABEL, KEVIN DEM 2018 GA H 06 C P C00658625 2020
H8GA06377,2018 H8GA06377 ABEL, KEVIN DEM 2018 GA H 06 C C C00658625 2018
H2NY04251,2024 H2NY04251 ABELOVE, JASON L DEM 2022 NY H 04 C N C00806679 2024
H2NY04251,2022 H2NY04251 ABELOVE, JASON L DEM 2022 NY H 04 C N C00806679 2022
H0FL05162,2020 H0FL05162 ABENCHUCHAN, ISAIAH DEM 2020 FL H 05 C N C00731299 2020
H6HI01121,2010 H6HI01121 ABERCROMBIE, NEIL DEM 2010 HI H 01 I C C00247379 2010
H6HI01121,2012 H6HI01121 ABERCROMBIE, NEIL DEM 2010 HI H 01 C P C00247379 2012
H4OH15075,2024 H4OH15075 ABID, ZERQA DEM 2024 OH H 15 C C C00837542 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
S4LA00156,2014 S4LA00156 ABLES, MURIEL WAYNE DEM 2014 LA S 00 C C C00568790 2014
S4LA00156,2016 S4LA00156 ABLES, MURIEL WAYNE DEM 2014 LA S 00 C P C00568790 2016
H4RI01281,2024 H4RI01281 ABNEY, MARVIN L. DEM 2023 RI H 01 O C C00839126 2024
H4RI01281,2026 H4RI01281 ABNEY, MARVIN L. DEM 2023 RI H 01 O P C00839126 2026
H4TN05145,2024 H4TN05145 ABOLFAZLI, MARYAM. DEM 2024 TN H 05 C C C00874602 2024
H4TN05145,2026 H4TN05145 ABOLFAZLI, MARYAM. DEM 2024 TN H 05 C P C00874602 2026
H2AZ02279,2012 H2AZ02279 ABOUD, PAULA ANN DEM 2012 AZ H 02 C C C00514810 2012
H2AZ02279,2014 H2AZ02279 ABOUD, PAULA ANN DEM 2012 AZ H 02 C P C00514810 2014
H4FL02112,2024 H4FL02112 ABOUJAOUDE, ROCK ADEL MR. JR DEM 2024 FL H 12 C C C00876888 2024
H4FL02112,2026 H4FL02112 ABOUJAOUDE, ROCK ADEL MR. JR DEM 2024 FL H 12 C P C00876888 2026
H6FL03123,2026 H6FL03123 ABOUJAOUDE, ROCK ADEL MR. JR. DEM 2026 FL H 03 C N C00923086 2026
P60022233,2016 P60022233 ABOZAID, ABDULRAQEEB DEM 2016 US P 00 O N   2016
H4GA06137,2024 H4GA06137 ABRAHAM, SHELLY JOHN DEM 2024 GA H 07 C C C00844803 2024
H4GA06137,2026 H4GA06137 ABRAHAM, SHELLY JOHN DEM 2024 GA H 07 C P C00844803 2026
H4NY04067,2014 H4NY04067 ABRAHAMS, KEVAN DEM 2014 NY H 04 O C C00555292 2014
H4NY04067,2016 H4NY04067 ABRAHAMS, KEVAN DEM 2014 NY H 04 O P C00555292 2016
H8NM01356,2018 H8NM01356 ABRAMS, JOHN E. DEM 2018 NM H 01 O N C00640540 2018
H6CO08039,2026 H6CO08039 ABRATE, DENIS CHARLES MR. DEM 2025 CO H 08 C N C00903161 2026
H6IL09186,2026 H6IL09186 ABREVAYA, DAVID DEM 2026 IL H 09 O N C00902346 2026
H0TX23193,2024 H0TX23193 ABUABARA, ROSALINDA RAMOS DEM 2020 TX H 23 O P C00709071 2024
H0TX23193,2020 H0TX23193 ABUABARA, ROSALINDA RAMOS DEM 2020 TX H 23 O C C00709071 2020
H0TX23193,2022 H0TX23193 ABUABARA, ROSALINDA RAMOS DEM 2020 TX H 23 O P C00709071 2022
S2FL00482,2024 S2FL00482 ABUD, EDWARD DEM 2022 FL S 00 C N C00766535 2024
S2FL00482,2022 S2FL00482 ABUD, EDWARD DEM 2022 FL S 00 C N C00766535 2022
H6IL09178,2026 H6IL09178 ABUGHAZALEH, KATHERINE M. DEM 2026 IL H 09 O C C00900449 2026
H0MO06180,2020 H0MO06180 ABUNDIS, VICTOR DEM 2020 MO H 06 C C C00696922 2020
H8MI10132,2018 H8MI10132 ACCAVITTI, FRANK JR DEM 2018 MI H 10 C C C00678342 2018
H6MI10227,2016 H6MI10227 ACCAVITTI, FRANK MR. JR DEM 2016 MI H 10 O C C00615195 2016
H6MI10227,2018 H6MI10227 ACCAVITTI, FRANK MR. JR DEM 2016 MI H 10 O P C00615195 2018
H2CA18171,2024 H2CA18171 ACEVEDO-ARREGUIN, LUIS DEM 2022 CA H 18 C P C00805770 2024
H2CA18171,2026 H2CA18171 ACEVEDO-ARREGUIN, LUIS DEM 2022 CA H 18 C P C00805770 2026
H2CA18171,2022 H2CA18171 ACEVEDO-ARREGUIN, LUIS DEM 2022 CA H 18 C C C00805770 2022
H8PR00054,2024 H8PR00054 ACEVEDO-VILA, ANIBAL DEM 2020 PR H 00 C P C00738856 2024
H8PR00054,2020 H8PR00054 ACEVEDO-VILA, ANIBAL DEM 2020 PR H 00 C C C00738856 2020
H8PR00054,2022 H8PR00054 ACEVEDO-VILA, ANIBAL DEM 2020 PR H 00 C P C00738856 2022
H2FL10218,2022 H2FL10218 ACHENBACH, JACK JOSEPH DEM 2022 FL H 10 O C C00781799 2022
H8NY05107,2020 H8NY05107 ACHILLE, CARL H. DEM 2018 NY H 05 C P C00669952 2020
H8NY05107,2018 H8NY05107 ACHILLE, CARL H. DEM 2018 NY H 05 C C C00669952 2018
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
H8NC07093,2024 H8NC07093 ACKER, BRANDON W. DEM 2018 NC H 07 C N C00778498 2024
H8NC07093,2022 H8NC07093 ACKER, BRANDON W. DEM 2018 NC H 07 C N C00778498 2022
H8NC07093,2016 H8NC07093 ACKER, BRANDON W. DEM 2018 NC H 07   N C00616953 2016
H8NC07093,2018 H8NC07093 ACKER, BRANDON W. DEM 2018 NC H 07 C N C00616953 2018
H4NY07011,2010 H4NY07011 ACKERMAN, GARY L. DEM 2010 NY H 05 I C C00165241 2010
H4NY07011,2012 H4NY07011 ACKERMAN, GARY L. DEM 2012 NY H 05 I C C00165241 2012
H4NY07011,2014 H4NY07011 ACKERMAN, GARY L. DEM 2014 NY H 05 C N C00165241 2014
H4NY07011,2016 H4NY07011 ACKERMAN, GARY L. DEM 2014 NY H 05 C N C00165241 2016
H4NY07011,2018 H4NY07011 ACKERMAN, GARY L. DEM 2014 NY H 05 C N C00165241 2018
H2KY05144,2012 H2KY05144 ACKERMAN, MICHAEL DEM 2012 KY H 05 C N   2012
H0NV02209,2020 H0NV02209 ACKERMAN, PATRICIA GERALDENE MS. DEM 2020 NV H 02 C C C00726810 2020
H0NV02209,2022 H0NV02209 ACKERMAN, PATRICIA GERALDENE MS. DEM 2020 NV H 02 C P C00726810 2022
H8IN04108,2010 H8IN04108 ACKERSON, NELS DEM 2008 IN H 04 C C C00436857 2010
H8IN04108,2012 H8IN04108 ACKERSON, NELS DEM 2008 IN H 04 C P C00436857 2012

Next page

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);
Powered by Datasette · Queries took 140.846ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API