FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Termination_Date" is on date 1988-10-31 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Address_1, Registrant_Date (date)
Registrant_Name 10
- Ablondi, Foster, Sobin & Davidow, P.C. 1
- Anderson, Hibey & Blair 1
- Bishop, Cook, Purcell & Reynolds 1
- Black, Kelly, Scruggs & Healey 1
- Debevoise & Plimpton 1
- Harry W. Hochman Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Lipsen, Whitten & Diamond 1
- Powell, Goldstein, Frazer & Murphy, L.L.P. 1
- Tromson Monroe Advertising, Inc. 1
Foreign_Principal 10
- ADIG-Investment GmbH 1
- Aston Martin Lagonda, Ltd. 1
- Bahamas Cruise Lines 1
- Colebrand, Ltd. 1
- Dornier Medical Systems, Inc. 1
- Government of the Cayman Islands on Behalf of the Cayman Turtle Farm 1
- Taiwan Textile Federation 1
- Toshiba Corporation 1
- Westpac Banking Corporation 1
- World Zionist Organization, American Section 1
Country/Location_Represented 9
- GREAT BRITAIN 2
- AUSTRALIA 1
- BAHAMAS 1
- CAYMAN ISLANDS 1
- GERMANY, FEDERAL REPUBLIC OF 1
- ISRAEL 1
- JAPAN 1
- LIBERIA 1
- TAIWAN 1
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13246 | 13246 | 1988-10-31 | ADIG-Investment GmbH | 1989-05-31 | LIBERIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Reston | VA | |||
13247 | 13247 | 1988-10-31 | Aston Martin Lagonda, Ltd. | 1987-07-16 | GREAT BRITAIN | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | |||||
13248 | 13248 | 1988-10-31 | Bahamas Cruise Lines | 1986-05-21 | BAHAMAS | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | |||||
13249 | 13249 | 1988-10-31 | Colebrand, Ltd. | 1988-08-12 | GREAT BRITAIN | Lipsen, Whitten & Diamond 3586 | 1984-05-10 | Lipsen, Whitten & Diamond | London | ||||
13250 | 13250 | 1988-10-31 | Dornier Medical Systems, Inc. | 1988-03-17 | GERMANY, FEDERAL REPUBLIC OF | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Marietta | GA | |||
13251 | 13251 | 1988-10-31 | Government of the Cayman Islands on Behalf of the Cayman Turtle Farm | 1988-01-21 | CAYMAN ISLANDS | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | |||||
13252 | 13252 | 1988-10-31 | Taiwan Textile Federation | 1985-09-11 | TAIWAN | Ablondi, Foster, Sobin & Davidow, P.C. 3235 | 1981-05-04 | Ablondi, Foster, Sobin & Davidow, P.C. | Taipei | ||||
13253 | 13253 | 1988-10-31 | Toshiba Corporation | 1987-10-30 | JAPAN | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | Tokyo | ||||
13254 | 13254 | 1988-10-31 | Westpac Banking Corporation | 1987-11-05 | AUSTRALIA | Debevoise & Plimpton 3527 | 1983-10-05 | Debevoise & Plimpton | Sidney | ||||
13255 | 13255 | 1988-10-31 | World Zionist Organization, American Section | 1981-11-05 | ISRAEL | Harry W. Hochman Associates, Inc. 3300 | 1981-11-05 | Harry W. Hochman Associates, Inc. | New York | NY |
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]) );