FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Short_Form_First_Name = "Susan M."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 15
- Squire Patton Boggs, LLP 1
- Bahamas Tourist Office 1
- Peter Martin Associates, Inc. 1
- Fasturn, Inc. 1
- Oestreicher, Michael R. 1
- APCO Associates 1
- Saatchi & Saatchi North America, Inc. 1
- Coudert Brothers 1
- Henry J. Kaufman & Associates, Inc. 1
- Pillsbury, Madison & Sutro 1
- Evans Group, Ltd. 1
- BZS/Capitol Strategies, L.P. 1
- Manatt, Phelps & Phillips 1
- DCS Group 1
- Quinn Gillespie & Associates, LLC 1
Registrant_Name 15
- APCO Associates 1
- BZS/Capitol Strategies, L.P. 1
- Bahamas Tourist Office 1
- Coudert Brothers 1
- DCS Group 1
- Evans Group, Ltd. 1
- Fasturn, Inc. 1
- Henry J. Kaufman & Associates, Inc. 1
- Manatt, Phelps & Phillips 1
- Oestreicher, Michael R. 1
- Peter Martin Associates, Inc. 1
- Pillsbury, Madison & Sutro 1
- Quinn Gillespie & Associates, LLC 1
- Saatchi & Saatchi North America, Inc. 1
- Squire Patton Boggs, LLP 1
City 5
- Washington 10
- New York 2
- Cincinnati 1
- Nassau 1
- Washington, 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7481 | 7481 | 1998-02-23 | 1997-11-17 | Collins | Susan M. | Oestreicher, Michael R. 3426 | 1982-12-08 | Oestreicher, Michael R. | 312 Walnut Street | Suite 1400 | Cincinnati | OH | 45202 |
7889 | 7889 | 1981-02-28 | 1981-01-22 | Case | Susan M. | Peter Martin Associates, Inc. 2846 | 1977-11-15 | Peter Martin Associates, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
14088 | 14088 | 1986-04-25 | 1986-02-20 | Lawson | Susan M. | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
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 |
31966 | 31966 | 2002-10-01 | 1994-11-17 | Cella | Susan M. | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | ||
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]) );