FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Address_1 = "Tel Aviv" and Country/Location_Represented = "ISRAEL"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 19
- Israel Labor Party 3
- Israel Aircraft Industries, Ltd. 2
- Israel Export Institute 2
- Democratic Movement for Change 1
- Gadot Petrochemical Industries, Ltd. 1
- General Federation of Jewish Labor - Histadrut Haovdim 1
- General Federation of Jewish Labor in Israel 1
- Gilat Satellite Networks, Ltd. 1
- Government of Israel (Through Express Service Transport, Ltd. & Collector of Customs, Tel Aviv) 1
- Ha'aretz 1
- Herut Party of Israel 1
- Israel Aircraft Industries 1
- Israel Company for Fairs & Exhibitions, Ltd. 1
- Israel Land Development Company 1
- Israel National Oil Company, Ltd. 1
- Likud Party of Israel 1
- Menahem Begin 1
- Salgad International 1
- Silberherz & Weidler 1
Registrant_Name 18
- Ruder Finn, Inc. 3
- Family Export & Shipping Company, Inc. 2
- Friedman, Steven L. 2
- Law Offices of Cohen & Uretz 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Ben-Zevie, Isaac 1
- Fund for the Democratic Movement for Change 1
- Furst, Zev 1
- GCI Group, Inc. 1
- Galland, Kharasch, Morse & Garfinkle, P.C. 1
- Haft, Abraham 1
- International Strategies, Inc. 1
- Kaplan, Russin & Vecchi 1
- Katz, Samuel 1
- Krosney Productions, Ltd. 1
- Mershon, W. Russell 1
- Morris J. Amitay, P.C. 1
- Tavori, Avner 1
Registrant_Date (date) 18 ✖
- 1961-09-27 3
- 1950-01-11 2
- 1971-07-29 2
- 1987-08-18 2
- 1948-12-20 1
- 1948-12-29 1
- 1970-01-16 1
- 1977-04-12 1
- 1977-06-09 1
- 1983-06-24 1
- 1986-07-11 1
- 1987-06-23 1
- 1988-02-11 1
- 1988-05-09 1
- 1992-03-13 1
- 1992-04-24 1
- 1993-08-03 1
- 1994-01-26 1
State 1
- - 23
Country/Location_Represented 1
- ISRAEL · 23 ✖
City 1
- - 23
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1386 | 1386 | 1989-01-17 | Israel Labor Party | 1987-08-18 | ISRAEL | Tavori, Avner 4027 | 1987-08-18 | Tavori, Avner | Tel Aviv | ||||
2516 | 2516 | 1996-02-14 | Israel Aircraft Industries | 1993-08-03 | ISRAEL | Morris J. Amitay, P.C. 4838 | 1993-08-03 | Morris J. Amitay, P.C. | Tel Aviv | ||||
4091 | 4091 | 1997-03-27 | Ha'aretz | 1995-10-27 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Tel Aviv | ||||
5007 | 5007 | 1989-04-03 | Herut Party of Israel | 1988-05-09 | ISRAEL | Friedman, Steven L. 4138 | 1988-05-09 | Friedman, Steven L. | Tel Aviv | ||||
5331 | 5331 | 1993-04-16 | Israel Labor Party | 1987-08-18 | ISRAEL | Mershon, W. Russell 4026 | 1987-08-18 | Mershon, W. Russell | Tel Aviv | ||||
5967 | 5967 | 1998-04-30 | Israel Land Development Company | 1994-04-29 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Tel Aviv | ||||
6471 | 6471 | 1978-05-12 | Democratic Movement for Change | 1977-04-12 | ISRAEL | Fund for the Democratic Movement for Change 2775 | 1977-04-12 | Fund for the Democratic Movement for Change | Tel Aviv | ||||
6640 | 6640 | 1978-05-18 | Menahem Begin | 1977-06-09 | ISRAEL | Katz, Samuel 2786 | 1977-06-09 | Katz, Samuel | Tel Aviv | ||||
7406 | 7406 | 1989-06-01 | Salgad International | 1985-10-25 | ISRAEL | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | Tel Aviv | ||||
9169 | 9169 | 1951-07-11 | Government of Israel (Through Express Service Transport, Ltd. & Collector of Customs, Tel Aviv) | 1950-01-11 | ISRAEL | Family Export & Shipping Company, Inc. 605 | 1950-01-11 | Family Export & Shipping Company, Inc. | Tel Aviv | ||||
9171 | 9171 | 1951-07-11 | Silberherz & Weidler | 1952-07-29 | ISRAEL | Family Export & Shipping Company, Inc. 605 | 1950-01-11 | Family Export & Shipping Company, Inc. | Tel Aviv | ||||
9300 | 9300 | 1971-07-16 | Israel Company for Fairs & Exhibitions, Ltd. | 1970-09-30 | ISRAEL | Krosney Productions, Ltd. 2180 | 1970-01-16 | Krosney Productions, Ltd. | Tel Aviv | ||||
9844 | 9844 | 2003-07-31 | Gilat Satellite Networks, Ltd. | 1993-11-01 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Tel Aviv | ||||
10028 | 10028 | 1996-08-01 | Likud Party of Israel | 1992-03-13 | ISRAEL | Friedman, Steven L. 4631 | 1992-03-13 | Friedman, Steven L. | Tel Aviv | ||||
10742 | 10742 | 1993-08-25 | Israel Aircraft Industries, Ltd. | 1988-04-21 | ISRAEL | Galland, Kharasch, Morse & Garfinkle, P.C. 4006 | 1987-06-23 | Galland, Kharasch, Morse & Garfinkle, P.C. | Tel Aviv | ||||
10762 | 10762 | 1985-08-26 | Israel National Oil Company, Ltd. | 1981-09-08 | ISRAEL | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | Tel Aviv | ||||
11021 | 11021 | 1992-08-31 | Israel Labor Party | 1992-04-24 | ISRAEL | Furst, Zev 4652 | 1992-04-24 | Furst, Zev | Tel Aviv | ||||
11513 | 11513 | 1992-09-11 | Gadot Petrochemical Industries, Ltd. | 1990-09-21 | ISRAEL | Kaplan, Russin & Vecchi 4092 | 1988-02-11 | Kaplan, Russin & Vecchi | Tel Aviv | ||||
12801 | 12801 | 1994-10-17 | Israel Export Institute | 1994-01-26 | ISRAEL | International Strategies, Inc. 4886 | 1994-01-26 | International Strategies, Inc. | Tel Aviv | ||||
13261 | 13261 | 1989-10-31 | Israel Export Institute | 1988-10-04 | ISRAEL | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Tel Aviv | ||||
15237 | 15237 | 1948-12-20 | General Federation of Jewish Labor in Israel | 1948-12-20 | ISRAEL | Haft, Abraham 548 | 1948-12-20 | Haft, Abraham | Tel Aviv | ||||
15438 | 15438 | 1948-12-29 | General Federation of Jewish Labor - Histadrut Haovdim | 1948-12-29 | ISRAEL | Ben-Zevie, Isaac 552 | 1948-12-29 | Ben-Zevie, Isaac | Tel Aviv | ||||
15878 | 15878 | 1982-12-31 | Israel Aircraft Industries, Ltd. | 1971-07-29 | ISRAEL | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | Tel Aviv |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );