OpenFEC Data
All Data From the Federal Election Commission (Except Individual Contributions)
@kaggle.dubradave_openfec_data
Table List
- 10 tables(1.19 GB)
- All Candidates 2010–2024
- Allcandidates 2010–2024
- Any Transactions From One Committee To Another 2010–2024
- Candidate Committe Linkages 2010–2024
- Candidate Master 2010–2024
- Committee Master 2010–2024
- Contributions From Committees To Candidates 2010–2024
- House Senate Current Campaigns 2010–2024
- Operating Expenditures 2010–2024
- Pac Summary 2010–2024
Pac Summary 2010–2024
@kaggle.dubradave_openfec_data.pac_summary_2010_2024
- 3.58 MB
- 83764 rows
- 27 columns
cmte_idCMTE ID | cmte_nmCMTE NM | cmte_tpCMTE TP | cmte_dsgnCMTE DSGN | cmte_filing_freqCMTE FILING FREQ | ttl_receiptsTTL RECEIPTS | trans_from_affTRANS FROM AFF | indv_contribINDV CONTRIB | other_pol_cmte_contribOTHER POL CMTE CONTRIB | cand_contribCAND CONTRIB | cand_loansCAND LOANS | ttl_loans_receivedTTL LOANS RECEIVED | ttl_disbTTL DISB | tranf_to_affTRANF TO AFF | indv_refundsINDV REFUNDS | other_pol_cmte_refundsOTHER POL CMTE REFUNDS | cand_loan_repayCAND LOAN REPAY | loan_repayLOAN REPAY | coh_bopCOH BOP | coh_copCOH COP | debts_owed_byDEBTS OWED BY | nonfed_trans_receivedNONFED TRANS RECEIVED | contrib_to_other_cmteCONTRIB TO OTHER CMTE | ind_expIND EXP | pty_coord_expPTY COORD EXP | nonfed_share_expNONFED SHARE EXP | cvg_end_dtCVG END DT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C00000042 | ILLINOIS TOOL WORKS FOR BETTER GOVERNMENT COMMITTEE | Q | B | Q | 195371.22 | 195371.22 | 201339.95 | 30572.87 | 24604.14 | 187000 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||||||||||||
| C00000059 | HALLMARK CARDS PAC | Q | U | M | 110431.5 | 110286.09 | 96544 | 13477.34 | 27364.84 | 96500 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||||||||||||
| C00000422 | AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE | Q | B | M | 2345491.09 | 2000 | 2311012.23 | 1428163.12 | 6350 | 9178.48 | 545620.98 | 1463048.95 | 1366400 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||||||||
| C00000489 | D R I V E POLITICAL FUND, TEAMSTERS LOCAL UNION CHAPTER 886 | Q | U | Q | 23333.75 | 23183 | 31216 | 11052 | 3171 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||||||||||||
| C00000547 | KANSAS MEDICAL SOCIETY POLITICAL ACTION COMMITTEE | Q | U | Q | 29834 | 29834 | 30550 | 12255.67 | 11539.67 | 28500 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||||||||||||
| C00000638 | INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE | Q | U | Q | 331236.01 | 800 | 319685 | 322299.08 | 96315 | 106283.79 | 115220.72 | 22000 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||||||||||
| C00000729 | AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE | Q | B | M | 2418953.13 | 147223.68 | 2227092.63 | 2430850.18 | 1200 | 276141.44 | 264244.39 | 2279731.13 | 125358.51 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||||||||
| C00000885 | INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMM | Q | B | M | 5232963.54 | 5188141.98 | 4971673.3 | 2714.86 | 2270848.99 | 2532139.23 | 1360900 | 4016.16 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||||||||||
| C00000901 | BUILD POLITICAL ACTION COMMITTEE OF THE NATIONAL ASSOCIATION OF HOME BUILDERS (BUILDPAC) | Q | B | M | 2392832.77 | 2320829.29 | 6000 | 3218569.26 | 51633.34 | 1271578.45 | 445841.96 | 2838500 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||||||||||
| C00000935 | DEMOCRATIC CONGRESSIONAL CAMPAIGN COMMITTEE | Y | U | M | 163896052.62 | 9336436.34 | 89228834.5 | 9666453.41 | 163582280.47 | 17646881.54 | 249604.25 | 4000 | 13500000 | 491852.26 | 805624.41 | 19012191.14 | 566134.51 | 65683837.11 | 3720291.99 | Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) |
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
);