FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Country/Location_Represented = "JAPAN" and Foreign_Principal_Termination_Date = "1990-03-31"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
- Bank of Japan, New York Representative Office 1
- Central Union of Agricultural Cooperatives (ZENCHU) 1
- Consulate General of Japan 1
- Fasteners Institute of Japan 1
- Government of Japan 1
- Hyogo Prefectural Government 1
- Industrial Bank of Japan, Ltd. 1
- Mitsubishi Motors Corporation 1
- Nomura Research Institute 1
Registrant_Name 6
Country/Location_Represented 1
- JAPAN · 9 ✖
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4474 | 4474 | 1990-03-31 | Bank of Japan, New York Representative Office | 1978-09-21 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | New York | NY | |||
4477 | 4477 | 1990-03-31 | Central Union of Agricultural Cooperatives (ZENCHU) | 1987-01-08 | JAPAN | Donald G. Lerch, Jr. & Company, Inc. 2089 | 1968-04-22 | Donald G. Lerch, Jr. & Company, Inc. | |||||
4480 | 4480 | 1990-03-31 | Consulate General of Japan | 1987-09-09 | JAPAN | Michael Klepper Associates, Inc. 3128 | 1980-08-04 | Michael Klepper Associates, Inc. | New York | NY | |||
4483 | 4483 | 1990-03-31 | Fasteners Institute of Japan | 1989-11-15 | JAPAN | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | Toyko | ||||
4486 | 4486 | 1990-03-31 | Government of Japan | 1978-05-04 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | Washington | DC | |||
4487 | 4487 | 1990-03-31 | Hyogo Prefectural Government | 1987-12-24 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Kobe City | ||||
4488 | 4488 | 1990-03-31 | Industrial Bank of Japan, Ltd. | 1979-09-28 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | New York | NY | |||
4491 | 4491 | 1990-03-31 | Mitsubishi Motors Corporation | 1987-10-05 | JAPAN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Tokyo | ||||
4492 | 4492 | 1990-03-31 | Nomura Research Institute | 1984-05-08 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | Kanagawa Prefecture |
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]) );