FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Foreign_Principal_Termination_Date" is on date 1993-04-30 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date
Foreign_Principal 9
- Association for an International Securities Exchange Curacao 1
- Bundesverband der Deutschen Industrie e.V. Federation of German Industries 1
- Curacao, Inc. 1
- Ethiopian Medhin Democratic Party 1
- Fokker Aircraft, B.V. 1
- Grand Duchy of Luxembourg - Luxembourg Board of Economic Development 1
- Samancor Foundation 1
- Social Democratic Front 1
- Welsh Development International 1
Country/Location_Represented 8
- CURACAO 2
- CAMEROON 1
- ETHIOPIA 1
- GERMANY 1
- GREAT BRITAIN 1
- LUXEMBOURG 1
- NETHERLANDS 1
- SOUTH AFRICA 1
Registrant_Name 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5932 | 5932 | 1993-04-30 | Association for an International Securities Exchange Curacao | 1992-08-19 | CURACAO | Kuett & Company, Inc. 4491 | 1991-04-01 | Kuett & Company, Inc. | Curacao | ||||
5933 | 5933 | 1993-04-30 | Bundesverband der Deutschen Industrie e.V. Federation of German Industries | 1989-09-15 | GERMANY | Baker Botts L.L.P. 4293 | 1989-09-15 | Baker Botts L.L.P. | Koln | ||||
5934 | 5934 | 1993-04-30 | Curacao, Inc. | 1991-08-08 | CURACAO | Kuett & Company, Inc. 4491 | 1991-04-01 | Kuett & Company, Inc. | Curacao | ||||
5935 | 5935 | 1993-04-30 | Ethiopian Medhin Democratic Party | 1992-04-17 | ETHIOPIA | North American Medhin Democratic Association 4650 | 1992-04-17 | North American Medhin Democratic Association | Washington | DC | |||
5936 | 5936 | 1993-04-30 | Fokker Aircraft, B.V. | 1992-10-07 | NETHERLANDS | Lee Laino Associates, Inc. 4718 | 1992-10-07 | Lee Laino Associates, Inc. | Amsterdam | ||||
5937 | 5937 | 1993-04-30 | Grand Duchy of Luxembourg - Luxembourg Board of Economic Development | 1991-04-01 | LUXEMBOURG | Kuett & Company, Inc. 4491 | 1991-04-01 | Kuett & Company, Inc. | Consulate, New York | NY | |||
5938 | 5938 | 1993-04-30 | Samancor Foundation | 1992-10-08 | SOUTH AFRICA | Samancor Foundation, U.S.A. 4715 | 1992-10-08 | Samancor Foundation, U.S.A. | Johannesburg | ||||
5939 | 5939 | 1993-04-30 | Social Democratic Front | 1992-10-05 | CAMEROON | Szlavik, Hogan & Miller, Inc. 4716 | 1992-10-05 | Szlavik, Hogan & Miller, Inc. | Bamenda | ||||
5940 | 5940 | 1993-04-30 | Welsh Development International | 1992-08-19 | GREAT BRITAIN | Kuett & Company, Inc. 4491 | 1991-04-01 | Kuett & Company, Inc. | Princeton | NJ |
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]) );