FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
3 rows where Short_Form_Termination_Date = "2008-09-12"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
Registration_Number 3
Registrant_Name 3
City 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29647 | 29647 | 2008-09-12 | 2007-03-08 | Colvin | Adam R. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
29648 | 29648 | 2008-09-12 | 2007-06-13 | Prioleau | Florence W. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
29649 | 29649 | 2008-09-12 | 2007-11-02 | Woolley | Jessica S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 |
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]) );