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

43 rows where Registration_Number = 498

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date)

State 1

  • NY 43

Registration_Number 1

  • Turkish Consulate Office of Culture & Information Attache · 43 ✖

Registrant_Name 1

  • Turkish Consulate Office of Culture & Information Attache 43

City 1

  • New York 43
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
4151 4151 1964-01-20 1962-11-23 Curtis Tomi Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
4603 4603 1951-01-27 1950-03-03 Turemen Ihsan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
5696 5696 1974-02-01 1973-02-01 Erturk Yakin Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
6043 6043 1976-02-03 1964-09-02 Surmelioglu Hande Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
6599 6599 1949-02-11 1947-10-22 Esmer Ahmet Sukru Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
7990 7990 1992-02-28 1988-03-31 Ataman Oktay Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
8789 8789 1993-03-01 1991-01-23 Susek Ressan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
9693 9693 1976-03-12 1976-07-09 Acir Muzeyyen Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
9925 9925 1977-03-15 1975-01-10 Ozon Bulent Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
10922 10922 1960-03-28 1949-08-24 Eren Nuri Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
11110 11110 1967-03-30 1963-02-15 Serdaroglu Akil Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
11339 11339 1956-03-31 1955-08-04 Yalman Tunc Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
13168 13168 1982-04-11 1979-01-15 Cerci Hasan Huseyin Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
13273 13273 1955-04-13 1947-10-22 Atakent Ihsan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
13837 13837 1978-04-21 1975-01-10 Rawick Zeynep Gul Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
15304 15304 1960-05-01 1956-11-09 Bulut Tarik Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
16991 16991 1956-05-24 1956-03-09 Cohen Edward M. Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
17129 17129 1980-05-26 1978-01-30 Togay Nuri Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
17628 17628 1975-05-31 1971-02-17 Buyukpamukcu Nesil Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
17757 17757 1992-05-31 1991-01-23 Aygen Mahmut Guven Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
19037 19037 1966-06-08 1965-07-08 Ulus Erdogan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
19843 19843 1978-06-19 1978-01-30 Hekimgil M. Emin Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
19949 19949 1949-06-21 1947-10-22 Andolsun Feridun Kurt Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
20631 20631 1950-06-30 1949-02-25 Church Joseph Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
20650 20650 1956-06-30 1955-08-04 Soyal Ali Necati Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
22740 22740 1955-07-08 1950-08-25 Wolf Daniel Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
23997 23997 1974-07-25 1971-01-04 Ozaktas Adnan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
24452 24452 1969-07-30 1968-04-05 Dogancay Burhan C. Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
27572 27572 1970-08-28 1969-07-29 Buyukpamukcu Nesil Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
27842 27842 1960-08-31 1956-11-07 Gurun Ata Ahmet Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
30583 30583 1961-09-27 1958-09-18 Pirinccioglu Fethi Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
30882 30882 1968-09-30 1968-04-05 Goren Zeyyat Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
30935 30935 1980-09-30 1977-01-25 Kutay Esin Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
34020 34020 1968-10-30 1965-07-08 Mizanoglu Orhan Mehmet Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
34140 34140 1960-10-31 1958-10-29 Capli Erdogan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
34141 34141 1960-10-31 1956-11-07 Fenik Omer Faruk Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
36336 36336 1964-11-25 1963-03-06 Dogancay Durhan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
36471 36471 1981-11-27 1977-01-25 Sipit Ibrahim Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
39678 39678 1959-12-31 1956-11-07 Glen James Ramsey Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
39697 39697 1960-12-31 1947-10-22 Manyas Nezih Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
39730 39730 1962-12-31 1961-03-21 Atakent Ihsan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
39732 39732 1962-12-31 1961-03-21 Ozaktas Adnan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor New York NY 10017
40059 40059 1978-12-31 1975-01-10 Atakent Ihsan Turkish Consulate Office of Culture & Information Attache 498 1947-10-22 Turkish Consulate Office of Culture & Information Attache 821 United Nations Plaza 4th Floor 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 961.638ms · 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