FARA_All_Registrants

List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

39 rows where City = "Philadelphia"

View and edit SQL

Suggested facets: Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • Philadelphia · 39
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
121 1942-09-11 1942-09-11 Braik, Douglas Gordon   C/O British Consulate General 12 South 12th Street Philadelphia PA  
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
1775 1964-07-24 1966-10-02 Dilworth, Paxson, Kalish, Kohn & Dilks   2635 Fidelity-Philadelphia Trust Building Philadelphia PA 19109
1943 1965-12-06 1966-08-02 Kenneth G. Smith & Associates, Inc.   1428 South Penn Square   Philadelphia PA 19102
2545 1974-11-04 1977-06-17 Spiro & Associates, Inc.   Chestnut East Building 841 Chestnut Street Philadelphia PA 19107
2556 1975-01-29 1978-03-27 Jamaica Tourist Board, Philadelphia   2 Penn Center Plaza Suite 1604 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
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   Bokhari, Raza   1717 Arch Street Suite 3820 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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);
Powered by Datasette · Query took 49.443ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history