FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
48 rows where Address_2 = "Rohm & Haas Building" and City = "Philadelphia"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Registration_Date (date)
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
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]) );