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

238 rows where Registration_Number = 456

✎ View and edit SQL

This data as json, CSV (advanced)

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
2379 2379 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
4645 4645 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
4647 4647 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
4648 4648 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
4649 4649 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
4650 4650 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
4651 4651 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
4658 4658 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
4659 4659 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
5240 5240 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
5291 5291 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
6430 6430 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
6566 6566 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
6719 6719 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
6720 6720 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
6721 6721 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
8109 8109 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
8111 8111 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
8239 8239 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
8256 8256 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
8395 8395 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
8396 8396 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
9442 9442 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
9512 9512 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
9664 9664 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
9881 9881 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
10029 10029 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
10030 10030 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
10105 10105 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
10717 10717 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
11677 11677 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
11678 11678 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
11698 11698 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
11701 11701 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
11769 11769 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
12187 12187 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
12188 12188 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
12189 12189 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
12746 12746 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
12747 12747 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
12752 12752 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
12846 12846 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
12847 12847 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
12848 12848 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
12851 12851 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
12852 12852 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
12853 12853 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
13382 13382 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
14455 14455 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
14459 14459 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
14928 14928 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
14929 14929 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
14971 14971 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
14972 14972 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
14973 14973 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
14974 14974 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
14975 14975 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
14976 14976 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
14977 14977 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
14978 14978 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
14979 14979 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
14980 14980 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
14981 14981 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
14982 14982 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
14983 14983 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
14984 14984 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
14985 14985 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
14986 14986 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
14987 14987 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
14988 14988 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
14989 14989 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
14990 14990 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
15041 15041 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
15042 15042 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
15043 15043 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
15044 15044 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
15045 15045 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
15046 15046 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
15123 15123 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
15247 15247 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
15248 15248 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
15249 15249 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
15250 15250 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
15251 15251 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
15252 15252 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
15253 15253 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
15254 15254 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
15255 15255 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
15379 15379 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
15380 15380 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
15381 15381 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
15382 15382 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
15383 15383 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
15856 15856 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
15857 15857 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
16157 16157 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
16305 16305 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
17281 17281 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
17294 17294 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
17817 17817 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)
);