FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Short_Form_Termination_Date" is on date 2006-10-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34535 | 34535 | 2006-10-31 | 2004-05-25 | Bedolla | Leon F. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34536 | 34536 | 2006-10-31 | 2004-05-25 | Murfin | Cecilia | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34537 | 34537 | 2006-10-31 | 2004-05-25 | Olguin | Adhemir | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34538 | 34538 | 2006-10-31 | 2005-06-10 | Bradshaw | Kimberlee M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34539 | 34539 | 2006-10-31 | 2006-08-02 | Saunders | Katherine | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34542 | 34542 | 2006-10-31 | 2004-09-28 | Maric | Zorica | Republic of Montenegro Trade Mission to the U.S. of America 5199 | 1997-08-04 | Republic of Montenegro Trade Mission to the U.S. of America | 1610 New Hampshire Avenue, NW | Washington | DC | 20009 | |
34549 | 34549 | 2006-10-31 | 2005-10-28 | Merola | Barbara F. | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
34550 | 34550 | 2006-10-31 | 2006-10-31 | Bentkowski | David Anthony | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
34551 | 34551 | 2006-10-31 | 2006-10-31 | Bickford | Frank | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
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]) );