FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where Address_1 = "Hamilton" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 32
- Davis & Harman 2
- Hill and Knowlton Strategies, LLC 2
- Kelly, Nason, Inc. 2
- LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2
- Levine & Company 2
- Mayer, Brown & Platt 2
- Ragan & Mason 2
- AEGIS Insurance Services, Inc. (AISI) 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Baker & Hostetler 1
- Bergner Bockorny, Inc. 1
- Bernstein Law Firm, PLLC 1
- Black, Kelly, Scruggs & Healey 1
- Crowell & Moring 1
- DDB Worldwide Communications Group, Inc. 1
- Debevoise & Plimpton 1
- FCB New York 1
- Foster Garvey PC 1
- Gallagher & Blitz, Chartered 1
- IPG DXTRA, Inc 1
- Miller, Marye Taylor 1
- Modern Education Services, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- O'Connor & Hannan, L.L.P. 1
- Ropes and Gray 1
- Skadden, Arps, Slate, Meagher & Flom 1
- Sutherland, Asbill & Brennan 1
- Swidler Berlin Shereff Friedman, LLP 1
- Vinson & Elkins 1
- Vinson & Elkins, L.L.P. 1
- Whitmore, Judith M. 1
- Wilmer, Cutler & Pickering 1
Registrant_Date (date) 32 ✖
- 1942-07-30 2
- 1964-01-03 2
- 1978-03-17 2
- 1979-12-13 2
- 1981-11-10 2
- 1987-04-29 2
- 1987-07-28 2
- 1957-09-16 1
- 1964-06-03 1
- 1964-10-19 1
- 1973-03-28 1
- 1978-10-25 1
- 1979-08-09 1
- 1981-11-20 1
- 1982-04-08 1
- 1983-06-24 1
- 1983-10-05 1
- 1984-06-14 1
- 1985-10-15 1
- 1985-11-22 1
- 1986-03-20 1
- 1986-12-01 1
- 1987-01-29 1
- 1988-01-07 1
- 1989-05-01 1
- 1990-02-05 1
- 1990-04-30 1
- 1993-02-08 1
- 1993-02-23 1
- 1994-06-20 1
- 1994-10-03 1
- 1999-09-15 1
Foreign_Principal 27
- Government of Bermuda 7
- Hoylake Investments, Ltd. 4
- Attorneys' Liability Assurance Society, Ltd. 2
- Bermuda Government 2
- XL Insurance Company, Ltd. 2
- A.C.E. Insurance Company (Bermuda) Ltd. 1
- ACE Insurance Company, Ltd. (Formerly) ACE Insurance Company, Ltd. (Bermuda) 1
- ACE, Ltd. 1
- Accountants' Liability Assurance Company, Ltd. 1
- Ad Hoc Bermuda Insurance Group 1
- Associated Electric & Gas Insurance Services, Ltd. 1
- Associated Electric & Gas Insurance Services, Ltd. (AEGIS) 1
- Bank of Bermuda 1
- Bermuda Department of Tourism 1
- Bermuda Department of Tourism & Trade Development 1
- Bermuda Hotels, Inc. 1
- Bermuda Trade Development Board 1
- Centre Reinsurance (Bermuda), Ltd. 1
- Cristal, Ltd. 1
- Government of Bermuda, Department of Tourism 1
- Government of Bermuda, Ministry of Finance 1
- OOC, Ltd. 1
- Oman Oil Company, Ltd. 1
- Princess Hotel of Bermuda, Ltd. 1
- Shoreline Mutual (Bermuda), Ltd. 1
- Steel Company of Canada, Ltd. 1
- United Kingdom Mutual Steam Ship Association (Bermuda), Ltd. 1
Country/Location_Represented 5
- BERMUDA 34
- OMAN 2
- CANADA 1
- CAYMAN ISLANDS 1
- INTERNATIONAL 1
State 1
- - 39
City 1
- - 39
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16786 | 16786 | 2016-12-31 | Government of Bermuda | 1989-07-25 | BERMUDA | Levine & Company 3971 | 1987-04-29 | Levine & Company | Hamilton | ||||
16566 | 16566 | 2004-12-31 | XL Insurance Company, Ltd. | 1993-02-08 | BERMUDA | Bernstein Law Firm, PLLC 4764 | 1993-02-08 | Bernstein Law Firm, PLLC | Hamilton | ||||
16374 | 16374 | 1995-12-31 | XL Insurance Company, Ltd. | 1994-06-20 | BERMUDA | Vinson & Elkins, L.L.P. 4921 | 1994-06-20 | Vinson & Elkins, L.L.P. | Hamilton | ||||
16118 | 16118 | 1989-12-31 | Government of Bermuda, Department of Tourism | 1973-03-28 | BERMUDA | FCB New York 2415 | 1973-03-28 | FCB New York | Hamilton | ||||
16034 | 16034 | 1988-12-31 | Ad Hoc Bermuda Insurance Group | 1988-04-04 | BERMUDA | Levine & Company 3971 | 1987-04-29 | Levine & Company | Hamilton | ||||
14369 | 14369 | 1986-11-30 | Government of Bermuda | 1986-08-20 | BERMUDA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Hamilton | ||||
13260 | 13260 | 1989-10-31 | Government of Bermuda | 1986-03-26 | BERMUDA | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Hamilton | ||||
13127 | 13127 | 1993-10-29 | Bank of Bermuda | 1986-03-26 | BERMUDA | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Hamilton | ||||
12852 | 12852 | 1982-10-19 | Steel Company of Canada, Ltd. | 1978-05-28 | CANADA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | Hamilton | ||||
12468 | 12468 | 1989-10-04 | Hoylake Investments, Ltd. | 1989-09-08 | INTERNATIONAL | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Hamilton | ||||
10989 | 10989 | 1989-08-31 | Hoylake Investments, Ltd. | 1989-09-12 | BERMUDA | Debevoise & Plimpton 3527 | 1983-10-05 | Debevoise & Plimpton | Hamilton | ||||
9807 | 9807 | 1995-07-31 | A.C.E. Insurance Company (Bermuda) Ltd. | 1993-06-09 | CAYMAN ISLANDS | Davis & Harman 4018 | 1987-07-28 | Davis & Harman | Hamilton | ||||
9692 | 9692 | 1964-07-31 | Princess Hotel of Bermuda, Ltd. | 1955-03-31 | BERMUDA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Hamilton | ||||
9658 | 9658 | 1964-07-31 | Bermuda Hotels, Inc. | 1942-07-30 | BERMUDA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Hamilton | ||||
9593 | 9593 | 1997-07-29 | Associated Electric & Gas Insurance Services, Ltd. | 1987-01-29 | BERMUDA | AEGIS Insurance Services, Inc. (AISI) 3932 | 1987-01-29 | AEGIS Insurance Services, Inc. (AISI) | Hamilton | ||||
8440 | 8440 | 1989-06-30 | Government of Bermuda | 1986-04-22 | BERMUDA | Sutherland, Asbill & Brennan 3307 | 1981-11-20 | Sutherland, Asbill & Brennan | Hamilton | ||||
8064 | 8064 | 1990-06-24 | Hoylake Investments, Ltd. | 1989-08-17 | BERMUDA | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | Hamilton | ||||
7732 | 7732 | 1993-06-10 | OOC, Ltd. | 1992-06-19 | OMAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Hamilton | ||||
7678 | 7678 | 1994-06-08 | ACE Insurance Company, Ltd. (Formerly) ACE Insurance Company, Ltd. (Bermuda) | 1993-02-23 | BERMUDA | Gallagher & Blitz, Chartered 4768 | 1993-02-23 | Gallagher & Blitz, Chartered | Hamilton | ||||
7076 | 7076 | 1990-05-31 | Associated Electric & Gas Insurance Services, Ltd. (AEGIS) | 1987-07-28 | BERMUDA | Davis & Harman 4018 | 1987-07-28 | Davis & Harman | Hamilton | ||||
6689 | 6689 | 1990-05-21 | Government of Bermuda | 1988-11-03 | BERMUDA | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Hamilton | ||||
6688 | 6688 | 1987-05-21 | Attorneys' Liability Assurance Society, Ltd. | 1986-09-18 | BERMUDA | Vinson & Elkins 3758 | 1985-11-22 | Vinson & Elkins | Hamilton | ||||
6555 | 6555 | 1983-05-15 | United Kingdom Mutual Steam Ship Association (Bermuda), Ltd. | 1981-07-07 | BERMUDA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Hamilton | ||||
6435 | 6435 | 1989-05-10 | Cristal, Ltd. | 1989-05-01 | BERMUDA | Miller, Marye Taylor 4246 | 1989-05-01 | Miller, Marye Taylor | Hamilton | ||||
6302 | 6302 | 1995-05-03 | ACE, Ltd. | 1994-10-03 | BERMUDA | Crowell & Moring 4958 | 1994-10-03 | Crowell & Moring | Hamilton | ||||
6267 | 6267 | 1990-05-02 | Hoylake Investments, Ltd. | 1989-09-07 | BERMUDA | Skadden, Arps, Slate, Meagher & Flom 3746 | 1985-10-15 | Skadden, Arps, Slate, Meagher & Flom | Hamilton | ||||
5950 | 5950 | 1996-04-30 | Centre Reinsurance (Bermuda), Ltd. | 1994-08-04 | BERMUDA | Baker & Hostetler 4371 | 1990-04-30 | Baker & Hostetler | Hamilton | ||||
5276 | 5276 | 1973-04-15 | Bermuda Department of Tourism & Trade Development | 1969-06-10 | BERMUDA | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | Hamilton | ||||
4640 | 4640 | 2005-03-31 | Government of Bermuda | 1994-10-06 | BERMUDA | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Hamilton | ||||
4574 | 4574 | 1999-03-31 | Bermuda Department of Tourism | 1990-04-17 | BERMUDA | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | Hamilton | ||||
4542 | 4542 | 1995-03-31 | Oman Oil Company, Ltd. | 1995-02-03 | OMAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Hamilton | ||||
4525 | 4525 | 1993-03-31 | Bermuda Government | 1990-02-05 | BERMUDA | Whitmore, Judith M. 4336 | 1990-02-05 | Whitmore, Judith M. | Hamilton | ||||
4459 | 4459 | 1989-03-31 | Bermuda Government | 1978-10-05 | BERMUDA | Ragan & Mason 1678 | 1964-01-03 | Ragan & Mason | Hamilton | ||||
4156 | 4156 | 1972-03-30 | Bermuda Trade Development Board | 1964-01-03 | BERMUDA | Ragan & Mason 1678 | 1964-01-03 | Ragan & Mason | Hamilton | ||||
2789 | 2789 | 2002-02-25 | Government of Bermuda, Ministry of Finance | 1999-09-15 | BERMUDA | Ropes and Gray 5328 | 1999-09-15 | Ropes and Gray | Hamilton | ||||
1775 | 1775 | 1994-01-31 | Attorneys' Liability Assurance Society, Ltd. | 1986-09-16 | BERMUDA | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Hamilton | ||||
1774 | 1774 | 1994-01-31 | Accountants' Liability Assurance Company, Ltd. | 1988-02-22 | BERMUDA | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Hamilton | ||||
1389 | 1389 | 1996-01-17 | Shoreline Mutual (Bermuda), Ltd. | 1994-05-04 | BERMUDA | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Hamilton | ||||
1285 | 1285 | 1987-01-14 | Government of Bermuda | 1987-01-21 | BERMUDA | Bergner Bockorny, Inc. 3801 | 1986-03-20 | Bergner Bockorny, Inc. | Hamilton |
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]) );