home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

284 rows where Country/Location_Represented = "ISRAEL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name >30

  • Ruder Finn, Inc. 11
  • North American Precis Syndicate 10
  • Rafiah, Zvi 7
  • GCI Group, Inc. 6
  • Arnold & Porter Kaye Scholer LLP 5
  • Boukstein, Maurice M. 5
  • Crowell & Moring International, LLC 5
  • Dow, Lohnes & Albertson, L.L.P. 5
  • Israel Communications, Inc. 5
  • Ultramar International Corporation 5
  • Fried, Frank, Harris, Shriver & Jacobson 4
  • Law Offices of Cohen & Uretz 4
  • Modern Education Services, Inc. 4
  • Robert R. Nathan Associates, Inc. 4
  • Cannon Advertising Associates, Inc. 3
  • DDB Worldwide Communications Group, Inc. 3
  • Davidson, I. Irving 3
  • Galli, Ran 3
  • Kaplan, Russin & Vecchi 3
  • Rubenstein Associates, Inc. 3
  • Teicher, Howard R. 3
  • Association Films, Inc. 2
  • Begin, Menachem 2
  • Charney, Leon H. 2
  • Family Export & Shipping Company, Inc. 2
  • Friedman, Steven L. 2
  • Gass, Oscar 2
  • Ginsburg, Feldman & Bress 2
  • Goldman, Hilton 2
  • Havas Media Group USA LLC 2
  • …

Foreign_Principal >30

  • Government of Israel 17
  • Israel Government Tourist Office 13
  • Israel Ministry of Tourism 12
  • State of Israel 9
  • Consulate General of Israel 5
  • Israel Aircraft Industries, Ltd. 5
  • Teddy Kollek 5
  • Embassy of Israel 4
  • Government of Israel Investment Authority 4
  • Government of Israel Supply Mission 4
  • Provisional Government of Israel 4
  • El-Al Israel Airlines 3
  • Government of Israel Trade Center 3
  • Hebrew University of Jerusalem 3
  • Israel Labor Party 3
  • Manufacturers' Association of Israel 3
  • Rafael U.S.A., Inc. 3
  • Ameribrom, Inc. 2
  • Bank of Israel 2
  • Democratic Movement for Change 2
  • Gadot Petrochemical Industries, Ltd. 2
  • General Federation of Jewish Labor in Israel 2
  • Government of Israel Tourist Office 2
  • Government of Israel, Ministry of Defense, Mission to the U.S. 2
  • Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) 2
  • Herut Party in Israel 2
  • Israel Eastbound Conference 2
  • Israel Export Institute 2
  • Israel Ministry of Tourism, N.A. 2
  • Israel Westbound Conference 2
  • …

City 11

  • - 265
  • Jerusalem 5
  • Herzelia 3
  • New York 3
  • Tel Aviv 2
  • JERUSALEM 1
  • Chicago 1
  • Haifa 1
  • Herzliya 1
  • Miami 1
  • Philadelphia 1

State 9

  • - 185
  • NY 74
  • DC 14
  • IL 4
  • CA 2
  • NJ 2
  • FL 1
  • MI 1
  • PA 1

Country/Location_Represented 1

  • ISRAEL · 284 ✖
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
148 148   Dr. Gal Luft 2023-02-21 ISRAEL Law Offices of Robert Henoch PLLC 7230 2023-02-21 Law Offices of Robert Henoch PLLC HaZamir 2   Haifa    
234 234   Executive of the World Zionist Organization, Jerusalem 1971-09-21 ISRAEL World Zionist Organization - American Section, Inc. 2278 1971-09-21 World Zionist Organization - American Section, Inc.          
272 272   Government of Israel 1992-07-27 ISRAEL Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Jerusalem        
273 273   Government of Israel, Ministry of Foreign Affairs 2022-04-28 ISRAEL Tishby, Noa 7110 2022-04-28 Tishby, Noa Ministry of Foreign Affairs, 9 Yitzhak Rabin Blvd   Jerusalem    
274 274   Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency [LAPAM]) 2023-02-27 ISRAEL Havas Media Group USA LLC 7106 2022-04-08 Havas Media Group USA LLC 9 Ahad Haam Street Shalom Tower Tel Aviv    
351 351   Israel Ministry of Foreign Affairs 2019-01-09 ISRAEL Holland & Knight 3718 1985-08-07 Holland & Knight Consulate General of Israel 100 Biscayne Blvd. Miami FL 33132
352 352   Israel Ministry of Tourism 2017-12-15 ISRAEL MWW Group, LLC 6381 2016-09-30 MWW Group, LLC 800 2nd Avenue Floor 6 New York NY 10017
370 370   Jewish Agency for Israel 2013-10-29 ISRAEL Jewish Agency - American Section, Inc. 6191 2013-10-29 Jewish Agency - American Section, Inc. 48 King George Street Jerusalem 91000      
458 458   Ministry of Foreign Affairs 2023-03-04 ISRAEL Merchant House Films, LLC 7234 2023-03-04 Merchant House Films, LLC 9 Yitzhak Rabin Blvd., Kiryat Ben-Gurion   JERUSALEM    
477 477   Movement for Quality Government in Israel 2020-09-29 ISRAEL Miller & Chevalier Chartered 6533 2018-03-15 Miller & Chevalier Chartered P.O. Box 36054   Jerusalem    
488 488   NSO Group via Pillsbury Winthrop Shaw Pittman LLP 2022-01-12 ISRAEL Chartwell Strategy Group, LLC 6518 2018-02-02 Chartwell Strategy Group, LLC 16 Galgaley HaPlada Street   Herzelia    
489 489   NSO Group 2022-01-24 ISRAEL Paul Hastings LLP 6743 2019-10-25 Paul Hastings LLP 16 Galgaley Ha Plada Street   Herzelia    
490 490   NSO Group 2021-06-30 ISRAEL Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 16 Galgaley HaPlada Street 4672216 Herzelia    
628 628   State of Israel, Embassy 1988-01-20 ISRAEL Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP          
961 961 2002-01-01 Rafael Armament Development Authority 1992-12-01 ISRAEL Rafiah, Zvi 4736 1992-12-01 Rafiah, Zvi Haifa        
1068 1068 1993-01-06 Soltam, Ltd. 1992-12-01 ISRAEL Rafiah, Zvi 4736 1992-12-01 Rafiah, Zvi Haifa        
1134 1134 1945-01-09 Erez Israel (Palestine) Foundation Fund Keren Hayesod, Ltd. 1942-07-09 ISRAEL Blumenfeld, Kurt 30 1942-07-09 Blumenfeld, Kurt Behavia, Jerusalem        
1356 1356 1989-01-17 Israel Labor Party 1987-08-18 ISRAEL Tavori, Avner 4027 1987-08-18 Tavori, Avner Tel Aviv        
1403 1403 1988-01-20 Embassy of the Government of Israel 1979-03-06 ISRAEL Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP Washington     DC  
1447 1447 1995-01-23 Elscint, Inc. 1992-05-21 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Haifa        
1454 1454 1950-01-24 Provisional Government of Israel 1949-01-24 ISRAEL Koppel, Yehuda 558 1949-01-24 Koppel, Yehuda          
1456 1456 1966-01-24 Government of Israel Investment Authority 1965-10-14 ISRAEL Bikel, Ofra 1931 1965-10-14 Bikel, Ofra New York     NY  
1503 1503 1977-01-26 State of Israel 1972-01-28 ISRAEL Guggenheim Productions, Inc. 2311 1972-01-28 Guggenheim Productions, Inc. Jerusalem        
1631 1631 1955-01-31 Jewish Agency for Palestine 1949-06-28 ISRAEL Robert R. Nathan Associates, Inc. 352 1946-04-22 Robert R. Nathan Associates, Inc.          
1646 1646 1961-01-31 Government of Israel 1960-12-07 ISRAEL Covington & Burling 523 1948-04-16 Covington & Burling Asbury Park     NJ  
1804 1804 2002-01-31 Enavis Networks, Ltd. 2001-08-03 ISRAEL Manning, Selvage & Lee 5397 2000-11-16 Manning, Selvage & Lee 16 Martin Gehl Street P.O. Box 448 Petah Tikva 49105        
1859 1859 2012-01-31 Margalit, Erel 2011-07-22 ISRAEL Margalit, Erel 6050 2011-07-22 Margalit, Erel 24 Hebron Road   Jerusalem    
1949 1949 1971-02-01 Government of Israel Tourist Office 1970-01-16 ISRAEL Krosney Productions, Ltd. 2180 1970-01-16 Krosney Productions, Ltd. New York     NY  
2003 2003 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        
2024 2024 1996-02-01 State of Israel 1995-11-02 ISRAEL Rubenstein Associates, Inc. 4778 1993-03-12 Rubenstein Associates, Inc. New York     NY  
2231 2231 1989-02-07 Zvi Zilker, Director-General, Ministry of Communications 1985-03-17 ISRAEL Weitzman, James M. 3613 1984-09-17 Weitzman, James M.          
2368 2368 1987-02-12 Israel Ministry of Tourism, N.A. 1986-08-22 ISRAEL Thomas L. Richmond, Inc. 3875 1986-08-22 Thomas L. Richmond, Inc. New York     NY  
2391 2391 1996-02-12 Consulate General of Israel (formerly: Israel Information Service) 1969-05-29 ISRAEL Alden Films, Business Education Films, Films of the Nations 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
2419 2419 1996-02-13 TAAS, Israeli Industries, Ltd. (I.M.I.) 1992-12-01 ISRAEL Rafiah, Zvi 4736 1992-12-01 Rafiah, Zvi Ramat-Hasharon        
2420 2420 1997-02-13 Israel Aircraft Industries, Ltd. 1978-05-25 ISRAEL Klemow, Marvin G. 2919 1978-05-25 Klemow, Marvin G. Ben Gurion Airport        
2439 2439 1971-02-14 Israel Government Tourist Office 1970-03-11 ISRAEL Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
2467 2467 1996-02-14 Manufacturers' Association of Israel 1995-08-25 ISRAEL Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC TelAviv        
2483 2483 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        
2590 2590 2021-02-17 Naftali David Ehrenfreund 2020-08-28 ISRAEL Kasowitz Benson Torres, LLP 6863 2020-08-28 Kasowitz Benson Torres, LLP 30 Sdey Hemed St., Modi'in ILLIT 7181130      
2674 2674 1992-02-22 Government of Israel 1992-01-09 ISRAEL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
2691 2691 1979-02-23 Teddy Kollek 1978-07-20 ISRAEL Bialkin, Kenneth J. 2931 1978-07-20 Bialkin, Kenneth J. Jerusalem        
2704 2704 1975-02-24 Government of Israel 1974-07-24 ISRAEL Loeb, Rhoades & Company 2527 1974-07-24 Loeb, Rhoades & Company Washington     DC  
2734 2734 1960-02-25 Government of Israel 1950-04-04 ISRAEL Gass, Oscar 345 1946-02-25 Gass, Oscar Hakiryah        
2744 2744 1960-02-25 Provisional Government of Israel 1948-08-05 ISRAEL Gass, Oscar 345 1946-02-25 Gass, Oscar Tel-Aviv        
2825 2825 1977-02-26 Israel Aircraft Industries, Ltd. 1977-06-20 ISRAEL Klemow, Marvin G. 2800 1977-06-20 Klemow, Marvin G. Ben Gurion Airport        
2840 2840 1960-02-27 Ministry of Finance, Government of Israel 1956-02-27 ISRAEL Bell, Bernard R. 931 1956-02-27 Bell, Bernard R. Jerusalem        
2953 2953 1992-02-28 Israel Democracy Trust 1992-04-28 ISRAEL Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Jerusalem        
3043 3043 2006-02-28 Hebrew University of Jerusalem 2002-08-02 ISRAEL Nurnberger & Associates, Inc. 5516 2002-08-02 Nurnberger & Associates, Inc. Jerusalem 91904        
3451 3451 2013-03-06 Plasan Sasa, Ltd. 2009-08-21 ISRAEL QORVIS LLC 5483 2002-03-06 QORVIS LLC M.P. Merom Hagalii 13870        
3537 3537 1996-03-10 Government of Israel 1995-05-12 ISRAEL Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Washington     DC  
3762 3762 1970-03-16 Government of Israel 1950-02-28 ISRAEL Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress Washington     DC  
3764 3764 1970-03-16 Mission to the U.S. Provisional Government of Israel 1948-09-16 ISRAEL Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress Washington     DC  
3876 3876 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        
3901 3901 1994-03-21 Teddy Kollek 1993-07-09 ISRAEL Teddy Kollek for Mayor 4828 1993-07-09 Teddy Kollek for Mayor Jerusalem        
4045 4045 1997-03-27 Ha'aretz 1995-10-27 ISRAEL Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Tel Aviv        
4127 4127 1988-03-30 ZIM Israel Navigation Company, Ltd. 1987-04-21 ISRAEL Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Haifa        
4132 4132 1990-03-30 Teddy Kollek 1988-08-02 ISRAEL Teddy Kollek for Mayor 4164 1988-08-02 Teddy Kollek for Mayor Jerusalem        
4571 4571 2003-03-31 I.I.S. Intelligent Information Systems 2002-10-29 ISRAEL Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Twins One Building 33 Jabotinsky Street Ramat Gan 52511        
4887 4887 1997-04-01 Government of Israel Economic Mission 1994-01-12 ISRAEL Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4951 4951 1989-04-03 Herut Party of Israel 1988-05-09 ISRAEL Friedman, Steven L. 4138 1988-05-09 Friedman, Steven L. Tel Aviv        
4973 4973 1966-04-05 Consulate General of the State of Israel 1964-07-21 ISRAEL Groban & Rava 1772 1964-07-21 Groban & Rava New York     NY  
5030 5030 2020-04-07 Zari David ( Eliezer) KOVO 2020-01-25 ISRAEL Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy  6399 2016-12-11 Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy          
5081 5081 1986-04-10 Israel Ministry of Tourism 1986-02-07 ISRAEL Marketshare 3775 1986-02-07 Marketshare       NY  
5123 5123 1973-04-12 Consulate General of Israel - New York 1949-11-29 ISRAEL Boukstein, Maurice M. 544 1948-11-02 Boukstein, Maurice M.          
5124 5124 1973-04-12 Housing Authority, Government of Israel 1961-10-30 ISRAEL Boukstein, Maurice M. 544 1948-11-02 Boukstein, Maurice M.          
5125 5125 1973-04-12 Jewish Agency - American Section - Inc. 1960-08-08 ISRAEL Boukstein, Maurice M. 544 1948-11-02 Boukstein, Maurice M.          
5126 5126 1973-04-12 Jewish Agency of Palestine 1949-11-29 ISRAEL Boukstein, Maurice M. 544 1948-11-02 Boukstein, Maurice M.          
5127 5127 1973-04-12 Provisional Government of Israel 1948-11-02 ISRAEL Boukstein, Maurice M. 544 1948-11-02 Boukstein, Maurice M.          
5163 5163 1988-04-12 Consulate General of Israel 1987-10-26 ISRAEL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5210 5210 1995-04-14 State of Israel 1993-03-12 ISRAEL Rubenstein Associates, Inc. 4778 1993-03-12 Rubenstein Associates, Inc. New York     NY  
5237 5237 1994-04-15 Bank Leumi le-Israel, B.M. 1992-02-11 ISRAEL Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New York     NY  
5263 5263 1952-04-16 Government of Israel Supply Mission 1951-04-16 ISRAEL Kohn, Nathan Stolzer 668 1951-04-16 Kohn, Nathan Stolzer Tel-Aviv        
5274 5274 1993-04-16 Israel Labor Party 1987-08-18 ISRAEL Mershon, W. Russell 4026 1987-08-18 Mershon, W. Russell Tel Aviv        
5418 5418 1991-04-22 Israel Government Tourist Office 1991-04-22 ISRAEL M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. New York     NY  
5439 5439 1993-04-23 Peace & Civil Liberties Movement 1981-04-01 ISRAEL Low, Joseph 3222 1981-04-01 Low, Joseph          
5714 5714 1956-04-30 Israel Government Tourist Office 1956-04-03 ISRAEL Nichols & Peters 938 1956-04-03 Nichols & Peters New York     NY  
5744 5744 1975-04-30 Government of Israel Supply Mission 1973-11-16 ISRAEL Robert R. Nathan Associates, Inc. 352 1946-04-22 Robert R. Nathan Associates, Inc.          
5779 5779 1988-04-30 Israel Ministry of Tourism 1987-07-15 ISRAEL M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc.          
5780 5780 1988-04-30 Israel-America Chamber of Commerce & Industry (1965), Ltd. 1987-10-22 ISRAEL APCO Associates 3597 1984-06-20 APCO Associates          
5889 5889 1995-04-30 Magal Security Systems, Ltd. 1993-05-14 ISRAEL Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey          
5908 5908 1998-04-30 Israel Land Development Company 1994-04-29 ISRAEL Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Tel Aviv        
6100 6100 1977-05-01 Kacl 1977-06-27 ISRAEL Goldman, Hilton 2798 1977-06-27 Goldman, Hilton Jerusalem        
6137 6137 1986-05-01 World Zionist Organization, Jerusalem 1985-02-12 ISRAEL Cole Corette & Abrutyn, P.C. 2968 1978-10-18 Cole Corette & Abrutyn, P.C.          
6224 6224 1977-05-03 Democratic Movement for Change 1977-05-05 ISRAEL Dutka, Solomon 2780 1977-05-05 Dutka, Solomon Jerusalem        
6225 6225 1989-05-03 KACH 1988-09-13 ISRAEL Becker, Brett G. 4176 1988-09-13 Becker, Brett G. Jerusalem        
6239 6239 1994-05-03 Israel Shipyards, Ltd. 1990-06-19 ISRAEL Teicher, Howard R. 4389 1990-06-19 Teicher, Howard R. Haifa        
6240 6240 1994-05-03 RAFAEL - Armament Development Authority 1992-03-20 ISRAEL Teicher, Howard R. 4389 1990-06-19 Teicher, Howard R. Haifa        
6241 6241 1994-05-03 Soreq Nuclear Research Center 1991-01-31 ISRAEL Teicher, Howard R. 4389 1990-06-19 Teicher, Howard R. Yavne        
6265 6265 1993-05-04 Consulate (Central Region) of the State of Israel 1989-09-12 ISRAEL Jasculca/Terman & Associates, Inc. 4289 1989-09-12 Jasculca/Terman & Associates, Inc. Chicago     IL  
6283 6283 1953-05-06 Consulate General of Israel 1953-05-06 ISRAEL Goldman, Ralph Irving 764 1953-05-06 Goldman, Ralph Irving New York     NY  
6352 6352 1992-05-08 Government of Israel 1992-01-09 ISRAEL APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. New York     NY  
6411 6411 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        
6413 6413 1993-05-12 Consulate General of Israel 1993-01-14 ISRAEL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
6445 6445 1982-05-13 Embassy of Israel 1950-05-16 ISRAEL Robert R. Nathan Associates, Inc. 352 1946-04-22 Robert R. Nathan Associates, Inc.          
6472 6472 1993-05-14 Israel Consulate 1977-03-14 ISRAEL Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
6477 6477 1957-05-15 Herut Party in Israel 1957-05-15 ISRAEL Begin, Menachem 1024 1957-05-15 Begin, Menachem Tel-Aviv        
6486 6486 1968-05-15 Consul General of Israel 1967-07-19 ISRAEL Cannon Advertising Associates, Inc. 1945 1965-12-14 Cannon Advertising Associates, Inc. New York     NY  
6562 6562 1979-05-17 Government of Israel Investment Authority 1975-10-15 ISRAEL Kekst & Company 2618 1975-10-15 Kekst & Company New York     NY  
6580 6580 1978-05-18 Menahem Begin 1977-06-09 ISRAEL Katz, Samuel 2786 1977-06-09 Katz, Samuel Tel Aviv        
6607 6607 1986-05-20 Tadiran Electronic Industries, Inc. 1985-02-21 ISRAEL Fried, Frank, Harris, Shriver & Jacobson 3473 1983-05-20 Fried, Frank, Harris, Shriver & Jacobson       NY  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 207.544ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history