List of all foreign principals (active and terminated)

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

2 rows where City = "Washington" and Registrant_Name = "Arnold & Porter Kaye Scholer, LLP"

View and edit SQL

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

Country/Location_Represented

State

Registrant_Name

  • Arnold & Porter Kaye Scholer, LLP · 2

City

  • Washington · 2
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
74   Bolivarian Republic of Venezuela under President Juan Guaido 2019-02-11 VENEZUELA 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP Carlos Vecchio, Ambassador of the Bolivarian Republic of Venuzuela under President Juan Guaido 2409 California Street, NW Washington DC 20008
180   Embassy of the Republic of Argentina 2020-05-07 ARGENTINA 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP 1600 New Hampshire Avenue, NW   Washington DC 20009

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