US Campaign Finance 2015-2016 FEC
Candidate & PAC info, contributions, expenditures, campaigns & committees data
@kaggle.jeegarmaru_us_campaign_finance_20152016_fec
Candidate & PAC info, contributions, expenditures, campaigns & committees data
@kaggle.jeegarmaru_us_campaign_finance_20152016_fec
CREATE TABLE all_candidates (
"cand_id" VARCHAR,
"cand_name" VARCHAR,
"cand_ici" VARCHAR,
"pty_cd" BIGINT,
"cand_pty_affiliation" VARCHAR,
"ttl_receipts" DOUBLE,
"trans_from_auth" DOUBLE,
"ttl_disb" DOUBLE,
"trans_to_auth" DOUBLE,
"coh_bop" DOUBLE,
"coh_cop" DOUBLE,
"cand_contrib" DOUBLE,
"cand_loans" DOUBLE,
"other_loans" DOUBLE,
"cand_loan_repay" DOUBLE,
"other_loan_repay" DOUBLE,
"debts_owed_by" DOUBLE,
"ttl_indiv_contrib" DOUBLE,
"cand_office_st" VARCHAR,
"cand_office_district" DOUBLE,
"spec_election" VARCHAR,
"prim_election" VARCHAR,
"run_election" VARCHAR,
"gen_election" VARCHAR,
"gen_election_precent" VARCHAR,
"other_pol_cmte_contrib" DOUBLE,
"pol_pty_contrib" DOUBLE,
"cvg_end_dt" TIMESTAMP,
"indiv_refunds" DOUBLE,
"cmte_refunds" DOUBLE
);
CREATE TABLE any_transaction_from_one_committee_to_another (
"cmte_id" VARCHAR,
"amndt_ind" VARCHAR,
"rpt_tp" VARCHAR,
"transaction_pgi" VARCHAR,
"image_num" BIGINT,
"transaction_tp" VARCHAR,
"entity_tp" VARCHAR,
"name" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"employer" VARCHAR,
"occupation" VARCHAR,
"transaction_dt" DOUBLE,
"transaction_amt" BIGINT,
"other_id" VARCHAR,
"tran_id" VARCHAR,
"file_num" BIGINT,
"memo_cd" VARCHAR,
"memo_text" VARCHAR,
"sub_id" BIGINT
);
CREATE TABLE candidate_master (
"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
);
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
);
CREATE TABLE committee_master (
"cmte_id" VARCHAR,
"cmte_nm" VARCHAR,
"tres_nm" VARCHAR,
"cmte_st1" VARCHAR,
"cmte_st2" VARCHAR,
"cmte_city" VARCHAR,
"cmte_st" VARCHAR,
"cmte_zip" VARCHAR,
"cmte_dsgn" VARCHAR,
"cmte_tp" VARCHAR,
"cmte_pty_affiliation" VARCHAR,
"cmte_filing_freq" VARCHAR,
"org_tp" VARCHAR,
"connected_org_nm" VARCHAR,
"cand_id" VARCHAR
);
CREATE TABLE contributions_by_individuals (
"cmte_id" VARCHAR,
"amndt_ind" VARCHAR,
"rpt_tp" VARCHAR,
"transaction_pgi" VARCHAR,
"image_num" BIGINT,
"transaction_tp" VARCHAR,
"entity_tp" VARCHAR,
"name" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"employer" VARCHAR,
"occupation" VARCHAR,
"transaction_dt" DOUBLE,
"transaction_amt" BIGINT,
"other_id" VARCHAR,
"tran_id" VARCHAR,
"file_num" BIGINT,
"memo_cd" VARCHAR,
"memo_text" VARCHAR,
"sub_id" BIGINT
);
CREATE TABLE contributions_from_committees_to_candidates_independen_1de6a035 (
"cmte_id" VARCHAR,
"amndt_ind" VARCHAR,
"rpt_tp" VARCHAR,
"transaction_pgi" VARCHAR,
"image_num" BIGINT,
"transaction_tp" VARCHAR,
"entity_tp" VARCHAR,
"name" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"employer" VARCHAR,
"occupation" VARCHAR,
"transaction_dt" DOUBLE,
"transaction_amt" BIGINT,
"other_id" VARCHAR,
"cand_id" VARCHAR,
"tran_id" VARCHAR,
"file_num" BIGINT,
"memo_cd" VARCHAR,
"memo_text" VARCHAR,
"sub_id" BIGINT
);
CREATE TABLE house_senate_current_campaigns (
"cand_id" VARCHAR,
"cand_name" VARCHAR,
"cand_ici" VARCHAR,
"pty_cd" BIGINT,
"cand_pty_affiliation" VARCHAR,
"ttl_receipts" DOUBLE,
"trans_from_auth" DOUBLE,
"ttl_disb" DOUBLE,
"trans_to_auth" DOUBLE,
"coh_bop" DOUBLE,
"coh_cop" DOUBLE,
"cand_contrib" DOUBLE,
"cand_loans" DOUBLE,
"other_loans" DOUBLE,
"cand_loan_repay" DOUBLE,
"other_loan_repay" DOUBLE,
"debts_owed_by" DOUBLE,
"ttl_indiv_contrib" DOUBLE,
"cand_office_st" VARCHAR,
"cand_office_district" DOUBLE,
"spec_election" VARCHAR,
"prim_election" VARCHAR,
"run_election" VARCHAR,
"gen_election" VARCHAR,
"gen_election_precent" VARCHAR,
"other_pol_cmte_contrib" DOUBLE,
"pol_pty_contrib" DOUBLE,
"cvg_end_dt" TIMESTAMP,
"indiv_refunds" DOUBLE,
"cmte_refunds" DOUBLE
);
CREATE TABLE operating_expenditures (
"cmte_id" VARCHAR,
"amndt_ind" VARCHAR,
"rpt_yr" BIGINT,
"rpt_tp" VARCHAR,
"image_num" BIGINT,
"line_num" VARCHAR,
"form_tp_cd" VARCHAR,
"sched_tp_cd" VARCHAR,
"name" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"transaction_dt" VARCHAR,
"transaction_amt" DOUBLE,
"transaction_pgi" VARCHAR,
"purpose" VARCHAR,
"category" VARCHAR,
"category_desc" VARCHAR,
"memo_cd" VARCHAR,
"memo_text" VARCHAR,
"entity_tp" VARCHAR,
"sub_id" BIGINT,
"file_num" BIGINT,
"tran_id" VARCHAR,
"back_ref_tran_id" VARCHAR
);
CREATE TABLE pac_summary (
"cmte_id" VARCHAR,
"cmte_nm" VARCHAR,
"cmte_tp" VARCHAR,
"cmte_dsgn" VARCHAR,
"cmte_filing_freq" VARCHAR,
"ttl_receipts" DOUBLE,
"trans_from_aff" DOUBLE,
"indv_contrib" DOUBLE,
"other_pol_cmte_contrib" DOUBLE,
"cand_contrib" DOUBLE,
"cand_loans" DOUBLE,
"ttl_loans_received" DOUBLE,
"ttl_disb" DOUBLE,
"tranf_to_aff" DOUBLE,
"indv_refunds" DOUBLE,
"other_pol_cmte_refunds" DOUBLE,
"cand_loan_repay" DOUBLE,
"loan_repay" DOUBLE,
"coh_bop" DOUBLE,
"coh_cop" DOUBLE,
"debts_owed_by" DOUBLE,
"nonfed_trans_received" DOUBLE,
"contrib_to_other_cmte" DOUBLE,
"ind_exp" DOUBLE,
"pty_coord_exp" DOUBLE,
"nonfed_share_exp" DOUBLE,
"cvg_end_dt" TIMESTAMP
);
Anyone who has the link will be able to view this.