FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Termination_Date" is on date 1995-09-30 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 12
- Williams & Connolly 2
- Fratelli Group 1
- Gold & Liebengood, Inc. 1
- Hoegh, Westye 1
- Mann, Richard J. 1
- Martens, Hans Ditlef, Jr. 1
- SJA International, Inc. 1
- Sack & Associates, Inc. 1
- Sandler & Travis Trade Advisory Services, Inc. 1
- TKC International, Inc. 1
- Washington World Group, Ltd. 1
- Wilhelmsen, Bjorn 1
Foreign_Principal 11
- Norwegian Shipowners' Association 3
- Caribbean Banana Exporters' Association 1
- Direction Generale de l'Aviation Civile Ministere de l'Equipement, des Transports et du Tourisme 1
- Generalitat of Catalonia 1
- Government of Bolivia 1
- Government of Israel, Ministry of Defense, Mission to the U.S. 1
- Gregory Mevs 1
- James Capel & Company 1
- Karwell Group 1
- Republic of Benin 1
- Thomas De La Rue, PLC 1
Country/Location_Represented 10
- NORWAY 3
- GREAT BRITAIN 2
- BENIN 1
- BOLIVIA 1
- FRANCE 1
- HAITI 1
- INDONESIA 1
- INTERNATIONAL 1
- ISRAEL 1
- SPAIN 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12058 | 12058 | 1995-09-30 | Caribbean Banana Exporters' Association | 1995-03-13 | INTERNATIONAL | Fratelli Group 5004 | 1995-03-13 | Fratelli Group | Middlesex | ||||
12059 | 12059 | 1995-09-30 | Direction Generale de l'Aviation Civile Ministere de l'Equipement, des Transports et du Tourisme | 1994-09-30 | FRANCE | SJA International, Inc. 4955 | 1994-09-30 | SJA International, Inc. | Paris | ||||
12063 | 12063 | 1995-09-30 | Generalitat of Catalonia | 1995-06-15 | SPAIN | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | |||||
12064 | 12064 | 1995-09-30 | Government of Bolivia | 1990-06-05 | BOLIVIA | Williams & Connolly 4225 | 1989-03-14 | Williams & Connolly | Washinton | DC | |||
12065 | 12065 | 1995-09-30 | Government of Israel, Ministry of Defense, Mission to the U.S. | 1992-09-03 | ISRAEL | Mann, Richard J. 4746 | 1992-09-03 | Mann, Richard J. | New York | NY | |||
12066 | 12066 | 1995-09-30 | Gregory Mevs | 1992-05-07 | HAITI | Williams & Connolly 4225 | 1989-03-14 | Williams & Connolly | Miami | FL | |||
12067 | 12067 | 1995-09-30 | James Capel & Company | 1993-10-18 | GREAT BRITAIN | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | London | ||||
12068 | 12068 | 1995-09-30 | Karwell Group | 1992-07-31 | INDONESIA | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | Jakarta | ||||
12060 | 12060 | 1995-09-30 | Norwegian Shipowners' Association | 1993-09-20 | NORWAY | Martens, Hans Ditlef, Jr. 4850 | 1993-09-20 | Martens, Hans Ditlef, Jr. | Oslo | ||||
12061 | 12061 | 1995-09-30 | Norwegian Shipowners' Association | 1994-09-21 | NORWAY | Hoegh, Westye 4948 | 1994-09-21 | Hoegh, Westye | Oslo | ||||
12062 | 12062 | 1995-09-30 | Norwegian Shipowners' Association | 1991-11-06 | NORWAY | Wilhelmsen, Bjorn 4588 | 1991-11-06 | Wilhelmsen, Bjorn | |||||
12069 | 12069 | 1995-09-30 | Republic of Benin | 1995-07-10 | BENIN | Washington World Group, Ltd. 5016 | 1995-04-20 | Washington World Group, Ltd. | Cotonou | ||||
12070 | 12070 | 1995-09-30 | Thomas De La Rue, PLC | 1995-09-15 | GREAT BRITAIN | Sack & Associates, Inc. 5046 | 1995-09-15 | Sack & Associates, Inc. | London |
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]) );