FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Address_1 = "1850 M Street, N.W." and City = "Washington"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6331 | 6331 | 1997-02-07 | 1996-07-02 | Wolf | John | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
8091 | 8091 | 1998-02-28 | 1991-08-01 | Lawrence | Jeffrey F. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
8093 | 8093 | 1998-02-28 | 1991-10-04 | Fink | Marc J. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
8094 | 8094 | 1998-02-28 | 1991-10-04 | Smith | David F. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
8095 | 8095 | 1998-02-28 | 1992-10-30 | Blackwell | Robert J. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
8096 | 8096 | 1998-02-28 | 1992-10-30 | Sher | Stanley O. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
9784 | 9784 | 1998-03-13 | 1997-07-09 | Brown | Julia Jane | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
14107 | 14107 | 1997-04-25 | 1996-05-17 | Maselli | Mary | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
14644 | 14644 | 1993-04-30 | 1991-08-01 | Pollock | William W. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
17758 | 17758 | 1992-05-31 | 1988-02-02 | Choi | Dong Sik | Hyundai, Washington Office 4088 | 1988-02-02 | Hyundai, Washington Office | 1850 M Street, N.W. | Suite 840 | Washington | DC | 20036 |
19578 | 19578 | 1997-06-15 | 1996-09-17 | Silverman | Peter | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
22533 | 22533 | 1998-07-03 | 1997-05-09 | Marshall | Don | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
24102 | 24102 | 1996-07-26 | 1996-05-17 | Fulwider | Michael | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
25793 | 25793 | 1996-08-02 | 1988-02-02 | Shin | Hyun Kyu | Hyundai, Washington Office 4088 | 1988-02-02 | Hyundai, Washington Office | 1850 M Street, N.W. | Suite 840 | Washington | DC | 20036 |
30150 | 30150 | 1996-09-20 | 1992-10-30 | Sjogren | Torbjorn | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
30448 | 30448 | 1998-09-25 | 1997-07-28 | Howell | Andrew P. | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
30449 | 30449 | 1998-09-25 | 1997-09-11 | Larson | Jennifer Paige | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
34372 | 34372 | 1995-10-31 | 1994-12-27 | Bangert | Philip A. | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | 1850 M Street, N.W. | Suite 900 | Washington | DC | 20036 |
40902 | 40902 | 1995-12-31 | 1989-09-05 | Ha | Jong Sun | Hyundai, Washington Office 4088 | 1988-02-02 | Hyundai, Washington Office | 1850 M Street, N.W. | Suite 840 | Washington | DC | 20036 |
41132 | 41132 | 1999-12-31 | 1998-04-14 | Aman | Sally J. | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41137 | 41137 | 1999-12-31 | 1996-05-17 | Montrey | Scot | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41138 | 41138 | 1999-12-31 | 1996-05-17 | Sullivan | Kelly | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41148 | 41148 | 1999-12-31 | 1997-07-09 | Leonard | Dan | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41161 | 41161 | 1999-12-31 | 1994-09-28 | Chlopak | Robert A. | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41162 | 41162 | 1999-12-31 | 1994-09-28 | Leonard | Charles G. | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41163 | 41163 | 1999-12-31 | 1994-09-28 | Schechter | Peter | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
41169 | 41169 | 1999-12-31 | 1998-10-30 | Waffle | William | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
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]) );