FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

64 rows where Registrant_Name = "Jones Day"

✎ View and edit SQL

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)

State

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
1485 1485 1994-01-28 Embassy of the Republic of Slovenia 1993-07-30 SLOVENIA 3427 3427 1982-12-10 Jones Day Washington, DC        
2270 2270 1991-02-12 Embassy of France 1989-06-22 FRANCE 3427 3427 1982-12-10 Jones Day Washington     DC  
3707 3707 1990-03-20 Preussag, A.G. 1989-02-17 GERMANY, FEDERAL REPUBLIC OF 3427 3427 1982-12-10 Jones Day Hannover        
4296 4296 1992-03-31 Federation of Bankers' Association of Japan 1991-05-15 JAPAN 3427 3427 1982-12-10 Jones Day Tokyo        
4473 4473 2009-03-31 Embassy of the People's Republic of China 1986-01-31 CHINA 3427 3427 1982-12-10 Jones Day Washington     DC  
8131 8131 1992-06-30 Royal Trustco, Ltd. 1989-04-17 CANADA 3427 3427 1982-12-10 Jones Day Ontario        
8132 8132 1992-06-30 Thomson-CSF, S.A. 1992-04-06 FRANCE 3427 3427 1982-12-10 Jones Day Paris        
8172 8172 1996-06-30 Kuwait National Assembly 1995-08-18 KUWAIT 3427 3427 1982-12-10 Jones Day Safat        
9127 9127 1990-07-27 Heron International, N.V. 1987-09-15 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day London        
9177 9177 1994-07-29 Morgan Grenfell & Company, Ltd. 1986-10-20 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day London        
11155 11155 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  
12711 12711 1991-10-31 Avon County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Bristol        
12712 12712 1991-10-31 Bedfordshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12713 12713 1991-10-31 Borough of Haringey 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day London        
12714 12714 1991-10-31 Borough of South Tyneside 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Tyne and Wear        
12715 12715 1991-10-31 Buckinghamshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Bucks        
12716 12716 1991-10-31 Cambridgeshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12717 12717 1991-10-31 City of Bradford Metropolitian Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Wakefield        
12718 12718 1991-10-31 Cornwall County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Truro        
12719 12719 1991-10-31 County of Cleveland 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12720 12720 1991-10-31 Cumbria County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12722 12722 1991-10-31 Devon County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Exeter        
12723 12723 1991-10-31 Durham County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12724 12724 1991-10-31 East Sussex County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12725 12725 1991-10-31 Essex County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Chelmsford        
12726 12726 1991-10-31 Gloucestershire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12728 12728 1991-10-31 Greater Manchester Residuary Body 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Manchester        
12729 12729 1991-10-31 Gwent County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12730 12730 1991-10-31 Hampshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Winchester        
12731 12731 1991-10-31 Hertfordshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12732 12732 1991-10-31 Kent County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12733 12733 1991-10-31 Lancashire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Preston        
12734 12734 1991-10-31 Leicestershire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12735 12735 1991-10-31 London Borough of Barking & Dagenham 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Essex        
12736 12736 1991-10-31 London Borough of Hounslow 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12737 12737 1991-10-31 London Borough of Islington 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12738 12738 1991-10-31 London Borough of Redbridge 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Essex        
12739 12739 1991-10-31 London Borough of Richmond Upon Thames 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Twickenham        
12740 12740 1991-10-31 London Borough of Waltham Forest 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day London        
12741 12741 1991-10-31 London Residuary Body 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12742 12742 1991-10-31 Mid Glamorgan County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Cardiff        
12745 12745 1991-10-31 Norfolk County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Norwich        
12746 12746 1991-10-31 North Yorkshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12747 12747 1991-10-31 Northamptonshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12748 12748 1991-10-31 Oxfordshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Oxford        
12751 12751 1991-10-31 Royal County of Berkshire 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Reading        
12753 12753 1991-10-31 Somerset County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Taunton        
12754 12754 1991-10-31 South Glamorgan County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Cardiff        
12755 12755 1991-10-31 South Yorkshire Residuary Body 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12757 12757 1991-10-31 West Glamorgan County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Swansea        
12758 12758 1991-10-31 West Sussex County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day          
12759 12759 1991-10-31 Westminster City Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day London        
12760 12760 1991-10-31 Wiltshire County Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day Trowbridge        
12761 12761 1991-10-31 Wolverhampton Borough Council 1988-02-17 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day West Midlands        
13030 13030 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        
13032 13032 1994-11-01 Embassy of the Democratic Republic of Algeria 1993-05-28 ALGERIA 3427 3427 1982-12-10 Jones Day Washington     DC  
14070 14070 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        
14071 14071 1986-12-01 South African Sugar Association 1986-01-31 SOUTH AFRICA 3427 3427 1982-12-10 Jones Day Durban        
14316 14316 1987-12-10 Government of Costa Rica 1986-08-01 COSTA RICA 3427 3427 1982-12-10 Jones Day San Jose        
14317 14317 1987-12-10 London Chamber of Commerce & Industry (LCCI) 1986-03-03 GREAT BRITAIN 3427 3427 1982-12-10 Jones Day London        
15557 15557 1991-12-31 Hachette U.S.A., Inc. 1991-04-01 FRANCE 3427 3427 1982-12-10 Jones Day New York     NY  
15574 15574 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        
15696 15696 1995-12-31 Internationale Nederlanden Group, N.V. 1993-11-30 NETHERLANDS 3427 3427 1982-12-10 Jones Day Amsterdam        
15720 15720 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

CSV options: 

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)
);
Powered by Datasette · Query took 176.503ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history