FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where City = "Washington", "Short_Form_Termination_Date" is on date 2004-10-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34509 | 34509 | 2004-10-31 | 2003-03-03 | Brock | William E. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34512 | 34512 | 2004-10-31 | 2000-06-23 | Ray | John L. | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 700 12th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
34521 | 34521 | 2004-10-31 | 2002-08-12 | Ang | Tina Bee Geok | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 700 12th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
34523 | 34523 | 2004-10-31 | 2004-10-29 | Blalock | Kirk | Fierce, Isakowitz & Blalock 5654 | 2004-10-29 | Fierce, Isakowitz & Blalock | 600 New Hampshire Avenue, N.W. | Suite 1000 | Washington | DC | 20037 |
34524 | 34524 | 2004-10-31 | 2002-12-06 | Jonas | W. James III | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
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]) );