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_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 20
- Government of Israel Supply Mission 2
- Herut Party in Israel 2
- Manufacturers' Association of Israel 2
- Bank Hapoalim, B.M. 1
- Bedek Aircraft, Ltd. 1
- Clal Israel, Ltd. 1
- Defense Ministry of Israel, Government of Israel 1
- El-Al Israel National Airlines 1
- General Federation of Jewish Labor in Israel - Histadrut Haovdim 1
- Israel Aircraft Industries (Formerly: Bedek Aircraft, Ltd.) 1
- Israeli Military Industries 1
- Jewelry of Israel/Israel Export Institute 1
- LAHAB 1
- Mekoroth Water Company, Ltd. 1
- Municipality of Tel-Aviv-Yafo 1
- Provisional Government of Israel 1
- Shlomzion 1
- State of Israel 1
- Tenuat HaHerut 1
- Ultramar International Company, Ltd. 1
Registrant_Date (date) 17 ✖
- 1951-04-26 5
- 1955-04-18 3
- 1946-02-25 1
- 1948-12-27 1
- 1948-12-28 1
- 1950-02-01 1
- 1950-06-08 1
- 1951-04-16 1
- 1957-05-15 1
- 1957-05-29 1
- 1957-12-20 1
- 1977-04-06 1
- 1979-03-22 1
- 1985-10-15 1
- 1986-07-11 1
- 1987-05-28 1
- 1987-05-29 1
Registrant_Name 16
- Ultramar International Corporation 5
- Davidson, I. Irving 3
- Begin, Menachem 2
- Crowell & Moring 1
- Crowell & Moring International, LLC 1
- Crum, Bartley C. 1
- Foreign Supply Company, Inc. 1
- GCI Group, Inc. 1
- Gass, Oscar 1
- Goldstein, Gustave Louis 1
- Kohn, Nathan Stolzer 1
- Levin, Nahum 1
- Lurie, Yehudith 1
- Skadden, Arps, Slate, Meagher & Flom 1
- Stroock & Stroock & Lavan 1
- Warren, James 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2034 | 2034 | 1989-02-01 | Jewelry of Israel/Israel Export Institute | 1988-04-08 | ISRAEL | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Tel-Aviv | ||||
2777 | 2777 | 1960-02-25 | Provisional Government of Israel | 1948-08-05 | ISRAEL | Gass, Oscar 345 | 1946-02-25 | Gass, Oscar | Tel-Aviv | ||||
3921 | 3921 | 1951-03-21 | Defense Ministry of Israel, Government of Israel | 1950-06-08 | ISRAEL | Foreign Supply Company, Inc. 627 | 1950-06-08 | Foreign Supply Company, Inc. | Tel-Aviv | ||||
5320 | 5320 | 1952-04-16 | Government of Israel Supply Mission | 1951-04-16 | ISRAEL | Kohn, Nathan Stolzer 668 | 1951-04-16 | Kohn, Nathan Stolzer | Tel-Aviv | ||||
6537 | 6537 | 1957-05-15 | Herut Party in Israel | 1957-05-15 | ISRAEL | Begin, Menachem 1024 | 1957-05-15 | Begin, Menachem | Tel-Aviv | ||||
6711 | 6711 | 1987-05-22 | Manufacturers' Association of Israel | 1987-05-28 | ISRAEL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Tel-Aviv | ||||
6712 | 6712 | 1987-05-22 | Manufacturers' Association of Israel | 1987-05-29 | ISRAEL | Crowell & Moring 3987 | 1987-05-29 | Crowell & Moring | Tel-Aviv | ||||
6897 | 6897 | 1957-05-29 | Herut Party in Israel | 1957-05-29 | ISRAEL | Levin, Nahum 1031 | 1957-05-29 | Levin, Nahum | Tel-Aviv | ||||
7909 | 7909 | 1973-06-18 | Bedek Aircraft, Ltd. | 1960-05-19 | ISRAEL | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Tel-Aviv | ||||
7913 | 7913 | 1973-06-18 | Israel Aircraft Industries (Formerly: Bedek Aircraft, Ltd.) | 1960-11-18 | ISRAEL | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Tel-Aviv | ||||
7914 | 7914 | 1973-06-18 | Israeli Military Industries | 1958-07-22 | ISRAEL | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Tel-Aviv | ||||
7975 | 7975 | 1977-06-21 | Shlomzion | 1977-04-06 | ISRAEL | Warren, James 2770 | 1977-04-06 | Warren, James | Tel-Aviv | ||||
8007 | 8007 | 1989-06-22 | Clal Israel, Ltd. | 1988-11-04 | ISRAEL | Skadden, Arps, Slate, Meagher & Flom 3746 | 1985-10-15 | Skadden, Arps, Slate, Meagher & Flom | Tel-Aviv | ||||
8218 | 8218 | 1953-06-30 | El-Al Israel National Airlines | 1951-04-26 | ISRAEL | Ultramar International Corporation 673 | 1951-04-26 | Ultramar International Corporation | Tel-Aviv | ||||
8219 | 8219 | 1953-06-30 | Government of Israel Supply Mission | 1951-04-26 | ISRAEL | Ultramar International Corporation 673 | 1951-04-26 | Ultramar International Corporation | Tel-Aviv | ||||
8220 | 8220 | 1953-06-30 | Mekoroth Water Company, Ltd. | 1951-04-26 | ISRAEL | Ultramar International Corporation 673 | 1951-04-26 | Ultramar International Corporation | Tel-Aviv | ||||
8222 | 8222 | 1953-06-30 | Ultramar International Company, Ltd. | 1951-04-26 | ISRAEL | Ultramar International Corporation 673 | 1951-04-26 | Ultramar International Corporation | Tel-Aviv | ||||
9952 | 9952 | 1958-08-01 | State of Israel | 1950-02-01 | ISRAEL | Goldstein, Gustave Louis 609 | 1950-02-01 | Goldstein, Gustave Louis | Tel-Aviv | ||||
11199 | 11199 | 1951-09-01 | LAHAB | 1951-04-26 | ISRAEL | Ultramar International Corporation 673 | 1951-04-26 | Ultramar International Corporation | Tel-Aviv | ||||
11779 | 11779 | 1983-09-23 | Bank Hapoalim, B.M. | 1979-03-22 | ISRAEL | Stroock & Stroock & Lavan 3005 | 1979-03-22 | Stroock & Stroock & Lavan | Tel-Aviv | ||||
14932 | 14932 | 1959-12-10 | Municipality of Tel-Aviv-Yafo | 1957-12-20 | ISRAEL | Crum, Bartley C. 1095 | 1957-12-20 | Crum, Bartley C. | Tel-Aviv | ||||
15395 | 15395 | 1948-12-27 | General Federation of Jewish Labor in Israel - Histadrut Haovdim | 1948-12-27 | ISRAEL | Lurie, Yehudith 553 | 1948-12-27 | Lurie, Yehudith | Tel-Aviv | ||||
15420 | 15420 | 1948-12-28 | Tenuat HaHerut | 1948-12-28 | ISRAEL | Begin, Menachem 551 | 1948-12-28 | Begin, Menachem | 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]) );