FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Foreign_Principal_Termination_Date = "1987-09-30" sorted by State
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 9
- Canadian Forest Industries Council 1
- Council of Forest Industries of British Columbia 1
- Dart-M.L., Ltd. 1
- Free National Movement 1
- Japan Tobacco, Inc. 1
- Masstock (International), Ltd. 1
- Mediterranean-North Pacific Coast Freight Conference 1
- South Europe-U.S.A. Freight Conference 1
- Yacimientos Petroliferos Fiscales 1
Country/Location_Represented 7
- CANADA 2
- INTERNATIONAL 2
- ARGENTINA 1
- BAHAMAS 1
- GREAT BRITAIN 1
- IRELAND 1
- JAPAN 1
Registrant_Name 5
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11980 | 11980 | 1987-09-30 | Canadian Forest Industries Council | 1984-08-03 | CANADA | Fierst, Herbert A. 1590 | 1963-01-10 | Fierst, Herbert A. | |||||
11981 | 11981 | 1987-09-30 | Council of Forest Industries of British Columbia | 1963-01-10 | CANADA | Fierst, Herbert A. 1590 | 1963-01-10 | Fierst, Herbert A. | Vancouver | ||||
11982 | 11982 | 1987-09-30 | Dart-M.L., Ltd. | 1986-07-03 | GREAT BRITAIN | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | London | ||||
11983 | 11983 | 1987-09-30 | Free National Movement | 1986-09-21 | BAHAMAS | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | Nassau | ||||
11985 | 11985 | 1987-09-30 | Masstock (International), Ltd. | 1987-05-19 | IRELAND | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | Dublin | ||||
11986 | 11986 | 1987-09-30 | Mediterranean-North Pacific Coast Freight Conference | 1987-07-13 | INTERNATIONAL | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | Genoa | ||||
11987 | 11987 | 1987-09-30 | South Europe-U.S.A. Freight Conference | 1987-07-21 | INTERNATIONAL | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | Genoa | ||||
11988 | 11988 | 1987-09-30 | Yacimientos Petroliferos Fiscales | 1987-05-26 | ARGENTINA | Buiar Grefe International 3985 | 1987-05-26 | Buiar Grefe International | Buenos Aires | ||||
11984 | 11984 | 1987-09-30 | Japan Tobacco, Inc. | 1987-04-13 | JAPAN | Hoppel, Mayer & Coleman 3470 | 1983-05-20 | Hoppel, Mayer & Coleman | Washington | DC |
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]) );