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

30 rows where Country/Location_Represented = "NORTHERN IRELAND"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 3

Country/Location_Represented 1

  • NORTHERN IRELAND · 30 ✖

City 1

  • - 30
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
352 352   Invest Northern Ireland 1990-04-13 NORTHERN IRELAND Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland Belfast        
1270 1270 1989-01-13 Social Democratic & Labour Party of Northern Ireland 1987-11-24 NORTHERN IRELAND Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Belfast        
1822 1822 1999-01-31 Central Office of Information Government of the United Kingdom 1998-10-19 NORTHERN IRELAND Shandwick Public Affairs, Inc. 5220 1997-12-17 Shandwick Public Affairs, Inc. IDB House, 64 Chicester Street, Belfast,        
1872 1872 2007-01-31 Social Democratic Labour Party of Northern Ireland 2006-02-02 NORTHERN IRELAND O'Neill, Rosemary D. 5730 2006-02-02 O'Neill, Rosemary D. 121 Ormeau Road Belfast, BT 71 sh        
2223 2223 1996-02-05 Industrial Development Board of Northern Ireland 1993-09-07 NORTHERN IRELAND Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Belfast        
3527 3527 1997-03-08 Social Democratic & Labour Party of Northern Ireland 1984-03-09 NORTHERN IRELAND Oldaker, William C. 3564 1984-03-08 Oldaker, William C. Belfast        
4633 4633 2004-03-31 Invest Northern Ireland 2001-08-10 NORTHERN IRELAND GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Industrial Development Board for Northern Ireland Corporate Headquarters 64 Chichester St. Belfast B        
4672 4672 2006-03-31 Ulster Unionist Council 1995-09-07 NORTHERN IRELAND AWS Services 5043 1995-09-07 AWS Services Belfast        
6265 6265 1990-05-02 Democratic Unionist Party of Northern Ireland 1984-05-18 NORTHERN IRELAND Jack E. Buttram Company, Inc. 3588 1984-05-18 Jack E. Buttram Company, Inc. Belfast        
7080 7080 1990-05-31 Industrial Development Board of Northern Ireland 1986-11-20 NORTHERN IRELAND Burson-Marsteller 2469 1973-10-23 Burson-Marsteller          
8042 8042 1995-06-23 Ulster Unionist Party 1995-03-09 NORTHERN IRELAND Pathfinder Group, L.L.C. 5001 1995-03-09 Pathfinder Group, L.L.C. Belfast        
10045 10045 2008-08-01 Social Democratic Labor Party 2006-09-19 NORTHERN IRELAND O'Malley, Sheila 5769 2006-09-19 O'Malley, Sheila 121 Ormeau Road Belfast BT7 ISH      
10143 10143 1994-08-05 Democratic Unionist Party 1994-05-12 NORTHERN IRELAND Jack E. Buttram & Company 4913 1994-05-12 Jack E. Buttram & Company Belfast        
10768 10768 1996-08-26 An Cumann Cabhrach 1985-05-21 NORTHERN IRELAND Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee Dublin        
10769 10769 1996-08-26 Irish Republican Army 1985-05-21 NORTHERN IRELAND Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee          
11410 11410 1993-09-07 Industrial Development Board of Northern Ireland 1991-08-06 NORTHERN IRELAND Golin/Harris Communications, Inc. 3949 1987-03-18 Golin/Harris Communications, Inc. Belfast        
12131 12131 2002-09-30 Northern Ireland Women's Coalition 1999-03-12 NORTHERN IRELAND Rhoney, Colette T. 5305 1999-03-12 Rhoney, Colette T. 52 Elmwood Avenue, Belfast        
12169 12169 2006-09-30 John Hume, MP & Social Democratic Labour Party 1994-03-07 NORTHERN IRELAND O'Neill III, Thomas P. 4898 1994-03-07 O'Neill III, Thomas P. Derry        
12181 12181 2007-09-30 Northern Ireland Tourist Board 2007-05-04 NORTHERN IRELAND Development Counsellors International 4777 1993-03-12 Development Counsellors International          
12546 12546 1978-10-08 Community of Peace People 1977-06-07 NORTHERN IRELAND Corrigan, Mairead 2784 1977-06-07 Corrigan, Mairead          
12547 12547 1978-10-08 Community of the Peace People, Inc. 1977-07-11 NORTHERN IRELAND McKeown, Ciaran 2807 1977-07-11 McKeown, Ciaran Belfast        
13003 13003 1989-10-25 Burson-Marsteller for the Industrial Development Board of Northern Ireland 1988-10-03 NORTHERN IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13017 13017 1989-10-25 Industrial Development Board of Northern Ireland 1988-02-09 NORTHERN IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13686 13686 1993-11-03 Short Brothers, PLC 1985-03-19 NORTHERN IRELAND Hyjek & Fix, Inc. 3660 1985-03-19 Hyjek & Fix, Inc.          
13993 13993 1998-11-15 Northern Ireland Free Trade Initiative 1998-05-21 NORTHERN IRELAND Pathfinder Group, LLC 5257 1998-05-21 Pathfinder Group, LLC John L. Andrews, William Clark & Sons, Ltd., Upperlands Maghera County, Londonderry        
14204 14204 1971-11-24 Northern Ireland Civil Rights Association 1970-08-20 NORTHERN IRELAND National Association for Irish Justice 2207 1970-08-20 National Association for Irish Justice Belfast        
14532 14532 2008-11-30 Invest Northern Ireland 2008-01-28 NORTHERN IRELAND Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Bedford Square Bedford Street Belfast BT2 7ES      
14863 14863 1977-12-07 Community of the Peace People 1977-06-07 NORTHERN IRELAND Close, Anne 2785 1977-06-07 Close, Anne Belfast        
14952 14952 1992-12-10 Short Brothers, PLC 1991-06-21 NORTHERN IRELAND Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Belfast        
16368 16368 1995-12-31 Short Brothers 1995-06-02 NORTHERN IRELAND Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Arlington     VA  

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])
);