FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Finley"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4054 | 4054 | 1994-01-18 | 1991-06-04 | Finley | Grace J. | Finley, McDermott & Company 4523 | 1991-06-04 | Finley, McDermott & Company | 521 Fifth Avenue | New York | NY | 10175 | |
10192 | 10192 | 1977-03-18 | 1969-08-21 | Finley | William T. , Jr. | Pierson, Semmes, Crolius & Finley 2159 | 1969-08-21 | Pierson, Semmes, Crolius & Finley | 1054 - 31st Street, N.W. | Washington | DC | 20007 | |
11337 | 11337 | 1955-03-31 | 1955-05-26 | Finley | Forrest E. | Finley, Forrest E. 891 | 1955-05-26 | Finley, Forrest E. | 814 National Press Building | Washington | DC | ||
14809 | 14809 | 1999-04-30 | 1998-06-05 | Finley | Grace J. | Parter International, Inc. 5260 | 1998-06-05 | Parter International, Inc. | 135 West 50th Street | 21st Floor | New York | NY | 10020-1201 |
16297 | 16297 | 1952-05-14 | 1950-11-14 | Finley | George Francis Titus | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
17634 | 17634 | 1977-05-31 | 1974-05-22 | Finley | Grace J. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
18258 | 18258 | 2022-05-31 | 2017-09-18 | Finley | Shannon | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
19531 | 19531 | 1982-06-15 | 1981-10-20 | Finley | Michael | Hemisphere Associates, Inc. 3290 | 1981-10-20 | Hemisphere Associates, Inc. | 2000 L Street, N.W. | Suite 200 | Washington | DC | 20036 |
23109 | 23109 | 1987-07-14 | 1986-06-05 | Finley | Grace J. | Finley, McDermott & Company 3840 | 1986-06-05 | Finley, McDermott & Company | 333 East 46th Street | New York | NY | 10017 | |
38773 | 38773 | 1954-12-20 | 1954-06-21 | Finley | Forrest E. | Forrest E. Finley & Associates 833 | 1954-06-21 | Forrest E. Finley & Associates | 814 National Press Building | Washington | DC |
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]) );