FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Short_Form_Date" is on date 2014-08-19
This data as json, CSV (advanced)
Suggested facets: Address_2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1631 | 1631 | 2014-08-19 | Ohara | Noriko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
15075 | 15075 | 2015-04-30 | 2014-08-19 | Christie | Katherine | Global Communicators, LLC 6243 | 2014-08-19 | Global Communicators, LLC | 1875 I Street. NW | Suite 500 | Washington | DC | 20006 |
15076 | 15076 | 2015-04-30 | 2014-08-19 | Harff | James W. | Global Communicators, LLC 6243 | 2014-08-19 | Global Communicators, LLC | 1875 I Street. NW | Suite 500 | Washington | DC | 20006 |
27026 | 27026 | 2014-08-19 | 2014-08-19 | Wariyo | Bekele Wayu | Sidama National Democratic Movement (SNDM) 6246 | 2014-08-19 | Sidama National Democratic Movement (SNDM) | 806B Kennedy St., NW | Washington | DC | 20011 | |
27816 | 27816 | 2017-08-30 | 2014-08-19 | Chidlow | Carl D. | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | Washington | DC | 20004 |
27817 | 27817 | 2017-08-30 | 2014-08-19 | Hickman | Chelsey Penrod | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | Washington | DC | 20004 |
27818 | 27818 | 2017-08-30 | 2014-08-19 | Merola | Michael Alfonso | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | Washington | DC | 20004 |
27819 | 27819 | 2017-08-30 | 2014-08-19 | Mullins | Donna Frances | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | Washington | DC | 20004 |
28619 | 28619 | 2016-08-31 | 2014-08-19 | Zucker | Robert Benjamin | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | Washington | DC | 20004 |
41961 | 41961 | 2014-12-31 | 2014-08-19 | Heimov | Brett | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | 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]) );