FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Short_Form_Date" is on date 2017-11-03 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9273 | 9273 | 2019-03-06 | 2017-11-03 | Altman | Henry Grant | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9274 | 9274 | 2019-03-06 | 2017-11-03 | Broder | Adam | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9275 | 9275 | 2019-03-06 | 2017-11-03 | Caves | Jefferson | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9276 | 9276 | 2019-03-06 | 2017-11-03 | Crawford | Thomas Raymond | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9277 | 9277 | 2019-03-06 | 2017-11-03 | Dunn III | Jackson Thomas | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9278 | 9278 | 2019-03-06 | 2017-11-03 | Heeren | Ana | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9279 | 9279 | 2019-03-06 | 2017-11-03 | Hitchings | Nathan Michael | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9280 | 9280 | 2019-03-06 | 2017-11-03 | Kilgore | Callahan Alexandra | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9281 | 9281 | 2019-03-06 | 2017-11-03 | McCray | Tarren | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9282 | 9282 | 2019-03-06 | 2017-11-03 | McInerney | Jamie | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9283 | 9283 | 2019-03-06 | 2017-11-03 | Millett | Mathew Mateo | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9284 | 9284 | 2019-03-06 | 2017-11-03 | Mutch IV | John Carson | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9285 | 9285 | 2019-03-06 | 2017-11-03 | Pelaez | Andres Garcia | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9286 | 9286 | 2019-03-06 | 2017-11-03 | Sanford Marrow | Jenna Crossley | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9287 | 9287 | 2019-03-06 | 2017-11-03 | Whitcomb | John | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
28658 | 28658 | 2018-08-31 | 2017-11-03 | Warzala | Jared | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
35127 | 35127 | 2018-11-02 | 2017-11-03 | Ukayli | Hani | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
35963 | 35963 | 2018-11-16 | 2017-11-03 | Teixeira | Anabel Wosiack | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 |
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]) );