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

78 rows where City = "London"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

Registration_Number

State

  • 78

City

  • London · 78 ✖
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
320 320   2019-02-15 Morland Danielle 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
321 321   2019-02-15 Worthington Rob Ian 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
1146 1146   2018-07-09 Barltrop Mitchell 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1147 1147   2018-07-09 Bubb Evelyn 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1148 1148   2018-07-09 Fornabaio Danielle 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1149 1149   2018-07-09 Gajjar Raina 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1150 1150   2018-07-09 Lee Hyunjung Katherine 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1151 1151   2018-07-09 Rai Vadia 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1153 1153   2018-07-09 Toleafoa Zaman 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1173 1173   2019-07-12 Hawker Jonathan 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1413 1413   2019-08-26 Cohn Maria 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1414 1414   2019-08-26 Dolan Shane 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
1724 1724   2017-10-06 Rigg David John Kilshaw 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
2032 2032   2019-11-20 Winstanley Robert 6752 6752 2019-11-20 Halcyon Associates 69 Old Broad Street   London    
2194 2194   2018-12-03 Doyle Neil 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
2707 2707 2006-01-01 1998-09-02 Prettejohn Nicholas 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
5162 5162 2012-01-31 1999-02-24 Matcham David 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
5451 5451 2002-02-01 1996-09-09 Barker Jane 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
6753 6753 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    
7498 7498 1995-02-28 1994-01-06 Suterwalla Razia 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
7684 7684 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    
9294 9294 2000-03-15 1998-02-27 Skwiertz Albert 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
9929 9929 2007-03-23 2005-02-28 Russell David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
10981 10981 1995-03-31 1994-02-09 Hall Stephen Hargreaves 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
10983 10983 1995-03-31 1994-02-16 Mallinson John Russell 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
13802 13802 1998-04-30 1994-06-01 Lane Peter William 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
13981 13981 2007-04-30 1998-02-27 James Julian 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14173 14173 2019-04-30 2019-02-15 Wild Suzy 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14179 14179 2019-04-30 2017-10-06 Loeffen-Gallagher Ryan 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14458 14458 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    
16755 16755 2006-05-31 1999-06-30 Burgess Sara 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
16769 16769 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    
16770 16770 2006-05-31 2005-12-14 Bardot Andrew 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
16771 16771 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    
19911 19911 1999-06-30 1996-09-09 Sandler Ronald A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
20436 20436 2017-06-30 2001-02-27 Westcott Rosemary Beaver 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23302 23302 2001-07-31 1999-02-24 Carroll Tim 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
23627 23627 2018-07-31 2013-02-26 Miesowitz Sabrina Ariel 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23628 23628 2018-07-31 2005-02-28 Parry John 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23629 23629 2018-07-31 2018-03-02 Carter Misty 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23630 23630 2018-07-31 2018-03-02 Claydon Simon 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23637 23637 2018-07-31 1994-06-01 Evans Alastair MacKenzie 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23641 23641 2018-07-31 2000-08-17 Gunset Joseph P. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23642 23642 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    
23644 23644 2018-07-31 2016-08-30 Grant Tirnothy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23645 23645 2018-07-31 2017-08-30 Weaver Hilary 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23664 23664 2019-07-31 2018-07-09 Earl Jonathan Richard 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
26354 26354 1995-08-31 1994-01-06 Gibson Barry J. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
26539 26539 2005-08-31 1999-07-07 Havers Chris 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
26540 26540 2005-08-31 2001-07-10 James Stephen 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
27375 27375 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    
27917 27917 2005-09-15 2002-08-29 Pinchin Jeremy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
28327 28327 2017-09-23 2017-10-06 Atkinson Matthew 6473 6473 2017-10-06 SCL Social Limited 55 New Oxford Street   London    
28536 28536 2005-09-26 2005-02-28 Manning Stephen 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
29353 29353 2007-09-30 2001-02-27 Tompson Bruce Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
29573 29573 2016-09-30 2008-02-25 McGovern Sean 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
30181 30181 2019-10-04 2019-05-02 Fixter Ruci 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30182 30182 2019-10-04 2019-05-02 Glover Stephanie 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30183 30183 2019-10-04 2019-05-02 Just Alexander 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30184 30184 2019-10-04 2019-05-02 Leach Stuart 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30185 30185 2019-10-04 2019-05-02 Munro Malcolm 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
30605 30605 2011-10-13 2003-02-28 Levene of Portsoken 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
32357 32357 2007-10-31 2007-08-27 Roberts Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
33279 33279 1995-11-10 1994-02-09 Middleton Peter James 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
34429 34429 1996-11-30 1994-02-09 Merrett Stephen Roy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
34523 34523 2002-11-30 2001-04-16 Riley S. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
35088 35088 2018-12-01 2018-07-09 Walton Andrew 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
36630 36630 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    
38448 38448 1997-12-31 1994-02-09 Rowland John David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
38518 38518 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    
38546 38546 1998-12-31 1996-09-09 Miller Peter 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
38588 38588 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    
38617 38617 2000-12-31 1994-01-06 Duguid Andrew A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
38620 38620 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    
38633 38633 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    
38814 38814 2004-12-31 1991-11-05 Seward Robert 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
38985 38985 2007-12-31 2007-03-01 Baker Winifred A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39094 39094 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 335.961ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history