FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Registration_Number = 5605
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]) );