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

59 rows where Address_2 = "Suite 900"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Address_1 >30

  • 1747 Pennsylvania Avenue, N.W. 4
  • 300 New Jersey Avenue, NW 4
  • 1150 Connecticut Avenue, N.W. 3
  • 1401 New York Avenue, N.W. 3
  • 1717 K Street, NW 3
  • 1400 Eye Street, NW 2
  • 1615 L Street, N.W. 2
  • 4 Robert Speck Parkway 2
  • 601 Pennsylvania Avenue, NW 2
  • 928 Broadway 2
  • 98 San Jacinto Boulevard 2
  • 750 17th Street, NW 1
  • 1025 Connecticut Avenue, N.W. 1
  • 1101 Connecticut Avenue, N.W. 1
  • 1101 Vermont Avenue, N.W. 1
  • 1110 Vermont Avenue, N.W. 1
  • 1133 Connecticut Avenue, N.W. 1
  • 1150 18th Street, N.W. 1
  • 1333 New Hampshire Ave., N.W. 1
  • 1411 K Street, N.W. 1
  • 1500 K Street, N.W. 1
  • 1667 K Street, N.W. 1
  • 1701 K Street, N.W. 1
  • 1800 M Street, N.W. 1
  • 1850 M Street, N.W. 1
  • 1850 M Street, NW 1
  • 2000 K Street NW 1
  • 2100 L Street, NW 1
  • 500 Australian Avenue, South 1
  • 601 Brickell Key Drive 1
  • …

City 6

  • Washington 50
  • Austin 2
  • Miami 2
  • Mississauga, Ontario 2
  • New York 2
  • West Palm Beach 1

State 5

  • DC 50
  • FL 3
  • - 2
  • NY 2
  • TX 2
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
1351 1960-04-07 1960-10-07 McGovern, John Joseph   1411 K Street, N.W. Suite 900 Washington DC  
2968 1978-10-18 1994-11-22 Cole Corette & Abrutyn, P.C.   805 - 15th Street, N.W, Suite 900 Washington DC 20005
3066 1979-11-05 1980-06-07 Clark, Robert Brewster   1800 M Street, N.W. Suite 900 Washington DC 20036
3072 1979-11-30 1983-06-21 Reed, Smith, Shaw & McClay   1150 Connecticut Avenue, N.W. Suite 900 Washington DC 20036
3212 1981-03-11 1982-02-28 Gracey, Catherine E.   1110 Vermont Avenue, N.W. Suite 900 Washington DC 20006
3235 1981-05-04 2001-07-15 Ablondi, Foster, Sobin & Davidow, P.C.   1150 18th Street, N.W. Suite 900 Washington DC 20036-4129
3423 1982-11-30 1985-08-29 Buchanan & Ingersoll, Professional Corporation   1667 K Street, N.W. Suite 900 Washington DC 20006
3428 1982-12-10 1998-06-10 Rogers & Wells, LLP   607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
3490 1983-06-24 1991-01-25 Chadbourne & Parke   1101 Vermont Avenue, N.W. Suite 900 Washington DC 20005
3626 1984-10-31 1998-04-30 Miller & Chevalier, Chartered   655 - 15th Street, N.W. Suite 900 Washington DC 20005-5701
3717 1985-08-07 1986-03-07 Chapoton, John E.   1101 Connecticut Avenue, N.W. Suite 900 Washington DC 20036
3744 1985-10-03 1994-09-12 Brownstein, Zeidman & Lore   1401 New York Avenue, N.W. Suite 900 Washington DC 20005
3772 1986-01-31 1987-08-27 Beveridge & Diamond, P.C.   1333 New Hampshire Ave., N.W. Suite 900 Washington DC 20036
3818 1986-04-23 1993-05-18 Royer & Babyak   1747 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20006
3824 1986-05-01 1993-05-20 Land, Lemle & Arnold   1701 K Street, N.W. Suite 900 Washington DC 20006
3933 1987-02-02 1995-04-03 Mintz, Levin, Cohn, Ferris, Glovsky & Popeo, P.C.   701 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2608
4033 1987-08-27 1998-08-27 Schochet, Kenneth Barry   1747 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20006
4208 1989-01-23 2000-01-23 Shearman & Sterling   801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
4243 1989-04-24 1989-04-24 Brownstein, Zeidman & Schomer   1401 New York Avenue, N.W. Suite 900 Washington DC 20005
4252 1989-05-12 1989-12-29 BZS/Capitol Strategies, L.P.   1401 New York Avenue, N.W. Suite 900 Washington DC 20005
4470 1991-02-05 1993-01-26 Paul Werth Associates, Inc.   1150 Connecticut Avenue, N.W. Suite 900 Washington DC 20036
4562 1991-09-13 1992-10-06 EMF & Associates, Inc.   9100 South Dadeland Boulevard Suite 900 Miami FL 33156
4576 1991-08-01 1998-02-28 Sher & Blackwell   1850 M Street, N.W. Suite 900 Washington DC 20036
4591 1991-11-12 1998-06-30 Baker & McKenzie   815 Connecticut Avenue, N.W. Suite 900 Washington DC 20006
4625 1992-03-03 1992-09-30 Horst & Frisch, Inc.   1133 Connecticut Avenue, N.W. Suite 900 Washington DC 20036
4664 1992-05-13 1992-12-31 de Korte, Derek M.   4 Robert Speck Parkway Suite 900 Mississauga, Ontario    
4665 1992-05-13 1992-12-31 Hudson, Gerry B.   4 Robert Speck Parkway Suite 900 Mississauga, Ontario    
4842 1993-08-05 1994-09-29 Semmes, Bowen & Semmes   1025 Connecticut Avenue, N.W. Suite 900 Washington DC 20036
4928 1994-07-15 2001-01-31 Public Strategies, Inc.   98 San Jacinto Boulevard Suite 900 Austin TX 78701
4946 1994-09-06 1996-01-31 Nelson, Paul   1747 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20006
5086 1995-12-12 1995-12-31 Royer & Babyak   1747 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20006
5091 1996-01-03 1996-01-04 Asencio, Diego C.   500 Australian Avenue, South Suite 900 West Palm Beach FL 33401
5424 2001-04-04 2001-04-04 Law Firm of Larson-Jackson, P.C.   1500 K Street, N.W. Suite 900 Washington DC 20005
5436 2001-05-29 2001-11-30 Pepperwood International Corporation Hannaford Enterprises 1615 L Street, N.W. Suite 900 Washington DC 20036-5610
5472 2002-02-14 2004-09-30 Public Strategies, Inc.   98 San Jacinto Boulevard Suite 900 Austin TX 78701
5543 2003-03-11 2003-03-11 Government Strategies, LLC   1150 Connecticut Avenue, N.W. Suite 900 Washington DC 20036
5574 2003-05-29 2003-12-31 Pepperwood International Corporation Hannaford Enterprises 1615 L Street, N.W. Suite 900 Washington DC 20036-5610
5641 2004-08-27 2016-02-01 Watts Partners (J.C. Watts Companies)   601 Pennsylvania Avenue, NW Suite 900 Washington DC 20004
5740 2006-03-23 2007-05-31 Weidenfeld Law Firm   888 17th Street, N.W. Suite 900 Washington DC 20006
5774 2006-10-06 2016-10-30 CLS Strategies   1850 M Street, NW Suite 900 Washington DC 20036
5775 2006-11-07 2009-08-31 TD International, LLC   818 18th Street, NW Suite 900 Washington DC 20006
5806 2007-05-07 2017-10-31 Gray Global Advisors, LLC   300 New Jersey Avenue, NW Suite 900 Washington DC 20001
5992 2010-06-28 2018-12-31 CDN International, Inc.   1717 K Street, NW Suite 900 Washington DC 20006
6031 2011-04-08 2011-11-30 National Strategies, LLC   1400 Eye Street, NW Suite 900 Washington DC 20005
6062 2011-09-10 2012-03-30 Advantage Associates International, LTD., through Raza Bokhari   601 Pennsylvania Avenue, NW Suite 900 Washington DC 20004
6123 2012-08-07 2012-10-18 National Strategies, LLC   1400 Eye Street, NW Suite 900 Washington DC 20005
6223 2014-05-20 2018-06-30 Burson-Marsteller, LLC (Miami Office)   601 Brickell Key Drive Suite 900 Miami FL 33131
6256 2014-09-30 2014-10-31 Goldin Solutions Inc.   928 Broadway Suite 900 New York NY 10010
6273 2015-01-19 2016-01-31 Husch Blackwell, LLP   750 17th Street, NW Suite 900 Washington DC 20006
6278 2015-03-03   DCI Group AZ, LLC   2000 K Street NW Suite 900 Washington DC 20006
6280 2015-03-16   Daschle Group, LLC   901 K Street, NW Suite 900 Washington DC 20001
6298 2015-06-05 2015-06-09 Goldin Solutions Inc.   928 Broadway Suite 900 New York NY 10010
6362 2016-06-22 2018-08-01 Husch Blackwell, LLP   750 17th Street, NW Suite 900 Washington DC 20006
6654 2019-04-02 2019-07-01 Fein & DelValle, PLLC   300 New Jersey Avenue, NW Suite 900 Washington DC 20001
6750 2019-11-14   Mac, Andrew   1717 K Street, NW Suite 900 Washington DC 20006
6755 2019-11-25 2020-11-30 Rulon & White Governance Strategies et al   1717 K Street, NW Suite 900 Washington DC 20006
6892 2020-11-19   Gray Global Advisors, LLC   300 New Jersey Avenue, NW Suite 900 Washington DC 20001
7103 2022-03-28 2023-03-31 Morrison & Foerster LLP   2100 L Street, NW Suite 900 Washington DC 20037
7115 2022-05-11   AK Party Representation to the United States LLC   300 New Jersey Avenue, NW Suite 900 Washington DC 20001

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