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

15 rows where Registration_Number = 529

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Belgian National Tourist Office · 15 ✖

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
3754 3754 1973-01-15 1948-06-17 De Bleeker Audrey Maria Adrienne Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
3755 3755 1973-01-15 1948-06-17 Martens Fernand Jean-Frederic Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
3756 3756 1973-01-15 1960-07-19 Emil Haulot, Frederique Charlotte Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
3757 3757 1973-01-15 1955-07-27 Vivier Daniel Le Roy du Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
4017 4017 1971-01-18 1956-02-13 Kahn Helen L. Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
5646 5646 1960-02-01 1960-07-19 Charlier Roger Henri Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
20926 20926 1978-06-30 1972-02-18 Koenig Marion Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
21591 21591 2007-06-30 1977-05-23 Raeymaekers Frederique Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
28618 28618 2016-08-31 2015-08-12 Haffreingue Francoise Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
37286 37286 1971-12-01 1952-02-20 De Bary Nadine Julienne Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
37289 37289 1971-12-01 1971-07-01 Delafontaine Janine Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
40025 40025 1977-12-31 1956-02-13 De Maerel Peter A. Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
40106 40106 1979-12-31 1979-09-05 Parke Stephen P. Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
40547 40547 1989-12-31 1977-02-18 Neville Ann Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor New York NY 10017
42031 42031 2016-12-31 2008-04-02 Choynacki Annette Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office 300 East 42nd Street 14th Floor 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])
);