FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Short_Form_Termination_Date" is on date 2015-07-01
This data as json, CSV (advanced)
Suggested facets: Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22356 | 22356 | 2015-07-01 | 2013-01-30 | Tal | Ittai | World Zionist Organization - American Section, Inc. 2278 | 1971-09-21 | World Zionist Organization - American Section, Inc. | 633 Third Avenue | 21st Floor | New York | NY | 10017 |
22357 | 22357 | 2015-07-01 | 2013-02-28 | Hix | Dylan Benjamin | Wiley Rein, LLP 6108 | 2012-06-11 | Wiley Rein, LLP | 1776 K Street, NW | Washington | DC | 20006 | |
22358 | 22358 | 2015-07-01 | 2015-06-05 | Conover | David | DUTKO WORLDWIDE, LLC DBA GRAYLING 6270 | 2015-01-15 | DUTKO WORLDWIDE, LLC DBA GRAYLING | 100 M Street, SE | Suite 500 | Washington | DC | 20003 |
22359 | 22359 | 2015-07-01 | 2012-07-26 | Fitzgerald | Jayne | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
22360 | 22360 | 2015-07-01 | 2012-09-17 | Chin | Chee Weng Damian | 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 |
22361 | 22361 | 2015-07-01 | 2012-11-29 | Gamal | Islam | Commonwealth of Dominica Maritime Registry, Inc. 5334 | 1999-10-12 | Commonwealth of Dominica Maritime Registry, Inc. | 32 Washington Street | Fairhaven | MA | 02719 |
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]) );