FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
216 rows where Registration_Number = 3385
This data as json, CSV (advanced)
These facets timed out: Registrant_Name
Foreign_Principal_Name 18
- - 132
- INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. 43
- SANWA BANK, LTD. 6
- MITSUBISHI TRUST & BANKING CORPORATION 5
- NIPPON TELEGRAPH & TELEPHONE PUBLIC CORPORATION (NTT) 5
- PR SERVICE COMPANY, LTD. 4
- MITSUBISHI TRUST & BANKING CORPORATION THROUGH INTERNATIONAL 3
- NIPPON TELEGRAPH & TELEPHONE PUBLIC CORPORATION (NTT) THROUG 3
- UNIVERSAL PUBLIC RELATIONS COMPANY, INC. 3
- AEG ELECTROMCOM GMBH 2
- JAPAN FEDERATION OF CONSTRUCTION CONTRACTORS 2
- SANWA BANK, LTD 2
- CENTRAL UNION OF AGRICULTURAL CO-OPERATIVES 1
- INTERNATIONAL PUBLIC RELATINS COMPANY, LTD. SHANDWICK 1
- INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD 1
- INTERNATIONAL PUBLIC RELATIONS, COMPANY, LTD. 1
- NIPPON TELEPGRAPH AND TELEPHONE CORP., THROUGH IPR SHANDWICK 1
- SHIN NIHON KAI SHIMBUN-SAI 1
Document_Type 7
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );