OpenFEC Data
All Data From the Federal Election Commission (Except Individual Contributions)
@kaggle.dubradave_openfec_data
All Data From the Federal Election Commission (Except Individual Contributions)
@kaggle.dubradave_openfec_data
CREATE TABLE all_candidates_2010_2024 (
"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" DOUBLE,
"other_pol_cmte_contrib" DOUBLE,
"pol_pty_contrib" DOUBLE,
"cvg_end_dt" TIMESTAMP,
"indiv_refunds" DOUBLE,
"cmte_refunds" DOUBLE
);
CREATE TABLE allcandidates_2010_2024 (
"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" DOUBLE,
"other_pol_cmte_contrib" DOUBLE,
"pol_pty_contrib" DOUBLE,
"cvg_end_dt" TIMESTAMP,
"indiv_refunds" DOUBLE,
"cmte_refunds" DOUBLE
);
CREATE TABLE any_transactions_from_one_committee_to_another_2010_2024 (
"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" DOUBLE,
"memo_cd" VARCHAR,
"memo_text" VARCHAR,
"sub_id" BIGINT
);
CREATE TABLE candidate_committe_linkages_2010_2024 (
"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 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
);
CREATE TABLE committee_master_2010_2024 (
"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_from_committees_to_candidates_2010_2024 (
"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" DOUBLE,
"memo_cd" VARCHAR,
"memo_text" VARCHAR,
"sub_id" BIGINT
);
CREATE TABLE house_senate_current_campaigns_2010_2024 (
"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" DOUBLE,
"other_pol_cmte_contrib" DOUBLE,
"pol_pty_contrib" DOUBLE,
"cvg_end_dt" TIMESTAMP,
"indiv_refunds" DOUBLE,
"cmte_refunds" DOUBLE
);
CREATE TABLE operating_expenditures_2010_2024 (
"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,
"n_25" VARCHAR
);
CREATE TABLE pac_summary_2010_2024 (
"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.