FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

31 rows where Registration_Number = 2539

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date (date)

State 1

Registration_Number 1

  • Dancer Fitzgerald Sample, Inc. · 31 ✖

Registrant_Name 1

City 1

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
6221 6221 1976-02-06 1974-10-09 Capossela Carolee Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
12422 12422 1976-04-01 1974-10-09 Hines Roger V. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
14509 14509 1976-04-30 1974-10-09 Giles William H. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
15734 15734 1975-05-05 1974-10-09 Nesbett Daniel A. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
19229 19229 1975-06-11 1974-10-09 McNamara Thomas R. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
23494 23494 1975-07-18 1974-10-09 Davis Martin Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37310 37310 1978-12-01 1976-06-15 Isaacs Barbara Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37311 37311 1978-12-01 1976-06-15 Snedeker Alan R. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37312 37312 1978-12-01 1976-06-15 Stinchfield Margaret Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37313 37313 1978-12-01 1976-06-15 Tabak Judy F. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37314 37314 1978-12-01 1975-06-17 Billi Vincent B. , Jr. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37316 37316 1978-12-01 1975-08-21 Myers Paul V. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37317 37317 1978-12-01 1974-10-09 Ames J. Lewis Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37318 37318 1978-12-01 1974-10-09 Blackmar Dana Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37319 37319 1978-12-01 1974-10-09 Gorglione Victor T. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37320 37320 1978-12-01 1974-10-09 Hughes Katherine V. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37321 37321 1978-12-01 1974-10-09 Hunter James C. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37322 37322 1978-12-01 1974-10-09 Kennedy Robert Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37323 37323 1978-12-01 1974-10-09 Lucci John T. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37324 37324 1978-12-01 1974-10-09 Procak George J. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37325 37325 1978-12-01 1974-10-09 Robertson Sandra Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37326 37326 1978-12-01 1974-10-09 Shaver George J. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37327 37327 1978-12-01 1974-10-09 Teitz Walter I. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37328 37328 1978-12-01 1974-10-09 Upson Stuart B. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37329 37329 1978-12-01 1974-10-09 Vickery William McC. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37330 37330 1978-12-01 1975-11-07 Hussey Marianne C. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37331 37331 1978-12-01 1976-11-24 Carrigan John F. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37332 37332 1978-12-01 1976-11-24 Kresch Andrew Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37333 37333 1978-12-01 1976-11-24 Ryan Eileen Marie Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37334 37334 1978-12-01 1977-11-30 Bohan Thomas E. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017
37335 37335 1978-12-01 1977-11-30 Taverna Rose C. Dancer Fitzgerald Sample, Inc. 2539 1974-10-09 Dancer Fitzgerald Sample, Inc. 347 Madison Avenue   New York NY 10017

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])
);