FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "New York", Registrant_Name = "GCI Group, Inc." and "Short_Form_Termination_Date" is on date 2004-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11917 | 11917 | 2004-03-31 | 2004-02-10 | Derosia | Tamara Lyn | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11918 | 11918 | 2004-03-31 | 2003-02-25 | Hendry | Kerry | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11919 | 11919 | 2004-03-31 | 2003-02-25 | Mumma | Nelson Jr., | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11920 | 11920 | 2004-03-31 | 2003-02-25 | Shields | Amy | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11926 | 11926 | 2004-03-31 | 2003-08-08 | Antao | Natasha | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11927 | 11927 | 2004-03-31 | 2003-08-08 | Counihan | Caroline | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11928 | 11928 | 2004-03-31 | 2003-08-08 | Crane | Charles W. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11929 | 11929 | 2004-03-31 | 2003-08-08 | Devine | Anne-Marie | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11930 | 11930 | 2004-03-31 | 2003-08-08 | Wong | Andrew | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11931 | 11931 | 2004-03-31 | 2001-08-10 | Clutz | Andrew | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11932 | 11932 | 2004-03-31 | 2001-08-10 | Jordan | William G. Jr., | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11933 | 11933 | 2004-03-31 | 2001-08-10 | Kerins | Raymond F. Jr., | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11934 | 11934 | 2004-03-31 | 2002-08-12 | Lifshitz | Bryna | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
11935 | 11935 | 2004-03-31 | 2002-08-12 | Sarlo | James | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
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]) );