FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where Short_Form_Last_Name = "Keenan" sorted by Registrant_Name
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26600 | 26600 | 1986-08-14 | 1986-01-31 | Keenan | Florence R. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
27775 | 27775 | 1993-08-30 | 1993-08-30 | Keenan | Neil F. | Neil Keenan & Associates, Inc. 4942 | 1993-08-30 | Neil Keenan & Associates, Inc. | 118 North Main Street | Providence | RI | 02903 | |
6516 | 6516 | 1986-02-10 | 1984-04-18 | Keenan | Florence R. | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | 1250 I Street, N.W. | Washington | DC | 20005 | |
22610 | 22610 | 2017-07-05 | 2019-04-15 | Keenan | Nick | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34714 | 34714 | 2018-10-31 | 2019-04-15 | Keenan | Nick | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 |
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]) );