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

51 rows where Registrant_Name = "GCI Group, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • Canon Europa 2
  • Boehringer Ingelheim GmbH 1
  • British Airways 1
  • British Tourist Authority 1
  • Brunswick, Ltd. 1
  • Cancun Hotel Association 1
  • China External Trade Development Council (CETRA) 1
  • Cineplex Odeon Corporation 1
  • Cisneros Group of Companies Highgate Properties, Inc. 1
  • Domtar, Inc. 1
  • Elscint, Inc. 1
  • Expo '95 1
  • Fiesta Americana Hotels 1
  • Flota Mercante Grancolombiana, S.A. 1
  • Government of Israel 1
  • Government of Jamaica, Office of the Prime Minister 1
  • Government of the British Virgin Islands 1
  • Hellenic Export Promotion Organization 1
  • Holiday Inn 1
  • Hong Kong Government 1
  • Hong Kong Trade Development Council 1
  • Invest Northern Ireland 1
  • Israel Export Institute 1
  • Israel Ministry of Tourism 1
  • Italian Trade Commission 1
  • Jamaica Tourist Board 1
  • Jewelry of Israel/Israel Export Institute 1
  • London Docklands Development Corporation 1
  • MC Shipping, Inc. 1
  • MFC Bancorp 1
  • …

Country/Location_Represented 26

  • ISRAEL 6
  • CANADA 5
  • GREAT BRITAIN 5
  • MEXICO 5
  • HONG KONG 4
  • JAMAICA 4
  • TAIWAN 3
  • AUSTRIA 1
  • BRITISH VIRGIN ISLANDS 1
  • CAYMAN ISLANDS 1
  • COLOMBIA 1
  • GERMANY 1
  • GREECE 1
  • INTERNATIONAL 1
  • IRELAND 1
  • ITALY 1
  • JAPAN 1
  • MONACO 1
  • NETHERLANDS 1
  • NETHERLANDS ANTILLES 1
  • NORTHERN IRELAND 1
  • NORWAY 1
  • PHILIPPINES 1
  • RUSSIA 1
  • SWITZERLAND 1
  • TURKEY 1

State 3

  • - 42
  • NY 8
  • IL 1

Registrant_Name 1

  • GCI Group, Inc. · 51 ✖

City 1

  • - 51
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
904 904 1991-01-01 Canon Europa 1990-08-03 SWITZERLAND GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Zurich        
905 905 1991-01-01 Canon Europa 1989-09-07 NETHERLANDS GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Amstelveen        
1309 1309 1992-01-15 Holiday Inn 1991-08-12 MEXICO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc.          
1315 1315 1996-01-15 London Docklands Development Corporation 1996-02-20 GREAT BRITAIN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. London        
1316 1316 1996-01-15 Tee-Comm Electronics 1995-08-30 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Milton, Ontario        
1450 1450 1995-01-23 Elscint, Inc. 1992-05-21 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Haifa        
1467 1467 1992-01-24 Taiwan-Government Information Office of Republic of China 1989-09-07 TAIWAN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
1742 1742 1992-01-31 Sectur/Mexico a Work of Art 1991-01-31 MEXICO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc.          
2004 2004 1989-02-01 Jewelry of Israel/Israel Export Institute 1988-04-08 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Tel-Aviv        
2008 2008 1991-02-01 Expo '95 1990-02-12 AUSTRIA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Vienna        
2563 2563 1994-02-16 Fiesta Americana Hotels 1990-08-03 MEXICO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Reforma Lomas        
2564 2564 1994-02-16 Premium Financial Company (Enchanted Garden) 1992-07-23 JAMAICA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Kingston        
2565 2565 1994-02-16 Trinity Biotech plc 1993-05-11 IRELAND GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Dublin        
2671 2671 1992-02-22 Government of Israel 1992-01-09 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
3124 3124 2000-02-29 Nokia/ aka: Vienna Systems 1999-02-23 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Kanata, Ontario        
4173 4173 1996-03-30 Hong Kong Government 1993-05-11 HONG KONG GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
4433 4433 1990-03-31 Government of Jamaica, Office of the Prime Minister 1986-07-11 JAMAICA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Kingston        
4581 4581 2004-03-31 Invest Northern Ireland 2001-08-10 NORTHERN IRELAND GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Industrial Development Board for Northern Ireland Corporate Headquarters 64 Chichester St. Belfast B        
5817 5817 1992-04-30 MC Shipping, Inc. 1990-02-12 MONACO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Monte Carlo        
7000 7000 1989-05-31 Jamaica Tourist Board 1986-07-11 JAMAICA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Kingston        
7009 7009 1990-05-31 Flota Mercante Grancolombiana, S.A. 1988-04-08 COLOMBIA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Bogota        
7101 7101 1999-05-31 Cisneros Group of Companies Highgate Properties, Inc. 1999-02-23 INTERNATIONAL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
8352 8352 1988-06-30 National Hotels & Properties, Ltd. 1988-04-08 JAMAICA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Kingston        
8363 8363 1989-06-30 Israel Ministry of Tourism 1989-04-18 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
8407 8407 1991-06-30 Nagase Kenko Corporation 1991-01-31 JAPAN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Tokyo        
8419 8419 1992-06-30 China External Trade Development Council (CETRA) 1992-03-05 TAIWAN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Taipei        
9104 9104 2000-07-11 Boehringer Ingelheim GmbH 1999-02-23 GERMANY GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc.          
9105 9105 2000-07-11 British Airways 1999-08-11 GREAT BRITAIN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Waterside (HCB3) P.O. Box 365 Harmondsworth, Middlesex UB7 OGB        
9106 9106 2000-07-11 MFC Bancorp 2000-02-15 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 1250 - 400 Burrard Street Vancouver, British Columbia V6C3AC        
9219 9219 1989-07-16 Hellenic Export Promotion Organization 1988-04-08 GREECE GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Athens        
9746 9746 2000-07-31 Scottish Annuity & Life Holdings, Ltd. 1999-06-02 CAYMAN ISLANDS GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Grand Pavillion Commercial Centre 802 West Bay Road Grand Cayman, Cayman Island        
9936 9936 1994-08-01 Republic of the Philippines 1993-04-16 PHILIPPINES GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Manila        
10972 10972 1998-08-31 Macronix International 1997-03-10 TAIWAN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Hsinchu        
10973 10973 1998-08-31 Physical Health Center Hong Kong, Ltd. 1997-09-25 HONG KONG GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Causeway Bay        
10984 10984 2001-08-31 Government of the British Virgin Islands 1995-08-25 BRITISH VIRGIN ISLANDS GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Tortola        
11000 11000 2004-08-31 Italian Trade Commission 2004-01-13 ITALY GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 401 N. Michigan Avenue, Suite 3030 Chicago 60611     IL  
11991 11991 1996-09-30 Scitex Corporation 1997-03-10 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Herzlia        
11998 11998 1998-09-30 Brunswick, Ltd. 1995-08-25 GREAT BRITAIN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. London        
12029 12029 2001-09-30 British Tourist Authority 2001-08-10 GREAT BRITAIN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Thames Tower Black's Road London, W6 9EL        
12073 12073 2005-09-30 United Kingdom Trade & Investment 2005-03-01 GREAT BRITAIN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 845 Third Avenue New York 10022     NY  
13161 13161 1989-10-31 Israel Export Institute 1988-10-04 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Tel Aviv        
15323 15323 1990-12-28 Cancun Hotel Association 1990-08-03 MEXICO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Cancun        
15381 15381 1990-12-30 Mexico - Secretary of Tourism 1989-09-07 MEXICO GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Hidalgo        
16014 16014 1989-12-31 Hong Kong Trade Development Council 1989-09-07 HONG KONG GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
16130 16130 1992-12-31 Norsk Hydro, A.S. 1990-02-12 NORWAY GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Stabekk        
16131 16131 1992-12-31 Quincentennial Foundation of Istanbul 1990-02-12 TURKEY GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Istanbul        
16249 16249 1995-12-31 Most Group 1995-02-23 RUSSIA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Moscow        
16270 16270 1996-12-31 Cineplex Odeon Corporation 1996-09-06 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Toronto, Onatrio        
16273 16273 1996-12-31 Domtar, Inc. 1996-02-20 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Montreal, Quebec        
16318 16318 1997-12-31 Sealand Housing Corporation 1997-09-25 HONG KONG GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Central        
16431 16431 2003-12-31 Netherlands Foreign Investment Agency 2002-08-12 NETHERLANDS ANTILLES GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. One Rockefeller Plaza 10020     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 146.703ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history