home / fara

Menu
  • Search all tables
  • GraphQL API

fara

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

Custom SQL query returning 101 rows (hide)

 
1
select 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 from FARA_All_ShortForms where "Registrant_Name" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowidShort_Form_Termination_DateShort_Form_DateShort_Form_Last_NameShort_Form_First_NameRegistration_NumberRegistration_DateRegistrant_NameAddress_1Address_2CityStateZip
2660 1988-01-01 1986-01-09 Jonckheer Guillaume Francois 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5029 1989-01-31 1951-04-04 Kooiman Pieter J. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5031 1989-01-31 1973-05-10 Stunzi Jacques Ralph 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5032 1989-01-31 1981-05-21 Wouter Ponsen Hendrik 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5033 1989-01-31 1970-06-17 Fraino Anthony J. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5034 1989-01-31 1961-06-19 Philips August 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5035 1989-01-31 1977-06-26 Hazes Jan P. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5042 1989-01-31 1971-10-21 Pennink Karel B. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5043 1989-01-31 1958-12-12 van Heemstra Frans Julius Johan 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5653 1961-02-01 1959-08-07 von Hemert A. Philippe 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
5704 1974-02-01 1971-10-21 Hoobroeckx Jan W. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
6889 1955-02-15 1953-07-30 McIntyre Philip E. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
7037 1955-02-16 1953-09-04 Hose Harold Clarence 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
7193 1959-02-18 1951-04-04 Ramsey Hobart Cole 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
7194 1959-02-18 1954-06-09 Huisingh Rudolph Onno 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
7195 1959-02-18 1957-09-06 Lind William 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8638 1960-03-01 1956-11-15 Lada-Mocarski Valerian 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8640 1961-03-01 1948-05-17 Tunell Clement Roland 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8768 1988-03-01 1982-06-02 Spriggs John S. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8785 1992-03-01 1990-03-21 Blank Aldert E. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8949 1954-03-02 1950-05-22 Barclay Thomas R. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
8950 1954-03-02 1953-06-08 Gehle William Frederick 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10050 1982-03-16 1981-11-27 van Baasbank C. J. P. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10120 1970-03-17 1968-11-13 Huntington Freeman H. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10274 1959-03-19 1955-05-23 Rand William B. , Jr. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10490 1960-03-22 1951-07-09 Vuyk Adrian 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10643 1959-03-24 1953-07-13 van Laer Johannes A. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10644 1959-03-24 1954-07-22 Recknagel John Herman 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
10721 1952-03-25 1951-04-04 Hayman Hugo H. (Henry) 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
11342 1957-03-31 1951-04-04 Tollig Leendert 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12387 1965-04-01 1958-12-03 Kiek Robert J. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12388 1965-04-01 1950-12-26 Lago Anna 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12408 1972-04-01 1951-04-04 Catz Isidor Bernhard 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12411 1972-04-01 1971-10-21 Jordan A. Kees 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12479 1988-04-01 1983-06-13 Brinckmann J. H. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12920 1965-04-08 1950-05-22 Sparks William Sidney 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12921 1965-04-08 1953-07-13 De Leur Dirk Laurens 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
12922 1965-04-08 1959-10-21 van Stolk Cornelis 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13502 1953-04-16 1952-06-04 Langdon Ilyana Agusta 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13503 1953-04-16 1950-12-26 Keesing Sebastian Hornung 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13508 1956-04-16 1953-11-16 Bake Hugo Lourens A. den Wall 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13603 1969-04-17 1965-05-17 Hooykaas Dirk Neil 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13604 1969-04-17 1963-05-24 Haley John Charles 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13605 1969-04-17 1966-07-12 LaVoie Paul Charles 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13608 1969-04-17 1967-11-13 de Jong Cornelis Hendrikus 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13609 1969-04-17 1968-11-13 Hoets Pieter Johannes 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
13610 1969-04-17 1961-11-21 Bochow John Philip 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
14173 1966-04-27 1964-05-18 Eldridge Jonathan 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15317 1971-05-01 1971-01-31 Walker Frank M. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15321 1971-05-01 1966-06-06 Schifter Marilyn 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15837 1974-05-07 1955-02-18 Wrigley Richard Dean , Jr. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15838 1974-05-07 1954-11-15 Neuman Alexander 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15886 1974-05-08 1947-04-16 Brugger Charles Walter 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15887 1974-05-08 1947-04-16 Cremer Jacob Theodor 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15888 1974-05-08 1947-04-16 Crittenden William Whitcraft 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15889 1974-05-08 1947-04-16 De Vries Enrico Marius 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15890 1974-05-08 1947-04-16 Elias Edward 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15891 1974-05-08 1947-04-16 Gomory Andrew Louis 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15892 1974-05-08 1947-04-16 Johnson Clinton Charles 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15893 1974-05-08 1947-04-16 Pennington Harold Douglas 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15894 1974-05-08 1947-04-16 Poel Arie A. der 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15895 1974-05-08 1947-04-16 Rogers Howard Joseph 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15896 1974-05-08 1947-04-16 Sheehan Charles Vincent 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15897 1974-05-08 1947-04-16 Stousland Alfred C. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15898 1974-05-08 1947-04-16 Wardburgh Russell Lawrence 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15899 1974-05-08 1947-04-16 Wierdsma Frederick W. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15900 1974-05-08 1951-05-14 Rovensky Joseph Charles 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15901 1974-05-08 1951-06-08 Fleck Gustav Peter 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15902 1974-05-08 1951-06-08 Frank Jacobus F. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15903 1974-05-08 1953-06-08 Roth Gerda Johanna Elizabeth Berman 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15904 1974-05-08 1954-06-09 van Hengel Johannes Frederik 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15905 1974-05-08 1951-07-09 van Munching Leo 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15961 1974-05-09 1962-02-23 Rau Robert 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15962 1974-05-09 1960-05-03 Greenwald Curtis H. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15963 1974-05-09 1960-05-03 de Schepper Hendrik Yssel 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15964 1974-05-09 1963-11-14 Benney Trevose Walters 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15965 1974-05-09 1963-11-14 Young Philip 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
15966 1974-05-09 1972-12-08 Marx Jean-Paul 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16047 1955-05-11 1951-06-08 de Lanoy Jan Adriaan 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16182 1974-05-13 1974-05-13 Lawrence John Mason 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16183 1974-05-13 1970-06-17 Schneider Gerhard W. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16184 1974-05-13 1971-10-21 Buchanan A. Campbell 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16185 1974-05-13 1971-10-21 van Dierendonck Joseph A. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16186 1974-05-13 1967-11-13 Moormans Willem Jan 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16187 1974-05-13 1969-11-21 Hazelhoff Robertus 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16188 1974-05-13 1969-11-21 Reurs John H. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16189 1974-05-13 1969-11-21 Schmidt Charles F. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16190 1974-05-13 1969-11-21 Von Korff Frederick E. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16316 1970-05-14 1960-05-12 Edwards Robert Lawson 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16317 1970-05-14 1963-05-15 Campbell Charles King 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16318 1970-05-14 1954-07-22 Gevers Maximilian Edward 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16319 1970-05-14 1967-11-13 Angliss Robert Joseph 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16320 1970-05-14 1953-11-16 Trimbos Constant A. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16808 1969-05-21 1959-06-24 Rasmussen Harold William 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
16809 1969-05-21 1967-11-13 Guerin Charles H. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
17116 1964-05-26 1959-06-03 Tree Alfred Edward 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
17270 1958-05-28 1957-07-24 Fosque John Drummond 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
18309 1950-06-01 1949-05-16 Orcutt Reginald 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
18322 1957-06-01 1953-06-05 O'Sullivan Patrick Pearse 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
18871 1956-06-05 1953-06-24 Hayes Alfred 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
19009 1962-06-07 1956-05-16 Koeleman Dirk Jan 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
Powered by Datasette · Queries took 9.977ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history