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_2, Short_Form_Termination_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    
2118 2118   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    
2119 2119   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    
2195 2195   2019-11-20 Winstanley Robert Halcyon Associates 6752 2019-11-20 Halcyon Associates Dashwood House, 69 Old Broad Street London    
2831 2831 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    
3130 3130 2020-01-03 2020-08-26 Levi Zac FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
4283 4283 2021-01-22 2020-05-22 Evtimov Bogdan Venelinov Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
4714 4714 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    
5448 5448 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    
5799 5799 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    
6740 6740 2023-02-13 2020-02-24 Bartels Lorand Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6741 6741 2023-02-13 2020-02-24 Coldicutt Samuel Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6742 6742 2023-02-13 2020-02-24 Fawke Alexander Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6743 6743 2023-02-13 2020-02-24 Gracia Natura Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6744 6744 2023-02-13 2020-02-24 Kar Nicole Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6745 6745 2023-02-13 2020-02-24 Lurie Adam Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6746 6746 2023-02-13 2020-02-24 Metcalf Caitlin Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6747 6747 2023-02-13 2020-02-24 Morgan Charlotte Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6748 6748 2023-02-13 2020-02-24 Ormerod Imogen Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6749 6749 2023-02-13 2020-02-24 Weiniger Matthew Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
6752 6752 2023-02-13 2020-09-29 Darling Jr. Sterling Price Adams Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
7212 7212 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    
7997 7997 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    
8183 8183 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    
8397 8397 2021-02-28 2020-02-24 Brooks Aaron Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
8398 8398 2021-02-28 2020-02-24 Tridgell Anthony Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
9969 9969 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    
10009 10009 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    
10620 10620 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    
11697 11697 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    
11699 11699 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    
14755 14755 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    
14934 14934 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    
15129 15129 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    
15130 15130 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    
15157 15157 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    
15578 15578 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    
15814 15814 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    
15815 15815 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    
15816 15816 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    
15817 15817 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    
17237 17237 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    
17991 17991 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    
18005 18005 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    
18006 18006 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    
18007 18007 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    
18243 18243 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    
18244 18244 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    
18245 18245 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    
18246 18246 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    
18247 18247 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    
18248 18248 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    
18249 18249 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    
18250 18250 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    
18251 18251 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    
18252 18252 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    
18253 18253 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    
18254 18254 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    
18257 18257 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    
21322 21322 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    
21851 21851 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    
23013 23013 2020-07-12 2019-07-12 Hawker Jonathan FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
24966 24966 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    
25291 25291 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    
25292 25292 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    
25293 25293 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    
25294 25294 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    
25301 25301 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    
25305 25305 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    
25306 25306 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    
25308 25308 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    
25309 25309 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    
25334 25334 2019-07-31 2018-07-09 Earl Jonathan Richard FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
28235 28235 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    
28420 28420 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    
28421 28421 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    
29311 29311 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    
29871 29871 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    
30304 30304 2017-09-23 2017-10-06 Atkinson Matthew SCL Social Limited 6473 2017-10-06 SCL Social Limited 55 New Oxford Street   London    
30524 30524 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    
31349 31349 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    
31568 31568 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    
32267 32267 2019-10-04 2019-05-02 Fixter Ruci Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
32268 32268 2019-10-04 2019-05-02 Glover Stephanie Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
32269 32269 2019-10-04 2019-05-02 Just Alexander Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
32270 32270 2019-10-04 2019-05-02 Leach Stuart Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
32271 32271 2019-10-04 2019-05-02 Munro Malcolm Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
32728 32728 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    
34545 34545 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    
34728 34728 2020-10-31 2018-07-09 Barltrop Mitchell FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34729 34729 2020-10-31 2018-07-09 Bubb Evelyn FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34730 34730 2020-10-31 2018-07-09 Fornabaio Danielle FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34731 34731 2020-10-31 2018-07-09 Lee Hyunjung Katherine FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34732 34732 2020-10-31 2018-07-09 Rai Vadia FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34733 34733 2020-10-31 2018-07-09 Toleafoa Zaman FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34734 34734 2020-10-31 2019-08-26 Cohn Maria FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34735 34735 2020-10-31 2019-08-26 Dolan Shane FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34736 34736 2020-10-31 2018-12-03 Doyle Neil FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
35570 35570 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])
);