FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Foreign_Principal_Termination_Date" is on date 1991-07-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Registration_Date (date)
Foreign_Principal 12
- Chamber of Mines of South Africa 1
- Companhia de Navegacao Maritima NETUMAR 1
- Embassy of Japan 1
- Embassy of Qatar 1
- Government of Portugal 1
- Japan Aero Engines Corporation/Japan Aircraft Development 1
- Mallory Industries, Inc. 1
- NEC Corporation 1
- Panavia GmbH 1
- President of the Republic of Bulgaria, Zhelyo Zhelev; Director, Agency for IntNatl. Assistance, Petko Simeonov 1
- Republic of Croatia 1
- Shipbuilders' Association of Japan 1
Registrant_Name 10
Country/Location_Represented 9
- JAPAN 4
- BRAZIL 1
- BULGARIA 1
- CANADA 1
- GERMANY 1
- PORTUGAL 1
- QATAR 1
- SOUTH AFRICA 1
- YUGOSLAVIA 1
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9783 | 9783 | 1991-07-31 | Shipbuilders' Association of Japan | 1991-07-29 | JAPAN | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | Tokyo | ||||
9784 | 9784 | 1991-07-31 | Chamber of Mines of South Africa | 1988-04-11 | SOUTH AFRICA | Freedman, Levy, Kroll & Simonds 4117 | 1988-03-15 | Freedman, Levy, Kroll & Simonds | Johannesburg | ||||
9785 | 9785 | 1991-07-31 | Companhia de Navegacao Maritima NETUMAR | 1990-10-05 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Rio de Janeiro | ||||
9786 | 9786 | 1991-07-31 | Embassy of Japan | 1990-09-27 | JAPAN | Davis Wright Tremaine 4382 | 1990-06-05 | Davis Wright Tremaine | Washington | DC | |||
9787 | 9787 | 1991-07-31 | Embassy of Qatar | 1990-09-27 | QATAR | Davis Wright Tremaine 4382 | 1990-06-05 | Davis Wright Tremaine | Washington | DC | |||
9788 | 9788 | 1991-07-31 | Government of Portugal | 1989-09-28 | PORTUGAL | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | Lisboa | ||||
9789 | 9789 | 1991-07-31 | Japan Aero Engines Corporation/Japan Aircraft Development | 1984-09-13 | JAPAN | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | Tokyo | ||||
9790 | 9790 | 1991-07-31 | Mallory Industries, Inc. | 1990-06-13 | CANADA | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | Ontario | ||||
9791 | 9791 | 1991-07-31 | NEC Corporation | 1991-04-02 | JAPAN | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | Tokyo | ||||
9792 | 9792 | 1991-07-31 | Panavia GmbH | 1991-03-04 | GERMANY | Moore, Powell A. 4402 | 1990-07-18 | Moore, Powell A. | Munich | ||||
9793 | 9793 | 1991-07-31 | President of the Republic of Bulgaria, Zhelyo Zhelev; Director, Agency for IntNatl. Assistance, Petko Simeonov | 1991-05-29 | BULGARIA | William D. Harris & Associates, Inc. 4518 | 1991-05-29 | William D. Harris & Associates, Inc. | Sofia | ||||
9794 | 9794 | 1991-07-31 | Republic of Croatia | 1991-01-15 | YUGOSLAVIA | Norman A. Bailey, Inc. 4464 | 1991-01-15 | Norman A. Bailey, Inc. | Visoka |
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]) );