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

27 rows where Registration_Number = 5605

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date

State 1

Registration_Number 1

  • Mediaedge: CIA, LLC · 27 ✖

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
15464 15464 2004-05-01 2003-12-29 Janson George P. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
15465 15465 2004-05-01 2003-12-29 Lambert Corey Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
15467 15467 2005-05-01 2003-12-29 Apo Dennis Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
18521 18521 2005-06-01 2003-12-29 Drucker Jodie Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
21560 21560 2005-06-30 2003-12-29 Nann Laura Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
22303 22303 2004-07-01 2003-12-29 Toss Phyllis A. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
23300 23300 2004-07-15 2003-12-29 Lobel Heidi S. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
25643 25643 2004-08-01 2004-07-30 Mesa Gloria Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
25644 25644 2004-08-01 2003-12-29 Mantagno Patricia J. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41383 41383 2005-12-31 2005-01-31 Cabrera Melissa Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41386 41386 2005-12-31 2005-01-31 Nocerino Peter Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41435 41435 2005-12-31 2004-07-30 DeJesos Yahaira Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41436 41436 2005-12-31 2004-07-30 Dempsey Thomas Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41437 41437 2005-12-31 2004-07-30 Gutierrez Ingrid Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41438 41438 2005-12-31 2004-07-30 Soriano Carrie Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41439 41439 2005-12-31 2004-07-30 Valentin Alvaro Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41473 41473 2005-12-31 2003-12-29 Baker Kristen E. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41474 41474 2005-12-31 2003-12-29 Benitez Frances E. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41475 41475 2005-12-31 2003-12-29 Chamberlin Susan Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41476 41476 2005-12-31 2003-12-29 Chan Ka Wing Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41477 41477 2005-12-31 2003-12-29 Espinosa Jorge Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41478 41478 2005-12-31 2003-12-29 Figueroa Jesus Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41479 41479 2005-12-31 2003-12-29 Hammel Sarah Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41480 41480 2005-12-31 2003-12-29 Lazo Carmen M. Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41482 41482 2005-12-31 2003-12-29 Rogers Gregory Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41483 41483 2005-12-31 2003-12-29 Schanzer Alan Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019
41484 41484 2005-12-31 2003-12-29 Valenzuela Benjamin Mediaedge: CIA, LLC 5605 2003-12-29 Mediaedge: CIA, LLC 825 Seventh Avenue   New York NY 10019

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