FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 2015-07-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25260 | 25260 | 2015-07-31 | 2004-03-16 | Aulakh | Gurmit Singh | Council of Khalistan 5597 | 2004-01-21 | Council of Khalistan | 730 24th Street, N.W. | Suite 310 | Washington | DC | 20037 |
25262 | 25262 | 2015-07-31 | 2015-03-25 | Norton | Ruya | Outreach Strategies, LLC 6286 | 2015-03-25 | Outreach Strategies, LLC | 1001 Connecticut Avenue, NW | Suite 704 | Washington | DC | 20036 |
25264 | 25264 | 2015-07-31 | 2015-04-23 | Goss | Porter | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
25267 | 25267 | 2015-07-31 | 2018-05-23 | Sarhan | Salah | Arab Information Center 876 | 1955-03-03 | Arab Information Center | League of Arab States | 1100 17th Street, N.W., Suite 201 | Washington | DC | 20036 |
25269 | 25269 | 2015-07-31 | 2015-06-22 | Eymond-Laritaz | Thomas | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25270 | 25270 | 2015-07-31 | 2015-06-22 | King | Richard | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25275 | 25275 | 2015-07-31 | 2014-10-03 | Carrier | Jennifer | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
25276 | 25276 | 2015-07-31 | 2014-10-03 | Thompson | David | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
25278 | 25278 | 2015-07-31 | 2013-10-18 | Brophy | Susan | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
25280 | 25280 | 2015-07-31 | 2013-10-30 | El-Haj | Amara | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
25281 | 25281 | 2015-07-31 | 2015-11-05 | Patch | Alison | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
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]) );