Baselight

US Campaign Finance 2015-2016 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec

Candidate Committee Linkages
@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.candidate_committee_linkages

  • 129.14 KB
  • 6412 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

H0AK0009720142016C00525261HP201860
H0AL0208720162016C00462143HP201861
H0AL0208720162016C00493783HJ201862
H0AL0504920082016C00239038HP201863
H0AL0516320162016C00464149HP201864
H0AL0608820102016C00464222HP201865
H0AL0708620162016C00458976HP201866
H0AL0709420102016C00460410HP201867
H0AL0717720122016C00482059HP201868
H0AR0108320162016C00462374HP201869

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.