FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Address_1 = "Washington" and Country/Location_Represented = "SOUTH AFRICA"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 18
- Baskin & Sears, P.C. 1
- Bolan, Thomas A. 1
- C/R International, L.L.C. 1
- Covington & Burling 1
- Fleishman-Hillard, Inc. 1
- Gerstein, Albert S. 1
- Gotham Advertising Company 1
- Hallamore, Kimberley Cameron 1
- International Public Affairs Consultants, Inc. 1
- Johnson, Donald G. 1
- Law Offices of John P. Sears 1
- Philip J. Hare Law Office 1
- Public Service Audience Planners 1
- Riley, Stephen F. 1
- Sims Jr., John Rogers 1
- Smathers, Hickey & Riley 1
- United International Consultants 1
- Walter E. Fauntroy & Associates, Inc. (WEFA) 1
Foreign_Principal 10
- Republic of South Africa 5
- Embassy of South Africa 4
- Embassy of the Republic of South Africa 2
- African National Congress of South Africa (ANC) 1
- Embassy of the Union of South Africa 1
- Government of the Republic of South Africa 1
- Government of the Republic of South Africa, Embassy 1
- South African Government 1
- South African Railways & Harbours 1
- South African Resident Mission to the International Monetary Fund & Internat'l Bank for Reconstruction & Dev. 1
State 1
- DC 18
Country/Location_Represented 1
- SOUTH AFRICA · 18 ✖
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
2982 | 2982 | 1992-02-28 | Embassy of South Africa | 1985-07-10 | SOUTH AFRICA | United International Consultants 3701 | 1985-07-10 | United International Consultants | 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 | |||
4920 | 4920 | 1989-04-01 | Government of the Republic of South Africa | 1986-04-04 | SOUTH AFRICA | Bolan, Thomas A. 3807 | 1986-04-04 | Bolan, Thomas A. | Washington | DC | |||
5461 | 5461 | 1993-04-21 | Embassy of the Republic of South Africa | 1987-09-25 | SOUTH AFRICA | Johnson, Donald G. 3882 | 1986-09-12 | Johnson, Donald G. | Washington | DC | |||
6281 | 6281 | 1966-05-03 | Embassy of the Republic of South Africa | 1965-09-27 | SOUTH AFRICA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
7153 | 7153 | 1996-05-31 | Embassy of South Africa | 1996-04-24 | SOUTH AFRICA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
7372 | 7372 | 1979-06-01 | South African Resident Mission to the International Monetary Fund & Internat'l Bank for Reconstruction & Dev. | 1975-02-06 | SOUTH AFRICA | Gerstein, Albert S. 2558 | 1975-02-06 | Gerstein, Albert S. | 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 | |||
9308 | 9308 | 1996-07-16 | South African Government | 1992-04-29 | SOUTH AFRICA | Riley, Stephen F. 4657 | 1992-04-29 | Riley, Stephen F. | Washington | DC | |||
10680 | 10680 | 1992-08-23 | Embassy of South Africa | 1983-03-11 | SOUTH AFRICA | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | Washington | DC | |||
11993 | 11993 | 1988-09-30 | Embassy of South Africa | 1985-09-10 | SOUTH AFRICA | International Public Affairs Consultants, Inc. 3730 | 1986-05-13 | International Public Affairs Consultants, Inc. | Washington | DC | |||
12568 | 12568 | 1992-10-09 | African National Congress of South Africa (ANC) | 1991-11-05 | SOUTH AFRICA | Walter E. Fauntroy & Associates, Inc. (WEFA) 4587 | 1991-11-05 | Walter E. Fauntroy & Associates, Inc. (WEFA) | Washington | DC | |||
13366 | 13366 | 1997-10-31 | Government of the Republic of South Africa, Embassy | 1996-07-16 | SOUTH AFRICA | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | Washington | DC | |||
14613 | 14613 | 1958-12-01 | Embassy of the Union of South Africa | 1957-06-07 | SOUTH AFRICA | Sims Jr., John Rogers 1034 | 1957-06-07 | Sims Jr., John Rogers | Washington | DC | |||
15009 | 15009 | 1950-12-11 | South African Railways & Harbours | 1944-02-10 | SOUTH AFRICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 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]) );