FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Short_Form_Date = "2017-09-14"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1773 | 1773 | 2017-09-14 | Lockhart | Elizabeth | Beef + Lamb New Zealand, Ltd. 2526 | 1974-07-08 | Beef + Lamb New Zealand, Ltd. | 6841 Elm Street | #7401 | McLean | VA | 22106 | |
7488 | 7488 | 2018-02-23 | 2017-09-14 | Quan | Renee | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
16686 | 16686 | 2018-05-18 | 2017-09-14 | Abueva | Jerone | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
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 |
29781 | 29781 | 2018-09-14 | 2017-09-14 | Buchan | Debbie | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
30245 | 30245 | 2018-09-21 | 2017-09-14 | Kunze | Amanda | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
32294 | 32294 | 2019-10-04 | 2017-09-14 | Golin-Blaugrund | Bari | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
33442 | 33442 | 2018-10-22 | 2017-09-14 | Becker | David C. | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
38851 | 38851 | 2017-12-20 | 2017-09-14 | Hisler | Rebecca | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
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]) );