FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Kenney"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2563 | 2563 | 1974-01-01 | 1971-07-06 | Kenney | W. John | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
8069 | 8069 | 1996-02-28 | 1994-12-21 | Kenney | Robert J. , Jr. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
21151 | 21151 | 1991-06-30 | 1979-05-02 | Kenney | William J. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
24618 | 24618 | 1952-07-31 | 1947-04-11 | Kenney | Madlyn Bolton | French Government Tourist Office 364 | 1946-07-25 | French Government Tourist Office | 610 Fifth Avenue | New York | NY | 10020 | |
25456 | 25456 | 1964-08-01 | 1963-07-17 | Kenney | James Albert , III | Patton, Blow, Verrill, Brand & Boggs 1636 | 1963-06-06 | Patton, Blow, Verrill, Brand & Boggs | 1200 - 17th Street, N.W. | Washington | DC | 20036 | |
26713 | 26713 | 1984-08-15 | 1984-07-04 | Kenney | R. Barry | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
29326 | 29326 | 1989-09-07 | 1982-09-27 | Kenney | Patricia M. | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
32414 | 32414 | 1988-10-07 | 1988-10-04 | Kenney | Patricia | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
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]) );