FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Address_1 = "2300 M Street, N.W." and City = "Washington"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Registration_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9123 | 9123 | 1993-03-04 | 1992-07-13 | Wallace | Stephen J. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
13089 | 13089 | 1991-04-10 | 1989-10-05 | Holmstrom | Engin Inel | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
14254 | 14254 | 1989-04-28 | 1988-11-07 | Gay | Heather L. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
16662 | 16662 | 1994-05-18 | 1989-01-11 | Feith | Douglas J. | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
16663 | 16663 | 1994-05-18 | 1989-01-11 | Feldman | Mark B. | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
16664 | 16664 | 1994-05-18 | 1989-02-22 | McNamara | Michael J. | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
16665 | 16665 | 1994-05-18 | 1989-04-10 | Borland | Lydia A. | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
20100 | 20100 | 1992-06-23 | 1988-11-07 | O'Neill | Catherine C. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
20101 | 20101 | 1992-06-23 | 1988-11-07 | Green | Benjamin H. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
20102 | 20102 | 1992-06-23 | 1987-12-23 | Wallace | Stephen J. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
20538 | 20538 | 1990-06-29 | 1989-10-03 | Epstein | Mark A. | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
21116 | 21116 | 1989-06-30 | 1986-04-01 | Nordquist | Myron Harry | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
22635 | 22635 | 1990-07-06 | 1990-02-09 | Busam | David R. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
23852 | 23852 | 1991-07-23 | 1987-07-24 | Lebow | Edward M. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
29484 | 29484 | 1993-09-09 | 1992-03-02 | Marinaccio | Charles L. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
34307 | 34307 | 1990-10-31 | 1990-06-27 | Weeks | Joan Strickler | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
34920 | 34920 | 1989-11-01 | 1989-03-10 | Amitay | Morris J. | International Advisers, Inc. 4203 | 1989-01-11 | International Advisers, Inc. | 2300 M Street, N.W. | Suite 600 | Washington | DC | 20037 |
35427 | 35427 | 1988-11-08 | 1981-10-08 | Propper | Eugene M. | Lane & Edson, P.C. 3286 | 1981-10-08 | Lane & Edson, P.C. | 2300 M Street, N.W. | Washington | DC | 20037 | |
35428 | 35428 | 1988-11-08 | 1981-10-08 | Truslow | Frederic J. | Lane & Edson, P.C. 3286 | 1981-10-08 | Lane & Edson, P.C. | 2300 M Street, N.W. | Washington | DC | 20037 |
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]) );