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

8 rows where Registration_Number = 94

View and edit SQL

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

State

  • 8

City

  • 8
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
2436 1959-02-16 China Reconstructs 1958-12-23 CHINA 94 94 1942-08-12 Four Continent Book Corporation Peking        
4183 1983-03-31 ARS Polona-Ruch 1978-03-14 POLAND 94 94 1942-08-12 Four Continent Book Corporation Warsaw        
4184 1983-03-31 Artia 1978-03-14 CZECHOSLOVAKIA 94 94 1942-08-12 Four Continent Book Corporation Prague        
4578 1943-04-01 All-Union Combine Mezhdunarodnaya Kniga 1942-08-12 RUSSIA 94 94 1942-08-12 Four Continent Book Corporation Moscow        
7872 1962-06-30 W.F.T.U. Publications, Ltd. 1952-05-09 GREAT BRITAIN 94 94 1942-08-12 Four Continent Book Corporation London        
14913 1955-12-31 People's China - Hong Kong Distribution Office 1952-06-10 CHINA 94 94 1942-08-12 Four Continent Book Corporation Kowloon        
15005 1964-12-31 Verlag (Zeit im Bild) 1957-01-10 GERMANY, FEDERAL REPUBLIC OF 94 94 1942-08-12 Four Continent Book Corporation Dresden        
15022 1966-12-31 Kultura Hungarian Trading Company for Books and Newspapers 1953-04-14 HUNGARY 94 94 1942-08-12 Four Continent Book Corporation Budapest        

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 164.373ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history