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

16 rows where Registrant_Name = "West Glen Communications" and State = "NY"

✎ 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 1

Registrant_Name 1

  • West Glen Communications · 16 ✖

City 1

  • - 16
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
2222 2222 1993-02-05 Lufthansa German Airlines 1988-11-23 GERMANY West Glen Communications 4191 1988-11-23 West Glen Communications East Meadow     NY  
6752 6752 1997-05-23 Barbados Board of Tourism 1988-11-23 BARBADOS West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
7077 7077 1990-05-31 Czechoslovak Travel Bureau 1988-11-23 CZECHOSLOVAKIA West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
7082 7082 1990-05-31 Norwegian Tourist Board 1988-11-23 NORWAY West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
7100 7100 1991-05-31 Eurail Pass C/O French Rail, Inc. - Mr. Dagobert Scher 1991-04-08 FRANCE West Glen Communications 4191 1988-11-23 West Glen Communications White Plains     NY  
8465 8465 1990-06-30 Scandinavian Tourist Board 1988-11-23 INTERNATIONAL West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
8515 8515 1994-06-30 Belgian Tourist Office 1993-08-30 BELGIUM West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
9803 9803 1994-07-31 Finnish Tourist Board 1988-11-23 FINLAND West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
12056 12056 1994-09-30 Japan Airlines 1988-11-23 JAPAN West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
13368 13368 1997-10-31 Israeli Government Tourist Office 1988-11-23 ISRAEL West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
13906 13906 1992-11-12 Danish Tourist Board 1988-11-23 DENMARK West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
13908 13908 1992-11-12 Swedish Tourist Board 1988-11-23 SWEDEN West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
14200 14200 2003-11-23 German Information Center 1988-11-23 GERMANY West Glen Communications 4191 1988-11-23 West Glen Communications       NY  
14448 14448 1994-11-30 Iceland Tourist Board 1988-11-23 ICELAND West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
14460 14460 1995-11-30 Swiss National Tourist Board 1988-11-23 SWITZERLAND West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
16462 16462 1999-12-31 Hong Kong Tourism Associates 1999-02-01 HONG KONG West Glen Communications 4191 1988-11-23 West Glen Communications 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])
);