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

31 rows where Registrant_Name = "Keating Group, Inc." and State = "NY" sorted by Country/Location_Represented

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • ALIA, Royal Jordanian Airline 1
  • Adriatica Line 1
  • Air Afrique 1
  • Air France 1
  • Australian Consulate General 1
  • Australian Tourist Commission 1
  • Brazilian-American Chamber of Commerce 1
  • BritRail Travel International, Inc. 1
  • British-American Chamber of Commerce 1
  • Dial Austria Instant Reservations, Inc. 1
  • Egyptian Government Tourist Office 1
  • Egyptian Tourist Authority 1
  • France-Tourisme 1
  • French Alps Commission 1
  • French Government Tourist Office 1
  • Global Tours 1
  • Government of India Tourist Office 1
  • Information Service of South Africa 1
  • Italian Line 1
  • Ivory Coast Department of Tourism 1
  • Kenya Airways 1
  • Kenya Tourist Office 1
  • MISR Travel 1
  • Merit Hotels, Ltd. 1
  • New Zealand Tourist Office 1
  • Republic of Turkey 1
  • Shannon Development 1
  • Trade Development Authority of India 1
  • United Aviation Services, Inc. 1
  • Venezuelan-American Association 1
  • …

Country/Location_Represented 19

  • FRANCE 4
  • GREAT BRITAIN 4
  • EGYPT 3
  • AUSTRALIA 2
  • INDIA 2
  • ITALY 2
  • KENYA 2
  • AUSTRIA 1
  • BRAZIL 1
  • BRITISH VIRGIN ISLANDS 1
  • COTE D'IVOIRE (IVORY COAST) 1
  • IRELAND 1
  • JORDAN 1
  • NEW ZEALAND 1
  • PANAMA 1
  • SENEGAL 1
  • SOUTH AFRICA 1
  • TURKEY 1
  • VENEZUELA 1

State 1

  • NY · 31 ✖

Registrant_Name 1

  • Keating Group, Inc. · 31 ✖

City 1

  • - 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
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  
3610 3610 1993-03-11 Australian Tourist Commission 1987-05-26 AUSTRALIA 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  
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  
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  
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  
3616 3616 1993-03-11 Egyptian Tourist Authority 1987-05-26 EGYPT Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       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  
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  
3607 3607 1993-03-11 Air France 1987-05-26 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3618 3618 1993-03-11 France-Tourisme 1989-06-23 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
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  
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  
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  
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  
3621 3621 1993-03-11 Global Tours 1987-05-26 GREAT BRITAIN 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  
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  
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  
3629 3629 1993-03-11 Shannon Development 1987-05-26 IRELAND Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       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  
14648 14648 1975-12-01 Adriatica Line 1974-12-31 ITALY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     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  
8385 8385 1984-06-30 Kenya Airways 1979-07-17 KENYA 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  
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  
3632 3632 1993-03-11 United Aviation Services, Inc. 1987-05-26 PANAMA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3606 3606 1993-03-11 Air Afrique 1987-05-26 SENEGAL Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       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  
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  
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  

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 738.316ms · 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