FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Foreign_Principal = "Republic of South Africa" sorted by State
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- BMW Government Relations LLC 1
- Baron/Canning & Company, Inc. 1
- Baskin & Sears, P.C. 1
- Bill Hecht & Associates, Inc. 1
- Global Philatelic Agency, Ltd. 1
- Hallamore, Kimberley Cameron 1
- Johnson, Donald G. 1
- Law Offices of John P. Sears 1
- Philip J. Hare Law Office 1
- Riley & Fox, Inc. 1
- Smathers, Hickey & Riley 1
- Spencer-Roberts & Associates, Inc. 1
- White & Case, LLP 1
Foreign_Principal_Registration_Date 12 ✖
- 1983-02-18 2
- 1974-03-12 1
- 1976-03-18 1
- 1980-04-08 1
- 1980-04-11 1
- 1981-01-06 1
- 1984-05-09 1
- 1986-04-11 1
- 1986-09-12 1
- 1987-10-27 1
- 2006-05-31 1
- 2023-04-16 1
Foreign_Principal 1
- Republic of South Africa · 13 ✖
Country/Location_Represented 1
- SOUTH AFRICA 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
595 | 595 | Republic of South Africa | 2023-04-16 | SOUTH AFRICA | BMW Government Relations LLC 7258 | 2023-04-16 | BMW Government Relations LLC | Tourism House, 17 Trevenna Street Sunnyside | 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 | ||||
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 | ||||
4522 | 4522 | 1992-03-31 | Republic of South Africa | 1986-04-11 | SOUTH AFRICA | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. | |||||
4666 | 4666 | 2006-03-31 | Republic of South Africa | 2006-05-31 | SOUTH AFRICA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 399 Duncan Street | Hatfield 0083 | |||
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 | ||||
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. | |||||
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 | ||||
1129 | 1129 | 1993-01-07 | Republic of South Africa | 1984-05-09 | SOUTH AFRICA | Law Offices of John P. Sears 3584 | 1984-05-09 | Law Offices of John P. Sears | Washington | DC | |||
3270 | 3270 | 1984-03-01 | Republic of South Africa | 1981-01-06 | SOUTH AFRICA | Baskin & Sears, P.C. 3184 | 1981-01-06 | Baskin & Sears, P.C. | Washington | DC | |||
4417 | 4417 | 1984-03-31 | Republic of South Africa | 1980-04-08 | SOUTH AFRICA | Hallamore, Kimberley Cameron 3098 | 1980-04-08 | Hallamore, Kimberley Cameron | Washington | DC | |||
7962 | 7962 | 1990-06-20 | Republic of South Africa | 1987-10-27 | SOUTH AFRICA | Philip J. Hare Law Office 3974 | 1987-05-07 | Philip J. Hare Law Office | Washington | DC | |||
8863 | 8863 | 1986-07-01 | Republic of South Africa | 1980-04-11 | SOUTH AFRICA | Smathers, Hickey & Riley 3099 | 1980-04-11 | Smathers, Hickey & Riley | Washington | DC |
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]) );