FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "Washington" and Country/Location_Represented = "AZERBAIJAN"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 16
- Azerbaijan America Alliance Corporation 1
- BGR Government Affairs, LLC 1
- Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 1
- Ballard Partners 1
- Bob Lawrence & Associates, Inc. 1
- Fabiani & Company 1
- JWI, LLC 1
- Mair Strategies, LLC 1
- Melwood Communications 1
- Podesta Group, Inc. 1
- Potomac Square Group 1
- Rasky Partners 1
- Roberti + White, LLC 1
- Sanitas International, Inc. 1
- Stellar Jay Communications 1
- Strategy XXI Group, LLC 1
Foreign_Principal_Termination_Date 14 ✖
- - 3
- 2007-02-28 1
- 2010-07-30 1
- 2011-06-13 1
- 2012-04-30 1
- 2012-05-14 1
- 2012-12-31 1
- 2013-05-31 1
- 2015-01-09 1
- 2015-03-31 1
- 2017-12-31 1
- 2018-10-15 1
- 2018-10-19 1
- 2019-08-27 1
Foreign_Principal_Termination_Date (date) 13 ✖
- 2007-02-28 1
- 2010-07-30 1
- 2011-06-13 1
- 2012-04-30 1
- 2012-05-14 1
- 2012-12-31 1
- 2013-05-31 1
- 2015-01-09 1
- 2015-03-31 1
- 2017-12-31 1
- 2018-10-15 1
- 2018-10-19 1
- 2019-08-27 1
Foreign_Principal 9
- Embassy of the Republic of Azerbaijan 5
- Embassy of Azerbaijan 3
- Azerbaijan America Alliance Corporation Board of Directors 2
- Azerbaijan America Alliance Corporation Board of Directors thru Fabiani & Company 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
- Government of Azerbaijan of behalf of BGR Group 1
- SOCAR USA, subsidiary of State Oil Company of Azerbaijan Republic (SOCAR) 1
State 1
- DC 16
Country/Location_Represented 1
- AZERBAIJAN · 16 ✖
City 1
- Washington · 16 ✖
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 | |
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 | |
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 | |
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 | |
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
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]) );