home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
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 City = "San Salvador"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 9

  • Arnold & Porter Kaye Scholer, LLP 1
  • Blueprint Communications, LLC 1
  • Brownstein Hyatt Farber Schreck, LLP 1
  • Cardenas Partners, LLC 1
  • Gephardt Group Government Affairs, LLC 1
  • Invest El Salvador 1
  • Latin America Advisory Group, LLC 1
  • Rational PR, LLC d/b/a Rational 360 1
  • S.G.R. LLC Government Relations and Lobbying 1

Foreign_Principal 8

  • Government of El Salvador 2
  • Exor Investment Corporate De El Salvador, S.A. De C.V. 1
  • Exor Investment Corporate De El Salvador, S.A. De C.V., through a subcontract with Brownstein Hyatt Farber Schreck 1
  • Funes & Asociados Publicidad 1
  • Office of the Presidency, Republic of El Salvador 1
  • Office of the President of El Salvador 1
  • Partido Alianza Republicana Nacionalista (ARENA) And El Salvador Presidental candidate, Carlos Calleja 1
  • Republic of El Salvador 1

State 1

  • - 9

Country/Location_Represented 1

  • EL SALVADOR 9

City 1

  • San Salvador · 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
249 249   Exor Investment Corporate De El Salvador, S.A. De C.V. 2022-02-18 EL SALVADOR Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP Las Magnolias No. 131, Colonia San Benito, Edificio Casa 5, Oficina D12 San Salvador    
250 250   Exor Investment Corporate De El Salvador, S.A. De C.V., through a subcontract with Brownstein Hyatt Farber Schreck 2022-04-06 EL SALVADOR Blueprint Communications, LLC 6844 2020-07-15 Blueprint Communications, LLC Las Magnolias No. 131, Colonia San Benito, Edificio Casa 5, Oficina D12 San Salvador    
540 540   Office of the Presidency, Republic of El Salvador 2021-04-05 EL SALVADOR Arnold & Porter Kaye Scholer, LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP Casa Presidencial de El Salvador Alameda Manuel Enrique Araujo 5500 San Salvador    
541 541   Office of the President of El Salvador 2022-01-14 EL SALVADOR Latin America Advisory Group, LLC 6898 2020-12-09 Latin America Advisory Group, LLC Alameda Doctor Manuel Enrique Araujo No 5500   San Salvador    
585 585   Republic of El Salvador 2020-10-25 EL SALVADOR Rational PR, LLC d/b/a Rational 360 6882 2020-10-25 Rational PR, LLC d/b/a Rational 360 Alameda Manuel Enrique Araujo 5500   San Salvador    
9868 9868 2011-08-01 Government of El Salvador 2010-08-03 EL SALVADOR Gephardt Group Government Affairs, LLC 5874 2008-07-21 Gephardt Group Government Affairs, LLC Casa Presidencial No. 5500 Manuel Enrique Araujo Highway Colonia San Benito San Salvador    
13258 13258 2018-10-31 Partido Alianza Republicana Nacionalista (ARENA) And El Salvador Presidental candidate, Carlos Calleja 2018-09-13 EL SALVADOR S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying Prolognacion Calle Arce, entre 45 y 46 avenida norte No. 2429   San Salvador    
16445 16445 2012-12-31 Funes & Asociados Publicidad 2011-12-15 EL SALVADOR Cardenas Partners, LLC 6080 2011-12-15 Cardenas Partners, LLC Torre Futura, Nivel 12 Local 3 87 Av. Nte y 9a Calle Poniente San Salvador    
16637 16637 2021-12-31 Government of El Salvador 2020-11-13 EL SALVADOR Invest El Salvador 6890 2020-11-13 Invest El Salvador Alameda Manuel Enrique Araujo No. 5500   San Salvador    

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])
);
Powered by Datasette · Queries took 152.334ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history