FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
119 rows where City = "London"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
36805 | 36805 | 1996-11-30 | 1994-02-09 | Merrett | Stephen Roy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
36899 | 36899 | 2002-11-30 | 2001-04-16 | Riley | S. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
37541 | 37541 | 2018-12-01 | 2018-07-09 | Walton | Andrew | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
39039 | 39039 | 2021-12-23 | 2021-10-06 | Roubi | Matthieu | Project Associates UK Ltd. 7024 | 2021-10-06 | Project Associates UK Ltd. | 30 Haymarket St James's | London | |||
39181 | 39181 | 1994-12-27 | 1991-11-05 | Coghlin | Terence G. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41007 | 41007 | 1997-12-31 | 1994-02-09 | Rowland | John David | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41077 | 41077 | 1998-12-31 | 1994-02-09 | Youell | J. Richard L. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41105 | 41105 | 1998-12-31 | 1996-09-09 | Miller | Peter | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41147 | 41147 | 1999-12-31 | 1993-07-06 | Readman | R.N. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41176 | 41176 | 2000-12-31 | 1994-01-06 | Duguid | Andrew A. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41179 | 41179 | 2000-12-31 | 1998-02-27 | Taylor | John Maxwell Percy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41192 | 41192 | 2000-12-31 | 1995-07-10 | Greenwood | George E. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41374 | 41374 | 2004-12-31 | 1991-11-05 | Seward | Robert | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41545 | 41545 | 2007-12-31 | 2007-03-01 | Baker | Winifred A. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41653 | 41653 | 2009-12-31 | 2005-02-28 | Tolle | Rolf | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
42311 | 42311 | 2020-12-31 | 2019-02-15 | Worthington | Rob Ian | Project Associates UK Ltd 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | ||
42347 | 42347 | 2020-12-31 | 2017-10-06 | Rigg | David John Kilshaw | Project Associates UK Ltd 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | 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]) );