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

43 rows where Registrant_Name = "Keating Group, Inc." sorted by Foreign_Principal_Registration_Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registrant_Name

  • Keating Group, Inc. · 43 ✖

City

  • - 43
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
8053 8053 1982-06-30 Republic of Turkey 1973-11-23 TURKEY 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5580 5580 1975-04-30 Italian Line 1974-07-02 ITALY 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
759 759 1982-01-01 British-American Chamber of Commerce 1974-12-31 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
14183 14183 1975-12-01 Adriatica Line 1974-12-31 ITALY 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
14184 14184 1975-12-01 Information Service of South Africa 1974-12-31 SOUTH AFRICA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5969 5969 1990-05-01 Egyptian Government Tourist Office 1976-04-13 EGYPT 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3442 3442 1993-03-11 Australian Consulate General 1976-10-22 AUSTRALIA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
740 740 1978-01-01 Government of India Tourist Office 1977-07-13 INDIA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
8092 8092 1984-06-30 Kenya Tourist Office 1978-08-16 KENYA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3459 3459 1993-03-11 MISR Travel 1979-07-17 EGYPT 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
8091 8091 1984-06-30 Kenya Airways 1979-07-17 KENYA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3446 3446 1993-03-11 BritRail Travel International, Inc. 1982-11-15 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
5971 5971 1990-05-01 New Zealand Tourist Office 1982-11-15 NEW ZEALAND 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3439 3439 1993-03-11 Air Afrique 1987-05-26 SENEGAL 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3440 3440 1993-03-11 Air France 1987-05-26 FRANCE 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3443 3443 1993-03-11 Australian Tourist Commission 1987-05-26 AUSTRALIA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3445 3445 1993-03-11 Brazilian-American Chamber of Commerce 1987-05-26 BRAZIL 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3449 3449 1993-03-11 Egyptian Tourist Authority 1987-05-26 EGYPT 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3454 3454 1993-03-11 Global Tours 1987-05-26 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3458 3458 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  
3462 3462 1993-03-11 Shannon Development 1987-05-26 IRELAND 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3465 3465 1993-03-11 United Aviation Services, Inc. 1987-05-26 PANAMA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
5968 5968 1990-05-01 Dial Austria Instant Reservations, Inc. 1987-05-26 AUSTRIA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
5972 5972 1990-05-01 Trade Development Authority of India 1987-05-26 INDIA 2478 2478 1973-11-23 Keating Group, Inc.       NY  
14225 14225 1987-12-01 Merit Hotels, Ltd. 1987-05-26 GREAT BRITAIN 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3438 3438 1993-03-11 ALIA, Royal Jordanian Airline 1987-07-14 JORDAN 2478 2478 1973-11-23 Keating Group, Inc.       NY  
3448 3448 1993-03-11 Crest Hotels International 1988-12-21 INTERNATIONAL 2478 2478 1973-11-23 Keating Group, Inc. Silver Springs     MD  
3457 3457 1993-03-11 Hotel Villa Magna 1988-12-21 SPAIN 2478 2478 1973-11-23 Keating Group, Inc. Madrid        
3441 3441 1993-03-11 Atlante Hotels 1989-06-23 ITALY 2478 2478 1973-11-23 Keating Group, Inc. Rome        
3451 3451 1993-03-11 France-Tourisme 1989-06-23 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3453 3453 1993-03-11 French Government Tourist Office 1989-06-23 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3466 3466 1993-03-11 Venezuelan-American Association 1989-06-23 VENEZUELA 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3460 3460 1993-03-11 Melaine Communications Group 1989-12-28 CANADA 2478 2478 1973-11-23 Keating Group, Inc. Toronto, Ontario        
3464 3464 1993-03-11 UTA French Airlines 1989-12-28 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. San Francisco     CA  
3456 3456 1993-03-11 Hotel Marquis Reforma 1991-04-16 MEXICO 2478 2478 1973-11-23 Keating Group, Inc. Mexico City        
3463 3463 1993-03-11 Turks & Caicos Tourist Board 1991-04-16 TURKS AND CAICOS ISLANDS 2478 2478 1973-11-23 Keating Group, Inc. Grand Turk        
3452 3452 1993-03-11 French Alps Commission 1991-09-24 FRANCE 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3467 3467 1993-03-11 Virgin Atlantic Airways 1991-09-24 BRITISH VIRGIN ISLANDS 2478 2478 1973-11-23 Keating Group, Inc. New York     NY  
3444 3444 1993-03-11 Barbados Hotel Association 1992-01-14 BARBADOS 2478 2478 1973-11-23 Keating Group, Inc. St. Michael        
3461 3461 1993-03-11 Ocean Club at Grace Bay 1992-01-14 TURKS AND CAICOS ISLANDS 2478 2478 1973-11-23 Keating Group, Inc. Providenciales        
3447 3447 1993-03-11 Caravanserai 1992-04-06 NETHERLANDS ANTILLES 2478 2478 1973-11-23 Keating Group, Inc.          
3450 3450 1993-03-11 Elegant Resorts of Barbados 1992-04-06 BARBADOS 2478 2478 1973-11-23 Keating Group, Inc. Bridgetown        
3455 3455 1993-03-11 Hotel K-Royal de Mexico 1992-04-06 MEXICO 2478 2478 1973-11-23 Keating Group, Inc. Mexico City        

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