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

19 rows where Country/Location_Represented = "IRELAND" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • IRELAND · 19 ✖
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
240 240   Enterprise Ireland 2023-01-09 IRELAND Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 345 Park Avenue, 17th Floor   New York NY 10154
713 713   Tourism Ireland Limited 2003-11-20 IRELAND Tourism Ireland Limited 5594 2003-11-20 Tourism Ireland Limited 345 Park Avenue, New York 10154     NY  
1753 1753 1991-01-31 Aerlinte Eireann Teoranta Trading (AerLingus) 1986-04-10 IRELAND Hill, Holliday, Connors, Cosmopulos, Inc. 3810 1986-04-10 Hill, Holliday, Connors, Cosmopulos, Inc.       NY  
3242 3242 1973-03-01 Irish Tourist Board 1972-01-17 IRELAND Berger, Olson & Beaumont, Inc. 2306 1972-01-17 Berger, Olson & Beaumont, Inc. New York     NY  
3629 3629 1993-03-11 Shannon Development 1987-05-26 IRELAND Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
4335 4335 1970-03-31 Irish Tourist Board 1968-03-29 IRELAND De Garmo-McCaffery, Inc. 1821 1964-11-25 De Garmo-McCaffery, Inc. New York     NY  
5202 5202 1985-04-12 Industrial Development Board of Northern Ireland 1984-11-13 IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5216 5216 1987-04-12 AER Lingus 1986-05-21 IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5241 5241 1984-04-13 Irish Tourist Board 1980-12-01 IRELAND Kardwell Associates, Inc. 3174 1980-12-01 Kardwell Associates, Inc.       NY  
5445 5445 1958-04-21 Irish Counties Bureau 1958-04-21 IRELAND Prisoners Aid Society 1202 1958-04-21 Prisoners Aid Society Yonkers     NY  
5599 5599 1990-04-26 Shannon Airport Development Company 1986-07-21 IRELAND St. Vincent, Richard L. 3928 1986-07-21 St. Vincent, Richard L. New York     NY  
5869 5869 1992-04-30 Aer Lingus 1992-01-03 IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
7494 7494 1993-06-02 Irish Tourist Board 1964-10-29 IRELAND Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
7895 7895 1992-06-17 Irish Tourist Board 1986-04-10 IRELAND Hill, Holliday, Connors, Cosmopulos, Inc. 3810 1986-04-10 Hill, Holliday, Connors, Cosmopulos, Inc.       NY  
8369 8369 1983-06-30 Northern Ireland Industrial Development 1982-09-27 IRELAND N.W. Ayer & Son, Inc. 3411 1982-09-27 N.W. Ayer & Son, Inc.       NY  
11584 11584 1988-09-14 Industrial Development Authority-North America (Rep. of Ireland) 1985-03-14 IRELAND Savage, Harry A. 3658 1985-03-14 Savage, Harry A. New York     NY  
12620 12620 1986-10-12 Spring O'Brien 1986-01-06 IRELAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13139 13139 1997-10-29 Friends of Sinn Fein, Inc. 1997-08-29 IRELAND MWW/Strategic Communications, Inc. 5209 1997-08-29 MWW/Strategic Communications, Inc. New York     NY  
15032 15032 1958-12-12 Irish Republican Army Prisoners' Dependents Fund Committee 1958-06-11 IRELAND Irish Republic Army Prisoners' Dependents Fund Committee 1149 1958-06-11 Irish Republic Army Prisoners' Dependents Fund Committee New York     NY  

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