FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "Washington", "Short_Form_Termination_Date" is on date 1988-06-30 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21078 | 21078 | 1988-06-30 | 1937-01-01 | III | Edgar F. Heiskell | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
21084 | 21084 | 1988-06-30 | 1988-04-11 | Beazer | Brian C. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21085 | 21085 | 1988-06-30 | 1988-04-11 | Davis | Smith W. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21086 | 21086 | 1988-06-30 | 1988-04-11 | DeBor | Marydale | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21087 | 21087 | 1988-06-30 | 1988-04-11 | Howard | Thomas | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21088 | 21088 | 1988-06-30 | 1988-04-11 | Jordan | Vernon E. , Jr. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21089 | 21089 | 1988-06-30 | 1988-04-11 | Long | Janis C. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21092 | 21092 | 1988-06-30 | 1988-04-13 | Digby | The Lord | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21096 | 21096 | 1988-06-30 | 1986-07-11 | Cooks | Shirley | South/North Development Group, Ltd. 3854 | 1986-07-11 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 | |
21097 | 21097 | 1988-06-30 | 1986-07-11 | Cooks | Stoney | South/North Development Group, Ltd. 3854 | 1986-07-11 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 | |
21098 | 21098 | 1988-06-30 | 1986-07-11 | II | Mitchell Dasher | South/North Development Group, Ltd. 3854 | 1986-07-11 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 | |
21100 | 21100 | 1988-06-30 | 1986-08-01 | Campbell | Anne D. | Mark A. Siegel & Associates, Inc. 3865 | 1986-08-01 | Mark A. Siegel & Associates, Inc. | 1030 - 15th Street, N.W. | Suite 408 | Washington | DC | 20005 |
21105 | 21105 | 1988-06-30 | 1986-10-15 | Mockler | James W. | South/North Development Group, Ltd. 3854 | 1986-07-11 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 | |
21106 | 21106 | 1988-06-30 | 1986-10-28 | Mumford | Danaia V. | South/North Development Group, Ltd. 3854 | 1986-07-11 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 |
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]) );