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

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
2586 2586 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
4806 4806 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
4808 4808 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
4809 4809 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
4810 4810 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
4811 4811 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
4812 4812 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
4819 4819 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
4820 4820 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
5380 5380 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
5431 5431 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
6555 6555 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
6672 6672 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
6821 6821 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
6822 6822 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
6823 6823 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
8152 8152 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
8154 8154 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
8282 8282 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
8299 8299 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
8437 8437 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
8438 8438 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
9483 9483 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
9553 9553 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
9705 9705 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
9921 9921 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
10069 10069 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
10070 10070 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
10144 10144 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
10754 10754 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
11709 11709 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
11710 11710 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
11730 11730 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
11733 11733 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
11801 11801 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
12207 12207 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
12208 12208 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
12209 12209 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
12763 12763 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
12764 12764 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
12769 12769 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
12862 12862 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
12863 12863 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
12864 12864 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
12867 12867 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
12868 12868 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
12869 12869 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
13392 13392 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
14436 14436 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
14440 14440 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
14906 14906 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
14907 14907 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
14949 14949 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
14950 14950 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
14951 14951 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
14952 14952 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
14953 14953 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
14954 14954 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
14955 14955 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
14956 14956 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
14957 14957 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
14958 14958 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
14959 14959 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
14960 14960 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
14961 14961 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
14962 14962 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
14963 14963 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
14964 14964 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
14965 14965 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
14966 14966 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
14967 14967 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
14968 14968 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
15018 15018 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
15019 15019 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
15020 15020 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
15021 15021 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
15022 15022 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
15023 15023 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
15100 15100 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
15223 15223 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
15224 15224 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
15225 15225 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
15226 15226 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
15227 15227 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
15228 15228 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
15229 15229 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
15230 15230 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
15231 15231 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
15355 15355 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
15356 15356 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
15357 15357 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
15358 15358 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
15359 15359 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
15819 15819 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
15820 15820 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
16118 16118 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
16266 16266 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
17228 17228 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
17241 17241 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
17759 17759 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 378.804ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history