FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

11 rows where Foreign_Principal_Country = "MEXICO" and Registrant_Name = "Young & Rubicam, S. de R.L. de C.V."

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Registrant_Name

Foreign_Principal_Country 1

  • MEXICO · 11 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
8929 8929 2006-01-30 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   BBVD Bancomer S.A. FID 27 932-3 de 2% sl Hosped MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20060130-2.pdf
8930 8930 2006-01-30 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Banco Internacional S.A. FID 489 Fondo. Riviera Maya MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20060130-4.pdf
8931 8931 2006-01-30 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20060130-1.pdf
8932 8932 2006-01-30 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Fiduciaria FID De Turismo Puerto Vallarta MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20060130-5.pdf
8933 8933 2006-01-30 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Gobierno del Estado de Michuacan Sector Michuacan MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20060130-3.pdf
10063 10063 2005-01-31 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   BBVD Bancomer S.A. FID 27 932-3 de 2% sl Hosped MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20050131-IBEKIC01.pdf
10064 10064 2005-01-31 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Banco Internacional S.A. FID 489 Fondo. Riviera Maya MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20050131-IBEL7T01.pdf
10065 10065 2005-01-31 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20050131-IBEKQT01.pdf
10066 10066 2005-01-31 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Fiduciaria FID De Turismo Puerto Vallarta MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20050131-IBEL1C01.pdf
10067 10067 2005-01-31 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Gobierno del Estado de Michuacan Sector Michuacan MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20050131-IBEK5L01.pdf
134150 134150 2003-12-29 Young & Rubicam, S. de R.L. de C.V. Young & Rubicam, S. de R.L. de C.V. 5603 Exhibit AB   Consejo de Promocion Turistica de Mexico S.A. de C.V. MEXICO https://efile.fara.gov/docs/5603-Exhibit-AB-20031229-HVK5RN03.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);