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

886 rows where cand_pty_affiliation = "W" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_election_yr, cand_ici, cand_status, cycle

cand_office_st >30

  • US 527
  • AZ 58
  • FL 46
  • CA 34
  • OH 32
  • IL 19
  • CT 17
  • GA 15
  • IN 15
  • TX 13
  • CO 10
  • KY 9
  • NY 9
  • MD 8
  • VA 8
  • AK 7
  • NM 5
  • SC 5
  • UT 5
  • AR 4
  • DE 4
  • MI 4
  • MN 4
  • NJ 4
  • PA 3
  • WA 3
  • WV 3
  • HI 2
  • MA 2
  • WI 2
  • …

cand_office 3

  • P 527
  • H 227
  • S 132

cand_pty_affiliation 1

  • W · 886 ✖
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
H0VA10152,2024 H0VA10152 ABDALLAH, UNIT89487 W 2020 VA H 10 C N C00691386 2024
H0VA10152,2020 H0VA10152 ABDALLAH, UNIT89487 W 2020 VA H 10 C N C00691386 2020
H0VA10152,2022 H0VA10152 ABDALLAH, UNIT89487 W 2020 VA H 10 C N C00691386 2022
H0VA10152,2018 H0VA10152 ABDALLAH, UNIT89487 W 2020 VA H 10   N C00691386 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
S4OR00289,2024 S4OR00289 ACCARDI, LORENZO W 2024 OR S 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
P60008182,2016 P60008182 AGUILAR, DANNY GOOGLE W 2016 US P 00 O N   2016
P60018728,2016 P60018728 AISHI, AYANO W 2016 US P 00 O N   2016
P00016931,2024 P00016931 AKERS, ROBERT GALE MR. W 2020 US P 00 C N C00753467 2024
P00016931,2020 P00016931 AKERS, ROBERT GALE MR. W 2020 US P 00 C N C00753467 2020
P00016931,2022 P00016931 AKERS, ROBERT GALE MR. W 2020 US P 00 C N C00753467 2022
H0NY11102,2024 H0NY11102 AKINDUDE, KEMI W 2020 NY H 11 C P C00750893 2024
H0NY11102,2020 H0NY11102 AKINDUDE, KEMI W 2020 NY H 11 C C C00750893 2020
H0NY11102,2022 H0NY11102 AKINDUDE, KEMI W 2020 NY H 11 C P C00750893 2022
P80008915,2026 P80008915 ALLEN, BOBBY LEE W 2028 US P 00   N C00937359 2026
S2IN00364,2024 S2IN00364 ALVAREZ, ANTONIO XAVIER W 2024 IN S 00 C N   2024
S2IN00364,2022 S2IN00364 ALVAREZ, ANTONIO XAVIER W 2022 IN S   O N   2022
H2AK00556,2022 H2AK00556 AMBROSE, DAVID W 2022 AK H 00 C N C00822163 2022
H6OH92012,2016 H6OH92012 AMICONE, NICHOLAS W 2016 OH H 92 C N   2016
H6OH92012,2018 H6OH92012 AMICONE, NICHOLAS W 2016 OH H 92 C N   2018
H2OH03208,2022 H2OH03208 AMICUCCI, ALEXANDER Q. W 2022 OH H 03 C N   2022
S2CT00355,2022 S2CT00355 ANDERSON, JOHN W 2022 CT S   O N   2022
H8AZ04157,2018 H8AZ04157 ANDRESKI, THADDEUS J MR. II W 2018 AZ H 04 C N C00667535 2018
P80008899,2026 P80008899 ANTONIK, JAMES ROBERT MR. W 2028 US P 00   N C00936310 2026
H4NJ08139,2024 H4NJ08139 ARANGO, ALEXANDER W 2024 NJ H 08 C N   2024
P40019291,2024 P40019291 ARENARE, BRIAN W 2024 US P 00 C N   2024
S0AZ00384,2024 S0AZ00384 ARIF, MOHAMMAD W 2020 AZ S 00 C N C00737973 2024
S0AZ00384,2020 S0AZ00384 ARIF, MOHAMMAD W 2020 AZ S 00 C N C00737973 2020
S0AZ00384,2022 S0AZ00384 ARIF, MOHAMMAD W 2020 AZ S 00 C N C00737973 2022
H2AK00267,2024 H2AK00267 ARMSTRONG, JAY R W 2022 AK H 00 O N C00810986 2024
H2AK00267,2022 H2AK00267 ARMSTRONG, JAY R W 2022 AK H 00 O N C00810986 2022
P00014118,2024 P00014118 ARNOLD, EUGENE NATHANIEL MR. III W 2020 US P 00 C N C00726653 2024
P00014118,2020 P00014118 ARNOLD, EUGENE NATHANIEL MR. III W 2020 US P 00 C N C00726653 2020
P00014118,2022 P00014118 ARNOLD, EUGENE NATHANIEL MR. III W 2020 US P 00 C N C00726653 2022
P40018434,2024 P40018434 ASHBURN, WILLIAM CHESTER JR W 2024 US P 00 C N C00863795 2024
P40018434,2026 P40018434 ASHBURN, WILLIAM CHESTER JR W 2024 US P 00 C N C00863795 2026
P40021545,2024 P40021545 ASTELLO, JENNIFER W 2024 US P 00 C N C00889592 2024
P40021545,2026 P40021545 ASTELLO, JENNIFER W 2024 US P 00 C N C00889592 2026
S0CO00740,2020 S0CO00740 ATLAS, MICHAEL SANCHEZ W 2020 CO S 00 C N   2020
H4TX38045,2024 H4TX38045 AYERS, AVERY LAMARR W 2024 TX H 38 C N C00886770 2024
S2IN00331,2022 S2IN00331 BAER, THOMAS W 2022 IN S   O N   2022
P00011403,2020 P00011403 BAGIACKAS, JAMES PENCE RN W 2020 US P 00 C N   2020
H2IN09324,2022 H2IN09324 BAILEY, JACOB W 2022 IN H 09 C N   2022
P60009602,2016 P60009602 BAIRD, DUSTIN ALAN W 2016 US P 00 O N C00582932 2016
P60009602,2018 P60009602 BAIRD, DUSTIN ALAN W 2016 US P 00 O N C00582932 2018
P60021672,2016 P60021672 BAKER, MICHAEL ALLEN REV. W 2016 US P 00 O N   2016
S4GA11376,2024 S4GA11376 BALENO, IRENE STEPHANIE W 2024 GA S 00 C N   2024
H8IN04207,2018 H8IN04207 BALLOCK, THOMAS W 2018 IN H 04 O N C00660308 2018
P40019531,2024 P40019531 BANK, ARI BENJAMIN PROF. W 2024 US P 00 C N   2024
S4MD00673,2024 S4MD00673 BARAJAS, MIGUEL W 2024 MD S     N   2024
P60018702,2020 P60018702 BARBINE, MICHAEL W. W 2020 US P 00 C N   2020
P60018702,2022 P60018702 BARBINE, MICHAEL W. W 2020 US P 00 C N   2022
P60018702,2016 P60018702 BARBINE, MICHAEL W. W 2016 US P 00 O N   2016
P60018702,2018 P60018702 BARBINE, MICHAEL W. W 2020 US P 00   N   2018
P60018702,2024 P60018702 BARBINE, MICHAEL W. MR W 2024 US P 00 C N   2024
P60018702,2026 P60018702 BARBINE, MICHAEL W. MR W 2024 US P 00 C N   2026
P40006462,2024 P40006462 BARDOL, DAVID CHRISTOPHE MR. W 2024 US P 00 C N   2024
P40006462,2022 P40006462 BARDOL, DAVID CHRISTOPHE MR. W 2024 US P 00   N   2022
P60020930,2016 P60020930 BARTMAN, JEREMY EDWARD MR W 2016 US P 00 O N   2016
H6IL05192,2016 H6IL05192 BARZ, MICHAEL THOMAS W 2016 IL H 05 C N C00608794 2016
H6IL05192,2018 H6IL05192 BARZ, MICHAEL THOMAS W 2016 IL H 05 C N C00608794 2018
S2IN00349,2024 S2IN00349 BEACHY, PHILLIP W 2024 IN S 00 C N   2024
S2IN00349,2022 S2IN00349 BEACHY, PHILLIP W 2022 IN S   O N   2022
P40005977,2024 P40005977 BECK, PATRICK W 2024 US P 00 C N C00777318 2024
P40005977,2026 P40005977 BECK, PATRICK W 2024 US P 00 C N C00777318 2026
P40005977,2022 P40005977 BECK, PATRICK W 2024 US P 00   N C00777318 2022
S0AZ00442,2024 S0AZ00442 BECKETT, CHRISTOPHER W 2024 AZ S     N   2024
S0AZ00442,2020 S0AZ00442 BECKETT, CHRISTOPHER W 2020 AZ S 00 C N   2020
S4CA00795,2024 S4CA00795 BERDUGO, EDUARDO MR. W 2024 CA S 00 O N   2024
H2AZ06320,2024 H2AZ06320 BERTONE, FRANK W 2022 AZ H 06 C N C00825927 2024
H2AZ06320,2022 H2AZ06320 BERTONE, FRANK W 2022 AZ H 06 C N C00825927 2022
H2PA05124,2022 H2PA05124 BESTMAN, WILLIAM DAVID W 2022 PA H 05 C N   2022
H0CT02181,2010 H0CT02181 BIANCHI, MURIEL P. W 2010 CT H 02 C N   2010
P40020257,2024 P40020257 BILLOPS, SHAWNSY W 2024 US P 00 C N   2024
P40020273,2024 P40020273 BILLOPS, SHAWNSY W 2024 US P 00 C N   2024
S8AL00480,2018 S8AL00480 BISHOP, RONALD HUBERT JR MR W 2018 AL S 00 C N   2018
P00006502,2024 P00006502 BLUFORD, LARRY D MR. SR W 2020 US P 00 C N C00660258 2024
P00006502,2020 P00006502 BLUFORD, LARRY D MR. SR W 2020 US P 00 C N C00660258 2020
P00006502,2022 P00006502 BLUFORD, LARRY D MR. SR W 2020 US P 00 C N C00660258 2022
P00006502,2018 P00006502 BLUFORD, LARRY D MR. SR W 2020 US P 00   N C00660258 2018
H0CT03148,2012 H0CT03148 BOAZ, ITSHAKY W 2011 CT H 03 C N   2012
P00017202,2024 P00017202 BODDIE, PRESIDENT R19 W 2020 US P 00 C N C00749580 2024
P00017202,2020 P00017202 BODDIE, PRESIDENT R19 W 2020 US P 00 C N C00749580 2020
P00017202,2022 P00017202 BODDIE, PRESIDENT R19 W 2020 US P 00 C N C00749580 2022
H2AZ05207,2022 H2AZ05207 BORDEN, DEBRA JO "D JO" W 2022 AZ H 05 C N   2022
S2AZ00455,2022 S2AZ00455 BORDES, SHERRISE W 2022 AZ S   O N   2022
P00012088,2024 P00012088 BOWHALL, WILLIAM E. JUNIOR W 2020 US P 00 C N   2024
P00012088,2020 P00012088 BOWHALL, WILLIAM E. JUNIOR W 2020 US P 00 C N   2020
P00012088,2022 P00012088 BOWHALL, WILLIAM E. JUNIOR W 2020 US P 00 C N   2022
P00005090,2024 P00005090 BOYER, GREGORY W 2020 US P 00 C N C00621128 2024
P00005090,2020 P00005090 BOYER, GREGORY W 2020 US P 00 C N C00621128 2020
P00005090,2022 P00005090 BOYER, GREGORY W 2020 US P 00 C N C00621128 2022
P00005090,2016 P00005090 BOYER, GREGORY W 2020 US P 00   N C00621128 2016

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 292.247ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API