FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington" and "Short_Form_Termination_Date" is on date 1995-03-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11715 | 11715 | 1995-03-31 | 1993-03-03 | Korn | David A. | Korn, David A. 4773 | 1993-03-03 | Korn, David A. | 3601 Connecticut Avenue, N.W. | Suite 210 | Washington | DC | 20008 |
11720 | 11720 | 1995-03-31 | 1993-06-14 | Gale | Michael R. | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 4817 | 1993-06-14 | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. | 1300 Connecticut Avenue, N.W. | Suite 1000 | Washington | DC | 20036 |
11723 | 11723 | 1995-03-31 | 1993-07-21 | Tracey | Evan | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
11726 | 11726 | 1995-03-31 | 1992-08-31 | Kim | Hyong Chun | Korea International Trade Association 3636 | 1984-12-21 | Korea International Trade Association | 1800 K Street, N.W. | Suite 700 | Washington | DC | 20006 |
11727 | 11727 | 1995-03-31 | 1993-10-07 | Hart | J. Steven | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11728 | 11728 | 1995-03-31 | 1993-10-07 | Starr | David Allen | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11729 | 11729 | 1995-03-31 | 1994-10-20 | Franasiak | David E. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11730 | 11730 | 1995-03-31 | 1994-10-20 | Glennon | Robert E. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11731 | 11731 | 1995-03-31 | 1994-10-20 | Pharaoh | Jennifer L. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11732 | 11732 | 1995-03-31 | 1994-10-20 | Roda | Anthony J. | Williams & Jensen, P.C. 4858 | 1993-10-07 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 |
11733 | 11733 | 1995-03-31 | 1990-12-12 | Fuller | Lee O. | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | 1730 Pennsylvania Avenue, N.W. | Suite 200 | Washington | DC | 20006 |
11734 | 11734 | 1995-03-31 | 1990-12-12 | Smith | James E. | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | 1730 Pennsylvania Avenue, N.W. | Suite 200 | Washington | DC | 20006 |
11735 | 11735 | 1995-03-31 | 1990-12-19 | Free | James C. | Walker/Potter Associates, Inc. 4446 | 1990-12-12 | Walker/Potter Associates, Inc. | 1730 Pennsylvania Avenue, N.W. | Suite 200 | Washington | DC | 20006 |
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]) );