FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Address_1 = "Jerusalem" 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)
Registrant_Date (date) 28 ✖
- 1968-08-02 2
- 1978-07-20 2
- 1943-09-14 1
- 1953-08-03 1
- 1954-05-18 1
- 1956-02-27 1
- 1959-09-15 1
- 1961-09-27 1
- 1965-04-23 1
- 1965-12-30 1
- 1971-01-31 1
- 1971-03-08 1
- 1971-07-29 1
- 1972-01-28 1
- 1973-10-30 1
- 1975-05-28 1
- 1977-05-05 1
- 1977-06-27 1
- 1981-11-10 1
- 1982-06-02 1
- 1983-08-03 1
- 1985-09-13 1
- 1986-03-12 1
- 1987-03-18 1
- 1987-05-28 1
- 1988-08-02 1
- 1988-09-13 1
- 1993-07-09 1
Registrant_Name 27
- Goldman, Hilton 2
- Israel Communications, Inc. 2
- Teddy Kollek for Mayor 2
- ACTS for Israel 1
- American Section of the Jewish Agency for Israel 1
- Becker, Brett G. 1
- Bell, Bernard R. 1
- Bertram, Fred 1
- Bialkin, Kenneth J. 1
- Crowell & Moring International, LLC 1
- Dutka, Solomon 1
- EMB, Ltd. 1
- Eliel, Stefan E. 1
- Golin/Harris Communications, Inc. 1
- Guggenheim Productions, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Israel Philatelic Agency in America, Inc. 1
- J.R. Taft Corporation 1
- Law Offices of Cohen & Uretz 1
- Minkus, Jacques S. 1
- Morgan, Lewis & Bockius, L.L.P. 1
- Parsons, Richard Michael 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Robert B. Meyersburg Company 1
- Ruder Finn, Inc. 1
- Scheuer, Richard J. 1
- Sidley Austin LLP 1
Foreign_Principal 23
- Teddy Kollek 5
- Bank of Israel 2
- Government of Israel 2
- State of Israel 2
- Civil Aviation Adminstration Ministry of Transport, Government of Israel 1
- Democratic Movement for Change 1
- Director General, Ministry of Posts, on Behalf of the State of Israel 1
- Director General, Minstry of Posts 1
- Executive of the Jewish Agency for Palestine 1
- Government of Israel, Ministry of Justice 1
- Haliga L'Haganah y'hudit L'Yisroel (Meir Kahane) 1
- Hebrew University of Jerusalem 1
- Israel Democracy Trust 1
- Israel Government Coins & Medals Corporation 1
- Israel Government Coins & Medals Corporation, Ltd. 1
- Israel Government Coins & Metals 1
- Israel Nature Reserves Authority 1
- Jerusalem Development Authority 1
- KACH 1
- Kacl 1
- Ministry of Finance, Government of Israel 1
- Ministry of Industry & Trade of the Government of Israel 1
- State of Israel, Ministry of Industry & Trade 1
State 1
- - 30
Country/Location_Represented 1
- ISRAEL · 30 ✖
City 1
- - 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
283 | 283 | Government of Israel | 1992-07-27 | ISRAEL | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | Jerusalem | |||||
1534 | 1534 | 1977-01-26 | State of Israel | 1972-01-28 | ISRAEL | Guggenheim Productions, Inc. 2311 | 1972-01-28 | Guggenheim Productions, Inc. | Jerusalem | ||||
2724 | 2724 | 1979-02-23 | Teddy Kollek | 1978-07-20 | ISRAEL | Bialkin, Kenneth J. 2931 | 1978-07-20 | Bialkin, Kenneth J. | Jerusalem | ||||
2873 | 2873 | 1960-02-27 | Ministry of Finance, Government of Israel | 1956-02-27 | ISRAEL | Bell, Bernard R. 931 | 1956-02-27 | Bell, Bernard R. | Jerusalem | ||||
2986 | 2986 | 1992-02-28 | Israel Democracy Trust | 1992-04-28 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Jerusalem | ||||
3946 | 3946 | 1994-03-21 | Teddy Kollek | 1993-07-09 | ISRAEL | Teddy Kollek for Mayor 4828 | 1993-07-09 | Teddy Kollek for Mayor | Jerusalem | ||||
4178 | 4178 | 1990-03-30 | Teddy Kollek | 1988-08-02 | ISRAEL | Teddy Kollek for Mayor 4164 | 1988-08-02 | Teddy Kollek for Mayor | Jerusalem | ||||
6160 | 6160 | 1977-05-01 | Kacl | 1977-06-27 | ISRAEL | Goldman, Hilton 2798 | 1977-06-27 | Goldman, Hilton | Jerusalem | ||||
6284 | 6284 | 1977-05-03 | Democratic Movement for Change | 1977-05-05 | ISRAEL | Dutka, Solomon 2780 | 1977-05-05 | Dutka, Solomon | Jerusalem | ||||
6285 | 6285 | 1989-05-03 | KACH | 1988-09-13 | ISRAEL | Becker, Brett G. 4176 | 1988-09-13 | Becker, Brett G. | Jerusalem | ||||
7757 | 7757 | 1973-06-12 | Israel Government Coins & Medals Corporation | 1969-05-27 | ISRAEL | Israel Communications, Inc. 2097 | 1968-08-02 | Israel Communications, Inc. | Jerusalem | ||||
7758 | 7758 | 1973-06-12 | Israel Government Coins & Metals | 1968-08-02 | ISRAEL | Israel Communications, Inc. 2097 | 1968-08-02 | Israel Communications, Inc. | Jerusalem | ||||
8844 | 8844 | 1975-07-01 | Bank of Israel | 1974-08-29 | ISRAEL | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | Jerusalem | ||||
9263 | 9263 | 1985-07-15 | Israel Nature Reserves Authority | 1983-08-03 | ISRAEL | Parsons, Richard Michael 3504 | 1983-08-03 | Parsons, Richard Michael | Jerusalem | ||||
10068 | 10068 | 1966-08-02 | Government of Israel | 1965-04-23 | ISRAEL | Paul, Weiss, Rifkind, Wharton & Garrison 1888 | 1965-04-23 | Paul, Weiss, Rifkind, Wharton & Garrison | Jerusalem | ||||
10085 | 10085 | 1953-08-03 | Director General, Minstry of Posts | 1953-08-03 | ISRAEL | Minkus, Jacques S. 784 | 1953-08-03 | Minkus, Jacques S. | Jerusalem | ||||
11378 | 11378 | 1975-09-05 | State of Israel | 1975-06-26 | ISRAEL | ACTS for Israel 2587 | 1975-05-28 | ACTS for Israel | Jerusalem | ||||
11411 | 11411 | 1993-09-07 | Jerusalem Development Authority | 1992-09-21 | ISRAEL | Golin/Harris Communications, Inc. 3949 | 1987-03-18 | Golin/Harris Communications, Inc. | Jerusalem | ||||
11604 | 11604 | 1962-09-15 | Bank of Israel | 1959-09-15 | ISRAEL | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Jerusalem | ||||
12439 | 12439 | 1966-10-02 | Israel Government Coins & Medals Corporation, Ltd. | 1965-12-30 | ISRAEL | Bertram, Fred 1950 | 1965-12-30 | Bertram, Fred | Jerusalem | ||||
12487 | 12487 | 1974-10-05 | Haliga L'Haganah y'hudit L'Yisroel (Meir Kahane) | 1973-10-30 | ISRAEL | Goldman, Hilton 2474 | 1973-10-30 | Goldman, Hilton | Jerusalem | ||||
13115 | 13115 | 1971-10-29 | Executive of the Jewish Agency for Palestine | 1954-12-08 | ISRAEL | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | Jerusalem | ||||
13591 | 13591 | 1991-11-01 | Government of Israel, Ministry of Justice | 1990-10-12 | ISRAEL | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | Jerusalem | ||||
13684 | 13684 | 1987-11-03 | Ministry of Industry & Trade of the Government of Israel | 1987-10-13 | ISRAEL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Jerusalem | ||||
13797 | 13797 | 1978-11-07 | Teddy Kollek | 1978-07-20 | ISRAEL | Scheuer, Richard J. 2930 | 1978-07-20 | Scheuer, Richard J. | Jerusalem | ||||
14355 | 14355 | 1979-11-30 | Civil Aviation Adminstration Ministry of Transport, Government of Israel | 1974-09-19 | ISRAEL | Robert B. Meyersburg Company 2242 | 1971-01-31 | Robert B. Meyersburg Company | Jerusalem | ||||
14635 | 14635 | 1972-12-01 | Hebrew University of Jerusalem | 1971-03-08 | ISRAEL | J.R. Taft Corporation 2245 | 1971-03-08 | J.R. Taft Corporation | Jerusalem | ||||
14749 | 14749 | 1966-12-02 | Director General, Ministry of Posts, on Behalf of the State of Israel | 1954-05-18 | ISRAEL | Israel Philatelic Agency in America, Inc. 830 | 1954-05-18 | Israel Philatelic Agency in America, Inc. | Jerusalem | ||||
14991 | 14991 | 1993-12-10 | State of Israel, Ministry of Industry & Trade | 1991-10-21 | ISRAEL | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Jerusalem | ||||
15904 | 15904 | 1983-12-31 | Teddy Kollek | 1982-06-02 | ISRAEL | Eliel, Stefan E. 3376 | 1982-06-02 | Eliel, Stefan E. | Jerusalem |
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]) );