FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where State = "NJ"
This data as json, CSV (advanced)
Foreign_Principal 13
- Ausimont U.S.A. 1
- Congolese International Union 1
- Cuban-American Sugar Company 1
- Frank N. Lawson/Vice President Business Development, U.S. 1
- Fuji Photo Film U.S.A., Inc. 1
- Guantanamo Sugar Company 1
- JDS International Consulting 1
- Konica U.S.A., Wholly-Owned Subsidiary of Konishiroku Photo 1
- Mercedes-Benz of North America, Inc. 1
- Ricoh Corporation 1
- Samsung 1
- Trans-Atlantic Agreement 1
- Trans-Atlantic Agreement (TAA) 1
Registrant_Name 12
- U.S.-Cuban Sugar Council 2
- Cadwalader, Wickersham & Taft 1
- Daniel J. Edelman, Inc. 1
- Friedman, Pauline A. (Polly) 1
- Gold & Liebengood, Inc. 1
- Jones Day 1
- Milbank, Tweed, Hadley & McCloy 1
- Murphy & Demory, Ltd. 1
- Ngoyi, Mwabilu L. 1
- SJS Advanced Strategies, Inc. 1
- Schrier, Elliot 1
- Sher & Blackwell 1
Country/Location_Represented 9
- INTERNATIONAL 3
- CUBA 2
- JAPAN 2
- ANGOLA 1
- CANADA 1
- CONGO, REPUBLIC OF THE 1
- GERMANY 1
- ITALY 1
- KOREA, SOUTH 1
State 1
- NJ · 13 ✖
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10007 | 10007 | 1989-08-01 | Fuji Photo Film U.S.A., Inc. | 1987-04-09 | JAPAN | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Elmsford | NJ | |||
10518 | 10518 | 1984-08-15 | Frank N. Lawson/Vice President Business Development, U.S. | 1984-03-01 | CANADA | Friedman, Pauline A. (Polly) 3562 | 1984-03-01 | Friedman, Pauline A. (Polly) | Summit | NJ | |||
10531 | 10531 | 1994-08-15 | Trans-Atlantic Agreement | 1993-09-30 | INTERNATIONAL | Schrier, Elliot 4854 | 1993-09-30 | Schrier, Elliot | Rutherford | NJ | |||
11631 | 11631 | 1987-09-15 | Konica U.S.A., Wholly-Owned Subsidiary of Konishiroku Photo | 1987-04-24 | JAPAN | Jones Day 3427 | 1982-12-10 | Jones Day | Englewood Cliffs | NJ | |||
12002 | 12002 | 1988-09-30 | Ricoh Corporation | 1987-02-27 | INTERNATIONAL | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | West Caldwell | NJ | |||
12012 | 12012 | 1989-09-30 | Samsung | 1989-09-05 | KOREA, SOUTH | Murphy & Demory, Ltd. 4095 | 1988-03-03 | Murphy & Demory, Ltd. | Fort Lee | NJ | |||
12937 | 12937 | 1992-10-22 | Mercedes-Benz of North America, Inc. | 1989-06-09 | GERMANY | Cadwalader, Wickersham & Taft 4083 | 1988-01-21 | Cadwalader, Wickersham & Taft | Montvale | NJ | |||
13730 | 13730 | 1986-11-05 | JDS International Consulting | 1986-08-29 | ANGOLA | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Pennsville | NJ | |||
14515 | 14515 | 2005-11-30 | Congolese International Union | 1999-11-22 | CONGO, REPUBLIC OF THE | Ngoyi, Mwabilu L. 5348 | 1999-11-22 | Ngoyi, Mwabilu L. | P.O. Box 133 Newark, NJ 07101 | NJ | |||
15408 | 15408 | 1993-12-27 | Ausimont U.S.A. | 1993-02-03 | ITALY | SJS Advanced Strategies, Inc. 4390 | 1990-06-25 | SJS Advanced Strategies, Inc. | Morristown | NJ | |||
15413 | 15413 | 1994-12-27 | Trans-Atlantic Agreement (TAA) | 1993-09-30 | INTERNATIONAL | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | Rutherford | NJ | |||
15546 | 15546 | 1955-12-31 | Cuban-American Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Flemington | NJ | |||
15549 | 15549 | 1955-12-31 | Guantanamo Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Flemington | NJ |
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]) );