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

48 rows where City = "Boston"

View and edit SQL

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

State

City

  • Boston · 48
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
32 1942-07-24 1946-12-07 Syrian National Party in the U.S.   216 Harrison Avenue   Boston MA  
112 1942-08-20 1943-02-20 Ghiloni, Alfred R.   7 Park Square   Boston MA  
113 1942-08-20 1943-02-20 Ghiloni, Alfred R.   7 Park Square   Boston MA  
114 1942-08-20 1942-08-20 Ghiloni, Alfred R.   7 Park Square   Boston MA  
408 1946-12-12 1947-05-15 Frary, William   233 Marlborough Street   Boston MA  
507 1948-01-09 1949-01-09 Mysore Company   75 Federal Street   Boston MA  
864 1955-01-04 1956-07-01 Margold, Stella K.   345 Commonwealth Avenue   Boston MA  
1271 1959-09-17 1960-03-17 National Travel Company, Inc.   90 State Street   Boston MA  
1347 1960-03-29 1960-06-09 Bernstone, Lawrence Jesse   11 Beacon Street   Boston MA  
1353 1960-04-06 1963-10-14 Mahfuz, Husney A.   667 Boylston Street   Boston MA  
1588 1963-01-04 1964-04-30 Portuguese-American Committee on Foreign Affairs   20 Pemberton Square Suite 909 Boston MA  
2466 1973-10-12 1976-08-03 Culver International, Inc.   535 Boylston Street   Boston MA 02116
2704 1976-07-01 1978-01-02 Masterman, Edward I.   225 Franklin Street   Boston MA 02110
2841 1977-11-01 1981-06-16 Widett, Slater & Goldman, P.C.   60 State Street   Boston MA 02109
2914 1978-06-12 1989-02-16 Gadsby & Hannah   1 Post Office Square   Boston MA 02109
3013 1979-04-17   Scottish Enterprise Scottish Develoment International and SCTR, Limited 50 Milk Street 14th Floor Boston MA 02109
3119 1980-07-02 1985-12-31 Ingalls Associates, Inc.   2 Copley Place   Boston MA 02116
3189 1981-01-09 1985-02-25 Newsome & Company, Inc.   225 Franklin Street   Boston MA 02110
3298 1981-10-28 1986-06-17 Robert A. Weaver, Jr. & Associates, Inc.   Pilot House at Lewis Wharf   Boston MA 02110
3314 1981-12-03 1982-11-26 Publicity, Inc.   390 Commonwealth Avenue   Boston MA 02215
3549 1984-01-19 1998-05-21 Britt, Raymond L., Jr.   45 Milk Street   Boston MA 02109
3810 1986-04-10 1992-04-10 Hill, Holliday, Connors, Cosmopulos, Inc.   200 Clarendon Street   Boston MA 02116
3848 1986-06-25 1987-05-08 Linet, Paul E.   1 Devonshire Place Suite 1002 Boston MA 02109
3934 1987-02-05 1989-08-21 Cone Communications   90 Canal Street   Boston MA 02114
4019 1987-08-03 1994-12-24 J.R. Bechtle & Company   185 Devonshire Street Suite 350 Boston MA 02110
4074 1987-12-11 1994-09-12 Clarke & Company, Inc.   535 Boylston Street   Boston MA 02135
4123 1988-04-20 1993-10-20 ClarkeGowardFittsMatteson, Inc.   535 Boylston Street   Boston MA 02116
4431 1990-08-07 1995-04-30 Harron & Associates   229 Berkeley Street   Boston MA 02116
4505 1991-04-25 1995-09-11 Goodman Group, Ltd.   303 Congress Street   Boston MA 02210
4522 1991-06-03 1993-08-30 Saba, Paul F.   200 State Street 11th Floor Boston MA 02109
4886 1994-01-26 1994-10-17 International Strategies, Inc.   11 Beacon Street   Boston MA 02108
4898 1994-03-07 2006-09-30 O'Neill III, Thomas P.   Thirty-One New Chardon Street   Boston MA 02114
4915 1993-09-27 1995-02-06 Agnew, Carter, McCarthy, Inc.   222 Berkeley Street   Boston MA 02116
5009 1995-04-30 1997-04-30 Harron Ellenson   229 Berkeley Street   Boston MA 02116
5068 1995-11-08 1997-11-30 Friends of Fine Gael, Inc.   55 Union Street Suite 200 Boston MA 02108-2400
5219 1997-12-15 1998-12-31 Napolitano, Francisco   52 Temple Place   Boston MA 02111-1315
5328 1999-09-15 2002-03-31 Ropes and Gray   One International Place   Boston MA 02110-2624
5364 2000-04-03 2002-10-10 Hill & Barlow, P.C.   One International Place   Boston MA 02110-2600
5644 2004-09-20 2007-09-28 O'Neill and Associates   Thirty-One New Chardon Street   Boston MA 02114
5893 2008-11-26 2010-06-01 Rasky Baerlein Strategic Communications, Inc.   70 Franklin Street 3rd Floor Boston MA 02110
5896 2008-12-04 2012-02-27 Taylor, Simon   2 Oliver Street   Boston MA 02109
5897 2008-12-04 2010-12-31 Passacantilli, Daniel   62B Commercial Wharf Suite 300 Boston MA 02110
6020 2011-02-18 2011-02-18 O'Neill and Associates, LLC   31 New Chardon Street   Boston MA 02114
6100 2012-05-07 2013-06-15 Rasky Baerlein Strategic Communications, Inc.   70 Franklin Street 3rd Floor Boston MA 02110
6222 2014-05-16 2017-12-31 Rasky Baerlein Strategic Communications, Inc.   70 Franklin Street 3rd Floor Boston MA 02110
6557 2018-05-14 2019-09-23 Sachem Strategies, LLC   50 Milk Street - 16th Floor   Boston MA 02109
6586 2018-09-06 2019-08-27 Rasky Partners   70 Franklin Street 3rd Floor Boston MA 02110
6650 2019-03-15   Racepoint Global, Inc.   2 Center Plaza Suite 210 Boston MA 02108

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 41.916ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history