FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where "Foreign_Principal_Termination_Date" is on date 2005-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 26
- Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro 3
- Fiduciaria FID De Turismo Puerto Vallarta 3
- BBVA Bancomer S.A. FID 27 932-3 de 2% sl Hosped 2
- Gobierno del Estado de Michuacan Sector Michuacan 2
- BBVD Bancomer S.A. FID 27 932-3 de 2% sl Hosped 1
- Banco Internacional S.A. FID 489 Fondo Playa Del Carmen 1
- Banco Internacional S.A. FID 489 Fondo Playa Del Carment 1
- Banco Internacional S.A. FID 489 Fondo. Riviera Maya 1
- Batam Industrial Development Authority 1
- Bayern International 1
- Centre National d'Etudes Spatiales 1
- Consejo de Promocion Turistica de Mexico S.A. de C.V. 1
- Consejo de Promocion Turistica de Mexico S.A. de C.V. through Young & Rubicam 1
- Consejo de Promocion Turistica de Mexico S.A. de CV - through Young & Rubicam 1
- Consulate General of Japan in Hong Kong 1
- Corporate Fund Kazakhstan 1
- Federal Republic of Yugoslavia, Embassy 1
- Global Trader International 1
- Gobierno Del Estado De Michuacan Sector Michuacan 1
- Government of Federal Democratic Republic of Ethiopia, Embassy 1
- Government of Trinidad and Tobago (through Ainsley Gill & Associates) 1
- JETRO Japanese External Trade Organization 1
- Jean-Claude Bayou 1
- Republic of Bulgaria 1
- Republic of Somaliland 1
- Sociedade Nacional de Combustiveis de Angola (SONANGOL) /Republic of Angola 1
Registrant_Name 15
- Dinamica Multiple, S.A. 6
- Mediaedge: CIA, LLC 6
- Young & Rubicam, S. de R.L. de C.V. 6
- Squire Patton Boggs, LLP 3
- American Continental Group 1
- American International Development Group, Inc. 1
- Bavarian Office for Trade, Investment, Research and Technology 1
- Brewster/Jory Associates, LLC 1
- Daniel J. Edelman, Inc. 1
- Daniel J. Edelman, Inc. - San Francisco 1
- Hill and Knowlton Strategies, LLC 1
- KWR International, Inc. 1
- Kamber Group 1
- McGuireWoods Consulting, LLC 1
- Paul A. Russo and Associates, Inc. 1
Country/Location_Represented 14
- MEXICO 18
- JAPAN 2
- ANGOLA 1
- BRAZIL 1
- BULGARIA 1
- COTE D'IVOIRE (IVORY COAST) 1
- ETHIOPIA 1
- FRANCE 1
- GERMANY 1
- INDONESIA 1
- KAZAKHSTAN 1
- SOMALI DEMOCRATIC REPUBLIC 1
- TRINIDAD AND TOBAGO 1
- YUGOSLAVIA 1
Registrant_Date 13 ✖
- 2003-12-29 18
- 1969-10-09 3
- 1981-11-10 1
- 1984-11-15 1
- 1996-07-02 1
- 1998-06-03 1
- 2000-09-01 1
- 2001-02-05 1
- 2003-07-28 1
- 2004-03-24 1
- 2004-12-22 1
- 2004-12-28 1
- 2005-07-08 1
City 2
- - 30
- Washington 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16567 | 16567 | 2005-12-31 | Centre National d'Etudes Spatiales | 2003-07-28 | FRANCE | Brewster/Jory Associates, LLC 5569 | 2003-07-28 | Brewster/Jory Associates, LLC | 2 Place Maurice Quentin 75039 Paris CEDEX 01 | ||||
16568 | 16568 | 2005-12-31 | BBVA Bancomer S.A. FID 27 932-3 de 2% sl Hosped | 2005-01-31 | MEXICO | Dinamica Multiple, S.A. 5604 | 2003-12-29 | Dinamica Multiple, S.A. | Paseo de las Gauiotas 12 Seccion Commercial 1, Ixtapa Xihuatanejo | ||||
16569 | 16569 | 2005-12-31 | BBVA Bancomer S.A. FID 27 932-3 de 2% sl Hosped | 2005-01-31 | MEXICO | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | Paseo de las Gauiotas 12 Seccion Commercial 1, Ixtapa Zihuatanejo | ||||
16570 | 16570 | 2005-12-31 | BBVD Bancomer S.A. FID 27 932-3 de 2% sl Hosped | 2005-01-31 | MEXICO | Young & Rubicam, S. de R.L. de C.V. 5603 | 2003-12-29 | Young & Rubicam, S. de R.L. de C.V. | Paseo de las Gauiotas 12 Seccion Commercial 1, Ixtapa Zihuatanejo | ||||
16571 | 16571 | 2005-12-31 | Banco Internacional S.A. FID 489 Fondo Playa Del Carmen | 2005-01-31 | MEXICO | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | Calle 28 S/N M4 C1. Ejido Playa Del Carmen Q. Roo. | ||||
16572 | 16572 | 2005-12-31 | Banco Internacional S.A. FID 489 Fondo Playa Del Carment | 2005-01-31 | MEXICO | Dinamica Multiple, S.A. 5604 | 2003-12-29 | Dinamica Multiple, S.A. | Calle 28 S/N M4 C1. Ejido Playa Del Carmen Q. Roo. | ||||
16573 | 16573 | 2005-12-31 | Banco Internacional S.A. FID 489 Fondo. Riviera Maya | 2005-01-31 | MEXICO | Young & Rubicam, S. de R.L. de C.V. 5603 | 2003-12-29 | Young & Rubicam, S. de R.L. de C.V. | |||||
16574 | 16574 | 2005-12-31 | Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro | 2005-01-31 | MEXICO | Young & Rubicam, S. de R.L. de C.V. 5603 | 2003-12-29 | Young & Rubicam, S. de R.L. de C.V. | Pasteur Norte #4, Centro Historico CP 76000, Queretaro | ||||
16575 | 16575 | 2005-12-31 | Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro | 2005-01-31 | MEXICO | Dinamica Multiple, S.A. 5604 | 2003-12-29 | Dinamica Multiple, S.A. | Pasteur Norte #4, Centro Historico CP 76000, Queretaro | ||||
16576 | 16576 | 2005-12-31 | Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro | 2005-01-31 | MEXICO | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | Pasteur Norte #4, Centro Historico CP 76000, Queretaro | ||||
16577 | 16577 | 2005-12-31 | Batam Industrial Development Authority | 2005-01-21 | INDONESIA | KWR International, Inc. 5119 | 1996-07-02 | KWR International, Inc. | BIDA Building Batam Centre, Batam 29400 | ||||
16578 | 16578 | 2005-12-31 | Bayern International | 2004-08-24 | GERMANY | Bavarian Office for Trade, Investment, Research and Technology 5381 | 2000-09-01 | Bavarian Office for Trade, Investment, Research and Technology | Am Messess 2 | ||||
16579 | 16579 | 2005-12-31 | Consejo de Promocion Turistica de Mexico S.A. de C.V. through Young & Rubicam | 2003-12-29 | MEXICO | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | Mariano Escobede No. 550 Sto. Piso Col. Anzures C.P. 11590, Mexico D.F. Mexico | ||||
16580 | 16580 | 2005-12-31 | Consejo de Promocion Turistica de Mexico S.A. de C.V. | 2003-12-29 | MEXICO | Young & Rubicam, S. de R.L. de C.V. 5603 | 2003-12-29 | Young & Rubicam, S. de R.L. de C.V. | Mariano Escobede No. 550 Sto. Piso Col. Anzures C.P. 11590, Mexico D.F. Mexico | ||||
16581 | 16581 | 2005-12-31 | Consejo de Promocion Turistica de Mexico S.A. de CV - through Young & Rubicam | 2003-12-29 | MEXICO | Dinamica Multiple, S.A. 5604 | 2003-12-29 | Dinamica Multiple, S.A. | Mariano Escobede No. 550 Sto. Piso Col. Anzures C.P. 11590, Mexico D.F. Mexico | ||||
16582 | 16582 | 2005-12-31 | Consulate General of Japan in Hong Kong | 2006-08-14 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 46-47/F, One Exchange Square, 8 Connaught Place, Central | Hong Kong | |||
16583 | 16583 | 2005-12-31 | Corporate Fund Kazakhstan | 2003-06-05 | KAZAKHSTAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 20 Kabanbaya Batira Street, Astana | ||||
16584 | 16584 | 2005-12-31 | Federal Republic of Yugoslavia, Embassy | 1998-06-03 | YUGOSLAVIA | American International Development Group, Inc. 5259 | 1998-06-03 | American International Development Group, Inc. | DC | ||||
16585 | 16585 | 2005-12-31 | Fiduciaria FID De Turismo Puerto Vallarta | 2005-01-31 | MEXICO | Young & Rubicam, S. de R.L. de C.V. 5603 | 2003-12-29 | Young & Rubicam, S. de R.L. de C.V. | FCO Medina Ascenio KM 2.5 Local H8Y10 Zona Las Buorias Puerto Vallarta | ||||
16586 | 16586 | 2005-12-31 | Fiduciaria FID De Turismo Puerto Vallarta | 2005-01-31 | MEXICO | Dinamica Multiple, S.A. 5604 | 2003-12-29 | Dinamica Multiple, S.A. | FCO Medina Ascenio KM 2.5 Local H8Y10 Zona Las Buorias Puerto Vallarta | ||||
16587 | 16587 | 2005-12-31 | Fiduciaria FID De Turismo Puerto Vallarta | 2005-01-31 | MEXICO | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | FCO Medina Ascenio KM 2.5 Local H8Y10 Zona Las Buorias Puerto Vallarta | ||||
16588 | 16588 | 2005-12-31 | Global Trader International | 2005-07-29 | BRAZIL | American Continental Group 5695 | 2005-07-08 | American Continental Group | Rua Helena, 140 2nd Floor | Sao Paulo, SP 04552-050 | |||
16589 | 16589 | 2005-12-31 | Gobierno Del Estado De Michuacan Sector Michuacan | 2005-01-31 | MEXICO | Mediaedge: CIA, LLC 5605 | 2003-12-29 | Mediaedge: CIA, LLC | Av Madero Poniente No. 63 Col. Centro CP 58000 | ||||
16590 | 16590 | 2005-12-31 | Gobierno del Estado de Michuacan Sector Michuacan | 2005-01-31 | MEXICO | Young & Rubicam, S. de R.L. de C.V. 5603 | 2003-12-29 | Young & Rubicam, S. de R.L. de C.V. | Av Madero Poniente No. 63 Col. Centro CP 58000 | ||||
16591 | 16591 | 2005-12-31 | Gobierno del Estado de Michuacan Sector Michuacan | 2005-01-31 | MEXICO | Dinamica Multiple, S.A. 5604 | 2003-12-29 | Dinamica Multiple, S.A. | Av Madero Poniente No. 63 Col. Centro CP 58000 | ||||
16594 | 16594 | 2005-12-31 | JETRO Japanese External Trade Organization | 2004-12-28 | JAPAN | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 235 Pine Street, Suite 1700 San Francisco | CA | |||
16595 | 16595 | 2005-12-31 | Jean-Claude Bayou | 2004-12-22 | COTE D'IVOIRE (IVORY COAST) | Kamber Group 5663 | 2004-12-22 | Kamber Group | Dignite Communication de Cote D'Ivoire 06 BP 2900, Abidjan 06 | ||||
16596 | 16596 | 2005-12-31 | Republic of Bulgaria | 2004-11-05 | BULGARIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 102, G.S. Rakovski Street Sofia, Bulgaria 1040 | ||||
16597 | 16597 | 2005-12-31 | Republic of Somaliland | 2004-03-24 | SOMALI DEMOCRATIC REPUBLIC | Paul A. Russo and Associates, Inc. 5613 | 2004-03-24 | Paul A. Russo and Associates, Inc. | Hargeisa, Somaliland | ||||
16598 | 16598 | 2005-12-31 | Sociedade Nacional de Combustiveis de Angola (SONANGOL) /Republic of Angola | 2002-08-05 | ANGOLA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Av, 1 Congresso do MPLA 8-16 P.O. Box 2426, Luanda | ||||
16592 | 16592 | 2005-12-31 | Government of Federal Democratic Republic of Ethiopia, Embassy | 2005-09-15 | ETHIOPIA | McGuireWoods Consulting, LLC 5408 | 2001-02-05 | McGuireWoods Consulting, LLC | 3506 International Drive, NW | Washington | DC | 20008 | |
16593 | 16593 | 2005-12-31 | Government of Trinidad and Tobago (through Ainsley Gill & Associates) | 2005-09-16 | TRINIDAD AND TOBAGO | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 1627 K Street, NW | #901 | Washington | DC | 20006 |
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]) );