FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Short_Form_Termination_Date" is on date 2000-01-31
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5209 | 5209 | 2000-01-31 | 2000-01-14 | Stanges | Milly | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
5210 | 5210 | 2000-01-31 | 1998-01-15 | Andiario | Angelo | Karol Media, Inc. 5228 | 1998-01-15 | Karol Media, Inc. | 375 Stewart Road | Post Office Box 7600 | Wilkes-Barre | PA | 18773-7600 |
5211 | 5211 | 2000-01-31 | 1998-01-15 | Costello | Robert T. | Karol Media, Inc. 5228 | 1998-01-15 | Karol Media, Inc. | 375 Stewart Road | Post Office Box 7600 | Wilkes-Barre | PA | 18773-7600 |
5212 | 5212 | 2000-01-31 | 1998-01-15 | Dodge | Eugene E. | Karol Media, Inc. 5228 | 1998-01-15 | Karol Media, Inc. | 375 Stewart Road | Post Office Box 7600 | Wilkes-Barre | PA | 18773-7600 |
5213 | 5213 | 2000-01-31 | 1998-01-15 | Kincheloe | Mark W. | Karol Media, Inc. 5228 | 1998-01-15 | Karol Media, Inc. | 375 Stewart Road | Post Office Box 7600 | Wilkes-Barre | PA | 18773-7600 |
5214 | 5214 | 2000-01-31 | 1998-01-15 | Kincheloe | Michael F. | Karol Media, Inc. 5228 | 1998-01-15 | Karol Media, Inc. | 375 Stewart Road | Post Office Box 7600 | Wilkes-Barre | PA | 18773-7600 |
5215 | 5215 | 2000-01-31 | 1994-03-04 | Carter | J. Rene | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
5216 | 5216 | 2000-01-31 | 1997-04-01 | Bennett | Robert S. | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | 1440 New York Avenue, N.W. | Washington | DC | 20005-2107 | |
5217 | 5217 | 2000-01-31 | 1995-04-12 | Baker | Christopher L. | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | 1440 New York Avenue, N.W. | Washington | DC | 20005-2107 | |
5218 | 5218 | 2000-01-31 | 2000-05-08 | White-Tan | Millicent | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | 99 Madison Avenue | 2nd Floor | New York | NY | 10016-7419 |
5219 | 5219 | 2000-01-31 | 1998-06-05 | Mienano | Gregory | Parter International, Inc. 5260 | 1998-06-05 | Parter International, Inc. | 135 West 50th Street | 21st Floor | New York | NY | 10020-1201 |
5220 | 5220 | 2000-01-31 | 1996-07-01 | Stoga | Alan | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | 99 Madison Avenue | 2nd Floor | New York | NY | 10016-7419 |
5221 | 5221 | 2000-01-31 | 1997-07-08 | Inoue | Isao | Economic Information Center 4983 | 1995-01-04 | Economic Information Center | 1900 K Street, N.W. | Suite 1075 | Washington | DC | 20006 |
5222 | 5222 | 2000-01-31 | 1997-07-08 | Yamanaka | Katsufumi | Economic Information Center 4983 | 1995-01-04 | Economic Information Center | 1900 K Street, N.W. | Suite 1075 | Washington | DC | 20006 |
5223 | 5223 | 2000-01-31 | 1991-07-29 | Shapiro | Isaac | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | 1440 New York Avenue, N.W. | Washington | DC | 20005-2107 | |
5224 | 5224 | 2000-01-31 | 1998-10-09 | Carraro | Robert J. | Michael Solomon Associates 3923 | 1987-01-06 | Michael Solomon Associates | 516 Fifth Avenue | Suite 801 | New York | NY | 10036 |
5225 | 5225 | 2000-01-31 | 1997-10-20 | Hume | Virginia | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 |
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]) );