FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "Washington" and Short_Form_Last_Name = "Berman"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4165 | 4165 | 1989-01-20 | 1986-03-20 | Berman | Wayne L. | Bergner Bockorny, Inc. 3801 | 1986-03-20 | Bergner Bockorny, Inc. | 1101 - 16th Street, N.W. | Suite 500 | Washington | DC | 20036 |
5006 | 5006 | 1986-01-31 | 1985-05-07 | Berman | Wayne L. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
8288 | 8288 | 2015-02-28 | 2014-06-02 | Berman | Howard | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
11045 | 11045 | 1991-03-29 | 1990-05-24 | Berman | Julie E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11051 | 11051 | 1991-03-29 | 1989-12-18 | Berman | Julie E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
14347 | 14347 | 1994-04-29 | 1993-04-02 | Berman | Jeffrey G. | Reid & Priest 4223 | 1989-03-06 | Reid & Priest | 701 Pennsylvania Avenue, N.W. | Suite 800 | Washington | DC | 20004 |
23531 | 23531 | 1988-07-18 | 1987-11-04 | Berman | Lynn E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34484 | 34484 | 2003-10-31 | 2003-04-10 | Berman | Wayne L. | Berman Enterprises 5552 | 2003-04-10 | Berman Enterprises | 1800 K Street, N.W. | Suite 1124 | Washington | DC | 20006 |
36470 | 36470 | 1979-11-27 | 1977-06-06 | Berman | Alan | Alikonis, Robert John 2789 | 1977-06-06 | Alikonis, Robert John | 1629 K Street, N.W. | Suite 575 | Washington | DC | 20006 |
41486 | 41486 | 2006-12-31 | 2005-01-26 | Berman | Wayne L. | Federalist Group, an Ogilvy PR Worldwide Company 5628 | 2004-06-17 | Federalist Group, an Ogilvy PR Worldwide Company | 1331 H Street, N.W. | 12th Floor | Washington | DC | 20005 |
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]) );