FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Address_2 = "" and City = "Philadelphia"
This data as json, CSV (advanced)
Suggested facets: Name, Business_Name, Zip, Registration_Date (date), Termination_Date (date)
Address_1 24
- 1012 City Avenue 2
- 30 South 17th Street 2
- 716 Walnut Street 2
- 1 Asbury Avenue 1
- 100 Independence Mall West 1
- 1105 Friendship Street 1
- 1229 South 11th Street 1
- 1234 Market Street 1
- 1405 Locust Street 1
- 1428 South Penn Square 1
- 146 North Bread Street 1
- 1525 Locust Street, 6th Floor 1
- 15th & Chesnut Streets 1
- 1622 Locust Street 1
- 1648 South Orkney Street 1
- 1819 John F. Kennedy Boulevard 1
- 1819 Packard Building 1
- 2600 The Fidelity Building 1
- 2714 East Allegheny Avenue 1
- 3 Parkway 1
- 310 South Juniper Street 1
- 40 South 19th Street 1
- 7472 Rhoads Street 1
- Post Office Box 13122 1
State 1
- PA 27
City 1
- Philadelphia · 27 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
423 | 1947-01-10 | 1947-12-31 | Pennsylvania Company for Banking & Trusts | 15th & Chesnut Streets | Philadelphia | PA | |||
462 | 1947-05-21 | 1952-12-31 | Alexander, Raymond Pace | 40 South 19th Street | Philadelphia | PA | |||
512 | 1948-02-16 | 1960-03-23 | Globe Travel Service | 716 Walnut Street | Philadelphia | PA | |||
910 | 1955-09-14 | 1959-09-14 | Friedmann, Eric | 1 Asbury Avenue | Philadelphia | PA | |||
1164 | 1958-08-25 | 1988-06-21 | Globe Parcel Service, Inc. | 716 Walnut Street | Philadelphia | PA | 19106 | ||
1262 | 1959-08-28 | 1960-02-25 | Polish-American Travel Service | 2714 East Allegheny Avenue | Philadelphia | PA | |||
1304 | 1959-12-07 | 1967-01-04 | Friedmann Radio Broadcasting & Advertising Company | 1105 Friendship Street | Philadelphia | PA | 19111 | ||
1711 | 1964-04-09 | 1966-12-09 | Rawle & Henderson | 1819 Packard Building | Philadelphia | PA | 19102 | ||
1943 | 1965-12-06 | 1966-08-02 | Kenneth G. Smith & Associates, Inc. | 1428 South Penn Square | Philadelphia | PA | 19102 | ||
2709 | 1976-07-17 | 1976-06-01 | Public Relations, Ltd. | 3 Parkway | Philadelphia | PA | 19102 | ||
2925 | 1978-07-06 | 1983-01-05 | Compton Advertising, Inc. | Thelma Gray/Compton Public Relations | 1819 John F. Kennedy Boulevard | Philadelphia | PA | 19103 | |
3009 | 1979-03-30 | 1981-03-09 | David Berger, P.A. | 1622 Locust Street | Philadelphia | PA | 19103 | ||
3018 | 1979-05-10 | 1980-11-11 | Brenner, Gertrude B. | 1012 City Avenue | Philadelphia | PA | 19151 | ||
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 | ||
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 | ||
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 | ||
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 | ||
6266 | 2014-12-19 | 2015-11-30 | Ceisler Media & Issue Advocacy, LLC | 1525 Locust Street, 6th Floor | Philadelphia | PA | 19102 |
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]) );