FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Foreign_Principal = "Government of Libya" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 5
City 2
- - 5
- Washington 1
Foreign_Principal 1
- Government of Libya · 6 ✖
Country/Location_Represented 1
- LIBYA 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16009 | 16009 | 1987-12-31 | Government of Libya | 1977-07-13 | LIBYA | Aramtek Corporation 2810 | 1977-07-13 | Aramtek Corporation | |||||
8729 | 8729 | 2015-06-30 | Government of Libya | 2011-06-24 | LIBYA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2445 M Street | Washington | DC | 20037 | |
2181 | 2181 | 1966-02-04 | Government of Libya | 1966-02-04 | LIBYA | James F. Fox, Inc. 1960 | 1966-02-04 | James F. Fox, Inc. | London, England | ||||
3859 | 3859 | 1968-03-18 | Government of Libya | 1967-08-15 | LIBYA | James F. Fox, Inc. 2038 | 1967-08-15 | James F. Fox, Inc. | London, England | ||||
8510 | 8510 | 1993-06-30 | Government of Libya | 1992-11-05 | LIBYA | International Communications Marketing, Inc. (ICM) 4733 | 1992-11-05 | International Communications Marketing, Inc. (ICM) | Tripoli | ||||
8665 | 8665 | 2007-06-30 | Government of Libya | 2004-07-16 | LIBYA | Fahmy Hudome International, LLC 5632 | 2004-07-16 | Fahmy Hudome International, LLC | Tripoli |
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]) );