home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

40 rows where City = "New York", Registrant_Name = "Representative of the Turkish Republic of Northern Cyprus" and State = "NY"

✖
✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date), Registration_Date (date)

State 1

  • NY · 40 ✖

Registration_Number 1

  • Representative of the Turkish Republic of Northern Cyprus 40

Registrant_Name 1

  • Representative of the Turkish Republic of Northern Cyprus · 40 ✖

City 1

  • New York · 40 ✖
Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
1112 1112   2021-05-26 Akin Denil Ertug Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
1266 1266   2019-06-21 Tahiroglu Seran Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
1274 1274   2020-06-22 Dana Mehmet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
1354 1354   2018-07-03 Lakadamyali Mustafa Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
1571 1571   2019-08-06 Gokeri Seval Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
1714 1714   2018-09-02 Guven Sertac Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
5077 5077 1991-01-31 1985-06-25 Koray Ozer Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
6556 6556 1992-02-10 1984-06-24 Aliriza Bulent Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
8912 8912 2018-03-01 2014-12-22 Ulgen Havva Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
8913 8913 2018-03-01 2014-12-22 Yesilada Yasa Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
9528 9528 2004-03-09 2004-03-09 Altiok Devrim Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
9993 9993 2012-03-15 2011-02-25 Yanik Dilek Yavuz Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
11540 11540 1985-03-31 1975-10-16 Atalay Nail Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
12545 12545 2010-04-01 2006-10-13 Onar Gunes Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
16482 16482 2015-05-15 2010-07-15 Tunc Mustafa Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
17751 17751 1991-05-31 1987-08-17 Erdengiz Ahmet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
19210 19210 2015-06-10 2012-06-07 Erdengiz Ahmet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
20061 20061 2020-06-22 2015-07-16 Korukoglu Ismet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
21895 21895 2018-06-30 2013-03-17 Dana Mehmet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
22306 22306 2006-07-01 2003-01-10 Caglar Resat Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
22483 22483 2005-07-02 2005-07-05 Altiok Devrim Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
23964 23964 1991-07-24 1987-08-17 Plumer Aytug Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
24023 24023 1997-07-25 1991-07-01 Ertug Osman Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
24103 24103 1997-07-26 1992-09-22 Kohran Namik Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
24758 24758 1987-07-31 1983-11-15 Caglar Resat Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
25626 25626 1999-08-01 1995-09-26 Uluer Beniz Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
25638 25638 2003-08-01 2002-04-03 Guclu Damla Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
25640 25640 2003-08-01 2001-05-29 Basaran Zehra Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
25645 25645 2005-08-01 2004-06-03 Dana Mehmet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
25662 25662 2009-08-01 2006-03-01 Soysal Murat Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
28592 28592 2014-08-31 2010-03-17 Guven Sertac Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
31031 31031 1988-09-30 1985-12-02 Cagar Safiye Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
32035 32035 2010-10-01 2007-03-23 Kop Buket Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
32105 32105 2018-10-01 2016-06-16 Ezel Ozgur Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
34974 34974 2002-11-01 2001-05-29 Veziroglu Gulfem Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
35305 35305 1997-11-05 1997-11-05 Erdengiz Ahmet Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
36402 36402 2012-11-25 2007-03-23 Akil Hilmi Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
37483 37483 2004-12-01 1999-09-15 Fein Bruce Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
37495 37495 2010-12-01 2007-03-27 Gokeri M. Kemal Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017
41492 41492 2006-12-31 2002-02-21 Ertug Osman Representative of the Turkish Republic of Northern Cyprus 2619 1975-10-16 Representative of the Turkish Republic of Northern Cyprus 821 First Avenue Floor 13 New York NY 10017

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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])
);
Powered by Datasette · Queries took 591.196ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows