FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Foreign_Principal_Termination_Date = "1993-11-30" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- Aiphone Corporation 1
- Altus Finance 1
- Coalition for Safe Ceramicware 1
- Commission of the European Communities 1
- Embassy of Lithuania 1
- Fokker-VFW International 1
- International Crystal Federation 1
- Office of the President of Kazakhstan 1
- Office of the President of Ukraine 1
- SEMAICO, Ltd. 1
- Southern Ethiopia People's Democratic Coalition 1
Country/Location_Represented 9
- INTERNATIONAL 3
- ETHIOPIA 1
- FRANCE 1
- JAPAN 1
- KAZAKHSTAN 1
- LITHUANIA 1
- NETHERLANDS 1
- THAILAND 1
- UKRAINE 1
Registrant_Name 8
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14447 | 14447 | 1993-11-30 | SEMAICO, Ltd. | 1990-09-06 | THAILAND | AbramsonEhrlichManes, Inc. 3103 | 1980-04-30 | AbramsonEhrlichManes, Inc. | Bangkok | ||||
14446 | 14446 | 1993-11-30 | Office of the President of Ukraine | 1993-05-21 | UKRAINE | P/C Advisors, Inc. 4806 | 1993-05-21 | P/C Advisors, Inc. | Kiev | ||||
14445 | 14445 | 1993-11-30 | Office of the President of Kazakhstan | 1993-08-31 | KAZAKHSTAN | P/C Advisors, Inc. 4806 | 1993-05-21 | P/C Advisors, Inc. | Alma Ata | ||||
14444 | 14444 | 1993-11-30 | International Crystal Federation | 1993-04-12 | INTERNATIONAL | Albertine Enterprises, Inc. 4793 | 1993-04-12 | Albertine Enterprises, Inc. | Warwick | RI | |||
14443 | 14443 | 1993-11-30 | Fokker-VFW International | 1986-08-11 | NETHERLANDS | AbramsonEhrlichManes, Inc. 3103 | 1980-04-30 | AbramsonEhrlichManes, Inc. | Amsterdam | ||||
14442 | 14442 | 1993-11-30 | Embassy of Lithuania | 1991-11-13 | LITHUANIA | Kelley, Ziba Jurenaite 4620 | 1991-11-13 | Kelley, Ziba Jurenaite | Washington | DC | |||
14441 | 14441 | 1993-11-30 | Commission of the European Communities | 1993-06-25 | INTERNATIONAL | TransAtlantic Futures, Inc. 4353 | 1990-03-16 | TransAtlantic Futures, Inc. | Brussels | ||||
14440 | 14440 | 1993-11-30 | Coalition for Safe Ceramicware | 1993-04-12 | INTERNATIONAL | Albertine Enterprises, Inc. 4793 | 1993-04-12 | Albertine Enterprises, Inc. | Washington | DC | |||
14439 | 14439 | 1993-11-30 | Altus Finance | 1991-08-09 | FRANCE | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Paris | ||||
14438 | 14438 | 1993-11-30 | Aiphone Corporation | 1992-06-29 | JAPAN | Rockey Company, Inc. 4594 | 1991-11-14 | Rockey Company, Inc. | Bellevue | WA | |||
14437 | 14437 | 1993-11-30 | Southern Ethiopia People's Democratic Coalition | 1993-11-10 | ETHIOPIA | DeBello, Yirgu Megerssa 4868 | 1993-11-10 | DeBello, Yirgu Megerssa | Addis Ababa |
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]) );