FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

39 rows where City = "London"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Termination_Date, Address_2, Registration_Date (date), Termination_Date (date)

State 1

  • - 39

City 1

  • London · 39 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
3095 1980-03-31 1982-11-26 Borken-Hagen, Connie K.   Queen's Building, Bishops Ct. Old Bailey London    
3742 1985-10-01 1991-10-25 McLoughlin, Alex G.   ICL, Bridge House - Lon 11 Putney High Street London    
3784 1986-02-28 1986-10-20 Weatherhead, T. Ian   69 Cannon Street   London    
3785 1986-10-20 1986-10-20 Browne, Terence M.   Hill House 1 Little New Street London    
3786 1986-02-28 1986-10-20 Arkell, Julian   42-46 Weymouth Street   London    
3788 1986-02-28 1986-10-20 Peel, Richard M.   10 Carteret Street Queen Anne's Gate London    
4070 1987-12-10 1992-12-31 Lord, Alan   Corporation of Lloyd's Lime Street London    
4071 1987-12-10 1992-12-22 Gaynor, John H.F.   Corporation of Lloyd's Lime Street London    
4072 1987-12-10 1994-01-06 Goddard, Kenneth S.   Corporation of Lloyd's Lime Street London    
4073 1987-12-11 1988-07-08 Miller, Peter N.   Lloyd's Lime Street London    
4187 1988-11-09 1991-12-09 Camp, Peter Mark   Corporation of Lloyd's Lime Street London    
4194 1988-12-09 1992-01-09 Lawrence, W.N. Murray   Lloyd's One Lime Street London    
4195 1988-12-09 1994-01-06 Duguid, Andrew A.   Corporation of Lloyd's One Lime Street London    
4196 1988-12-09 1992-12-31 Beckett, William C.   Corporation of Lloyd's One Lime Street London    
4205 1989-01-12 1994-02-09 Merrett, Stephen Roy   Lloyd's Lime Street London    
4374 1990-05-17 1990-11-14 Roe, Hugh R.   ICI Group Headquarters 9 Millbank, Finance Department London    
4526 1991-06-06 1994-01-06 Suterwalla, Razia   Corporation of Lloyd's Lime Street London    
4527 1991-06-05 1994-01-06 Gibson, Barry J.   Corporation of Lloyd's Lime Street London    
4572 1991-10-03 1993-04-27 Coleridge, David Ean   Lloyd's Lime Street London    
4584 1991-11-05 2006-05-31 International Group of P&I Clubs   Peek House 20 Eastcheap London    
4585 1991-11-05 1993-12-23 Youell, J. Richard L.   Lloyd's One Lime Street London    
4626 1992-03-03 1993-09-07 McConville, Sean Daniel Michael   62 Greenwich Park Street Greenwich London    
4645 1992-04-09 1993-06-09 Evans, Philip D.   English & American Group Three Quays, Tower Hill London    
4720 1992-10-13 1994-06-29 Middleton, Peter J.   Lloyd's of London One Lime Street London    
4753 1993-01-14 1995-07-31 Blake, Victor H.   CNA Internatl. Reinsurance Co. 3 Minster Court, Mincing Lane London    
4883 1994-01-06 2018-07-31 Lloyd's of London Market Representatives   One Lime Street   London    
4919 1994-06-16 1998-11-11 Rossi, Marie-Louise   London Underwriting Centre 3 Minster Crt., Mincing Lane London    
5045 1995-09-14 1995-12-31 Council of European & Japanese National Shipowners' Assn.   Carthusian Court 12 Carthusian Street London    
5062 1995-09-11 1998-09-30 Cane, Stephen Paul   Zurich Building 90 Fenchurch Street London    
5296 1999-01-12 2012-01-31 International Underwriting Association of London   3 Minister Court Mincing Lane London    
6472 2017-10-06 2020-12-31 Project Associates UK Ltd   30 Haymarket St James's London    
6473 2017-10-06 2017-10-06 SCL Social Limited   55 New Oxford Street   London    
6569 2018-07-09 2020-10-31 FTI Consulting LLP   200 Aldersgate, Aldersgate Street   London    
6675 2019-05-02 2019-10-04 Pagefield Global   5 Chancery Lane   London    
6752 2019-11-20   Halcyon Associates   Dashwood House, 69 Old Broad Street London    
6795 2020-02-24   Linklaters LLP   One Silk Street   London    
7024 2021-10-06 2022-05-06 Project Associates UK Ltd.   30 Haymarket St James's   London    
7033 2021-11-01 2022-05-31 Actum International UK Limited   91 Jermyn Street, First Floor   London    
7040 2021-11-09   Quinn Emanuel Urquhart & Sullivan UK LLP   90 High Holborn   London    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);