FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Address_1 = "Istanbul"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 14
- APCO Worldwide, Inc. 2
- APCO Associates 1
- Arnold & Porter Kaye Scholer LLP 1
- Burson-Marsteller 1
- C/R International, L.L.C. 1
- Capitoline/MS&L 1
- GCI Group, Inc. 1
- Gray, Kenneth J. 1
- Levin, Kreis, Ruskin & Gyory 1
- Manning, Selvage & Lee 1
- Milbank, Tweed, Hadley & McCloy 1
- Pillsbury, Madison & Sutro 1
- Winston & Strawn 1
- World Trade Link 1
Registrant_Date (date) 14 ✖
- 1991-09-03 2
- 1964-06-04 1
- 1965-01-11 1
- 1965-08-05 1
- 1973-10-23 1
- 1976-03-05 1
- 1984-06-20 1
- 1986-07-11 1
- 1986-08-13 1
- 1989-01-27 1
- 1989-11-22 1
- 1991-06-20 1
- 1992-06-10 1
- 1996-07-02 1
Foreign_Principal 12
- Profilo Holding, A.S. 3
- Quincentennial Foundation of Istanbul 2
- Besim Tibuk 1
- Interbank (Uluslararasi Endustri ve Ticaret Bankasi) 1
- Interbank Anonim Sirketi 1
- Penajans/DMB & B Ticaret, A.S. Aysegul Dora, Chairman 1
- Regional Cooperation for Development (RCD) Shipping Committee 1
- Republic of Turkey 1
- Turkish Airlines, Inc. 1
- Turkish Apparel Exporters' Association 1
- Turkish Industrialists & Businessmen Association 1
- Turkish Industrialists' & Businessman's Association (TUSIAD) 1
State 1
- - 15
Country/Location_Represented 1
- TURKEY 15
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2046 | 2046 | 1993-02-01 | Profilo Holding, A.S. | 1991-09-03 | TURKEY | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Istanbul | ||||
3299 | 3299 | 1991-03-01 | Interbank (Uluslararasi Endustri ve Ticaret Bankasi) | 1991-02-27 | TURKEY | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | Istanbul | ||||
3972 | 3972 | 1993-03-22 | Quincentennial Foundation of Istanbul | 1991-09-19 | TURKEY | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Istanbul | ||||
6617 | 6617 | 1967-05-17 | Regional Cooperation for Development (RCD) Shipping Committee | 1965-08-05 | TURKEY | Levin, Kreis, Ruskin & Gyory 1913 | 1965-08-05 | Levin, Kreis, Ruskin & Gyory | Istanbul | ||||
8113 | 8113 | 1996-06-26 | Republic of Turkey | 1996-06-04 | TURKEY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Istanbul | ||||
9271 | 9271 | 1997-07-15 | Besim Tibuk | 1997-07-29 | TURKEY | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Istanbul | ||||
11016 | 11016 | 1991-08-31 | Profilo Holding, A.S. | 1985-12-18 | TURKEY | APCO Associates 3597 | 1984-06-20 | APCO Associates | Istanbul | ||||
11227 | 11227 | 1976-09-01 | Turkish Industrialists & Businessmen Association | 1976-03-05 | TURKEY | Gray, Kenneth J. 2665 | 1976-03-05 | Gray, Kenneth J. | Istanbul | ||||
11404 | 11404 | 1976-09-07 | Turkish Airlines, Inc. | 1975-08-21 | TURKEY | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Istanbul | ||||
11569 | 11569 | 1994-09-13 | Penajans/DMB & B Ticaret, A.S. Aysegul Dora, Chairman | 1993-05-04 | TURKEY | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | Istanbul | ||||
14400 | 14400 | 1990-11-30 | Turkish Apparel Exporters' Association | 1990-01-31 | TURKEY | World Trade Link 4317 | 1989-11-22 | World Trade Link | Istanbul | ||||
14480 | 14480 | 1998-11-30 | Turkish Industrialists' & Businessman's Association (TUSIAD) | 1998-11-13 | TURKEY | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | Istanbul | ||||
14807 | 14807 | 1995-12-04 | Profilo Holding, A.S. | 1985-12-16 | TURKEY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Istanbul | ||||
16239 | 16239 | 1992-12-31 | Quincentennial Foundation of Istanbul | 1990-02-12 | TURKEY | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Istanbul | ||||
16263 | 16263 | 1994-12-31 | Interbank Anonim Sirketi | 1994-01-05 | TURKEY | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | Istanbul |
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]) );