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 = "1996-05-31"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- Autonomous Community of the Basque Country 1
- Cementos Mexicanos, S.A. 1
- Colombia Hemispheric Trade Forum 1
- Embassy of El Salvador 1
- Embassy of South Africa 1
- Government of Angola 1
- Government of Ecuador, Embassy 1
- Government of Qatar, Embassy 1
- Ministry of Commerce & Industrial Development of Mexico 1
- Singapore Tourist Promotion Board 1
- Somali Republic, President Mohammed Farah Aidid 1
Country/Location_Represented 10
- MEXICO 2
- ANGOLA 1
- COLOMBIA 1
- ECUADOR 1
- EL SALVADOR 1
- QATAR 1
- SINGAPORE 1
- SOMALI DEMOCRATIC REPUBLIC 1
- SOUTH AFRICA 1
- SPAIN 1
Registrant_Name 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7149 | 7149 | 1996-05-31 | Autonomous Community of the Basque Country | 1994-11-14 | SPAIN | American Basque Foundation, Inc. 4971 | 1994-11-14 | American Basque Foundation, Inc. | Victoria-Gasteiz | ||||
7150 | 7150 | 1996-05-31 | Cementos Mexicanos, S.A. | 1995-11-17 | MEXICO | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | Monterrey | ||||
7151 | 7151 | 1996-05-31 | Colombia Hemispheric Trade Forum | 1995-12-12 | COLOMBIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Bogota | ||||
7152 | 7152 | 1996-05-31 | Embassy of El Salvador | 1995-11-16 | EL SALVADOR | Shepardson, Stern & Kaminsky 5078 | 1995-11-16 | Shepardson, Stern & Kaminsky | Washington | DC | |||
7153 | 7153 | 1996-05-31 | Embassy of South Africa | 1996-04-24 | SOUTH AFRICA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
7154 | 7154 | 1996-05-31 | Government of Angola | 1995-01-25 | ANGOLA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Luanda | ||||
7155 | 7155 | 1996-05-31 | Government of Ecuador, Embassy | 1994-12-08 | ECUADOR | Petito, Margaret L. 4979 | 1994-12-08 | Petito, Margaret L. | Washington | DC | |||
7156 | 7156 | 1996-05-31 | Government of Qatar, Embassy | 1996-03-29 | QATAR | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
7157 | 7157 | 1996-05-31 | Ministry of Commerce & Industrial Development of Mexico | 1990-12-12 | MEXICO | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | Condesa | ||||
7158 | 7158 | 1996-05-31 | Singapore Tourist Promotion Board | 1994-08-05 | SINGAPORE | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | Beverly Hills | CA | |||
7159 | 7159 | 1996-05-31 | Somali Republic, President Mohammed Farah Aidid | 1996-05-22 | SOMALI DEMOCRATIC REPUBLIC | Gulaid, Ali Hassan 5113 | 1996-05-22 | Gulaid, Ali Hassan | Mogadishu |
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]) );