FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Address_2 = "" and City = "London" sorted by Business_Name
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Termination_Date, Registration_Date (date), Termination_Date (date)
Address_1 12
- 200 Aldersgate, Aldersgate Street 1
- 30 Haymarket St James's 1
- 42-46 Weymouth Street 1
- 5 Chancery Lane 1
- 55 New Oxford Street 1
- 69 Cannon Street 1
- 90 High Holborn 1
- 91 Jermyn Street, First Floor 1
- 9BR Chambers, 11/12 Soputh Square 1
- Oculus Financial Intelligence, 25 Park Lane 1
- One Lime Street 1
- One Silk Street 1
State 1
- - 12
City 1
- London · 12 ✖
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name ▼ | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3784 | 1986-02-28 | 1986-10-20 | Weatherhead, T. Ian | 69 Cannon Street | London | ||||
3786 | 1986-02-28 | 1986-10-20 | Arkell, Julian | 42-46 Weymouth Street | London | ||||
4883 | 1994-01-06 | 2018-07-31 | Lloyd's of London Market Representatives | One Lime Street | London | ||||
6473 | 2017-10-06 | 2017-10-06 | SCL Social Limited | 55 New Oxford Street | London | ||||
6569 | 2018-07-09 | 2020-10-31 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | ||||
6675 | 2019-05-02 | 2019-10-04 | Pagefield Global | 5 Chancery Lane | London | ||||
6795 | 2020-02-24 | 2023-02-13 | Linklaters LLP | One Silk Street | London | ||||
7024 | 2021-10-06 | 2022-05-06 | Project Associates UK Ltd. | 30 Haymarket St James's | London | ||||
7033 | 2021-11-01 | 2022-05-31 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | ||||
7040 | 2021-11-09 | Quinn Emanuel Urquhart & Sullivan UK LLP | 90 High Holborn | London | |||||
7253 | 2023-04-03 | Jonathan Dart | Oculus Financial Intelligence, 25 Park Lane | London | |||||
7257 | 2023-04-11 | Steven Walton Kay | 9BR Chambers, 11/12 Soputh Square | London |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );