FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
571 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 >30
- 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, LLC 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 >30
- Mexican National Tourist Council 13
- Government of Mexico 11
- Union Nacional Sinarquista 7
- Aeromexico 6
- Government of Mexico, Embassy 6
- Cemex, S.A. 5
- Embassy of Mexico 4
- 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
- …
City 11
- - 551
- Mexico City 5
- Washington 5
- Houston 2
- Juarez 2
- Cuauhtemoc 1
- Cuauhtemoc, 1
- MEXICO 1
- Tamaulipas 1
- Texcoco 1
- Washington, DC 1
Country/Location_Represented 1
- MEXICO · 571 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135 | 135 | DEACERO S.A.P.I. de .C,V, (DEACERO) | 2022-03-17 | MEXICO | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | ||||||
176 | 176 | Embassy of Mexico | 2022-01-12 | MEXICO | Glassman Enterprises, LLC 7069 | 2022-01-12 | Glassman Enterprises, LLC | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
177 | 177 | Embassy of Mexico | 2021-09-07 | MEXICO | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
297 | 297 | Government of United Mexican States | 2009-03-09 | MEXICO | Kuykendall, Gregory J., PC 5917 | 2009-03-09 | Kuykendall, Gregory J., PC | Consultoria Juridica Plaza #20, Piso 6 | Col. Centro, Deleg. Cuauhtemoc C.P. 06010 D.F. | Juarez | |||
314 | 314 | Government of the United Mexican States | 2021-08-18 | MEXICO | Shadowen, Steve Duane 6993 | 2021-08-18 | Shadowen, Steve Duane | Ave. Juarez #20, Col. Centro, CP 06010, Del., Centro, CP | 06010, Del. Cuauhtemoc | Mexico City | |||
315 | 315 | Government of the United Mexican States | 2022-10-05 | MEXICO | Global Action on Gun Violence (GAGV) Inc. 7175 | 2022-10-05 | Global Action on Gun Violence (GAGV) Inc. | Ave. Juarez #20, Colonia Centro Mexico City, Del. | Cuauhtemoc | ||||
346 | 346 | International Maize and Wheat Improvement Center (CIMMYT) | 2022-05-13 | MEXICO | Ecospherics, LLC 7119 | 2022-05-13 | Ecospherics, LLC | 45 Carretera Mexico-Veracruz | El Batan | Texcoco | |||
438 | 438 | Los Cabos Tourism Board, a.k.a. Fideicomiso de Turismo de los Cabos (FITURCA) | 2022-01-06 | MEXICO | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | CARRETERA TRANSPENINSULAR KM. 4.3, FRACCION I LOTE 5 | PLAZA PROVIDENCIA, LOCAL 209-210 | MEXICO | 23454 | ||
625 | 625 | Secretaria de Economia | 1998-04-09 | MEXICO | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 50 Fremont Street San Francisco | CA | ||||
626 | 626 | Secretaria de Turismo del Gobierno de Mexico (via Braintivity) | 2022-10-12 | MEXICO | Visit Mexico USA, LLC 7184 | 2022-10-12 | Visit Mexico USA, LLC | Avenida Presidente Masaryk, 172 Bosques de Chapultepec Ciudad de México | |||||
717 | 717 | Turismo de Los Cabos | 2017-11-27 | MEXICO | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | Lote S Plaza Providencia | Cabo San Lucas | ||||
783 | 783 | 1964-01-01 | Frente Civico Mexicano de Afirmacion Revolucionaria | 1963-03-26 | MEXICO | Frente Civico Mexicano de Afirmacion Revolucionaria 1612 | 1963-03-26 | Frente Civico Mexicano de Afirmacion Revolucionaria | |||||
823 | 823 | 1980-01-01 | Instituto Mexicano de Comercio Exterior | 1971-07-12 | MEXICO | Samuel E. Stavisky & Associates, Inc. 1531 | 1962-04-02 | Samuel E. Stavisky & Associates, Inc. | Mexico City | ||||
834 | 834 | 1982-01-01 | Constructora Nacional de Carros de Ferrocarril, S.A. | 1978-08-29 | MEXICO | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
877 | 877 | 1987-01-01 | Consejo Empresarial Mexicano para Asuntos Internacionales (CEMAI) | 1985-07-18 | MEXICO | GFE, Ltd. 3705 | 1985-07-18 | GFE, Ltd. | |||||
955 | 955 | 1996-01-01 | CONACEX NORESTE, A.C. | 1994-06-08 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
969 | 969 | 1998-01-01 | Ministry of Commerce & Industrial Development of Mexico (SECOFI) | 1996-07-02 | MEXICO | Federal Strategies Group, Inc. 5118 | 1996-07-02 | Federal Strategies Group, Inc. | Condesa | ||||
1144 | 1144 | 1974-01-08 | Mexico National Tourist Office | 1972-05-30 | MEXICO | Richter & Mracky-Bates, Inc. 2343 | 1972-05-30 | Richter & Mracky-Bates, Inc. | |||||
1207 | 1207 | 1988-01-11 | Government of Mexico | 1974-02-20 | MEXICO | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
1228 | 1228 | 1987-01-12 | Estado Chihuahua (State of Chihuahua) | 1986-03-19 | MEXICO | Jones, B. Calvin 3800 | 1986-03-19 | Jones, B. Calvin | |||||
1239 | 1239 | 1998-01-12 | ALFA Industries, S.A. | 1986-02-25 | MEXICO | Scanlon, Thomas J. 3500 | 1983-07-12 | Scanlon, Thomas J. | Nuevo Leon | ||||
1307 | 1307 | 1975-01-15 | Mexican National Tourist Council | 1972-01-28 | MEXICO | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | Mexico City | ||||
1326 | 1326 | 1992-01-15 | Holiday Inn | 1991-08-12 | MEXICO | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | |||||
1434 | 1434 | 1982-01-21 | Union Nacional de Productores de Hortalizas | 1979-07-26 | MEXICO | Food Business Associates, Inc. 3085 | 1979-07-26 | Food Business Associates, Inc. | Sinaloa | ||||
1441 | 1441 | 1994-01-21 | Telecommunicaciones Internacionales de Mexico | 1993-06-25 | MEXICO | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | Mexico City | ||||
1498 | 1498 | 1984-01-25 | Aeronaves de Mexico | 1964-07-10 | MEXICO | Lewis Company, Ltd. 1763 | 1964-06-19 | Lewis Company, Ltd. | |||||
1499 | 1499 | 1984-01-25 | Ferias y Exposiciones Mexicanas, A.C. | 1969-10-02 | MEXICO | Lewis Company, Ltd. 1763 | 1964-06-19 | Lewis Company, Ltd. | |||||
1565 | 1565 | 1946-01-28 | Ezequiel Padilla | 1946-01-28 | MEXICO | Morlet, Manuel Tomas 339 | 1946-01-28 | Morlet, Manuel Tomas | |||||
1566 | 1566 | 1946-01-28 | Partido Democratico Mexicano, Mexican Democratic Party | 1946-01-28 | MEXICO | Morlet, Manuel Tomas 339 | 1946-01-28 | Morlet, Manuel Tomas | Mexico City | ||||
1608 | 1608 | 1952-01-30 | Espana Libre | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | New York | NY | |||
1609 | 1609 | 1952-01-30 | Espana Nueva Spanish Papper | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | |||||
1612 | 1612 | 1952-01-30 | Pedro Martinez | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | Tampa | FL | |||
1616 | 1616 | 1952-01-30 | Vicente Esbri Vidal | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | |||||
1761 | 1761 | 1992-01-31 | Sectur/Mexico a Work of Art | 1991-01-31 | MEXICO | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | |||||
1788 | 1788 | 1996-01-31 | Grupo Domos | 1995-05-08 | MEXICO | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Garza Garcia | ||||
1810 | 1810 | 1998-01-31 | Office of the President of Mexico | 1995-02-06 | MEXICO | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | Mexico City | ||||
1899 | 1899 | 2017-01-31 | Consulate General of Mexico | 2016-06-22 | MEXICO | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 4507 San Jacinto Street | Houston | TX | 77004 | |
1934 | 1934 | 1943-02-01 | F. Rodriquez Rosa | 1943-03-12 | MEXICO | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
1979 | 1979 | 1978-02-01 | Fondo Nacional de Fomento al Turismo (Fonatur) | 1974-10-09 | MEXICO | Dancer Fitzgerald Sample, Inc. 2539 | 1974-10-09 | Dancer Fitzgerald Sample, Inc. | |||||
1986 | 1986 | 1980-02-01 | Constructora Nacional de Carros de Ferrocarril | 1978-03-21 | MEXICO | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | 1976-02-18 | Arent Fox Kintner Plotkin & Kahn, PLLC | |||||
1989 | 1989 | 1980-02-01 | Republic of Mexico (Mexican National Tourist Council) | 1979-10-15 | MEXICO | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | |||||
2051 | 2051 | 2002-02-01 | PEMEX | 2001-05-23 | MEXICO | LPI Consulting, Inc. 5434 | 2001-05-23 | LPI Consulting, Inc. | Marina Nacional #329 Col. Huasteca, Delegacion Miguel Hidalgo, Codigo Postal 11311, Petroleos Mexica | ||||
2120 | 2120 | 1961-02-03 | National Railways of Mexico | 1943-03-03 | MEXICO | Caples Company 34 | 1943-03-03 | Caples Company | Mexico City | ||||
2160 | 2160 | 1993-02-03 | La Cigarerra Moderna | 1991-08-01 | MEXICO | SJS Advanced Strategies, Inc. 4390 | 1990-06-25 | SJS Advanced Strategies, Inc. | |||||
2162 | 2162 | 2006-02-03 | Government of State of Mexico | 2003-12-24 | MEXICO | DLA Piper US LLP 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 | ||||
2175 | 2175 | 1983-02-04 | Asociacion Agricola Local de Productores de Uva de Mesa Local Table Grape Growers Association of Hermosillo, Sonora | 1982-07-09 | MEXICO | Farnsworth, Albert M. 3388 | 1982-07-09 | Farnsworth, Albert M. | Sonora | ||||
2206 | 2206 | 1985-02-05 | Samuel del Villar | 1984-09-17 | MEXICO | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | |||||
2220 | 2220 | 2001-02-05 | Government of Mexico, Embassy | 1998-12-16 | MEXICO | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 1911 Pennsylvania Avenue, N.W | DC | |||
2225 | 2225 | 1952-02-06 | Junta Espanola de Liberacion, Mexico, D.F. | 1944-04-28 | MEXICO | Riera, Pedro Orpi 248 | 1944-04-28 | Riera, Pedro Orpi | |||||
2226 | 2226 | 1952-02-06 | Spanish Republican Government in Exile | 1946-11-18 | MEXICO | Riera, Pedro Orpi 248 | 1944-04-28 | Riera, Pedro Orpi | |||||
2246 | 2246 | 1983-02-07 | Government of Mexico | 1979-07-11 | MEXICO | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | |||||
2293 | 2293 | 1947-02-09 | Adelante | 1944-08-09 | MEXICO | Reina, Antonio 274 | 1944-08-09 | Reina, Antonio | |||||
2294 | 2294 | 1947-02-09 | Espana | 1944-08-09 | MEXICO | Reina, Antonio 274 | 1944-08-09 | Reina, Antonio | |||||
2295 | 2295 | 1947-02-09 | Ministerio de Emigracion | 1946-10-09 | MEXICO | Reina, Antonio 274 | 1944-08-09 | Reina, Antonio | |||||
2320 | 2320 | 1993-02-09 | Grupo Empresarial Agricola Mexicano | 1992-10-09 | MEXICO | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | |||||
2322 | 2322 | 1993-02-09 | SICARTSA | 1991-12-31 | MEXICO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | |||||
2346 | 2346 | 1992-02-10 | Banco Nacional de Mexico (Banamex")" | 1991-03-27 | MEXICO | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Isabel la Catolica | ||||
2406 | 2406 | 1993-02-12 | Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. | 1990-11-06 | MEXICO | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Mexico City | ||||
2447 | 2447 | 2017-02-13 | Government of the State of Jalisco, Office of Communication | 2017-02-08 | MEXICO | Wiljan Consulting LLC 6402 | 2017-02-08 | Wiljan Consulting LLC | Palacio de Gobierno. Av. Corona #31 Col. Centro. | Guadalajara, Jalisco, Mexico. C.P. 44100 | |||
2484 | 2484 | 1994-02-14 | SECOFI (Secretaria de Comercio y Fomento Industrial) C/O Mexican Embassy Free Trade Office | 1991-03-12 | MEXICO | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Washington | DC | |||
2498 | 2498 | 1996-02-14 | Cemex, S.A. | 1994-06-08 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
2516 | 2516 | 1996-02-14 | Vitro, S.A. | 1993-11-01 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Garza Garcia | ||||
2566 | 2566 | 2019-02-15 | Government of Mexico | 1991-03-15 | MEXICO | Public Strategies Washington, Inc. 4486 | 1991-03-15 | Public Strategies Washington, Inc. | Mexico City | ||||
2577 | 2577 | 1960-02-16 | Union Nacional Sinarquista Consejo Nacional | 1946-08-16 | MEXICO | Union Nacional Sinarquista, Inc. 367 | 1946-08-16 | Union Nacional Sinarquista, Inc. | Mexico City | ||||
2589 | 2589 | 1994-02-16 | Fiesta Americana Hotels | 1990-08-03 | MEXICO | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Reforma Lomas | ||||
2594 | 2594 | 1996-02-16 | Camara Nacional de la Industria Pesquera | 1994-02-25 | MEXICO | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Mexico City | ||||
2595 | 2595 | 1996-02-16 | Camara Nacional de las Industrias (Azucarera y Alcoholera) | 1994-02-25 | MEXICO | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Mexico City | ||||
2596 | 2596 | 1996-02-16 | Cementos Mexicanos | 1994-02-25 | MEXICO | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Monterrey | ||||
2619 | 2619 | 1945-02-18 | Section of the Dominican Revolutionary Party in Mexico | 1944-08-18 | MEXICO | Dominican Revolutionary Party/Section of Mayaguez 275 | 1944-08-18 | Dominican Revolutionary Party/Section of Mayaguez | Habana | ||||
2709 | 2709 | 1962-02-23 | Organizaciones Rebolucionarias Unidas | 1961-02-23 | MEXICO | De La Campa, Alberto 1428 | 1961-02-23 | De La Campa, Alberto | |||||
2711 | 2711 | 1967-02-23 | Camara Nacional de la Industria Pesquera | 1960-06-13 | MEXICO | Chapman, DiSalle & Friedman 867 | 1955-01-21 | Chapman, DiSalle & Friedman | |||||
2713 | 2713 | 1967-02-23 | Sociedad Mexicana de Credito Industrial, S.A. | 1961-10-16 | MEXICO | Chapman, DiSalle & Friedman 867 | 1955-01-21 | Chapman, DiSalle & Friedman | |||||
2752 | 2752 | 1949-02-25 | Union Nacional Sinarquista (National Synarchist Union) | 1942-08-25 | MEXICO | Gross Jr., Frank J. 106 | 1942-08-25 | Gross Jr., Frank J. | Mexico City | ||||
2777 | 2777 | 1997-02-25 | Fomento Economico Mexicano, S.A. de C.V. | 1997-02-25 | MEXICO | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | Monterrey | ||||
2812 | 2812 | 1964-02-26 | Amparo Martinez | 1950-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2813 | 2813 | 1964-02-26 | Antonio Calderon Talavera | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2814 | 2814 | 1964-02-26 | Antonio Zermeno | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2815 | 2815 | 1964-02-26 | Bibiano Segura Leon | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2816 | 2816 | 1964-02-26 | Consuelo Sanchez Gonzalez | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2817 | 2817 | 1964-02-26 | David Lomeli Contreras | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2818 | 2818 | 1964-02-26 | Davis Orosco Romo | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2820 | 2820 | 1964-02-26 | Francisco Raul Calderon | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2821 | 2821 | 1964-02-26 | Ignacio Gonzalez Gollaz | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2822 | 2822 | 1964-02-26 | Jaime Delgado Herrera | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2823 | 2823 | 1964-02-26 | Jesus Montenegro Aboytes | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2824 | 2824 | 1964-02-26 | Jose Davalos | 1958-11-30 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2825 | 2825 | 1964-02-26 | Jose Manuel Figueroa | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2826 | 2826 | 1964-02-26 | Jose Resendiz Castaneda | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2827 | 2827 | 1964-02-26 | Jose Sanchez Gonzalez | 1959-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2828 | 2828 | 1964-02-26 | Josefina Escobedo | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2830 | 2830 | 1964-02-26 | Juan Ignacio Padilla | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2831 | 2831 | 1964-02-26 | Leon Aguilar | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2832 | 2832 | 1964-02-26 | Leopoldo Martinez | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2833 | 2833 | 1964-02-26 | Leovardo Senteno | 1953-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2834 | 2834 | 1964-02-26 | Manuel Galindo Fuentes | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2835 | 2835 | 1964-02-26 | Maria De Jesus Castro De Lomeli | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2836 | 2836 | 1964-02-26 | Ofelia Ramirez | 1961-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2837 | 2837 | 1964-02-26 | Oscar Memdez Napoles | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2838 | 2838 | 1964-02-26 | Rafael Bernal | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2839 | 2839 | 1964-02-26 | Salvador Zermeno Marques | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista |
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]) );