FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Short_Form_Termination_Date" is on date 2007-06-30
This data as json, CSV (advanced)
Suggested facets: Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21586 | 21586 | 2007-06-30 | 2007-04-11 | Ward | Laura Celeste J. | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
21587 | 21587 | 2007-06-30 | 2007-05-18 | Baierlein | Daniele | Podesta Group, Inc. 5813 | 2007-05-18 | Podesta Group, Inc. | 1001 G Street, NW | Suite 900 East | Washington | DC | 20001 |
21588 | 21588 | 2007-06-30 | 2007-05-18 | Bianchetti | Thomas | Podesta Group, Inc. 5813 | 2007-05-18 | Podesta Group, Inc. | 1001 G Street, NW | Suite 900 East | Washington | DC | 20001 |
21589 | 21589 | 2007-06-30 | 2007-05-18 | Fritts | Kimberley | Podesta Group, Inc. 5813 | 2007-05-18 | Podesta Group, Inc. | 1001 G Street, NW | Suite 900 East | Washington | DC | 20001 |
21590 | 21590 | 2007-06-30 | 2007-05-18 | Podesta | Anthony T. | Podesta Group, Inc. 5813 | 2007-05-18 | Podesta Group, Inc. | 1001 G Street, NW | Suite 900 East | Washington | DC | 20001 |
21591 | 21591 | 2007-06-30 | 1977-05-23 | Raeymaekers | Frederique | Belgian National Tourist Office 529 | 1948-06-17 | Belgian National Tourist Office | 300 East 42nd Street | 14th Floor | New York | NY | 10017 |
21592 | 21592 | 2007-06-30 | 2004-07-16 | Hudome | Randa Fahmy | Fahmy Hudome International, LLC 5632 | 2004-07-16 | Fahmy Hudome International, LLC | 888 17th Street, NW | Suite 904 | Washington | DC | 20006 |
21593 | 21593 | 2007-06-30 | 2005-07-21 | Delaney | Timothy | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21594 | 21594 | 2007-06-30 | 2003-08-13 | Lee | Lansing B. III | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21595 | 21595 | 2007-06-30 | 2004-08-17 | Liston | Leah | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21596 | 21596 | 2007-06-30 | 2002-09-19 | Long | Abd. Talib HJ. | Malaysia Tourism Promotion Board 2510 | 1974-04-17 | Malaysia Tourism Promotion Board | 818 West Seventh Street | Suite 970 | Los Angeles | CA | 90017-3432 |
21597 | 21597 | 2007-06-30 | 2006-10-31 | Arno | Michael | Capitol Links LLC 5761 | 2006-06-27 | Capitol Links LLC | 1300 Pennsylvania Avenue, NW | Suite 700 | Washington | DC | 20004 |
21598 | 21598 | 2007-06-30 | 2006-10-31 | Minjack | Gregory | Capitol Links LLC 5761 | 2006-06-27 | Capitol Links LLC | 1300 Pennsylvania Avenue, NW | Suite 700 | Washington | DC | 20004 |
21599 | 21599 | 2007-06-30 | 2006-12-08 | Courtovich | James C. | Kearsarge Global Advisors 5780 | 2006-12-08 | Kearsarge Global Advisors | 815 Slaters Lane | Alexandria | VA | 22314 | |
21600 | 21600 | 2007-06-30 | 2006-12-08 | McNabb | Sean A. | Kearsarge Global Advisors 5780 | 2006-12-08 | Kearsarge Global Advisors | 815 Slaters Lane | Alexandria | VA | 22314 |
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]) );