counterparty_contact

Contact person at the counterparty organization for each activity.
activity_id
Foreign key to activity.id.
city
City.
name
Contact person's name.
po_box,_bldg,_room_no,_if_any
P.O. box, building, or room number.
state
State.
street
Street address.
zip_code_+_4
ZIP+4 code.

7,537 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ city name po_box,_bldg,_room_no,_if_any state street zip_code_+_4 activity_id
1 1 Washington Johnny Taylor 303 DC 1600 Wisconsin Ave 20018 1 1
2 2 DUBLIN Bill Wheeler P. O. Box 398 OH   43017 - 0398 2 2
3 3 HARTFORD JOSEPH TONER IRONWORKERS LOCAL UNION 15 CT 49 LOCUST STREET 06114 5 5
4 4 HAMDEN MICHELLE YOUNG IUOE LOCAL 479 CT 1965 DIXWELL AVENUE 06514 7 7
5 5 HAMDEN MICHELLE YOUNG IUOE LOCAL 478 CT 1965 DIXWELL AVENUE 06514 8 8
6 6 Colleyville Ken Cannon   TX 2207 Ballantrae Dr 76034 9 9
7 7 Colleyville Ken Cannon   TX 2207 Ballantrae Dr 76034 10 10
8 8 PAWLEYS ISLAND PETER A LIST P.O. BOX 2877 SC   29585 12 12
9 9 Parsippany MICHAEL STILES   NJ 205 JEFFERSON ROAD 07054 13 13
10 10 West Caldwell James McManus, Jr.   NJ 20 Fairfield Place 07006 14 14
11 11 Englishtown Michael Maloney   NJ 2 Iron Ore Road at Route 33 07726 15 15
12 12 Warren Shaun Sullivan P.O. Box 4187 NJ 136 Mt Bethel Road 07059 16 16
13 13 PARSIPPANY DAVID M FIORE   NJ 50 Parsippany Road 07054 17 17
14 14 North Brunswick Michael G. McLaughlin   NJ 1295 Livingston Ave. 08902 18 18
15 15 Englishtown Michael Maloney   NJ 2 Iron Ore Road at Route 33 07726 19 19
16 16 ROCHESTER GARY BONADONNA   NY 750 EAST AVENUE 14607 20 20
17 17 PHILADELPHIA LYNNE FOX   PA 225 22ND STREET 19103 21 21
18 18 CHICAGO NAOMI K. HANSHEW   IL 333 S. ASHLAND AVE. , SUITE 206 60607 22 22
19 19 DALLAS JEAN HERVEY   TX 2639 WALNUT HILL LANE, SUITE 203 75229 23 23
20 20 NEW YORK JULIE KELLY   NY 305 SEVENTH AVE., 7TH FLOOR 10001 24 24
21 21 FREDERICK PATRICK JONES, Sr.   MD 5735 INDUSTRY LANE, BLDG. C, STE101 21704 25 25
22 22 ALLENTOWN DAVID MELMAN   PA 1017 HAMILTON STREET 18101 26 26
23 23 BOSTON WARREN PEPICELLI   MA 333 HARRISON AVENUE 02111 27 27
24 24 UNION CITY HARRIS RAYNOR   GA 4405 MALL BOULEVARD, SUITE 600 30291 28 28
25 25 NEW YORK EDGAR ROMNEY   NY 275 SEVENTH AVE., 6TH FLOOR 10001 29 29
26 26 LOS ANGELES CRISTINA VAZQUEZ   CA 920 S. ALVARADO STREET 90006 30 30
27 27 Kissimmee Greg Peraino 422812 FL   34742 38 38
28 28 Los Angeles Building Trades Council   CA 1626 Beverly Blvd. 90026 39 39
29 29 Broken Arrow Phillip B Wilson   OK 7859 South Elm Place Suite E 74011 41 41
30 30 Broken Arrow Phillip B Wilson   OK 7850 South Elm Place 74011 42 42
31 31 Morris Chapel Andy Weeks   TN 620 C W White Dr. 38361 43 43
32 32 DeRidder Trollis Hickman   LA 1235 Allison Dr. 70634 44 44
33 33 Baudette Tim Anderson   MN 12373 Hwy 11 SE 56303 45 45
34 34 International Falls Margaret Holmstad   MN 2130 County Rd. 123 56649 46 46
35 35 International Falls Leonard Morrison   MN 5055 Hwy 11 56649 47 47
36 36 International Falls Terry Jerdee   MN 2731 County Rd. 94 56649 48 48
37 37 International Falls Tim Wegner   MN 2102 Forth Ave. W. 56649 49 49
38 38 Pasco Todd Schadler   WA 7821 Pelican Ln 99301 50 50
39 39 Broken Arrow Phillip B. Wilson Suite E OK 7850 South Elm Place 74011 51 51
40 40 Pawleys Island Peter List P.O Box 2877 SC   29585 52 52
41 41 St. Paul Matt Fairbanks   MN 1681 Cope Avenue 55109 53 53
42 42 Minneapolis Jason George   MN 2829 Anthony Lane South 55418 54 54
43 43 Minneapolis Trevor M Lawrence # 402 MN 3001 University Avenue SE 55414 55 55
44 44 Little Canada Terry L Nelson   MN 3205 Country Drive 55117 56 56
45 45 St. Paul David Ybarra II Suite 309 MN 411 Main Street 55102 57 57
46 46 Minneapolis Russ Scherber Suite 408 MN 312 Central Avenue SE 55414 58 58
47 47 Encino Screen Actors Guild Award Attn: Sarah Barry Ste. 110 CA 15821 Ventura Blvd. 91436 59 59
48 48 Hibbing Heather Hill 2131 Highway 5 MN   55746 60 60
49 49 Pittsburgh Stan Johnson USW PA 60 Blvd of the Allies 15222 61 61
50 50 Cleveland Mark Granakis   OH 3421 Independence RD 44105 62 62
51 51 Wellington Jarin McGovern   KS 1321 Edgewood 67152 63 63
52 52 Burleson David Vilandre Suite 107-227 TX 1169 Burleson Boulevard 76028 64 64
53 53 Burleson Robert Cheek Suite 107-227 TX 1169 Burleson Boulevard 76028 65 65
54 54 East Moline Gary Miller   IL 821 Oaklawn Avenue 61244 66 66
55 55 McLean Jack Roback Suite 400 VA 7950 Jones Branch Drive 22101 67 67
56 56 McLean Tyler Kirks Suite 400 VA 7950 Jones Branch Drive 22101 68 68
57 57 COLLEYVILLE KENNETH E CANNON   TX 2207 BALLANTRAE DR 76034 69 69
58 58 Ontario Jacquelin Allen   CA 4100 E Jurupa Street, Suite 108 91764 - 1420 70 70
59 59 Glendora Milton Davis   CA 1155 Amelia Ave. 91740 - 6719 71 71
60 60 Glendora Eric Hofmann   CA 1155 Amelia Ave. 91740 - 6719 72 72
61 61 Glendora Sean Mitchell   CA 1155 Amelia Ave. 91740 - 6719 73 73
62 62 Glendora Joe Moreno   CA 1155 Amelia Ave. 91740 - 6719 74 74
63 63 Ontario La Dasha Morris   CA 4100 E Jurupa Street, Suite 108 91764 - 1420 75 75
64 64 Kennewick Travis E. Swayze   WA 2637 W. Albany Street 99336 - 3136 112 112
65 65 Houston No Individual Recipient No Individual Recipient Suite 400 TX 9555 W. Sam Houston Parkway 77099 178 178
66 66 Washington DC No Individual Recipient No Individual Recipient Suite 600 DC 815 16th St. NW 20006 179 179
67 67 New York No Individual Recipient No Individual Recipient 1st Floor NV 451 Park Ave. South 10016 180 180
68 68 Lanham No Individual Recipient No Individual Recipient   MD 4731 Parliament Place 20706 181 181
69 69 Bordentown No Individual Recipient No Individual Recipient   NJ 3281 Route 206 08505 182 182
70 70 Philadelphia No Individual Recipient No Individual Recipient   PA 4170 Woodhaven Rd. 19154 183 183
71 71 Hammonton No Individual Recipient No Individual Recipient P.O. Box 637 NJ One White Horse Pike 08037 - 0637 184 184
72 72 Warrenville No Individual Recipient No Individual Recipient Suite 1000 IL 28600 Bella Vista Parkway 60555 185 185
73 73 Philadelphia No Individual Recipient No Individual Recipient   PA 1719 Spring Garden St. 19130 - 3915 186 186
74 74 Savannah No Individual Recipient No Individual Recipient   GA 2337 East Victory Lane 31404 187 187
75 75 Baltimore No Individual Recipient No Individual Recipient   MD 3615 North Point 21222 188 188
76 76 San Leandro Sullivan Kraw Crab Feed   CA 10806 Bigge Street 94577 190 190
77 77 Glendora SMART Local 105   CA 2120 Auto Centre Drive 91740 191 191
78 78 Oakland Alameda Labor Council Suite 110 CA 7750 Pardee Lane 94621 192 192
79 79 Oakland Contra Costa Bldg & Contruction c/o Earp Events & Fundraising CA 4200 Park Blvd 94602 193 193
80 80 La Verne Western States Apprenticeship Contest Suite A CA 2679 Sierra Way 91750 194 194
81 81 Livermore District Council 16   CA 2705 Constitution Drive 94551 195 195
82 82 San Francisco IATSE LOCAL 16   CA 240 Second Street 94105 196 196
83 83 San Francisco UA Local 38 Charity Golf   CA 1621 Market Street 94103 197 197
84 84 Tacoma IUOE Local 612 Charity Golf PO Box 1735 WA   98401 198 198
85 85 Everett Local 191 WA Brotherhood   WA 2701 Hoyt Avenue 98201 199 199
86 86 Everett Council 2 WSCCCE Golf PO Box 750 WA   98206 200 200
87 87 Oakland Contra Costa Labor Council c/o Earp Events & Fundraising CA 4200 Park Blvd 94602 201 201
88 88 Sacramento WSC HVAC Industry Golf #101-207 CA 1809 S Street 95811 202 202
89 89 Tacoma South Sound IBEW Golf Tournament Suite 101 WA 3049 S 36th Street 98409 203 203
90 90 Tacoma Teamsters Local 313   WA 220 So. 27th Street 98402 204 204
91 91 Seattle IBEW 46 Retirees' Golf Suite 105 WA 19802 62nd Ave S 98032 205 205
92 92 Stockton Teamsters California State Cannery Council   CA 745 E. Miner Ave 95202 206 206
93 93 Las Vegas Carpenters Helping Hands Golf   NV 212 Carpenters Union Way 89119 207 207
94 94 Vacaville Plumbers 343 Entertain Acct   CA 220 Peabody Road 95687 208 208
95 95 Oakland NCC Regional Council Suite 200 CA 265 Hegenberger Road 94621 - 1480 209 209
96 96 San Diego SEIU Local 221   CA 4004 Kearny Mesa Road 92111 210 210
97 97 Pleasant Hill Steve Grannis   CA 20 Carte Place 94523 211 211
98 98 Salt Lake City Thomas Vitti   UT 3821 West 2700 South 41206 212 212
99 99 Washington John Abraham   DC 555 New Jersey Ave, NW 20001 213 213
100 100 COLUMBUS Pedro Leroux SUITE 330 OH 2740 AIRPORT DRIVE 43219 220 220

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "counterparty_contact" (
   [city] TEXT,
   [name] TEXT,
   [po_box,_bldg,_room_no,_if_any] TEXT,
   [state] TEXT,
   [street] TEXT,
   [zip_code_+_4] TEXT,
   [activity_id] INTEGER REFERENCES [activity]([id])
);