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

5,097 rows where cand_office_st = "CA" sorted by cand_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cand_ici, cand_status, cycle

cand_pty_affiliation >30

  • DEM 2,260
  • REP 2,054
  • IND 171
  • LIB 84
  • NNE 79
  • GRE 75
  • NPA 71
  • NOP 62
  • OTH 60
  • W 34
  • UNK 28
  • PAF 23
  • UN 14
  • AIP 13
  • NON 11
  • FED 10
  • DGR 6
  • CST 4
  • PFP 4
  • COM 3
  • CON 3
  • FS 3
  • 18 2
  • AIC 2
  • FSP 2
  • IAP 2
  • NPP 2
  • R 2
  • ACE 1
  • CA 1
  • …

cand_office 2

  • H 4,624
  • S 473

cand_office_st 1

  • CA · 5,097 ✖
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
H2CA01110,2012 H2CA01110 AANESTAD, SAMUEL REP 2012 CA H 01 C C C00513580 2012
H2CA01110,2014 H2CA01110 AANESTAD, SAMUEL REP 2012 CA H 01 C P C00513580 2014
H2CA01110,2016 H2CA01110 AANESTAD, SAMUEL REP 2012 CA H 01 C P C00513580 2016
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
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
H0CA50129,2020 H0CA50129 ABED, SAM REP 2020 CA H 50 O C C00710863 2020
H0CA50129,2022 H0CA50129 ABED, SAM REP 2022 CA H 50 C C C00710863 2022
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
H6CA19170,2026 H6CA19170 ACEVEDO-CABRERA, ANA LUZ IND 2026 CA H 19 C N C00940171 2026
H6CA24295,2016 H6CA24295 ACHADJIAN, KHATCHIK REP 2016 CA H 24 O C C00575886 2016
H2CA25176,2012 H2CA25176 ACOSTA, DANTE REP 2012 CA H 25 C C C00517706 2012
H2CA25176,2014 H2CA25176 ACOSTA, DANTE REP 2012 CA H 25 C P C00517706 2014
H2CA25176,2016 H2CA25176 ACOSTA, DANTE REP 2012 CA H 25 C P C00517706 2016
H0CA38173,2024 H0CA38173 ADALIA, ZOILO MR DGR 2020 CA H 38 C N   2024
H0CA50236,2024 H0CA50236 ADALIA, ZOILO MR DGR 2020 CA H 50 O N   2024
H0CA38173,2020 H0CA38173 ADALIA, ZOILO MR DGR 2020 CA H 38 C N   2020
H0CA50236,2020 H0CA50236 ADALIA, ZOILO MR DGR 2020 CA H 50 O N   2020
H0CA38173,2022 H0CA38173 ADALIA, ZOILO MR DGR 2020 CA H 38 C N   2022
H0CA50236,2022 H0CA50236 ADALIA, ZOILO MR DGR 2020 CA H 50 O N   2022
H2CA08180,2012 H2CA08180 ADAMS, ANTHONY T NPA 2012 CA H 08 C C C00513416 2012
H2CA08180,2014 H2CA08180 ADAMS, ANTHONY T NPA 2012 CA H 08 C P C00513416 2014
S8CA00325,2020 S8CA00325 ADAMS, DONALD R REP 2018 CA S 00 C N C00635490 2020
S8CA00325,2018 S8CA00325 ADAMS, DONALD R REP 2018 CA S 00 C N C00635490 2018
H6CA38113,2016 H6CA38113 ADAMS, SCOTT MICHAEL MR. IND 2016 CA H 38 C C C00613588 2016
H4CA49131,2024 H4CA49131 ADAMS, SHERYL REP 2024 CA H 49 C C C00838318 2024
H4CA41120,2014 H4CA41120 ADAMS, STEVE REP 2014 CA H 41 C C C00544882 2014
H4CA41120,2016 H4CA41120 ADAMS, STEVE REP 2014 CA H 41 C P C00544882 2016
H2CA06275,2012 H2CA06275 ADAMS, SUSAN L DEM 2012 CA H 02 O C C00497222 2012
H2CA06275,2014 H2CA06275 ADAMS, SUSAN L DEM 2012 CA H 02 O P C00497222 2014
H6CA38121,2026 H6CA38121 ADAMS-FALCONER, THOMAS MICHAEL JR. DEM 2026 CA H 38 C C C00905786 2026
H4CA20215,2024 H4CA20215 ADDISON WILLIAMS, AUDREY ELIZABETH MS REP 2024 CA H 20 C N   2024
H2CA36348,2012 H2CA36348 ADLER, DANIEL H DEM 2011 CA H 36 O P C00494880 2012
H0CA28133,2024 H0CA28133 AGBEDE, AKINYEMI DEM 2020 CA H 28 C N C00698282 2024
S6CA00634,2024 S6CA00634 AGBEDE, AKINYEMI DEM 2024 CA S   O N C00698282 2024
H0CA28133,2020 H0CA28133 AGBEDE, AKINYEMI DEM 2020 CA H 28 C N C00698282 2020
S6CA00634,2020 S6CA00634 AGBEDE, AKINYEMI DEM 2022 CA S 00   N C00698282 2020
H0CA28133,2022 H0CA28133 AGBEDE, AKINYEMI DEM 2020 CA H 28 C N C00698282 2022
S6CA00634,2022 S6CA00634 AGBEDE, AKINYEMI DEM 2022 CA S 00 C N C00698282 2022
S6CA00634,2016 S6CA00634 AGBEDE, AKINYEMI DEM 2016 CA S 00 O N C00573931 2016
H0CA32184,2010 H0CA32184 AGRELLA, CHRISTOPHER LIB 2009 CA H 32 O N   2010
H0CA24132,2010 H0CA24132 AGUIAR, LANCE UNK 2010 CA H 24 C N C00485359 2010
H2CA31125,2024 H2CA31125 AGUILAR, PETE DEM 2024 CA H 33 I C C00510461 2024
H2CA31125,2026 H2CA31125 AGUILAR, PETE DEM 2026 CA H 33 I C C00510461 2026
H2CA31125,2020 H2CA31125 AGUILAR, PETE DEM 2020 CA H 31 I C C00510461 2020
H2CA31125,2022 H2CA31125 AGUILAR, PETE DEM 2022 CA H 33 I C C00510461 2022
H2CA31125,2012 H2CA31125 AGUILAR, PETE DEM 2012 CA H 31 C C C00510461 2012
H2CA31125,2014 H2CA31125 AGUILAR, PETE DEM 2014 CA H 31 O C C00510461 2014
H2CA31125,2016 H2CA31125 AGUILAR, PETE DEM 2016 CA H 31 I C C00510461 2016
H2CA31125,2018 H2CA31125 AGUILAR, PETE DEM 2018 CA H 31 I C C00510461 2018
H8CA19051,2020 H8CA19051 AGUILERA, JUSTIN REP 2020 CA H 19 C N C00683532 2020
H8CA19051,2022 H8CA19051 AGUILERA, JUSTIN REP 2020 CA H 19 C N C00683532 2022
H8CA19051,2018 H8CA19051 AGUILERA, JUSTIN REP 2018 CA H 19 C C C00683532 2018
H6CA40358,2026 H6CA40358 AHMED, CHRISTIAN TYLER IND 2026 CA H 40 C N C00904433 2026
H6CA31159,2020 H6CA31159 AHMED, KAISAR DEM 2018 CA H 31 C N C00617209 2020
H6CA31159,2022 H6CA31159 AHMED, KAISAR DEM 2018 CA H 31 C N C00617209 2022
H6CA31159,2016 H6CA31159 AHMED, KAISAR DEM 2016 CA H 31 C N   2016
H6CA31159,2018 H6CA31159 AHMED, KAISAR DEM 2018 CA H 31 C N   2018
H8CA34217,2018 H8CA34217 AHN, JASON DR. DEM 2017 CA H 34 O N   2018
H8CA34258,2024 H8CA34258 AHN, ROBERT LEE DEM 2017 CA H 34 O P C00631564 2024
H8CA34258,2026 H8CA34258 AHN, ROBERT LEE DEM 2017 CA H 34 O P C00631564 2026
H8CA34258,2020 H8CA34258 AHN, ROBERT LEE DEM 2017 CA H 34 O P C00631564 2020
H8CA34258,2022 H8CA34258 AHN, ROBERT LEE DEM 2017 CA H 34 O P C00631564 2022
H8CA34258,2018 H8CA34258 AHN, ROBERT LEE DEM 2017 CA H 34 O C C00631564 2018
H4CA32145,2024 H4CA32145 AHUJA, CHRISTOPHER DEM 2024 CA H 32 C N C00858746 2024
H4CA32145,2026 H4CA32145 AHUJA, CHRISTOPHER DEM 2026 CA H 32 C C C00858746 2026
H0CA35138,2020 H0CA35138 AHUMADA, ALFREDO DEM 2020 CA H 35 C N   2020
S2CA00963,2024 S2CA00963 AINSWORTH, BRIAN KEVIN REP 2022 CA S 00 C N C00769042 2024
S2CA00963,2022 S2CA00963 AINSWORTH, BRIAN KEVIN REP 2022 CA S 00 C N C00769042 2022
H2CA02134,2012 H2CA02134 AKHLAGHI, BANAFSHEH DEM 2012 CA H 02 O C C00503490 2012
H6CA29229,2016 H6CA29229 ALARCON, RICHARD ANTHONY MR. DEM 2016 CA H 29 C C C00611939 2016
H4CA32103,2014 H4CA32103 ALAS, ARTURO E III REP 2014 CA H 32 C C C00550574 2014
H2CA08198,2012 H2CA08198 ALBERTSEN, DENNIS L. REP 2012 CA H 08 C N   2012
S6CA00618,2016 S6CA00618 ALBERTSON, STEWART DEM 2016 CA S 00 O C C00573220 2016
H6CA41315,2026 H6CA41315 ALEMAN, KATHERINE DEM 2026 CA H 41 C C C00912782 2026
H8CA37301,2020 H8CA37301 ALEMAYHU, TED OTH 2018 CA H 39 O N C00638734 2020
H8CA37301,2018 H8CA37301 ALEMAYHU, TED OTH 2018 CA H 39 O N C00638734 2018
H8CA39273,2020 H8CA39273 ALEXANDER, SOPHIA JOSEPHINE 8506376927 IND 2018 CA H 39 O N C00670000 2020
H8CA39273,2018 H8CA39273 ALEXANDER, SOPHIA JOSEPHINE 8506376927 IND 2018 CA H 39 O N C00670000 2018
S2CA00815,2012 S2CA00815 ALI, KABIRUDDIN KARIM PAF 2012 CA S 00 C N   2012
H6CA01103,2010 H6CA01103 ALIOTO, MICHELA A DEM 1996 CA H 01 C P C00308403 2010
H6CA01103,2012 H6CA01103 ALIOTO, MICHELA A DEM 1996 CA H 01 C P C00308403 2012
H4CA24175,2022 H4CA24175 ALLEN, BRAD DR REP 2022 CA H 24 C N C00557124 2022
H4CA24175,2014 H4CA24175 ALLEN, BRAD DR REP 2014 CA H 24 C C C00557124 2014
H4CA24175,2016 H4CA24175 ALLEN, BRAD DR REP 2014 CA H 24 C P C00557124 2016
H4CA24175,2018 H4CA24175 ALLEN, BRAD DR REP 2014 CA H 24 C P C00557124 2018
H2CA24229,2024 H2CA24229 ALLEN, BRAD DR. REP 2022 CA H 24 C P C00820647 2024
H2CA24229,2026 H2CA24229 ALLEN, BRAD DR. REP 2022 CA H 24 C P C00820647 2026
H2CA24229,2022 H2CA24229 ALLEN, BRAD DR. REP 2022 CA H 24 C C C00820647 2022
H0CA09091,2010 H0CA09091 ALLEN, LARRY PAF 2010 CA H 09 C N   2010
H0CA09091,2014 H0CA09091 ALLEN, LARRY PAF 2014 CA H 13 C N   2014
H0CA24116,2010 H0CA24116 ALLISON, TIMOTHY JAMES DEM 2010 CA H 24 C N C00464347 2010
H0CA24116,2012 H0CA24116 ALLISON, TIMOTHY JAMES DEM 2010 CA H 24 C P C00464347 2012
H8CA52136,2018 H8CA52136 ALLMAN, MICHAEL REP 2018 CA H 52 C C C00658005 2018
H6CA52155,2016 H6CA52155 ALLVORD, TERRY REP 2016 CA H 52 C C C00608059 2016
H0CA32176,2010 H0CA32176 ALONSO, FRANCISCO DEM 2009 CA H 32 O P C00460519 2010
H6CA23271,2026 H6CA23271 ALONZO, EDWIN DEM 2026 CA H 23 C N C00903864 2026

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