FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Termination_Date" is on date 1994-04-29 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 13
- Central Medical Administration of Moscow 1
- Communications Economiques et Sociales 1
- Eltex, Ltd. 1
- Government of Mauritania 1
- Hudson Soft Company 1
- International Foundation for Mother & Child Care 1
- International Organization Open Economy of Eastern Europe 1
- International Telecom Japan, Inc. 1
- Kanematsu U.S.A., Inc. 1
- La Caixa Foundation 1
- Ministry for Protection of the Environment and Natural Resources of the Russian Federation 1
- Ontario-Hydro 1
- Secretaria de Comercio y Fomento Industrial de Mexico (SECOFI) 1
Country/Location_Represented 9
Registrant_Name 8
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5746 | 5746 | 1994-04-29 | Central Medical Administration of Moscow | 1992-11-13 | RUSSIA | Nutter & Harris, Inc. 4635 | 1992-03-18 | Nutter & Harris, Inc. | Moscow | ||||
5747 | 5747 | 1994-04-29 | Communications Economiques et Sociales | 1992-04-28 | FRANCE | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | Paris | ||||
5748 | 5748 | 1994-04-29 | Eltex, Ltd. | 1992-09-21 | BULGARIA | Law Office of Stewart & Stewart 4709 | 1992-09-21 | Law Office of Stewart & Stewart | Sofia | ||||
5749 | 5749 | 1994-04-29 | Government of Mauritania | 1992-09-21 | MAURITANIA | Law Office of Stewart & Stewart 4709 | 1992-09-21 | Law Office of Stewart & Stewart | Washington | DC | |||
5750 | 5750 | 1994-04-29 | Hudson Soft Company | 1992-04-28 | JAPAN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Sapporo | ||||
5751 | 5751 | 1994-04-29 | International Foundation for Mother & Child Care | 1992-03-18 | RUSSIA | Nutter & Harris, Inc. 4635 | 1992-03-18 | Nutter & Harris, Inc. | Moscow | ||||
5752 | 5752 | 1994-04-29 | International Organization Open Economy of Eastern Europe | 1993-10-29 | UKRAINE | Law Office of Stewart & Stewart 4709 | 1992-09-21 | Law Office of Stewart & Stewart | Kiev | ||||
5753 | 5753 | 1994-04-29 | International Telecom Japan, Inc. | 1987-11-05 | JAPAN | Debevoise & Plimpton 3527 | 1983-10-05 | Debevoise & Plimpton | Tokyo | ||||
5754 | 5754 | 1994-04-29 | Kanematsu U.S.A., Inc. | 1993-05-04 | JAPAN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | New York | NY | |||
5755 | 5755 | 1994-04-29 | La Caixa Foundation | 1993-05-04 | SPAIN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Barcelona | ||||
5756 | 5756 | 1994-04-29 | Ministry for Protection of the Environment and Natural Resources of the Russian Federation | 1993-03-26 | RUSSIA | Stroock & Stroock & Lavan 4750 | 1992-09-14 | Stroock & Stroock & Lavan | Moscow | ||||
5757 | 5757 | 1994-04-29 | Ontario-Hydro | 1993-04-02 | CANADA | Reid & Priest 4223 | 1989-03-06 | Reid & Priest | Toronto, Ontario | ||||
5758 | 5758 | 1994-04-29 | Secretaria de Comercio y Fomento Industrial de Mexico (SECOFI) | 1991-09-18 | MEXICO | Valdez, Abelardo L. 4567 | 1991-09-18 | Valdez, Abelardo L. |
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]) );