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

21 rows where Registration_Number = 538

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Short_Form_Date (date)

State 1

Registration_Number 1

  • Spanish National Tourist Office, New York · 21 ✖

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
2540 2540 1967-01-01 1966-04-15 Bernstein Phyllis Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
2542 2542 1968-01-01 1967-04-21 Fajardo Manuel Garcia Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
2550 2550 1970-01-01 1969-03-11 Peck Ralph H. Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
7841 7841 1966-02-28 1964-10-29 Perez Jose Eugenio Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
7842 7842 1966-02-28 1964-10-29 Pujol Joaquin Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
11429 11429 1974-03-31 1974-06-21 Coll Jose Maria Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
17622 17622 1973-05-31 1966-04-15 Ruiz Antonio Alonso Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
22052 22052 1962-07-01 1951-09-18 De Ugarte Prudencia Garcia Saenz Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
22083 22083 1971-07-01 1967-02-24 Iznaola Antonio Carbajosa Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
25483 25483 1972-08-01 1964-05-15 Perez Enrique Garcia-Herraiz Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
26329 26329 1950-08-10 1950-03-23 Brandts Jorge Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
26529 26529 1977-08-13 1976-05-11 Ayuso Fernando Rodriguez Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
27915 27915 1976-08-31 1973-03-14 Pachon Carlos Sanchez Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
31761 31761 1950-10-01 1950-03-23 Tristan Mauro Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
31815 31815 1972-10-01 1972-04-17 Sandoval Julian Moreno Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
35644 35644 1973-11-12 1950-03-23 Mexax Kasem B. Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
35646 35646 1973-11-12 1949-09-21 Garcia Cayita Pacheco Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
37932 37932 1948-12-09 1948-09-14 Long Georgia B. Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
39324 39324 1980-12-30 1973-03-14 Iznaola Antonio Carbajosa Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
39744 39744 1962-12-31 1948-09-14 Coll Jose Maria Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022
39854 39854 1967-12-31 1966-04-15 Baumgartner Susan Spanish National Tourist Office, New York 538 1948-09-14 Spanish National Tourist Office, New York 665 Fifth Avenue   New York NY 10022

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])
);