FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Short_Form_Termination_Date" is on date 2018-09-30 sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date (date)
Short_Form_First_Name >30 ✖
- Adam 1
- Aftab 1
- Ahsan 1
- Ali Asim 1
- Andrew Byron 1
- Bradley 1
- Brendan 1
- Caitlin Bender 1
- Choon Hua Simon 1
- Faisal 1
- Georgei Bassam 1
- Hagar Hajjar 1
- Hakam 1
- Hamad 1
- Husam 1
- Imtiaz 1
- Imtiaz A 1
- Janeen 1
- Jared 1
- Jennifer J. 1
- John 1
- Kulsoom Ali 1
- Kun Long John 1
- Melanie 1
- Mian 1
- Mohammad 1
- Muhammad Saeed 1
- Nick 1
- Omar 1
- Parvez 1
- …
Registration_Number 12
- PTI USA, LLC 18
- General Delegation of the PLO to the US 8
- Reputation Partners, LLC 3
- Singapore Economic Development Board 2
- Media Planning International Corporation 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Harbour Group, LLC 1
- Fratelli Group 1
- Mercury Public Affairs, LLC 1
- Greenwich Media Strategies, LLC 1
- Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 1
- Advanced Advocacy, LLC 1
Registrant_Name 12
- PTI USA, LLC 18
- General Delegation of the PLO to the US 8
- Reputation Partners, LLC 3
- Media Planning International Corporation 2
- Singapore Economic Development Board 2
- Advanced Advocacy, LLC 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Fratelli Group 1
- Greenwich Media Strategies, LLC 1
- Harbour Group, LLC 1
- Mercury Public Affairs, LLC 1
- Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 1
City 5
- Chino Hills 18
- Washington 14
- New York 4
- Chicago 3
- Greenwich 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31632 | 31632 | 2018-09-30 | 2015-04-21 | Phua | Choon Hua Simon | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
31633 | 31633 | 2018-09-30 | 2016-04-25 | Eng | Kun Long John | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
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 | |
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 |
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 |
31624 | 31624 | 2018-09-30 | 2017-02-23 | Burki | Sajjad I | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31625 | 31625 | 2018-09-30 | 2017-02-23 | Irshad | Faisal | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31626 | 31626 | 2018-09-30 | 2017-02-23 | Syed | Kulsoom Ali | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31629 | 31629 | 2018-09-30 | 2013-03-29 | Razaq | Mohammad | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31634 | 31634 | 2018-09-30 | 2013-05-02 | Khan | Sherry | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31644 | 31644 | 2018-09-30 | 2018-05-24 | Chaudhary | Muhammad Saeed | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31645 | 31645 | 2018-09-30 | 2018-05-24 | Majeed | Tariq | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31646 | 31646 | 2018-09-30 | 2018-05-24 | Naveed | Rasjod | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31647 | 31647 | 2018-09-30 | 2018-05-24 | Riaz | Parvez | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31649 | 31649 | 2018-09-30 | 2018-06-05 | Ali | Imtiaz | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31650 | 31650 | 2018-09-30 | 2018-06-05 | Syed | Imtiaz A | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31652 | 31652 | 2018-09-30 | 2018-07-09 | Ahmed | Mian | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31653 | 31653 | 2018-09-30 | 2018-07-09 | Azam | Hamad | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31654 | 31654 | 2018-09-30 | 2018-07-09 | Maqsood | Ahsan | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31659 | 31659 | 2018-09-30 | 2014-10-18 | Hussain | Aftab | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31660 | 31660 | 2018-09-30 | 2014-10-18 | Khan | Ali Asim | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31661 | 31661 | 2018-09-30 | 2018-10-19 | Khan | Umer | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
31662 | 31662 | 2018-09-30 | 2016-10-29 | Khan | Qamar Zaman | PTI USA, LLC 6160 | 2013-03-29 | PTI USA, LLC | 16599 Vellano Club Drive | Chino Hills | CA | 91709 | |
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 |
31657 | 31657 | 2018-09-30 | 2016-09-23 | Chemali | Hagar Hajjar | Greenwich Media Strategies, LLC 6380 | 2016-09-23 | Greenwich Media Strategies, LLC | 617 Round Hill | Greenwich | CT | 06831 | |
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 | |
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 |
31640 | 31640 | 2018-09-30 | 2018-05-14 | Carlson | Bradley | Reputation Partners, LLC 6556 | 2018-05-14 | Reputation Partners, LLC | 30 West Monroe Street | Suite 1410 | Chicago | IL | 60603 |
31641 | 31641 | 2018-09-30 | 2018-05-14 | Griffith | Brendan | Reputation Partners, LLC 6556 | 2018-05-14 | Reputation Partners, LLC | 30 West Monroe Street | Suite 1410 | Chicago | IL | 60603 |
31642 | 31642 | 2018-09-30 | 2018-05-14 | Kalm | Nick | Reputation Partners, LLC 6556 | 2018-05-14 | Reputation Partners, LLC | 30 West Monroe Street | Suite 1410 | Chicago | IL | 60603 |
31655 | 31655 | 2018-09-30 | 2019-07-30 | Gonzalez | Sara | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
31656 | 31656 | 2018-09-30 | 2019-07-30 | Pudles | Melanie | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
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]) );