FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
559 rows where Country/Location_Represented = "MEXICO"
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name
- Union Nacional Sinarquista 37
- Brownstein, Zeidman & Lore 11
- Chapman, DiSalle & Friedman 11
- Burson-Marsteller 10
- Manchester Trade, Inc. 10
- Lewis Company, Ltd. 9
- Manchester Associates, Ltd. 9
- Craighill & Fentress 8
- Saatchi & Saatchi North America, Inc. 7
- TKC International, Inc. 7
- DLA Piper US LLP 6
- Daniel J. Edelman, Inc. 6
- Dinamica Multiple, S.A. 6
- Mediaedge: CIA, LLC 6
- North American Precis Syndicate 6
- Ruder Finn, Inc. 6
- Young & Rubicam, S. de R.L. de C.V. 6
- Crowell & Moring International, Ltd. 5
- Dale Henderson, Inc. 5
- Dancer Fitzgerald Sample, Inc. 5
- Fleishman-Hillard, Inc. 5
- GCI Group, Inc. 5
- Gold & Liebengood, Inc. 5
- Hill and Knowlton Strategies, LLC 5
- Manatt, Phelps & Phillips 5
- O'Connor & Hannan, L.L.P. 5
- Robinsons, Inc. 5
- Arnold & Porter Kaye Scholer, LLP 4
- Cannon Advertising Associates, Inc. 4
- Gibler, Frank 4
- ...
Foreign_Principal
- Mexican National Tourist Council 13
- Government of Mexico 11
- Union Nacional Sinarquista 7
- Aeromexico 6
- Government of Mexico, Embassy 6
- Cemex, S.A. 5
- Mexican Government Tourism Department 4
- Mexican Ministry of Tourism 4
- Vitro, Sociedad Anonima 4
- Bancomer S.A. FID 323667 Promotor De Turismo En Estado De Queretaro 3
- Camara Minera de Mexico 3
- Consejo Nacional de Turismo 3
- Fiduciaria FID De Turismo Puerto Vallarta 3
- Secretaria de Economia 3
- Secretariat of Commerce & Industrial Development of Mexico (SECOFI) 3
- Union Nacional de Productores de Azucar, S.A. de C.V. 3
- Vitrocrisa Cristaleria, S.A. 3
- AHMSA Steel International, Inc. 2
- Aeronaves de Mexico 2
- Autonomous University of Guadalajara 2
- BBVA Bancomer S.A. FID 27 932-3 de 2% sl Hosped 2
- Banco de Mexico 2
- Camara Nacional de la Industria Pesquera 2
- Camara Nacional de la Industria del Vestido 2
- Consejo Empresarial Mexicano para Asuntos Internacionales, A.C. 2
- Consejo de Promocion Turistica de Mexico S.A. de C.V 2
- Constructora Nacional de Carros de Ferrocarril, S.A. 2
- Departamento de Turismo 2
- Departamento de Turismo del Gobierno de Mexico 2
- Dr. Marcos D. Katz 2
- ...
City
- - 545
- Mexico City 4
- Washington 3
- Houston 2
- Juarez 2
- Cuauhtemoc, 1
- Tamaulipas 1
- Washington, DC 1
Country/Location_Represented
- MEXICO · 559 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58 | 58 | Benitez Strategies | 2018-06-26 | MEXICO | 6566 6566 | 2018-06-26 | Felipe Carlos Benitez Rojas | 1015 15th Street, NW | Suite 600 | Washington | DC | 20005 | |
273 | 273 | Government of United Mexican States | 2009-03-09 | MEXICO | 5917 5917 | 2009-03-09 | Kuykendall, Gregory J., PC | Consultoria Juridica Plaza #20, Piso 6 | Col. Centro, Deleg. Cuauhtemoc C.P. 06010 D.F. | Juarez | |||
575 | 575 | Secretaria de Economia | 1998-04-09 | MEXICO | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 50 Fremont Street San Francisco | CA | ||||
576 | 576 | Secretaria de Economia | 2019-05-03 | MEXICO | 5712 5712 | 2005-10-03 | Greenberg Traurig, LLP | Ave Pachuca #189 | Col. Hipodromo Condesa Ciudad de Mexico CP06140 | ||||
649 | 649 | Turismo de Los Cabos | 2017-11-27 | MEXICO | 6492 6492 | 2017-11-27 | MMGY Global, LLC | Lote S Plaza Providencia | Cabo San Lucas | ||||
698 | 698 | 1964-01-01 | Frente Civico Mexicano de Afirmacion Revolucionaria | 1963-03-26 | MEXICO | 1612 1612 | 1963-03-26 | Frente Civico Mexicano de Afirmacion Revolucionaria | |||||
738 | 738 | 1980-01-01 | Instituto Mexicano de Comercio Exterior | 1971-07-12 | MEXICO | 1531 1531 | 1962-04-02 | Samuel E. Stavisky & Associates, Inc. | Mexico City | ||||
749 | 749 | 1982-01-01 | Constructora Nacional de Carros de Ferrocarril, S.A. | 1978-08-29 | MEXICO | 2216 2216 | 1970-10-30 | Berry, Max N. | |||||
792 | 792 | 1987-01-01 | Consejo Empresarial Mexicano para Asuntos Internacionales (CEMAI) | 1985-07-18 | MEXICO | 3705 3705 | 1985-07-18 | GFE, Ltd. | |||||
870 | 870 | 1996-01-01 | CONACEX NORESTE, A.C. | 1994-06-08 | MEXICO | 3736 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
884 | 884 | 1998-01-01 | Ministry of Commerce & Industrial Development of Mexico (SECOFI) | 1996-07-02 | MEXICO | 5118 5118 | 1996-07-02 | Federal Strategies Group, Inc. | Condesa | ||||
1048 | 1048 | 1974-01-08 | Mexico National Tourist Office | 1972-05-30 | MEXICO | 2343 2343 | 1972-05-30 | Richter & Mracky-Bates, Inc. | |||||
1111 | 1111 | 1988-01-11 | Government of Mexico | 1974-02-20 | MEXICO | 1839 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
1132 | 1132 | 1987-01-12 | Estado Chihuahua (State of Chihuahua) | 1986-03-19 | MEXICO | 3800 3800 | 1986-03-19 | Jones, B. Calvin | |||||
1143 | 1143 | 1998-01-12 | ALFA Industries, S.A. | 1986-02-25 | MEXICO | 3500 3500 | 1983-07-12 | Scanlon, Thomas J. | Nuevo Leon | ||||
1211 | 1211 | 1975-01-15 | Mexican National Tourist Council | 1972-01-28 | MEXICO | 2361 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | Mexico City | ||||
1230 | 1230 | 1992-01-15 | Holiday Inn | 1991-08-12 | MEXICO | 3856 3856 | 1986-07-11 | GCI Group, Inc. | |||||
1332 | 1332 | 1982-01-21 | Union Nacional de Productores de Hortalizas | 1979-07-26 | MEXICO | 3085 3085 | 1979-07-26 | Food Business Associates, Inc. | Sinaloa | ||||
1339 | 1339 | 1994-01-21 | Telecommunicaciones Internacionales de Mexico | 1993-06-25 | MEXICO | 3759 3759 | 1985-11-27 | Dewey Ballantine | Mexico City | ||||
1393 | 1393 | 1984-01-25 | Aeronaves de Mexico | 1964-07-10 | MEXICO | 1763 1763 | 1964-06-19 | Lewis Company, Ltd. | |||||
1394 | 1394 | 1984-01-25 | Ferias y Exposiciones Mexicanas, A.C. | 1969-10-02 | MEXICO | 1763 1763 | 1964-06-19 | Lewis Company, Ltd. | |||||
1456 | 1456 | 1946-01-28 | Ezequiel Padilla | 1946-01-28 | MEXICO | 339 339 | 1946-01-28 | Morlet, Manuel Tomas | |||||
1457 | 1457 | 1946-01-28 | Partido Democratico Mexicano, Mexican Democratic Party | 1946-01-28 | MEXICO | 339 339 | 1946-01-28 | Morlet, Manuel Tomas | Mexico City | ||||
1498 | 1498 | 1952-01-30 | Espana Libre | 1947-01-31 | MEXICO | 273 273 | 1944-07-31 | Junta de Cultura Espanola | New York | NY | |||
1499 | 1499 | 1952-01-30 | Espana Nueva Spanish Papper | 1947-01-31 | MEXICO | 273 273 | 1944-07-31 | Junta de Cultura Espanola | |||||
1502 | 1502 | 1952-01-30 | Pedro Martinez | 1947-01-31 | MEXICO | 273 273 | 1944-07-31 | Junta de Cultura Espanola | Tampa | FL | |||
1506 | 1506 | 1952-01-30 | Vicente Esbri Vidal | 1947-01-31 | MEXICO | 273 273 | 1944-07-31 | Junta de Cultura Espanola | |||||
1651 | 1651 | 1992-01-31 | Sectur/Mexico a Work of Art | 1991-01-31 | MEXICO | 3856 3856 | 1986-07-11 | GCI Group, Inc. | |||||
1678 | 1678 | 1996-01-31 | Grupo Domos | 1995-05-08 | MEXICO | 3301 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Garza Garcia | ||||
1700 | 1700 | 1998-01-31 | Office of the President of Mexico | 1995-02-06 | MEXICO | 4953 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | Mexico City | ||||
1789 | 1789 | 2017-01-31 | Consulate General of Mexico | 2016-06-22 | MEXICO | 5932 5932 | 2009-04-24 | Raben Group, LLC | 4507 San Jacinto Street | Houston | TX | 77004 | |
1814 | 1814 | 1943-02-01 | F. Rodriquez Rosa | 1943-03-12 | MEXICO | 77 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
1859 | 1859 | 1978-02-01 | Fondo Nacional de Fomento al Turismo (Fonatur) | 1974-10-09 | MEXICO | 2539 2539 | 1974-10-09 | Dancer Fitzgerald Sample, Inc. | |||||
1866 | 1866 | 1980-02-01 | Constructora Nacional de Carros de Ferrocarril | 1978-03-21 | MEXICO | 2661 2661 | 1976-02-18 | Arent Fox Kintner Plotkin & Kahn, PLLC | |||||
1869 | 1869 | 1980-02-01 | Republic of Mexico (Mexican National Tourist Council) | 1979-10-15 | MEXICO | 1648 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | |||||
1931 | 1931 | 2002-02-01 | PEMEX | 2001-05-23 | MEXICO | 5434 5434 | 2001-05-23 | LPI Consulting, Inc. | Marina Nacional #329 Col. Huasteca, Delegacion Miguel Hidalgo, Codigo Postal 11311, Petroleos Mexica | ||||
1996 | 1996 | 1961-02-03 | National Railways of Mexico | 1943-03-03 | MEXICO | 34 34 | 1943-03-03 | Caples Company | Mexico City | ||||
2036 | 2036 | 1993-02-03 | La Cigarerra Moderna | 1991-08-01 | MEXICO | 4390 4390 | 1990-06-25 | SJS Advanced Strategies, Inc. | |||||
2038 | 2038 | 2006-02-03 | Government of State of Mexico | 2003-12-24 | MEXICO | 3712 3712 | 1985-08-05 | DLA Piper US LLP | Lic. Carlos Rello c/o Continental Outsourcing SA de CV Iglesia 2E - 1205/1206 Tizapan, Del. Alvar | ||||
2050 | 2050 | 1983-02-04 | Asociacion Agricola Local de Productores de Uva de Mesa Local Table Grape Growers Association of Hermosillo, Sonora | 1982-07-09 | MEXICO | 3388 3388 | 1982-07-09 | Farnsworth, Albert M. | Sonora | ||||
2081 | 2081 | 1985-02-05 | Samuel del Villar | 1984-09-17 | MEXICO | 1750 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer, LLP | |||||
2095 | 2095 | 2001-02-05 | Government of Mexico, Embassy | 1998-12-16 | MEXICO | 3712 3712 | 1985-08-05 | DLA Piper US LLP | 1911 Pennsylvania Avenue, N.W | DC | |||
2099 | 2099 | 1952-02-06 | Junta Espanola de Liberacion, Mexico, D.F. | 1944-04-28 | MEXICO | 248 248 | 1944-04-28 | Riera, Pedro Orpi | |||||
2100 | 2100 | 1952-02-06 | Spanish Republican Government in Exile | 1946-11-18 | MEXICO | 248 248 | 1944-04-28 | Riera, Pedro Orpi | |||||
2119 | 2119 | 1983-02-07 | Government of Mexico | 1979-07-11 | MEXICO | 2272 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | |||||
2165 | 2165 | 1947-02-09 | Adelante | 1944-08-09 | MEXICO | 274 274 | 1944-08-09 | Reina, Antonio | |||||
2166 | 2166 | 1947-02-09 | Espana | 1944-08-09 | MEXICO | 274 274 | 1944-08-09 | Reina, Antonio | |||||
2167 | 2167 | 1947-02-09 | Ministerio de Emigracion | 1946-10-09 | MEXICO | 274 274 | 1944-08-09 | Reina, Antonio | |||||
2192 | 2192 | 1993-02-09 | Grupo Empresarial Agricola Mexicano | 1992-10-09 | MEXICO | 4539 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | |||||
2194 | 2194 | 1993-02-09 | SICARTSA | 1991-12-31 | MEXICO | 4149 4149 | 1988-06-22 | Manchester Trade, Inc. | |||||
2218 | 2218 | 1992-02-10 | Banco Nacional de Mexico (Banamex")" | 1991-03-27 | MEXICO | 1839 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Isabel la Catolica | ||||
2276 | 2276 | 1993-02-12 | Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. | 1990-11-06 | MEXICO | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Mexico City | ||||
2316 | 2316 | 2017-02-13 | Government of the State of Jalisco, Office of Communication | 2017-02-08 | MEXICO | 6402 6402 | 2017-02-08 | Wiljan Consulting LLC | Palacio de Gobierno. Av. Corona #31 Col. Centro. | Guadalajara, Jalisco, Mexico. C.P. 44100 | |||
2352 | 2352 | 1994-02-14 | SECOFI (Secretaria de Comercio y Fomento Industrial) C/O Mexican Embassy Free Trade Office | 1991-03-12 | MEXICO | 3700 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Washington | DC | |||
2366 | 2366 | 1996-02-14 | Cemex, S.A. | 1994-06-08 | MEXICO | 3736 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
2384 | 2384 | 1996-02-14 | Vitro, S.A. | 1993-11-01 | MEXICO | 3736 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Garza Garcia | ||||
2433 | 2433 | 2019-02-15 | Government of Mexico | 1991-03-15 | MEXICO | 4486 4486 | 1991-03-15 | Public Strategies Washington, Inc. | Mexico City | ||||
2439 | 2439 | 1960-02-16 | Union Nacional Sinarquista Consejo Nacional | 1946-08-16 | MEXICO | 367 367 | 1946-08-16 | Union Nacional Sinarquista, Inc. | Mexico City | ||||
2451 | 2451 | 1994-02-16 | Fiesta Americana Hotels | 1990-08-03 | MEXICO | 3856 3856 | 1986-07-11 | GCI Group, Inc. | Reforma Lomas | ||||
2456 | 2456 | 1996-02-16 | Camara Nacional de la Industria Pesquera | 1994-02-25 | MEXICO | 3700 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Mexico City | ||||
2457 | 2457 | 1996-02-16 | Camara Nacional de las Industrias (Azucarera y Alcoholera) | 1994-02-25 | MEXICO | 3700 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Mexico City | ||||
2458 | 2458 | 1996-02-16 | Cementos Mexicanos | 1994-02-25 | MEXICO | 3700 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Monterrey | ||||
2480 | 2480 | 1945-02-18 | Section of the Dominican Revolutionary Party in Mexico | 1944-08-18 | MEXICO | 275 275 | 1944-08-18 | Dominican Revolutionary Party/Section of Mayaguez | Habana | ||||
2566 | 2566 | 1962-02-23 | Organizaciones Rebolucionarias Unidas | 1961-02-23 | MEXICO | 1428 1428 | 1961-02-23 | De La Campa, Alberto | |||||
2568 | 2568 | 1967-02-23 | Camara Nacional de la Industria Pesquera | 1960-06-13 | MEXICO | 867 867 | 1955-01-21 | Chapman, DiSalle & Friedman | |||||
2570 | 2570 | 1967-02-23 | Sociedad Mexicana de Credito Industrial, S.A. | 1961-10-16 | MEXICO | 867 867 | 1955-01-21 | Chapman, DiSalle & Friedman | |||||
2606 | 2606 | 1949-02-25 | Union Nacional Sinarquista (National Synarchist Union) | 1942-08-25 | MEXICO | 106 106 | 1942-08-25 | Gross Jr., Frank J. | Mexico City | ||||
2631 | 2631 | 1997-02-25 | Fomento Economico Mexicano, S.A. de C.V. | 1997-02-25 | MEXICO | 5120 5120 | 1996-07-01 | Zemi Communications, L.L.C. | Monterrey | ||||
2665 | 2665 | 1964-02-26 | Amparo Martinez | 1950-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2666 | 2666 | 1964-02-26 | Antonio Calderon Talavera | 1955-11-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2667 | 2667 | 1964-02-26 | Antonio Zermeno | 1955-11-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2668 | 2668 | 1964-02-26 | Bibiano Segura Leon | 1955-11-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2669 | 2669 | 1964-02-26 | Consuelo Sanchez Gonzalez | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2670 | 2670 | 1964-02-26 | David Lomeli Contreras | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2671 | 2671 | 1964-02-26 | Davis Orosco Romo | 1955-11-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2673 | 2673 | 1964-02-26 | Francisco Raul Calderon | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2674 | 2674 | 1964-02-26 | Ignacio Gonzalez Gollaz | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2675 | 2675 | 1964-02-26 | Jaime Delgado Herrera | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2676 | 2676 | 1964-02-26 | Jesus Montenegro Aboytes | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2677 | 2677 | 1964-02-26 | Jose Davalos | 1958-11-30 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2678 | 2678 | 1964-02-26 | Jose Manuel Figueroa | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2679 | 2679 | 1964-02-26 | Jose Resendiz Castaneda | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2680 | 2680 | 1964-02-26 | Jose Sanchez Gonzalez | 1959-05-31 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2681 | 2681 | 1964-02-26 | Josefina Escobedo | 1960-05-31 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2683 | 2683 | 1964-02-26 | Juan Ignacio Padilla | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2684 | 2684 | 1964-02-26 | Leon Aguilar | 1960-05-31 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2685 | 2685 | 1964-02-26 | Leopoldo Martinez | 1960-05-31 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2686 | 2686 | 1964-02-26 | Leovardo Senteno | 1953-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2687 | 2687 | 1964-02-26 | Manuel Galindo Fuentes | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2688 | 2688 | 1964-02-26 | Maria De Jesus Castro De Lomeli | 1955-11-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2689 | 2689 | 1964-02-26 | Ofelia Ramirez | 1961-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2690 | 2690 | 1964-02-26 | Oscar Memdez Napoles | 1955-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2691 | 2691 | 1964-02-26 | Rafael Bernal | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2692 | 2692 | 1964-02-26 | Salvador Zermeno Marques | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2693 | 2693 | 1964-02-26 | Saturnina Zuniga | 1962-05-01 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2694 | 2694 | 1964-02-26 | Union Nacional Sinarquista | 1942-09-14 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2695 | 2695 | 1964-02-26 | Zefrerino Sanchez Hidalgo | 1949-05-02 | MEXICO | 123 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2734 | 2734 | 1946-02-28 | Confederacion Regional Obrera Mexicana | 1942-07-08 | MEXICO | 20 20 | 1942-07-08 | Haberman, Roberto | Mexico City | ||||
2747 | 2747 | 1963-02-28 | Natumex Line (Naviera Turistica Mexicana, S.A.) | 1962-08-23 | MEXICO | 1468 1468 | 1961-08-01 | Geyer & Oswald, Inc. | |||||
2809 | 2809 | 1991-02-28 | Cozumel Trust | 1990-02-15 | MEXICO | 3605 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. |
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) );