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

9 rows where Registrant_Name = "Susan Davis International & Public Affairs" and Registration_Number = 3444

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented 8

State 2

Registrant_Name 1

  • Susan Davis International & Public Affairs · 9 ✖

City 1

  • - 9
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
1762 1762 1991-01-31 Union del Centro Nacional 1991-10-30 GUATEMALA Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs          
5854 5854 1990-04-30 Franklin, S.A. 1991-10-30 SPAIN Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Madrid        
11020 11020 1992-08-31 Cultura 2000 1992-10-23 NAMIBIA Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Windhoek        
11263 11263 1987-09-01 National Civic Crusade for Panama 1987-07-01 PANAMA Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Washington     DC  
11685 11685 1992-09-17 Partido Nacional de Honduras 1989-11-21 HONDURAS Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Tegucigalpa        
12032 12032 1991-09-30 Partido Repubblicano Italiano 1991-10-30 ITALY Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Rome        
12360 12360 1987-10-01 Government of Egypt 1983-02-16 EGYPT Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Cairo        
13316 13316 1991-10-31 Rafael Leanardo Callejas 1991-10-30 HONDURAS Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs          
16029 16029 1987-12-31 Turkish Republic of Northern Cyprus 1985-06-04 CYPRUS Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Washington     DC  

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