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

57 rows where Address_2 = "Suite 500"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Address_1 >30

  • 1735 New York Avenue, N.W. 4
  • 100 M Street, SE 3
  • 1850 K Street, N.W. 3
  • 1899 L Street, N.W. 3
  • 1050 Connecticut Avenue, NW 2
  • 1129 - 20th Street, N.W. 2
  • 1301 Pennsylvania Avenue, N.W. 2
  • 1666 K Street, N.W. 2
  • 1050 Connecticut Avenue, NW 1
  • 1101 - 16th Street, N.W. 1
  • 1101 16th Street, N.W. 1
  • 1101 16th Street, NW 1
  • 1201 Connecticut Avenue, NW 1
  • 1201 Pennsylvania Avenue, NW 1
  • 1320 - 19th Street, N.W. 1
  • 1401 I Street, N.W. 1
  • 1701 Pennsylvania Avenue, N.W. 1
  • 1707 H Street, N.W. 1
  • 1717 Pennsylvania Avenue, NW 1
  • 1730 Pennsylvania Avenue, NW 1
  • 1735 DeSales Street, N.W. 1
  • 1736 Franklin Street 1
  • 1800 Massachusetts Avenue, NW 1
  • 1875 I Street, NW 1
  • 1875 I Street. NW 1
  • 1919 Pennsylvania Avenue, N.W. 1
  • 2112 Third Avenue 1
  • 2233 Wisconsin Avenue 1
  • 2233 Wisconsin Avenue, N.W. 1
  • 230 Fifth Avenue 1
  • …

City 10

  • Washington 46
  • Miami 2
  • Vienna 2
  • Atlanta 1
  • Ft. Lauderdale 1
  • Los Angeles 1
  • New York 1
  • Oakland 1
  • San Francisco 1
  • Seattle 1

State 7

  • DC 46
  • CA 3
  • FL 3
  • VA 2
  • GA 1
  • NY 1
  • WA 1
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
934 1956-03-16 1957-02-28 Franklin D. Roosevelt, Jr. & Charles Patrick Clark   World Center Building Suite 500 Washington DC  
2208 1970-09-03 1972-03-02 Frojen Advertising, Inc.   2500 Wilshire Boulevard Suite 500 Los Angeles CA 90057
2267 1971-06-23 1971-05-26 Ellison, Byron G.   3100 East Oakland Park Blvd. Suite 500 Ft. Lauderdale FL  
2752 1977-02-10 1978-03-03 Jay Parker & Associates, Inc.   1735 DeSales Street, N.W. Suite 500 Washington DC 20036
2865 1978-02-23 1978-12-14 Clinton, Fleck, Glein & Brown   2112 Third Avenue Suite 500 Seattle WA 98121
2972 1978-10-25 2001-04-30 O'Connor & Hannan, L.L.P.   1666 K Street, N.W. Suite 500 Washington DC 20006
3122 1980-07-18 1995-02-16 Seyfarth, Shaw, Fairweather & Geraldson   815 Connecticut Avenue, N.W. Suite 500 Washington DC 20006-4004
3248 1981-06-15 1988-03-31 Steven R. Perles, P.C.   1320 - 19th Street, N.W. Suite 500 Washington DC 20036
3343 1982-03-05 1983-10-12 Walters, Costanzo, Miller & Russell   330 North Biscayne Boulevard Suite 500 Miami FL 33132
3344 1982-03-05 1983-05-11 Rainbolt II, John Vernon   1701 Pennsylvania Avenue, N.W. Suite 500 Washington DC 20006
3401 1982-08-17 1982-11-23 Florida Systems Management, Inc.   3550 Biscayne Boulevard Suite 500 Miami FL 33137
3433 1983-01-04 1986-07-30 Products of Nepal   230 Fifth Avenue Suite 500 New York NY 10001
3533 1983-10-28 1987-09-02 McDermott, Will & Emery   1850 K Street, N.W. Suite 500 Washington DC 20006
3547 1984-01-11 1984-11-20 Winston & Strawn, Washington Office   2550 M Street, N.W. Suite 500 Washington DC 20037
3610 1984-08-29 1989-03-16 Kilpatrick & Cody   2501 M Street, N.W. Suite 500 Washington DC 20037
3707 1985-07-29 1987-12-31 Rogers & Cowan, Inc., Washington Office   2233 Wisconsin Avenue Suite 500 Washington DC 20007
3801 1986-03-20 2001-03-20 Bergner Bockorny, Inc.   1101 - 16th Street, N.W. Suite 500 Washington DC 20036
3828 1986-05-08 1987-05-14 Institutional Development Associates, Ltd.   8300 Boone Boulevard Suite 500 Vienna VA 22180
3845 1986-06-18 1992-06-11 Wagner, Hines & Avary, Inc.   1899 L Street, N.W. Suite 500 Washington DC 20036
3887 1986-09-25 1989-06-15 Cameron, Hornbostel & Butterman   1707 H Street, N.W. Suite 500 Washington DC 20006
3925 1987-01-09 1987-08-11 Schmeltzer, Aptaker & Sheppard, P.C.   1800 Massachusetts Avenue, NW Suite 500 Washington DC 20036
3945 1987-03-09 1989-10-20 Moran, Mark E.   1129 - 20th Street, N.W. Suite 500 Washington DC 20036
4010 1987-07-09 1988-01-09 Foley & Lardner   3000 K Street Suite 500 Washington DC 20007-5109
4054 1987-11-06 1989-12-14 Charles L. Fishman, P.C. InTecTran, Inc. 1129 - 20th Street, N.W. Suite 500 Washington DC 20036-3403
4093 1988-02-19 1994-10-04 Henry J. Kaufman & Associates, Inc.   2233 Wisconsin Avenue, N.W. Suite 500 Washington DC 20007-4186
4643 1992-04-06 1993-04-05 McDermott, Will & Emery   1850 K Street, N.W. Suite 500 Washington DC 20006
4785 1993-03-31 1995-04-25 Barnes & Thornburg   1401 I Street, N.W. Suite 500 Washington DC 20005
4792 1993-04-08 1993-12-01 Thompson Group, Inc.   1899 L Street, N.W. Suite 500 Washington DC 20036
4793 1993-04-12 1993-11-30 Albertine Enterprises, Inc.   1899 L Street, N.W. Suite 500 Washington DC 20036
4818 1993-06-22 1996-02-14 McDermott, Will & Emery   1850 K Street, N.W. Suite 500 Washington DC 20006
5075 1995-06-15 1995-12-31 Butera, James J.   1301 Pennsylvania Avenue, N.W. Suite 500 Washington DC 20004
5172 1997-04-15 1997-10-31 Boggs, J.C.   1301 Pennsylvania Avenue, N.W. Suite 500 Washington DC 20004
5208 1997-09-15 2008-08-28 Porter, Wright, Morris & Arthur, LLP   1919 Pennsylvania Avenue, N.W. Suite 500 Washington DC 20006
5295 1998-12-29 2000-12-31 Southern Energy Resources, Inc.   900 Ashwood Parkway Suite 500 Atlanta GA 30338
5300 1999-02-08 2000-02-29 Preston Gates Ellis & Rouvelas Meeds, LLP   1735 New York Avenue, N.W. Suite 500 Washington DC 20006
5442 2001-06-18 2003-12-31 Dellums, Brauer, Halterman & Associates, LLC   1736 Franklin Street Suite 500 Oakland CA 94612
5516 2002-08-02 2006-02-28 Nurnberger & Associates, Inc.   1735 New York Avenue, N.W. Suite 500 Washington DC 20006
5518 2002-09-18 2003-01-02 Preston Gates Ellis & Rouvelas Meeds LLP   1735 New York Avenue, N.W. Suite 500 Washington DC 20006-5209
5555 2003-01-09 2005-01-31 Bockorny, Petrizzo, Inc.   1101 16th Street, N.W. Suite 500 Washington DC 20036
5583 2003-10-31 2004-02-29 Preston Gates Ellis & Rouvelas Meeds, LLP   1735 New York Avenue, N.W. Suite 500 Washington DC 20006
5589 2003-11-18 2004-09-30 O'Connor & Hannan, LLP   1666 K Street, N.W. Suite 500 Washington DC 20006-2803
5791 2007-02-05 2010-02-28 Squire Sanders Public Advocacy, LLC   1201 Pennsylvania Avenue, NW Suite 500 Washington DC 20004-2401
5810 2007-05-14 2011-10-31 American Business Development Group   301 Maple Avenue West Suite 500 Vienna VA 22180
5817 2007-06-26 2012-12-31 Global Communicators, LLC   1875 I Street, NW Suite 500 Washington DC 20006
5819 2007-07-06 2007-09-30 Bockorny Group, Inc.   1101 16th Street, NW Suite 500 Washington DC 20036
5982 2010-03-22   Thomas Capitol Partners, Inc.   1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
6041 2011-05-19 2012-03-31 Dutko Worldwide, LLC   100 M Street, SE Suite 500 Washington DC 20003
6056 2011-08-12 2011-10-31 Bell Pottinger USA, Inc.   1201 Connecticut Avenue, NW Suite 500 Washington DC 20036
6166 2013-04-17 2013-04-26 Dutko Worldwide, LLC d/b/a Dutko Grayling Dutko Grayling 100 M Street, SE Suite 500 Washington DC 20003
6243 2014-08-19 2015-04-30 Global Communicators, LLC   1875 I Street. NW Suite 500 Washington DC 20006
6247 2014-08-28 2015-12-31 Barnes & Thornburg, LLP   1717 Pennsylvania Avenue, NW Suite 500 Washington DC 20006
6270 2015-01-15 2016-07-31 DUTKO WORLDWIDE, LLC DBA GRAYLING   100 M Street, SE Suite 500 Washington DC 20003
6305 2015-07-20   Scribe Strategies & Advisors, Inc.   1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
6324 2015-10-19 2015-10-30 Williams & Jensen, PLLC   701 8th Street, NW Suite 500 Washington DC 20001
6388 2016-10-28   theGroup DC, LLC   1730 Pennsylvania Avenue, NW Suite 500 Washington DC 20006
6493 2017-11-30 2017-12-31 Hawksbill Group, LLC   1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
6725 2019-09-20 2021-10-11 Earthjustice   50 California Street Suite 500 San Francisco CA 94111

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