FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Address_2 = "Suite 630"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Zip, Short_Form_Termination_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1070 | 1070 | 2019-05-21 | Harmer | Todd | American Defense International, Inc. 6567 | 2018-07-05 | American Defense International, Inc. | 100 New York Avenue, NW | Suite 630 | Washington | DC | 20005 | |
1358 | 1358 | 2018-07-05 | Herson | Michael | American Defense International, Inc. 6567 | 2018-07-05 | American Defense International, Inc. | 100 New York Avenue, NW | Suite 630 | Washington | DC | 20005 | |
1359 | 1359 | 2018-07-05 | Shindelman | Bonnie | American Defense International, Inc. 6567 | 2018-07-05 | American Defense International, Inc. | 100 New York Avenue, NW | Suite 630 | Washington | DC | 20005 | |
9507 | 9507 | 1979-03-09 | 1977-08-03 | Inoue | Hiro | Unicorp International, Inc. 2818 | 1977-08-03 | Unicorp International, Inc. | 4835 LBJ Freeway | Suite 630 | Dallas | TX | 75234 |
9508 | 9508 | 1979-03-09 | 1977-11-29 | Shaw | John F. | Unicorp International, Inc. 2818 | 1977-08-03 | Unicorp International, Inc. | 4835 LBJ Freeway | Suite 630 | Dallas | TX | 75234 |
17530 | 17530 | 2018-05-30 | 2017-05-31 | Brown | Cynthia | West Front Strategies, LLC 6436 | 2017-05-31 | West Front Strategies, LLC | 600 New Hampshire Avenue, NW | Suite 630 | Washington | DC | 20037 |
20261 | 20261 | 2018-06-25 | 2017-05-31 | Frushone | Ashley Davis | West Front Strategies, LLC 6436 | 2017-05-31 | West Front Strategies, LLC | 600 New Hampshire Avenue, NW | Suite 630 | Washington | DC | 20037 |
20262 | 20262 | 2018-06-25 | 2017-05-31 | McDaniel | Hammond Malloy | West Front Strategies, LLC 6436 | 2017-05-31 | West Front Strategies, LLC | 600 New Hampshire Avenue, NW | Suite 630 | Washington | DC | 20037 |
20263 | 20263 | 2018-06-25 | 2017-05-31 | Remington | Kristi L. | West Front Strategies, LLC 6436 | 2017-05-31 | West Front Strategies, LLC | 600 New Hampshire Avenue, NW | Suite 630 | Washington | DC | 20037 |
20264 | 20264 | 2018-06-25 | 2017-05-31 | Stein | Shimon | West Front Strategies, LLC 6436 | 2017-05-31 | West Front Strategies, LLC | 600 New Hampshire Avenue, NW | Suite 630 | Washington | DC | 20037 |
23030 | 23030 | 2019-07-12 | 2018-07-05 | Myers | David | American Defense International, Inc. 6567 | 2018-07-05 | American Defense International, Inc. | 100 New York Avenue, NW | Suite 630 | Washington | DC | 20005 |
25272 | 25272 | 2015-07-31 | 2013-07-09 | Fletcher | William | Fletcher Rowley, Inc. 6173 | 2013-07-09 | Fletcher Rowley, Inc. | 1720 West End Avenue | Suite 630 | Nashville | TN | 37203 |
25273 | 25273 | 2015-07-31 | 2013-07-09 | Morgan | Mark | Fletcher Rowley, Inc. 6173 | 2013-07-09 | Fletcher Rowley, Inc. | 1720 West End Avenue | Suite 630 | Nashville | TN | 37203 |
25274 | 25274 | 2015-07-31 | 2013-07-09 | Rowley | John | Fletcher Rowley, Inc. 6173 | 2013-07-09 | Fletcher Rowley, Inc. | 1720 West End Avenue | Suite 630 | Nashville | TN | 37203 |
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]) );