FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Address_1 = "Johannesburg"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 21
- Shearman & Sterling 2
- APCO Worldwide, Inc. 1
- Anchor, Clifford James 1
- Bernard Relin Associates 1
- Busby, Rehm & Leonard, P.C. 1
- C/R International, L.L.C. 1
- Fraser Associates, Inc. 1
- Freedman, Levy, Kroll & Simonds 1
- Gotham Advertising Company 1
- Hall, John C. 1
- Harty, Richard J. 1
- INFOPRENEURS 1
- Kilmarx, Robert A. 1
- Lord Day & Lord, Barrett Smith 1
- Manning, Selvage & Lee 1
- Molotsi, Peter H. 1
- Public Service Audience Planners 1
- Rech, R. Elizabeth 1
- Riley & Fox, Inc. 1
- Samancor Foundation, U.S.A. 1
- Streicher, Pieter E. 1
Registrant_Date (date) 19 ✖
- 1965-04-05 2
- 1978-10-02 2
- 1994-02-02 2
- 1942-07-08 1
- 1946-05-27 1
- 1964-05-13 1
- 1969-05-12 1
- 1977-11-08 1
- 1978-06-27 1
- 1979-08-23 1
- 1986-04-11 1
- 1986-05-19 1
- 1988-03-15 1
- 1990-10-10 1
- 1991-09-03 1
- 1992-06-10 1
- 1992-10-08 1
- 1993-08-06 1
- 1996-07-02 1
Foreign_Principal 16
- Chamber of Mines of South Africa 5
- Ferro Alloy Producers' Association of South Africa 3
- ASA, Ltd. (formerly American-South African Investment Company, Ltd.) 1
- African National Congress 1
- American-South African Investment Company, Ltd. 1
- Anderson, Wilson & Partners, Inc. 1
- International Gold Corporation 1
- Kagiso Trust 1
- National Clothing Federation of South Africa 1
- New Clewer House 1
- Pan-Africanist Congress, South Africa 1
- Progressive Alliance 1
- Publicity & Travel Department 1
- Samancor Foundation 1
- South African Airways 1
- South African Broadcasting Corporation 1
Country/Location_Represented 2
- SOUTH AFRICA 21
- SAUDI ARABIA 1
State 1
- - 22
City 1
- - 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1209 | 1209 | 1988-01-11 | Ferro Alloy Producers' Association of South Africa | 1980-10-08 | SOUTH AFRICA | Busby, Rehm & Leonard, P.C. 2923 | 1978-06-27 | Busby, Rehm & Leonard, P.C. | Johannesburg | ||||
2328 | 2328 | 1991-02-09 | Progressive Alliance | 1990-10-10 | SOUTH AFRICA | Harty, Richard J. 4427 | 1990-10-10 | Harty, Richard J. | Johannesburg | ||||
4512 | 4512 | 1992-03-31 | Chamber of Mines of South Africa | 1989-06-12 | SOUTH AFRICA | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. | Johannesburg | ||||
4549 | 4549 | 1996-03-31 | Chamber of Mines of South Africa | 1994-02-02 | SOUTH AFRICA | Rech, R. Elizabeth 4890 | 1994-02-02 | Rech, R. Elizabeth | Johannesburg | ||||
5159 | 5159 | 1977-04-11 | ASA, Ltd. (formerly American-South African Investment Company, Ltd.) | 1974-04-17 | SOUTH AFRICA | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | Johannesburg | ||||
5344 | 5344 | 1974-04-17 | American-South African Investment Company, Ltd. | 1969-10-29 | SOUTH AFRICA | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | Johannesburg | ||||
5938 | 5938 | 1993-04-30 | Samancor Foundation | 1992-10-08 | SOUTH AFRICA | Samancor Foundation, U.S.A. 4715 | 1992-10-08 | Samancor Foundation, U.S.A. | Johannesburg | ||||
7782 | 7782 | 1983-06-13 | Ferro Alloy Producers' Association of South Africa | 1978-10-02 | SOUTH AFRICA | Streicher, Pieter E. 2962 | 1978-10-02 | Streicher, Pieter E. | Johannesburg | ||||
8122 | 8122 | 1952-06-27 | New Clewer House | 1947-06-25 | SOUTH AFRICA | Bernard Relin Associates 359 | 1946-05-27 | Bernard Relin Associates | Johannesburg | ||||
8847 | 8847 | 1977-07-01 | International Gold Corporation | 1973-08-23 | SAUDI ARABIA | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | Johannesburg | ||||
9237 | 9237 | 1983-07-14 | Ferro Alloy Producers' Association of South Africa | 1978-10-02 | SOUTH AFRICA | Hall, John C. 2961 | 1978-10-02 | Hall, John C. | Johannesburg | ||||
9784 | 9784 | 1991-07-31 | Chamber of Mines of South Africa | 1988-04-11 | SOUTH AFRICA | Freedman, Levy, Kroll & Simonds 4117 | 1988-03-15 | Freedman, Levy, Kroll & Simonds | Johannesburg | ||||
9837 | 9837 | 2002-07-31 | Chamber of Mines of South Africa | 1996-08-14 | SOUTH AFRICA | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | Johannesburg | ||||
10526 | 10526 | 1986-08-15 | National Clothing Federation of South Africa | 1986-05-19 | SOUTH AFRICA | Kilmarx, Robert A. 3833 | 1986-05-19 | Kilmarx, Robert A. | Johannesburg | ||||
11773 | 11773 | 1970-09-23 | Pan-Africanist Congress, South Africa | 1969-05-12 | SOUTH AFRICA | Molotsi, Peter H. 2135 | 1969-05-12 | Molotsi, Peter H. | Johannesburg | ||||
11898 | 11898 | 1995-09-29 | Kagiso Trust | 1994-03-01 | SOUTH AFRICA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Johannesburg | ||||
12335 | 12335 | 1982-10-01 | Anderson, Wilson & Partners, Inc. | 1981-09-10 | SOUTH AFRICA | Fraser Associates, Inc. 2844 | 1977-11-08 | Fraser Associates, Inc. | Johannesburg | ||||
12633 | 12633 | 1993-10-12 | African National Congress | 1993-08-06 | SOUTH AFRICA | INFOPRENEURS 4843 | 1993-08-06 | INFOPRENEURS | Johannesburg | ||||
12695 | 12695 | 1965-10-15 | South African Broadcasting Corporation | 1964-05-13 | SOUTH AFRICA | Anchor, Clifford James 1729 | 1964-05-13 | Anchor, Clifford James | Johannesburg | ||||
13332 | 13332 | 1994-10-31 | Chamber of Mines of South Africa | 1994-02-02 | SOUTH AFRICA | Lord Day & Lord, Barrett Smith 4889 | 1994-02-02 | Lord Day & Lord, Barrett Smith | Johannesburg | ||||
15007 | 15007 | 1950-12-11 | Publicity & Travel Department | 1942-07-08 | SOUTH AFRICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Johannesburg | ||||
15142 | 15142 | 1996-12-15 | South African Airways | 1995-05-17 | SOUTH AFRICA | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | Johannesburg |
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]) );