Baselight

OpenFEC Data

All Data From the Federal Election Commission (Except Individual Contributions)

@kaggle.dubradave_openfec_data

Loading...
Loading...

About this Dataset

OpenFEC Data

Source: https://www.fec.gov/data/browse-data/?tab=bulk-data

All data provided from the Federal Election Commission. That is, except individual contributions, which are provided in a separate dataset here: https://www.kaggle.com/datasets/dubradave/openfec-individual-contributions.

Download bulk data
Downloadable bulk data files contain data from statements and reports filed with the Commission in a form that may be useful to users performing in-depth campaign finance research. The files, which were previously located on the Commission's file transfer protocol (FTP) server, can be very large because they contain transaction-level data. The update schedule of these files varies from daily to weekly. Expand each file's accordion to read more about what is contained in the file.

Tables

All Candidates 2010–2024

@kaggle.dubradave_openfec_data.all_candidates_2010_2024
  • 1.49 MB
  • 24350 rows
  • 30 columns
Loading...

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
);

Allcandidates 2010–2024

@kaggle.dubradave_openfec_data.allcandidates_2010_2024
  • 1.49 MB
  • 24350 rows
  • 30 columns
Loading...

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
);

Any Transactions From One Committee To Another 2010–2024

@kaggle.dubradave_openfec_data.any_transactions_from_one_committee_to_another_2010_2024
  • 652.78 MB
  • 18053069 rows
  • 21 columns
Loading...

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
);

Candidate Committe Linkages 2010–2024

@kaggle.dubradave_openfec_data.candidate_committe_linkages_2010_2024
  • 745.63 KB
  • 51756 rows
  • 7 columns
Loading...

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
);

Candidate Master 2010–2024

@kaggle.dubradave_openfec_data.candidate_master_2010_2024
  • 1.76 MB
  • 53649 rows
  • 15 columns
Loading...

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
);

Committee Master 2010–2024

@kaggle.dubradave_openfec_data.committee_master_2010_2024
  • 5.31 MB
  • 130506 rows
  • 15 columns
Loading...

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
);

Contributions From Committees To Candidates 2010–2024

@kaggle.dubradave_openfec_data.contributions_from_committees_to_candidates_2010_2024
  • 118.47 MB
  • 3579910 rows
  • 22 columns
Loading...

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
);

House Senate Current Campaigns 2010–2024

@kaggle.dubradave_openfec_data.house_senate_current_campaigns_2010_2024
  • 1.19 MB
  • 16483 rows
  • 30 columns
Loading...

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
);

Operating Expenditures 2010–2024

@kaggle.dubradave_openfec_data.operating_expenditures_2010_2024
  • 429.13 MB
  • 12196238 rows
  • 26 columns
Loading...

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
);

Pac Summary 2010–2024

@kaggle.dubradave_openfec_data.pac_summary_2010_2024
  • 3.58 MB
  • 83764 rows
  • 27 columns
Loading...

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
);

Share link

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