FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
569 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, 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 >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 10
- - 550
- Mexico City 5
- Washington 5
- Houston 2
- Juarez 2
- Cuauhtemoc, 1
- MEXICO 1
- Tamaulipas 1
- Texcoco 1
- Washington, DC 1
Country/Location_Represented 1
- MEXICO · 569 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129 | 129 | 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) | ||||||
171 | 171 | Embassy of Mexico | 2022-01-12 | MEXICO | Glassman Enterprises, LLC 7069 | 2022-01-12 | Glassman Enterprises, LLC | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
172 | 172 | 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 | ||
300 | 300 | 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 | |||
322 | 322 | 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 | |||
358 | 358 | 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 | |||
441 | 441 | 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 | ||
502 | 502 | Municipality of Morelia - Economic Development Office | 2022-02-16 | MEXICO | Morris, Luis A. 7080 | 2022-02-16 | Morris, Luis A. | Allende # 403, Col. Centro | Morelia 58000 | ||||
627 | 627 | 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 | ||||
628 | 628 | Secretaria de Economia | 2019-05-03 | MEXICO | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | Ave Pachuca #189 | Col. Hipodromo Condesa Ciudad de Mexico CP06140 | ||||
629 | 629 | Secretartia de Economia | 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) | ||||||
713 | 713 | 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 | ||||
767 | 767 | 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 | |||||
807 | 807 | 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 | ||||
818 | 818 | 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. | |||||
861 | 861 | 1987-01-01 | Consejo Empresarial Mexicano para Asuntos Internacionales (CEMAI) | 1985-07-18 | MEXICO | GFE, Ltd. 3705 | 1985-07-18 | GFE, Ltd. | |||||
939 | 939 | 1996-01-01 | CONACEX NORESTE, A.C. | 1994-06-08 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
953 | 953 | 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 | ||||
1120 | 1120 | 1974-01-08 | Mexico National Tourist Office | 1972-05-30 | MEXICO | Richter & Mracky-Bates, Inc. 2343 | 1972-05-30 | Richter & Mracky-Bates, Inc. | |||||
1183 | 1183 | 1988-01-11 | Government of Mexico | 1974-02-20 | MEXICO | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
1204 | 1204 | 1987-01-12 | Estado Chihuahua (State of Chihuahua) | 1986-03-19 | MEXICO | Jones, B. Calvin 3800 | 1986-03-19 | Jones, B. Calvin | |||||
1215 | 1215 | 1998-01-12 | ALFA Industries, S.A. | 1986-02-25 | MEXICO | Scanlon, Thomas J. 3500 | 1983-07-12 | Scanlon, Thomas J. | Nuevo Leon | ||||
1284 | 1284 | 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 | ||||
1303 | 1303 | 1992-01-15 | Holiday Inn | 1991-08-12 | MEXICO | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | |||||
1410 | 1410 | 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 | ||||
1417 | 1417 | 1994-01-21 | Telecommunicaciones Internacionales de Mexico | 1993-06-25 | MEXICO | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | Mexico City | ||||
1473 | 1473 | 1984-01-25 | Aeronaves de Mexico | 1964-07-10 | MEXICO | Lewis Company, Ltd. 1763 | 1964-06-19 | Lewis Company, Ltd. | |||||
1474 | 1474 | 1984-01-25 | Ferias y Exposiciones Mexicanas, A.C. | 1969-10-02 | MEXICO | Lewis Company, Ltd. 1763 | 1964-06-19 | Lewis Company, Ltd. | |||||
1538 | 1538 | 1946-01-28 | Ezequiel Padilla | 1946-01-28 | MEXICO | Morlet, Manuel Tomas 339 | 1946-01-28 | Morlet, Manuel Tomas | |||||
1539 | 1539 | 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 | ||||
1581 | 1581 | 1952-01-30 | Espana Libre | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | New York | NY | |||
1582 | 1582 | 1952-01-30 | Espana Nueva Spanish Papper | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | |||||
1585 | 1585 | 1952-01-30 | Pedro Martinez | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | Tampa | FL | |||
1589 | 1589 | 1952-01-30 | Vicente Esbri Vidal | 1947-01-31 | MEXICO | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | |||||
1734 | 1734 | 1992-01-31 | Sectur/Mexico a Work of Art | 1991-01-31 | MEXICO | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | |||||
1761 | 1761 | 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 | ||||
1783 | 1783 | 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 | ||||
1872 | 1872 | 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 | |
1905 | 1905 | 1943-02-01 | F. Rodriquez Rosa | 1943-03-12 | MEXICO | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
1950 | 1950 | 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. | |||||
1957 | 1957 | 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 | |||||
1960 | 1960 | 1980-02-01 | Republic of Mexico (Mexican National Tourist Council) | 1979-10-15 | MEXICO | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | |||||
2022 | 2022 | 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 | ||||
2088 | 2088 | 1961-02-03 | National Railways of Mexico | 1943-03-03 | MEXICO | Caples Company 34 | 1943-03-03 | Caples Company | Mexico City | ||||
2128 | 2128 | 1993-02-03 | La Cigarerra Moderna | 1991-08-01 | MEXICO | SJS Advanced Strategies, Inc. 4390 | 1990-06-25 | SJS Advanced Strategies, Inc. | |||||
2130 | 2130 | 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 | ||||
2143 | 2143 | 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 | ||||
2174 | 2174 | 1985-02-05 | Samuel del Villar | 1984-09-17 | MEXICO | Arnold & Porter Kaye Scholer, LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer, LLP | |||||
2188 | 2188 | 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 | |||
2192 | 2192 | 1952-02-06 | Junta Espanola de Liberacion, Mexico, D.F. | 1944-04-28 | MEXICO | Riera, Pedro Orpi 248 | 1944-04-28 | Riera, Pedro Orpi | |||||
2193 | 2193 | 1952-02-06 | Spanish Republican Government in Exile | 1946-11-18 | MEXICO | Riera, Pedro Orpi 248 | 1944-04-28 | Riera, Pedro Orpi | |||||
2213 | 2213 | 1983-02-07 | Government of Mexico | 1979-07-11 | MEXICO | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | |||||
2259 | 2259 | 1947-02-09 | Adelante | 1944-08-09 | MEXICO | Reina, Antonio 274 | 1944-08-09 | Reina, Antonio | |||||
2260 | 2260 | 1947-02-09 | Espana | 1944-08-09 | MEXICO | Reina, Antonio 274 | 1944-08-09 | Reina, Antonio | |||||
2261 | 2261 | 1947-02-09 | Ministerio de Emigracion | 1946-10-09 | MEXICO | Reina, Antonio 274 | 1944-08-09 | Reina, Antonio | |||||
2286 | 2286 | 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 | |||||
2288 | 2288 | 1993-02-09 | SICARTSA | 1991-12-31 | MEXICO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | |||||
2312 | 2312 | 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 | ||||
2372 | 2372 | 1993-02-12 | Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. | 1990-11-06 | MEXICO | Crowell & Moring International, Ltd. 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Mexico City | ||||
2412 | 2412 | 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 | |||
2448 | 2448 | 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 | |||
2462 | 2462 | 1996-02-14 | Cemex, S.A. | 1994-06-08 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
2480 | 2480 | 1996-02-14 | Vitro, S.A. | 1993-11-01 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Garza Garcia | ||||
2530 | 2530 | 2019-02-15 | Government of Mexico | 1991-03-15 | MEXICO | Public Strategies Washington, Inc. 4486 | 1991-03-15 | Public Strategies Washington, Inc. | Mexico City | ||||
2537 | 2537 | 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 | ||||
2549 | 2549 | 1994-02-16 | Fiesta Americana Hotels | 1990-08-03 | MEXICO | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Reforma Lomas | ||||
2554 | 2554 | 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 | ||||
2555 | 2555 | 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 | ||||
2556 | 2556 | 1996-02-16 | Cementos Mexicanos | 1994-02-25 | MEXICO | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Monterrey | ||||
2579 | 2579 | 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 | ||||
2667 | 2667 | 1962-02-23 | Organizaciones Rebolucionarias Unidas | 1961-02-23 | MEXICO | De La Campa, Alberto 1428 | 1961-02-23 | De La Campa, Alberto | |||||
2669 | 2669 | 1967-02-23 | Camara Nacional de la Industria Pesquera | 1960-06-13 | MEXICO | Chapman, DiSalle & Friedman 867 | 1955-01-21 | Chapman, DiSalle & Friedman | |||||
2671 | 2671 | 1967-02-23 | Sociedad Mexicana de Credito Industrial, S.A. | 1961-10-16 | MEXICO | Chapman, DiSalle & Friedman 867 | 1955-01-21 | Chapman, DiSalle & Friedman | |||||
2709 | 2709 | 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 | ||||
2734 | 2734 | 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 | ||||
2769 | 2769 | 1964-02-26 | Amparo Martinez | 1950-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2770 | 2770 | 1964-02-26 | Antonio Calderon Talavera | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2771 | 2771 | 1964-02-26 | Antonio Zermeno | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2772 | 2772 | 1964-02-26 | Bibiano Segura Leon | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2773 | 2773 | 1964-02-26 | Consuelo Sanchez Gonzalez | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2774 | 2774 | 1964-02-26 | David Lomeli Contreras | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2775 | 2775 | 1964-02-26 | Davis Orosco Romo | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2777 | 2777 | 1964-02-26 | Francisco Raul Calderon | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2778 | 2778 | 1964-02-26 | Ignacio Gonzalez Gollaz | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2779 | 2779 | 1964-02-26 | Jaime Delgado Herrera | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2780 | 2780 | 1964-02-26 | Jesus Montenegro Aboytes | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2781 | 2781 | 1964-02-26 | Jose Davalos | 1958-11-30 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2782 | 2782 | 1964-02-26 | Jose Manuel Figueroa | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2783 | 2783 | 1964-02-26 | Jose Resendiz Castaneda | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2784 | 2784 | 1964-02-26 | Jose Sanchez Gonzalez | 1959-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2785 | 2785 | 1964-02-26 | Josefina Escobedo | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2787 | 2787 | 1964-02-26 | Juan Ignacio Padilla | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2788 | 2788 | 1964-02-26 | Leon Aguilar | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2789 | 2789 | 1964-02-26 | Leopoldo Martinez | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2790 | 2790 | 1964-02-26 | Leovardo Senteno | 1953-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2791 | 2791 | 1964-02-26 | Manuel Galindo Fuentes | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2792 | 2792 | 1964-02-26 | Maria De Jesus Castro De Lomeli | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2793 | 2793 | 1964-02-26 | Ofelia Ramirez | 1961-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2794 | 2794 | 1964-02-26 | Oscar Memdez Napoles | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2795 | 2795 | 1964-02-26 | Rafael Bernal | 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]) );