FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
47 rows where Country/Location_Represented = "GREAT BRITAIN" and "Registrant_Date" is on date 1982-12-10 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Address_1, Foreign_Principal_Termination_Date (date)
Foreign_Principal >30
- Avon County Council 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
- Essex County Council 1
- Gloucestershire County Council 1
- Greater Manchester Residuary Body 1
- Gwent County Council 1
- Hampshire County Council 1
- Heron International, N.V. 1
- Hertfordshire County Council 1
- Kent County Council 1
- Lancashire County Council 1
- Leicestershire County Council 1
- London Borough of Barking & Dagenham 1
- London Borough of Hounslow 1
- London Borough of Islington 1
- London Borough of Redbridge 1
- London Borough of Richmond Upon Thames 1
- London Borough of Waltham Forest 1
- London Chamber of Commerce & Industry (LCCI) 1
- …
Foreign_Principal_Registration_Date (date) 5 ✖
- 1988-02-17 43
- 1986-03-03 1
- 1986-10-20 1
- 1987-09-15 1
- 1990-03-20 1
Registrant_Name 2
State 1
- - 47
Country/Location_Represented 1
- GREAT BRITAIN · 47 ✖
City 1
- - 47
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 | ||||
11719 | 11719 | 1991-09-19 | Marks & Spencer, PLC | 1990-03-20 | GREAT BRITAIN | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | 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
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]) );