Baselight

OpenFEC Data

All Data From the Federal Election Commission (Except Individual Contributions)

@kaggle.dubradave_openfec_data

Candidate Master 2010–2024
@kaggle.dubradave_openfec_data.candidate_master_2010_2024

  • 1.76 MB
  • 53649 rows
  • 15 columns
cand_id

CAND ID

cand_name

CAND NAME

cand_pty_affiliation

CAND PTY AFFILIATION

cand_election_yr

CAND ELECTION YR

cand_office_st

CAND OFFICE ST

cand_office

CAND OFFICE

cand_office_district

CAND OFFICE DISTRICT

cand_ici

CAND ICI

cand_status

CAND STATUS

cand_pcc

CAND PCC

cand_st1

CAND ST1

cand_st2

CAND ST2

cand_city

CAND CITY

cand_st

CAND ST

cand_zip

CAND ZIP

H0AK00089CRAWFORD, HARRY T JRDEM2010AKHCNC004666984350 BUTTE CIRnanANCHORAGEAK99504
H0AK00097COX, JOHN R.REP2010AKHCNnanPO BOX 1092nanANCHOR POINTAK99556
H0AK01038FISHER, SHELDON ALLREDREP2010AKHCCC004747832140 CASTNER LANEnanANCHORAGEAK99517
H0AL00016BOZEMAN, MARTHA RENEEUNK2010ALH7OCC00464040PO BOX 2512 nanBIRMINGHAMAL35201
H0AL01030GOUNARES, PETER HUNTERREP2010ALH1CNC004594954881 CYPRESS VILLAGE BLVD UNIT EnanORANGE BEACHAL36561
H0AL01048WALTER, DAVID MARSHCON2010ALH1CCC004859387208 FAIRMONT DRIVEnanFOLEYAL36535
H0AL02087ROBY, MARTHAREP2010ALH2CCC004621433260 BANKHEAD AVENUEnanMONTGOMERYAL36106
H0AL02095JOHN, ROBERT E JRIND2010ALH2CNnan1465 W OVERBROOK ROADnanMILLBROOKAL36054
H0AL02103BARBER, RICK JOEREP2010ALH2CCC00471938211 ARROWHEAD DRIVEnanMONTGOMERYAL36117
H0AL02111BELL, STEPHANIE WOLFEREP2010ALH2CCC004776383218 LANCASTER LANEnanMONTGOMERYAL36106

CREATE TABLE candidate_master_2010_2024 (
  "cand_id" VARCHAR,
  "cand_name" VARCHAR,
  "cand_pty_affiliation" VARCHAR,
  "cand_election_yr" BIGINT,
  "cand_office_st" VARCHAR,
  "cand_office" VARCHAR,
  "cand_office_district" DOUBLE,
  "cand_ici" VARCHAR,
  "cand_status" VARCHAR,
  "cand_pcc" VARCHAR,
  "cand_st1" VARCHAR,
  "cand_st2" VARCHAR,
  "cand_city" VARCHAR,
  "cand_st" VARCHAR,
  "cand_zip" DOUBLE
);

Share link

Anyone who has the link will be able to view this.