FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "Washington" and Zip = 20004 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 9
Foreign_Principal 8
- Azerbaijan America Alliance Corporation Board of Directors 2
- Azerbaijan America Alliance Corporation Board of Directors thru Fabiani & Company 1
- Council on Pakistan Relations 1
- Embassy of the Republic of Cyprus, through Covington & Burling LLP 1
- Gainful Solutions, on behalf of the Government of South Sudan 1
- Government of Saudi Arabia through Glover Park Group, LLC 1
- Thaksin Shinawatra, former Prime Minister of Thailand 1
- US Office of the National Coalition of Syrian Revolution and Opposition Forces 1
Country/Location_Represented 7
- AZERBAIJAN 3
- CYPRUS 1
- PAKISTAN 1
- SAUDI ARABIA 1
- SUDAN 1
- SYRIA 1
- THAILAND 1
State 1
- DC 9
City 1
- Washington · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16840 | 16840 | 2018-12-31 | US Office of the National Coalition of Syrian Revolution and Opposition Forces | 2013-04-08 | SYRIA | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 1101 Pennsylvania Avenue, NW | Suite 6620 | Washington | DC | 20004 |
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 | |
14741 | 14741 | 2021-12-01 | Council on Pakistan Relations | 2021-06-10 | PAKISTAN | South/North Communications LLC 6972 | 2021-06-10 | South/North Communications LLC | 1455 Pennsylvania Avenue, NW | Suite 400 | Washington | DC | 20004 |
12864 | 12864 | 2020-10-19 | Gainful Solutions, on behalf of the Government of South Sudan | 2019-08-13 | SUDAN | Sanitas International, Inc. 6530 | 2018-03-07 | Sanitas International, Inc. | 1155 F Street, NW | Suite 1050 | Washington | DC | 20004 |
11112 | 11112 | 2007-08-31 | Embassy of the Republic of Cyprus, through Covington & Burling LLP | 2006-11-29 | CYPRUS | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1201 Pennsylvania Avenue, NW | Washington | DC | 20004 | |
7444 | 7444 | 2007-06-01 | Thaksin Shinawatra, former Prime Minister of Thailand | 2007-01-25 | THAILAND | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | c/o Baker Botts | The Warner 1299 Pennsylvania Avenue, NW | Washington | DC | 20004 |
7278 | 7278 | 2018-05-31 | Government of Saudi Arabia through Glover Park Group, LLC | 2016-11-16 | SAUDI ARABIA | McKeon Group, Inc. 6391 | 2016-11-16 | McKeon Group, Inc. | Royal Embassy of Saudi Arabia | 601 New Hampshire Avenue, NW | Washington | DC | 20004 |
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 |
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 |
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]) );