home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

117 rows where City = "London"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 14

  • Lloyd's of London Market Representatives 37
  • Actum International UK Limited 16
  • FTI Consulting LLP 14
  • Linklaters LLP 14
  • International Group of P&I Clubs 10
  • Project Associates UK Ltd 5
  • Pagefield Global 5
  • Project Associates UK Ltd. 5
  • International Underwriting Association of London 4
  • Quinn Emanuel Urquhart & Sullivan UK LLP 3
  • Roe, Hugh R. 1
  • McConville, Sean Daniel Michael 1
  • SCL Social Limited 1
  • Halcyon Associates 1

Registrant_Name 14

  • Lloyd's of London Market Representatives 37
  • Actum International UK Limited 16
  • FTI Consulting LLP 14
  • Linklaters LLP 14
  • International Group of P&I Clubs 10
  • Pagefield Global 5
  • Project Associates UK Ltd 5
  • Project Associates UK Ltd. 5
  • International Underwriting Association of London 4
  • Quinn Emanuel Urquhart & Sullivan UK LLP 3
  • Halcyon Associates 1
  • McConville, Sean Daniel Michael 1
  • Roe, Hugh R. 1
  • SCL Social Limited 1

State 1

  • - 117

City 1

  • London · 117 ✖
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
380 380   2020-02-24 Bartels Lorand Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
382 382   2020-02-24 Coldicutt Samuel Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
383 383   2020-02-24 Fawke Alexander Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
384 384   2020-02-24 Gracia Natura Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
385 385   2020-02-24 Kar Nicole Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
386 386   2020-02-24 Lurie Adam Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
387 387   2020-02-24 Metcalf Caitlin Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
388 388   2020-02-24 Morgan Charlotte Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
389 389   2020-02-24 Ormerod Imogen Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
390 390   2020-02-24 Weiniger Matthew Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1808 1808   2020-09-29 Darling Jr. Sterling Price Adams Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
2007 2007   2021-11-01 Baker Zara Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2008 2008   2021-11-01 Birnbaum George Eli Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2009 2009   2021-11-01 Collier Benjamin Britworth Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2010 2010   2021-11-01 Denselow Toby Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2011 2011   2021-11-01 Galan Vladislava Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2012 2012   2021-11-01 Hassan Miran Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2013 2013   2021-11-01 McMillan Thomas Jock Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2014 2014   2021-11-01 Ogborn William Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2015 2015   2021-11-01 Reid Morris Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2016 2016   2021-11-01 Toomey Molly Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2017 2017   2021-11-01 Walker Alexander Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2035 2035   2021-11-02 Walker Alexander DJ Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2060 2060   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    
2061 2061   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    
2063 2063   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    
2134 2134   2019-11-20 Winstanley Robert Halcyon Associates 6752 2019-11-20 Halcyon Associates Dashwood House, 69 Old Broad Street London    
2330 2330   2021-12-14 Fabian Olamide Noah Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
2757 2757 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    
3051 3051 2020-01-03 2020-08-26 Levi Zac FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
4164 4164 2021-01-22 2020-05-22 Evtimov Bogdan Venelinov Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
4585 4585 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    
5319 5319 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    
5662 5662 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    
7049 7049 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    
7828 7828 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    
8014 8014 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    
8229 8229 2021-02-28 2020-02-24 Brooks Aaron Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
8230 8230 2021-02-28 2020-02-24 Tridgell Anthony Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
9758 9758 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    
10405 10405 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    
11475 11475 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    
11477 11477 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    
14461 14461 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    
14640 14640 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    
14835 14835 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    
14836 14836 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    
14863 14863 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    
15257 15257 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    
15491 15491 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    
15492 15492 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    
15493 15493 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    
15494 15494 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    
16897 16897 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    
17648 17648 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    
17662 17662 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    
17663 17663 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    
17664 17664 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    
20927 20927 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    
21457 21457 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    
22588 22588 2020-07-12 2019-07-12 Hawker Jonathan FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
24506 24506 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    
24831 24831 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    
24832 24832 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    
24833 24833 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    
24834 24834 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    
24841 24841 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    
24845 24845 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    
24846 24846 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    
24848 24848 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    
24849 24849 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    
24874 24874 2019-07-31 2018-07-09 Earl Jonathan Richard FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
27711 27711 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    
27896 27896 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    
27897 27897 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    
28779 28779 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    
29326 29326 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    
29749 29749 2017-09-23 2017-10-06 Atkinson Matthew SCL Social Limited 6473 2017-10-06 SCL Social Limited 55 New Oxford Street   London    
29968 29968 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    
30792 30792 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    
31011 31011 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    
31679 31679 2019-10-04 2019-05-02 Fixter Ruci Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31680 31680 2019-10-04 2019-05-02 Glover Stephanie Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31681 31681 2019-10-04 2019-05-02 Just Alexander Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31682 31682 2019-10-04 2019-05-02 Leach Stuart Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
31683 31683 2019-10-04 2019-05-02 Munro Malcolm Pagefield Global 6675 2019-05-02 Pagefield Global 5 Chancery Lane   London    
32122 32122 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    
33928 33928 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    
34111 34111 2020-10-31 2018-07-09 Barltrop Mitchell FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34112 34112 2020-10-31 2018-07-09 Bubb Evelyn FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34113 34113 2020-10-31 2018-07-09 Fornabaio Danielle FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34114 34114 2020-10-31 2018-07-09 Lee Hyunjung Katherine FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34115 34115 2020-10-31 2018-07-09 Rai Vadia FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34116 34116 2020-10-31 2018-07-09 Toleafoa Zaman FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34117 34117 2020-10-31 2019-08-26 Cohn Maria FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34118 34118 2020-10-31 2019-08-26 Dolan Shane FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34119 34119 2020-10-31 2018-12-03 Doyle Neil FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
34936 34936 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    
34980 34980 2019-11-11 2018-07-09 Gajjar Raina FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
35797 35797 2021-11-26 2021-11-01 Sculthorpe Timothy Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   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])
);
Powered by Datasette · Queries took 624.968ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history