FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Country/Location_Represented = "JAPAN" and Foreign_Principal = "Japan Iron & Steel Exporters' Association" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 10
Foreign_Principal 1
- Japan Iron & Steel Exporters' Association · 10 ✖
Country/Location_Represented 1
- JAPAN · 10 ✖
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12337 | 12337 | 1983-10-01 | Japan Iron & Steel Exporters' Association | 1978-05-15 | JAPAN | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | |||||
12768 | 12768 | 1985-10-16 | Japan Iron & Steel Exporters' Association | 1983-09-02 | JAPAN | Wald, Harkrader & Ross 3241 | 1981-05-10 | Wald, Harkrader & Ross | |||||
1196 | 1196 | 2010-01-10 | Japan Iron & Steel Exporters' Association | 1983-12-29 | JAPAN | Charles E. Butler & Associates 3544 | 1983-12-29 | Charles E. Butler & Associates | Tokyo | ||||
4456 | 4456 | 1989-03-31 | Japan Iron & Steel Exporters' Association | 1986-01-13 | JAPAN | Whitehouse Associates, Inc. 2190 | 1970-02-24 | Whitehouse Associates, Inc. | Tokyo | ||||
5121 | 5121 | 2002-04-09 | Japan Iron & Steel Exporters' Association | 1980-10-09 | JAPAN | Japan Iron & Steel Federation 3155 | 1980-10-09 | Japan Iron & Steel Federation | Tokyo | ||||
8352 | 8352 | 1983-06-30 | Japan Iron & Steel Exporters' Association | 1966-03-21 | JAPAN | Arter, Hadden & Hemmendinger 1001 | 1957-02-21 | Arter, Hadden & Hemmendinger | Tokyo | ||||
10631 | 10631 | 1998-08-20 | Japan Iron & Steel Exporters' Association | 1985-12-26 | JAPAN | Willkie, Farr & Gallagher 3765 | 1985-12-26 | Willkie, Farr & Gallagher | Tokyo | ||||
16088 | 16088 | 1989-12-31 | Japan Iron & Steel Exporters' Association | 1989-04-19 | JAPAN | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | Tokyo | ||||
16243 | 16243 | 1993-12-31 | Japan Iron & Steel Exporters' Association | 1993-06-25 | JAPAN | Crandall, Robert W. 4823 | 1993-06-25 | Crandall, Robert W. | Tokyo | ||||
3660 | 3660 | 1985-03-12 | Japan Iron & Steel Exporters' Association | 1984-04-27 | JAPAN | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | Washington | DC |
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]) );