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

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)

Foreign_Principal >30

  • ALIA, Royal Jordanian Airline 1
  • Adriatica Line 1
  • Air Afrique 1
  • Air France 1
  • Atlante Hotels 1
  • Australian Consulate General 1
  • Australian Tourist Commission 1
  • Barbados Hotel Association 1
  • Brazilian-American Chamber of Commerce 1
  • BritRail Travel International, Inc. 1
  • British-American Chamber of Commerce 1
  • Caravanserai 1
  • Crest Hotels International 1
  • Dial Austria Instant Reservations, Inc. 1
  • Egyptian Government Tourist Office 1
  • Egyptian Tourist Authority 1
  • Elegant Resorts of Barbados 1
  • France-Tourisme 1
  • French Alps Commission 1
  • French Government Tourist Office 1
  • Global Tours 1
  • Government of India Tourist Office 1
  • Hotel K-Royal de Mexico 1
  • Hotel Marquis Reforma 1
  • Hotel Villa Magna 1
  • Information Service of South Africa 1
  • Italian Line 1
  • Ivory Coast Department of Tourism 1
  • Kenya Airways 1
  • Kenya Tourist Office 1
  • …

Country/Location_Represented 26

  • FRANCE 5
  • GREAT BRITAIN 4
  • EGYPT 3
  • ITALY 3
  • AUSTRALIA 2
  • BARBADOS 2
  • INDIA 2
  • KENYA 2
  • MEXICO 2
  • TURKS AND CAICOS ISLANDS 2
  • AUSTRIA 1
  • BRAZIL 1
  • BRITISH VIRGIN ISLANDS 1
  • CANADA 1
  • COTE D'IVOIRE (IVORY COAST) 1
  • INTERNATIONAL 1
  • IRELAND 1
  • JORDAN 1
  • NETHERLANDS ANTILLES 1
  • NEW ZEALAND 1
  • PANAMA 1
  • SENEGAL 1
  • SOUTH AFRICA 1
  • SPAIN 1
  • TURKEY 1
  • VENEZUELA 1

State 4

  • NY 31
  • - 10
  • CA 1
  • MD 1

Registrant_Name 1

  • Keating Group, Inc. · 43 ✖

City 1

  • - 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
8347 8347 1982-06-30 Republic of Turkey 1973-11-23 TURKEY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
5804 5804 1975-04-30 Italian Line 1974-07-02 ITALY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
842 842 1982-01-01 British-American Chamber of Commerce 1974-12-31 GREAT BRITAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
14648 14648 1975-12-01 Adriatica Line 1974-12-31 ITALY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
14649 14649 1975-12-01 Information Service of South Africa 1974-12-31 SOUTH AFRICA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
6203 6203 1990-05-01 Egyptian Government Tourist Office 1976-04-13 EGYPT Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3609 3609 1993-03-11 Australian Consulate General 1976-10-22 AUSTRALIA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
823 823 1978-01-01 Government of India Tourist Office 1977-07-13 INDIA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
8386 8386 1984-06-30 Kenya Tourist Office 1978-08-16 KENYA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3626 3626 1993-03-11 MISR Travel 1979-07-17 EGYPT Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
8385 8385 1984-06-30 Kenya Airways 1979-07-17 KENYA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3613 3613 1993-03-11 BritRail Travel International, Inc. 1982-11-15 GREAT BRITAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
6205 6205 1990-05-01 New Zealand Tourist Office 1982-11-15 NEW ZEALAND Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3606 3606 1993-03-11 Air Afrique 1987-05-26 SENEGAL Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3607 3607 1993-03-11 Air France 1987-05-26 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3610 3610 1993-03-11 Australian Tourist Commission 1987-05-26 AUSTRALIA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3612 3612 1993-03-11 Brazilian-American Chamber of Commerce 1987-05-26 BRAZIL Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3616 3616 1993-03-11 Egyptian Tourist Authority 1987-05-26 EGYPT Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3621 3621 1993-03-11 Global Tours 1987-05-26 GREAT BRITAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3625 3625 1993-03-11 Ivory Coast Department of Tourism 1987-05-26 COTE D'IVOIRE (IVORY COAST) Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3629 3629 1993-03-11 Shannon Development 1987-05-26 IRELAND Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3632 3632 1993-03-11 United Aviation Services, Inc. 1987-05-26 PANAMA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
6202 6202 1990-05-01 Dial Austria Instant Reservations, Inc. 1987-05-26 AUSTRIA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
6206 6206 1990-05-01 Trade Development Authority of India 1987-05-26 INDIA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
14690 14690 1987-12-01 Merit Hotels, Ltd. 1987-05-26 GREAT BRITAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3605 3605 1993-03-11 ALIA, Royal Jordanian Airline 1987-07-14 JORDAN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3615 3615 1993-03-11 Crest Hotels International 1988-12-21 INTERNATIONAL Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Silver Springs     MD  
3624 3624 1993-03-11 Hotel Villa Magna 1988-12-21 SPAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Madrid        
3608 3608 1993-03-11 Atlante Hotels 1989-06-23 ITALY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Rome        
3618 3618 1993-03-11 France-Tourisme 1989-06-23 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3620 3620 1993-03-11 French Government Tourist Office 1989-06-23 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3633 3633 1993-03-11 Venezuelan-American Association 1989-06-23 VENEZUELA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3627 3627 1993-03-11 Melaine Communications Group 1989-12-28 CANADA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Toronto, Ontario        
3631 3631 1993-03-11 UTA French Airlines 1989-12-28 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. San Francisco     CA  
3623 3623 1993-03-11 Hotel Marquis Reforma 1991-04-16 MEXICO Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Mexico City        
3630 3630 1993-03-11 Turks & Caicos Tourist Board 1991-04-16 TURKS AND CAICOS ISLANDS Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Grand Turk        
3619 3619 1993-03-11 French Alps Commission 1991-09-24 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3634 3634 1993-03-11 Virgin Atlantic Airways 1991-09-24 BRITISH VIRGIN ISLANDS Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3611 3611 1993-03-11 Barbados Hotel Association 1992-01-14 BARBADOS Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. St. Michael        
3628 3628 1993-03-11 Ocean Club at Grace Bay 1992-01-14 TURKS AND CAICOS ISLANDS Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Providenciales        
3614 3614 1993-03-11 Caravanserai 1992-04-06 NETHERLANDS ANTILLES Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.          
3617 3617 1993-03-11 Elegant Resorts of Barbados 1992-04-06 BARBADOS Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. Bridgetown        
3622 3622 1993-03-11 Hotel K-Royal de Mexico 1992-04-06 MEXICO Keating Group, Inc. 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])
);
Powered by Datasette · Queries took 186.132ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows