FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Short_Form_Date" is on date 1989-01-27
This data as json, CSV (advanced)
Suggested facets: Address_1, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5048 | 5048 | 1990-01-31 | 1989-01-27 | Ott | Judith A. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
5767 | 5767 | 1991-02-01 | 1989-01-27 | Jang | Sudeok | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
11161 | 11161 | 1993-03-30 | 1989-01-27 | Mudrov | Alexander N. | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
12635 | 12635 | 1991-04-02 | 1989-01-27 | Campbell | Scott L. | Washington Policy & Analysis 4211 | 1989-01-27 | Washington Policy & Analysis | 655 - 15th Street, N.W. | 9th Floor | Washington | DC | 20005-5701 |
12636 | 12636 | 1991-04-02 | 1989-01-27 | Martin | William F. | Washington Policy & Analysis 4211 | 1989-01-27 | Washington Policy & Analysis | 655 - 15th Street, N.W. | 9th Floor | Washington | DC | 20005-5701 |
13786 | 13786 | 1989-04-20 | 1989-01-27 | Zoppo | Judith A. Del | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Suite 500 | Washington | DC | 20007-4186 |
14193 | 14193 | 1993-04-27 | 1989-01-27 | Nathan | Irvin B. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
17717 | 17717 | 1989-05-31 | 1989-01-27 | Downen | Robert L. | Whalen Company, Inc. 3637 | 1985-01-09 | Whalen Company, Inc. | 1717 K Street, N.W. | Suite 706 | Washington | DC | 20006 |
19348 | 19348 | 1993-06-13 | 1989-01-27 | O'Brien | David D. | Fierce, Donald L. 3541 | 1983-12-13 | Fierce, Donald L. | 600 New Hampshire Avenue, N.W. | Suite 1150 | Washington | DC | 20037 |
20305 | 20305 | 1992-06-26 | 1989-01-27 | Mendelson | Keith J. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20306 | 20306 | 1992-06-26 | 1989-01-27 | Morse | Ann | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
23431 | 23431 | 1992-07-17 | 1989-01-27 | Lupica | Lois | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
30196 | 30196 | 1989-09-21 | 1989-01-27 | Frank | Susan M. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
32250 | 32250 | 1994-10-04 | 1989-01-27 | Carrier | Allen E. | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Suite 500 | Washington | DC | 20007-4186 |
33017 | 33017 | 1989-10-16 | 1989-01-27 | Cobble | Beverly K. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
33754 | 33754 | 1991-10-28 | 1989-01-27 | Gusev | Vladimir N. | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
36727 | 36727 | 1990-11-30 | 1989-01-27 | Zhuchenko | Larisa V. | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
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]) );