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

65 rows where Registration_Number = 603 and State = "NY"

✎ 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

  • 603 · 65 ✖

Registrant_Name

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
331 331   2017-02-23 Masisi Keabetswe Bangu 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
528 528   2018-03-23 Forde Najae-Vianni 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
938 938   2009-05-19 Barnette Justin 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
939 939   2009-05-19 Dionisio Virginia M. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
940 940   2009-05-19 George Maya 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
1479 1479   2016-08-09 Angellitti Kristy 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
1510 1510   2010-08-20 Pillay Judy 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
3108 3108 1987-01-05 1982-07-07 Albertyn Jean Laurie 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
3355 3355 1975-01-10 1971-05-26 Blokker W.J.M. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
4370 4370 1966-01-27 1965-07-30 Stathakis Nicholas Aris 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
4371 4371 1966-01-27 1965-07-30 Wannenburg Dawn Patricia 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
4676 4676 1969-01-31 1952-02-01 West Warren Fox 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
7483 7483 1985-02-28 1983-07-18 Botha Stephanus 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
8225 8225 1983-03-01 1980-07-21 Hawtayne Jean M. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
8233 8233 1985-03-01 1972-07-31 Stathakis Nicholas A. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
9556 9556 1997-03-17 1996-11-01 Gobodo Vuyani 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
10367 10367 2014-03-28 2010-04-15 DiGregorio David 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
10470 10470 1951-03-30 1950-08-17 Moylen Frances Margaret 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
10703 10703 1953-03-31 1950-08-17 Siebert Esme 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
11046 11046 1992-03-31 1984-08-17 van Zyl Albertus 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
11561 11561 2017-03-31 2017-02-23 Gioia Victoria 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
13291 13291 2009-04-25 2009-05-19 Grogver Adel 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
13622 13622 1967-04-30 1965-09-10 Jacobs Dirk Johannes 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
13647 13647 1973-04-30 1969-03-03 Oelofse Aletta Sysanna Magdalena 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
14133 14133 2008-04-30 2004-05-20 Prinsloo Christoffel P. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
14701 14701 1955-05-04 1954-08-02 Jeffries Peter James 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
16520 16520 1964-05-31 1964-03-11 McDougall Maud 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
16593 16593 1982-05-31 1980-07-21 Barnard Leon F. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
17654 17654 1970-06-04 1965-07-30 Coetzee Anna Catherine 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
18404 18404 2012-06-15 2010-08-20 Jacobberger Dean 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
19182 19182 1952-06-28 1950-01-04 Armstrong Reginald Bernard 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
20266 20266 2004-06-30 2004-05-20 Moeng Nicodemus Solly 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
20271 20271 2004-06-30 2002-07-26 Walsh John 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
20737 20737 1966-07-01 1964-06-09 Davis Samuel 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
21187 21187 1952-07-04 1950-08-17 Smith Ethel Marion 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
21188 21188 1952-07-04 1950-08-17 Waldron Jeanne Anne 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
23014 23014 1979-07-30 1974-09-27 van Rooyen Thana 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
23242 23242 1980-07-31 1979-08-07 Spies Hendrik Tertius 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
23540 23540 2002-07-31 1996-11-01 Komani Blacky 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
23541 23541 2002-07-31 1996-11-01 Padima Raymond 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
24921 24921 1994-08-12 1985-06-28 Steyn Nicolaas Phillipus Jacobus 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
26086 26086 1973-08-30 1971-05-26 Moolman Jeanette Marion 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
27390 27390 1971-09-03 1956-07-30 Pearson Oscar Edward 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
28233 28233 2015-09-16 2009-05-19 Zungu Sphakamile Sthuthukile 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
28356 28356 2008-09-19 2008-04-09 Parker Deborah 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
28635 28635 2004-09-24 2004-05-20 Ackerman Jill 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
31903 31903 1953-10-29 1950-08-17 Tait Roma Eugenie 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
32133 32133 1987-10-30 1981-02-17 De Plessis Eduard C.H. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
32217 32217 1963-10-31 1962-06-25 Mrak Dusan 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
33901 33901 1962-11-16 1959-02-02 Siebert Esme 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
34597 34597 1985-11-30 1984-08-13 Botha Louis R. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
36355 36355 1951-12-18 1950-01-04 Brennan Andrew Thomas 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
37076 37076 1970-12-30 1968-02-08 Joubert Adrianus Johannes 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
37656 37656 1971-12-31 1971-05-26 Pearson Oscar E. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
37743 37743 1975-12-31 1974-07-27 Gould Leslie 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
37825 37825 1978-12-31 1973-02-23 Smith David Warden 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
37885 37885 1980-12-31 1964-03-11 Schoeman Cathy Petrolina 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
38008 38008 1983-12-31 1980-02-07 Durie Alan Noel 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
38009 38009 1983-12-31 1981-02-17 Burger John H. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
38041 38041 1984-12-31 1976-03-31 Pretorius Goodale 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
38269 38269 1988-12-31 1985-07-19 Dargie Robert Gavin 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
38325 38325 1989-12-31 1988-04-29 Garstang Richard 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
38336 38336 1989-12-31 1985-06-28 Jackson Michael G.D. 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
39167 39167 2005-12-31 2004-05-20 Bateman John 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
39788 39788 2016-12-31 2008-04-09 Saeger Laura 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002

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 381.541ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history