FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
44 rows where Country/Location_Represented = "SCOTLAND"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal_Registration_Date (date) 41 ✖
- 1960-12-06 2
- 1981-12-31 2
- 1999-01-08 2
- 1942-07-27 1
- 1967-11-01 1
- 1979-02-08 1
- 1979-04-17 1
- 1979-07-05 1
- 1979-07-09 1
- 1979-07-23 1
- 1979-08-22 1
- 1980-05-08 1
- 1980-06-11 1
- 1981-06-18 1
- 1981-08-24 1
- 1982-06-16 1
- 1982-09-13 1
- 1983-03-25 1
- 1983-06-27 1
- 1986-06-03 1
- 1986-06-10 1
- 1986-08-28 1
- 1986-10-22 1
- 1987-10-29 1
- 1987-12-11 1
- 1988-04-20 1
- 1988-08-18 1
- 1989-05-31 1
- 1991-02-20 1
- 1992-06-11 1
- 1994-05-06 1
- 1994-10-11 1
- 1994-12-05 1
- 1995-10-24 1
- 1996-07-24 1
- 1998-11-18 1
- 2002-06-19 1
- 2002-08-01 1
- 2013-02-25 1
- 2019-01-28 1
- 2021-10-29 1
Registrant_Name 37
- Development Counsellors International 3
- Al Paul Lefton Company, Inc. 2
- Clarke & Company, Inc. 2
- Crockford, Peter James 2
- Roland Olander & Company 2
- Winston Advertising, Inc. 2
- Ackerman, Robert L. 1
- Anchor Line, Ltd. 1
- Barker, Mearns & Gill Public Relations 1
- Bohle Company 1
- British-American Chamber of Commerce 1
- Bromwich Group, LLC 1
- Carl Byoir & Associates, Inc. 1
- ClarkeGowardFittsMatteson, Inc. 1
- Clifford & Warnke 1
- Clyde Group, LLC 1
- David M. Grant, Inc. 1
- Development Counsellors International, Ltd. 1
- Einstein & Sandom, Inc. 1
- Government Research Corporation 1
- Hill and Knowlton Strategies, LLC 1
- IPG DXTRA, Inc 1
- J. Walter Thompson Company 1
- Livingston Development Corporation 1
- Lou Hammond & Associates, Inc. 1
- M. Silver Associates, Inc. 1
- MacFarlane & Company, Inc. 1
- Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 1
- Morgan, Lewis & Bockius, L.L.P. 1
- Mullen 1
- Newsome & Company, Inc. 1
- Porter, Wright, Morris & Arthur, LLP 1
- Promotional Concept Group, Inc. 1
- Rifkind, Pondel & Parsons 1
- Roberts, Richard I. 1
- Scottish Development Agency 1
- Scottish Enterprise 1
Registrant_Date 37 ✖
- 1993-03-12 3
- 1960-12-06 2
- 1979-07-05 2
- 1981-12-31 2
- 1987-12-11 2
- 1994-05-06 2
- 1942-07-27 1
- 1961-01-30 1
- 1967-11-01 1
- 1975-03-26 1
- 1979-02-08 1
- 1979-04-17 1
- 1979-07-09 1
- 1979-07-23 1
- 1979-08-22 1
- 1980-07-15 1
- 1980-11-24 1
- 1981-01-09 1
- 1981-06-18 1
- 1981-08-24 1
- 1981-11-10 1
- 1982-06-16 1
- 1985-05-23 1
- 1986-03-12 1
- 1986-06-03 1
- 1986-08-28 1
- 1986-10-22 1
- 1986-12-01 1
- 1988-04-20 1
- 1988-08-18 1
- 1991-02-20 1
- 1994-10-11 1
- 1994-12-05 1
- 1997-09-15 1
- 2002-08-01 1
- 2013-02-25 1
- 2019-01-28 1
Foreign_Principal 29
- Scottish Development Agency 13
- Scottish Equitable Life Assurance Society 2
- Scottish National Party 2
- Scottish Tourist Board 2
- Anchor Line, Ltd. 1
- Borders Regional Council 1
- Central Regional Council 1
- Glasgow Development Agency 1
- Glenrothes Development Corporation 1
- Government of Scotland in North America 1
- Greater Glasgow & Clyde Valley Tourist Board 1
- Highlands & Islands Development Board 1
- Highlands & Islands Enterprise 1
- John C. Maxtone-Mailer 1
- Livingston Development Corporation 1
- Locate in Scotland 1
- Locate in Scotland (Formerly: Scottish Development Agency) 1
- Northern League 1
- Northern World 1
- Scotch Whisky Association 1
- Scottish Affairs Office, British Embassy 1
- Scottish Council, Development & Industry 1
- Scottish Development Agency, Glasgow, Scotland 1
- Scottish Enterprise 1
- Scottish Enterprise (Through Weber Shandwick) 1
- Scottish Enterprise (formerly: Scottish Development Agency) 1
- Scottish Trade International 1
- UNILINK Research Park 1
- Visit Scotland 1
City 3
- - 41
- Washington 2
- Edinburgh 1
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
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]) );