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

38 rows where State = "NJ"

View and edit SQL

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

City

State

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
1566 1961-01-31 Government of Israel 1960-12-07 ISRAEL 523 523 1948-04-16 Covington & Burling Asbury Park     NJ  
1600 1983-01-31 Falcon Jet Corporation 1983-01-10 FRANCE 3435 3435 1983-01-10 Davis, Christopher L. Teterboro     NJ  
2303 1992-02-13 Falcon Jet Corporation, a Subsidiary of Dassault Industries 1992-03-18 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Paramus     NJ  
2315 1998-02-13 Companhia de Navegacao Alianca, S.A. 1997-11-07 BRAZIL 3723 3723 1985-08-15 L.A. Motley & Company South Plainfield     NJ  
2790 1989-02-28 General Biscuit Brands, Inc. 1989-05-31 FRANCE 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Elizabeth     NJ  
3475 1997-03-12 Muslim National Council of Sanjak 1996-06-05 SERBIA 4315 4315 1989-11-09 Ruder Finn, Inc. North Bergen     NJ  
3802 1994-03-24 AMEC Holdings, Inc. 1992-05-11 GREAT BRITAIN 4094 4094 1988-02-25 Thompson & Company Princeton     NJ  
4945 1986-04-12 Haiti National Offices of Tourism 1985-11-05 HAITI 2836 2836 1977-10-12 North American Precis Syndicate       NJ  
5122 2011-04-18 HRH Prince Adel Ibn Prince Mohammad Bin King Feysal (I) El-Hashemite 2011-04-18 IRAQ 6034 6034 2011-04-18 Thy Hashemite Sovereign Royal Family of Iraq Office in the USA 222 Mary Street   Hackensack NJ 07601
5658 1993-04-30 Welsh Development International 1992-08-19 GREAT BRITAIN 4491 4491 1991-04-01 Kuett & Company, Inc. Princeton     NJ  
5714 2001-04-30 SGS North America, Inc. 1986-10-30 SWITZERLAND 3901 3901 1986-10-30 Goodwin Procter, LLP Hoboken     NJ  
6634 1989-05-30 General Biscuit Brands, Inc. 1988-08-18 FRANCE 4170 4170 1988-08-18 Government Research Corporation Elizabeth     NJ  
6762 1991-05-31 Ajinomoto U.S.A., Inc. 1990-12-07 JAPAN 4434 4434 1990-11-13 Cosmo Public Relations Teaneck     NJ  
6768 1991-05-31 Daiichi Pharmaceutical Corporation 1990-12-07 JAPAN 4434 4434 1990-11-13 Cosmo Public Relations Fort Lee     NJ  
6770 1991-05-31 Eisai America, Inc. 1990-11-13 JAPAN 4434 4434 1990-11-13 Cosmo Public Relations Teaneck     NJ  
6774 1991-05-31 Fujirebio America, Inc. 1990-11-13 JAPAN 4434 4434 1990-11-13 Cosmo Public Relations Fairfield     NJ  
6783 1991-05-31 Maerk, Inc. 1990-07-18 DENMARK 3452 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Madison     NJ  
6794 1991-05-31 Tanabe U.S.A., Inc. 1990-11-16 JAPAN 4434 4434 1990-11-13 Cosmo Public Relations Woodcliff Lake     NJ  
7081 1995-06-01 University of Limerick Foundation 1992-02-04 IRELAND 4259 4259 1989-05-25 Cassidy & Associates, Inc. East Orange     NJ  
7226 1986-06-04 United Arab Shipping Company 1983-06-17 INTERNATIONAL 3279 3279 1981-10-06 Billig, Sher & Jones, P.C. Cranford     NJ  
7229 1988-06-04 Samsung Group 1988-02-11 KOREA, SOUTH 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP Fort Lee     NJ  
7267 1963-06-06 Government of Israel 1960-12-06 ISRAEL 1412 1412 1960-12-06 Cerceo, Alfred G. Asbury Park     NJ  
7401 1973-06-12 Renault, Inc. 1973-04-17 FRANCE 1814 1814 1964-11-06 Association Films, Inc. Englewood Cliffs     NJ  
7700 1995-06-24 Ajinomoto U.S.A., Inc. 1993-03-19 JAPAN 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Teaneck     NJ  
8057 1988-06-30 Samsung Group 1988-02-12 KOREA, SOUTH 3597 3597 1984-06-20 APCO Associates Fort Lee     NJ  
9579 1989-08-01 Fuji Photo Film U.S.A., Inc. 1987-04-09 JAPAN 3634 3634 1984-11-15 Daniel J. Edelman, Inc. Elmsford     NJ  
10080 1984-08-15 Frank N. Lawson/Vice President Business Development, U.S. 1984-03-01 CANADA 3562 3562 1984-03-01 Friedman, Pauline A. (Polly) Summit     NJ  
10093 1994-08-15 Trans-Atlantic Agreement 1993-09-30 INTERNATIONAL 4854 4854 1993-09-30 Schrier, Elliot Rutherford     NJ  
11155 1987-09-15 Konica U.S.A., Wholly-Owned Subsidiary of Konishiroku Photo 1987-04-24 JAPAN 3427 3427 1982-12-10 Jones Day Englewood Cliffs     NJ  
11508 1988-09-30 Ricoh Corporation 1987-02-27 INTERNATIONAL 3700 3700 1985-07-09 Gold & Liebengood, Inc. West Caldwell     NJ  
11518 1989-09-30 Samsung 1989-09-05 KOREA, SOUTH 4095 4095 1988-03-03 Murphy & Demory, Ltd. Fort Lee     NJ  
12377 1992-10-22 Mercedes-Benz of North America, Inc. 1989-06-09 GERMANY 4083 4083 1988-01-21 Cadwalader, Wickersham & Taft Montvale     NJ  
13146 1986-11-05 JDS International Consulting 1986-08-29 ANGOLA 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Pennsville     NJ  
13916 2005-11-30 Congolese International Union 1999-11-22 CONGO, REPUBLIC OF THE 5348 5348 1999-11-22 Ngoyi, Mwabilu L. P.O. Box 133 Newark, NJ 07101     NJ  
14769 1993-12-27 Ausimont U.S.A. 1993-02-03 ITALY 4390 4390 1990-06-25 SJS Advanced Strategies, Inc. Morristown     NJ  
14774 1994-12-27 Trans-Atlantic Agreement (TAA) 1993-09-30 INTERNATIONAL 4576 4576 1991-08-01 Sher & Blackwell Rutherford     NJ  
14901 1955-12-31 Cuban-American Sugar Company 1946-03-07 CUBA 347 347 1946-03-07 U.S.-Cuban Sugar Council Flemington     NJ  
14904 1955-12-31 Guantanamo Sugar Company 1946-03-07 CUBA 347 347 1946-03-07 U.S.-Cuban Sugar Council Flemington     NJ  

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 · Query took 168.702ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history