List of all foreign principals (active and terminated)

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

31 rows where Registrant_Name = "Keating Group, Inc." and State = "NY"

View and edit SQL

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

Foreign_Principal_Termination_Date (date)

State

Registrant_Name

  • Keating Group, Inc. · 31

City

  • - 31
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
734 1978-01-01 Government of India Tourist Office 1977-07-13 INDIA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
753 1982-01-01 British-American Chamber of Commerce 1974-12-31 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3433 1993-03-11 ALIA, Royal Jordanian Airline 1987-07-14 JORDAN 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3434 1993-03-11 Air Afrique 1987-05-26 SENEGAL 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3435 1993-03-11 Air France 1987-05-26 FRANCE 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3437 1993-03-11 Australian Consulate General 1976-10-22 AUSTRALIA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3438 1993-03-11 Australian Tourist Commission 1987-05-26 AUSTRALIA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3440 1993-03-11 Brazilian-American Chamber of Commerce 1987-05-26 BRAZIL 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3441 1993-03-11 BritRail Travel International, Inc. 1982-11-15 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3444 1993-03-11 Egyptian Tourist Authority 1987-05-26 EGYPT 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3446 1993-03-11 France-Tourisme 1989-06-23 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3447 1993-03-11 French Alps Commission 1991-09-24 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3448 1993-03-11 French Government Tourist Office 1989-06-23 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3449 1993-03-11 Global Tours 1987-05-26 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3453 1993-03-11 Ivory Coast Department of Tourism 1987-05-26 COTE D'IVOIRE (IVORY COAST) 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3454 1993-03-11 MISR Travel 1979-07-17 EGYPT 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3457 1993-03-11 Shannon Development 1987-05-26 IRELAND 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3460 1993-03-11 United Aviation Services, Inc. 1987-05-26 PANAMA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3461 1993-03-11 Venezuelan-American Association 1989-06-23 VENEZUELA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3462 1993-03-11 Virgin Atlantic Airways 1991-09-24 BRITISH VIRGIN ISLANDS 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5581 1975-04-30 Italian Line 1974-07-02 ITALY 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5973 1990-05-01 Dial Austria Instant Reservations, Inc. 1987-05-26 AUSTRIA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
5974 1990-05-01 Egyptian Government Tourist Office 1976-04-13 EGYPT 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5976 1990-05-01 New Zealand Tourist Office 1982-11-15 NEW ZEALAND 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5977 1990-05-01 Trade Development Authority of India 1987-05-26 INDIA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
8061 1982-06-30 Republic of Turkey 1973-11-23 TURKEY 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
8099 1984-06-30 Kenya Airways 1979-07-17 KENYA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
8100 1984-06-30 Kenya Tourist Office 1978-08-16 KENYA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
14198 1975-12-01 Adriatica Line 1974-12-31 ITALY 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
14199 1975-12-01 Information Service of South Africa 1974-12-31 SOUTH AFRICA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
14240 1987-12-01 Merit Hotels, Ltd. 1987-05-26 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc.       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])
);