FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

18 rows where City = "Washington" and Short_Form_Last_Name = "Kelly"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

City 1

  • Washington · 18 ✖
Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
402 402   2022-02-15 Kelly Matthew BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
3177 3177 1993-01-04 1990-10-30 Kelly John A. Commerce Consultants International, Ltd. 4248 1989-05-05 Commerce Consultants International, Ltd. 1025 Thomas Jeff. Street, N.W. Suite 105 Washington DC 20007
4189 4189 2017-01-20 2016-09-20 Kelly John S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 Eye Street, NW Suite 410 Washington DC 20006
6938 6938 1985-02-15 1984-05-01 Kelly Joan Larson Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
7207 7207 1992-02-18 1991-01-30 Kelly Kathleen Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
7273 7273 1953-02-20 1951-02-20 Kelly Helen L. Barnes, James M. 660 1951-02-20 Barnes, James M. 1025 Connecticut Avenue   Washington DC  
13466 13466 1996-04-15 1985-05-07 Kelly Peter G. Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey 1801 K Street, N.W. Suite 901-L Washington DC 20006
16720 16720 2023-05-19 2018-04-05 Kelly Caroline Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
16881 16881 1987-05-22 1986-11-24 Kelly J. Ronald Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
28294 28294 1997-08-31 1993-01-08 Kelly Peter G. Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey 1801 K Street, N.W. Suite 901-L Washington DC 20006
28307 28307 1997-08-31 1995-05-16 Kelly Peter Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
30928 30928 1978-09-30 1977-10-13 Kelly Jacqueline Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
32521 32521 1995-10-09 1993-08-02 Kelly Francis J. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
34414 34414 1998-10-31 1998-04-23 Kelly W. Michael Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   Washington DC 20006
35300 35300 1991-11-05 1971-03-08 Kelly Robert Adgar Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. 1015 - 18th Street, N.W. Suite 704 Washington DC 20036
36856 36856 1997-11-30 1989-05-16 Kelly Biruta P. Scribner, Hall & Thompson 4253 1989-05-16 Scribner, Hall & Thompson 1875 Eye Street, N.W. Suite 1050 Washington DC 20006
39085 39085 1997-12-24 1992-08-14 Kelly Dianne H. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
40407 40407 1987-12-31 1986-06-10 Kelly Michael S. Morgan, Lewis & Bockius, L.L.P. 3794 1986-03-12 Morgan, Lewis & Bockius, L.L.P. 1111 Pennsylvania Avenue, N.W.   Washington DC 20004

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);