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

24 rows where Foreign_Principal = "Intourist"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

Country/Location_Represented 2

City 2

Foreign_Principal 1

  • Intourist · 24 ✖
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
2819 2819 1960-02-26 Intourist 1959-08-17 USSR Ask Mr. Foster Travel Service, Inc. 1253 1959-08-17 Ask Mr. Foster Travel Service, Inc. Moscow        
3215 3215 1960-03-01 Intourist 1958-03-05 USSR Paul Tausig & Son, Inc. 1120 1958-03-05 Paul Tausig & Son, Inc. Moscow        
3494 3494 1960-03-07 Intourist 1959-11-16 USSR Poly Travel, Inc. 1297 1959-11-16 Poly Travel, Inc.          
3833 3833 1960-03-17 Intourist 1959-09-17 USSR National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. Moscow        
4032 4032 1960-03-25 Intourist 1959-09-25 USSR Safaritours, Inc. 1274 1959-09-25 Safaritours, Inc. Moscow        
4033 4033 1960-03-25 Intourist 1959-09-25 USSR Chase Travel Service 1275 1959-09-25 Chase Travel Service Moscow        
4108 4108 1960-03-28 Intourist 1957-03-29 USSR Lanseair Travel Service, Inc. 1014 1957-03-29 Lanseair Travel Service, Inc. Moscow        
4188 4188 1993-03-30 Intourist 1949-11-07 RUSSIA Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation Moscow        
5271 5271 1958-04-15 Intourist 1957-11-12 USSR Dundes & Frank, Inc. 1085 1957-11-12 Dundes & Frank, Inc. Moscow        
5513 5513 1987-04-24 Intourist 1959-07-10 USSR Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. Moscow        
6350 6350 1960-05-06 Intourist 1958-04-11 USSR American Travel Abroad, Inc. 1130 1958-04-11 American Travel Abroad, Inc. Moscow        
7540 7540 1987-06-03 Intourist 1984-08-16 USSR Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
8106 8106 1974-06-26 Intourist 1974-06-26 USSR Davis Public Relations, Inc. 2462 1973-10-01 Davis Public Relations, Inc. New York     NY  
9170 9170 1951-07-11 Intourist 1950-01-11 USSR Family Export & Shipping Company, Inc. 605 1950-01-11 Family Export & Shipping Company, Inc. Moscow        
10230 10230 1960-08-09 Intourist 1955-11-07 USSR Cosmos Travel Bureau, Inc. 918 1955-11-07 Cosmos Travel Bureau, Inc. Moscow        
10724 10724 1959-08-25 Intourist 1957-02-25 USSR Maupintour Associates 1003 1957-02-25 Maupintour Associates Moscow        
11324 11324 1983-09-02 Intourist 1980-01-29 USSR Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
11760 11760 1960-09-22 Intourist 1958-04-17 USSR Whitbey-Rehbock Advertising, Inc. 1133 1958-04-21 Whitbey-Rehbock Advertising, Inc. 49 West 37 Street   New York NY  
12761 12761 1959-10-16 Intourist 1959-04-16 RUSSIA University Travel Company 1218 1959-04-16 University Travel Company Moscow        
13056 13056 1959-10-27 Intourist 1959-10-27 USSR Marquis, Sarah 1289 1959-10-27 Marquis, Sarah Moscow        
13102 13102 1993-10-28 Intourist 1961-03-28 RUSSIA Wolf Shevack, Inc. 1436 1961-03-28 Wolf Shevack, Inc.       NY  
14181 14181 1960-11-23 Intourist 1959-05-14 USSR American Tourist Bureau, Inc., New York 1229 1959-05-14 American Tourist Bureau, Inc., New York Moscow        
14645 14645 1974-12-01 Intourist 1974-09-16 USSR Public Relations Board, Inc. 2520 1974-06-19 Public Relations Board, Inc. New York     NY  
14861 14861 1959-12-07 Intourist 1959-12-07 USSR Simmons Gateway Tours 1305 1959-12-07 Simmons Gateway Tours          

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