FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where "Foreign_Principal_Registration_Date" is on date 1990-04-02 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 5
Registrant_Name 4
Country/Location_Represented 4
- GREAT BRITAIN 2
- CANADA 1
- INTERNATIONAL 1
- TAIWAN 1
City 1
- - 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5139 | 5139 | 1991-04-10 | Council of European & Japanese National Shipowners' Association (CENSA) | 1990-04-02 | INTERNATIONAL | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | London | ||||
13872 | 13872 | 1992-11-10 | Republic of China | 1990-04-02 | TAIWAN | Evans Group, Ltd. 4222 | 1989-03-02 | Evans Group, Ltd. | Taipei | ||||
14875 | 14875 | 1992-12-07 | Grand Metropolitan, PLC | 1990-04-02 | GREAT BRITAIN | McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 | 1990-04-02 | McGrann Shea Franzen Carnival Straughn & Lamb, Chartered | London | ||||
14878 | 14878 | 1992-12-07 | Pillsbury Company | 1990-04-02 | GREAT BRITAIN | McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 | 1990-04-02 | McGrann Shea Franzen Carnival Straughn & Lamb, Chartered | Minneapolis | MN | |||
16407 | 16407 | 1996-12-31 | Saskatchewan Department of Trade & Investment Government of Saskatchewan, Canada | 1990-04-02 | CANADA | Saskatchewan Economic Diversification & Trade Office 4361 | 1990-04-02 | Saskatchewan Economic Diversification & Trade Office | Regina, Saskatchewan |
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]) );