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
2529 2529 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
4811 4811 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
4813 4813 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
4814 4814 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
4815 4815 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
4816 4816 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
4817 4817 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
4824 4824 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
4825 4825 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
5418 5418 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
5469 5469 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
6619 6619 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
6766 6766 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
6919 6919 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
6920 6920 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
6921 6921 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
8326 8326 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
8328 8328 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
8456 8456 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
8473 8473 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
8620 8620 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
8621 8621 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
9679 9679 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
9749 9749 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
9902 9902 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
10119 10119 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
10269 10269 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
10270 10270 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
10346 10346 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
10961 10961 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
11956 11956 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
11957 11957 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
11977 11977 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
11980 11980 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
12048 12048 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
12472 12472 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
12473 12473 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
12474 12474 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
13039 13039 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
13040 13040 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
13045 13045 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
13139 13139 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
13140 13140 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
13141 13141 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
13144 13144 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
13145 13145 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
13146 13146 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
13686 13686 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
14788 14788 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
14792 14792 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
15271 15271 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
15272 15272 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
15319 15319 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
15320 15320 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
15321 15321 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
15322 15322 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
15323 15323 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
15324 15324 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
15325 15325 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
15326 15326 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
15327 15327 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
15328 15328 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
15329 15329 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
15330 15330 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
15331 15331 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
15332 15332 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
15333 15333 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
15334 15334 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
15335 15335 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
15336 15336 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
15337 15337 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
15338 15338 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
15389 15389 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
15390 15390 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
15391 15391 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
15392 15392 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
15393 15393 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
15394 15394 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
15473 15473 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
15598 15598 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
15599 15599 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
15600 15600 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
15601 15601 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
15602 15602 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
15603 15603 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
15604 15604 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
15605 15605 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
15606 15606 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
15730 15730 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
15731 15731 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
15732 15732 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
15733 15733 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
15734 15734 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
16211 16211 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
16212 16212 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
16513 16513 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
16663 16663 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
17657 17657 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
17670 17670 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
18199 18199 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])
);