FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Date" is on date 2009-02-27
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7230 | 7230 | 2013-02-18 | 2009-02-27 | Chiu | Dannie Nagm | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
10989 | 10989 | 2013-03-28 | 2009-02-27 | Thompson | Scott C. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21627 | 21627 | 2009-06-30 | 2009-02-27 | Hannaford | Peter D. | Pepperwood International Corp. 5912 | 2009-02-27 | Pepperwood International Corp. | 3555 J Street | Eureka | CA | 95503-5419 | |
21628 | 21628 | 2009-06-30 | 2009-02-27 | Spinck | Darren | Pepperwood International Corp. 5912 | 2009-02-27 | Pepperwood International Corp. | 3555 J Street | Eureka | CA | 95503-5419 | |
25141 | 25141 | 2009-07-31 | 2009-02-27 | Donaldson | Nancy | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
25142 | 25142 | 2009-07-31 | 2009-02-27 | Dorton | Patrick | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
25143 | 25143 | 2009-07-31 | 2009-02-27 | Korkoian | David J. | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
25144 | 25144 | 2009-07-31 | 2009-02-27 | McKew | Molly M. | KRL International, LLC 5788 | 2007-01-26 | KRL International, LLC | 6682 Van Winkle Drive | Falls Church | VA | 22044 | |
25145 | 25145 | 2009-07-31 | 2009-02-27 | Painter | Sally A. | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
25146 | 25146 | 2009-07-31 | 2009-02-27 | Tramontano | Karen A. | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
41811 | 41811 | 2012-12-31 | 2009-02-27 | O'Connell | Janice M. | Gephardt Group Government Affairs, LLC 5874 | 2008-07-21 | Gephardt Group Government Affairs, LLC | 1667 K Street, NW | Suite 800 | 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]) );