FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Registrant_Date" is on date 1992-02-12
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Foreign_Principal_Registration_Date (date)
Foreign_Principal 9
- Argonaut, A.B. 1
- Atlantis Submarines International, Inc. 1
- British Columbia Ferry Corporation 1
- Canadian Pacific Hotels & Resorts 1
- Great Canadian Railtour Company, Ltd. 1
- Ministry of Tourism, British Columbia, Canada 1
- Naess Shipping (Holland), B.V. 1
- Tourism Victoria 1
- Unicom Management Services, Ltd. 1
Foreign_Principal_Termination_Date (date) 8 ✖
- 1993-09-24 2
- 1995-08-31 1
- 1995-12-20 1
- 1998-03-30 1
- 1999-06-30 1
- 1999-07-31 1
- 1999-08-28 1
- 2002-10-31 1
Address_1 5 ✖
Country/Location_Represented 4
- CANADA 6
- CYPRUS 1
- NETHERLANDS 1
- SWEDEN 1
Registrant_Name 2
State 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4228 | 4228 | 1998-03-30 | Unicom Management Services, Ltd. | 1998-03-30 | CYPRUS | Brown Nelson & Associates, Inc. 4615 | 1992-02-12 | Brown Nelson & Associates, Inc. | Oasis Centre, Corner Gladstone/Karaiskakis St., P.O. Box 6674, 3032 Limassol | ||||
8578 | 8578 | 1999-06-30 | Atlantis Submarines International, Inc. | 1992-02-12 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | British Columbia | ||||
9826 | 9826 | 1999-07-31 | Canadian Pacific Hotels & Resorts | 1995-03-22 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | Vancouver, B.C. | ||||
10811 | 10811 | 1999-08-28 | Argonaut, A.B. | 1994-03-31 | SWEDEN | Brown Nelson & Associates, Inc. 4615 | 1992-02-12 | Brown Nelson & Associates, Inc. | Stockholm | ||||
11038 | 11038 | 1995-08-31 | Ministry of Tourism, British Columbia, Canada | 1992-02-12 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | British Columbia | ||||
11803 | 11803 | 1993-09-24 | British Columbia Ferry Corporation | 1992-02-12 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | British Columbia | ||||
11806 | 11806 | 1993-09-24 | Tourism Victoria | 1992-02-12 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | British Columbia | ||||
13407 | 13407 | 2002-10-31 | Great Canadian Railtour Company, Ltd. | 1992-02-12 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | British Columbia | ||||
15270 | 15270 | 1995-12-20 | Naess Shipping (Holland), B.V. | 1992-02-12 | NETHERLANDS | Brown Nelson & Associates, Inc. 4615 | 1992-02-12 | Brown Nelson & Associates, Inc. | Amsterdam |
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]) );