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

71 rows where cand_pty_affiliation = "REF" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_election_yr, cand_office_district, cand_ici, cand_status, cand_pcc, cycle

cand_office_st 12

  • US 22
  • MS 21
  • NY 8
  • KS 6
  • IL 5
  • NJ 2
  • WA 2
  • CO 1
  • FL 1
  • KY 1
  • LA 1
  • TN 1

cand_office 3

  • H 32
  • P 22
  • S 17

cand_pty_affiliation 1

  • REF · 71 ✖
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
S0WA00399,2010 S0WA00399 BAKER, WILL REF 2010 WA S 00 C N   2010
S0WA00399,2012 S0WA00399 BAKER, WILL REF 2012 WA S 00 C N   2012
P80005499,2012 P80005499 BALDWIN, CHARLES OBADIAH REF 2012 US P 00 C N C00449983 2012
S0KS00133,2010 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2010
S0KS00133,2012 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2012
S0KS00133,2014 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2014
S0KS00133,2016 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2016
S0KS00133,2018 S0KS00133 BELLIS, JOSEPH K III REF 2010 KS S 00 O N C00473801 2018
P80000805,2010 P80000805 BUCHANAN, PATRICK J REF 2000 US P 00 C P C00361352 2010
P80000805,2012 P80000805 BUCHANAN, PATRICK J REF 2000 US P 00 C P C00361352 2012
H8NJ01192,2012 H8NJ01192 CHAPMAN, MARGARET M REF 2012 NJ H 01 C N   2012
H8NY17110,2020 H8NY17110 CIARDULLO, JOSEPH JOHN REF 2018 NY H 17 C P C00679936 2020
H8NY17110,2018 H8NY17110 CIARDULLO, JOSEPH JOHN REF 2018 NY H 17 C C C00679936 2018
H8MS05179,2012 H8MS05179 CLAUNCH, ROBERT REF 2012 MS H 04 C N   2012
P80005366,2014 P80005366 CROSS, KENNETH ROBERT REF 2016 US P 00   N C00446526 2014
P80005366,2016 P80005366 CROSS, KENNETH ROBERT REF 2016 US P 00 O N C00446526 2016
P00014670,2024 P00014670 D?AMICO, SAMUEL NICHOLAS MR REF 2020 US P 00 C N C00729541 2024
P00014670,2020 P00014670 D?AMICO, SAMUEL NICHOLAS MR REF 2020 US P 00 C N C00729541 2020
P00014670,2022 P00014670 D?AMICO, SAMUEL NICHOLAS MR REF 2020 US P 00 C N C00729541 2022
H8NY07053,2018 H8NY07053 DILLON, JAMES J. REF 2018 NY H 14 C N   2018
H2FL01209,2014 H2FL01209 DRUMMOND, WILLIAM CLEAVE II REF 2014 FL H 02 C N C00507624 2014
H8KS04070,2010 H8KS04070 DUCEY, SUSAN G. REF 2010 KS H 04 O N   2010
H6CO04152,2010 H6CO04152 EIDSNESS, FREDERIC ARNOLD REF 2006 CO H 04 C P C00424564 2010
H0TN07248,2020 H0TN07248 ESTES, BENJAMIN C REF 2020 TN H 07 C N   2020
P40021347,2024 P40021347 GIBB, JOHN R REF 2024 US P 00 C N   2024
H6NY11224,2016 H6NY11224 GILDER, LAWRENCE E REF 2016 NY H 11 C N C00611830 2016
H6NY11224,2018 H6NY11224 GILDER, LAWRENCE E REF 2016 NY H 11 C N C00611830 2018
H8MS02069,2018 H8MS02069 HARRIS, IRVING REF 2018 MS H 02 C N   2018
H0MS03064,2010 H0MS03064 HILL, TRACELLA LOU O'HARA REF 2010 MS H 03 C N   2010
H4MS04080,2018 H4MS04080 HILL, TRACELLA LOU O'HARA REF 2018 MS H 01 C N C00399147 2018
H8MS03208,2018 H8MS03208 HOLLAND, MATTHEW REF 2018 MS H 03 O N   2018
H4MS04155,2014 H4MS04155 JACKSON, ELI "SARGE REF 2014 MS H 04 C N   2014
P40011652,2024 P40011652 JONES, TONY REF 2024 US P 00 C N   2024
P60017027,2016 P60017027 MARKS, STEPHEN MR. REF 2016 US P 00 O N C00590109 2016
P60017027,2018 P60017027 MARKS, STEPHEN MR. REF 2016 US P 00 O N C00590109 2018
S4IL00362,2010 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2010
S4IL00362,2012 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2012
S4IL00362,2014 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2014
S4IL00362,2016 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2016
S4IL00362,2018 S4IL00362 MARTIN, ANDY REF 2010 IL S 00 O N C00488924 2018
S0LA00287,2010 S0LA00287 MCSHAN , WILLIAM R. REF 2010 LA S 00 C N   2010
H0MS02074,2010 H0MS02074 NORWOOD, ASHLEY REF 2010 MS H 02 C N   2010
S4MS00062,2012 S4MS00062 O'HARA, SHAWN REF 2012 MS S 00 C N C00376210 2012
S4MS00062,2014 S4MS00062 O'HARA, SHAWN REF 2014 MS S 00 C N C00376210 2014
S4MS00062,2018 S4MS00062 O'HARA, SHAWN REF 2018 MS S 00 C N C00376210 2018
H2MS03128,2012 H2MS03128 PANNELL, JOHN LUKE REF 2012 MS H 03 C N   2012
S0KY00412,2020 S0KY00412 PETTEYS, DEREK LEONARD REF 2020 KY S 00 C N C00730473 2020
P00017251,2024 P00017251 PICKENS, RODNEY ALLEN REF 2020 US P 00 C N   2024
P00017251,2020 P00017251 PICKENS, RODNEY ALLEN REF 2020 US P 00 C N   2020
P00017251,2022 P00017251 PICKENS, RODNEY ALLEN REF 2020 US P 00 C N   2022
H2MS01106,2012 H2MS01106 POTTS, CHRIS REF 2012 MS H 01 C N   2012
H0MS04146,2010 H0MS04146 REVIES, ANNA JEWEL REF 2010 MS H 04 C N   2010
P20001376,2024 P20001376 RICHARDSON, DARCY G REF 2020 US P 00 C N C00713677 2024
P20001376,2020 P20001376 RICHARDSON, DARCY G REF 2020 US P 00 C N C00713677 2020
P20001376,2022 P20001376 RICHARDSON, DARCY G REF 2020 US P 00 C N C00713677 2022
H6MS03194,2018 H6MS03194 SHEETS, LAJENA REF 2018 MS H 04 C N   2018
H4MS02191,2014 H4MS02191 SHOEMAKE, SHELLEY REF 2014 MS H 02 C N C00565416 2014
H4MS02191,2016 H4MS02191 SHOEMAKE, SHELLEY REF 2014 MS H 02 C N C00565416 2016
H4MS02191,2018 H4MS02191 SHOEMAKE, SHELLEY REF 2014 MS H 02 C N C00565416 2018
P20004313,2012 P20004313 STEELE, ROBERT DAVID REF 2012 US P 00 C N C00507756 2012
H6NJ06211,2012 H6NJ06211 TARBOUS, HERBERT L. REF 2012 NJ H 06 C N   2012
H4MS01128,2014 H4MS01128 WALLEY, LAJENA REF 2014 MS H 01 C N   2014
H4MS01102,2010 H4MS01102 WASHER, BARBARA DALE REF 2010 MS H 01 C N C00399162 2010
P20005286,2012 P20005286 WASHER, BARBARA DALE REF 2012 US P 00 C N   2012
H4MS01102,2014 H4MS01102 WASHER, BARBARA DALE REF 2014 MS H 03 C N C00399162 2014
H8NY08093,2020 H8NY08093 WHITE, JESSICA L. REF 2018 NY H 08 C N C00672188 2020
H8NY08093,2022 H8NY08093 WHITE, JESSICA L. REF 2018 NY H 08 C N C00672188 2022
H8NY08093,2018 H8NY08093 WHITE, JESSICA L. REF 2018 NY H 08 C N   2018
P20003620,2012 P20003620 WHITLEY, MICHAEL EDWIN REF 2012 US P 00 C N C00503037 2012
P20003620,2014 P20003620 WHITLEY, MICHAEL EDWIN REF 2012 US P 00 C N C00503037 2014
H2MS02146,2012 H2MS02146 WILLIAMS, LAJENA REF 2012 MS H 02 C N   2012

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