home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

569 rows where Country/Location_Represented = "MEXICO"

✎ View and edit SQL

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

State 8

  • - 511
  • DC 25
  • NY 12
  • TX 11
  • CA 4
  • FL 4
  • NC 1
  • TN 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          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 174.955ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history