FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "Washington" and "Short_Form_Termination_Date" is on date 2018-09-30
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31623 | 31623 | 2018-09-30 | 2012-02-21 | Loeffler | Tom | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
31627 | 31627 | 2018-09-30 | 2018-03-09 | Cummings | Jennifer J. | Fratelli Group 5867 | 2008-06-03 | Fratelli Group | 1300 Connecticut Avenue, NW | Suite 950 | Washington | DC | 20036 |
31628 | 31628 | 2018-09-30 | 2017-03-10 | Kovalcin | Andrew Byron | Advanced Advocacy, LLC 6407 | 2017-03-10 | Advanced Advocacy, LLC | 1750 K Street, NW | Suite 1200 | Washington | DC | 20002 |
31630 | 31630 | 2018-09-30 | 2017-04-04 | Rosenberg | John | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | PO Box 25378 | Washington | DC | 20027 | |
31631 | 31631 | 2018-09-30 | 2018-04-11 | Klevorick | Caitlin Bender | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
31635 | 31635 | 2018-09-30 | 2018-05-09 | Aburish | Rania | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31636 | 31636 | 2018-09-30 | 2018-05-09 | Ennab | Georgei Bassam | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31637 | 31637 | 2018-09-30 | 2018-05-09 | Rashmawi | Janeen | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31638 | 31638 | 2018-09-30 | 2018-05-09 | Yaseen | Shirin | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31639 | 31639 | 2018-09-30 | 2018-05-09 | Zomlot | Husam | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31643 | 31643 | 2018-09-30 | 2012-05-21 | Takash | Hakam | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31648 | 31648 | 2018-09-30 | 2013-05-30 | Shamiya | Omar | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31651 | 31651 | 2018-09-30 | 2015-07-09 | Markland | Jared | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
31658 | 31658 | 2018-09-30 | 2017-10-06 | Sharon | Adam | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
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]) );