FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
119 rows where City = "London" sorted by Registration_Number
This data as json, CSV (advanced)
Registration_Number 2
Registration_Date (date) 2 ✖
- 2021-11-01 14
- 2021-11-09 5
Registrant_Name 2
State 1
- - 19
City 1
- London · 19 ✖
Link | rowid | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number ▼ | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18260 | 18260 | 2022-05-31 | 2021-11-01 | Baker | Zara | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18261 | 18261 | 2022-05-31 | 2021-11-01 | Birnbaum | George Eli | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18262 | 18262 | 2022-05-31 | 2021-11-01 | Collier | Benjamin Britworth | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18263 | 18263 | 2022-05-31 | 2021-11-01 | Denselow | Toby | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18264 | 18264 | 2022-05-31 | 2021-11-01 | Galan | Vladislava | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18265 | 18265 | 2022-05-31 | 2021-11-01 | Hassan | Miran | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18266 | 18266 | 2022-05-31 | 2021-11-01 | McMillan | Thomas Jock | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18267 | 18267 | 2022-05-31 | 2021-11-01 | Ogborn | William | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18268 | 18268 | 2022-05-31 | 2021-11-01 | Reid | Morris | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18269 | 18269 | 2022-05-31 | 2021-11-01 | Toomey | Molly | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18270 | 18270 | 2022-05-31 | 2021-11-01 | Walker | Alexander | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18271 | 18271 | 2022-05-31 | 2021-11-02 | Walker | Alexander DJ | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18274 | 18274 | 2022-05-31 | 2021-12-14 | Fabian | Olamide Noah | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
36461 | 36461 | 2021-11-26 | 2021-11-01 | Sculthorpe | Timothy | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
1341 | 1341 | 2023-06-30 | Le Miere | Lucienne Anne | Quinn Emanuel Urquhart & Sullivan UK LLP 7040 | 2021-11-09 | Quinn Emanuel Urquhart & Sullivan UK LLP | 90 High Holborn | London | ||||
1342 | 1342 | 2023-06-30 | Nelder | Alexander Joseph | Quinn Emanuel Urquhart & Sullivan UK LLP 7040 | 2021-11-09 | Quinn Emanuel Urquhart & Sullivan UK LLP | 90 High Holborn | London | ||||
2127 | 2127 | 2021-11-09 | Gerbi | Alexander Joseph | Quinn Emanuel Urquhart & Sullivan UK LLP 7040 | 2021-11-09 | Quinn Emanuel Urquhart & Sullivan UK LLP | 90 High Holborn | London | ||||
2128 | 2128 | 2021-11-09 | Menezes | Jagdish John | Quinn Emanuel Urquhart & Sullivan UK LLP 7040 | 2021-11-09 | Quinn Emanuel Urquhart & Sullivan UK LLP | 90 High Holborn | London | ||||
10022 | 10022 | 2023-03-15 | 2021-11-09 | Squires | Jerome Alexander | Quinn Emanuel Urquhart & Sullivan UK LLP 7040 | 2021-11-09 | Quinn Emanuel Urquhart & Sullivan UK LLP | 90 High Holborn | London |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_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]) );