FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Short_Form_Termination_Date" is on date 1995-02-10
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6577 | 6577 | 1995-02-10 | 1994-02-17 | James | Claudia | Podesta Associates, Inc. 4894 | 1994-02-17 | Podesta Associates, Inc. | 1001 G Street, N.W. | Suite 900E | Washington | DC | 20001 |
6578 | 6578 | 1995-02-10 | 1994-02-17 | Kellermann | Carol | Podesta Associates, Inc. 4894 | 1994-02-17 | Podesta Associates, Inc. | 1001 G Street, N.W. | Suite 900E | Washington | DC | 20001 |
6579 | 6579 | 1995-02-10 | 1994-02-17 | Podesta | Anthony T. | Podesta Associates, Inc. 4894 | 1994-02-17 | Podesta Associates, Inc. | 1001 G Street, N.W. | Suite 900E | Washington | DC | 20001 |
6580 | 6580 | 1995-02-10 | 1992-04-30 | Wessendorf | Jill M. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
6581 | 6581 | 1995-02-10 | 1994-06-20 | Sullivan | Russell W. | Vinson & Elkins, L.L.P. 4921 | 1994-06-20 | Vinson & Elkins, L.L.P. | 1455 Pennsylvania Avenue, N.W. | Suite 700 | Washington | DC | 20004-1008 |
6582 | 6582 | 1995-02-10 | 1988-08-09 | Olea | Armando | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
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]) );