Baselight

US Campaign Finance 2013-2014 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec

Candidate Committee Linkages
@kaggle.jeegarmaru_us_campaign_finance_20132014_fec.candidate_committee_linkages

  • 120.19 KB
  • 6245 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

H0AK0009720142014C00525261HP195285
H0AL0208720142014C00493783HJ195287
H0AL0208720142014C00462143HP195286
H0AL0504920082014C00239038HP195288
H0AL0516320142014C00464149HP195289
H0AL0518920102014C00477026HP195290
H0AL0608820102014C00464222HP195291
H0AL0708620142014C00501825NJ195293
H0AL0708620142014C00458976HP195292
H0AL0709420102014C00460410HP195294

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.