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

22 rows where Short_Form_Last_Name = "Kelly" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

City 1

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
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
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
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
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
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
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
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
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
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  
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
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

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