FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

30 rows where Registration_Number = 2278

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

  • 2278 · 30 ✖

City

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
99 99   2018-01-12 Brandwein David 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
286 286   2003-02-04 Haber Leo 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
287 287   2011-02-04 Israeli Hasia 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
943 943   1972-05-16 Sultanik Kalman 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
1398 1398   2013-07-31 Post Marlene 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
1412 1412   2007-08-03 Levinson Melissa 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
2343 2343 1972-01-01 1971-10-05 Neumann Emanuel 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
2565 2565 1998-01-01 1972-05-16 Torczyner Jacques 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
7823 7823 2007-02-28 2003-02-04 Hochberg Jane 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
12148 12148 1990-04-04 1971-10-05 Hamlin Isadore 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
20173 20173 1988-06-30 1983-04-12 Bernstein Louis 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
20174 20174 1988-06-30 1983-04-12 Sutker Phyllis 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
21338 21338 2010-07-01 2007-02-01 Finkelstein Maxyne 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
21372 21372 2015-07-01 2013-01-30 Tal Ittai 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
22265 22265 2005-07-15 2003-02-04 Peretz Joseph 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
23903 23903 2001-07-31 2001-01-16 Levy Alla 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
26175 26175 1993-08-24 1983-03-21 Tannenbaun Bernice S. 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
27383 27383 2011-08-31 2008-07-31 Shusterman Uriel 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
27772 27772 2017-09-01 2003-02-04 Bloch Sam 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
29807 29807 1991-09-30 1989-01-25 Rabi Yitzhak 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
33735 33735 1988-11-03 1985-02-12 Kalick Laura L. 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
34465 34465 2007-11-15 2006-03-01 Menashe Yehoshua 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
37236 37236 1982-12-20 1972-05-16 Pollack Allen 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
37238 37238 1982-12-20 1971-10-12 Jacobson Charlotte 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
38544 38544 1979-12-31 1971-10-05 Levy Henry W. 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
39053 39053 1990-12-31 1974-05-22 Chertoff Mordecai S. 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
39068 39068 1990-12-31 1977-06-21 Bar-On Mordechai 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
39088 39088 1990-12-31 1979-12-25 Fried Jacob 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
39222 39222 1994-12-31 1988-06-14 Chinitz Zelig 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
40125 40125 2010-12-31 2003-02-04 Werber Allen K. 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st 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])
);