FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Foreign_Principal = "Government of the Republic of Turkey, Embassy" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
City 2
- - 4
- Washington 3
Foreign_Principal 1
- Government of the Republic of Turkey, Embassy · 7 ✖
Country/Location_Represented 1
- TURKEY 7
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9080 | 9080 | 2003-07-07 | Government of the Republic of Turkey, Embassy | 2000-01-31 | TURKEY | Livingston-Solomon Group, L.L.C. 5352 | 2000-01-07 | Livingston-Solomon Group, L.L.C. | 2525 Massachusetts Avenue, N.W. 20008 | DC | |||
10034 | 10034 | 1999-08-01 | Government of the Republic of Turkey, Embassy | 1999-04-30 | TURKEY | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | 1606 23rd Street, NW | DC | |||
11059 | 11059 | 1998-08-31 | Government of the Republic of Turkey, Embassy | 1998-08-17 | TURKEY | People's Revolutionary Party 5271 | 1998-08-17 | People's Revolutionary Party | Washington | DC | |||
15144 | 15144 | 1998-12-15 | Government of the Republic of Turkey, Embassy | 1998-08-13 | TURKEY | DCS Group 5269 | 1998-08-13 | DCS Group | Tulsa | OK | |||
6080 | 6080 | 2014-04-30 | Government of the Republic of Turkey, Embassy | 2007-09-24 | TURKEY | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
9636 | 9636 | 2013-07-30 | Government of the Republic of Turkey, Embassy | 2009-03-09 | TURKEY | Caspian Group, LLC 5915 | 2009-03-09 | Caspian Group, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
312 | 312 | Government of the Republic of Turkey, Embassy | 2014-03-03 | TURKEY | LB International Solutions, LLC 6210 | 2014-03-03 | LB International Solutions, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 29998 |
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]) );