FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

80 rows where Address_2 = "Suite 400"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 12

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
817 1954-02-23 1999-06-30 Pekao Trading Corporation   Two Park Avenue Suite 400 New York NY 10016
1001 1957-02-21 1983-06-30 Arter, Hadden & Hemmendinger   1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
1782 1964-09-01 1991-07-30 British Columbia House   100 Bush Street Suite 400 San Francisco CA 94104
1992 1966-10-31 1974-01-09 Barnett, Vincent Gerrard   919 - 18th Street, N.W. Suite 400 Washington DC 20006
2686 1976-04-23   Korea International Trade Association, Inc.   460 Park Avenue Suite 400 New York NY 10022
2852 1977-12-15 1979-06-15 Akin, Gump, Hauer & Feld   1333 New Hampshire Ave., N.W. Suite 400 Washington DC 20036
3064 1979-10-02 1982-12-13 Lee Edwards & Associates, Inc.   1705 DeSales Street, N.W. Suite 400 Washington DC 20036
3158 1980-10-20 1983-09-30 Motsi, Jacob Ramokoena   1320 - 19th Street, N.W. Suite 400 Washington DC 20036
3321 1982-01-06 1982-10-19 Montoya-Curbelo, Rolando   200 Southeast 1st Street Suite 400 Miami FL 33131
3331 1982-01-26 1982-07-31 Hale, Russell & Gray   1025 Connecticut Avenue, N.W. Suite 400 Washington DC 20036
3408 1982-08-31 1983-09-30 Olumba, Rufus I.   4801 Massachusetts Avenue, NW Suite 400 Washington DC 20016
3435 1983-01-10 1983-10-13 Davis, Christopher L.   2501 M Street, N.W. Suite 400 Washington DC 20037
3460 1983-04-20 1984-05-22 Kennedy, Cornelius B.   4801 Massachusetts Avenue, NW Suite 400 Washington DC 20016
3466 1983-05-09 1994-05-09 van Kloberg & Associates, Ltd.   1129 - 20th Street, N.W. Suite 400 Washington DC 20036
3467 1983-05-10 1985-06-11 McLeod, Michael R.   2501 M Street, N.W. Suite 400 Washington DC 20037
3485 1983-06-16 1992-10-02 Oppenheimer, Wolff & Donnelly   1020 - 19th Street, N.W. Suite 400 Washington DC 20036
3588 1984-05-18 1990-05-02 Jack E. Buttram Company, Inc.   1212 Haywood Road Suite 400 Greenville SC 29615
3686 1985-06-03 1985-12-31 Arter & Hadden   1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
3694 1985-06-24 2003-12-23 Collier Shannon Scott, PLLC   3050 K Street N.W. Suite 400 Washington DC 20007-5108
3884 1986-09-19 1996-12-31 CANAMCO   1220 - 19th Street, N.W. Suite 400 Washington DC 20036
3903 1986-11-03 1989-05-24 Pacific Islands, Washington Office   1615 New Hampshire Avenue, NW Suite 400 Washington DC 20009
4090 1988-02-19 1989-12-31 Haworth, James David Stewart   4801 Massachusetts Avenue, NW Suite 400 Washington DC 20016
4127 1988-06-11 1993-04-08 Paul H. DeLaney, Jr.   1155 Connecticut Avenue, N.W. Suite 400 Washington DC 20036
4169 1988-08-23 1989-10-20 Afri-Trust International (Ati-Afribank)   1155 - 21st Street, N.W. Suite 400 Washington DC 20036
4259 1989-05-25 2002-12-01 Cassidy & Associates, Inc.   700 - 13th Street, N.W. Suite 400 Washington DC 20005
4332 1990-01-18 1998-12-31 Washington Group   1401 K Street, N.W. Suite 400 Washington DC 20005
4412 1990-09-19 1991-03-31 Porter, Wright, Morris & Arthur   1233 - 20th Street, N.W. Suite 400 Washington DC 20036
4426 1990-10-15 1993-04-12 Interface Public Affairs   1825 I Street, N.W. Suite 400 Washington DC 20006
4524 1991-05-23 1994-05-30 Miller, Canfield, Paddock & Stone, P.L.C.   1225 - 19th Street, N.W. Suite 400 Washington DC 20036
4534 1991-07-03 1993-03-31 McNair Law Firm, P.A.   1155 - 15th Street, N.W. Suite 400 Washington DC 20005
4580 1991-10-23 1994-04-30 Olsson, Frank & Weeda, P.C.   1400 - 16th Street, N.W. Suite 400 Washington DC 20036-2220
4586 1991-11-06 1992-12-31 Office of the Republic of Slovenia   1300 - 19th Street, N.W. Suite 400 Washington DC 20036
4622 1992-02-21 1998-05-30 Tourism Authority of Thailand, Chicago   303 East Wacker Drive Suite 400 Chicago IL 60601
4671 1992-05-18 2001-01-31 Porter/Novelli   1909 K Street Suite 400 Washington DC 20006
4695 1992-07-27 1993-10-26 Demougeot, George   1825 I Street, N.W. Suite 400 Washington DC 20006
4699 1992-07-31 1999-08-31 Sandler & Travis Trade Advisory Services, Inc.   1300 Pennsylvania Ave., N.W. Suite 400 Washington DC 20004
5005 1995-03-21 1995-10-26 Schechter, Richard   1825 I Street, N.W. Suite 400 Washington DC 20006-0006
5015 1995-04-14 1996-04-30 Law Office of Richard Littell   1220 - 19th Street, N.W. Suite 400 Washington DC 20036
5175 1997-04-21 1998-04-30 Olsson, Frank & Weeda, P.C.   1400 - 16th Street, N.W. Suite 400 Washington DC 20036-2220
5190 1997-07-07 1998-01-31 Dawkins, Dymally & Associates   1825 I Street, N.W. Suite 400 Washington DC 20006
5266 1998-07-15 1999-01-31 Ruddy, Frank   1825 I Street, N.W. Suite 400 Washington DC 20006
5303 1998-12-07 2007-12-31 Sandler, Travis & Rosenberg, P.A.   1300 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20004-3002
5315 1999-05-11 2001-05-31 Shandwick USA, Inc.   8000 Norman Center Drive Suite 400 Bloomington MN 55437
5386 2000-09-27 2000-09-30 Mehreteab, Ghebre Selassie   1090 Vermont Avenue, N.W. Suite 400 Washington DC 20005
5387 2000-09-28 2000-09-30 International Strategic & Consulting Group, Inc.   1020 Nineteenth Street, N.W. Suite 400 Washington DC 20036
5408 2001-02-05 2011-02-28 McGuireWoods Consulting, LLC   2001 K Street, NW Suite 400 Washington DC 20006
5441 2001-06-12 2001-12-31 Dierman, Wortley & Zola, Inc.   1776 K Street, N.W. Suite 400 Washington DC 20006
5575 2003-08-14 2005-02-28 Bisceglie & Walsh   1130 17th Street, N.W. Suite 400 Washington DC 20036
5636 2004-08-05 2006-02-27 Ford & Associates   700 Thirteenth Street, N.W. Suite 400 Washington DC 20005
5643 2004-09-10 2010-12-31 Cassidy & Associates, Inc.   700 13th Street, N.W. Suite 400 Washington DC 20005
5649 2004-10-08 2013-04-04 Levick Strategic Communications   1900 M Street, N.W. Suite 400 Washington DC 20036
5717 2005-10-26 2006-04-30 Saint-Louis & Johnson, P.C.   1020 19th Street Suite 400 Washington DC 20036
5718 2005-10-31 2005-10-31 Collier Shannon Scott, PLLC   3050 K Street, NW Suite 400 Washington DC 20007
5756 2006-06-30 2006-06-30 Africa United States Friendship & Economic Development Group (US FED Group)   1701 Pennsylvania Avenue, NW Suite 400 Washington DC 20006
5816 2007-06-25 2007-12-15 Olsson, Phil   1400 16th Street, NW Suite 400 Washington DC 20036
5843 2007-12-28 2008-12-31 August, Lang & Husak AL&H 4630 Montgomery Avenue Suite 400 Bethesda MD 20814
5859 2008-04-03 2010-07-12 Broydrick & Associates, Inc.   400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
5952 2009-09-24 2009-10-01 BlackBear Communications   701 8th Street, NW Suite 400 Washington DC 20001
5989 2010-05-20 2010-11-30 Sandler, Travis & Rosenberg, P.A.   1300 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6001 2010-09-21 2012-12-31 Singer Bonjean Strategies   1455 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6052 2011-08-11 2013-08-31 Sconset Strategies, LLC   1720 Eye Street, NW Suite 400 Washington DC 20006
6115 2012-07-19 2013-04-26 Sandler, Travis & Rosenberg, P.A.   1300 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6140 2012-10-05 2013-11-01 DCI Group, LLC   1828 L Street, NW Suite 400 Washington DC 20036
6170 2013-05-14   Mercury Public Affairs, LLC   1615 L Street, NW Suite 400 Washington DC 20036
6179 2013-08-09 2013-12-31 Cassidy & Associates, Inc.   733 10th Street, NW Suite 400 Washington DC 20001
6214 2014-04-15 2014-09-30 Cassidy & Associates, Inc.   733 10th Street, NW Suite 400 Washington DC 20001
6216 2014-04-16 2014-12-14 Singer Bonjean Strategies   1455 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6217 2014-04-17 2015-03-31 FTI Consulting (Government Affairs) LLC   325 7th Street, NW Suite 400 Washington DC 20004
6244 2014-08-20 2015-01-30 Sandler, Travis & Rosenberg, P.A.   1300 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6272 2015-01-16 2018-04-18 Cassidy & Associates, Inc.   733 Tenth Street, NW Suite 400 Washington DC 20001
6281 2015-03-17 2017-03-31 Targeted Victory, LLC   1033 North Fairfax Street Suite 400 Alexandria VA 22314
6309 2015-07-24 2015-12-15 Sandler, Travis & Rosenberg, P.A.   1300 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6338 2016-02-05 2016-09-29 Law Offices of Robert Kelley   1401 K Street, NW Suite 400 Washington DC 20005
6366 2016-08-08 2018-03-19 Sandler, Travis & Rosenberg, P.A.   1300 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6368 2016-08-11 2017-02-15 Monte Advisory Group, LLC   1455 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
6385 2016-10-27 2018-05-31 Trailblazer Group   901 King Street Suite 400 Alexandria VA 22314
6549 2018-04-30   Myriad International Marketing, LLC   7309 W. 80th Street Suite 400 Overland Park KS 66204
6672 2019-05-06   McGinnis Lochridge   1111 W. 6th Street Bldg. B Suite 400 Austin TX 78703
6844 2020-07-15 2022-11-30 Blueprint Communications, LLC   2111 Eisenhower Avenue Suite 400 Alexandria VA 22314
7005 2021-09-01 2022-08-22 Ice Miller Strategies LLC   200 Massachusetts Avenue, NW Suite 400 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])
);