FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Termination_Date" is on date 2004-03-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11916 | 11916 | 2004-03-31 | 1987-01-06 | Solomon | Michael | Michael Solomon Associates 3923 | 1987-01-06 | Michael Solomon Associates | 516 Fifth Avenue | Suite 801 | New York | NY | 10036 |
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 |
11921 | 11921 | 2004-03-31 | 2003-04-09 | Hindermann | Laura C. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
11922 | 11922 | 2004-03-31 | 2003-04-09 | Keeter | Brian C. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
11923 | 11923 | 2004-03-31 | 2001-05-17 | Ahn | Sang Keun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
11924 | 11924 | 2004-03-31 | 2002-06-05 | Moorman | Robert | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
11925 | 11925 | 2004-03-31 | 2004-07-08 | Ahn | Bok Nyu | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
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 |
11937 | 11937 | 2004-03-31 | 1997-09-12 | Manuel | Nigel C.O. | Instituto Galego de Promocion Economica (IGAPE), New York 5210 | 1997-09-12 | Instituto Galego de Promocion Economica (IGAPE), New York | 670 Long Beach Boulevard | Long Beach | NY | 11561 |
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]) );