FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
64 rows where Registrant_Name = "Jones Day"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal
- Avon County Council 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
- City of Bradford Metropolitian Council 1
- Cornwall County Council 1
- County of Cleveland 1
- Cumbria County Council 1
- Devon County Council 1
- Durham County Council 1
- East Sussex County Council 1
- Embassy of France 1
- Embassy of the Democratic Republic of Algeria 1
- Embassy of the People's Republic of China 1
- Embassy of the Republic of Slovenia 1
- Essex County Council 1
- Federation of Bankers' Association of Japan 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
- Hampshire County Council 1
- Heron International, N.V. 1
- Hertfordshire County Council 1
- Internationale Nederlanden Group, N.V. 1
- Kent County Council 1
- ...
Country/Location_Represented
- GREAT BRITAIN 46
- ALGERIA 3
- FRANCE 3
- JAPAN 3
- KUWAIT 2
- CANADA 1
- CHINA 1
- COSTA RICA 1
- GERMANY, FEDERAL REPUBLIC OF 1
- NETHERLANDS 1
- SLOVENIA 1
- SOUTH AFRICA 1
Registrant_Name
- Jones Day · 64 ✖
City
- - 64
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1475 | 1475 | 1994-01-28 | Embassy of the Republic of Slovenia | 1993-07-30 | SLOVENIA | 3427 3427 | 1982-12-10 | Jones Day | Washington, DC | ||||
2268 | 2268 | 1991-02-12 | Embassy of France | 1989-06-22 | FRANCE | 3427 3427 | 1982-12-10 | Jones Day | Washington | DC | |||
3712 | 3712 | 1990-03-20 | Preussag, A.G. | 1989-02-17 | GERMANY, FEDERAL REPUBLIC OF | 3427 3427 | 1982-12-10 | Jones Day | Hannover | ||||
4301 | 4301 | 1992-03-31 | Federation of Bankers' Association of Japan | 1991-05-15 | JAPAN | 3427 3427 | 1982-12-10 | Jones Day | Tokyo | ||||
4478 | 4478 | 2009-03-31 | Embassy of the People's Republic of China | 1986-01-31 | CHINA | 3427 3427 | 1982-12-10 | Jones Day | Washington | DC | |||
8157 | 8157 | 1992-06-30 | Royal Trustco, Ltd. | 1989-04-17 | CANADA | 3427 3427 | 1982-12-10 | Jones Day | Ontario | ||||
8158 | 8158 | 1992-06-30 | Thomson-CSF, S.A. | 1992-04-06 | FRANCE | 3427 3427 | 1982-12-10 | Jones Day | Paris | ||||
8198 | 8198 | 1996-06-30 | Kuwait National Assembly | 1995-08-18 | KUWAIT | 3427 3427 | 1982-12-10 | Jones Day | Safat | ||||
9157 | 9157 | 1990-07-27 | Heron International, N.V. | 1987-09-15 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
9207 | 9207 | 1994-07-29 | Morgan Grenfell & Company, Ltd. | 1986-10-20 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
11200 | 11200 | 1987-09-15 | Konica U.S.A., Wholly-Owned Subsidiary of Konishiroku Photo | 1987-04-24 | JAPAN | 3427 3427 | 1982-12-10 | Jones Day | Englewood Cliffs | NJ | |||
12780 | 12780 | 1991-10-31 | Avon County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Bristol | ||||
12781 | 12781 | 1991-10-31 | Bedfordshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12782 | 12782 | 1991-10-31 | Borough of Haringey | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
12783 | 12783 | 1991-10-31 | Borough of South Tyneside | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Tyne and Wear | ||||
12784 | 12784 | 1991-10-31 | Buckinghamshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Bucks | ||||
12785 | 12785 | 1991-10-31 | Cambridgeshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12786 | 12786 | 1991-10-31 | City of Bradford Metropolitian Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Wakefield | ||||
12787 | 12787 | 1991-10-31 | Cornwall County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Truro | ||||
12788 | 12788 | 1991-10-31 | County of Cleveland | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12789 | 12789 | 1991-10-31 | Cumbria County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12791 | 12791 | 1991-10-31 | Devon County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Exeter | ||||
12792 | 12792 | 1991-10-31 | Durham County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12793 | 12793 | 1991-10-31 | East Sussex County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12794 | 12794 | 1991-10-31 | Essex County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Chelmsford | ||||
12795 | 12795 | 1991-10-31 | Gloucestershire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12797 | 12797 | 1991-10-31 | Greater Manchester Residuary Body | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Manchester | ||||
12798 | 12798 | 1991-10-31 | Gwent County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12799 | 12799 | 1991-10-31 | Hampshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Winchester | ||||
12800 | 12800 | 1991-10-31 | Hertfordshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12801 | 12801 | 1991-10-31 | Kent County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12802 | 12802 | 1991-10-31 | Lancashire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Preston | ||||
12803 | 12803 | 1991-10-31 | Leicestershire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12804 | 12804 | 1991-10-31 | London Borough of Barking & Dagenham | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Essex | ||||
12805 | 12805 | 1991-10-31 | London Borough of Hounslow | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12806 | 12806 | 1991-10-31 | London Borough of Islington | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12807 | 12807 | 1991-10-31 | London Borough of Redbridge | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Essex | ||||
12808 | 12808 | 1991-10-31 | London Borough of Richmond Upon Thames | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Twickenham | ||||
12809 | 12809 | 1991-10-31 | London Borough of Waltham Forest | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
12810 | 12810 | 1991-10-31 | London Residuary Body | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12811 | 12811 | 1991-10-31 | Mid Glamorgan County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Cardiff | ||||
12814 | 12814 | 1991-10-31 | Norfolk County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Norwich | ||||
12815 | 12815 | 1991-10-31 | North Yorkshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12816 | 12816 | 1991-10-31 | Northamptonshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12817 | 12817 | 1991-10-31 | Oxfordshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Oxford | ||||
12820 | 12820 | 1991-10-31 | Royal County of Berkshire | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Reading | ||||
12822 | 12822 | 1991-10-31 | Somerset County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Taunton | ||||
12823 | 12823 | 1991-10-31 | South Glamorgan County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Cardiff | ||||
12824 | 12824 | 1991-10-31 | South Yorkshire Residuary Body | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12826 | 12826 | 1991-10-31 | West Glamorgan County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Swansea | ||||
12827 | 12827 | 1991-10-31 | West Sussex County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | |||||
12828 | 12828 | 1991-10-31 | Westminster City Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
12829 | 12829 | 1991-10-31 | Wiltshire County Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | Trowbridge | ||||
12830 | 12830 | 1991-10-31 | Wolverhampton Borough Council | 1988-02-17 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | West Midlands | ||||
13102 | 13102 | 1994-11-01 | Bank of Algeria, Acting on behalf of the Government of the Republic of Algeria | 1993-05-03 | ALGERIA | 3427 3427 | 1982-12-10 | Jones Day | Algiers | ||||
13104 | 13104 | 1994-11-01 | Embassy of the Democratic Republic of Algeria | 1993-05-28 | ALGERIA | 3427 3427 | 1982-12-10 | Jones Day | Washington | DC | |||
14152 | 14152 | 1986-12-01 | SONATRACH - Societe Nationale de Transport et de Commercialisation des Hydrocarbures | 1982-12-10 | ALGERIA | 3427 3427 | 1982-12-10 | Jones Day | Algiers | ||||
14153 | 14153 | 1986-12-01 | South African Sugar Association | 1986-01-31 | SOUTH AFRICA | 3427 3427 | 1982-12-10 | Jones Day | Durban | ||||
14400 | 14400 | 1987-12-10 | Government of Costa Rica | 1986-08-01 | COSTA RICA | 3427 3427 | 1982-12-10 | Jones Day | San Jose | ||||
14401 | 14401 | 1987-12-10 | London Chamber of Commerce & Industry (LCCI) | 1986-03-03 | GREAT BRITAIN | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
15643 | 15643 | 1991-12-31 | Hachette U.S.A., Inc. | 1991-04-01 | FRANCE | 3427 3427 | 1982-12-10 | Jones Day | New York | NY | |||
15660 | 15660 | 1991-12-31 | Sheikha Hussah Sabah al-Salem al-Sabah & Sheikh Nasser Sabah al-Ahmed al-Sabah | 1990-10-19 | KUWAIT | 3427 3427 | 1982-12-10 | Jones Day | London | ||||
15782 | 15782 | 1995-12-31 | Internationale Nederlanden Group, N.V. | 1993-11-30 | NETHERLANDS | 3427 3427 | 1982-12-10 | Jones Day | Amsterdam | ||||
15806 | 15806 | 1995-12-31 | Sakura Bank, Ltd. | 1992-07-31 | JAPAN | 3427 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) );