FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

7 rows where Country/Location_Represented = "TRANSKEI"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Foreign_Principal_Termination_Date (date)

State 2

Country/Location_Represented 1

  • TRANSKEI · 7 ✖

City 1

  • - 7
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
2336 2336 1995-02-09 Government of the Republic of Transkei 1989-04-05 TRANSKEI Pagonis & Donnelly Group, Inc. 3692 1985-06-20 Pagonis & Donnelly Group, Inc. Umtata        
3391 3391 1978-03-03 Republic of Transkei 1977-02-10 TRANSKEI Jay Parker & Associates, Inc. 2752 1977-02-10 Jay Parker & Associates, Inc. Umtata        
5130 5130 1979-04-10 Republic of Transkei 1978-01-31 TRANSKEI Katzen, Bernard 2859 1978-01-31 Katzen, Bernard Umtata        
9238 9238 1987-07-14 Government of the Republic of Transkei 1982-06-16 TRANSKEI Towsey, Kenneth Howard 3382 1982-06-16 Towsey, Kenneth Howard Umtata        
11235 11235 1979-09-01 Republic of Transkei (in the person of Minister-at-Large Ngqondi L. Masimini) 1978-03-28 TRANSKEI Smith Group 2876 1978-03-28 Smith Group Washington     DC  
13031 13031 1993-10-25 Republic of Transkei 1984-10-03 TRANSKEI Republic of Transkei, Washington Bureau 3618 1984-10-03 Republic of Transkei, Washington Bureau Umtata        
13661 13661 1983-11-02 Republic of Transkei 1977-11-02 TRANSKEI Masimini, Ngqondi L. 2842 1977-11-02 Masimini, Ngqondi L.          

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);