FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where Address_1 = "" and Country/Location_Represented = "SOUTH AFRICA"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 25
- Modern Education Services, Inc. 4
- North American Precis Syndicate 3
- Riley & Fox, Inc. 2
- deKieffer & Associates, P.C. 2
- Brenner, Arthur E.K. 1
- Brenner, Gertrude B. 1
- Burns, Jackson, Miller, Summit & Jacoby 1
- Clinton E. Frank, Inc., New York 1
- Collier, Shannon, Rill, Edwards & Scott 1
- FD Dittus Communications 1
- Gotham Advertising Company 1
- Hahn, Lorna 1
- International Gold Corporation 1
- Jay Parker & Associates, Inc. 1
- Muundjua, Festus U. 1
- Paladin Public Relations, Inc. 1
- Pearson & Pipkin, Inc. 1
- Plaia & Schaumberg, Chartered 1
- Provisional Government of Namibia 1
- Riruako, Kuaima Isaac 1
- Ross, Leo 1
- Schoenfeld Film Distribution Corporation 1
- Spencer-Roberts & Associates, Inc. 1
- Surrey & Morse 1
- Warren Weil Public Relations 1
Registrant_Date (date) 25 ✖
- 1964-10-19 4
- 1977-10-12 3
- 1978-01-17 2
- 1986-04-11 2
- 1942-07-08 1
- 1955-07-19 1
- 1962-03-23 1
- 1963-02-25 1
- 1967-08-23 1
- 1967-10-16 1
- 1970-11-09 1
- 1974-03-12 1
- 1976-01-05 1
- 1976-02-24 1
- 1976-08-31 1
- 1979-05-10 1
- 1980-12-08 1
- 1981-04-08 1
- 1981-04-15 1
- 1981-10-21 1
- 1982-03-02 1
- 1983-02-18 1
- 1983-06-15 1
- 1985-08-29 1
- 2008-09-12 1
Foreign_Principal 25
- South African Tourist Corporation 3
- Chamber of Mines of South Africa 2
- Department of Information, Republic of South Africa 2
- Embassy of South Africa 2
- National Unity Democratic Organization 2
- Republic of South Africa 2
- Anglo-American Corporation of South Africa, Ltd. 1
- Bureau of National & International Communications, Republic of South Africa 1
- Christian League of Southern Africa 1
- Christian League of Southern Africa (Encounter Press & Publishing Company) 1
- Embassy of South Africa (Through International Public Affairs Consultants, Inc.) 1
- Frans Meisenholl 1
- Global News Service 1
- International Gold Corporation, Ltd. 1
- Khmer Republic 1
- L.A. Van Selm, Ltd. 1
- National Cultural Liberation Movement 1
- South African Consulate General 1
- South African Government 1
- South African Sugar Association 1
- South African Tourism - Wendy Tlou 1
- South African Tourist Office 1
- South West Africa National United Front 1
- South West African National Union 1
- Union of South Africa 1
Country/Location_Represented 1
- SOUTH AFRICA · 32 ✖
City 1
- - 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 | ||||
840 | 840 | 1982-01-01 | Anglo-American Corporation of South Africa, Ltd. | 1965-05-20 | SOUTH AFRICA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
1091 | 1091 | 1978-01-06 | Department of Information, Republic of South Africa | 1974-03-12 | SOUTH AFRICA | Collier, Shannon, Rill, Edwards & Scott 2504 | 1974-03-12 | Collier, Shannon, Rill, Edwards & Scott | |||||
2353 | 2353 | 1986-02-10 | South African Sugar Association | 1984-01-17 | SOUTH AFRICA | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | |||||
2936 | 2936 | 1983-02-28 | National Cultural Liberation Movement | 1982-03-02 | SOUTH AFRICA | Hahn, Lorna 3339 | 1982-03-02 | Hahn, Lorna | |||||
3760 | 3760 | 1979-03-15 | National Unity Democratic Organization | 1976-02-24 | SOUTH AFRICA | Riruako, Kuaima Isaac 2662 | 1976-02-24 | Riruako, Kuaima Isaac | |||||
4367 | 4367 | 1978-03-31 | National Unity Democratic Organization | 1976-08-31 | SOUTH AFRICA | Burns, Jackson, Miller, Summit & Jacoby 2718 | 1976-08-31 | Burns, Jackson, Miller, Summit & Jacoby | |||||
4501 | 4501 | 1991-03-31 | Embassy of South Africa | 1985-08-29 | SOUTH AFRICA | Pearson & Pipkin, Inc. 3727 | 1985-08-29 | Pearson & Pipkin, Inc. | |||||
4503 | 4503 | 1991-03-31 | Global News Service | 1987-07-13 | SOUTH AFRICA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
4522 | 4522 | 1992-03-31 | Republic of South Africa | 1986-04-11 | SOUTH AFRICA | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. | |||||
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 | ||||
6447 | 6447 | 1966-05-11 | South African Tourist Corporation | 1964-10-19 | SOUTH AFRICA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
8253 | 8253 | 1966-06-30 | South African Tourist Corporation | 1966-03-31 | SOUTH AFRICA | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | |||||
8848 | 8848 | 1978-07-01 | Department of Information, Republic of South Africa | 1978-01-17 | SOUTH AFRICA | deKieffer & Associates, P.C. 2857 | 1978-01-17 | deKieffer & Associates, P.C. | |||||
9197 | 9197 | 1983-07-12 | Christian League of Southern Africa | 1981-01-27 | SOUTH AFRICA | Brenner, Arthur E.K. 3188 | 1980-12-08 | Brenner, Arthur E.K. | |||||
9328 | 9328 | 1986-07-17 | International Gold Corporation, Ltd. | 1983-06-15 | SOUTH AFRICA | International Gold Corporation 3482 | 1983-06-15 | International Gold Corporation | |||||
9651 | 9651 | 1957-07-31 | Union of South Africa | 1955-07-19 | SOUTH AFRICA | Ross, Leo 901 | 1955-07-19 | Ross, Leo | DC | ||||
9723 | 9723 | 1979-07-31 | Bureau of National & International Communications, Republic of South Africa | 1978-12-14 | SOUTH AFRICA | deKieffer & Associates, P.C. 2857 | 1978-01-17 | deKieffer & Associates, P.C. | |||||
10233 | 10233 | 1988-08-09 | Chamber of Mines of South Africa | 1987-12-23 | SOUTH AFRICA | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. | |||||
10821 | 10821 | 1969-08-29 | South West African National Union | 1967-08-23 | SOUTH AFRICA | Muundjua, Festus U. 2040 | 1967-08-23 | Muundjua, Festus U. | |||||
11245 | 11245 | 1983-09-01 | Republic of South Africa | 1983-02-18 | SOUTH AFRICA | Spencer-Roberts & Associates, Inc. 3446 | 1983-02-18 | Spencer-Roberts & Associates, Inc. | |||||
11432 | 11432 | 1988-09-08 | Embassy of South Africa (Through International Public Affairs Consultants, Inc.) | 1986-05-13 | SOUTH AFRICA | Jay Parker & Associates, Inc. 3227 | 1981-04-15 | Jay Parker & Associates, Inc. | |||||
12341 | 12341 | 1984-10-01 | Frans Meisenholl | 1983-11-23 | SOUTH AFRICA | Plaia & Schaumberg, Chartered 3223 | 1981-04-08 | Plaia & Schaumberg, Chartered | |||||
12486 | 12486 | 1973-10-05 | South West Africa National United Front | 1970-11-09 | SOUTH AFRICA | Provisional Government of Namibia 2218 | 1970-11-09 | Provisional Government of Namibia | |||||
12889 | 12889 | 1981-10-21 | L.A. Van Selm, Ltd. | 1981-10-21 | SOUTH AFRICA | Paladin Public Relations, Inc. 3293 | 1981-10-21 | Paladin Public Relations, Inc. | |||||
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 | ||||
13861 | 13861 | 1980-11-10 | Christian League of Southern Africa (Encounter Press & Publishing Company) | 1979-05-10 | SOUTH AFRICA | Brenner, Gertrude B. 3018 | 1979-05-10 | Brenner, Gertrude B. | |||||
14533 | 14533 | 2008-11-30 | South African Tourism - Wendy Tlou | 2008-09-12 | SOUTH AFRICA | FD Dittus Communications 5881 | 2008-09-12 | FD Dittus Communications | |||||
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 | ||||
15008 | 15008 | 1950-12-11 | South African Government | 1942-07-08 | SOUTH AFRICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | |||||
15869 | 15869 | 1981-12-31 | South African Consulate General | 1981-06-19 | SOUTH AFRICA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. |
Advanced export
JSON shape: default, array, newline-delimited
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]) );