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

298 rows where cand_office = "H" and cand_pty_affiliation = "UNK" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

cand_office_st >30

  • FL 47
  • CA 26
  • OH 26
  • CO 23
  • NY 19
  • MA 16
  • CT 15
  • LA 10
  • NC 10
  • AZ 8
  • MD 8
  • TX 8
  • MI 7
  • KY 6
  • PA 6
  • UT 6
  • GA 5
  • RI 5
  • VA 5
  • AS 3
  • DE 3
  • ID 3
  • IL 3
  • MN 3
  • NJ 3
  • WI 3
  • AL 2
  • AR 2
  • HI 2
  • MS 2
  • …

cand_pty_affiliation 1

  • UNK · 298 ✖

cand_office 1

  • H · 298 ✖
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
H6CT05173,2016 H6CT05173 ADAMS, ANN-MARIE UNK 2016 CT H 05 C N   2016
H0CA24132,2010 H0CA24132 AGUIAR, LANCE UNK 2010 CA H 24 C N C00485359 2010
H2TX35086,2012 H2TX35086 ALVARADO, SIMON UNK 2012 TX H 35 C C C00528000 2012
H2TX35086,2014 H2TX35086 ALVARADO, SIMON UNK 2012 TX H 35 C P C00528000 2014
H4NY09090,2018 H4NY09090 ANABILAH-AZUMAH, JOEL UNK 2018 NY H 09 C N C00613182 2018
H6CA22166,2016 H6CA22166 ANDRES, TERESITA AYA UNK 2016 CA H 22 C N C00593566 2016
H6CA22166,2018 H6CA22166 ANDRES, TERESITA AYA UNK 2016 CA H 22 C N C00593566 2018
H0FL03084,2010 H0FL03084 ANNARUMMA, JOHN UNK 2010 FL H 06 C N C00469387 2010
H0FL03084,2012 H0FL03084 ANNARUMMA, JOHN UNK 2010 FL H 06 C N C00469387 2012
H0FL03084,2014 H0FL03084 ANNARUMMA, JOHN UNK 2010 FL H 06 C N C00469387 2014
H0FL03084,2016 H0FL03084 ANNARUMMA, JOHN UNK 2010 FL H 06 C N C00469387 2016
H0FL03084,2018 H0FL03084 ANNARUMMA, JOHN UNK 2010 FL H 06 C N C00469387 2018
H2OH07142,2014 H2OH07142 APPLEGATE, RALPH A. UNK 2014 OH H 03 C N   2014
H4NY09090,2020 H4NY09090 AZUMAH, JOEL UNK 2020 NY H 09 C N C00613182 2020
H0MA03038,2010 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2010
H0MA03038,2012 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2012
H0MA03038,2014 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2014
H0MA03038,2016 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2016
H0MA03038,2018 H0MA03038 BARRON, PATRICK UNK 2010 MA H 03 C N C00472688 2018
H2FL17080,2012 H2FL17080 BAUMANN, TOM UNK 2012 FL H 17 C N   2012
H6OH12135,2016 H6OH12135 BAUMEISTER, JOHN J. UNK 2016 OH H 12 C N   2016
H2KY02117,2012 H2KY02117 BEACHAM, ANDREW R. UNK 2012 KY H 02 C N C00531541 2012
H2KY02117,2014 H2KY02117 BEACHAM, ANDREW R. UNK 2012 KY H 02 C N C00531541 2014
H8UT03394,2018 H8UT03394 BENNETT, JAMES MCKAY UNK 2017 UT H 03 O C C00656116 2018
H6AZ05083,2018 H6AZ05083 BIGGS, ANDY MR. UNK 2018 AZ H 05 I C C00610451 2018
H6TX03242,2026 H6TX03242 BLACK, BRITTANY UNK 2026 TX H 03 C N C00928580 2026
H2CO01223,2022 H2CO01223 BOSWELL, IRIS RHIANNON AURORA UNK 2022 CO H 01 C N C00823666 2022
H2CO01223,2024 H2CO01223 BOSWELL, IRIS RHIANNON AURORA UNK 2022 CO H 01 C N C00823666 2024
H8FL15073,2010 H8FL15073 BOUFFARD, JEFFREY BRIAN UNK 2008 FL H 15 C N C00441766 2010
H8FL15073,2012 H8FL15073 BOUFFARD, JEFFREY BRIAN UNK 2008 FL H 15 O N C00441766 2012
H8FL15073,2014 H8FL15073 BOUFFARD, JEFFREY BRIAN UNK 2008 FL H 15 O N C00441766 2014
H8FL15073,2016 H8FL15073 BOUFFARD, JEFFREY BRIAN UNK 2008 FL H 15 O N C00441766 2016
H8FL15073,2018 H8FL15073 BOUFFARD, JEFFREY BRIAN UNK 2008 FL H 15 O N C00441766 2018
H6MI12041,2014 H6MI12041 BOWMAN, JOHN T. UNK 1978 MI H 12   A C00025460 2014
H0AL00016,2010 H0AL00016 BOZEMAN, MARTHA RENEE UNK 2010 AL H 07 O C C00464040 2010
H0AL00016,2012 H0AL00016 BOZEMAN, MARTHA RENEE UNK 2010 AL H 07 O C C00464040 2012
H0KY03218,2010 H0KY03218 BRINKSNEADER, DARREN UNK 2010 KY H 03 C N C00477208 2010
H2OH03166,2012 H2OH03166 BROWN, JEFF UNK 2012 OH H 03 C N   2012
H0OH15040,2010 H0OH15040 BUCKEL, WILLIAM LOREN UNK 2010 OH H 15 C N C00352781 2010
H0FL19072,2010 H0FL19072 BUDD, JOSEPH E UNK 2010 FL H 19 C C C00466037 2010
H0FL19072,2012 H0FL19072 BUDD, JOSEPH E UNK 2010 FL H 19 C P C00466037 2012
H8GA08035,2014 H8GA08035 CAIN, RONALD L UNK 2014 GA H 08 C N C00340976 2014
H8MT00093,2018 H8MT00093 CAMPBELL, DOUGLAS BRUCE II UNK 2018 MT H 00 C N   2018
H4CA53083,2014 H4CA53083 CAMPBELL, JOHN W UNK 2014 CA H 53 C C C00558650 2014
H2CO03146,2012 H2CO03146 CASIDA, TISHA TRINETTE UNK 2012 CO H 03 C C C00506188 2012
H2CO03146,2014 H2CO03146 CASIDA, TISHA TRINETTE UNK 2014 CO H 03 C C C00506188 2014
H2CO03146,2016 H2CO03146 CASIDA, TISHA TRINETTE UNK 2016 CO H 03 C N C00616540 2016
H2CO03146,2018 H2CO03146 CASIDA, TISHA TRINETTE UNK 2016 CO H 03 C N C00506188 2018
H6UT02333,2012 H6UT02333 CHRISTENSEN, LAVAR UNK 2006 UT H 02 C P C00417204 2012
H0MA05090,2010 H0MA05090 CLARK, ROBERT MICHAEL UNK 2010 MA H 05 C C C00481143 2010
H0MA05090,2012 H0MA05090 CLARK, ROBERT MICHAEL UNK 2010 MA H 05 C P C00481143 2012
H0KY06153,2010 H0KY06153 COLLINS, C WES UNK 2010 KY H 06 C N   2010
H2OH02077,2012 H2OH02077 CONDIT, JR., JIM UNK 2012 OH H 08 C N C00430736 2012
H2OH02077,2020 H2OH02077 CONDIT, JR., JIM UNK 2020 OH H 02 C N C00430736 2020
H0OH02121,2010 H0OH02121 CONOVER, RANDY LEE UNK 2010 OH H 02 C N   2010
H6ID01243,2018 H6ID01243 COUNSIL, GORDON JOE UNK 2018 ID H 01 O N C00582510 2018
H6ID01243,2020 H6ID01243 COUNSIL, GORDON JOE UNK 2018 ID H 01 O N C00582510 2020
H8TX02166,2018 H8TX02166 CRENSHAW, DANIEL UNK 2018 TX H 02 O C C00660795 2018
H6TX01279,2016 H6TX01279 CULLER, RENEE UNK 2016 TX H 01 C N   2016
H4GA04058,2014 H4GA04058 DAVIS, RAYMOND LEE UNK 2014 GA H 04 C N C00398875 2014
H2IL13120,2016 H2IL13120 DAVIS, RODNEY L UNK 2016 IL H 13 I C C00521948 2016
H0MD07098,2010 H0MD07098 DICKSON, FRED DONALD JR., UNK 2010 MD H 07 C N   2010
H4CO04082,2014 H4CO04082 DOHERTY, GRANT UNK 2014 CO H 04 O C C00555912 2014
H4CO04082,2016 H4CO04082 DOHERTY, GRANT UNK 2014 CO H 04 O P C00555912 2016
H4CO04082,2018 H4CO04082 DOHERTY, GRANT UNK 2014 CO H 04 O P C00555912 2018
H2CA52105,2012 H2CA52105 DOYLE, JACK UNK 2012 CA H 52 C C C00518431 2012
H4MI08259,2024 H4MI08259 DRAVES, MARY F. UNK 2024 MI H 08 O C C00874891 2024
H4MI08259,2026 H4MI08259 DRAVES, MARY F. UNK 2024 MI H 08 O P C00874891 2026
H6MA09131,2010 H6MA09131 DUNKELBARGER, PHILIP L UNK 2010 MA H 09 C C C00481929 2010
H6MA09131,2012 H6MA09131 DUNKELBARGER, PHILIP L UNK 2010 MA H 09 C P C00481929 2012
H6MA09131,2014 H6MA09131 DUNKELBARGER, PHILIP L UNK 2010 MA H 09 C P C00481929 2014
H2FL20118,2012 H2FL20118 DUTROW, ANTHONY M. UNK 2012 FL H 20 C N   2012
H4NC09130,2014 H4NC09130 ECKLES, SHAWN UNK 2014 NC H 09 C N C00542738 2014
H4NC09130,2016 H4NC09130 ECKLES, SHAWN UNK 2014 NC H 09 C N C00542738 2016
H4NC09130,2018 H4NC09130 ECKLES, SHAWN UNK 2014 NC H 09 C N C00542738 2018
H6FL23089,2018 H6FL23089 ENDRISS, DONALD UNK 2018 FL H 23 C C C00679258 2018
H8VA01220,2020 H8VA01220 ENNIS, CRAIG E UNK 2008 VA H 01 C N C00704908 2020
H8VA01220,2022 H8VA01220 ENNIS, CRAIG E UNK 2008 VA H 01 C N C00704908 2022
H6OH02292,2016 H6OH02292 EVERHARD, JANET UNK 2016 OH H 02 C N   2016
H0CO04163,2010 H0CO04163 FAHLANEIGH, ROCHE UNK 2010 CO H 04 C N   2010
H2NC08151,2012 H2NC08151 FOREMAN, TODD MONTGOMERY UNK 2012 NC H 08 C N C00496794 2012
H2NC08151,2014 H2NC08151 FOREMAN, TODD MONTGOMERY UNK 2012 NC H 08 C N C00496794 2014
H2NC08151,2016 H2NC08151 FOREMAN, TODD MONTGOMERY UNK 2012 NC H 08 C N C00496794 2016
H6DE00230,2016 H6DE00230 FRANZ, ROBERT NELSON III UNK 2016 DE H 00 O N   2016
H0MN06135,2010 H0MN06135 FREIHAMMER, TROY THOMAS UNK 2010 MN H 06 C N C00470195 2010
H4MD05177,2014 H4MD05177 FRITZ, DENNIS L. UNK 2014 MD H 05 C N   2014
H4CO00015,2010 H4CO00015 FRITZ, JIM UNK 2010 CO H 03 C N C00390559 2010
H8UT02305,2018 H8UT02305 GARBETT, JAN UNK 2018 UT H 02 C C C00669879 2018
H8UT02305,2020 H8UT02305 GARBETT, JAN UNK 2018 UT H 02 C P C00669879 2020
H4CA04110,2014 H4CA04110 GERLACH, JEFFREY D UNK 2014 CA H 04 C N C00559849 2014
H0FL08166,2010 H0FL08166 GERRITZEN, STEVEN J UNK 2010 FL H 08 C N C00475459 2010
H0FL08166,2012 H0FL08166 GERRITZEN, STEVEN J UNK 2010 FL H 08 C N C00475459 2012
H0FL08166,2014 H0FL08166 GERRITZEN, STEVEN J UNK 2010 FL H 08 C N C00475459 2014
H0FL08166,2016 H0FL08166 GERRITZEN, STEVEN J UNK 2010 FL H 08 C N C00475459 2016
H0FL08166,2018 H0FL08166 GERRITZEN, STEVEN J UNK 2010 FL H 08 C N C00475459 2018
H2VA11172,2014 H2VA11172 GIBSON, MARK TIMOTHY UNK 2014 VA H 11 C C C00558783 2014
H2FL08071,2012 H2FL08071 GILLMOR, RICHARD H UNK 2012 FL H 08 C C C00524223 2012
H2FL08071,2014 H2FL08071 GILLMOR, RICHARD H UNK 2012 FL H 08 C P C00524223 2014
H6AZ03229,2016 H6AZ03229 GO VEGAN UNK 2016 AZ H 03 C N C00621292 2016
H6AZ03229,2018 H6AZ03229 GO VEGAN UNK 2016 AZ H 03 C N C00621292 2018

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