FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Foreign_Principal_Termination_Date" is on date 1996-06-30 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
- Canadian Forest Industries Council 1
- Chinachem Group 1
- Fujisawa Pharmaceutical Company, Ltd. 1
- Geneva Departement de l'Economie Publique 1
- Government of Nigeria 1
- Hong Kong Economic & Trade Office 1
- Kuwait National Assembly 1
- Labour Party, Republic of Ireland 1
- Mathew Dontzin (for Sheikh Khalid bin Mahfouz) (formerly: Lawrence G. Smith for K. bin-Mahfouz) 1
- Nippon Paper Industries Company, Ltd. 1
- P.T. Texmaco Jaya 1
- Winag Corporation 1
Registrant_Name 11
- Hill and Knowlton Strategies, LLC 2
- Abernathy/MacGregor Group, Inc. 1
- Baker & McKenzie 1
- Development Counsellors International 1
- Friends of Irish Labour in America (FILA) 1
- Jones Day 1
- Levenson, Levenson & Hill, Inc. 1
- O'Melveny & Myers, L.L.P. 1
- Ruder Finn, Inc. 1
- Sandler & Travis Trade Advisory Services, Inc. 1
- Symms, Lehn & Associates, Inc. 1
Country/Location_Represented 10
- HONG KONG 2
- JAPAN 2
- CANADA 1
- GERMANY 1
- INDONESIA 1
- IRELAND 1
- KUWAIT 1
- NIGERIA 1
- SAUDI ARABIA 1
- SWITZERLAND 1
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8541 | 8541 | 1996-06-30 | Canadian Forest Industries Council | 1994-04-18 | CANADA | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Vancouver, B.C. | ||||
8542 | 8542 | 1996-06-30 | Chinachem Group | 1995-11-28 | HONG KONG | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Kowloon | ||||
8543 | 8543 | 1996-06-30 | Fujisawa Pharmaceutical Company, Ltd. | 1991-04-18 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Osaka | ||||
8540 | 8540 | 1996-06-30 | Geneva Departement de l'Economie Publique | 1993-05-11 | SWITZERLAND | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Geneve | ||||
8544 | 8544 | 1996-06-30 | Government of Nigeria | 1995-08-22 | NIGERIA | Symms, Lehn & Associates, Inc. 4880 | 1993-12-21 | Symms, Lehn & Associates, Inc. | New York | NY | |||
8545 | 8545 | 1996-06-30 | Hong Kong Economic & Trade Office | 1996-05-28 | HONG KONG | Levenson, Levenson & Hill, Inc. 5109 | 1996-05-28 | Levenson, Levenson & Hill, Inc. | San Francisco | CA | |||
8546 | 8546 | 1996-06-30 | Kuwait National Assembly | 1995-08-18 | KUWAIT | Jones Day 3427 | 1982-12-10 | Jones Day | Safat | ||||
8547 | 8547 | 1996-06-30 | Labour Party, Republic of Ireland | 1996-06-06 | IRELAND | Friends of Irish Labour in America (FILA) 5110 | 1996-06-06 | Friends of Irish Labour in America (FILA) | Dublin | ||||
8548 | 8548 | 1996-06-30 | Mathew Dontzin (for Sheikh Khalid bin Mahfouz) (formerly: Lawrence G. Smith for K. bin-Mahfouz) | 1992-12-11 | SAUDI ARABIA | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | New York | NY | |||
8549 | 8549 | 1996-06-30 | Nippon Paper Industries Company, Ltd. | 1995-12-06 | JAPAN | O'Melveny & Myers, L.L.P. 5084 | 1995-12-06 | O'Melveny & Myers, L.L.P. | Tokyo | ||||
8550 | 8550 | 1996-06-30 | P.T. Texmaco Jaya | 1992-07-31 | INDONESIA | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | Jakarta | ||||
8551 | 8551 | 1996-06-30 | Winag Corporation | 1996-10-25 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Passau |
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]) );