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

37 rows where Registration_Number = 4883

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date)

State 1

  • - 37

Registration_Number 1

  • Lloyd's of London Market Representatives · 37 ✖

City 1

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
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
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    
36805 36805 1996-11-30 1994-02-09 Merrett Stephen Roy Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
36899 36899 2002-11-30 2001-04-16 Riley S. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41007 41007 1997-12-31 1994-02-09 Rowland John David Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41077 41077 1998-12-31 1994-02-09 Youell J. Richard L. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41105 41105 1998-12-31 1996-09-09 Miller Peter Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41176 41176 2000-12-31 1994-01-06 Duguid Andrew A. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41179 41179 2000-12-31 1998-02-27 Taylor John Maxwell Percy Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41545 41545 2007-12-31 2007-03-01 Baker Winifred A. Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
41653 41653 2009-12-31 2005-02-28 Tolle Rolf Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    

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