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

47 rows where Short_Form_Last_Name = "Kelly"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)

State 7

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
2700 2700 1990-01-01 1985-10-03 Kelly James Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
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  
9850 9850 2008-03-14 2008-10-31 Kelly Kristine Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
10517 10517 1995-03-22 1992-01-29 Kelly Cornelius McCann Direct, Inc. 3922 1986-12-29 McCann Direct, Inc. 750 Third Avenue   New York NY 10017
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
14954 14954 2007-04-30 2007-06-20 Kelly Denise M. Cayman Islands Department of Tourism 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
15372 15372 1985-05-01 1981-10-30 Kelly Clement Frank VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
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
18296 18296 1948-06-01 1947-12-01 Kelly Doris May U.S. Office of the British Broadcasting Corporation 505 1947-12-01 U.S. Office of the British Broadcasting Corporation 630 Fifth Avenue   New York NY 10111
18499 18499 1993-06-01 1991-10-21 Kelly Dennis E. Feingerts & Kelly, PLC 4577 1991-10-21 Feingerts & Kelly, PLC 650 Poydras Street Suite 2750 New Orleans LA 70130-6161
19856 19856 1991-06-19 1990-04-10 Kelly Laura Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. 919 Prince Street   Alexandria VA 22314
20557 20557 1996-06-29 1995-07-28 Kelly Thomas J. McCann Direct, Inc. 3922 1986-12-29 McCann Direct, Inc. 750 Third Avenue   New York NY 10017
20816 20816 1970-06-30 1970-06-30 Kelly Anthony John Tourism Ireland 536 1948-08-16 Tourism Ireland 345 Park Avenue 17th Floor New York NY 10154
21195 21195 1993-06-30 1992-11-05 Kelly Brendan J. International Communications Marketing, Inc. (ICM) 4733 1992-11-05 International Communications Marketing, Inc. (ICM) 666 Fifth Avenue   New York NY 10103
22398 22398 2021-07-01 2018-12-06 Kelly Janika B'nai GMJ Global, LLC 6612 2018-12-06 GMJ Global, LLC 202 Hilltop Drive   Nyack NJ 10960
23803 23803 2019-07-22 2018-11-06 Kelly Brian L. Nelson Mullins Riley & Scarborough, LLP 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
24473 24473 1975-07-30 1955-04-08 Kelly John Nicholas Joseph Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. 247 Park Avenue   New York NY  
24478 24478 1975-07-30 1959-09-18 Kelly Robert Eugene Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. 247 Park Avenue   New York NY  
24633 24633 1963-07-31 1942-07-30 Kelly John C. Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. 247 Park Avenue   New York NY  
24741 24741 1985-07-31 1974-05-22 Kelly Edward J. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
24959 24959 2000-07-31 1993-05-19 Kelly Paul Gibney, Anthony & Flaherty, L.L.P. 4805 1993-05-19 Gibney, Anthony & Flaherty, L.L.P. 665 Fifth Avenue 10th Floor New York NY 10022-5305
27220 27220 1997-08-22 1995-03-31 Kelly Neil Enterprise Ireland 2518 1974-06-08 Enterprise Ireland Ireland House 345 Park Avenue, 17th Floor New York NY 10154-0037
27930 27930 1977-08-31 1970-01-06 Kelly John F. , Jr. McCann-Erickson, Inc. 1746 1964-06-02 McCann-Erickson, Inc. 485 Lexington Avenue   New York NY 10017
28219 28219 1993-08-31 1993-01-14 Kelly Dennis E. Ukrainian Technical Assistance Foundation 4752 1993-01-14 Ukrainian Technical Assistance Foundation 650 Poydras Street Suite 2750 New Orleans LA 70130
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
29061 29061 2005-09-02 1982-10-01 Kelly Robert M. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
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
32475 32475 2014-10-08 2013-12-11 Kelly Martha Dickens & Madson Canada Inc. 6200 2013-12-11 Dickens & Madson Canada Inc. c/o Tragen Resources & Logistics 740 Notre Dame Ouest, Suite 1250 Montreal    
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
32863 32863 1986-10-15 1986-04-18 Kelly Richard McCann-Erickson, Inc. 3060 1979-09-16 McCann-Erickson, Inc. 485 Lexington Avenue   New York NY 10017
33387 33387 1986-10-22 1978-08-03 Kelly Jean Parker Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. 420 Lexington Avenue   New York NY 10017
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
38092 38092 1961-12-11 1943-06-11 Kelly Hugh Dominican Chamber of Commerce of the U.S., Inc. 197 1943-06-11 Dominican Chamber of Commerce of the U.S., Inc. 1270 Avenue of the Americas   New York NY  
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
39578 39578 1957-12-31 1951-03-15 Kelly Jeannette Elizabeth Agence France-Presse (France-Presse News Agency) 223 1943-12-02 Agence France-Presse (France-Presse News Agency) 50 Rockefeller Plaza   New York NY 10020
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
41389 41389 2005-12-31 2005-02-01 Kelly Francis J. III Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41845 41845 2012-12-31 2012-10-03 Kelly Jared Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314

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])
);