FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Address_1 = "" and Registrant_Name = "Jones Day"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 18
- Bedfordshire County Council 1
- Cambridgeshire County Council 1
- County of Cleveland 1
- Cumbria County Council 1
- Durham County Council 1
- East Sussex County Council 1
- Gloucestershire County Council 1
- Gwent County Council 1
- Hertfordshire County Council 1
- Kent County Council 1
- Leicestershire County Council 1
- London Borough of Hounslow 1
- London Borough of Islington 1
- London Residuary Body 1
- North Yorkshire County Council 1
- Northamptonshire County Council 1
- South Yorkshire Residuary Body 1
- West Sussex County Council 1
State 1
- - 18
Registrant_Name 1
- Jones Day · 18 ✖
Registrant_Date (date) 1 ✖
- 1982-12-10 18
Country/Location_Represented 1
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13278 | 13278 | 1991-10-31 | Bedfordshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13282 | 13282 | 1991-10-31 | Cambridgeshire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
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 | |||||
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 | |||||
13292 | 13292 | 1991-10-31 | Gloucestershire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13295 | 13295 | 1991-10-31 | Gwent County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
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 | |||||
13300 | 13300 | 1991-10-31 | Leicestershire County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
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 | |||||
13307 | 13307 | 1991-10-31 | London Residuary Body | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
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 | |||||
13321 | 13321 | 1991-10-31 | South Yorkshire Residuary Body | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day | |||||
13324 | 13324 | 1991-10-31 | West Sussex County Council | 1988-02-17 | GREAT BRITAIN | Jones Day 3427 | 1982-12-10 | Jones Day |
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]) );