home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_Registrants

Table actions
  • GraphQL API for 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

89 rows where State = "PA"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

City >30

  • Philadelphia 40
  • Pittsburgh 9
  • Harrisburg 3
  • Bala Cynwyd 2
  • Carlisle 2
  • Chambersburg 2
  • Huntingdon Valley 2
  • Milroy 2
  • Pittsburg 2
  • Plymouth Meeting 2
  • Wilkes-Barre 2
  • - 1
  • Coatesville 1
  • Easton 1
  • Elkins Park 1
  • Erie 1
  • Glenolden 1
  • Guys Mills 1
  • Masontown 1
  • New Hope 1
  • Newtown 1
  • Penn Valley 1
  • Phoenixville 1
  • Radnor 1
  • Reading 1
  • Spring Grove 1
  • Swiftwater 1
  • University Park 1
  • Valley Forge 1
  • Villanova 1
  • …

Address_1 >30

  • - 2
  • 1012 City Avenue 2
  • 30 South 17th Street 2
  • 716 Walnut Street 2
  • Fisher Park 2
  • 1 Asbury Avenue 1
  • 100 Independence Mall West 1
  • 100 Independence Mall, West 1
  • 101 North Front Street 1
  • 104 Cedar Glen Drive 1
  • 10661 Dingman Road 1
  • 1105 Friendship Street 1
  • 1111 Penhurst Lane 1
  • 112 Airport Road 1
  • 116 Woodland Road 1
  • 121 North Wayne Avenue 1
  • 1229 South 11th Street 1
  • 1234 Market Street 1
  • 125 South 9th Street 1
  • 1358 Jefferson Road 1
  • 1405 Locust Street 1
  • 1428 South Penn Square 1
  • 1435 Cotton Street 1
  • 146 North Bread Street 1
  • 1484 Quilters Court 1
  • 1525 Locust Street, 6th Floor 1
  • 155 North Craig Street 1
  • 15th & Chesnut Streets 1
  • 1622 Locust Street 1
  • 1641 Fifth Avenue 1
  • …

State 1

  • PA · 89 ✖
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  
1065 1957-09-10 1957-09-11 Committee for Formosans' Free Formosa   No address     PA  
1122 1958-03-10 1960-02-25 Allegheny Travel Service   Frick Building Lobby Pittsburgh PA  
1149 1958-06-11 1958-12-12 Irish Republic Army Prisoners' Dependents Fund Committee       Pittsburgh 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
1413 1960-12-06 1961-06-06 Crockford, Peter James   Route 21   Masontown PA  
1471 1961-08-11 1969-05-22 Bacskai, Bela Harsany   Post Office Box 304   Phoenixville PA  
1493 1961-11-24 1962-11-24 Oliver, Robert T.   Pennsylvania State University 305 Sparks Building University Park PA  
1711 1964-04-09 1966-12-09 Rawle & Henderson   1819 Packard Building   Philadelphia PA 19102
1732 1964-03-14 1964-05-14 Buchanan, Ingersoll, Rodewald, Kyle & Buerger   1800 Oliver Building   Pittsburg PA 15222
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
2177 1969-12-10 1970-10-08 Educational & Professional Resources, Inc.   155 North Craig Street   Pittsburg PA 15213
2386 1972-10-17 1982-12-01 Ketchum Communications Holdings, Inc.   4 Gateway Center   Pittsburgh PA 15222
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
2576 1975-04-16 1984-11-13 Chilton International Company       Radnor PA 19089
2653 1976-01-21 1991-07-22 U.S. Branch Plaid Cymru   C/O Annette J. Thomas 94 North Franklin Street #6 Wilkes-Barre PA 18701-1303
2701 1976-06-29 1976-10-08 Volz, Christofer Ashton   200 Parker Avenue   Easton PA 18042
2706 1976-07-12 1984-11-26 Alexander International Development Consultants   Post Office Box 33   Glenolden PA 19036
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
3285 1981-10-08 1984-05-23 Arau & Goldberg   121 North Wayne Avenue   Wayne PA 19087
3308 1981-11-25 1983-06-28 International Research Associates, Inc.   104 Cedar Glen Drive   New Hope PA 18938
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
3552 1984-01-23 1990-09-05 Deckmann Associates   1725 Washington Road Suite 206 Pittsburgh PA 15241
3562 1984-03-01 1984-08-15 Friedman, Pauline A. (Polly)   404 Westview Road   Elkins Park PA 19117
3739 1985-09-26 1997-09-26 NKM Associates, Inc.   550 Cleveland Avenue Post Office Box 352 Chambersburg PA 17201
3998 1987-06-22 2002-06-22 Paterra, Inc.   526 North Spring Mill Road   Villanova PA 19085-1928
4098 1988-03-09 1988-03-09 Parsells, George Marlin   101 North Front Street   Harrisburg PA 17101
4102 1984-05-23 1993-04-07 Arau Associates, Inc.   Post Office Box 990   Valley Forge PA 19482
4129 1988-04-29 1996-04-29 Connaught Laboratories, Inc.   Post Office Box 187 Route 611 Swiftwater PA 18370
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
4254 1989-05-17 1990-06-29 Ketchum Communications, Inc., Through Ketchum P.R., New York   Six PPG Place   Pittsburgh PA 152225488
4330 1990-01-12 1991-09-30 Seffu, Julius B.   1716 Glenside Drive   Harrisburg PA 17109
4360 1990-03-30 1992-09-30 Domingos, Alvaro V.   3201 North Scenic Road   Harrisburg PA 17109
4613 1992-02-03 1992-02-03 Sanyo Audio Manufacturing (U.S.A.) Corporation   Fisher Park Route 322 Milroy PA 17063
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
4724 1992-10-20 2002-10-31 Tripp, Umbach & Associates, Inc.   Fort Pitt Commons, Suite 220 445 Fort Pitt Boulevard Pittsburgh PA 15219
4725 1992-10-20 1992-10-20 Sanyo Audio Manufacturing (U.S.A.) Corporation   Fisher Park Route 322 Milroy PA 17063
4791 1993-04-08 1993-10-29 American-Chechenian Friendship & Economic Association   47 Canal Run West Washington Crossing Washington Crossing PA 18977
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
5201 1997-08-15 2009-08-31 Asia Associates, Inc.   1484 Quilters Court   Chambersburg PA 17202
5228 1998-01-15 2000-01-31 Karol Media, Inc.   375 Stewart Road Post Office Box 7600 Wilkes-Barre PA 18773-7600
5282 1998-10-23 1999-04-30 Morby, Jeffrey L.   116 Woodland Road One Oxford Centre, Suite 4260 Pittsburgh PA 15219
5336 1999-10-28 2003-01-01 Gallagher, John J.   1760 Market Street Suite 1100 Philadelphia PA 19103
5413 2001-02-26 2003-02-28 English, Otilie   305 French Street   Erie PA 16507
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
5750 2006-05-03 2008-04-30 Ferrigno, Salvatore   37 Sibelius Road   Newtown PA 18940
5757 2006-07-12 2006-07-12 MDC Zimbabwe   112 Airport Road   Coatesville PA 19320-5800
5853 2008-02-21 2013-02-28 Berardi, Amato Libero   191 Presidential Blvd. Suite 118 Bala Cynwyd PA 19004
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
6012 2010-12-23 2011-12-31 Salvatore Services, LLC   1641 Fifth Avenue   Pittsburgh PA 15219
6018 2011-02-15 2023-02-05 Bokhari, Raza   1717 Arch Street 39th Floor Philadelphia PA 19103
6019 2011-02-15 2017-08-31 All Pakistan Muslim League, LLC   1800 Byberry Road Suite 1100 Huntingdon Valley PA 19009
6043 2011-05-24 2014-07-31 AB&C Philadelphia, LLC   125 South 9th Street Suite 801 Philadelphia PA 19107
6102 2012-05-15 2012-05-15 Watkins, Joseph P.   One Belmont, Suite 400 GSB Building Bala Cynwyd PA 19004
6266 2014-12-19 2015-11-30 Ceisler Media & Issue Advocacy, LLC   1525 Locust Street, 6th Floor   Philadelphia PA 19102
6331 2015-12-18   K&L Gates, LLP   210 Sixth Avenue   Pittsburgh PA 15222
6409 2017-03-15 2017-12-18 Maia Comeau, Global Government Affairs Solutions   560 Crossroad School Road   Carlisle PA 17015
6416 2017-04-06 2017-05-31 Armstrong & Associates, LLC   10661 Dingman Road   Guys Mills PA 16327
6448 2017-07-28 2018-02-28 Audience Partners Worldwide, LLC   630 W. Germantown Pike Suite 250 Plymouth Meeting PA 19462
6540 2018-04-13   ThirdCircle, Inc.   1111 Penhurst Lane   Penn Valley PA 19702
6657 2019-04-08 2019-10-31 Audience Partners Worldwide LLC   630 W. Germantown Avenue Suite 250 Plymouth Meeting PA 19462
6666 2019-04-18 2021-03-31 Comeau & Company LLC   560 Crossroad School Road   Carlisle PA 17015
6722 2019-09-16   Sefardi Consulting   1435 Cotton Street   Reading PA 19602
6759 2019-12-02 2019-12-02 Foundation for a Christian Civilization, Inc.   1358 Jefferson Road   Spring Grove PA 17362
7191 2022-11-12   Unique Solution Advisors   2531 West Girard Avenue Unit 3 Philadelphia PA 19130
7249 2023-03-23 2023-03-23 Gary Tabach   3336 Woodland Circle   Huntingdon Valley PA 19006

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 · Queries took 73.251ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows