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

20 rows where Registration_Number = 2049 and State = "MI"

✎ 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

  • Netherlands Information Service, Michigan · 20 ✖

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
3960 3960 1974-01-17 1966-12-31 Wichers Willard C. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
10028 10028 1965-03-16 1965-06-30 Kanera H. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11430 11430 1974-03-31 1965-06-30 Grace Antoon Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11431 11431 1974-03-31 1965-06-30 Zijthoff G.J. Ten Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11433 11433 1974-03-31 1966-12-31 Anderson M. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11434 11434 1974-03-31 1971-12-31 Bogaert Josephus P.A.M. Den Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11435 11435 1974-03-31 1971-12-31 Brandon M.R. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11436 11436 1974-03-31 1971-12-31 Citroen H. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11437 11437 1974-03-31 1971-12-31 Constantine Ineke Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11438 11438 1974-03-31 1971-12-31 Ekker A. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11439 11439 1974-03-31 1971-12-31 Franenburg C.E. Erazo Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11440 11440 1974-03-31 1971-12-31 Hennep Henry E. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11441 11441 1974-03-31 1971-12-31 Hesselink M.J.A. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11442 11442 1974-03-31 1971-12-31 Robertson Katrijn A. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11443 11443 1974-03-31 1971-12-31 Stein Katrhyn W. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11444 11444 1974-03-31 1971-12-31 Valentijn J.A.M. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11445 11445 1974-03-31 1971-12-31 de Ranitz Annemarie Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
11446 11446 1974-03-31 1971-12-31 van Eer Irwin E. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
18413 18413 1973-06-01 1966-12-31 Johnson Audrey L. Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423
35801 35801 1972-11-15 1966-12-31 Cook George Netherlands Information Service, Michigan 2049 1967-09-13 Netherlands Information Service, Michigan City Hall   Holland MI 49423

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