FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Address_1 = "Pretoria"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 10
Registrant_Date (date) 10 ✖
- 1971-07-23 2
- 1954-04-16 1
- 1959-09-15 1
- 1974-03-12 1
- 1974-09-27 1
- 1975-10-15 1
- 1983-02-18 1
- 1986-09-12 1
- 1989-09-13 1
- 1997-04-01 1
Foreign_Principal 8
State 1
- - 11
Country/Location_Represented 1
- SOUTH AFRICA 11
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2308 | 2308 | 1956-02-09 | Government of the Union of South Africa | 1954-04-16 | SOUTH AFRICA | Krock-Erwin Associates, Inc. 823 | 1954-04-16 | Krock-Erwin Associates, Inc. | Pretoria | ||||
4379 | 4379 | 1980-03-31 | Republic of South Africa | 1976-03-18 | SOUTH AFRICA | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | Pretoria | ||||
4384 | 4384 | 1981-03-31 | Information Service of South Africa | 1979-05-18 | SOUTH AFRICA | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | Pretoria | ||||
4424 | 4424 | 1985-03-31 | Republic of South Africa | 1983-02-18 | SOUTH AFRICA | Bill Hecht & Associates, Inc. 3445 | 1983-02-18 | Bill Hecht & Associates, Inc. | Pretoria | ||||
5466 | 5466 | 1993-04-21 | South African Tourism Board | 1975-10-15 | SOUTH AFRICA | Celliers, Peter J. 2617 | 1975-10-15 | Celliers, Peter J. | Pretoria | ||||
5961 | 5961 | 1997-04-30 | South African National Defense Force | 1997-04-01 | SOUTH AFRICA | Kornegay, Francis Albert, Jr. 5168 | 1997-04-01 | Kornegay, Francis Albert, Jr. | Pretoria | ||||
6470 | 6470 | 1977-05-12 | Republic of South Africa | 1974-03-12 | SOUTH AFRICA | Global Philatelic Agency, Ltd. 2505 | 1974-03-12 | Global Philatelic Agency, Ltd. | Pretoria | ||||
11616 | 11616 | 1962-09-15 | Reserve Bank of South Africa | 1959-09-15 | SOUTH AFRICA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Pretoria | ||||
11818 | 11818 | 1989-09-25 | Patriot | 1989-09-13 | SOUTH AFRICA | Finzer & Richardson 4290 | 1989-09-13 | Finzer & Richardson | Pretoria | ||||
11853 | 11853 | 1980-09-27 | Department of Information of the Republic of South Africa | 1974-09-27 | SOUTH AFRICA | South African Information Office 2535 | 1974-09-27 | South African Information Office | Pretoria | ||||
13244 | 13244 | 1986-10-31 | Republic of South Africa | 1986-09-12 | SOUTH AFRICA | Johnson, Donald G. 3882 | 1986-09-12 | Johnson, Donald G. | Pretoria |
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]) );