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

92 rows where Registration_Number = 620

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date (date)

State 1

Registration_Number 1

  • Israel Government Tourist Office · 92 ✖

Registrant_Name 1

City 1

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
2500 2500 1952-01-01 1950-03-27 Bergman Uri Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
2506 2506 1956-01-01 1955-03-07 Lapan Sonya Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3349 3349 1977-01-07 1973-02-07 Harly Reuven Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3398 3398 1977-01-08 1973-02-07 Golan Yoram Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3475 3475 1963-01-09 1956-07-31 Vidar Meir Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3480 3480 1977-01-09 1973-02-07 Daon Rafael Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3557 3557 1978-01-11 1974-05-07 Daker Jacob Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3728 3728 1960-01-15 1959-01-16 Zviaman Naftali Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
3951 3951 1973-01-17 1955-04-07 Gordon Rahel Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
5636 5636 1955-02-01 1953-09-10 Miller Simha Laby Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
5654 5654 1962-02-01 1958-10-10 Herman Menachem Manfred Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
7755 7755 1959-02-27 1958-01-06 Klein Ruth Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
7820 7820 1953-02-28 1952-09-17 Core David Uriel Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
9924 9924 1976-03-15 1971-12-06 Galei-Eger Louis Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
10579 10579 1976-03-23 1971-01-26 Goren Jacob Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
11332 11332 1952-03-31 1951-01-18 Eisner Netti Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
11350 11350 1959-03-31 1953-04-06 Bernstein Joseph Ilan Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
11432 11432 1974-03-31 1973-08-08 Lightman Paul Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
12367 12367 1956-04-01 1955-03-07 Blumenthal Margit Anne-Marie Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
12820 12820 1976-04-06 1967-09-25 Freedman Nathan T. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
13732 13732 1961-04-19 1960-08-01 Rubin Vivian Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
14175 14175 1973-04-27 1970-04-14 Pachter Jacob Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
14421 14421 1960-04-30 1959-03-25 Motzman Miriam Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
15300 15300 1960-05-01 1955-01-20 Baral Lillian Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
16728 16728 1960-05-20 1959-02-10 Bart Rose Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
18386 18386 1964-06-01 1963-04-03 Zodkevitch Lea Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
18388 18388 1964-06-01 1961-07-17 Rahav Asher Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
19332 19332 1967-06-13 1964-04-29 Beck Marjorie Ruth Levy Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20273 20273 1961-06-26 1959-01-21 Beham Yohanan Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20639 20639 1952-06-30 1952-09-17 Samuels Lillian Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20651 20651 1956-06-30 1955-09-08 Ross Jacob Jack Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20699 20699 1960-06-30 1959-02-13 Gordin Noemi F. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20729 20729 1962-06-30 1959-09-24 Kedem Dov Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20736 20736 1963-06-30 1959-02-26 Dervish Pnina Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20765 20765 1965-06-30 1961-05-22 Bennahum Victor Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20804 20804 1968-06-30 1964-10-09 Eyal Menachen Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20870 20870 1973-06-30 1969-03-24 Michaeli Uzi Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
20896 20896 1974-06-30 1971-12-06 Zeev Hellenberg Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
22072 22072 1967-07-01 1963-08-08 Sugerman Rina Urdang Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
22090 22090 1972-07-01 1969-03-24 Gidron Michael M. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
22839 22839 1983-07-09 1978-05-16 Sommer Arie Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
23152 23152 1956-07-15 1955-07-15 Jacoby Gregory Zwi Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
23188 23188 1968-07-15 1965-10-01 Shoshani Moshe Z. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
25457 25457 1964-08-01 1960-11-21 Housman Ester Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
25470 25470 1968-08-01 1962-08-27 Ari Abraham Ben Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
25491 25491 1972-08-01 1967-11-03 Sde-Or Gideon Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
26663 26663 1953-08-15 1951-12-12 Bachmann Hans Werner Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
26671 26671 1969-08-15 1965-10-01 Ofer Jacob Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
26709 26709 1982-08-15 1978-05-16 Kotzer Abraham Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
27038 27038 1968-08-20 1967-11-03 Golan Yoram Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
28776 28776 1968-09-01 1971-06-25 D'Angelo George A. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
28791 28791 1972-09-01 1971-12-06 Eliad Emanuel Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29796 29796 1966-09-15 1962-02-28 Sover Yitzhak Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29840 29840 1988-09-15 1986-02-19 Barak Daphna Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29841 29841 1988-09-15 1986-02-19 Ben-David Tsion Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29842 29842 1988-09-15 1986-02-19 Gafni Uzi Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29843 29843 1988-09-15 1986-02-19 Gil-Ad Amnon Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29844 29844 1988-09-15 1986-02-19 Shulman Hedy Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29845 29845 1988-09-15 1986-02-19 Zurel Shmuel Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29846 29846 1988-09-15 1976-04-01 Kolani Dov Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29847 29847 1988-09-15 1976-04-01 Shoshani Moshe Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29848 29848 1988-09-15 1978-05-16 Jones Vendyl Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29852 29852 1988-09-15 1969-07-17 Berman Mira Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29853 29853 1988-09-15 1969-09-04 Zur Amram Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29854 29854 1988-09-15 1974-09-05 Peleg Eiozer Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29855 29855 1988-09-15 1974-09-05 Strollman Sonja Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29857 29857 1988-09-15 1977-11-08 Linn Amnon Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
29858 29858 1988-09-15 1971-12-06 Shiby Arie Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
30182 30182 1975-09-21 1971-12-06 Yitzhak Sover Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
30804 30804 1952-09-30 1951-09-26 Katz Lillian Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
30805 30805 1952-09-30 1952-10-15 Laby Simcha Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
33470 33470 1982-10-23 1978-05-16 Leshem Dov Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
34016 34016 1965-10-30 1965-10-01 Barouch Itzhak Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
34055 34055 1986-10-30 1986-02-19 Pollack Lenore Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
35355 35355 1973-11-07 1959-04-23 Gabrielovitz Abraham Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
35357 35357 1973-11-07 1961-06-08 Wollock Roberta Gay Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
35785 35785 1960-11-15 1959-04-23 Goldstone Adrienne Joy Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
36588 36588 1956-11-30 1956-07-20 Tchernoff Ruth Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
36589 36589 1956-11-30 1955-10-26 Silver Helen Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
37266 37266 1965-12-01 1962-02-28 Koch Judith B. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
37267 37267 1965-12-01 1963-04-03 Markman Elsa Louise Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
37281 37281 1970-12-01 1968-03-15 Levy Jacob Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
37287 37287 1971-12-01 1969-03-24 Tory Ness Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
38920 38920 1967-12-22 1963-04-03 Gil-Ad Amnon Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39605 39605 1957-12-31 1957-07-19 Cohen Miriam Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39622 39622 1957-12-31 1953-09-10 Grunwald Matilda Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39655 39655 1958-12-31 1958-05-05 Lerich Moshe Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39663 39663 1958-12-31 1953-12-14 Ben-Eli Shmuel Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39733 39733 1962-12-31 1961-05-22 Elkort Martin Edward Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39746 39746 1962-12-31 1961-09-14 Goldenberg Bella Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39792 39792 1965-12-31 1965-10-01 Weber Florence Davida Redman Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118
39819 39819 1966-12-31 1961-05-25 Petty Laurence J. Israel Government Tourist Office 620 1950-03-27 Israel Government Tourist Office 350 Fifth Avenue   New York NY 10118

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