fara: FARA_All_ForeignPrincipals: 5 rows where City = "New York" and Country/Location

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

5 rows where City = "New York" and Country/Location_Represented = "TURKEY"

Search:

✖

descending

Link	rowid ▼	Foreign_Principal_Termination_Date	Foreign_Principal	Foreign_Principal_Registration_Date	Country/Location_Represented	Registration_Number	Registrant_Date	Registrant_Name	Address_1	City	State	Zip
259	259		GOTURKIYE - Turkish Ministry of Culture & Tourism	2022-09-27	TURKEY	Geoffrey Weill 7173	2022-09-27	Geoffrey Weill	823 United Nations Plaza	New York	NY	10017
3348	3348	2014-03-01	Turkish Culture and Tourist Office	2013-03-19	TURKEY	Ruder Finn, Inc. 1481	1961-09-27	Ruder Finn, Inc.	821 United Nations Plaza	New York	NY	10017
11822	11822	2015-09-25	Turk Hava Yollari, A.O. (Turkish Airlines)	2015-05-21	TURKEY	Golin/Harris International, Inc. 6296	2015-05-21	Golin/Harris International, Inc.	350 Fifth Avenue, Suite 7510	New York	NY	10118
16725	16725	2012-12-31	Turkish Culture & Tourism Office	2010-03-12	TURKEY	M. Silver Associates, Inc. 3131	1980-07-15	M. Silver Associates, Inc.	821 United Nations Plaza, 4th Floor	New York	NY	10017
16774	16774	2015-12-31	Turkish Culture and Tourist Office	2014-03-10	TURKEY	Finn Partners, Inc. 6212	2014-03-10	Finn Partners, Inc.	825 3rd Avenue	New York	NY	10022

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])
);