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

24 rows where Registrant_Name = "Mexican Government Railway System"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

Registrant_Name 1

  • Mexican Government Railway System · 24 ✖

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
2535 2535 1966-01-01 1965-05-11 Carrillo Roberto Sandoval Y Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
2537 2537 1966-01-01 1960-08-05 Esparza Luis Navarro Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
3512 3512 1962-01-10 1946-12-17 Vazquez Juan , Jr. Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
5625 5625 1949-02-01 1946-12-17 Chenoweth Harry Escalante Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
5626 5626 1949-02-01 1946-12-17 Vargas Guillermo Hawley Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
5652 5652 1961-02-01 1959-07-29 Basauri Luis Madrazo Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
6718 6718 1976-02-13 1970-09-08 D'Addona Manuel Zopfy Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
17620 17620 1973-05-31 1972-03-23 Avila Ricardo Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
17621 17621 1973-05-31 1972-03-23 Canto Rogerio Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
19502 19502 1970-06-15 1965-05-11 Brillas Guillermo Moreno Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
20124 20124 1964-06-24 1946-12-17 Alatorre Francisco Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
22035 22035 1956-07-01 1951-04-04 Reynoso Fernando Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
28764 28764 1964-09-01 1946-12-17 Moscosso V.H. Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
31770 31770 1957-10-01 1946-12-17 Servin G. Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
31793 31793 1964-10-01 1953-05-12 Garza Horacio Dominguez Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
32834 32834 1971-10-15 1971-02-04 Vasconcelos Jose I. Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
33378 33378 1986-10-22 1962-03-16 Scanlan Francis Thomas Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
33385 33385 1986-10-22 1978-07-19 Cerchione Emita (Rodriguez) Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
34877 34877 1977-11-01 1973-08-14 Guillen Jose Ramon Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
38275 38275 1973-12-14 1947-02-24 Moreno Felipe Nicolas Puente Y Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
38276 38276 1973-12-14 1947-02-26 Lina Laura Cecilia Bergquist Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
38280 38280 1973-12-14 1946-12-17 Porragas Santiago Pichardo Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
39359 39359 1983-12-30 1946-12-17 Hernandez Jose Guadalupe Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 New York NY 10017
39360 39360 1983-12-30 1946-12-17 Lopez Jose M. Mexican Government Railway System 413 1946-12-17 Mexican Government Railway System 1500 Broadway Suite 810 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])
);