FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

32 rows where Country/Location_Represented = "SOUTH AFRICA" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

City 2

State 1

Country/Location_Represented 1

  • SOUTH AFRICA · 32 ✖
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
820 820 1974-01-01 Khmer Republic 1973-11-27 SOUTH AFRICA Warren Weil Public Relations 1530 1962-03-23 Warren Weil Public Relations       NY  
826 826 1978-01-01 South African Consulate General 1977-10-12 SOUTH AFRICA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
834 834 1980-01-01 South African Mission to the United Nations 1979-12-26 SOUTH AFRICA Patrick & Associates 2984 1978-12-06 Patrick & Associates New York     NY  
1441 1441 1970-01-21 South West Africa National United Front 1966-04-07 SOUTH AFRICA Mbaeva, Nathaniel Veiue 1975 1966-04-07 Mbaeva, Nathaniel Veiue New York     NY  
2052 2052 1995-02-01 South African Tourism Board 1994-12-20 SOUTH AFRICA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
2133 2133 1961-02-03 South Africa Tourist Corporation 1951-01-31 SOUTH AFRICA Caples Company 34 1943-03-03 Caples Company New York     NY  
2239 2239 1978-02-06 Information Service of South Africa 1971-08-24 SOUTH AFRICA Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
2469 2469 1971-02-14 Government Information Service of South Africa 1963-02-12 SOUTH AFRICA Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
2477 2477 1971-02-14 South African Tourist Corporation 1963-02-12 SOUTH AFRICA Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
2925 2925 1978-02-28 South African Tourist Corporation 1971-08-13 SOUTH AFRICA Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
3181 3181 2016-02-29 South African Tourism 2013-08-07 SOUTH AFRICA Coyne Public Relations, LLC 6177 2013-08-07 Coyne Public Relations, LLC 500 5th Avenue, 20th Floor Suite 2040 New York NY 10110
3522 3522 1984-03-08 International Gold Corporation, Ltd. (a New York Corporation) 1983-09-08 SOUTH AFRICA Rubenstein, Wolfson & Company, Inc. 3517 1983-09-08 Rubenstein, Wolfson & Company, Inc. New York     NY  
4089 4089 1995-03-27 South African Department of Trade & Industry 1994-10-28 SOUTH AFRICA Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. New York     NY  
4224 4224 1995-03-30 South Africa Foundation 1968-11-21 SOUTH AFRICA South Africa Foundation 2111 1968-11-21 South Africa Foundation New York     NY  
4834 4834 1960-04-01 Government of the Union of South Africa (South Africa Railways) 1954-07-22 SOUTH AFRICA Caples Company 34 1943-03-03 Caples Company New York     NY  
5001 5001 1985-04-03 Consulate General of South Africa 1978-12-08 SOUTH AFRICA Perry, Marilyn Edith 2731 1976-10-27 Perry, Marilyn Edith New York     NY  
5044 5044 2001-04-05 South African Tourism (SATOUR) 2000-06-09 SOUTH AFRICA Peter Martin Associates, Inc. 4236 1989-04-05 Peter Martin Associates, Inc. SATOUR 500 Fifth Avenue New York 10110     NY  
5195 5195 1984-04-12 South African Tourist Office 1980-05-21 SOUTH AFRICA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5207 5207 1986-04-12 Embassy of South Africa 1984-11-13 SOUTH AFRICA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
7483 7483 1966-06-02 South African Tourist Corporation 1961-08-01 SOUTH AFRICA Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
8232 8232 1957-06-30 Union of South Africa Government Information Bureau 1946-04-22 SOUTH AFRICA Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
9381 9381 1994-07-20 Government of South Africa 1992-10-02 SOUTH AFRICA Marston Webb & Associates, Inc. 4209 1989-01-24 Marston Webb & Associates, Inc. New York     NY  
10692 10692 1992-08-23 South African Tourism Board 1978-03-01 SOUTH AFRICA Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
11066 11066 1999-08-31 South African Tourism Board 1993-03-12 SOUTH AFRICA Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
11887 11887 1960-09-29 South Africa Tourist Bureau 1960-06-16 SOUTH AFRICA Broadcast Planning Corporation 1371 1960-06-16 Broadcast Planning Corporation New York     NY  
12955 12955 1985-10-23 Chamber of Mines of South Africa 1985-02-15 SOUTH AFRICA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13414 13414 2003-10-31 South African Tourism 2001-04-13 SOUTH AFRICA Patrice Tanaka & Company, Inc. 5426 2001-04-13 Patrice Tanaka & Company, Inc. 500 Fifth Avenue New York 10110     NY  
14642 14642 1973-12-01 South African Tourist Corporation 1967-10-16 SOUTH AFRICA Schoenfeld Film Distribution Corporation 2056 1967-10-16 Schoenfeld Film Distribution Corporation       NY  
14649 14649 1975-12-01 Information Service of South Africa 1974-12-31 SOUTH AFRICA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
14859 14859 1946-12-07 Union of South Africa Government Information Office 1946-04-10 SOUTH AFRICA Groen, Maurice T. 351 1946-04-10 Groen, Maurice T. New York     NY  
15205 15205 1984-12-18 Information Service of South Africa 1975-12-19 SOUTH AFRICA Image Industries, Inc. 2643 1975-12-19 Image Industries, Inc. New York     NY  
15207 15207 1985-12-18 International Gold Corporation, Ltd. (a New York Corporation) 1983-06-15 SOUTH AFRICA Kilpatrick & Lockhart 3486 1983-06-15 Kilpatrick & Lockhart New York     NY  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_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])
);