ar_disbursements_emp_off

Officer and employee compensation detail — Schedule 11 (officers) and Schedule 12 (employees) on the LM-2 form. The largest table in the database. One row per officer or employee per filing, with salary, allowances, official-business expenses, "other" disbursements, and a percentage breakdown of how their time was allocated across representational/political/contribution/general-overhead/administration activities.
admin_pct
Percentage allocated to union administration.
allowances
Allowances paid (dollars).
cont_pct
Percentage allocated to contributions, gifts, and grants.
emp_off_type
Type of person (officer vs employee, etc.). FK to ar_erds_codes (EMP_OFF_CODE).
first_name
First name.
gen_ovrhd_pct
Percentage allocated to general overhead.
gross_salary
Gross salary (dollars).
item_num
Sequence number of the person within the filing.
last_name
Last name.
middle_name
Middle name.
official_business
Official-business expenses paid (dollars).
oid
Primary key.
other_not_rptd
Other disbursements not reported elsewhere.
pol_pct
Percentage allocated to political activities.
rep_pct
Percentage of time allocated to representational activities.
rpt_id
Foreign key to lm_data.rpt_id.
status_other_payer
Status of any other-payer (if the person was also paid by another employer during the period).
title
Job title.
total
Total disbursements to this person.

5,014,890 rows

✎ View and edit SQL

This data as json, CSV (advanced)

oid ▼ emp_off_type first_name middle_name last_name title status_other_payer gross_salary allowances official_business other_not_rptd total rep_pct pol_pct cont_pct gen_ovrhd_pct admin_pct rpt_id item_num
1 OFF 601 JOHN   FITZGERALD GEN CHAIRMAN C 86039 0 27248 0 113287           86369 86369 1
2 OFF 601 GENE   HARTSOCK VICE CHAIRMAN C 10512 0 16130 0 26642           86369 86369 2
3 OFF 601 DARRELL   HOWARD VICE CHAIRMAN C 2364 0 2829 0 5193           86369 86369 3
4 OFF 601 JAY   SCHOLLMEYER VICE CHAIRMAN C 3463 0 1832 0 5295           86369 86369 4
5 OFF 601 ROBERT   ANDERSON GCA SEC C 548 0 339   887           86369 86369 5
6 OFF 601 MARK   NORDGREN GCA SEC C 913 0 656 0 1569           86369 86369 6
7 OFF 601 PAUL   USSELMAN GCA SEC C 913 0 339   1252           86369 86369 7
8 OFF 601 JERRY   BATTON CHAIRMEN C 1736 0 5117 0 6853           86488 86488 1
9 OFF 601 KEVIN   TRAINOR BUS MGR/TREAS C 69420 0 893 1120 71433           86366 86366 1
10 OFF 601 PHILIP   WALSH PRESIDENT C 3994 0 880 0 4874           86366 86366 2
11 OFF 601 EDWARD   KEANEY VICE PRESIDENT C 626 0 240 0 866           86366 86366 3
12 OFF 601 STEVE   AGOSTINO RECORDING SEC C 0 0 260 0 260           86366 86366 4
13 OFF 601 ALEX   WHITE AUDITOR C 0 0 200 0 200           86366 86366 5
14 OFF 601 THOMAS   BRESNAHAN AUDITOR C 0 0 200 0 200           86366 86366 6
15 OFF 601 ROCCO   BENEDETTO SARGEANT AT ARM C 0 0 140 0 140           86366 86366 7
16 OFF 601 DOUGLAS   GALLANT EXEC BOARD C 0 0 140 0 140           86366 86366 8
17 OFF 601 JOHN   HENNESSY EXEC BOARD C 0 0 160 0 160           86366 86366 9
18 OFF 601 BRUCE   BERTWELL EXEC BOARD C 0 0 40 0 40           86366 86366 10
19 OFF 601 RICK   LAREAUX AUDITOR N 0 0 60 0 60           86366 86366 11
20 OFF 601 BRIAN   RING EXEC BOARD P 0 0 0 0 0           86366 86366 12
21 OFF 601 VIRGIL   BELFI BUS MGR C 65754 12000 3255 500 81509           86485 86485 1
22 OFF 601 STEVE   GREGALI FIN SEC C 46064 9600 1325 500 57489           86485 86485 2
23 OFF 601 LOV   LEOPKER BUS REP C 41861   4232 650 46743           86485 86485 3
24 OFF 601 KEN   POWDERS BUS AGENT C 61306 9600 1262 650 72818           86485 86485 4
25 OFF 601 RUSSEL   WALTER BUS AGENT C 58317 9600 605   68522           86485 86485 5
26 OFF 601 FRED   SIMSHAUSER PRESIDENT C 7800     650 8450           86485 86485 6
27 OFF 601 ROBERT   SWEENEY BUS AGENT C 38760 4000 3866   46626           86485 86485 7
28 OFF 601 ROBERT   JOHNSTON BOARD C 2538       2538           86485 86485 8
29 OFF 601 ROY   BEASLEY JR ORGANIZER N 19039       19039           86485 86485 9
30 OFF 601 HARRY   CHOMIN TREASURER C       650 650           86485 86485 10
31 OFF 601 JOE   CORTAPASSI VICE PRES C       650 650           86485 86485 11
32 OFF 601 JIM   GADEL BOARD C       650 650           86485 86485 12
33 OFF 601 PET   LYNCH BOARD C       650 650           86485 86485 13
34 OFF 601 JOHN   TRISKA GUARD C       350 350           86485 86485 14
35 OFF 601 HARRY   TUTT BOARD C       150 150           86485 86485 15
36 OFF 601 GARY   WILSON   C 38760   3202   41962           86485 86485 16
37 OFF 601 ANTHONY   MARRAPODE PRESIDENT C 1540   400   1940           86351 86351 1
38 OFF 601 MARK   TOY VICE PRESIDENT C 480       480           86351 86351 2
39 OFF 601 RONALD   BARRETT BUS MGR SEC TRE C 42037   4073   46110           86351 86351 3
40 OFF 601 RICKY   OLINGER REC SECRETARY C 600       600           86351 86351 4
41 OFF 601 LEWIS   FERRI EXEC BOARD C 420       420           86351 86351 5
42 OFF 601 CLARENC   SCHMADER EXEC BOARD C 420       420           86351 86351 6
43 OFF 601 JEFFREY   DAVIS EXEC BOARD C 420       420           86351 86351 7
44 OFF 601 EDWARD   CRAWFORD SGT AT ARMS C 360       360           86351 86351 8
45 OFF 601 ALAN   REARICK AUDITOR C 360       360           86351 86351 9
46 OFF 601 LYNFORD   MANGUS AUDITOR C 360       360           86351 86351 10
47 OFF 601 DONALD   BLOSE AUDITOR C 360       360           86351 86351 11
48 OFF 601 JOSEPH   SALIMBENE BUSINESS MGR P 113275 0 9892 0 123167           86367 86367 1
49 OFF 601 FRANK   OMBRES SECY/TREASURER C 121247 0 13672 0 134919           86367 86367 2
50 OFF 601 VICTOR   PANICA PRES/FIELD REP C 121247 0 9549 0 130796           86367 86367 3
51 OFF 601 GUISEPP   D'AMATO BUSINESS MGR/RE C 126998 0 14937 0 141935           86367 86367 4
52 OFF 601 THEOD   GERTISSER SGT AT ARMS C 1918 0   0 1918           86367 86367 5
53 OFF 601 ANTONIO   NATALE AUDITOR C 1016 0   0 1016           86367 86367 6
54 OFF 601 GASPARE   GIARRAPUTO VICE PRESIDENT C 2995 0   0 2995           86367 86367 7
55 OFF 601 DAVID   LUGO AUDITOR C 981 0 0 0 981           86367 86367 8
56 OFF 601 RAYMOND   ROLDAN EXEC BD C 3030 0 0 0 3030           86367 86367 9
57 OFF 601 ARMADEO   FASANO EXEC BD C 3215 0 0 0 3215           86367 86367 10
58 OFF 601 JAMES   NETHAWAY EXEC BD C 2455 0 0 0 2455           86367 86367 11
59 OFF 601 HERBERT   JOHNSON EXEC BD N 1964 0 0 0 1964           86367 86367 12
60 OFF 601 SEAN   MCCARTHY AUDITOR N 1020 0 0 0 1020           86367 86367 13
61 OFF 601 T   BOUDREAUX DIR C 31092 0 17727 0 48819           86444 86444 1
62 OFF 601 J   GOLLIHER ASS'T DIR N 724 0 490 0 1214           86444 86444 2
63 OFF 601 G   DEVALL ASS'T DIR C 1630 0 789 0 2419           86444 86444 3
64 OFF 601 ALEX   ADAMS PRESIDENT N 68381 9600 778 0 78759           86484 86484 1
65 OFF 601 TIMOTHY   ROBERTSON SECRETARY-TREAS N 70158 9645 633 0 80436           86484 86484 2
66 OFF 601 BEN   VANCE VICE PRESIDENT N 71477 9675 873 0 82025           86484 86484 3
67 OFF 601 LILLIAN   MORISKY RECORDING SEC C 25247 0 814 0 26061           86484 86484 4
68 OFF 601 DENNIS   ROBERTS TRUSTEE N 24017 0 184 0 24201           86484 86484 5
69 OFF 601 JK   TANSKI TRUSTEE C 24787 0 249 0 25036           86484 86484 6
70 OFF 601 PAUL   WOJNAR TRUSTEE N 24080 0 384 0 24464           86484 86484 7
71 OFF 601 JOSEPH   PIERANI PRESIDENT P     204   204           86484 86484 8
72 OFF 601 CRAIG   FRY VICE PRESIDENT P 311 100 0 0 411           86423 86423 1
73 OFF 601 BRAD   MURPHY VICE PRESIDENT N 1348 0 0 0 1348           86423 86423 9
74 OFF 601 DAVID   CONLEY PRESIDENT C 2916 100 0 0 3016           86423 86423 3
75 OFF 601 DARRELL   BAER FINANCIAL SECTY C 2080 100 0 0 2180           86423 86423 4
76 OFF 601 BRIAN   BOGAERT TREASURER C 2637 100 0 0 2737           86423 86423 5
77 OFF 601 TONY   MROCZKIEWICZ RECORDING SECTY C 2377 827 0 0 3204           86423 86423 6
78 OFF 601 GREGORY   JONES WARDEN C 809 100 0 0 909           86423 86423 7
79 OFF 601 MIKE   KRUK CONDUCTOR C 252 100 0 0 352           86423 86423 8
80 OFF 601 BRAD   MURPHY TRUSTEE P 0 100 0 0 100           86423 86423 9
81 OFF 601 ALAN   LIMERICK TRUSTEE N 126 0 0 0 126           86423 86423 10
82 OFF 601 ANTHONY   LANE JR TRUSTEE C 1348 100 0 0 1448           86423 86423 11
83 OFF 601 V DOUG   REINHOLD TRUSTEE C 2247 600 0 0 2847           86423 86423 12
84 OFF 601 CHARLES   RIGHTNOWAR GENERAL CHAIRMN C 79329 2100 5179   86608           86359 86359 1
85 OFF 601 RONNIE   RHODES 1ST VICE CHRMN N 15914   141   16055           86359 86359 2
86 OFF 601 TIM   WELLS 2ND VICE CHRMN N 38260   786   39046           86359 86359 3
87 OFF 601 CHARLES   BRAND SECY TREAS C 33951   3340   37291           86359 86359 4
88 OFF 601 NATE   KRIG EXEC COMMITTEE C 2985   22   3007           86359 86359 5
89 OFF 601 RUSS   GIFFORD EXEC COMMITTEE N 0       0           86359 86359 6
90 OFF 601 DAN   THURSTON 1ST VICE CHRMN P 0       0           86359 86359 7
91 OFF 601 JOHN   WATSON EXEC COMMITTEE P 1793       1793           86359 86359 8
92 OFF 601 JOHN   CASTEEL EXEC COMMITTEE P 534       534           86359 86359 9
93 OFF 601 RANDY   SCHNEIDER EXEC COMMITTEE N 1595       1595           86359 86359 10
94 OFF 601 FRED   GEGARE PRESIDENT C 3600   1744   5344           86429 86429 1
95 OFF 601 MICHAEL   SPENCER VICE PRESIDENT C     1670   1670           86429 86429 2
96 OFF 601 PAUL   LOVINUS SECRETARY TREAS C 2400   93   2493           86429 86429 3
97 OFF 601 DARRELL   SHELBY RECORDING SECR N         0           86429 86429 4
98 OFF 601 FRANK   BUSALACCHI TRUSTEE C 3600   292   3892           86429 86429 5
99 OFF 601 JAMES   NEWELL TRUSTEE C     62   62           86429 86429 6
100 OFF 601 TONY   CORNELIUS TRUSTEE C     109   109           86429 86429 7

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "ar_disbursements_emp_off" (
   [oid] INTEGER PRIMARY KEY NOT NULL,
   [emp_off_type] INTEGER NOT NULL REFERENCES [ar_erds_codes]([code]),
   [first_name] TEXT,
   [middle_name] TEXT,
   [last_name] TEXT,
   [title] TEXT,
   [status_other_payer] TEXT,
   [gross_salary] INTEGER,
   [allowances] INTEGER,
   [official_business] INTEGER,
   [other_not_rptd] INTEGER,
   [total] INTEGER,
   [rep_pct] INTEGER,
   [pol_pct] INTEGER,
   [cont_pct] INTEGER,
   [gen_ovrhd_pct] INTEGER,
   [admin_pct] INTEGER,
   [rpt_id] INTEGER REFERENCES [lm_data]([rpt_id]),
   [item_num] INTEGER
);