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 2005-06-30 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
- Embassy of the Bolivarian Republic of Venezuela 1
- Government of Australia, Embassy 1
- Government of the Republic of Croatia 1
- Ministry of Commerce, People's Republic of China 1
- Ministry of Economy - El Salvador 1
- Ministry of Foreign Affairs - Chile 1
- Ministry of Foreign Affairs Czech Republic, Embassy 1
- Ministry of Foreign Trade - Arab Republic of Egypt/Alexandria Cotton Exporters Assn. (Alcotexa) 1
- Republique de Cote d'Ivoire 1
- Republique de Cote d'Ivoire, through Quinn Gillespie & Associates 1
- Taipei Economic and Cultural Representative Office (TECRO) 1
- VisitBritain 1
Country/Location_Represented 11
- COTE D'IVOIRE (IVORY COAST) 2
- AUSTRALIA 1
- CHILE 1
- CHINA 1
- CROATIA 1
- CZECHIA 1
- EGYPT 1
- EL SALVADOR 1
- GREAT BRITAIN 1
- TAIWAN 1
- VENEZUELA 1
Registrant_Name 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8644 | 8644 | 2005-06-30 | Embassy of the Bolivarian Republic of Venezuela | 2003-10-21 | VENEZUELA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 1099 30th Street, N.W. 20007 | DC | |||
8645 | 8645 | 2005-06-30 | Government of Australia, Embassy | 2004-01-30 | AUSTRALIA | Weil, Gotshal & Manges LLP 5534 | 2002-12-18 | Weil, Gotshal & Manges LLP | 1601 Massachusetts Avenue, N.W. 20036 | DC | |||
8646 | 8646 | 2005-06-30 | Government of the Republic of Croatia | 2004-01-26 | CROATIA | Baker & Hostetler, LLP 5599 | 2004-01-26 | Baker & Hostetler, LLP | Trg sv. Marka 2 10 000 Zagreb | ||||
8641 | 8641 | 2005-06-30 | Ministry of Commerce, People's Republic of China | 2005-05-23 | CHINA | McDermott Will & Emery, LLP 5686 | 2005-05-23 | McDermott Will & Emery, LLP | No. 2, Dong Chang'an Street, 100731 Beijing | ||||
8647 | 8647 | 2005-06-30 | Ministry of Economy - El Salvador | 2004-01-30 | EL SALVADOR | Weil, Gotshal & Manges LLP 5534 | 2002-12-18 | Weil, Gotshal & Manges LLP | Edificio C-2, 2a Planta Centro de Gobierno, Alameda Juan Pablo II San Salvador | ||||
8648 | 8648 | 2005-06-30 | Ministry of Foreign Affairs - Chile | 2002-12-18 | CHILE | Weil, Gotshal & Manges LLP 5534 | 2002-12-18 | Weil, Gotshal & Manges LLP | Catedral 1158 Piso 3 Santiago | ||||
8649 | 8649 | 2005-06-30 | Ministry of Foreign Affairs Czech Republic, Embassy | 2004-11-01 | CZECHIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 3900 Spring of Freedom Street, N.W. 20008 | DC | |||
8650 | 8650 | 2005-06-30 | Ministry of Foreign Trade - Arab Republic of Egypt/Alexandria Cotton Exporters Assn. (Alcotexa) | 2003-04-29 | EGYPT | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 8 Aldy Street, Cairo, Egypt/12 Mohamed Talaat, Nooman Street, Alexandria, Egypt | ||||
8642 | 8642 | 2005-06-30 | Republique de Cote d'Ivoire | 2004-12-22 | COTE D'IVOIRE (IVORY COAST) | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | Palais de Presidence de la Republique 01 BP 13 54 Abidjan | ||||
8643 | 8643 | 2005-06-30 | Republique de Cote d'Ivoire, through Quinn Gillespie & Associates | 2005-05-11 | COTE D'IVOIRE (IVORY COAST) | Mirijanian, Peter G. 5683 | 2005-05-11 | Mirijanian, Peter G. | Palais de Presidence de la Republique 01 BP 13 54 Abidjan | ||||
8651 | 8651 | 2005-06-30 | Taipei Economic and Cultural Representative Office (TECRO) | 2005-03-01 | TAIWAN | RJI Government Strategies 5671 | 2005-03-01 | RJI Government Strategies | 4201 Wisconsin Avenue, N.W. | DC | |||
8652 | 8652 | 2005-06-30 | VisitBritain | 2004-06-07 | GREAT BRITAIN | Ogilvy Group, Inc. 5626 | 2004-06-07 | Ogilvy Group, Inc. | Thames Tower Blach's Road London, W6 9EL |
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]) );