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

48 rows where Registration_Number = 4912

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Date (date)

State 1

Registration_Number 1

  • Al Paul Lefton Company, Inc. · 48 ✖

Registrant_Name 1

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
3808 3808 1999-01-15 1996-07-01 Milano Karen J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
7476 7476 1995-02-23 1994-05-06 Helfrich Jacqueline Anne Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
7726 7726 1999-02-26 1997-01-16 Horan Michael F. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
8806 8806 1996-03-01 1995-06-19 Ryan M. Martha Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
8975 8975 2000-03-02 1997-07-11 Butler R. Mark Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
9250 9250 1998-03-06 1994-12-22 Zartarian Stephen K. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
10527 10527 2001-03-22 2000-12-18 Myers Laurence Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
10703 10703 2000-03-24 1997-07-07 Finamore Andrea J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
14810 14810 1999-04-30 1995-06-19 Cohen Barry Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
15760 15760 1995-05-05 1994-05-06 Vittolino Salvatore P. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
19691 19691 2000-06-16 1999-06-29 Dzwill Eileen Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
19818 19818 1999-06-18 1994-12-22 Vaughan-Gowen Deborah Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21362 21362 2000-06-30 1999-06-29 Masse Jennifer J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21375 21375 2001-06-30 1996-01-02 Cintron Ana M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21376 21376 2001-06-30 2000-01-10 Spratlin Jon Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21377 21377 2001-06-30 1997-01-16 Placido Peter A. , Jr. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21384 21384 2001-06-30 1994-05-06 Brandsdorfer Louis Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21385 21385 2001-06-30 1994-05-06 Evans John M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21386 21386 2001-06-30 1994-05-06 Hennessy Brian J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21387 21387 2001-06-30 1994-05-06 Kneisel William J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21388 21388 2001-06-30 1994-05-06 Lefton Al Paul , Jr. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21389 21389 2001-06-30 1994-05-06 Nunez Nurisell Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21390 21390 2001-06-30 1994-05-06 Orr John H. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21391 21391 2001-06-30 1994-05-06 Peretz Michael Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21392 21392 2001-06-30 1994-05-06 Russakoff Claire C. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21393 21393 2001-06-30 1994-05-06 Scanlon Raymond D. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21394 21394 2001-06-30 1994-05-06 Sharkey Darlene M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21395 21395 2001-06-30 1994-05-06 Spross Theresa Marie Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21396 21396 2001-06-30 1994-05-06 Waters David Bruce Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21397 21397 2001-06-30 1994-05-06 Yarrow Steven E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21400 21400 2001-06-30 2001-06-12 Fong Mary Ann Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21401 21401 2001-06-30 1995-06-19 Talbot James E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21420 21420 2001-06-30 1998-12-21 Ditton Jill Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
23936 23936 1999-07-23 1997-01-16 Michaud Anne E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
27592 27592 1996-08-28 1995-06-19 LaBranche Angelique Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
28379 28379 2001-08-31 1997-01-16 Buckman Judith G. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
28391 28391 2001-08-31 2001-06-12 Rossi Richard A. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
28392 28392 2001-08-31 2000-06-21 Smith J. Gregory Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
29357 29357 2001-09-07 1994-05-06 Costomiris D. Lynn Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
29887 29887 1999-09-15 1998-06-26 Brightman Ellen Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
31139 31139 1996-09-30 1994-05-06 Kilkenny Kathleen Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
32265 32265 1995-10-04 1994-05-06 Perkins Thomas F. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
33980 33980 1999-10-29 1998-06-26 Sanders Christine Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
34395 34395 1997-10-31 1995-06-19 Pickford Lorraine V. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
35561 35561 1995-11-09 1994-05-06 Magee Marjorie Moll Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
35562 35562 2001-11-09 2000-01-10 Ryan M. Martha Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
36564 36564 1999-11-29 1998-12-21 Haller Wendy Ann Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
37615 37615 1994-12-02 1994-05-06 Grasso Amanda Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399

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