FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where "Foreign_Principal_Registration_Date" is on date 2005-01-31 sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Registrant_Date (date)
Foreign_Principal 13
- 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
- Embassy of the Republic of Turkey 1
- Gobierno Del Estado De Michuacan Sector Michuacan 1
- Government of Malaysia (through the Alexander Strategy Group) 1
- Government of the Dominican Republic 1
- Government of the Republic of the Marshall Islands, Embassy (through the Alexander Strategy Group) 1
Registrant_Name 5
Foreign_Principal_Termination_Date (date) 5 ✖
- 2005-12-31 15
- 2005-02-28 1
- 2005-10-31 1
- 2006-12-31 1
- 2007-07-31 1
Country/Location_Represented 5
- MEXICO 15
- DOMINICAN REPUBLIC 1
- MALAYSIA 1
- MARSHALL ISLANDS 1
- TURKEY 1
City 1
- - 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3066 | 3066 | 2005-02-28 | Government of Malaysia (through the Alexander Strategy Group) | 2005-01-31 | MALAYSIA | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | Baskerville House 13 Duddell Street, Suite 401 Central Hong Kong | ||||
9872 | 9872 | 2007-07-31 | Embassy of the Republic of Turkey | 2005-01-31 | TURKEY | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 2525 Massachusetts Avenue, NW 20008 | DC | |||
13423 | 13423 | 2005-10-31 | Government of the Republic of the Marshall Islands, Embassy (through the Alexander Strategy Group) | 2005-01-31 | MARSHALL ISLANDS | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 2433 Massachusetts Avenue, NW 20008 | DC | |||
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 | ||||
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 | ||||
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 | ||||
16602 | 16602 | 2006-12-31 | Government of the Dominican Republic | 2005-01-31 | DOMINICAN REPUBLIC | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | Palacio Nacional Santo Domingo, R.D. |
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]) );