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

22 rows where Country/Location_Represented = "AZERBAIJAN" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • AZERBAIJAN · 22 ✖
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
1527 1527 2002-01-25 Embassy of Azerbaijan 1993-12-10 AZERBAIJAN Ed Graves & Associates 4541 1991-07-10 Ed Graves & Associates Washington     DC  
3056 3056 2003-02-28 Embassy of Azerbaijan 2002-01-08 AZERBAIJAN Wilson Associates, LLC 5450 2001-08-03 Wilson Associates, LLC 2741 34th Street, N.W. 20008     DC  
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
3982 3982 2009-03-22 Ministry of Foreign Affairs of the Republic of Azerbaijan, Embassy 2005-01-21 AZERBAIJAN Livingston Group, LLC 5356 2000-01-31 Livingston Group, LLC Embassy of Azerbaijan 2741 34th Street, NW 20008     DC  
4751 4751 2015-03-31 SOCAR USA, subsidiary of State Oil Company of Azerbaijan Republic (SOCAR) 2013-07-28 AZERBAIJAN Roberti + White, LLC 6065 2011-09-23 Roberti + White, LLC 1319 18th Street, NW   Washington DC 20036
6066 6066 2012-04-30 Azerbaijan America Alliance Corporation Board of Directors thru Fabiani & Company 2012-08-03 AZERBAIJAN Strategy XXI Group, LLC 6058 2011-08-18 Strategy XXI Group, LLC 1101 Pennsylvania Avenue, NW Suite 700 Washington DC 20004
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
7185 7185 2001-05-31 Government of Azerbaijan, Embassy 1998-08-17 AZERBAIJAN Hooper, Owen & Winburn 5179 1997-05-12 Hooper, Owen & Winburn       DC  
7241 7241 2013-05-31 Azerbaijan America Alliance Corporation Board of Directors 2011-05-25 AZERBAIJAN Fabiani & Company 6045 2011-05-25 Fabiani & Company 1101 Pennsylvania Avenue, NW Suite 700 Washington DC 20004
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
12390 12390 2001-10-01 Republic of Azerbaijan, Embassy 1998-09-17 AZERBAIJAN Baker, Donelson, Bearman & Caldwell 5274 1998-09-17 Baker, Donelson, Bearman & Caldwell 927 Fifteenth Street, N.W. Suite 700     DC  
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
13377 13377 1998-10-31 Embassy of the Republic of Azerbaijan 1998-08-11 AZERBAIJAN IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 927 15th Street, N.W., Washington     DC  
16704 16704 2012-12-31 Azerbaijan America Alliance Corporation Board of Directors 2011-06-07 AZERBAIJAN Azerbaijan America Alliance Corporation 6046 2011-06-07 Azerbaijan America Alliance Corporation 1101 Pennsylvania Avenue, NW Suite 600   Washington DC 20004
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])
);