FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where Foreign_Principal_Name = "FUJITSU, LTD."
This data as json, CSV (advanced)
Registrant_Name 5
Foreign_Principal_Name 1
- FUJITSU, LTD. · 5 ✖
Foreign_Principal_Country 1
- JAPAN 5
Document_Type 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
35453 | 35453 | 1991-04-01 | DANIEL J. EDELMAN, INC. | Daniel J. Edelman, Inc. 3634 | Exhibit AB | FUJITSU, LTD. | JAPAN | https://efile.fara.gov/docs/3634-Exhibit-AB-19910401-D0X1VG06.pdf | |
92111 | 92111 | 1978-09-01 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Exhibit AB | FUJITSU, LTD. | JAPAN | https://efile.fara.gov/docs/1481-Exhibit-AB-19780901-CYE3PM03.pdf | |
93258 | 93258 | 1989-09-01 | FUJITSU, LTD. | Fujitsu, Ltd. 4288 | Exhibit AB | FUJITSU, LTD. | JAPAN | https://efile.fara.gov/docs/4288-Exhibit-AB-19890901-D1KTFW02.pdf | |
104141 | 104141 | 1987-10-01 | MICHAEL SOLOMON ASSOCIATES | Michael Solomon Associates 3923 | Exhibit AB | FUJITSU, LTD. | JAPAN | https://efile.fara.gov/docs/3923-Exhibit-AB-19871001-D182NF02.pdf | |
108689 | 108689 | 1994-10-14 | SITRICK & CO., INC. | Sitrick & Company, Inc. 4967 | Exhibit AB | FUJITSU, LTD. | JAPAN | https://efile.fara.gov/docs/4967-Exhibit-AB-19941014-D6ZGV201.pdf |
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]) );