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

82 rows where Registrant_Name = "Mexican Tourism Board"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

State 2

Registration_Number 2

City 2

Registrant_Name 1

  • Mexican Tourism Board · 82 ✖
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
8843 8843 2005-03-01 2004-10-13 Cruz-Serrano Reynaldo A. Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
9782 9782 1995-03-13 1993-08-26 Gonzalez Francisco J. Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
12546 12546 2010-04-01 2008-11-19 Del Puerto Jose Maria Barquin Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
16402 16402 1988-05-15 1988-05-15 Bahry Alberto Abdo Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
17925 17925 2000-05-31 1993-01-25 Bouchereau Maria B. Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
19589 19589 2004-06-15 2002-12-17 Trevino Citlaly M. Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
20893 20893 1974-06-30 1972-08-31 Escandon Fernando Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
21654 21654 2010-06-30 2006-02-01 Patron Jorge Gamboa Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
21670 21670 2010-06-30 2004-10-13 Gonzalez-Cadaval Maria Luisa Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
24749 24749 1986-07-31 1970-09-08 Munoz-Avina Manuel Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
29806 29806 1972-09-15 1971-09-07 Bravo Jose J. Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
34224 34224 1982-10-31 1970-09-08 Ruz Alfonso Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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
39899 39899 1971-12-31 1970-09-08 Jones Oscar V. Mexican Tourism Board 2209 1970-09-08 Mexican Tourism Board 2401 West 6th Street   Los Angeles CA 90057
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])
);