FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
91 rows where "Registrant_Date" is on date 1982-12-10
This data as json, CSV (advanced)
Foreign_Principal >30
- Paribas Corporation 3
- Manufacturers Life Insurance Company of Canada 2
- Avon County Council 1
- Banca Nazionale del Lavoro 1
- Banco Latinoamericano de Exportaciones 1
- Bank of Algeria, Acting on behalf of the Government of the Republic of Algeria 1
- Bedfordshire County Council 1
- Borough of Haringey 1
- Borough of South Tyneside 1
- Buckinghamshire County Council 1
- Cambridgeshire County Council 1
- Canadian Pulp & Paper Association 1
- Canadian Steel Industry Council 1
- Cementos Anahuac del Golfo, S.A. 1
- City of Bradford Metropolitian Council 1
- Cornwall County Council 1
- County of Cleveland 1
- Cumbria County Council 1
- Devon County Council 1
- Dofasco, Inc. 1
- Durham County Council 1
- East Sussex County Council 1
- Embassy of Lebanon 1
- Embassy of the Democratic Republic of Algeria 1
- Essex County Council 1
- Gloucestershire County Council 1
- Government of Costa Rica 1
- Greater Manchester Residuary Body 1
- Gwent County Council 1
- Hachette U.S.A., Inc. 1
- …
Country/Location_Represented 17
- GREAT BRITAIN 47
- CANADA 8
- FRANCE 5
- ALGERIA 3
- COSTA RICA 2
- JAPAN 2
- KUWAIT 2
- MEXICO 2
- BRAZIL 1
- CAYMAN ISLANDS 1
- GERMANY, FEDERAL REPUBLIC OF 1
- ITALY 1
- LEBANON 1
- NETHERLANDS 1
- PANAMA 1
- SOUTH AFRICA 1
- SWITZERLAND 1
Registrant_Name 2
- Jones Day 59
- Rogers & Wells, LLP 21
City 1
- - 80
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6674 | 6674 | 1998-05-20 | Canadian Pulp & Paper Association | 1992-07-17 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Quebec | ||||
7722 | 7722 | 1985-06-10 | Magic Pantry Foods, Inc. | 1984-04-20 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Hamilton Ontario | ||||
7723 | 7723 | 1986-06-10 | Paribas North America | 1985-08-05 | MEXICO | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Edo de Mexico | ||||
7724 | 7724 | 1986-06-10 | Swissair | 1986-02-26 | SWITZERLAND | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Zurich | ||||
7739 | 7739 | 1998-06-10 | Dofasco, Inc. | 1992-03-18 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Ontario | ||||
8009 | 8009 | 1994-06-22 | Canadian Steel Industry Council | 1993-02-17 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Ontario | ||||
8010 | 8010 | 1994-06-22 | Paribas Corporation | 1992-07-07 | FRANCE | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | New York | NY | |||
8505 | 8505 | 1992-06-30 | Royal Trustco, Ltd. | 1989-04-17 | CANADA | Jones Day 3427 | 1982-12-10 | Jones Day | Ontario | ||||
8506 | 8506 | 1992-06-30 | Thomson-CSF, S.A. | 1992-04-06 | FRANCE | Jones Day 3427 | 1982-12-10 | Jones Day | Paris | ||||
8546 | 8546 | 1996-06-30 | Kuwait National Assembly | 1995-08-18 | KUWAIT | Jones Day 3427 | 1982-12-10 | Jones Day | Safat | ||||
9158 | 9158 | 1988-07-10 | Cementos Anahuac del Golfo, S.A. | 1984-04-20 | MEXICO | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Edo de Mexico | ||||
9159 | 9159 | 1988-07-10 | Indal, Ltd. | 1987-05-21 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Weston, Ontario | ||||
9160 | 9160 | 1988-07-10 | Manufacturers Life Insurance Company of Canada | 1987-03-23 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Toronto | ||||
9540 | 9540 | 1990-07-27 | Heron International, N.V. | 1987-09-15 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
9592 | 9592 | 1994-07-29 | Morgan Grenfell & Company, Ltd. | 1986-10-20 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
10140 | 10140 | 1985-08-05 | Paribas Corporation | 1984-04-20 | FRANCE | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | New York | NY | |||
10320 | 10320 | 1984-08-13 | International PetChemco, Inc. | 1984-06-13 | BRAZIL | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | New York | NY | |||
11631 | 11631 | 1987-09-15 | Konica U.S.A., Wholly-Owned Subsidiary of Konishiroku Photo | 1987-04-24 | JAPAN | Jones Day 3427 | 1982-12-10 | Jones Day | Englewood Cliffs | NJ | |||
11716 | 11716 | 1991-09-19 | Banca Nazionale del Lavoro | 1990-09-25 | ITALY | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Rome | ||||
11717 | 11717 | 1991-09-19 | Liga Agricola Industrial de la Cana de Azucar | 1986-02-26 | COSTA RICA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | San Jose | ||||
11718 | 11718 | 1991-09-19 | Manufacturers Life Insurance Company of Canada | 1989-04-07 | CANADA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Ontario | ||||
11719 | 11719 | 1991-09-19 | Marks & Spencer, PLC | 1990-03-20 | GREAT BRITAIN | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | London | ||||
11720 | 11720 | 1991-09-19 | Paribas Corporation | 1987-03-31 | FRANCE | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | New York | NY | |||
13277 | 13277 | 1991-10-31 | Avon County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Bristol | ||||
13278 | 13278 | 1991-10-31 | Bedfordshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13279 | 13279 | 1991-10-31 | Borough of Haringey | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
13280 | 13280 | 1991-10-31 | Borough of South Tyneside | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Tyne and Wear | ||||
13281 | 13281 | 1991-10-31 | Buckinghamshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Bucks | ||||
13282 | 13282 | 1991-10-31 | Cambridgeshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13283 | 13283 | 1991-10-31 | City of Bradford Metropolitian Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Wakefield | ||||
13284 | 13284 | 1991-10-31 | Cornwall County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Truro | ||||
13285 | 13285 | 1991-10-31 | County of Cleveland | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13286 | 13286 | 1991-10-31 | Cumbria County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13288 | 13288 | 1991-10-31 | Devon County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Exeter | ||||
13289 | 13289 | 1991-10-31 | Durham County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13290 | 13290 | 1991-10-31 | East Sussex County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13291 | 13291 | 1991-10-31 | Essex County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Chelmsford | ||||
13292 | 13292 | 1991-10-31 | Gloucestershire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13294 | 13294 | 1991-10-31 | Greater Manchester Residuary Body | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Manchester | ||||
13295 | 13295 | 1991-10-31 | Gwent County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13296 | 13296 | 1991-10-31 | Hampshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Winchester | ||||
13297 | 13297 | 1991-10-31 | Hertfordshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13298 | 13298 | 1991-10-31 | Kent County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13299 | 13299 | 1991-10-31 | Lancashire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Preston | ||||
13300 | 13300 | 1991-10-31 | Leicestershire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13301 | 13301 | 1991-10-31 | London Borough of Barking & Dagenham | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Essex | ||||
13302 | 13302 | 1991-10-31 | London Borough of Hounslow | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13303 | 13303 | 1991-10-31 | London Borough of Islington | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13304 | 13304 | 1991-10-31 | London Borough of Redbridge | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Essex | ||||
13305 | 13305 | 1991-10-31 | London Borough of Richmond Upon Thames | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Twickenham | ||||
13306 | 13306 | 1991-10-31 | London Borough of Waltham Forest | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
13307 | 13307 | 1991-10-31 | London Residuary Body | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13308 | 13308 | 1991-10-31 | Mid Glamorgan County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Cardiff | ||||
13311 | 13311 | 1991-10-31 | Norfolk County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Norwich | ||||
13312 | 13312 | 1991-10-31 | North Yorkshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13313 | 13313 | 1991-10-31 | Northamptonshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13314 | 13314 | 1991-10-31 | Oxfordshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Oxford | ||||
13317 | 13317 | 1991-10-31 | Royal County of Berkshire | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Reading | ||||
13319 | 13319 | 1991-10-31 | Somerset County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Taunton | ||||
13320 | 13320 | 1991-10-31 | South Glamorgan County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Cardiff | ||||
13321 | 13321 | 1991-10-31 | South Yorkshire Residuary Body | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13323 | 13323 | 1991-10-31 | West Glamorgan County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Swansea | ||||
13324 | 13324 | 1991-10-31 | West Sussex County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13325 | 13325 | 1991-10-31 | Westminster City Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
13326 | 13326 | 1991-10-31 | Wiltshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Trowbridge | ||||
13327 | 13327 | 1991-10-31 | Wolverhampton Borough Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | West Midlands | ||||
13606 | 13606 | 1994-11-01 | Bank of Algeria, Acting on behalf of the Government of the Republic of Algeria | 1993-05-03 | ALGERIA | Jones Day 3427 | 1982-12-10 | Jones Day | Algiers | ||||
13608 | 13608 | 1994-11-01 | Embassy of the Democratic Republic of Algeria | 1993-05-28 | ALGERIA | Jones Day 3427 | 1982-12-10 | Jones Day | Washington | DC | |||
14686 | 14686 | 1986-12-01 | SONATRACH - Societe Nationale de Transport et de Commercialisation des Hydrocarbures | 1982-12-10 | ALGERIA | Jones Day 3427 | 1982-12-10 | Jones Day | Algiers | ||||
14687 | 14687 | 1986-12-01 | South African Sugar Association | 1986-01-31 | SOUTH AFRICA | Jones Day 3427 | 1982-12-10 | Jones Day | Durban | ||||
14940 | 14940 | 1986-12-10 | Interbras Cayman Company | 1984-08-13 | CAYMAN ISLANDS | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Georgetown | ||||
14941 | 14941 | 1986-12-10 | Puma U.S.A., Inc. | 1985-07-31 | GERMANY, FEDERAL REPUBLIC OF | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Framingham | MA | |||
14942 | 14942 | 1987-12-10 | Government of Costa Rica | 1986-08-01 | COSTA RICA | Jones Day 3427 | 1982-12-10 | Jones Day | San Jose | ||||
14943 | 14943 | 1987-12-10 | London Chamber of Commerce & Industry (LCCI) | 1986-03-03 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
16095 | 16095 | 1989-12-31 | Banco Latinoamericano de Exportaciones | 1988-04-20 | PANAMA | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | |||||
16109 | 16109 | 1989-12-31 | Embassy of Lebanon | 1989-05-12 | LEBANON | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Washington | DC | |||
16202 | 16202 | 1991-12-31 | Hachette U.S.A., Inc. | 1991-04-01 | FRANCE | Jones Day 3427 | 1982-12-10 | Jones Day | New York | NY | |||
16219 | 16219 | 1991-12-31 | Sheikha Hussah Sabah al-Salem al-Sabah & Sheikh Nasser Sabah al-Ahmed al-Sabah | 1990-10-19 | KUWAIT | Jones Day 3427 | 1982-12-10 | Jones Day | London | ||||
16341 | 16341 | 1995-12-31 | Internationale Nederlanden Group, N.V. | 1993-11-30 | NETHERLANDS | Jones Day 3427 | 1982-12-10 | Jones Day | Amsterdam | ||||
16365 | 16365 | 1995-12-31 | Sakura Bank, Ltd. | 1992-07-31 | JAPAN | Jones Day 3427 | 1982-12-10 | Jones Day | Tokyo |
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]) );