FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where City = "Philadelphia" and Zip = 19107 sorted by Short_Form_First_Name
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Address_1, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37454 | 37454 | 1997-12-01 | 1997-03-14 | Model | Allen J. | ACM Worldwide, Ltd. 5164 | 1997-03-14 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | |
25257 | 25257 | 2014-07-31 | 2013-12-12 | Waters | D. Bruce | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
33123 | 33123 | 1984-10-18 | 1982-04-21 | Delman | David | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33125 | 33125 | 1984-10-18 | 1982-04-21 | Ferrell | David L. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
19740 | 19740 | 1977-06-17 | 1975-06-06 | Lawrence | Gordon G. | Spiro & Associates, Inc. 2545 | 1974-11-04 | Spiro & Associates, Inc. | Chestnut East Building | 841 Chestnut Street | Philadelphia | PA | 19107 |
25234 | 25234 | 2014-07-31 | 2013-06-20 | Talbot | James B. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25220 | 25220 | 2014-07-31 | 2011-05-24 | Orr | John H. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
33126 | 33126 | 1984-10-18 | 1982-04-21 | Mugler | Kenneth S. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33124 | 33124 | 1984-10-18 | 1982-04-21 | Feinstein | Laurence Robert | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
16841 | 16841 | 2014-05-21 | 2013-12-12 | Brandsdorfer | Louis | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
33127 | 33127 | 1984-10-18 | 1982-04-21 | Rector | Marion C. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
19741 | 19741 | 1977-06-17 | 1974-11-04 | Sherman | Martin | Spiro & Associates, Inc. 2545 | 1974-11-04 | Spiro & Associates, Inc. | Chestnut East Building | 841 Chestnut Street | Philadelphia | PA | 19107 |
33128 | 33128 | 1984-10-18 | 1982-04-21 | Senker | Patricia A. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
37452 | 37452 | 1997-12-01 | 1997-03-14 | Arsenault | Robert L. | ACM Worldwide, Ltd. 5164 | 1997-03-14 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | |
25233 | 25233 | 2014-07-31 | 2013-06-20 | Foster | Stephanie A. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
17522 | 17522 | 2014-05-30 | 2013-06-20 | Yarrow | Steven | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
37453 | 37453 | 1997-12-01 | 1997-03-14 | Cades | Stewart R. | ACM Worldwide, Ltd. 5164 | 1997-03-14 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | |
19946 | 19946 | 2014-06-20 | 2013-12-12 | Gentieu | Valerie | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
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]) );