FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
43 rows where "Foreign_Principal_Registration_Date" is on date 1988-02-17, "Foreign_Principal_Termination_Date" is on date 1991-10-31 and "Registrant_Date" is on date 1982-12-10
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_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
- 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 Residuary Body 1
- Mid Glamorgan County Council 1
- …
State 1
- - 43
Registrant_Name 1
- Jones Day 43
Country/Location_Represented 1
City 1
- - 43
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]) );