FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

46 rows where Country/Location_Represented = "GREAT BRITAIN" and Registrant_Name = "Jones Day"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

  • - 46

Registrant_Name 1

  • Jones Day · 46 ✖

Country/Location_Represented 1

  • GREAT BRITAIN · 46 ✖

City 1

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

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])
);