Name: ar_payer_payee
Creator: Forest Gregg
License: https://creativecommons.org/publicdomain/mark/1.0/

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,359 rows

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Advanced export

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

CREATE TABLE "ar_payer_payee" (
   [payer_payee_id] INTEGER PRIMARY KEY NOT NULL,
   [payer_payee_type] INTEGER NOT NULL REFERENCES [ar_erds_codes]([code]),
   [rcpt_disb_type] INTEGER NOT NULL REFERENCES [ar_erds_codes]([code]),
   [name] TEXT,
   [po_box] TEXT,
   [street] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip] TEXT,
   [type_or_class] TEXT,
   [itemized] INTEGER,
   [non_itemized] INTEGER,
   [total] INTEGER,
   [rpt_id] INTEGER REFERENCES [lm_data]([rpt_id])
);