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

Search:

descending

Link	rowid ▼	Foreign_Principal_Termination_Date	Foreign_Principal	Foreign_Principal_Registration_Date	Country/Location_Represented	Registration_Number	Registrant_Date	Registrant_Name	Address_1
2436	2436	1959-02-16	China Reconstructs	1958-12-23	CHINA	94 94	1942-08-12	Four Continent Book Corporation	Peking
4183	4183	1983-03-31	ARS Polona-Ruch	1978-03-14	POLAND	94 94	1942-08-12	Four Continent Book Corporation	Warsaw
4184	4184	1983-03-31	Artia	1978-03-14	CZECHOSLOVAKIA	94 94	1942-08-12	Four Continent Book Corporation	Prague
4578	4578	1943-04-01	All-Union Combine Mezhdunarodnaya Kniga	1942-08-12	RUSSIA	94 94	1942-08-12	Four Continent Book Corporation	Moscow
7872	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	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	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	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

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