US Campaign Finance 2013-2014 FEC
Candidate & PAC info, contributions, expenditures, campaigns & committees data
@kaggle.jeegarmaru_us_campaign_finance_20132014_fec
Table List
- 10 tables(191.52 MB)
Committee Master
@kaggle.jeegarmaru_us_campaign_finance_20132014_fec.committee_master
- 1.02 MB
- 14905 rows
- 15 columns
cmte_idCMTE ID | cmte_nmCMTE NM | tres_nmTRES NM | cmte_st1CMTE ST1 | cmte_st2CMTE ST2 | cmte_cityCMTE CITY | cmte_stCMTE ST | cmte_zipCMTE ZIP | cmte_dsgnCMTE DSGN | cmte_tpCMTE TP | cmte_pty_affiliationCMTE PTY AFFILIATION | cmte_filing_freqCMTE FILING FREQ | org_tpORG TP | connected_org_nmCONNECTED ORG NM | cand_idCAND ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C00000042 | ILLINOIS TOOL WORKS INC. FOR BETTER GOVERNMENT COMMITTEE | LYNCH, MICHAEL J. MR. | 3600 WEST LAKE AVENUE | nan | GLENVIEW | IL | 60026 | B | Q | nan | T | C | nan | nan |
| C00000059 | HALLMARK CARDS PAC | GREG SWARENS | 2501 MCGEE | MD#288 | KANSAS CITY | MO | 64108 | U | Q | UNK | M | C | nan | nan |
| C00000422 | AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE | WALKER, KEVIN | 25 MASSACHUSETTS AVE, NW | SUITE 600 | WASHINGTON | DC | 20001 | B | Q | nan | M | M | AMERICAN MEDICAL ASSOCIATION | nan |
| C00000489 | D R I V E POLITICAL FUND CHAPTER 886 | TOM RITTER | 3528 W RENO | nan | OKLAHOMA CITY | OK | 73107 | U | N | nan | Q | L | TEAMSTERS LOCAL UNION 886 | nan |
| C00000547 | KANSAS MEDICAL SOCIETY POLITICAL ACTION COMMITTEE | C. RICHARD BONEBRAKE, M.D. | 623 SW 10TH AVE | nan | TOPEKA | KS | 66612 | U | Q | UNK | Q | T | nan | nan |
| C00000638 | INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE | VIDYA KORA, M.D. | 322 CANAL WALK, CANAL LEVEL | nan | INDIANAPOLIS | IN | 46202 | U | Q | nan | Q | M | nan | nan |
| C00000729 | AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE | HARRISON, THOMAS C. DR | 1111 14TH STREET, NW | SUITE 1100 | WASHINGTON | DC | 20005 | B | Q | UNK | M | M | AMERICAN DENTAL ASSOCIATION | nan |
| C00000885 | INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMM | GALIS, GEORGE | 7234 PARKWAY DRIVE | nan | HANOVER | MD | 21076 | B | Q | UNK | M | L | INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES | nan |
| C00000901 | BUILD POLITICAL ACTION COMMITTEE OF THE NATIONAL ASSOCIATION OF HOME BUILDERS (BUILDPAC) | RAMAGE, EILEEN | 1201 15TH STREET, NW | nan | WASHINGTON | DC | 20005 | B | Q | UNK | M | T | NATIONAL ASSOCIATION OF HOME BUILDERS | nan |
| C00000935 | DEMOCRATIC CONGRESSIONAL CAMPAIGN COMMITTEE | WARD, KELLY C. | 430 SOUTH CAPITOL STREET, SE | 2ND FLOOR | WASHINGTON | DC | 20003 | U | Y | DEM | M | nan | NANCY PELOSI VICTORY FUND | nan |
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
);