FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
93 rows where City = "London"
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
Registrant_Name
- Lloyd's of London Market Representatives 37
- FTI Consulting LLP 14
- Linklaters LLP 14
- International Group of P&I Clubs 10
- Pagefield Global 5
- Project Associates UK Ltd 5
- International Underwriting Association of London 4
- Halcyon Associates 1
- McConville, Sean Daniel Michael 1
- Roe, Hugh R. 1
- SCL Social Limited 1
State
- - 93
City
- London · 93 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
340 | 340 | 2019-02-15 | Morland | Danielle | 6472 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | |||
341 | 341 | 2019-02-15 | Worthington | Rob Ian | 6472 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | |||
380 | 380 | 2020-02-24 | Bartels | Lorand | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
381 | 381 | 2020-02-24 | Brooks | Aaron | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
384 | 384 | 2020-02-24 | Coldicutt | Samuel | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
385 | 385 | 2020-02-24 | Fawke | Alexander | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
386 | 386 | 2020-02-24 | Gracia | Natura | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
387 | 387 | 2020-02-24 | Kar | Nicole | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
388 | 388 | 2020-02-24 | Lurie | Adam | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
389 | 389 | 2020-02-24 | Metcalf | Caitlin | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
390 | 390 | 2020-02-24 | Morgan | Charlotte | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
391 | 391 | 2020-02-24 | Ormerod | Imogen | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
392 | 392 | 2020-02-24 | Tridgell | Anthony | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
393 | 393 | 2020-02-24 | Weiniger | Matthew | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
860 | 860 | 2020-05-22 | Evtimov | Bogdan Venelinov | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
1554 | 1554 | 2020-09-29 | Darling Jr. | Sterling Price Adams | 6795 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | ||||
1596 | 1596 | 2017-10-06 | Rigg | David John Kilshaw | 6472 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | |||
1930 | 1930 | 2019-11-20 | Winstanley | Robert | 6752 6752 | 2019-11-20 | Halcyon Associates | 69 Old Broad Street | London | ||||
2579 | 2579 | 2006-01-01 | 1998-09-02 | Prettejohn | Nicholas | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
2865 | 2865 | 2020-01-03 | 2020-08-26 | Levi | Zac | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
5095 | 5095 | 2012-01-31 | 1999-02-24 | Matcham | David | 5296 5296 | 1999-01-12 | International Underwriting Association of London | 3 Minister Court | Mincing Lane | London | ||
5418 | 5418 | 2002-02-01 | 1996-09-09 | Barker | Jane | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
6765 | 6765 | 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 | ||
7533 | 7533 | 1995-02-28 | 1994-01-06 | Suterwalla | Razia | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
7719 | 7719 | 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 | ||
9396 | 9396 | 2000-03-15 | 1998-02-27 | Skwiertz | Albert | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
10035 | 10035 | 2007-03-23 | 2005-02-28 | Russell | David | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11096 | 11096 | 1995-03-31 | 1994-02-09 | Hall | Stephen Hargreaves | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11098 | 11098 | 1995-03-31 | 1994-02-16 | Mallinson | John Russell | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
13981 | 13981 | 1998-04-30 | 1994-06-01 | Lane | Peter William | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
14160 | 14160 | 2007-04-30 | 1998-02-27 | James | Julian | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
14354 | 14354 | 2019-04-30 | 2019-02-15 | Wild | Suzy | 6472 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | ||
14380 | 14380 | 2019-04-30 | 2017-10-06 | Loeffen-Gallagher | Ryan | 6472 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | ||
14704 | 14704 | 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 | ||
17045 | 17045 | 2006-05-31 | 1999-06-30 | Burgess | Sara | 4584 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
17059 | 17059 | 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 | ||
17060 | 17060 | 2006-05-31 | 2005-12-14 | Bardot | Andrew | 4584 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
17061 | 17061 | 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 | ||
20239 | 20239 | 1999-06-30 | 1996-09-09 | Sandler | Ronald A. | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
20764 | 20764 | 2017-06-30 | 2001-02-27 | Westcott | Rosemary Beaver | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
21806 | 21806 | 2020-07-12 | 2019-07-12 | Hawker | Jonathan | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
23708 | 23708 | 2001-07-31 | 1999-02-24 | Carroll | Tim | 5296 5296 | 1999-01-12 | International Underwriting Association of London | 3 Minister Court | Mincing Lane | London | ||
24033 | 24033 | 2018-07-31 | 2013-02-26 | Miesowitz | Sabrina Ariel | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24034 | 24034 | 2018-07-31 | 2005-02-28 | Parry | John | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24035 | 24035 | 2018-07-31 | 2018-03-02 | Carter | Misty | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24036 | 24036 | 2018-07-31 | 2018-03-02 | Claydon | Simon | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24043 | 24043 | 2018-07-31 | 1994-06-01 | Evans | Alastair MacKenzie | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24047 | 24047 | 2018-07-31 | 2000-08-17 | Gunset | Joseph P. | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24048 | 24048 | 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 | |||
24050 | 24050 | 2018-07-31 | 2016-08-30 | Grant | Tirnothy | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24051 | 24051 | 2018-07-31 | 2017-08-30 | Weaver | Hilary | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
24075 | 24075 | 2019-07-31 | 2018-07-09 | Earl | Jonathan Richard | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
26869 | 26869 | 1995-08-31 | 1994-01-06 | Gibson | Barry J. | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
27054 | 27054 | 2005-08-31 | 1999-07-07 | Havers | Chris | 4584 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
27055 | 27055 | 2005-08-31 | 2001-07-10 | James | Stephen | 4584 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
27913 | 27913 | 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 | ||
28458 | 28458 | 2005-09-15 | 2002-08-29 | Pinchin | Jeremy | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
28871 | 28871 | 2017-09-23 | 2017-10-06 | Atkinson | Matthew | 6473 6473 | 2017-10-06 | SCL Social Limited | 55 New Oxford Street | London | |||
29087 | 29087 | 2005-09-26 | 2005-02-28 | Manning | Stephen | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
29908 | 29908 | 2007-09-30 | 2001-02-27 | Tompson | Bruce Martin | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
30128 | 30128 | 2016-09-30 | 2008-02-25 | McGovern | Sean | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
30768 | 30768 | 2019-10-04 | 2019-05-02 | Fixter | Ruci | 6675 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
30769 | 30769 | 2019-10-04 | 2019-05-02 | Glover | Stephanie | 6675 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
30770 | 30770 | 2019-10-04 | 2019-05-02 | Just | Alexander | 6675 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
30771 | 30771 | 2019-10-04 | 2019-05-02 | Leach | Stuart | 6675 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
30772 | 30772 | 2019-10-04 | 2019-05-02 | Munro | Malcolm | 6675 6675 | 2019-05-02 | Pagefield Global | 5 Chancery Lane | London | |||
31204 | 31204 | 2011-10-13 | 2003-02-28 | Levene | of Portsoken | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
32989 | 32989 | 2007-10-31 | 2007-08-27 | Roberts | Martin | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
33172 | 33172 | 2020-10-31 | 2018-07-09 | Barltrop | Mitchell | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33173 | 33173 | 2020-10-31 | 2018-07-09 | Bubb | Evelyn | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33174 | 33174 | 2020-10-31 | 2018-07-09 | Fornabaio | Danielle | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33175 | 33175 | 2020-10-31 | 2018-07-09 | Lee | Hyunjung Katherine | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33176 | 33176 | 2020-10-31 | 2018-07-09 | Rai | Vadia | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33177 | 33177 | 2020-10-31 | 2018-07-09 | Toleafoa | Zaman | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33178 | 33178 | 2020-10-31 | 2019-08-26 | Cohn | Maria | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33179 | 33179 | 2020-10-31 | 2019-08-26 | Dolan | Shane | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33180 | 33180 | 2020-10-31 | 2018-12-03 | Doyle | Neil | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
33954 | 33954 | 1995-11-10 | 1994-02-09 | Middleton | Peter James | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
33991 | 33991 | 2019-11-11 | 2018-07-09 | Gajjar | Raina | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
35123 | 35123 | 1996-11-30 | 1994-02-09 | Merrett | Stephen Roy | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
35217 | 35217 | 2002-11-30 | 2001-04-16 | Riley | S. | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
35829 | 35829 | 2018-12-01 | 2018-07-09 | Walton | Andrew | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
37398 | 37398 | 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 | ||
39219 | 39219 | 1997-12-31 | 1994-02-09 | Rowland | John David | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
39289 | 39289 | 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 | |||
39317 | 39317 | 1998-12-31 | 1996-09-09 | Miller | Peter | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
39359 | 39359 | 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 | ||
39388 | 39388 | 2000-12-31 | 1994-01-06 | Duguid | Andrew A. | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
39391 | 39391 | 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 | |||
39404 | 39404 | 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 | ||
39585 | 39585 | 2004-12-31 | 1991-11-05 | Seward | Robert | 4584 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
39756 | 39756 | 2007-12-31 | 2007-03-01 | Baker | Winifred A. | 4883 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
39865 | 39865 | 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
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) );