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

30 rows where Registrant_Name = "Caples Company"

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

City 2

Registrant_Name 1

  • Caples Company · 30 ✖
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
780 780 1959-01-01 Arab Information Center 1956-02-03 EGYPT Caples Company 34 1943-03-03 Caples Company New York     NY  
1956 1956 1954-02-01 Swiss National Travel Office 1954-02-12 SWITZERLAND Caples Company 34 1943-03-03 Caples Company New York     NY  
2123 2123 1961-02-03 Associated British & Irish Railway 1943-03-03 GREAT BRITAIN Caples Company 34 1943-03-03 Caples Company London, England        
2124 2124 1961-02-03 British Railways 1950-06-12 GREAT BRITAIN Caples Company 34 1943-03-03 Caples Company London        
2125 2125 1961-02-03 East Africa Tourist Travel Association 1950-05-19 KENYA Caples Company 34 1943-03-03 Caples Company Nairobi        
2126 2126 1961-02-03 Finnair - Aeroo/y 1961-02-03 FINLAND Caples Company 34 1943-03-03 Caples Company Helsinki        
2127 2127 1961-02-03 Fogra Failte (National Tourist Publicity Organization for Ireland 1952-07-21 IRELAND Caples Company 34 1943-03-03 Caples Company Dublin        
2128 2128 1961-02-03 Industrial Development Authority 1958-08-04 IRELAND Caples Company 34 1943-03-03 Caples Company Dublin        
2129 2129 1961-02-03 Japan Tourist Association 1958-08-04 JAPAN Caples Company 34 1943-03-03 Caples Company New York     NY  
2130 2130 1961-02-03 National Railways of Mexico 1943-03-03 MEXICO Caples Company 34 1943-03-03 Caples Company Mexico City        
2131 2131 1961-02-03 Punch 1949-06-27 GREAT BRITAIN Caples Company 34 1943-03-03 Caples Company London, England        
2132 2132 1961-02-03 Scandinavian Travel Commission (Members are: Danish, Finnish, Norwegian & Swedish National Travel Offices) 1957-08-13 DENMARK Caples Company 34 1943-03-03 Caples Company New York     NY  
2133 2133 1961-02-03 South Africa Tourist Corporation 1951-01-31 SOUTH AFRICA Caples Company 34 1943-03-03 Caples Company New York     NY  
2134 2134 1961-02-03 Swedish American Line 1955-01-27 SWEDEN Caples Company 34 1943-03-03 Caples Company Gothenburg        
2135 2135 1961-02-03 Swiss National Travel Office 1955-04-04 SWITZERLAND Caples Company 34 1943-03-03 Caples Company New York     NY  
2136 2136 1961-02-03 Tourist Promotion Board, City of Vienna 1959-02-02 AUSTRIA Caples Company 34 1943-03-03 Caples Company          
2137 2137 1961-02-03 Ulster Transport Authority 1950-06-12 IRELAND Caples Company 34 1943-03-03 Caples Company          
2138 2138 1961-02-03 Yugoslav State Tourist Office 1953-02-10 YUGOSLAVIA Caples Company 34 1943-03-03 Caples Company New York     NY  
3205 3205 1953-03-01 Hotels Executive (British Transport) 1950-06-12 GREAT BRITAIN Caples Company 34 1943-03-03 Caples Company Londgon        
4288 4288 1952-03-31 Argentine Airlines, Fama Service 1950-05-19 ARGENTINA Caples Company 34 1943-03-03 Caples Company Buenos Aires        
4296 4296 1956-03-31 Inverurie Hotel Company, Ltd. (Belmont Manor Hotel) 1953-07-20 BERMUDA Caples Company 34 1943-03-03 Caples Company Warwick        
4297 4297 1956-03-31 Montego Beach Hotel Company, Ltd. 1953-02-10 JAMAICA Caples Company 34 1943-03-03 Caples Company Montego Bay        
4833 4833 1960-04-01 Coras Iompair Eireann (Irish Transport Company) 1950-06-12 IRELAND Caples Company 34 1943-03-03 Caples Company Dublin        
4834 4834 1960-04-01 Government of the Union of South Africa (South Africa Railways) 1954-07-22 SOUTH AFRICA Caples Company 34 1943-03-03 Caples Company New York     NY  
5270 5270 1956-04-15 British West Indian Airways 1955-08-16 TRINIDAD AND TOBAGO Caples Company 34 1943-03-03 Caples Company Port-of-Spain        
8234 8234 1959-06-30 African Car Hire, Ltd. 1952-01-28 SOUTH AFRICA Caples Company 34 1943-03-03 Caples Company Cape Town        
9652 9652 1959-07-31 European Travel Commission 1953-07-20 INTERNATIONAL Caples Company 34 1943-03-03 Caples Company New York     NY  
15551 15551 1955-12-31 Mexican Government Tourist Bureau 1954-07-22 MEXICO Caples Company 34 1943-03-03 Caples Company          
15590 15590 1959-12-31 Aerlinte Eireann Teoranta (Irish Airlines) 1958-08-04 IRELAND Caples Company 34 1943-03-03 Caples Company     Dublin    
15595 15595 1959-12-31 Shannon Free Airport Development Authority 1958-08-04 IRELAND Caples Company 34 1943-03-03 Caples Company          

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