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

24 rows where Foreign_Principal = "Intourist"

View and edit SQL

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

Country/Location_Represented

City

Foreign_Principal

  • 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
2650 1960-02-26 Intourist 1959-08-17 USSR 1253 1253 1959-08-17 Ask Mr. Foster Travel Service, Inc. Moscow        
3025 1960-03-01 Intourist 1958-03-05 USSR 1120 1120 1958-03-05 Paul Tausig & Son, Inc. Moscow        
3294 1960-03-07 Intourist 1959-11-16 USSR 1297 1297 1959-11-16 Poly Travel, Inc.          
3616 1960-03-17 Intourist 1959-09-17 USSR 1271 1271 1959-09-17 National Travel Company, Inc. Moscow        
3808 1960-03-25 Intourist 1959-09-25 USSR 1274 1274 1959-09-25 Safaritours, Inc. Moscow        
3809 1960-03-25 Intourist 1959-09-25 USSR 1275 1275 1959-09-25 Chase Travel Service Moscow        
3883 1960-03-28 Intourist 1957-03-29 USSR 1014 1014 1957-03-29 Lanseair Travel Service, Inc. Moscow        
3962 1993-03-30 Intourist 1949-11-07 RUSSIA 596 596 1949-11-07 Amtorg Trading Corporation Moscow        
4990 1958-04-15 Intourist 1957-11-12 USSR 1085 1085 1957-11-12 Dundes & Frank, Inc. Moscow        
5222 1987-04-24 Intourist 1959-07-10 USSR 1246 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. Moscow        
6027 1960-05-06 Intourist 1958-04-11 USSR 1130 1130 1958-04-11 American Travel Abroad, Inc. Moscow        
7166 1987-06-03 Intourist 1984-08-16 USSR 1803 1803 1964-10-19 Modern Education Services, Inc.          
7714 1974-06-26 Intourist 1974-06-26 USSR 2462 2462 1973-10-01 Davis Public Relations, Inc. New York     NY  
8747 1951-07-11 Intourist 1950-01-11 USSR 605 605 1950-01-11 Family Export & Shipping Company, Inc. Moscow        
9772 1960-08-09 Intourist 1955-11-07 USSR 918 918 1955-11-07 Cosmos Travel Bureau, Inc. Moscow        
10248 1959-08-25 Intourist 1957-02-25 USSR 1003 1003 1957-02-25 Maupintour Associates Moscow        
10828 1983-09-02 Intourist 1980-01-29 USSR 1803 1803 1964-10-19 Modern Education Services, Inc.          
11251 1960-09-22 Intourist 1958-04-17 USSR 1133 1133 1958-04-21 Whitbey-Rehbock Advertising, Inc. 49 West 37 Street   New York NY  
12182 1959-10-16 Intourist 1959-04-16 RUSSIA 1218 1218 1959-04-16 University Travel Company Moscow        
12468 1959-10-27 Intourist 1959-10-27 USSR 1289 1289 1959-10-27 Marquis, Sarah Moscow        
12513 1993-10-28 Intourist 1961-03-28 RUSSIA 1436 1436 1961-03-28 Wolf Shevack, Inc.       NY  
13556 1960-11-23 Intourist 1959-05-14 USSR 1229 1229 1959-05-14 American Tourist Bureau, Inc., New York Moscow        
14002 1974-12-01 Intourist 1974-09-16 USSR 2520 2520 1974-06-19 Public Relations Board, Inc. New York     NY  
14208 1959-12-07 Intourist 1959-12-07 USSR 1305 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)
);
Powered by Datasette · Query took 163.817ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history