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

12 rows where Address_1 = "2741 34th Street, NW" and City = "Washington"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Country/Location_Represented 1

City 1

  • Washington · 12 ✖
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
198 198   Embassy of the Republic of Azerbaijan (through BGR Government Affairs, LLC) 2018-03-05 AZERBAIJAN Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 6535 2018-03-05 Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 2741 34th Street, NW   Washington DC 20008
199 199   Embassy of the Republic of Azerbaijan to the United States of America 2020-01-31 AZERBAIJAN Stellar Jay Communications 6789 2020-01-31 Stellar Jay Communications 2741 34th Street, NW   Washington DC 20008
200 200   Embassy of the Republic of Azerbaijan 2017-03-20 AZERBAIJAN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2741 34th Street, NW   Washington DC 20008
1173 1173 2015-01-09 Embassy of the Republic of Azerbaijan 2014-10-09 AZERBAIJAN Mair Strategies, LLC 6257 2014-10-09 Mair Strategies, LLC 2741 34th Street, NW   Washington DC 20008
3082 3082 2007-02-28 Embassy of Azerbaijan 2007-01-04 AZERBAIJAN JWI, LLC 4990 1995-02-06 JWI, LLC 2741 34th Street, NW   Washington DC 20008
6533 6533 2012-05-14 Embassy of Azerbaijan 2012-05-14 AZERBAIJAN Bob Lawrence & Associates, Inc. 6101 2012-05-14 Bob Lawrence & Associates, Inc. 2741 34th Street, NW   Washington DC 20008
7788 7788 2011-06-13 Embassy of the Government of Azerbaijan 2011-06-13 AZERBAIJAN Potomac Square Group 6024 2011-03-15 Potomac Square Group 2741 34th Street, NW   Washington DC 20008
9633 9633 2010-07-30 Embassy of Azerbaijan 2008-01-07 AZERBAIJAN Melwood Communications 5846 2008-01-07 Melwood Communications 2741 34th Street, NW   Washington DC 20008
10783 10783 2019-08-27 Embassy of the Republic of Azerbaijan 2019-05-08 AZERBAIJAN Rasky Partners 6586 2018-09-06 Rasky Partners 2741 34th Street, NW   Washington DC 20008
12737 12737 2018-10-15 Government of Azerbaijan of behalf of BGR Group 2018-03-07 AZERBAIJAN Sanitas International, Inc. 6530 2018-03-07 Sanitas International, Inc. 2741 34th Street, NW   Washington DC 20008
12863 12863 2018-10-19 Embassy of the Republic of Azerbaijan 2018-04-24 AZERBAIJAN Ballard Partners 6415 2017-04-05 Ballard Partners 2741 34th Street, NW   Washington DC 20008
16800 16800 2017-12-31 Embassy of the Republic of Azerbaijan 2013-01-31 AZERBAIJAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2741 34th Street, NW   Washington DC 20008

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