List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

93 rows where City = "London"

View and edit SQL

Suggested facets: Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

  • - 93

City

  • London · 93
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
340   2019-02-15 Morland Danielle 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
341   2019-02-15 Worthington Rob Ian 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
380   2020-02-24 Bartels Lorand 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
381   2020-02-24 Brooks Aaron 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
384   2020-02-24 Coldicutt Samuel 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
385   2020-02-24 Fawke Alexander 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
386   2020-02-24 Gracia Natura 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
387   2020-02-24 Kar Nicole 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
388   2020-02-24 Lurie Adam 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
389   2020-02-24 Metcalf Caitlin 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
390   2020-02-24 Morgan Charlotte 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
391   2020-02-24 Ormerod Imogen 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
392   2020-02-24 Tridgell Anthony 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
393   2020-02-24 Weiniger Matthew 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
860   2020-05-22 Evtimov Bogdan Venelinov 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1554   2020-09-29 Darling Jr. Sterling Price Adams 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1596   2017-10-06 Rigg David John Kilshaw 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
1930   2019-11-20 Winstanley Robert 6752 6752 2019-11-20 Halcyon Associates 69 Old Broad Street   London    
2579 2006-01-01 1998-09-02 Prettejohn Nicholas 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
2865 2020-01-03 2020-08-26 Levi Zac 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
5095 2012-01-31 1999-02-24 Matcham David 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
5418 2002-02-01 1996-09-09 Barker Jane 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
6765 2005-02-18 1999-01-12 Rossi Marie-Louise 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
7533 1995-02-28 1994-01-06 Suterwalla Razia 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
7719 2006-02-28 1999-02-24 Cane Stephen P. 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
9396 2000-03-15 1998-02-27 Skwiertz Albert 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
10035 2007-03-23 2005-02-28 Russell David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11096 1995-03-31 1994-02-09 Hall Stephen Hargreaves 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11098 1995-03-31 1994-02-16 Mallinson John Russell 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
13981 1998-04-30 1994-06-01 Lane Peter William 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14160 2007-04-30 1998-02-27 James Julian 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14354 2019-04-30 2019-02-15 Wild Suzy 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14380 2019-04-30 2017-10-06 Loeffen-Gallagher Ryan 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14704 1990-05-02 1990-05-07 Bissell Robert Bruce 4374 4374 1990-05-17 Roe, Hugh R. ICI Group Headquarters 9 Millbank, Finance Department London    
17045 2006-05-31 1999-06-30 Burgess Sara 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17059 2006-05-31 1991-11-05 Watkins D.J.L. 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17060 2006-05-31 2005-12-14 Bardot Andrew 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17061 2006-05-31 2005-12-14 Groom Alistair John 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
20239 1999-06-30 1996-09-09 Sandler Ronald A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
20764 2017-06-30 2001-02-27 Westcott Rosemary Beaver 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
21806 2020-07-12 2019-07-12 Hawker Jonathan 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
23708 2001-07-31 1999-02-24 Carroll Tim 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
24033 2018-07-31 2013-02-26 Miesowitz Sabrina Ariel 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24034 2018-07-31 2005-02-28 Parry John 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24035 2018-07-31 2018-03-02 Carter Misty 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24036 2018-07-31 2018-03-02 Claydon Simon 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24043 2018-07-31 1994-06-01 Evans Alastair MacKenzie 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24047 2018-07-31 2000-08-17 Gunset Joseph P. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24048 2018-07-31 2002-08-19 Walmsley James Stuart Mainprize 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24050 2018-07-31 2016-08-30 Grant Tirnothy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24051 2018-07-31 2017-08-30 Weaver Hilary 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24075 2019-07-31 2018-07-09 Earl Jonathan Richard 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
26869 1995-08-31 1994-01-06 Gibson Barry J. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
27054 2005-08-31 1999-07-07 Havers Chris 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
27055 2005-08-31 2001-07-10 James Stephen 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
27913 1993-09-07 1992-03-03 McConville Sean Daniel Michael 4626 4626 1992-03-03 McConville, Sean Daniel Michael 62 Greenwich Park Street Greenwich London    
28458 2005-09-15 2002-08-29 Pinchin Jeremy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
28871 2017-09-23 2017-10-06 Atkinson Matthew 6473 6473 2017-10-06 SCL Social Limited 55 New Oxford Street   London    
29087 2005-09-26 2005-02-28 Manning Stephen 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
29908 2007-09-30 2001-02-27 Tompson Bruce Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
30128 2016-09-30 2008-02-25 McGovern Sean 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
30768 2019-10-04 2019-05-02 Fixter Ruci 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30769 2019-10-04 2019-05-02 Glover Stephanie 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30770 2019-10-04 2019-05-02 Just Alexander 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30771 2019-10-04 2019-05-02 Leach Stuart 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30772 2019-10-04 2019-05-02 Munro Malcolm 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31204 2011-10-13 2003-02-28 Levene of Portsoken 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
32989 2007-10-31 2007-08-27 Roberts Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
33172 2020-10-31 2018-07-09 Barltrop Mitchell 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33173 2020-10-31 2018-07-09 Bubb Evelyn 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33174 2020-10-31 2018-07-09 Fornabaio Danielle 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33175 2020-10-31 2018-07-09 Lee Hyunjung Katherine 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33176 2020-10-31 2018-07-09 Rai Vadia 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33177 2020-10-31 2018-07-09 Toleafoa Zaman 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33178 2020-10-31 2019-08-26 Cohn Maria 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33179 2020-10-31 2019-08-26 Dolan Shane 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33180 2020-10-31 2018-12-03 Doyle Neil 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33954 1995-11-10 1994-02-09 Middleton Peter James 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
33991 2019-11-11 2018-07-09 Gajjar Raina 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
35123 1996-11-30 1994-02-09 Merrett Stephen Roy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
35217 2002-11-30 2001-04-16 Riley S. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
35829 2018-12-01 2018-07-09 Walton Andrew 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
37398 1994-12-27 1991-11-05 Coghlin Terence G. 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
39219 1997-12-31 1994-02-09 Rowland John David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39289 1998-12-31 1994-02-09 Youell J. Richard L. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39317 1998-12-31 1996-09-09 Miller Peter 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39359 1999-12-31 1993-07-06 Readman R.N. 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
39388 2000-12-31 1994-01-06 Duguid Andrew A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39391 2000-12-31 1998-02-27 Taylor John Maxwell Percy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39404 2000-12-31 1995-07-10 Greenwood George E. 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
39585 2004-12-31 1991-11-05 Seward Robert 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
39756 2007-12-31 2007-03-01 Baker Winifred A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39865 2009-12-31 2005-02-28 Tolle Rolf 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);