FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Foreign_Principal_Termination_Date" is on date 2012-04-30 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_1, Zip
Foreign_Principal 6
Country/Location_Represented 6
- ARGENTINA 1
- AZERBAIJAN 1
- BAHRAIN 1
- ECUADOR 1
- MOROCCO 1
- SAUDI ARABIA 1
Registrant_Name 5
City 4
- - 2
- Washington 2
- Isa Town 1
- Riyadh 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
6067 | 6067 | 2012-04-30 | Embassy of Argentina | 2012-04-30 | ARGENTINA | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | |||||
6068 | 6068 | 2012-04-30 | Embassy of the Republic of Ecuador | 2011-01-31 | ECUADOR | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | |||||
6069 | 6069 | 2012-04-30 | Information Affairs Authority | 2011-08-22 | BAHRAIN | Joe Trippi & Associates 6060 | 2011-08-22 | Joe Trippi & Associates | P.O. Box 253 | Isa Town | |||
6070 | 6070 | 2012-04-30 | Moroccan American Center for Policy | 2010-12-03 | MOROCCO | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
6071 | 6071 | 2012-04-30 | Saudi Food & Drug Authority Kingdom of Saudi Arabia | 2011-10-03 | SAUDI ARABIA | Dewey & LeBoeuf, LLP 6066 | 2011-10-03 | Dewey & LeBoeuf, LLP | 3292 North Highway | Al Nafal Unit (1) | Riyadh |
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]) );