FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

44 rows where Country/Location_Represented = "SCOTLAND"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 3

City 3

Country/Location_Represented 1

  • SCOTLAND · 44 ✖
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
628 628   Scottish Enterprise (formerly: Scottish Development Agency) 1979-04-17 SCOTLAND Scottish Enterprise 3013 1979-04-17 Scottish Enterprise          
752 752   Visit Scotland 2021-10-29 SCOTLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Ocean Point, 94 Ocean drive   Edinburgh    
1706 1706 1982-01-31 Scottish Development Agency, Glasgow, Scotland 1979-07-23 SCOTLAND Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 3043 1979-07-23 Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. Glasgow        
1748 1748 1990-01-31 Scottish Equitable Life Assurance Society 1989-05-31 SCOTLAND Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Edinburgh        
2288 2288 1983-02-08 UNILINK Research Park 1980-05-08 SCOTLAND Roland Olander & Company 3035 1979-07-05 Roland Olander & Company          
2974 2974 1991-02-28 Scottish Development Agency 1991-02-20 SCOTLAND Einstein & Sandom, Inc. 4474 1991-02-20 Einstein & Sandom, Inc. Stamford     CT  
3177 3177 2008-02-29 Scottish Enterprise (Through Weber Shandwick) 2002-08-01 SCOTLAND Mullen 5512 2002-08-01 Mullen 5 Atlantic Quay, 150 Broomielaw Glasgow G28LU        
4398 4398 1982-03-31 Scottish Development Agency 1979-07-05 SCOTLAND Roland Olander & Company 3035 1979-07-05 Roland Olander & Company          
4414 4414 1984-03-31 Borders Regional Council 1981-12-31 SCOTLAND Winston Advertising, Inc. 3319 1981-12-31 Winston Advertising, Inc.          
4415 4415 1984-03-31 Central Regional Council 1981-12-31 SCOTLAND Winston Advertising, Inc. 3319 1981-12-31 Winston Advertising, Inc.          
4586 4586 2000-03-31 Scottish Tourist Board 1999-01-08 SCOTLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Edinburgh        
5223 5223 1990-04-12 John C. Maxtone-Mailer 1987-10-29 SCOTLAND Clifford & Warnke 2564 1975-03-26 Clifford & Warnke Ayr        
6076 6076 2013-04-30 Scottish Affairs Office, British Embassy 2013-02-25 SCOTLAND Bromwich Group, LLC 6155 2013-02-25 Bromwich Group, LLC 3100 Massachusetts Avenue, NW   Washington DC 20008-3600
6741 6741 1985-05-23 Scottish Development Agency 1981-08-24 SCOTLAND Bohle Company 3270 1981-08-24 Bohle Company Glasgow        
6934 6934 1980-05-30 Scottish Development Agency 1979-02-08 SCOTLAND J. Walter Thompson Company 2996 1979-02-08 J. Walter Thompson Company Glasgow        
6974 6974 1989-05-30 Scottish Equitable Life Assurance Society 1988-08-18 SCOTLAND Government Research Corporation 4170 1988-08-18 Government Research Corporation Edinburgh        
7413 7413 1991-06-01 Highlands & Islands Development Board 1983-03-25 SCOTLAND M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. Inverness        
7487 7487 1981-06-02 Scottish Council, Development & Industry 1967-11-01 SCOTLAND British-American Chamber of Commerce 2062 1967-11-01 British-American Chamber of Commerce          
7613 7613 1995-06-05 Scottish Development Agency 1988-04-20 SCOTLAND ClarkeGowardFittsMatteson, Inc. 4123 1988-04-20 ClarkeGowardFittsMatteson, Inc. Glasgow        
7622 7622 1961-06-06 Northern League 1960-12-06 SCOTLAND Crockford, Peter James 1413 1960-12-06 Crockford, Peter James Dunfermline        
7623 7623 1961-06-06 Northern World 1960-12-06 SCOTLAND Crockford, Peter James 1413 1960-12-06 Crockford, Peter James Dunfermline        
8405 8405 1986-06-30 Glenrothes Development Corporation 1980-06-11 SCOTLAND Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8610 8610 2001-06-30 Locate in Scotland 1994-05-06 SCOTLAND Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. Glasgow        
8864 8864 1986-07-01 Scottish Development Agency 1983-06-27 SCOTLAND Carl Byoir & Associates, Inc. 3170 1980-11-24 Carl Byoir & Associates, Inc.          
9491 9491 1942-07-27 Anchor Line, Ltd. 1942-07-27 SCOTLAND Anchor Line, Ltd. 66 1942-07-27 Anchor Line, Ltd. Glasgow        
9929 9929 2019-07-31 Government of Scotland in North America 2019-01-28 SCOTLAND Clyde Group, LLC 6631 2019-01-28 Clyde Group, LLC 3100 Massachusetts Avenue, NW   Washington DC 20008
10567 10567 1994-08-16 Glasgow Development Agency 1992-06-11 SCOTLAND Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. Glasgow        
10815 10815 2008-08-28 Scottish National Party 1998-11-18 SCOTLAND Porter, Wright, Morris & Arthur, LLP 5208 1997-09-15 Porter, Wright, Morris & Arthur, LLP Edinburgh        
11544 11544 1994-09-12 Locate in Scotland (Formerly: Scottish Development Agency) 1987-12-11 SCOTLAND Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. Glasgow        
11632 11632 1987-09-15 Scottish Development Agency 1986-10-22 SCOTLAND David M. Grant, Inc. 3900 1986-10-22 David M. Grant, Inc. Glascow        
11731 11731 1984-09-20 Scottish Development Agency 1981-06-18 SCOTLAND Scottish Development Agency 3249 1981-06-18 Scottish Development Agency Glasgow        
12095 12095 1998-09-30 Greater Glasgow & Clyde Valley Tourist Board 1999-01-08 SCOTLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Glasgow        
12715 12715 1988-10-15 Scottish Development Agency 1986-08-28 SCOTLAND Rifkind, Pondel & Parsons 3879 1986-08-28 Rifkind, Pondel & Parsons Glasgow        
13371 13371 1997-10-31 Scottish Tourist Board 1996-07-24 SCOTLAND Lou Hammond & Associates, Inc. 3682 1985-05-23 Lou Hammond & Associates, Inc. Edinburgh        
13570 13570 1986-11-01 Scottish Development Agency 1982-06-16 SCOTLAND Promotional Concept Group, Inc. 3383 1982-06-16 Promotional Concept Group, Inc.          
14096 14096 1992-11-20 Livingston Development Corporation 1986-06-03 SCOTLAND Livingston Development Corporation 3838 1986-06-03 Livingston Development Corporation Scotland        
14250 14250 1998-11-25 Scottish National Party 1994-10-11 SCOTLAND Ackerman, Robert L. 4962 1994-10-11 Ackerman, Robert L. Edinburgh        
14261 14261 1982-11-26 Scottish Development Agency 1979-07-09 SCOTLAND Roberts, Richard I. 3036 1979-07-09 Roberts, Richard I. Glasgow        
14426 14426 1990-11-30 Scottish Development Agency 1979-08-22 SCOTLAND MacFarlane & Company, Inc. 3051 1979-08-22 MacFarlane & Company, Inc.          
14478 14478 1997-11-30 Scottish Trade International 1995-10-24 SCOTLAND Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. Glasgow        
14514 14514 2004-11-30 Scottish Enterprise 2002-06-19 SCOTLAND IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 150 Broomielaw, Atlantic Quay Glasgow, G2 8LU        
14827 14827 1994-12-05 Highlands & Islands Enterprise 1994-12-05 SCOTLAND Barker, Mearns & Gill Public Relations 4977 1994-12-05 Barker, Mearns & Gill Public Relations St. Inverness        
15303 15303 1995-12-21 Scotch Whisky Association 1986-06-10 SCOTLAND Morgan, Lewis & Bockius, L.L.P. 3794 1986-03-12 Morgan, Lewis & Bockius, L.L.P. Edinburgh        
15886 15886 1982-12-31 Scottish Development Agency 1982-09-13 SCOTLAND Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc.          

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);