FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

69 rows where Registration_Number = 1754

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Mexican Tourism Board · 69 ✖

Registrant_Name 1

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
2682 2682 1989-01-01 1985-10-22 Lombardo Jorge Diaz Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
5017 5017 1987-01-31 1985-10-22 De Ferari Elisabeth Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
5081 5081 1991-01-31 1988-08-09 Guillen Manuel Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
5764 5764 1989-02-01 1987-02-20 O'Farrill Marcia Eugenia Gonzalez Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
5793 5793 1995-02-01 1990-01-29 Cerisola Patricia Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
6582 6582 1995-02-10 1988-08-09 Olea Armando Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
6906 6906 1968-02-15 1967-09-07 de Abromowitz Anagilda Garrasttegui Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
6910 6910 1971-02-15 1964-06-09 Zaiser Carol Joan Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
7879 7879 1976-02-28 1972-03-07 Ambron Andre M.G. Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
8090 8090 1998-02-28 1997-07-28 Verastegui Matilde Garcia Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
10303 10303 1986-03-19 1985-10-22 Hodgins Vincent Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
11054 11054 1994-03-29 1987-02-20 Lopez Francisco J. Gurria Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
11062 11062 1994-03-29 1987-11-02 Almada Alicia Rodriguez Familiar Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
11573 11573 1987-03-31 1985-10-22 Elorza Vicente Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
11957 11957 2005-03-31 2004-10-14 Amezcua Acuna Eduardo David Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
12693 12693 1995-04-03 1994-03-29 Gamboa-Patron Jorge Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
16403 16403 1988-05-15 1985-10-22 Bahry Alberto Abdo Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
17481 17481 1997-05-30 1995-02-10 Cabrera Myrna Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
17499 17499 2004-05-30 2003-05-07 Guerrero Hortensia Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
19088 19088 1964-06-09 1964-06-09 Breese Beverly Ann Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
19089 19089 1964-06-09 1964-06-09 Ramsey Betty Jo Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
19511 19511 1972-06-15 1965-05-03 Durant Ellen Gloria Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
19556 19556 1989-06-15 1988-08-09 Valdez Jorge Alberto M.Y. Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
20846 20846 1972-06-30 1964-06-09 Canning Daniel Fayerweather Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
20847 20847 1972-06-30 1964-06-09 Celliers Peter Joubert Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
20848 20848 1972-06-30 1964-06-09 Silverman Ernest Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
21141 21141 1990-06-30 1989-08-29 Gonzalez Servando Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
21570 21570 2006-06-30 2003-05-07 Caballero Adriana Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
21571 21571 2006-06-30 2003-05-07 Esponda Rodrigo Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
21577 21577 2006-06-30 2005-08-08 Marquez Clara Adriana Torres Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
23244 23244 1988-07-15 1987-02-20 Ragsdale Dorothea E. Noyes Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
23253 23253 1989-07-15 1989-02-15 Steta Maria Isabel Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
24563 24563 1996-07-30 1995-08-04 Martinez Jose Garcia Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
25629 25629 2002-08-01 1999-01-29 Ramos Tatiana Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
25635 25635 2002-08-01 1999-08-03 Vivar-Mariscal Jorge Arturo Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
26667 26667 1966-08-15 1965-04-12 Ingram Richard Charles Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
26724 26724 1987-08-15 1966-02-07 McCoy Patrick Desmond Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27130 27130 1992-08-21 1970-01-13 de Bouchez Concepcion Noye Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27131 27131 1992-08-21 1979-01-31 Gonzalez Jorge V. Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27132 27132 1992-08-21 1972-03-07 Aldaz Jose Luis Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27133 27133 1992-08-21 1973-03-07 Solar Luis Suarez Del Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27135 27135 1992-08-21 1964-06-09 Gray Jean Loach Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27136 27136 1992-08-21 1964-06-09 Scofield Barbara Holbrook Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27138 27138 1992-08-21 1985-10-22 Zarate Jose C. Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
27780 27780 1995-08-30 1994-03-29 Morales-Portas Eduardo Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
28127 28127 1988-08-31 1987-11-02 King Roberto Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
34262 34262 1986-10-31 1977-02-14 Doyle John H. Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
37934 37934 1964-12-09 1964-06-09 Benedikt Marianne Sabados Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
37935 37935 1964-12-09 1964-06-09 Murphy Mary Kay Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
37936 37936 1964-12-09 1964-10-02 Kulakoff Harriet Enid Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
37942 37942 1965-12-09 1965-07-21 Ray Gene Thomas Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
38277 38277 1973-12-14 1964-06-09 Fouche Bruce Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
38278 38278 1973-12-14 1964-07-23 Munoz Ector Manuel Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
38279 38279 1973-12-14 1964-09-03 Oyervidez Dr. Jose Carlos Serrato Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
38351 38351 1965-12-15 1965-05-03 Becerra Oscar Alberto Marquez Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
40323 40323 1985-12-31 1964-06-09 Lecube Miguel Angel Alejo Lopez Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
40382 40382 1986-12-31 1985-10-22 Bayardo Francisco Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
40383 40383 1986-12-31 1985-10-22 Duenas Roberto Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41279 41279 2002-12-31 1985-10-22 De Rojas Magdalena Torrescano Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41280 41280 2002-12-31 1985-10-22 Furlong Norma Ruiz Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41281 41281 2002-12-31 1985-10-22 Gamboa Jorge Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41282 41282 2002-12-31 1985-10-22 Garcia Rolando Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41283 41283 2002-12-31 1985-10-22 Hampe Carlos Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41284 41284 2002-12-31 1985-10-22 Mendez Adolfo Ibarra Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41285 41285 2002-12-31 1985-10-22 Navarro Jose Luis Sanchez Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41286 41286 2002-12-31 1985-10-22 Nieto Jose Luis Ayala Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41287 41287 2002-12-31 1985-10-22 Padilla Elia Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41288 41288 2002-12-31 1985-10-22 Reid Arthur S. Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017
41391 41391 2005-12-31 1991-02-08 Lopez Maria Isabel Mexican Tourism Board 1754 1964-06-09 Mexican Tourism Board 400 Madison Avenue Suite 11C New York NY 10017

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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])
);