FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where "Short_Form_Termination_Date" is on date 2018-08-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_2, Zip
Registration_Number 10
Registrant_Name 10
City 4
- New York 20
- Washington 5
- Overland Park 1
- Rockville 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28633 | 28633 | 2018-08-31 | 2018-01-01 | Arevalo | Erika | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
28634 | 28634 | 2018-08-31 | 2014-03-06 | Novick | Joshua | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
28635 | 28635 | 2018-08-31 | 2018-03-19 | Singleton | McAllister | Husch Blackwell Strategies, LLC 6517 | 2018-02-02 | Husch Blackwell Strategies, LLC | 300 M Street, SE | Suite 402 | Washington | DC | 20003 |
28636 | 28636 | 2018-08-31 | 2018-05-09 | Bine | David | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28637 | 28637 | 2018-08-31 | 2018-05-09 | Eselevsky | Hayley | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28638 | 28638 | 2018-08-31 | 2018-05-09 | Haimes | Deborah | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28639 | 28639 | 2018-08-31 | 2018-05-09 | Jones | Jeff | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28640 | 28640 | 2018-08-31 | 2018-05-09 | Patterson | Camille Palo | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28641 | 28641 | 2018-08-31 | 2018-05-24 | Gilster | Kyle | Husch Blackwell Strategies, LLC 6517 | 2018-02-02 | Husch Blackwell Strategies, LLC | 300 M Street, SE | Suite 402 | Washington | DC | 20003 |
28642 | 28642 | 2018-08-31 | 2017-06-19 | Lisa | Gregory C. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28643 | 28643 | 2018-08-31 | 2018-06-29 | Hung | Asher | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
28644 | 28644 | 2018-08-31 | 2015-08-04 | Jalabi | Mariam | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | |
28645 | 28645 | 2018-08-31 | 2017-09-14 | Don | Matthew | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28646 | 28646 | 2018-08-31 | 2017-09-14 | Garrett | Stuart | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28647 | 28647 | 2018-08-31 | 2017-09-14 | Katz | Phillip | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28648 | 28648 | 2018-08-31 | 2017-09-14 | Mitchell | Catherine Downes | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28649 | 28649 | 2018-08-31 | 2017-09-14 | Pathiyil | Amy J. | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28650 | 28650 | 2018-08-31 | 2017-09-14 | Peplov | Artem | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28651 | 28651 | 2018-08-31 | 2017-09-14 | Rakos | Patricia | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28652 | 28652 | 2018-08-31 | 2017-09-14 | Tellup | Michael | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28653 | 28653 | 2018-08-31 | 2017-09-14 | Waldner | Robert | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28654 | 28654 | 2018-08-31 | 2017-09-14 | Williams | Kali | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28655 | 28655 | 2018-08-31 | 2017-09-14 | Zahir | Mike | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28656 | 28656 | 2018-08-31 | 2014-09-24 | Tashi | Kunga | Office of Tibet 1699 | 1964-03-14 | Office of Tibet | 1228 17th Street, NW | Washington | DC | 20036 | |
28657 | 28657 | 2018-08-31 | 2012-09-28 | Michaelson | Martin | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28658 | 28658 | 2018-08-31 | 2017-11-03 | Warzala | Jared | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
28659 | 28659 | 2018-08-31 | 2017-12-11 | Yazlovsky | Alex | RTTV America, Inc. 6496 | 2017-12-11 | RTTV America, Inc. | 9710 Traville Gateway Drive | #363 | Rockville | MD | 20850 |
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]) );