FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and Short_Form_First_Name = "Kelly"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
243 | 243 | 2020-01-30 | McKenna | Kelly | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | ||
812 | 812 | 2021-04-16 | McGarry | Kelly | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
5103 | 5103 | 1992-01-31 | 1991-06-10 | McBride | Kelly | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
7308 | 7308 | 2015-02-20 | 2015-01-30 | Ramirez | Kelly | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
10831 | 10831 | 2021-03-26 | 2020-04-09 | Cameron | Kelly | RF Binder Partners Inc. 6814 | 2020-04-09 | RF Binder Partners Inc. | 950 Third Avenue | 7th Floor | New York | NY | 10022 |
21537 | 21537 | 2005-06-30 | 2004-06-07 | Dickens | Kelly | Ogilvy Group, Inc. 5626 | 2004-06-07 | Ogilvy Group, Inc. | Worldwide Plaza | 309 West 49th Street | New York | NY | 10019 |
25395 | 25395 | 2020-07-31 | 2019-11-27 | Delgado | Kelly | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
26466 | 26466 | 2017-08-11 | 2014-03-06 | Harrison | Kelly | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
31437 | 31437 | 2009-09-30 | 2009-03-19 | Rohrs | Kelly | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
34552 | 34552 | 2007-10-31 | 2008-01-30 | Beaty | Kelly | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
34561 | 34561 | 2007-10-31 | 2008-07-25 | Beaty | Kelly | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
35625 | 35625 | 1999-11-11 | 1997-11-28 | Glover | Kelly | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
37035 | 37035 | 2013-11-30 | 2013-01-29 | McKenna | Kelly | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
39428 | 39428 | 1998-12-30 | 1997-11-28 | McKeone | Kelly | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
41958 | 41958 | 2014-12-31 | 2014-07-30 | Powers | Kelly | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );