home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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)

Foreign_Principal >30

  • 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 12

  • 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

State 4

  • - 59
  • DC 3
  • NJ 1
  • NY 1

Registrant_Name 1

  • Jones Day · 64 ✖

City 1

  • - 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
1594 1594 1994-01-28 Embassy of the Republic of Slovenia 1993-07-30 SLOVENIA Jones Day 3427 1982-12-10 Jones Day Washington, DC        
2408 2408 1991-02-12 Embassy of France 1989-06-22 FRANCE Jones Day 3427 1982-12-10 Jones Day Washington     DC  
3915 3915 1990-03-20 Preussag, A.G. 1989-02-17 GERMANY, FEDERAL REPUBLIC OF Jones Day 3427 1982-12-10 Jones Day Hannover        
4511 4511 1992-03-31 Federation of Bankers' Association of Japan 1991-05-15 JAPAN Jones Day 3427 1982-12-10 Jones Day Tokyo        
4688 4688 2009-03-31 Embassy of the People's Republic of China 1986-01-31 CHINA Jones Day 3427 1982-12-10 Jones Day Washington     DC  
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        
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        
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  
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        
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        
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

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 · Queries took 591.499ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows