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

14 rows where Country/Location_Represented = "PERU" and State = "DC"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • PERU · 14 ✖
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
182 182   Embassy of Peru 2023-07-20 PERU Resolute Public Affairs  7297 2023-07-20 Resolute Public Affairs 1700 Massachusetts Ave., NW   Washington DC 20036
557 557   Peru 2023-03-10 PERU Patriot Strategies, LLC 7242 2023-03-10 Patriot Strategies, LLC 1700 Massachusetts NW   Washington DC 20036
4128 4128 2018-03-28 Government of Peru 2018-02-12 PERU CLS Strategies 6523 2018-02-12 CLS Strategies 1700 Massachusetts Avenue, NW   Washington DC 20036
4583 4583 2000-03-31 Government of Peru, Embassy 1999-10-26 PERU Shepardson Stern & Kaminsky 5335 1999-10-26 Shepardson Stern & Kaminsky 1700 Massachusetts Avenue, N.W.     DC  
10828 10828 2002-08-29 Embassy of Peru and Exporamerica 2001-07-12 PERU Schmeltzer, Aptaker & Shepard, P.C. 5304 1999-03-02 Schmeltzer, Aptaker & Shepard, P.C. Embassy of Peru 1700 Massachusetts Avenue, N.W. / Principal Address of Foreign Principal - Estudio     DC  
11113 11113 2007-08-31 Embassy of the Republic of Peru through Patton Boggs 2007-08-03 PERU James & Hoffman, PC 5822 2007-08-03 James & Hoffman, PC 1700 Massachusetts Avenue, NW   Washington DC 20036
12551 12551 1988-10-08 Republic of Peru 1981-10-08 PERU Lane & Edson, P.C. 3286 1981-10-08 Lane & Edson, P.C. Washington     DC  
12775 12775 1985-10-16 Government of Peru 1984-12-20 PERU Wald, Harkrader & Ross 3241 1981-05-10 Wald, Harkrader & Ross       DC  
12967 12967 1960-10-24 Reynaldo Gubbins (Gubbins & Company of Lima, Peru) 1960-04-07 PERU McGovern, John Joseph 1351 1960-04-07 McGovern, John Joseph Washington     DC  
14015 14015 1977-11-16 His Excellency, Senor Don Fernando Berckemeyer 1950-08-17 PERU Covington & Burling 523 1948-04-16 Covington & Burling Washington     DC  
14070 14070 1962-11-19 Fernando Berckemeyer 1962-11-19 PERU De Bessenyey, Gabor 1582 1962-11-19 De Bessenyey, Gabor Washington     DC  
14106 14106 1959-11-21 Government of Peru, Embassy of Peru 1953-11-24 PERU O'Dunne Jr., Eugene 798 1953-11-24 O'Dunne Jr., Eugene Washington     DC  
16484 16484 2000-12-31 Republic of Peru, Embassy 1999-10-29 PERU Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 1700 Massachusetts Avenue, NW     DC  
16632 16632 2008-12-31 Embassy of the Republic of Peru 2007-02-27 PERU Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 1700 Massachusetts Avenue, NW   Washington DC 20036

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