FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where City = "Philadelphia"
This data as json, CSV (advanced)
Address_1 22
- 30 South 17th Street 2
- 100 Independence Mall West 1
- 100 Independence Mall, West 1
- 1012 City Avenue 1
- 1229 South 11th Street 1
- 1234 Market Street 1
- 125 South 9th Street 1
- 1405 Locust Street 1
- 146 North Bread Street 1
- 1525 Locust Street, 6th Floor 1
- 1648 South Orkney Street 1
- 1717 Arch Street 1
- 1735 Market Street 1
- 1760 Market Street 1
- 2531 West Girard Avenue 1
- 2600 The Fidelity Building 1
- 310 South Juniper Street 1
- 7472 Rhoads Street 1
- Eight Penn Center 1
- Goebel, Kirk & Pilato 1
- Independence Mall, West 1
- Post Office Box 13122 1
State 1
- PA 23
City 1
- Philadelphia · 23 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3188 | 1980-12-08 | 1983-07-12 | Brenner, Arthur E.K. | 1012 City Avenue | Philadelphia | PA | 91951 | ||
3276 | 1981-09-23 | 1983-02-16 | Sommers/Rosen, Inc. | 1405 Locust Street | Philadelphia | PA | 19102 | ||
3315 | 1981-12-03 | 1987-12-31 | Tayoun, Joseph John | 1229 South 11th Street | Philadelphia | PA | 19147 | ||
3358 | 1982-04-21 | 1984-10-18 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | ||
3479 | 1983-05-27 | 1986-06-27 | Goebel, Chilton G., Jr. | Goebel, Kirk & Pilato | 1845 Walnut Street | Philadelphia | PA | 19103 | |
3493 | 1983-06-29 | 1984-08-28 | Mozambican National Resistence | Post Office Box 13122 | Philadelphia | PA | 19101 | ||
4138 | 1988-05-09 | 1990-04-04 | Friedman, Steven L. | 2600 The Fidelity Building | Philadelphia | PA | 19109 | ||
4217 | 1989-02-17 | 2003-08-31 | Government of Dubai, Dept. of Tourism & Commerce Marketing | Eight Penn Center | 19th Floor, Suite 1950 | Philadelphia | PA | 19103 | |
4631 | 1992-03-13 | 1996-08-01 | Friedman, Steven L. | 1735 Market Street | Suite 3200, Mellon Bank Center | Philadelphia | PA | 19103 | |
4678 | 1992-06-02 | 1993-05-05 | Al Paul Lefton Company, Inc. | Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106 | |
4912 | 1994-05-06 | 2001-06-30 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 | |
5088 | 1995-12-15 | 1996-12-01 | McLaughlin & Morgan, Inc. | 146 North Bread Street | Philadelphia | PA | 19149 | ||
5164 | 1997-03-14 | 1997-12-01 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | ||
5336 | 1999-10-28 | 2003-01-01 | Gallagher, John J. | 1760 Market Street | Suite 1100 | Philadelphia | PA | 19103 | |
5559 | 2003-05-02 | 2008-05-16 | Rancourt, Karolyn T. | 1648 South Orkney Street | Philadelphia | PA | 19148 | ||
5614 | 2004-03-25 | 2010-08-31 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | ||
5738 | 2006-03-14 | 2006-09-30 | Centofanti, Vincent | 7472 Rhoads Street | Philadelphia | PA | 19151 | ||
5918 | 2009-03-13 | 2009-09-30 | Duane Morris Government Affairs, LLC | 30 South 17th Street | Philadelphia | PA | 19103 | ||
5998 | 2010-08-13 | 2011-08-31 | Duane Morris Government Affairs, LLC | 30 South 17th Street | Philadelphia | PA | 19103 | ||
6018 | 2011-02-15 | 2023-02-05 | Bokhari, Raza | 1717 Arch Street | 39th Floor | Philadelphia | PA | 19103 | |
6043 | 2011-05-24 | 2014-07-31 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 | |
6266 | 2014-12-19 | 2015-11-30 | Ceisler Media & Issue Advocacy, LLC | 1525 Locust Street, 6th Floor | Philadelphia | PA | 19102 | ||
7191 | 2022-11-12 | Unique Solution Advisors | 2531 West Girard Avenue | Unit 3 | Philadelphia | PA | 19130 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]) );