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 = "Stephen R."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date)
Registration_Number 11
- Squire, Sanders & Dempsey, L.L.P. 1
- Government of Ontario, Canada 1
- Burson-Marsteller 1
- White & Case, LLP 1
- Food Business Associates, Inc. 1
- Jones Day 1
- Commerce Consultants International, Ltd. 1
- Conn Communications 1
- Sandler-Innocenzi, Inc. 1
- Fleishman-Hillard, Inc. 1
- Heather Podesta + Partners, LLC 1
Registrant_Name 11
- Burson-Marsteller 1
- Commerce Consultants International, Ltd. 1
- Conn Communications 1
- Fleishman-Hillard, Inc. 1
- Food Business Associates, Inc. 1
- Government of Ontario, Canada 1
- Heather Podesta + Partners, LLC 1
- Jones Day 1
- Sandler-Innocenzi, Inc. 1
- Squire, Sanders & Dempsey, L.L.P. 1
- White & Case, LLP 1
City 5
- Washington 5
- New York 3
- Alexandria 1
- St. Louis 1
- Temple 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176 | 3176 | 1993-01-04 | 1990-10-22 | Richards | Stephen R. | Commerce Consultants International, Ltd. 4248 | 1989-05-05 | Commerce Consultants International, Ltd. | 1025 Thomas Jeff. Street, N.W. | Suite 105 | Washington | DC | 20007 |
4206 | 4206 | 1982-01-21 | 1979-07-29 | Bull | Stephen R. | Food Business Associates, Inc. 3085 | 1979-07-26 | Food Business Associates, Inc. | Santa Claus Lake | Temple | ME | 04984 | |
11980 | 11980 | 2006-03-31 | 1992-06-17 | Bond | Stephen R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
13959 | 13959 | 1985-04-23 | 1985-04-11 | Aiello | Stephen R. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
23893 | 23893 | 1992-07-23 | 1983-03-02 | Bell | Stephen R. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
24372 | 24372 | 1994-07-29 | 1991-03-06 | Conafay | Stephen R. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
25070 | 25070 | 2005-07-31 | 2002-07-24 | Sandler | Stephen R. | Sandler-Innocenzi, Inc. 5511 | 2002-07-24 | Sandler-Innocenzi, Inc. | 705 Prince Street | Alexandria | VA | 22314 | |
36720 | 36720 | 1989-11-30 | 1988-05-16 | Howe | Stephen R. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
37512 | 37512 | 2012-12-01 | 2012-05-15 | Bailey | Stephen R. | Heather Podesta + Partners, LLC 6103 | 2012-05-15 | Heather Podesta + Partners, LLC | 901 7th Street, NW | Suite 600 | Washington | DC | 20001 |
38849 | 38849 | 2014-12-20 | 2009-06-19 | Naru | Stephen R. | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
40805 | 40805 | 1994-12-31 | 1990-12-27 | Conn | Stephen R. | Conn Communications 4454 | 1990-12-27 | Conn Communications | 33 West 95th Street | New York | NY | 10025-6753 |
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]) );