FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Termination_Date" is on date 2015-05-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18131 | 18131 | 2015-05-31 | 2015-03-25 | Van De Wijs | Peter Paul | Outreach Strategies, LLC 6286 | 2015-03-25 | Outreach Strategies, LLC | 1001 Connecticut Avenue, NW | Suite 704 | Washington | DC | 20036 |
18132 | 18132 | 2015-05-31 | 2015-04-08 | Theuer | Christian | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18133 | 18133 | 2015-05-31 | 2015-04-08 | Wilson | Justin | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18134 | 18134 | 2015-05-31 | 2015-04-27 | Davenport | Rory | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18136 | 18136 | 2015-05-31 | 2014-05-23 | Gruaz | Huma | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18137 | 18137 | 2015-05-31 | 2013-06-17 | Getzug | Steve | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18138 | 18138 | 2015-05-31 | 2013-06-17 | Giordano | Natalie | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18139 | 18139 | 2015-05-31 | 2014-06-19 | Ayan | Hande | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18140 | 18140 | 2015-05-31 | 2014-06-19 | Finch | Kristy | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18141 | 18141 | 2015-05-31 | 2014-06-19 | Linehan | Madison | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18142 | 18142 | 2015-05-31 | 2014-06-19 | Pappas | George | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18143 | 18143 | 2015-05-31 | 2014-06-19 | Sahl | Audrey | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18144 | 18144 | 2015-05-31 | 2014-06-19 | Viggiano | David | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18145 | 18145 | 2015-05-31 | 2015-06-30 | Ryan | Garrett | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18146 | 18146 | 2015-05-31 | 2015-06-30 | Schaefer | Elizabeth | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18147 | 18147 | 2015-05-31 | 2015-06-30 | Stojanovic | Svjetlana | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18148 | 18148 | 2015-05-31 | 2015-06-30 | Yunlu | Melisa | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18150 | 18150 | 2015-05-31 | 2008-10-21 | Viney | Bill | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
18151 | 18151 | 2015-05-31 | 2014-11-14 | Colangelo | Lisa | Prime Policy Group 6263 | 2014-11-14 | Prime Policy Group | 1110 Vermont Avenue, NW | Suite 1000 | Washington | DC | 20005 |
18152 | 18152 | 2015-05-31 | 2014-11-14 | McQuillen | William | Prime Policy Group 6263 | 2014-11-14 | Prime Policy Group | 1110 Vermont Avenue, NW | Suite 1000 | Washington | DC | 20005 |
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]) );