FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_1 = "Washington" and Country/Location_Represented = "TURKEY"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 20
- Capitoline/MS&L 1
- Dewey Ballantine 1
- Dudley, Henry A. 1
- Durak, Ahmet Unal 1
- Edelman International Corporation 1
- Fleishman-Hillard, Inc. 1
- Henry J. Kaufman & Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- International Advisers, Inc. 1
- International Government Consultants, Inc. 1
- Jack McDonald Associates, Inc. 1
- Manning, Selvage & Lee, Inc. 1
- People's Revolutionary Party 1
- Shandwick Public Affairs, Inc. 1
- Slade, Jonathan B. 1
- Squire Patton Boggs, LLP 1
- Strauss, Joseph A. 1
- Szaz, Zoltan Michael 1
- Thompson & Company 1
- Washington Group 1
Foreign_Principal 10
State 1
- DC 20
Country/Location_Represented 1
- TURKEY · 20 ✖
City 1
- - 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1510 | 1510 | 1990-01-25 | Embassy of the Turkish Republic | 1988-07-29 | TURKEY | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | Washington | DC | |||
2243 | 2243 | 1990-02-06 | Turkish Embassy | 1989-03-21 | TURKEY | Slade, Jonathan B. 4228 | 1989-03-21 | Slade, Jonathan B. | Washington | DC | |||
2922 | 2922 | 1976-02-28 | Government of Turkey | 1975-09-12 | TURKEY | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | Washington | DC | |||
4015 | 4015 | 1994-03-24 | Embassy of the Republic of Turkey | 1990-01-18 | TURKEY | Thompson & Company 4094 | 1988-02-25 | Thompson & Company | Washington | DC | |||
4380 | 4380 | 1980-03-31 | Republic of Turkey | 1976-03-09 | TURKEY | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Washington | DC | |||
6526 | 6526 | 1981-05-14 | Embassy of the Republic of Turkey | 1980-08-08 | TURKEY | International Government Consultants, Inc. 3137 | 1980-08-08 | International Government Consultants, Inc. | Washington | DC | |||
6647 | 6647 | 1994-05-18 | Embassy of Turkey | 1989-01-11 | TURKEY | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | Washington | DC | |||
7669 | 7669 | 1980-06-08 | Embassy of the Turkish Republic | 1981-01-07 | TURKEY | Szaz, Zoltan Michael 3187 | 1981-01-07 | Szaz, Zoltan Michael | Washington | DC | |||
8595 | 8595 | 2000-06-30 | Republic of Turkey, Embassy | 1997-10-06 | TURKEY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
8912 | 8912 | 1998-07-01 | Republic of Turkey, Embassy | 1997-12-17 | TURKEY | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | Washington | 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 | |||
11238 | 11238 | 1981-09-01 | Republic of Turkey | 1975-09-11 | TURKEY | Dudley, Henry A. 2607 | 1975-09-11 | Dudley, Henry A. | Washington | DC | |||
11283 | 11283 | 1994-09-01 | Embassy of the Republic of Turkey | 1990-01-18 | TURKEY | Washington Group 4332 | 1990-01-18 | Washington Group | Washington | DC | |||
12471 | 12471 | 1994-10-04 | Turkish Ministry of Tourism | 1992-06-08 | TURKEY | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Washington | DC | |||
13370 | 13370 | 1997-10-31 | Republic of Turkey | 1992-01-31 | TURKEY | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Washington | DC | |||
13970 | 13970 | 1982-11-15 | Embassy of the Republic of Turkey | 1981-07-20 | TURKEY | Jack McDonald Associates, Inc. 3038 | 1979-07-13 | Jack McDonald Associates, Inc. | Washington | DC | |||
14471 | 14471 | 1997-11-30 | Government of Turkey, Embassy | 1994-06-09 | TURKEY | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
14925 | 14925 | 1994-12-09 | Republic of Turkey | 1983-06-21 | TURKEY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
15147 | 15147 | 1998-12-15 | Republic of Turkey, Embassy | 1997-10-15 | TURKEY | Strauss, Joseph A. 5214 | 1997-10-15 | Strauss, Joseph A. | Washington | DC | |||
15148 | 15148 | 1998-12-15 | Republic of Turkey, Embassy | 1997-10-15 | TURKEY | Durak, Ahmet Unal 5215 | 1997-10-15 | Durak, Ahmet Unal | Washington | DC |
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]) );