Baselight

US Campaign Finance 2017-2018 FEC

Candidate & PAC info, contributions, expenditures, campaigns & committees data

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec

Candidate Committee Linkages
@kaggle.jeegarmaru_us_campaign_finance_20172018_fec.candidate_committee_linkages

  • 145.79 KB
  • 7203 rows
  • 7 columns
cand_id

CAND ID

cand_election_yr

CAND ELECTION YR

fec_election_yr

FEC ELECTION YR

cmte_id

CMTE ID

cmte_tp

CMTE TP

cmte_dsgn

CMTE DSGN

linkage_id

LINKAGE ID

H0AL0208720182018C00493783HJ212430
H0AL0208720182018C00462143HP212429
H0AL0319220202018C00681452HP221575
H0AL0504920082018C00239038HP212431
H0AL0516320182018C00464149HP212432
H0AL0608820102018C00464222HP212433
H0AL0610420202018C00681213HP221576
H0AL0708620182018C00458976HP212434
H0AL0709420102018C00460410HP212435
H0AR0108320182018C00462374HP212436

CREATE TABLE candidate_committee_linkages (
  "cand_id" VARCHAR,
  "cand_election_yr" BIGINT,
  "fec_election_yr" BIGINT,
  "cmte_id" VARCHAR,
  "cmte_tp" VARCHAR,
  "cmte_dsgn" VARCHAR,
  "linkage_id" BIGINT
);

Share link

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