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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29333 | 29333 | 1993-09-07 | 1992-03-03 | McConville | Sean Daniel Michael | McConville, Sean Daniel Michael 4626 | 1992-03-03 | McConville, Sean Daniel Michael | 62 Greenwich Park Street | Greenwich | London | ||
29893 | 29893 | 2005-09-15 | 2002-08-29 | Pinchin | Jeremy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
30326 | 30326 | 2017-09-23 | 2017-10-06 | Atkinson | Matthew | SCL Social Limited 6473 | 2017-10-06 | SCL Social Limited | 55 New Oxford Street | London | |||
30546 | 30546 | 2005-09-26 | 2005-02-28 | Manning | Stephen | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
31371 | 31371 | 2007-09-30 | 2001-02-27 | Tompson | Bruce Martin | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
31590 | 31590 | 2016-09-30 | 2008-02-25 | McGovern | Sean | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
32289 | 32289 | 2019-10-04 | 2019-05-02 | Fixter | Ruci | Pagefield Global 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
32290 | 32290 | 2019-10-04 | 2019-05-02 | Glover | Stephanie | Pagefield Global 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
32291 | 32291 | 2019-10-04 | 2019-05-02 | Just | Alexander | Pagefield Global 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
32292 | 32292 | 2019-10-04 | 2019-05-02 | Leach | Stuart | Pagefield Global 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
32293 | 32293 | 2019-10-04 | 2019-05-02 | Munro | Malcolm | Pagefield Global 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
32750 | 32750 | 2011-10-13 | 2003-02-28 | Levene | of Portsoken | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
34567 | 34567 | 2007-10-31 | 2007-08-27 | Roberts | Martin | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
34750 | 34750 | 2020-10-31 | 2018-07-09 | Barltrop | Mitchell | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34751 | 34751 | 2020-10-31 | 2018-07-09 | Bubb | Evelyn | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34752 | 34752 | 2020-10-31 | 2018-07-09 | Fornabaio | Danielle | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34753 | 34753 | 2020-10-31 | 2018-07-09 | Lee | Hyunjung Katherine | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34754 | 34754 | 2020-10-31 | 2018-07-09 | Rai | Vadia | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34755 | 34755 | 2020-10-31 | 2018-07-09 | Toleafoa | Zaman | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34756 | 34756 | 2020-10-31 | 2019-08-26 | Cohn | Maria | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34757 | 34757 | 2020-10-31 | 2019-08-26 | Dolan | Shane | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
34758 | 34758 | 2020-10-31 | 2018-12-03 | Doyle | Neil | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
35592 | 35592 | 1995-11-10 | 1994-02-09 | Middleton | Peter James | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
35636 | 35636 | 2019-11-11 | 2018-07-09 | Gajjar | Raina | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | 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 | |||
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]) );