home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

34 rows where Registration_Number = 6484

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

  • NY 34

Registration_Number 1

  • FTI Consulting (SC), Inc. · 34 ✖

Registrant_Name 1

  • FTI Consulting (SC), Inc. 34

City 1

  • New York 34
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
9258 9258 2019-03-06 2018-01-29 Blakeslee James A. FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9259 9259 2019-03-06 2018-01-29 Cullo William H. FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9260 9260 2019-03-06 2018-01-29 DeRosa Benjamin FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9261 9261 2019-03-06 2018-01-29 Dill Diana FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9262 9262 2019-03-06 2018-01-29 Hindin Dan FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9263 9263 2019-03-06 2018-01-29 McDermott Megan FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9264 9264 2019-03-06 2018-01-29 Mehan Zachary FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9265 9265 2019-03-06 2018-01-29 Pultorak Kristy FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9266 9266 2019-03-06 2018-01-29 Una Michael FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9267 9267 2019-03-06 2018-01-30 LaMagna Matthew FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9268 9268 2019-03-06 2018-01-30 Sanders Joanie FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9269 9269 2019-03-06 2019-05-23 Blakeslee James A. FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9270 9270 2019-03-06 2019-05-23 DeRosa Benjamin FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9271 9271 2019-03-06 2019-05-23 Dill Diana FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9272 9272 2019-03-06 2018-06-01 Leen Kristen FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
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
35125 35125 2018-11-02 2018-01-29 Mecker Malvika 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

CSV options:

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])
);
Powered by Datasette · Queries took 327.795ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows