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

19 rows where "Short_Form_Date" is on date 2009-10-30

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 3

City 3

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
31481 31481 2009-09-30 2009-10-30 Belcher Amanda Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31482 31482 2009-09-30 2009-10-30 Brooks Caroline Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31483 31483 2009-09-30 2009-10-30 Capps Jennifer Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31484 31484 2009-09-30 2009-10-30 Clark Ann Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31485 31485 2009-09-30 2009-10-30 Edelman Renee Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31486 31486 2009-09-30 2009-10-30 Ehrlich Alyssa Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31487 31487 2009-09-30 2009-10-30 Kinoshi Louisa Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31488 31488 2009-09-30 2009-10-30 Kumar Amit Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31489 31489 2009-09-30 2009-10-30 Laws George Benjamin Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31490 31490 2009-09-30 2009-10-30 Lumet Michele Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31491 31491 2009-09-30 2009-10-30 Naguib Amgad Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31492 31492 2009-09-30 2009-10-30 Pipkin Melanie Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31493 31493 2009-09-30 2009-10-30 Pulchin Howard Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31494 31494 2009-09-30 2009-10-30 Rajpal Nikki Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31495 31495 2009-09-30 2009-10-30 Schoenfelder Emily Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31496 31496 2009-09-30 2009-10-30 Tabak Ilana Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
31497 31497 2009-09-30 2009-10-30 Walsh Allison Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
32066 32066 2013-10-01 2009-10-30 Footlik Jay 30 Point Strategies, LLC 5884 2008-10-06 30 Point Strategies, LLC 7315 Wisconsin Avenue Suite 425 East Bethesda MD 20814
41733 41733 2010-12-31 2009-10-30 Kasperowicz Pete I. Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1501 K Street, N.W. 8th Floor Washington DC 20005

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