home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

29 rows where Country/Location_Represented = "LUXEMBOURG"

✎ 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, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name 24

  • Development Counsellors International, Ltd. 3
  • Luxcore, Ltd. 3
  • Hooper, Hooper, Owen & Gould 2
  • BGR Government Affairs, LLC 1
  • Cleary, Gottlieb, Steen & Hamilton, LLP 1
  • Covington & Burling, LLP 1
  • Culbertson, William S. 1
  • Dickstein Shapiro, LLP 1
  • European Community Information Service 1
  • French & Preston 1
  • Government Research Corporation 1
  • Hill and Knowlton Strategies, LLC 1
  • Jack H. McDonald Company 1
  • Ketchum Communications, Inc., Through Ketchum P.R., New York 1
  • Kuett & Company, Inc. 1
  • Manning, Selvage & Lee 1
  • Oliver A. Dulle, Jr. & Company, Inc. 1
  • Powell, Goldstein, Frazer & Murphy, L.L.P. 1
  • Price Waterhouse 1
  • Shearman & Sterling 1
  • South/North Development Group, Ltd. 1
  • Squire Patton Boggs, LLP 1
  • Teneo Strategy LLC 1
  • Trombone Associates, Inc. 1

Foreign_Principal 20

  • Minorco Societe Anonyme 4
  • Luxembourg Board of Economic Development 3
  • European Investment Bank 2
  • Grand Duchy of Luxembourg 2
  • IFINT, S.A. 2
  • Luxembourg Trade Commission 2
  • Cargolux Airlines International, S.A. 1
  • Consulate General of Luxembourg in New York 1
  • Embassy of the Grand Duchy of Luxembourg 1
  • Eurasian Resources Group 1
  • Exor America (formerly: IFINT, S.A.) 1
  • Government of Luxembourg (Embassy) 1
  • Grand Duchy of Luxembourg - Luxembourg Board of Economic Development 1
  • High Authority of the European Community for Coal & Steel 1
  • High Authority, European Coal & Steel Community 1
  • Letterone Investment Holdings S.A. 1
  • Luxembourg Legation 1
  • Luxembourg Trade & Investment Office in New York 1
  • Luxembourg Trade and Investment Office 1
  • Villeroy & Boch 1

State 3

  • - 19
  • NY 7
  • DC 3

City 3

  • - 25
  • New York 2
  • Washington 2

Country/Location_Represented 1

  • LUXEMBOURG · 29 ✖
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
937 937 1991-01-01 IFINT, S.A. 1990-09-19 LUXEMBOURG Hooper, Hooper, Owen & Gould 4414 1990-09-19 Hooper, Hooper, Owen & Gould          
1738 1738 1990-01-31 Cargolux Airlines International, S.A. 1988-08-19 LUXEMBOURG Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Luxembourg Airport        
1741 1741 1990-01-31 European Investment Bank 1989-05-31 LUXEMBOURG Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Luxembourg-Kirchberg        
1923 1923 2019-01-31 Luxembourg Trade and Investment Office 1994-03-10 LUXEMBOURG Luxcore, Ltd. 4901 1994-03-10 Luxcore, Ltd. New York     NY  
2101 2101 1968-02-02 High Authority, European Coal & Steel Community 1954-08-18 LUXEMBOURG Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP          
2337 2337 1996-02-09 Exor America (formerly: IFINT, S.A.) 1992-12-30 LUXEMBOURG Hooper, Hooper, Owen & Gould 4414 1990-09-19 Hooper, Hooper, Owen & Gould          
2686 2686 1991-02-20 Grand Duchy of Luxembourg 1985-10-30 LUXEMBOURG Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
2694 2694 2022-02-21 Eurasian Resources Group 2021-12-20 LUXEMBOURG BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 9, rue Sainte Zithe L-2763 Luxembourg        
3297 3297 1990-03-01 Minorco Societe Anonyme 1988-10-07 LUXEMBOURG Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Luxembourg-Ville        
3481 3481 1990-03-06 Minorco Societe Anonyme 1989-02-21 LUXEMBOURG South/North Development Group, Ltd. 4219 1989-02-21 South/North Development Group, Ltd. Luxembourg-Ville        
4169 4169 1988-03-30 Luxembourg Trade Commission 1987-04-30 LUXEMBOURG French & Preston 3965 1987-04-30 French & Preston New York     NY  
4468 4468 1989-03-31 Minorco Societe Anonyme 1989-01-23 LUXEMBOURG Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Luxembourg, Ville RC        
5150 5150 2013-04-10 Embassy of the Grand Duchy of Luxembourg 2013-03-01 LUXEMBOURG Covington & Burling, LLP 5852 2008-02-05 Covington & Burling, LLP 2200 Massachusetts Avenue, NW   Washington DC 20008
5407 5407 1989-04-19 Luxembourg Trade Commission 1987-09-25 LUXEMBOURG Manning, Selvage & Lee 4042 1987-09-25 Manning, Selvage & Lee New York     NY  
5937 5937 1993-04-30 Grand Duchy of Luxembourg - Luxembourg Board of Economic Development 1991-04-01 LUXEMBOURG Kuett & Company, Inc. 4491 1991-04-01 Kuett & Company, Inc. Consulate, New York     NY  
6955 6955 1989-05-30 European Investment Bank 1988-08-18 LUXEMBOURG Government Research Corporation 4170 1988-08-18 Government Research Corporation Luxembourg-Kirchberg        
7988 7988 1991-06-21 IFINT, S.A. 1990-09-19 LUXEMBOURG Price Waterhouse 4413 1990-09-19 Price Waterhouse          
8365 8365 1983-06-30 Grand Duchy of Luxembourg 1982-07-19 LUXEMBOURG Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8396 8396 1985-06-30 Luxembourg Board of Economic Development 1982-12-01 LUXEMBOURG Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8611 8611 2001-06-30 Luxembourg Board of Economic Development 2001-07-06 LUXEMBOURG Oliver A. Dulle, Jr. & Company, Inc. 4739 1992-12-17 Oliver A. Dulle, Jr. & Company, Inc. 17 Beekman Place New York 10022     NY  
8788 8788 2022-06-30 Luxembourg Trade & Investment Office in New York 2022-01-17 LUXEMBOURG Luxcore, Ltd. 7072 2022-01-17 Luxcore, Ltd. Consulate General of Luxembourg 17 Beekman Place New York NY 10022
8923 8923 2009-07-01 Government of Luxembourg (Embassy) 2009-04-06 LUXEMBOURG Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 2200 Massachusetts Avenue, NW   Washington DC 20008
11651 11651 1994-09-15 Villeroy & Boch 1992-08-11 LUXEMBOURG Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc.          
12008 12008 1989-09-30 Minorco Societe Anonyme 1989-03-23 LUXEMBOURG Jack H. McDonald Company 3956 1987-04-01 Jack H. McDonald Company Luxembourg-Ville        
13088 13088 1947-10-28 Luxembourg Legation 1947-01-10 LUXEMBOURG Culbertson, William S. 421 1947-01-10 Culbertson, William S. Washington     DC  
13510 13510 2021-10-31 Letterone Investment Holdings S.A. 2020-09-03 LUXEMBOURG Teneo Strategy LLC 6698 2019-07-08 Teneo Strategy LLC 1-3 Boulevard de la Foire L-1528 Luxembourg      
14817 14817 1972-12-05 High Authority of the European Community for Coal & Steel 1956-03-12 LUXEMBOURG European Community Information Service 933 1956-03-12 European Community Information Service Place de Metz        
15407 15407 1989-12-27 Luxembourg Board of Economic Development 1989-05-17 LUXEMBOURG Ketchum Communications, Inc., Through Ketchum P.R., New York 4254 1989-05-17 Ketchum Communications, Inc., Through Ketchum P.R., New York          
16919 16919 2022-12-31 Consulate General of Luxembourg in New York 2022-07-08 LUXEMBOURG Luxcore, Ltd. 7072 2022-01-17 Luxcore, Ltd. 17 Beekman Place   New York NY 10022

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])
);
Powered by Datasette · Queries took 158.595ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history