FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

91 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

  • 91

City

  • London · 91
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
288   2019-02-15 Morland Danielle 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
289   2019-02-15 Worthington Rob Ian 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
320   2020-02-24 Bartels Lorand 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
321   2020-02-24 Brooks Aaron 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
324   2020-02-24 Coldicutt Samuel 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
325   2020-02-24 Fawke Alexander 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
326   2020-02-24 Gracia Natura 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
327   2020-02-24 Kar Nicole 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
328   2020-02-24 Lurie Adam 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
329   2020-02-24 Metcalf Caitlin 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
330   2020-02-24 Morgan Charlotte 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
331   2020-02-24 Ormerod Imogen 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
332   2020-02-24 Tridgell Anthony 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
333   2020-02-24 Weiniger Matthew 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
962   2020-05-22 Evtimov Bogdan Venelinov 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1289   2018-07-09 Barltrop Mitchell 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1290   2018-07-09 Bubb Evelyn 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1291   2018-07-09 Fornabaio Danielle 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1292   2018-07-09 Gajjar Raina 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1293   2018-07-09 Lee Hyunjung Katherine 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1294   2018-07-09 Rai Vadia 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1295   2018-07-09 Toleafoa Zaman 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1322   2019-07-12 Hawker Jonathan 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1587   2019-08-26 Cohn Maria 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1588   2019-08-26 Dolan Shane 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1850   2017-10-06 Rigg David John Kilshaw 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
2128   2019-11-20 Winstanley Robert 6752 6752 2019-11-20 Halcyon Associates 69 Old Broad Street   London    
2267   2018-12-03 Doyle Neil 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
2765 2006-01-01 1998-09-02 Prettejohn Nicholas 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
5237 2012-01-31 1999-02-24 Matcham David 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
5539 2002-02-01 1996-09-09 Barker Jane 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
6853 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    
7607 1995-02-28 1994-01-06 Suterwalla Razia 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
7793 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    
9425 2000-03-15 1998-02-27 Skwiertz Albert 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
10063 2007-03-23 2005-02-28 Russell David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11122 1995-03-31 1994-02-09 Hall Stephen Hargreaves 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11124 1995-03-31 1994-02-16 Mallinson John Russell 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
13978 1998-04-30 1994-06-01 Lane Peter William 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14157 2007-04-30 1998-02-27 James Julian 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14351 2019-04-30 2019-02-15 Wild Suzy 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14372 2019-04-30 2017-10-06 Loeffen-Gallagher Ryan 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14673 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    
16986 2006-05-31 1999-06-30 Burgess Sara 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17000 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    
17001 2006-05-31 2005-12-14 Bardot Andrew 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17002 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    
20158 1999-06-30 1996-09-09 Sandler Ronald A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
20683 2017-06-30 2001-02-27 Westcott Rosemary Beaver 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23579 2001-07-31 1999-02-24 Carroll Tim 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
23904 2018-07-31 2013-02-26 Miesowitz Sabrina Ariel 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23905 2018-07-31 2005-02-28 Parry John 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23906 2018-07-31 2018-03-02 Carter Misty 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23907 2018-07-31 2018-03-02 Claydon Simon 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23914 2018-07-31 1994-06-01 Evans Alastair MacKenzie 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23918 2018-07-31 2000-08-17 Gunset Joseph P. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23919 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    
23921 2018-07-31 2016-08-30 Grant Tirnothy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23922 2018-07-31 2017-08-30 Weaver Hilary 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23944 2019-07-31 2018-07-09 Earl Jonathan Richard 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
26657 1995-08-31 1994-01-06 Gibson Barry J. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
26842 2005-08-31 1999-07-07 Havers Chris 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
26843 2005-08-31 2001-07-10 James Stephen 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
27684 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    
28226 2005-09-15 2002-08-29 Pinchin Jeremy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
28638 2017-09-23 2017-10-06 Atkinson Matthew 6473 6473 2017-10-06 SCL Social Limited 55 New Oxford Street   London    
28849 2005-09-26 2005-02-28 Manning Stephen 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
29669 2007-09-30 2001-02-27 Tompson Bruce Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
29889 2016-09-30 2008-02-25 McGovern Sean 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
30504 2019-10-04 2019-05-02 Fixter Ruci 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30505 2019-10-04 2019-05-02 Glover Stephanie 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30506 2019-10-04 2019-05-02 Just Alexander 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30507 2019-10-04 2019-05-02 Leach Stuart 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30508 2019-10-04 2019-05-02 Munro Malcolm 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30932 2011-10-13 2003-02-28 Levene of Portsoken 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
32692 2007-10-31 2007-08-27 Roberts Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
33629 1995-11-10 1994-02-09 Middleton Peter James 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
34781 1996-11-30 1994-02-09 Merrett Stephen Roy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
34875 2002-11-30 2001-04-16 Riley S. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
35449 2018-12-01 2018-07-09 Walton Andrew 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
37007 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    
38828 1997-12-31 1994-02-09 Rowland John David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
38898 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    
38926 1998-12-31 1996-09-09 Miller Peter 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
38968 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    
38997 2000-12-31 1994-01-06 Duguid Andrew A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39000 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    
39013 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    
39194 2004-12-31 1991-11-05 Seward Robert 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
39365 2007-12-31 2007-03-01 Baker Winifred A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39474 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)
);
Powered by Datasette · Query took 391.285ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history