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

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

State 1

  • - 119

City 1

  • London · 119 ✖
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
1341 1341   2023-06-30 Le Miere Lucienne Anne Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
1342 1342   2023-06-30 Nelder Alexander Joseph Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
2127 2127   2021-11-09 Gerbi Alexander Joseph Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
2128 2128   2021-11-09 Menezes Jagdish John Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
2204 2204   2019-11-20 Winstanley Robert Halcyon Associates 6752 2019-11-20 Halcyon Associates Dashwood House, 69 Old Broad Street London    
2839 2839 2006-01-01 1998-09-02 Prettejohn Nicholas Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
3142 3142 2020-01-03 2020-08-26 Levi Zac FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
4295 4295 2021-01-22 2020-05-22 Evtimov Bogdan Venelinov Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
4726 4726 2022-01-28 2021-11-02 Tucker George Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
5460 5460 2012-01-31 1999-02-24 Matcham David International Underwriting Association of London 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
5812 5812 2002-02-01 1996-09-09 Barker Jane Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
6753 6753 2023-02-13 2020-02-24 Bartels Lorand Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6754 6754 2023-02-13 2020-02-24 Coldicutt Samuel Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6755 6755 2023-02-13 2020-02-24 Fawke Alexander Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6756 6756 2023-02-13 2020-02-24 Gracia Natura Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6757 6757 2023-02-13 2020-02-24 Kar Nicole Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6758 6758 2023-02-13 2020-02-24 Lurie Adam Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6759 6759 2023-02-13 2020-02-24 Metcalf Caitlin Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6760 6760 2023-02-13 2020-02-24 Morgan Charlotte Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6761 6761 2023-02-13 2020-02-24 Ormerod Imogen Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6762 6762 2023-02-13 2020-02-24 Weiniger Matthew Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6765 6765 2023-02-13 2020-09-29 Darling Jr. Sterling Price Adams Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
7225 7225 2005-02-18 1999-01-12 Rossi Marie-Louise International Underwriting Association of London 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
8010 8010 1995-02-28 1994-01-06 Suterwalla Razia Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
8196 8196 2006-02-28 1999-02-24 Cane Stephen P. International Underwriting Association of London 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
8410 8410 2021-02-28 2020-02-24 Brooks Aaron Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
8411 8411 2021-02-28 2020-02-24 Tridgell Anthony Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
9982 9982 2000-03-15 1998-02-27 Skwiertz Albert Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
10022 10022 2023-03-15 2021-11-09 Squires Jerome Alexander Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
10633 10633 2007-03-23 2005-02-28 Russell David Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11710 11710 1995-03-31 1994-02-09 Hall Stephen Hargreaves Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
11712 11712 1995-03-31 1994-02-16 Mallinson John Russell Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14770 14770 1998-04-30 1994-06-01 Lane Peter William Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
14949 14949 2007-04-30 1998-02-27 James Julian Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
15144 15144 2019-04-30 2019-02-15 Morland Danielle Project Associates UK Ltd 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
15145 15145 2019-04-30 2019-02-15 Wild Suzy Project Associates UK Ltd 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
15172 15172 2019-04-30 2017-10-06 Loeffen-Gallagher Ryan Project Associates UK Ltd 6472 2017-10-06 Project Associates UK Ltd 30 Haymarket St James's London    
15594 15594 1990-05-02 1990-05-07 Bissell Robert Bruce Roe, Hugh R. 4374 1990-05-17 Roe, Hugh R. ICI Group Headquarters 9 Millbank, Finance Department London    
15831 15831 2022-05-06 2022-05-30 Barbier-Fendt Jean Project Associates UK Ltd. 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
15832 15832 2022-05-06 2021-10-06 Graham-Brown Hannah Project Associates UK Ltd. 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
15833 15833 2022-05-06 2021-10-06 Vimont Pietro Project Associates UK Ltd. 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
15834 15834 2022-05-06 2021-10-06 Worthington Robert Ian Project Associates UK Ltd. 7024 2021-10-06 Project Associates UK Ltd. 30 Haymarket St James's   London    
17254 17254 2022-05-27 2021-11-01 Gregory Katie Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18008 18008 2006-05-31 1999-06-30 Burgess Sara International Group of P&I Clubs 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
18022 18022 2006-05-31 1991-11-05 Watkins D.J.L. International Group of P&I Clubs 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
18023 18023 2006-05-31 2005-12-14 Bardot Andrew International Group of P&I Clubs 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
18024 18024 2006-05-31 2005-12-14 Groom Alistair John International Group of P&I Clubs 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
18260 18260 2022-05-31 2021-11-01 Baker Zara Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18261 18261 2022-05-31 2021-11-01 Birnbaum George Eli Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18262 18262 2022-05-31 2021-11-01 Collier Benjamin Britworth Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18263 18263 2022-05-31 2021-11-01 Denselow Toby Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18264 18264 2022-05-31 2021-11-01 Galan Vladislava Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18265 18265 2022-05-31 2021-11-01 Hassan Miran Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18266 18266 2022-05-31 2021-11-01 McMillan Thomas Jock Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18267 18267 2022-05-31 2021-11-01 Ogborn William Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18268 18268 2022-05-31 2021-11-01 Reid Morris Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18269 18269 2022-05-31 2021-11-01 Toomey Molly Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18270 18270 2022-05-31 2021-11-01 Walker Alexander Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18271 18271 2022-05-31 2021-11-02 Walker Alexander DJ Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
18274 18274 2022-05-31 2021-12-14 Fabian Olamide Noah Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
21340 21340 1999-06-30 1996-09-09 Sandler Ronald A. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
21869 21869 2017-06-30 2001-02-27 Westcott Rosemary Beaver Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
23034 23034 2020-07-12 2019-07-12 Hawker Jonathan FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
24988 24988 2001-07-31 1999-02-24 Carroll Tim International Underwriting Association of London 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
25313 25313 2018-07-31 2013-02-26 Miesowitz Sabrina Ariel Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25314 25314 2018-07-31 2005-02-28 Parry John Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25315 25315 2018-07-31 2018-03-02 Carter Misty Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25316 25316 2018-07-31 2018-03-02 Claydon Simon Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25323 25323 2018-07-31 1994-06-01 Evans Alastair MacKenzie Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25327 25327 2018-07-31 2000-08-17 Gunset Joseph P. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25328 25328 2018-07-31 2002-08-19 Walmsley James Stuart Mainprize Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25330 25330 2018-07-31 2016-08-30 Grant Tirnothy Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25331 25331 2018-07-31 2017-08-30 Weaver Hilary Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
25356 25356 2019-07-31 2018-07-09 Earl Jonathan Richard FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
28257 28257 1995-08-31 1994-01-06 Gibson Barry J. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
28442 28442 2005-08-31 1999-07-07 Havers Chris International Group of P&I Clubs 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
28443 28443 2005-08-31 2001-07-10 James Stephen International Group of P&I Clubs 4584 1991-11-05 International Group of P&I Clubs Peek House 20 Eastcheap London    
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    

Next page

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