FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Davenport"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2850 | 2850 | 2007-01-01 | 2006-09-19 | Davenport | Rory | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
10980 | 10980 | 2005-03-28 | 2005-01-05 | Davenport | Rory | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11546 | 11546 | 1986-03-31 | 1981-03-17 | Davenport | Luther M. | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
12129 | 12129 | 2013-03-31 | 2007-05-07 | Davenport | Rory | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
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 |
22777 | 22777 | 1993-07-08 | 1979-11-23 | Davenport | James C. | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | 655 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
28483 | 28483 | 2006-08-31 | 2005-09-26 | Davenport | Maureen | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
29242 | 29242 | 2002-09-05 | 2000-03-10 | Davenport | Rory | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
39434 | 39434 | 2002-12-30 | 2002-05-13 | Davenport | Doug | DCI Group, L.L.C. 5497 | 2002-05-13 | DCI Group, L.L.C. | Two Lafayette Square | 1133 21st Street, N.W., Suite M100 | Washington | DC | 20036 |
41599 | 41599 | 2007-12-31 | 2007-12-31 | Davenport | Jim | Alcalde and Fay 5844 | 2007-12-31 | Alcalde and Fay | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
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]) );