FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
51 rows where "Foreign_Principal_Termination_Date" is on date 1991-10-31
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1
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
- Democratic Socialist Republic of Sri Lanka, Ministry of Foreign Affairs 1
- Devon County Council 1
- Durham County Council 1
- East Sussex County Council 1
- Essex County Council 1
- Gloucestershire County Council 1
- Government of the Republic of Slovenia 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
- …
Registrant_Name 9
Registrant_Date 9 ✖
- 1982-12-10 43
- 1972-01-17 1
- 1981-11-10 1
- 1983-02-16 1
- 1987-02-25 1
- 1989-05-25 1
- 1990-04-24 1
- 1991-03-22 1
- 1991-09-23 1
Registrant_Date (date) 9 ✖
- 1982-12-10 43
- 1972-01-17 1
- 1981-11-10 1
- 1983-02-16 1
- 1987-02-25 1
- 1989-05-25 1
- 1990-04-24 1
- 1991-03-22 1
- 1991-09-23 1
Foreign_Principal_Registration_Date (date) 9 ✖
- 1988-02-17 43
- 1972-01-17 1
- 1987-02-25 1
- 1990-04-24 1
- 1991-03-22 1
- 1991-07-24 1
- 1991-09-11 1
- 1991-09-23 1
- 1991-10-30 1
Country/Location_Represented 9
- GREAT BRITAIN 43
- HONDURAS 1
- INDONESIA 1
- JAPAN 1
- NEW ZEALAND 1
- PERU 1
- SAUDI ARABIA 1
- SLOVENIA 1
- SRI LANKA 1
City 1
- - 51
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 | |||||
13287 | 13287 | 1991-10-31 | Democratic Socialist Republic of Sri Lanka, Ministry of Foreign Affairs | 1990-04-24 | SRI LANKA | Peiris, James Elroy Sheron 4369 | 1990-04-24 | Peiris, James Elroy Sheron | Colombo | ||||
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 | |||||
13293 | 13293 | 1991-10-31 | Government of the Republic of Slovenia | 1991-03-22 | SLOVENIA | Government Liaison Office of the Republic of Slovenia 4488 | 1991-03-22 | Government Liaison Office of the Republic of Slovenia | Ljubljana | ||||
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 | ||||
13309 | 13309 | 1991-10-31 | Ministry of Forestry of Indonesia, represented by the Embassy of Indonesia | 1991-09-11 | INDONESIA | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Washington | DC | |||
13310 | 13310 | 1991-10-31 | New Zealand Government Tourist & Publicity Department | 1972-01-17 | NEW ZEALAND | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | Wellington | ||||
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 | ||||
13315 | 13315 | 1991-10-31 | Peru Tourist Office, Inc. (FOPTUR) | 1991-07-24 | PERU | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Miami | FL | |||
13316 | 13316 | 1991-10-31 | Rafael Leanardo Callejas | 1991-10-30 | HONDURAS | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | |||||
13317 | 13317 | 1991-10-31 | Royal County of Berkshire | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | Reading | ||||
13318 | 13318 | 1991-10-31 | Sheikh Kamal Adham | 1991-09-23 | SAUDI ARABIA | Rogers Jr., Edward M. 4570 | 1991-09-23 | Rogers Jr., Edward M. | Jeddah | ||||
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 | |||||
13322 | 13322 | 1991-10-31 | Toa Nenryo Kogyo Kabushiki Kaisha (Tonen Corporation) | 1987-02-25 | JAPAN | First Associates, Inc. 3941 | 1987-02-25 | First Associates, Inc. | Tokyo | ||||
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]) );