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

View and edit SQL

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
353   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
554   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
967   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
968   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
969   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
1425   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
1460   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
3092 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
3339 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
4353 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
4354 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
4655 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
7457 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
8195 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
8203 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
9525 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
10335 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
10438 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
10671 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
11014 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
11529 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
13256 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
13578 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
13603 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
14089 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
14645 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
16457 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
16530 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
17589 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
18334 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
19112 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
20196 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
20201 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
20660 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
21109 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
21110 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
22936 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
23164 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
23462 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
23463 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
24843 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
26008 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
27312 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
28155 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
28278 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
28555 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
31820 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
32050 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
32134 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
33814 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
34509 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
36259 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
36978 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
37557 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
37644 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
37726 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
37786 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
37909 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
37910 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
37942 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
38170 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
38226 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
38237 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
39068 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
39689 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 371.386ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history