ar_payer_payee

Master list of payers and payees referenced from itemized receipts and disbursements. Each row is one named counterparty per filing — typically a vendor, contractor, employer (for dues check-off), or recipient organization. Referenced by ar_disbursements_genrl, ar_receipts_other, etc., via payer_payee_id.
city
City.
itemized
Itemized amount (dollars) associated with this counterparty.
name
Counterparty name.
non_itemized
Non-itemized amount (under OLMS reporting threshold).
payer_payee_id
Primary key.
payer_payee_type
Code distinguishing payer from payee. FK to ar_erds_codes (PAYER_PAYEE_CODE).
po_box
P.O. box.
rcpt_disb_type
Code for the kind of receipt or disbursement this counterparty is associated with. FK to ar_erds_codes.
rpt_id
Foreign key to lm_data.rpt_id.
state
State.
street
Street address.
total
Total amount (itemized + non_itemized).
type_or_class
Free-text classification of the counterparty.
zip
ZIP code.

2,282,564 rows

✎ View and edit SQL

Suggested facets: payer_payee_type, rcpt_disb_type

payer_payee_id ▼ payer_payee_type rcpt_disb_type name po_box street city state zip type_or_class itemized non_itemized total rpt_id
19 1001 1201 PIERCE TRANSIT P.O. BOX 99070   LAKEWOOD WA 984990070 EMPLOYER 16005 0 16005 224377
20 1001 1201 VARIOUS VENDORS           RETAIL SALES 0 395 395 224377
21 1001 1201 TACOMA SPORTSMAN     TACOMA WA   ENTERTAINMENT FACILITY 0 300 300 224377
22 1001 1201 AMALGAMATED TRANSIT UNION INTERNATIONAL   5025 WISCONSIN AVENUE NW WASHINGTON, D.C.   200164139 PARENT UNION 0 1886 1886 224377
23 1001 1201 ISAAC TATE   10828 GRAVELLY LAKE DRIVE LAKEWOOD WA 984991334 OFFICER 0 203 203 224377
24 1001 1201 SONJA OGDEN   10828 GRAVELLY LAKE DRIVE LAKEWOOD WA 98499 OFFICER 0 533 533 224377
25 1001 1201 TERRY HEDHURD   10828 GRAVELLY LAKE DRIVE LAKEWOOD WA 98499 MEMBER 0 76 76 224377
26 1001 1201 VARIOUS           MISCELLANEOUS 0 1881 1881 224377
27 1002 501 SCHROETER, GAKHUARL & BENDER 500 CENTRAL BUILDING 810 THIRD AVENUE SEATTLE WA 98104 LEGAL WORK 6632 1600 8232 224377
28 1002 501 FRED ROBERSON   1944 PACIFIC AVENUE, #900 TACOMA WA 98402 LANDLORD 5048 0 5048 224377
29 1002 501 TELEPHONE AND OFFICE EXPENSES UNDER $5,000         OFFICE EXPENSES AND UTILITIES 0 3151 3151 224377
30 1002 503 MUSCULAR DYSTROPHY     TACOMA WA   CHARITY 0 100 100 224377
31 1002 503 UNITED WAY     TACOMA WA   CHARITY 0 100 100 224377
32 1002 503 DON TAYLOR     TACOMA WA   REIMBURSEMENT FOR CHARITY CONTRIBUTION 0 500 500 224377
33 1002 503 TOM TERRIEN AMAL TRAN UN #758, RETIREES 10828 GRAVELLY LAKE DRIVE LAKEWOOD WA 98499 RETIRED MEMBER 0 700 700 224377
34 1002 504 FRED ROBERSON   1944 PACIFIC AVENUE #900 TACOMA WA 98402 LANDLORD 6310 0 6310 224377
35 1002 504 VARIOUS OFFICE EXPENSE AND         LEGAL, DUES REFUND, OFC EXP, UTILITY UNDER $5,000 0 13040 13040 224377
36 1002 504 VARIOUS SPRING FLING, PICNIC,         COMM EXP & SPG FLING, PIC & RAFFLE - UNDER $5,000 0 5064 5064 224377
37 1002 505 BRINK & SADLER, CPAs   5127 112TH ST SW LAKEWOOD WA 98499 CPAs 13300 0 13300 224377
38 1002 505 PIERCE TRANSIT P.O. BOX 99070   LAKEWOOD WA 98499 EMPLOYEE 18231 0 18231 224377
39 1002 505 VARIOUS TELEPHONE & UTILITIES         LEGAL/RENT/OFC EXP/TELE/UTIL & MISC/UNDER $5,000 0 7464 7464 224377
40 1002 504 APPLEWOOD CONST. CO.   13988 122ND ST. SO. HASTINGS MN 55033 GENERAL CONTRACTOR 9295 77926 87221 225864
41 1002 504 BOB KRUSE CONST. CO.   1337 MADISON ST. HASTINGS MN 55033 CARPENTRY CONTRACTOR 7547 0 7547 225864
42 1002 504 FLINT HILLS RESOURCES PO BOX 64596   ST. PAUL MN 551640596 PETROLEUM REFINER 62611 0 62611 225864
43 1002 504 State Fund P. O. Box 7854   San Francisco CA 941207854 Workers Compensation Insurance 0 6586 6586 226358
44 1002 505 D. H. Scott and Company P.O... Box 900 Market Street Redding CA 96001 Audit Fees 0 5000 5000 226358
63 1001 1201 National Postal Mail Handlers Union Suite 500 1101 Connenticut Avenue Washington DC 20036 National Union 20463 0 20463 227102
64 1002 505 Sheriton Boston Hotel   39 Dalton Street Boston MA 02199 Hotel 6489 0 6489 227102
65 1001 1201 Plumbers & Pipefitters Local 430-Organizing Fd   2908 N Harvard Tulsa OK 74115 Organizing Activites for Local 430. 56669 0 56669 227525
66 1001 1201 Pipefitters Local 430 Health & Welfare Fund   2908 N Harvard Tusa OK 74115 Pipefitters Local 430 Health & Welfare Fund 81579 0 81579 227525
67 1002 501 Robein, Urann & Lurye PO Box 6768 2540 Evern Avenue Suite 400 Metaire LA 700096768 Legal advice and consultation. 7556 0 7556 227525
68 1002 502 UA Political Action Committee PO Box 37800   Washington DC 200134307 MONTHLY CONTRIBUTION FOR PAC FOR LOCAL MEMBERS. 25316 0 25316 227525
69 1002 504 Dennis Semlar Tulsa Cty Treasurer   500 S Denver Tulsa OK 740133840 PROPERTY TAXES 8299 0 8299 227525
70 1002 504 Hanover Insurance Co PO Box 4031   Woburn MA 018884031 VARIOUS INSURANCE COVERAGE 19329 0 19329 227525
71 1002 504 US Cellular PO Box 650684   Dallas TX 752650684 CELLULAR VARIOUS EMPLOYEES & OFFICERS 5501 0 5501 227525
72 1002 504 SBC Communications PO Box 650661   Dallas TX 752650661 LOCAL & LONG DISTANCE PHONE SERVICE 6730 0 6730 227525
73 1002 504 American Power Electric PO Box 24421   Canton OH 447014421 ELECTRIC SERVICE 7401 0 7401 227525
74 1002 504 Bryan, Little, Springer & Littleton Inc PO Box 2306 412 E Fifth Street Bartlesville OK 74005 ACCOUNTING SERVICES 7185 0 7185 227525
75 1002 504 Oklahoma State AFL-CIO   501 NE 27th Street Oklahoma City OK 73105 BUILDING FUND ALLOCATION 5000 0 5000 227525
76 1002 505 Palmer Plumbing PO Box 27068   Tulsa OK 741270068 TULSA AREA PROGRAM JOB DISBURSEMENTS. 136781 0 136781 227525
77 1002 505 ADP Mechanical   1217 1/2 Admiral Blvd Tulsa OK 74120 TULSA AREA RECOVERY PROGRAM FOR A JOB ENHANCEMENT. 26272 0 26272 227525
78 1002 505 Pace Mechanical   7122 Charles Page Blvd Tulsa OK 741277300 TULSA AREA RECOVERY PROGRAM FOR JOB ENHANCEMENT 7600 0 7600 227525
79 1002 505 Dual Temp Companies   4301 S Packers Avenue Chicago IL 60609 TULSA AREA RECOVERY PROGRAM FOR JOB ENHANCEMENT. 5896 0 5896 227525
80 1002 505 McIntosh Services Inc   4246 S 74th East Avenue Tulsa OK 74145 TULSA AREA RECOVERY PROGRAM FOR JOB ENHANCEMENT 76544 0 76544 227525
81 1002 505 Forrest Shoemaker A C   202 S Guthrie Avenue Tulsa OK 74103 TULSA AREA RECOVERY PROGRAM FOR JOB ENHANCEMENT 5100 0 5100 227525
82 1002 505 Way Contractors   5401 S 101 Street East Ave Tulsa OK 74146 TULSA AREA RECOVERY PROGRAM FOR JOB ENHANCEMENT 18000 0 18000 227525
83 1002 505 Bells Amusement Park PO Box 4752   Tulsa OK 74159 FACILITIES FOR ANNUAL PICNIC. 10511 0 10511 227525
84 1002 505 Tulsa County Public Facility Authority PO Box 4735   Tulsa OK 741590735 FACILITIES FOR ANNUAL PICNIC 7941 0 7941 227525
85 1002 505 ArVest Bank PO Box 999   Bartlesville OK 74005 REPAYMENT OF LOAN INTEREST. 19083 0 19083 227525
86 1002 505 Plumbers & Pipefitters Local 430   2908 N Harvard Tulsa OK 74115 DEFAULT BENEFITS AND DEPOSIT CORRECTION. 20209 0 20209 227525
87 1002 505 Sheraton Tulsa Hotel   10918 East 41st Street Tulsa OK 74146 FACILITIES & FOOD FOR ANNUAL RETIREMENT/AWARDS 9584 0 9584 227525
111 1001 1201 UNITED TRANSPORTATION UNION   14600 DETROIT AVE CLEVELAND OH 441074250 UNION GENERAL OFFICES 6387 0 6387 227926
112 1002 501 UNITED TRANSPORTATION UNION   14600 DETROIT AVE CLEVELAND OH 441074250 DONATION RECEIVED FROM MEMBERS 6811 0 6811 227926
113 1002 502 INITED TRANSPORTATION UNION LOCAL 1366 9623N. TEMPLE SHADOWS DRIVE CEDAR HILLS UT 84062 UNION 6388 2166 8554 227926
114 1002 503 UTAH FOOD BANK     SALT LAKE CITY UT   CHARITY 3131 0 3131 227926
115 1002 504 UNITED TRANSPORTATION UNION LOCAL 1366 9623 N. TEMPLE SHADOWS DRIV CEDAR HILLS UT 84062 UNION 9190 0 9190 227926
116 1002 505 UNITED TRANSPORTATION UNION LOCAL 1366 9623 N TEMPLE SHADOWS DRIVE CEDAR HILLS UT 84062 UNION 0 0 0 227926
117 1002 504 CPA ASSOCIATES, LC   1301 SIXTH AVE.W., STE. 600 BRADENTON FL 342057440 CPA FIRM 13895 15060 28955 228680
118 1002 504 SUGARMAN & SUSKIND, P.A.   2801 PONCE DE LEON BLVD. CORAL GABLES FL 33134 LAW FIRM 0 5259 5259 228680
119 1002 504 AT&T WIRELESS P.O. BOX 68055   ANAHEIM HILLS CA 928178055 WIRELESS TELEPHONE PROVIDER 0 7146 7146 228680
120 1002 504 JUPITER BY THE SEA REALTY, INC.   2153 S. HIGHWAY 1 JUPITER FL 33477 REALTY COMPANY 0 5800 5800 228680
121 1002 504 FDN COMMUNICATIONS   2301 LUCIEN WAY, STE. 200 MAITLAND FL 32751 TELEPHONE SERVICE PROVIDER 0 5623 5623 228680
122 1002 504 WACHOVIA BANK   1410 COMMONWEALTH DR,ST 140 WILMINGTON NC 28403 BANK/MORTGAGE COMPANY 0 39000 39000 228680
133 1001 1201 VARIOUS VARIOUS VARIOUS VARIOUS IN 46204 MISCELLANEOUS 2001 0 2001 228746
134 1002 504 VARIOUS VARIOUS VARIOUS VARIOUS IN 46204 GENERAL OVERHEAD EXPENDITURES 49892 0 49892 228746
135 1002 505 VARIOUS VARIOUS VARIOUS VARIOUS IN 46204 GENERAL UNION ADMINISTRATION 34131 0 34131 228746
136 1001 1201 LABORERS DISTRICT COUNCIL OF ALABAMA           PREDECESSOR DISTRICT COUNCIL 102245 0 102245 228895
137 1001 1201 LABORERS DISTRICT COUNCIL OF GA & SC           PREDECESSOR DISTRICT COUNCIL 201311 0 201311 228895
138 1001 1201 LBORERS DISTRICT COUNCIL OF TENNESSEE           PREDECESSOR DISTRICT COUNCIL 199888 0 199888 228895
139 1001 1201 LABORERS DISTRICT COUNCIL OF S.. FLORIDA           PREDECESSOR DISTRICT COUNCIL 48811 0 48811 228895
140 1002 501 DISTRICT EIGHT REGIONAL ORGANIZING COMMITTEE   25 CENTURY BLVD. 305 NASHVILLE TN 37214 LABOR ORGANIZATION 35577 0 35577 228895
141 1002 502 K & R INDUSTRIES P.O. BOX 220690   CHANTILLY VA 20153 VENDOR - SUPPLIES , SHIRTS 13516 0 13516 228895
142 1002 504 HARTFORD INSURANCE P.O. BOX 2907   HARTFORD INSURANCE CT 061042907 INSURANCE CARRIER 6797 0 6797 228895
143 1002 505 WYNDAM PALACE RESORT & SPA P.O. BOX 22206 1900 BUENA VISTA LAKE BUENA VISTA FL 328302206 VENDOR - HOTEL MEETINGS 16215 0 16215 228895
144 1001 1201 LABORERS' EDUCATIONAL AND TRAINING FUND   PLATTSBURGH NY 12901 EDUCATIONAL AND TRAINING FUND 24983 0 24983 228896
145 1002 503 DERIDDER MASONRY, INC.   59 BLANCHARD ROAD GANSEVOORT NY 12831 GRANT 16007 0 16007 228896
146 1002 503 J.F.P. ENTERPRISES   7441 ROUTE 9 NORTH PLATTSBURGH NY 12901 GRANT 9700 0 9700 228896
147 1002 503 TRACY TROMBLEY CONSTRUCTION CO.   912 MASON STREET MORRISONVILLE NY 12962 GRANT 5620 0 5620 228896
148 1002 504 ABBOTT FRENYEA RUSSELL & COFFEY, P.C.           ACCOUNTING 0 6625 6625 228896
149 1002 504 THE FRANK DOOLITTLE   1310 MERCER STREET SUI 210 SEATTLE WA 98109 PRINTER 12038 2910 14948 228896
150 1002 504 LABORERS' PENSION FUND           RENT 0 9000 9000 228896
151 1002 504 BANKNORTH WEALTH MGMT GROUP P.O. BOX 477 143 NO. MAIN STREET CONCORD NH 033020477 INVESTMENT FEES 0 5159 5159 228896
152 1002 503 New Jersey State AFL-CIO   106 West State St. Trenton NJ 08608 non profit labor organization 5000 465 5465 229016
153 1002 503 Richard Stockton College of NJ P.O.Box 195   Pomona NJ 08240 college/university 0 16000 16000 229016
154 1002 503 Rutgers, The State University of NJ   620 George St. New Brunswick NJ 08901 college/university 0 16000 16000 229016
155 1002 503 Seton Hall University   457 Centre St. South Orange NJ 07079 college/university 0 7000 7000 229016
156 1002 503 The College of New Jersey P.O. Box 7718   Ewing NJ 08628 college/university 0 6000 6000 229016
157 1002 503 University of Scranton P.O. Box 1404   Scranton PA 18510 college/university 0 6000 6000 229016
158 1002 504 Adams Addressing Associates   39 Farinella Dr. East Hanover NJ 07936 mail services 0 8535 8535 229016
159 1002 504 Concord Promotions   2000 Bloomingdale Rd. Glendale Heights IL 60139 promotional items vendor 7894 3752 11646 229016
160 1002 504 Exxon Mobil P.O. Box 4559   Carol Storm IL 60197 gasoline sales 0 11706 11706 229016
161 1002 504 Graphics Design P.O. Box 83   South Harwich MA 02661 printing service 0 8500 8500 229016
162 1002 504 Pitney Bowes Inc. P.O. Box 856390   Louisville KY 40285 mail service 0 7676 7676 229016
163 1002 504 Public Service Gas & Electric P.O. Box 14105   New Brunswick NJ 08906 gas/electric service 0 8446 8446 229016
164 1002 504 Staples P.O. Box 9020   Des Moines IA 50368 office supplies vendor 0 7503 7503 229016
165 1002 504 Township of West Caldwell   30 Clinton Rd. West Caldwell NJ 07006 municipality 7839 1236 9075 229016
166 1002 504 Tradewind Net Access Inc.   484 Bloomfield Ave Montclair NJ 07042 web designer 5000 4500 9500 229016
167 1002 504 Verizon P.O. Box 4833   Trenton NJ 08650 telephone service 0 13250 13250 229016
168 1002 504 Wasilewski & Keating   117 South Maple Ave. Basking Ridge NJ 07920 accounting 10125 4025 14150 229016
169 1002 504 De Lage Landen P.O. Box 41601   Philadelphia PA 19101 rental of equipment 0 5013 5013 229016

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE ar_payer_payee(payer_payee_id BIGINT, payer_payee_type BIGINT, rcpt_disb_type BIGINT, "name" VARCHAR, po_box VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, type_or_class VARCHAR, itemized BIGINT, non_itemized BIGINT, total BIGINT, rpt_id BIGINT, PRIMARY KEY(payer_payee_id));