FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
68 rows where Registration_Number = 603
This data as json, CSV (advanced)
State 1
- NY 35
Registration_Number 1
- South African Tourism · 35 ✖
Registrant_Name 1
City 1
- New York 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22060 | 22060 | 1966-07-01 | 1964-06-09 | Davis | Samuel | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
22555 | 22555 | 1952-07-04 | 1950-08-17 | Smith | Ethel Marion | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
22556 | 22556 | 1952-07-04 | 1950-08-17 | Waldron | Jeanne Anne | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
24480 | 24480 | 1979-07-30 | 1974-09-27 | van Rooyen | Thana | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
24711 | 24711 | 1980-07-31 | 1979-08-07 | Spies | Hendrik Tertius | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
25009 | 25009 | 2002-07-31 | 1996-11-01 | Komani | Blacky | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
25010 | 25010 | 2002-07-31 | 1996-11-01 | Padima | Raymond | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
26503 | 26503 | 1994-08-12 | 1985-06-28 | Steyn | Nicolaas Phillipus Jacobus | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
27742 | 27742 | 1973-08-30 | 1971-05-26 | Moolman | Jeanette Marion | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
29095 | 29095 | 1971-09-03 | 1956-07-30 | Pearson | Oscar Edward | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
29655 | 29655 | 2018-09-12 | 2018-03-23 | Forde | Najae-Vianni | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
29962 | 29962 | 2015-09-16 | 2009-05-19 | Zungu | Sphakamile Sthuthukile | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
30090 | 30090 | 2008-09-19 | 2008-04-09 | Parker | Deborah | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
30384 | 30384 | 2004-09-24 | 2004-05-20 | Ackerman | Jill | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
33822 | 33822 | 1953-10-29 | 1950-08-17 | Tait | Roma Eugenie | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
34057 | 34057 | 1987-10-30 | 1981-02-17 | De Plessis | Eduard C.H. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
34147 | 34147 | 1963-10-31 | 1962-06-25 | Mrak | Dusan | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
35933 | 35933 | 1962-11-16 | 1959-02-02 | Siebert | Esme | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
36496 | 36496 | 2019-11-27 | 2009-05-19 | George | Maya | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
36676 | 36676 | 1985-11-30 | 1984-08-13 | Botha | Louis R. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
38577 | 38577 | 1951-12-18 | 1950-01-04 | Brennan | Andrew Thomas | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
39311 | 39311 | 1970-12-30 | 1968-02-08 | Joubert | Adrianus Johannes | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
39896 | 39896 | 1971-12-31 | 1971-05-26 | Pearson | Oscar E. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
39983 | 39983 | 1975-12-31 | 1974-07-27 | Gould | Leslie | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40065 | 40065 | 1978-12-31 | 1973-02-23 | Smith | David Warden | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40125 | 40125 | 1980-12-31 | 1964-03-11 | Schoeman | Cathy Petrolina | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40248 | 40248 | 1983-12-31 | 1980-02-07 | Durie | Alan Noel | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40249 | 40249 | 1983-12-31 | 1981-02-17 | Burger | John H. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40281 | 40281 | 1984-12-31 | 1976-03-31 | Pretorius | Goodale | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40509 | 40509 | 1988-12-31 | 1985-07-19 | Dargie | Robert Gavin | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40565 | 40565 | 1989-12-31 | 1988-04-29 | Garstang | Richard | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40576 | 40576 | 1989-12-31 | 1985-06-28 | Jackson | Michael G.D. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
41408 | 41408 | 2005-12-31 | 2004-05-20 | Bateman | John | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
42032 | 42032 | 2016-12-31 | 2008-04-09 | Saeger | Laura | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
42191 | 42191 | 2018-12-31 | 2009-05-19 | Dionisio | Virginia M. | South African Tourism 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
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]) );