FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "House"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13750 | 13750 | 1991-04-19 | 1988-09-02 | House | Michael | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | 2300 N Street, N.W. | Washington | DC | 20037-1128 | |
21546 | 21546 | 2005-06-30 | 2005-08-22 | House | Michael P. | McDermott Will & Emery, LLP 5686 | 2005-05-23 | McDermott Will & Emery, LLP | 600 13th Street, NW | Washington | DC | 20005 | |
22434 | 22434 | 1981-07-02 | 1981-07-02 | House | William A. | Cooperative Association of Professionals, Inc. 3255 | 1981-07-02 | Cooperative Association of Professionals, Inc. | 100 Renaissance Center | Suite 2412 | Detroit | MI | 48243 |
22435 | 22435 | 1981-07-02 | 1981-07-02 | House | William A. | Dike Motor Company, Ltd. 3256 | 1981-07-02 | Dike Motor Company, Ltd. | 100 Renaissance Center | Suite 2412 | Detroit | MI | 48243 |
28303 | 28303 | 1997-08-31 | 1992-03-18 | House | W. Michael | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28630 | 28630 | 2017-08-31 | 2014-05-30 | House | W. Michael | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
31030 | 31030 | 1988-09-30 | 1981-11-17 | House | Deborah M. | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | 805 - 15th Street, N.W, | Suite 900 | Washington | DC | 20005 |
34809 | 34809 | 1960-11-01 | 1951-05-02 | House | Robert Burton , Jr. | Cummings, Sellers, Reeves & Conner 420 | 1947-01-09 | Cummings, Sellers, Reeves & Conner | 1616 K Street, N.W. | Washington | DC |
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]) );