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

51 rows where City = "Boston"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Address_1 >30

  • 70 Franklin Street 4
  • 535 Boylston Street 3
  • 7 Park Square 3
  • 11 Beacon Street 2
  • 225 Franklin Street 2
  • 229 Berkeley Street 2
  • One International Place 2
  • Thirty-One New Chardon Street 2
  • 1 Devonshire Place 1
  • 1 Post Office Square 1
  • 185 Devonshire Street 1
  • 2 Copley Place 1
  • 2 Oliver Street 1
  • 20 Pemberton Square 1
  • 200 Clarendon Street 1
  • 200 Pier 4 Boulevard 1
  • 200 State Street 1
  • 216 Harrison Avenue 1
  • 222 Berkeley Street 1
  • 233 Marlborough Street 1
  • 303 Congress Street 1
  • 31 New Chardon Street 1
  • 345 Commonwealth Avenue 1
  • 390 Commonwealth Avenue 1
  • 45 Milk Street 1
  • 46 Waltham Street 1
  • 50 Milk Street - 16th Floor 1
  • 52 Temple Place 1
  • 55 Union Street 1
  • 60 State Street 1
  • …

State 1

  • MA 51

City 1

  • Boston · 51 ✖
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
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 2021-12-31 Racepoint Global, Inc.   46 Waltham Street   Boston MA 02118
6830 2020-05-28   Fish & Richardson P.C.   One Marina Park Drive   Boston MA 02210
6841 2020-06-25 2020-06-25 Bowen McDonald Peard   600 Atlantic Avenue 22nd Floor Boston MA 02210
6851 2020-08-10 2020-08-10 Boston Consulting Group International, Inc.   200 Pier 4 Boulevard   Boston MA 02210
7210 2022-12-23   Brown Rudnick LLP   One Financial Center, 18th Floor   Boston MA 02111

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