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

where Registration_Number = 543

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

These facets timed out: Registrant_Name

State 1

  • NY 57

Registration_Number 1

  • Israel Information Services · 57 ✖

City 1

  • New York 57
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
3477 3477 1964-01-09 1956-06-18 Rosenberg Bernard Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
4079 4079 1953-01-19 1951-07-20 Levy Ralene Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
5656 5656 1964-02-01 1964-01-09 Argov Shlomo Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
8617 8617 1954-03-01 1951-03-28 Zinder Harry Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
9748 9748 1951-03-13 1948-10-12 Kenen Isaiah Leo Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
14426 14426 1961-04-30 1959-08-17 Manela-Gutka Tova Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
15296 15296 1957-05-01 1953-10-13 Dafni Reuven Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
18307 18307 1949-06-01 1949-03-01 Guterman Lillian Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
18320 18320 1956-06-01 1952-11-26 Rivlin Moshe Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
18371 18371 1961-06-01 1961-02-02 Gilner Herbert Jacob Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
20633 20633 1950-06-30 1950-06-28 Davidovitch Minna Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
20634 20634 1950-06-30 1950-06-28 Gutman Yaaqov Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
20649 20649 1956-06-30 1956-01-20 Saphir Jacob Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
20692 20692 1958-06-30 1956-05-01 Shadmi Baruch Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
20695 20695 1960-06-30 1951-01-22 Elfert Samuel H. Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
20700 20700 1960-06-30 1960-03-24 Gerstman Shmuel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
22051 22051 1962-07-01 1961-02-02 Rivlin David Zvi Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
22428 22428 1971-07-02 1949-06-14 Brostoff Shirley Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
23186 23186 1968-07-15 1965-08-24 Raviv Shabtai Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
23338 23338 1968-07-16 1963-02-11 Yaakov Yosef Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
24053 24053 1949-07-26 1948-10-12 Rosenhouse Harvey Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
25967 25967 1953-08-05 1951-08-31 Kaufman Ephraim Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
28760 28760 1962-09-01 1961-08-24 Aviad Yakov Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
28761 28761 1964-09-01 1964-01-09 Meir Israel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
28769 28769 1966-09-01 1964-01-09 Raziel Joseph Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
29376 29376 1954-09-08 1955-02-28 Gottlieb Shmuel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
32489 32489 1958-10-09 1958-10-09 Grinberg Henry Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
32647 32647 1948-10-12 1948-10-12 Grossman Rita Esther Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34838 34838 1971-11-01 1956-01-20 Sokolower Caryl Lois Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34839 34839 1971-11-01 1961-02-02 Bitan Hava Buttenwieser Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34840 34840 1971-11-01 1961-02-02 Shadmi David Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34841 34841 1971-11-01 1959-02-04 Ra'anan Uri Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34842 34842 1971-11-01 1959-02-04 Padan Meir Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34843 34843 1971-11-01 1959-02-04 Zeldis Chayym Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34844 34844 1971-11-01 1955-02-10 Plotkin Arieh Leopold Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34845 34845 1971-11-01 1963-02-11 Pilosoph Itzhak Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34846 34846 1971-11-01 1961-03-29 Golan Menahem Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34847 34847 1971-11-01 1968-04-17 Eshkol Nahum Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34849 34849 1971-11-01 1957-08-01 Guterman Lillian Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34850 34850 1971-11-01 1965-08-26 Ben-Yosef Malka Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34851 34851 1971-11-01 1951-08-31 Hacohen Nahum Hillel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34853 34853 1971-11-01 1958-10-09 Gorr Reeva Gruna Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34854 34854 1971-11-01 1958-10-09 Karu Israel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34855 34855 1971-11-01 1958-10-09 Morris Yaacov Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34856 34856 1971-11-01 1958-10-09 Peled Benjamim Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
34857 34857 1971-11-01 1958-10-09 Yafeh Aviad Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
35252 35252 1949-11-05 1948-10-12 Zinder Harry Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
36593 36593 1960-11-30 1959-02-04 Losin Toby Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
37226 37226 1956-12-01 1955-01-12 Justman Joshua Abram Heszel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
37999 37999 1948-12-10 1948-10-12 Zamichow Bernard Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39543 39543 1955-12-31 1951-08-31 Goldschmidt Ruth Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39568 39568 1957-12-31 1955-01-12 Marmor David I. Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39660 39660 1958-12-31 1958-10-09 Cohen Benjamin Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39661 39661 1958-12-31 1958-10-09 Tadmor Shlomo Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39665 39665 1959-12-31 1956-01-20 Tenenbaum Charles Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39677 39677 1959-12-31 1958-10-09 Chernofsky Jacob L. Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021
39696 39696 1960-12-31 1958-10-09 Weitman Rachel Israel Information Services 543 1948-10-12 Israel Information Services 11 East 70th Street   New York NY 10021

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 4907.733ms · 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