FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_First_Name = "Susan M." and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14103 | 14103 | 1994-04-25 | 1990-11-02 | Muchmore | Susan M. | Coudert Brothers 3743 | 1985-10-02 | Coudert Brothers | 1627 I Street, N. W. | Suite 1200 | Washington, | DC | 20006 |
14917 | 14917 | 2004-04-30 | 1999-12-06 | Schmidt | Susan M. | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 700 12th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
21072 | 21072 | 1987-06-30 | 1986-03-25 | Huggins | Susan M. | APCO Associates 3597 | 1984-06-20 | APCO Associates | Three Lafayette Centre | 1155 - 21st Street, N.W. #1000 | Washington | DC | 20036 |
28352 | 28352 | 1999-08-31 | 1998-10-05 | Bachar | Susan M. | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
29279 | 29279 | 2002-09-06 | 1985-03-15 | Crawford | Susan M. | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | 1317 F Street, N.W. | Suite 300 | Washington | DC | 20004-1105 |
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 |
33568 | 33568 | 1991-10-24 | 1989-03-02 | Riley | Susan M. | Evans Group, Ltd. 4222 | 1989-03-02 | Evans Group, Ltd. | 1200 G Street, N.W. | Suite 800 | Washington | DC | 20005 |
33718 | 33718 | 1995-10-27 | 1991-10-21 | Narkewicz | Susan M. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
36510 | 36510 | 1988-11-28 | 1988-02-19 | O'Brien | Susan M. | 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 |
40570 | 40570 | 1989-12-31 | 1989-05-12 | Riley | Susan M. | BZS/Capitol Strategies, L.P. 4252 | 1989-05-12 | BZS/Capitol Strategies, L.P. | 1401 New York Avenue, N.W. | Suite 900 | Washington | DC | 20005 |
41699 | 41699 | 2010-12-31 | 2007-03-22 | Garman | Susan M. | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, NW | 5th Floor | 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]) );