FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Country/Location_Represented = "ISLE OF MAN" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Date (date) 6 ✖
- 1977-03-09 1
- 1984-06-14 1
- 1985-04-05 1
- 1997-04-25 1
- 2000-06-27 1
- 2003-10-02 1
Registrant_Name 5
Foreign_Principal 5
Address_1 5 ✖
State 1
- - 6
Country/Location_Represented 1
- ISLE OF MAN · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12409 | 12409 | 2010-10-01 | Isle of Man | 2005-11-01 | ISLE OF MAN | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | IOM Government Office | Douglan, IM1 9 PG | British | ||
7804 | 7804 | 1994-06-14 | Vittoria Consultants, Ltd. | 1993-10-07 | ISLE OF MAN | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Douglas | ||||
8394 | 8394 | 1985-06-30 | Government of the Isle of Man | 1985-04-05 | ISLE OF MAN | Cadwalader, Wickersham & Taft 3665 | 1985-04-05 | Cadwalader, Wickersham & Taft | |||||
11675 | 11675 | 1997-09-16 | Commercial Development Division, Treasury Isle of Man Government | 1997-04-25 | ISLE OF MAN | Byck, Donald M. 5178 | 1997-04-25 | Byck, Donald M. | |||||
14280 | 14280 | 2000-11-27 | International Services Division The Treasury Isle of Man Government | 2000-06-27 | ISLE OF MAN | Byck, Donald M. 5376 | 2000-06-27 | Byck, Donald M. | 1-4 Goldie Terrace 2nd Floor Douglas British Isle of Man, British Isles, IM1 1PG | ||||
16603 | 16603 | 2006-12-31 | Isle of Man | 2006-08-01 | ISLE OF MAN | Weber Shandwick, Inc. 5579 | 2003-10-02 | Weber Shandwick, Inc. | Government Office | Bucks Road | Douglas |
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]) );