FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Registrant_Name = "LeBoeuf, Lamb, Greene & MacRae, L.L.P."
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 15
- Axa Reassurance 1
- Bank of Bermuda 1
- Bogolijub Karic & the Karic Group of Companies 1
- British Insurance Association 1
- Council of European & Japanese National Shipowners' Association (CENSA) 1
- DHS-Dillinger Hutte Saarstahl, A.G. & A.G. der Dillinger Huttenwerke 1
- Foreign Ministry, Kingdom of Saudi Arabia 1
- Government of Bermuda 1
- London Insurance & Reinsurance Market Association 1
- Neratoom, B.V. 1
- Norwegian Shipowners' Association 1
- Shipping Corporation of India 1
- Swedish Shipowners' Association 1
- Transbrasil, S.A., Linhas Aereas 1
- Underwriters at Lloyd's, London 1
Country/Location_Represented 11
- GREAT BRITAIN 3
- BERMUDA 2
- FRANCE 2
- BRAZIL 1
- DENMARK 1
- INDIA 1
- INTERNATIONAL 1
- NORWAY 1
- SAUDI ARABIA 1
- SERBIA 1
- SWEDEN 1
State 1
- - 15
Registrant_Name 1
- LeBoeuf, Lamb, Greene & MacRae, L.L.P. · 15 ✖
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4904 | 4904 | 1987-04-01 | British Insurance Association | 1984-10-16 | GREAT BRITAIN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | London | ||||
4906 | 4906 | 1987-04-01 | Foreign Ministry, Kingdom of Saudi Arabia | 1978-03-17 | SAUDI ARABIA | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Jeddah | ||||
4912 | 4912 | 1987-04-01 | Shipping Corporation of India | 1982-01-22 | INDIA | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Bombay | ||||
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 | ||||
6609 | 6609 | 1997-05-16 | Bogolijub Karic & the Karic Group of Companies | 1996-12-06 | SERBIA | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 5144 | 1996-12-06 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Serbia | ||||
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 | ||||
13138 | 13138 | 1993-10-29 | Transbrasil, S.A., Linhas Aereas | 1990-10-19 | BRAZIL | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Rio de Janeiro | ||||
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 | ||||
13605 | 13605 | 1994-11-01 | Axa Reassurance | 1993-10-29 | FRANCE | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Paris | ||||
13607 | 13607 | 1994-11-01 | DHS-Dillinger Hutte Saarstahl, A.G. & A.G. der Dillinger Huttenwerke | 1994-07-22 | FRANCE | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Dillingen-Saar | ||||
15037 | 15037 | 1979-12-12 | Neratoom, B.V. | 1978-10-06 | DENMARK | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | The Hague | ||||
16278 | 16278 | 1995-12-31 | Norwegian Shipowners' Association | 1991-11-01 | NORWAY | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Oslo | ||||
16281 | 16281 | 1995-12-31 | Swedish Shipowners' Association | 1994-12-05 | SWEDEN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Gothenburg | ||||
16284 | 16284 | 1995-12-31 | Underwriters at Lloyd's, London | 1987-11-10 | GREAT BRITAIN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | London | ||||
16350 | 16350 | 1995-12-31 | London Insurance & Reinsurance Market Association | 1991-06-06 | GREAT BRITAIN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | London |
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]) );