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

30 rows where Registration_Number = 34

View and edit SQL

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

City

Registrant_Name

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
700 1959-01-01 Arab Information Center 1956-02-03 EGYPT 34 34 1943-03-03 Caples Company New York     NY  
1820 1954-02-01 Swiss National Travel Office 1954-02-12 SWITZERLAND 34 34 1943-03-03 Caples Company New York     NY  
1981 1961-02-03 Associated British & Irish Railway 1943-03-03 GREAT BRITAIN 34 34 1943-03-03 Caples Company London, England        
1982 1961-02-03 British Railways 1950-06-12 GREAT BRITAIN 34 34 1943-03-03 Caples Company London        
1983 1961-02-03 East Africa Tourist Travel Association 1950-05-19 KENYA 34 34 1943-03-03 Caples Company Nairobi        
1984 1961-02-03 Finnair - Aeroo/y 1961-02-03 FINLAND 34 34 1943-03-03 Caples Company Helsinki        
1985 1961-02-03 Fogra Failte (National Tourist Publicity Organization for Ireland 1952-07-21 IRELAND 34 34 1943-03-03 Caples Company Dublin        
1986 1961-02-03 Industrial Development Authority 1958-08-04 IRELAND 34 34 1943-03-03 Caples Company Dublin        
1987 1961-02-03 Japan Tourist Association 1958-08-04 JAPAN 34 34 1943-03-03 Caples Company New York     NY  
1988 1961-02-03 National Railways of Mexico 1943-03-03 MEXICO 34 34 1943-03-03 Caples Company Mexico City        
1989 1961-02-03 Punch 1949-06-27 GREAT BRITAIN 34 34 1943-03-03 Caples Company London, England        
1990 1961-02-03 Scandinavian Travel Commission (Members are: Danish, Finnish, Norwegian & Swedish National Travel Offices) 1957-08-13 DENMARK 34 34 1943-03-03 Caples Company New York     NY  
1991 1961-02-03 South Africa Tourist Corporation 1951-01-31 SOUTH AFRICA 34 34 1943-03-03 Caples Company New York     NY  
1992 1961-02-03 Swedish American Line 1955-01-27 SWEDEN 34 34 1943-03-03 Caples Company Gothenburg        
1993 1961-02-03 Swiss National Travel Office 1955-04-04 SWITZERLAND 34 34 1943-03-03 Caples Company New York     NY  
1994 1961-02-03 Tourist Promotion Board, City of Vienna 1959-02-02 AUSTRIA 34 34 1943-03-03 Caples Company          
1995 1961-02-03 Ulster Transport Authority 1950-06-12 IRELAND 34 34 1943-03-03 Caples Company          
1996 1961-02-03 Yugoslav State Tourist Office 1953-02-10 YUGOSLAVIA 34 34 1943-03-03 Caples Company New York     NY  
3004 1953-03-01 Hotels Executive (British Transport) 1950-06-12 GREAT BRITAIN 34 34 1943-03-03 Caples Company Londgon        
4044 1952-03-31 Argentine Airlines, Fama Service 1950-05-19 ARGENTINA 34 34 1943-03-03 Caples Company Buenos Aires        
4052 1956-03-31 Inverurie Hotel Company, Ltd. (Belmont Manor Hotel) 1953-07-20 BERMUDA 34 34 1943-03-03 Caples Company Warwick        
4053 1956-03-31 Montego Beach Hotel Company, Ltd. 1953-02-10 JAMAICA 34 34 1943-03-03 Caples Company Montego Bay        
4551 1960-04-01 Coras Iompair Eireann (Irish Transport Company) 1950-06-12 IRELAND 34 34 1943-03-03 Caples Company Dublin        
4552 1960-04-01 Government of the Union of South Africa (South Africa Railways) 1954-07-22 SOUTH AFRICA 34 34 1943-03-03 Caples Company New York     NY  
4962 1956-04-15 British West Indian Airways 1955-08-16 TRINIDAD AND TOBAGO 34 34 1943-03-03 Caples Company Port-of-Spain        
7797 1959-06-30 African Car Hire, Ltd. 1952-01-28 SOUTH AFRICA 34 34 1943-03-03 Caples Company Cape Town        
9164 1959-07-31 European Travel Commission 1953-07-20 INTERNATIONAL 34 34 1943-03-03 Caples Company New York     NY  
14802 1955-12-31 Mexican Government Tourist Bureau 1954-07-22 MEXICO 34 34 1943-03-03 Caples Company          
14841 1959-12-31 Aerlinte Eireann Teoranta (Irish Airlines) 1958-08-04 IRELAND 34 34 1943-03-03 Caples Company     Dublin    
14846 1959-12-31 Shannon Free Airport Development Authority 1958-08-04 IRELAND 34 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)
);
Powered by Datasette · Query took 167.781ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history