FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

97 rows where City = "London"

✎ View and edit SQL

This data as json, 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

  • - 97

City

  • London · 97 ✖
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
350 350   2020-02-24 Bartels Lorand 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
353 353   2020-02-24 Coldicutt Samuel 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
354 354   2020-02-24 Fawke Alexander 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
355 355   2020-02-24 Gracia Natura 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
356 356   2020-02-24 Kar Nicole 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
357 357   2020-02-24 Lurie Adam 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
358 358   2020-02-24 Metcalf Caitlin 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
359 359   2020-02-24 Morgan Charlotte 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
360 360   2020-02-24 Ormerod Imogen 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
361 361   2020-02-24 Weiniger Matthew 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1757 1757   2020-09-29 Darling Jr. Sterling Price Adams 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1813 1813   2021-10-06 Graham-Brown Hannah 7024 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
1814 1814   2021-10-06 Roubi Matthieu 7024 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
1815 1815   2021-10-06 Vimont Pietro 7024 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
1816 1816   2021-10-06 Worthington Robert Ian 7024 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
2110 2110   2019-11-20 Winstanley Robert 6752 6752 2019-11-20 Halcyon Associates 69 Old Broad Street   London    
2713 2713 2006-01-01 1998-09-02 Prettejohn Nicholas 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
3004 3004 2020-01-03 2020-08-26 Levi Zac 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
4095 4095 2021-01-22 2020-05-22 Evtimov Bogdan Venelinov 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
5247 5247 2012-01-31 1999-02-24 Matcham David 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
5582 5582 2002-02-01 1996-09-09 Barker Jane 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
6956 6956 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    
7728 7728 1995-02-28 1994-01-06 Suterwalla Razia 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
7914 7914 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    
8128 8128 2021-02-28 2020-02-24 Brooks Aaron 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
8129 8129 2021-02-28 2020-02-24 Tridgell Anthony 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
9621 9621 2000-03-15 1998-02-27 Skwiertz Albert 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
10266 10266 2007-03-23 2005-02-28 Russell David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11334 11334 1995-03-31 1994-02-09 Hall Stephen Hargreaves 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11336 11336 1995-03-31 1994-02-16 Mallinson John Russell 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14281 14281 1998-04-30 1994-06-01 Lane Peter William 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14460 14460 2007-04-30 1998-02-27 James Julian 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14654 14654 2019-04-30 2019-02-15 Morland Danielle 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14655 14655 2019-04-30 2019-02-15 Wild Suzy 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
14681 14681 2019-04-30 2017-10-06 Loeffen-Gallagher Ryan 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
15042 15042 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    
17401 17401 2006-05-31 1999-06-30 Burgess Sara 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17415 17415 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    
17416 17416 2006-05-31 2005-12-14 Bardot Andrew 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
17417 17417 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    
20629 20629 1999-06-30 1996-09-09 Sandler Ronald A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
21157 21157 2017-06-30 2001-02-27 Westcott Rosemary Beaver 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
22226 22226 2020-07-12 2019-07-12 Hawker Jonathan 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
24130 24130 2001-07-31 1999-02-24 Carroll Tim 5296 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
24455 24455 2018-07-31 2013-02-26 Miesowitz Sabrina Ariel 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24456 24456 2018-07-31 2005-02-28 Parry John 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24457 24457 2018-07-31 2018-03-02 Carter Misty 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24458 24458 2018-07-31 2018-03-02 Claydon Simon 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24465 24465 2018-07-31 1994-06-01 Evans Alastair MacKenzie 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24469 24469 2018-07-31 2000-08-17 Gunset Joseph P. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24470 24470 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    
24472 24472 2018-07-31 2016-08-30 Grant Tirnothy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24473 24473 2018-07-31 2017-08-30 Weaver Hilary 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
24498 24498 2019-07-31 2018-07-09 Earl Jonathan Richard 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
27300 27300 1995-08-31 1994-01-06 Gibson Barry J. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
27485 27485 2005-08-31 1999-07-07 Havers Chris 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
27486 27486 2005-08-31 2001-07-10 James Stephen 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
28358 28358 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    
28905 28905 2005-09-15 2002-08-29 Pinchin Jeremy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
29318 29318 2017-09-23 2017-10-06 Atkinson Matthew 6473 6473 2017-10-06 SCL Social Limited 55 New Oxford Street   London    
29535 29535 2005-09-26 2005-02-28 Manning Stephen 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
30358 30358 2007-09-30 2001-02-27 Tompson Bruce Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
30578 30578 2016-09-30 2008-02-25 McGovern Sean 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
31229 31229 2019-10-04 2019-05-02 Fixter Ruci 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31230 31230 2019-10-04 2019-05-02 Glover Stephanie 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31231 31231 2019-10-04 2019-05-02 Just Alexander 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31232 31232 2019-10-04 2019-05-02 Leach Stuart 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31233 31233 2019-10-04 2019-05-02 Munro Malcolm 6675 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31662 31662 2011-10-13 2003-02-28 Levene of Portsoken 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
33454 33454 2007-10-31 2007-08-27 Roberts Martin 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
33637 33637 2020-10-31 2018-07-09 Barltrop Mitchell 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33638 33638 2020-10-31 2018-07-09 Bubb Evelyn 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33639 33639 2020-10-31 2018-07-09 Fornabaio Danielle 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33640 33640 2020-10-31 2018-07-09 Lee Hyunjung Katherine 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33641 33641 2020-10-31 2018-07-09 Rai Vadia 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33642 33642 2020-10-31 2018-07-09 Toleafoa Zaman 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33643 33643 2020-10-31 2019-08-26 Cohn Maria 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33644 33644 2020-10-31 2019-08-26 Dolan Shane 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
33645 33645 2020-10-31 2018-12-03 Doyle Neil 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34426 34426 1995-11-10 1994-02-09 Middleton Peter James 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
34463 34463 2019-11-11 2018-07-09 Gajjar Raina 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
35599 35599 1996-11-30 1994-02-09 Merrett Stephen Roy 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
35693 35693 2002-11-30 2001-04-16 Riley S. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
36306 36306 2018-12-01 2018-07-09 Walton Andrew 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
37881 37881 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    
39704 39704 1997-12-31 1994-02-09 Rowland John David 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39774 39774 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    
39802 39802 1998-12-31 1996-09-09 Miller Peter 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39844 39844 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    
39873 39873 2000-12-31 1994-01-06 Duguid Andrew A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
39876 39876 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    
39889 39889 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    
40071 40071 2004-12-31 1991-11-05 Seward Robert 4584 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
40242 40242 2007-12-31 2007-03-01 Baker Winifred A. 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
40351 40351 2009-12-31 2005-02-28 Tolle Rolf 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41005 41005 2020-12-31 2019-02-15 Worthington Rob Ian 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
41039 41039 2020-12-31 2017-10-06 Rigg David John Kilshaw 6472 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's 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])
);