FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

238 rows where Registration_Number = 456

View and edit SQL

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

State

Registration_Number

  • 456 · 238

City

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
2528 1988-01-01 1986-01-09 Jonckheer Guillaume Francois 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4731 1989-01-31 1951-04-04 Kooiman Pieter J. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4733 1989-01-31 1973-05-10 Stunzi Jacques Ralph 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4734 1989-01-31 1981-05-21 Wouter Ponsen Hendrik 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4735 1989-01-31 1970-06-17 Fraino Anthony J. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4736 1989-01-31 1961-06-19 Philips August 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4737 1989-01-31 1977-06-26 Hazes Jan P. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4744 1989-01-31 1971-10-21 Pennink Karel B. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
4745 1989-01-31 1958-12-12 van Heemstra Frans Julius Johan 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5292 1961-02-01 1959-08-07 von Hemert A. Philippe 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5343 1974-02-01 1971-10-21 Hoobroeckx Jan W. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
6460 1955-02-15 1953-07-30 McIntyre Philip E. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
6572 1955-02-16 1953-09-04 Hose Harold Clarence 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
6721 1959-02-18 1951-04-04 Ramsey Hobart Cole 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
6722 1959-02-18 1954-06-09 Huisingh Rudolph Onno 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
6723 1959-02-18 1957-09-06 Lind William 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8026 1960-03-01 1956-11-15 Lada-Mocarski Valerian 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8028 1961-03-01 1948-05-17 Tunell Clement Roland 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8156 1988-03-01 1982-06-02 Spriggs John S. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8173 1992-03-01 1990-03-21 Blank Aldert E. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8309 1954-03-02 1950-05-22 Barclay Thomas R. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8310 1954-03-02 1953-06-08 Gehle William Frederick 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
9352 1982-03-16 1981-11-27 van Baasbank C. J. P. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
9422 1970-03-17 1968-11-13 Huntington Freeman H. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
9574 1959-03-19 1955-05-23 Rand William B. , Jr. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
9789 1960-03-22 1951-07-09 Vuyk Adrian 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
9935 1959-03-24 1953-07-13 van Laer Johannes A. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
9936 1959-03-24 1954-07-22 Recknagel John Herman 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10010 1952-03-25 1951-04-04 Hayman Hugo H. (Henry) 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10613 1957-03-31 1951-04-04 Tollig Leendert 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
11552 1965-04-01 1958-12-03 Kiek Robert J. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
11553 1965-04-01 1950-12-26 Lago Anna 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
11573 1972-04-01 1951-04-04 Catz Isidor Bernhard 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
11576 1972-04-01 1971-10-21 Jordan A. Kees 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
11644 1988-04-01 1983-06-13 Brinckmann J. H. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12045 1965-04-08 1950-05-22 Sparks William Sidney 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12046 1965-04-08 1953-07-13 De Leur Dirk Laurens 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12047 1965-04-08 1959-10-21 van Stolk Cornelis 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12598 1953-04-16 1952-06-04 Langdon Ilyana Agusta 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12599 1953-04-16 1950-12-26 Keesing Sebastian Hornung 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12604 1956-04-16 1953-11-16 Bake Hugo Lourens A. den Wall 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12697 1969-04-17 1965-05-17 Hooykaas Dirk Neil 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12698 1969-04-17 1963-05-24 Haley John Charles 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12699 1969-04-17 1966-07-12 LaVoie Paul Charles 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12702 1969-04-17 1967-11-13 de Jong Cornelis Hendrikus 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12703 1969-04-17 1968-11-13 Hoets Pieter Johannes 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12704 1969-04-17 1961-11-21 Bochow John Philip 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13225 1966-04-27 1964-05-18 Eldridge Jonathan 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14228 1971-05-01 1971-01-31 Walker Frank M. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14232 1971-05-01 1966-06-06 Schifter Marilyn 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14690 1974-05-07 1955-02-18 Wrigley Richard Dean , Jr. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14691 1974-05-07 1954-11-15 Neuman Alexander 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14733 1974-05-08 1947-04-16 Brugger Charles Walter 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14734 1974-05-08 1947-04-16 Cremer Jacob Theodor 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14735 1974-05-08 1947-04-16 Crittenden William Whitcraft 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14736 1974-05-08 1947-04-16 De Vries Enrico Marius 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14737 1974-05-08 1947-04-16 Elias Edward 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14738 1974-05-08 1947-04-16 Gomory Andrew Louis 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14739 1974-05-08 1947-04-16 Johnson Clinton Charles 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14740 1974-05-08 1947-04-16 Pennington Harold Douglas 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14741 1974-05-08 1947-04-16 Poel Arie A. der 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14742 1974-05-08 1947-04-16 Rogers Howard Joseph 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14743 1974-05-08 1947-04-16 Sheehan Charles Vincent 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14744 1974-05-08 1947-04-16 Stousland Alfred C. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14745 1974-05-08 1947-04-16 Wardburgh Russell Lawrence 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14746 1974-05-08 1947-04-16 Wierdsma Frederick W. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14747 1974-05-08 1951-05-14 Rovensky Joseph Charles 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14748 1974-05-08 1951-06-08 Fleck Gustav Peter 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14749 1974-05-08 1951-06-08 Frank Jacobus F. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14750 1974-05-08 1953-06-08 Roth Gerda Johanna Elizabeth Berman 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14751 1974-05-08 1954-06-09 van Hengel Johannes Frederik 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14752 1974-05-08 1951-07-09 van Munching Leo 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14802 1974-05-09 1962-02-23 Rau Robert 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14803 1974-05-09 1960-05-03 Greenwald Curtis H. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14804 1974-05-09 1960-05-03 de Schepper Hendrik Yssel 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14805 1974-05-09 1963-11-14 Benney Trevose Walters 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14806 1974-05-09 1963-11-14 Young Philip 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14807 1974-05-09 1972-12-08 Marx Jean-Paul 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14884 1955-05-11 1951-06-08 de Lanoy Jan Adriaan 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15007 1974-05-13 1974-05-13 Lawrence John Mason 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15008 1974-05-13 1970-06-17 Schneider Gerhard W. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15009 1974-05-13 1971-10-21 Buchanan A. Campbell 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15010 1974-05-13 1971-10-21 van Dierendonck Joseph A. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15011 1974-05-13 1967-11-13 Moormans Willem Jan 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15012 1974-05-13 1969-11-21 Hazelhoff Robertus 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15013 1974-05-13 1969-11-21 Reurs John H. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15014 1974-05-13 1969-11-21 Schmidt Charles F. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15015 1974-05-13 1969-11-21 Von Korff Frederick E. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15139 1970-05-14 1960-05-12 Edwards Robert Lawson 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15140 1970-05-14 1963-05-15 Campbell Charles King 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15141 1970-05-14 1954-07-22 Gevers Maximilian Edward 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15142 1970-05-14 1967-11-13 Angliss Robert Joseph 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15143 1970-05-14 1953-11-16 Trimbos Constant A. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15598 1969-05-21 1959-06-24 Rasmussen Harold William 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15599 1969-05-21 1967-11-13 Guerin Charles H. 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15895 1964-05-26 1959-06-03 Tree Alfred Edward 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16042 1958-05-28 1957-07-24 Fosque John Drummond 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16993 1950-06-01 1949-05-16 Orcutt Reginald 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
17006 1957-06-01 1953-06-05 O'Sullivan Patrick Pearse 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
17517 1956-06-05 1953-06-24 Hayes Alfred 456 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020

Next page

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)
);
Powered by Datasette · Query took 392.546ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history