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

56 rows where Country/Location_Represented = "AZERBAIJAN" sorted by Foreign_Principal_Registration_Date

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name >30

  • JWI, LLC 5
  • Azerbaijan America Alliance Corporation 3
  • Livingston Group, LLC 2
  • Potomac Square Group 2
  • Sanitas International, Inc. 2
  • 30 Point Strategies, LLC 1
  • APCO Worldwide, Inc. 1
  • Azerbaijan Study Foundation 1
  • BGR Government Affairs, LLC 1
  • Baker, Donelson, Bearman & Caldwell 1
  • Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 1
  • Ballard Partners 1
  • Blue Star Strategies, LLC 1
  • Bob Lawrence & Associates, Inc. 1
  • CLS Strategies 1
  • Campbell, Falk & Selby 1
  • Capitoline/MS&L 1
  • Catlett & Yancey, PLC 1
  • DCI Group, LLC 1
  • DLA Piper US LLP 1
  • Delahunt Group, LLC 1
  • Dutko Worldwide, LLC 1
  • Ed Graves & Associates 1
  • FGS Global (US) LLC (FKA FGH Holdings LLC) 1
  • Fabiani & Company 1
  • Friedlander Consulting Group LLC 1
  • Global Policy Initiatives 1
  • Greenberg Traurig, LLP 1
  • Hooper, Owen & Winburn 1
  • IPG DXTRA, Inc 1
  • …

Foreign_Principal >30

  • Embassy of the Republic of Azerbaijan 7
  • Republic of Azerbaijan 6
  • Embassy of Azerbaijan 5
  • Azerbaijan America Alliance Corporation Board of Directors 2
  • Camelot Oil & Gas Development Ltd. 2
  • Consulate General of the Republic of Azerbaijan 2
  • Investment Corporation, LLC 2
  • State Oil Company of the Azerbaijan Republic (SOCAR) 2
  • Aeromax Project LP DBA Carlex Technologies 1
  • Anar Mammadov 1
  • Assembly of the Friends of Azerbaijan 1
  • Association for Civil Society Development in Azerbaijan (ACSDA) 1
  • Azerbaijan America Alliance Corporation Board of Directors thru Fabiani & Company 1
  • Azerbaijan Consul General, Western US 1
  • Azerbaijan Diplomatic Academy 1
  • Azerbaijan Railways CJSC 1
  • Embassy of the Government of Azerbaijan 1
  • Embassy of the Republic of Azerbaijan (through BGR Government Affairs, LLC) 1
  • Embassy of the Republic of Azerbaijan to the United States of America 1
  • Embassy of the Republic of Azerbaijan, Amb. H.E. Elin Suleymanov 1
  • Foreign Ministry of Azerbaijan 1
  • Freedom Enterprises I, LLC 1
  • Freedom Enterprises I, LLC, (through the Dutko Group Companies) 1
  • Government of Azerbaijan of behalf of BGR Group 1
  • Government of Azerbaijan, Embassy 1
  • Government of the Republic of Azerbaijan 1
  • International Bank of Azerbaijan 1
  • Khayal Sharif-zadeh 1
  • Ministry of Foreign Affairs of the Republic of Azerbaijan through the Livingston Group 1
  • Ministry of Foreign Affairs of the Republic of Azerbaijan, Embassy 1
  • …

City 9

  • - 29
  • Washington 16
  • Baku 3
  • Los Angeles 2
  • New York 2
  • BAKU 1
  • Bakv 1
  • Houston 1
  • London 1

State 5

  • - 28
  • DC 22
  • NY 3
  • CA 2
  • TX 1

Country/Location_Represented 1

  • AZERBAIJAN · 56 ✖
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
3402 3402 1993-03-03 Republic of Azerbaijan 1992-07-14 AZERBAIJAN Campbell, Falk & Selby 4700 1992-07-14 Campbell, Falk & Selby New York     NY  
14840 14840 1993-12-06 Republic of Azerbaijan 1993-02-05 AZERBAIJAN Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Baku        
1527 1527 2002-01-25 Embassy of Azerbaijan 1993-12-10 AZERBAIJAN Ed Graves & Associates 4541 1991-07-10 Ed Graves & Associates Washington     DC  
1272 1272 1995-01-13 Republic of Azerbaijan 1994-02-01 AZERBAIJAN TKC International, Inc. 3075 1979-12-13 TKC International, Inc. Baku        
14449 14449 1994-11-30 P-NN Arkansas, Inc. 1994-05-17 AZERBAIJAN Catlett & Yancey, PLC 4914 1994-05-17 Catlett & Yancey, PLC Moscow        
10111 10111 1994-08-03 Republic of Azerbaijan 1994-08-03 AZERBAIJAN Piriev, Nizami 4936 1994-08-03 Piriev, Nizami Baku        
5956 5956 1996-04-30 Republic of Azerbaijan 1994-10-14 AZERBAIJAN Azerbaijan Study Foundation 4964 1994-10-14 Azerbaijan Study Foundation Baku        
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  
7185 7185 2001-05-31 Government of Azerbaijan, Embassy 1998-08-17 AZERBAIJAN Hooper, Owen & Winburn 5179 1997-05-12 Hooper, Owen & Winburn       DC  
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  
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  
11596 11596 2006-09-14 Republic of Azerbaijan 2003-10-31 AZERBAIJAN White & Case, LLP 2759 1977-03-09 White & Case, LLP 0        
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  
7552 7552 2005-06-03 Camelot Oil & Gas Development Ltd. 2005-06-03 AZERBAIJAN JWI, LLC 4990 1995-02-06 JWI, LLC 4 Princess Street Mayfair   London    
1353 1353 2006-01-15 Freedom Enterprises I, LLC 2005-08-08 AZERBAIJAN Dutko Worldwide, LLC 5693 2005-07-01 Dutko Worldwide, LLC c/o Nixon Peabody 437 Madison Avenue New York NY 10022
14063 14063 2005-11-18 Freedom Enterprises I, LLC, (through the Dutko Group Companies) 2005-09-09 AZERBAIJAN FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 2005-01-31 FGS Global (US) LLC (FKA FGH Holdings LLC) c/o Nixon Peabody 437 Madison Avenue New York NY 10022
5069 5069 2015-04-06 International Bank of Azerbaijan 2006-03-06 AZERBAIJAN JWI, LLC 4990 1995-02-06 JWI, LLC 67 Nizami Street Baku AZ1005      
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
16621 16621 2007-12-31 Ministry of Foreign Affairs of the Republic of Azerbaijan through the Livingston Group 2007-07-27 AZERBAIJAN CLS Strategies 5774 2006-10-06 CLS Strategies     Baku    
3176 3176 2008-02-29 Presidency of Azerbaijan 2007-09-26 AZERBAIJAN JWI, LLC 4990 1995-02-06 JWI, LLC 19 Istiglaliet Street   Baku    
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
2232 2232 2008-02-05 Consulate General of the Republic of Azerbaijan 2008-01-10 AZERBAIJAN Sitrick and Company, Inc. 5777 2006-11-20 Sitrick and Company, Inc.          
11123 11123 2008-08-31 Azerbaijan Diplomatic Academy 2008-08-08 AZERBAIJAN Southfive Strategies, LLC 5876 2008-08-08 Southfive Strategies, LLC     Bakv    
4754 4754 2016-03-31 Consulate General of the Republic of Azerbaijan 2009-03-09 AZERBAIJAN Tool Shed Group, LLC 5916 2009-03-09 Tool Shed Group, LLC 11766 Wilshire Boulevard Suite 1410 Los Angeles CA 90025
6697 6697 2009-05-21 Camelot Oil & Gas Development Ltd. 2009-05-19 AZERBAIJAN JWI, LLC 4990 1995-02-06 JWI, LLC 4 Princess Street Mayfair London, UK      
13035 13035 2012-10-25 Embassy of the Republic of Azerbaijan 2010-12-08 AZERBAIJAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
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
7660 7660 2011-06-07 Anar Mammadov 2011-06-07 AZERBAIJAN Azerbaijan America Alliance Corporation 6046 2011-06-07 Azerbaijan America Alliance Corporation Sarabski Str., Block 657 Baku, AZ 1022      
7661 7661 2011-06-07 Khayal Sharif-zadeh 2011-06-07 AZERBAIJAN Azerbaijan America Alliance Corporation 6046 2011-06-07 Azerbaijan America Alliance Corporation Sarabski Str., Block 657 Baku, AZ 1022      
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
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
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
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
2714 2714 2013-02-22 Embassy of the Republic of Azerbaijan, Amb. H.E. Elin Suleymanov 2012-10-08 AZERBAIJAN DCI Group, LLC 6140 2012-10-05 DCI Group, LLC          
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
12219 12219 2014-09-30 Azerbaijan Consul General, Western US 2013-05-28 AZERBAIJAN Potomac Square Group 6096 2012-03-27 Potomac Square Group          
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
6999 6999 2014-05-30 Assembly of the Friends of Azerbaijan 2014-04-14 AZERBAIJAN APCO Worldwide, Inc. 6184 2013-09-05 APCO Worldwide, Inc. Galleria Tower 1, 2700 Post Oak Blvd., Suite 1750   Houston TX 77056
12461 12461 2014-10-03 Representatives in Azerbaijan (through West Coast Connections Inc.) 2014-04-16 AZERBAIJAN Delahunt Group, LLC 6215 2014-04-16 Delahunt Group, LLC 11601 Wilshire Blvd. Suite 585 Los Angeles CA  
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
14729 14729 2015-12-01 State Oil Company of the Azerbaijan Republic (SOCAR) 2015-08-11 AZERBAIJAN Global Policy Initiatives 6314 2015-08-11 Global Policy Initiatives 73, Neftichiler Avenue Baku, AZ1000      
14776 14776 2015-12-03 State Oil Company of the Azerbaijan Republic (SOCAR) 2015-08-11 AZERBAIJAN 30 Point Strategies, LLC 6313 2015-08-11 30 Point Strategies, LLC 73, Neftichiler Avenue Baku, AZ1000      
6380 6380 2016-05-07 Association for Civil Society Development in Azerbaijan (ACSDA) 2016-05-09 AZERBAIJAN Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP          
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
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
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
12735 12735 2018-10-15 Aeromax Project LP DBA Carlex Technologies 2018-03-15 AZERBAIJAN Sanitas International, Inc. 6530 2018-03-07 Sanitas International, Inc. Mitchell Street 5, Edinburgh Suite, 4337 Mitchell House EH6 7BD      
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
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
12783 12783 2020-10-16 Azerbaijan Railways CJSC 2019-10-09 AZERBAIJAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP D. Aliyeva 230 Baku AZ1010      
2669 2669 2020-02-19 Nizami Ganjavi International Center 2020-01-17 AZERBAIJAN Blue Star Strategies, LLC 6587 2018-09-06 Blue Star Strategies, LLC World Business Center Floor 21 53 Samad Vurghun Street Nisimi District Baku    
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
12653 12653 2020-10-13 Government of the Republic of Azerbaijan 2020-07-27 AZERBAIJAN Livingston Group, LLC 6344 2016-03-25 Livingston Group, LLC     BAKU    
7288 7288 2021-05-31 Investment Corporation, LLC 2020-10-13 AZERBAIJAN S-3 Group 6422 2017-04-26 S-3 Group XALQLAR DOSTLUGU XIYOBANI 17C AZ1029, BAKU      
1408 1408 2021-01-18 Investment Corporation, LLC 2020-10-28 AZERBAIJAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Xalqlar Dostlugu Xiyabani, 17C, AX1029, Baku,        
252 252   Foreign Ministry of Azerbaijan 2023-02-10 AZERBAIJAN Friedlander Consulting Group LLC 7009 2021-09-03 Friedlander Consulting Group LLC 50 Shikhali Girbanov St. Baku AZERBAIJAN      

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 237.658ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows