FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Short_Form_Date = "2017-09-28"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date)
Registration_Number 4
Registrant_Name 4
City 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1861 | 1861 | 2017-09-28 | Chew | Brandon Wei Yang | 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 | |
1862 | 1862 | 2017-09-28 | Fleming | Patrick | S.G.R. LLC Government Relations and Lobbying 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | 1775 Eye Street, NW | Suite 410 | Washington | DC | 20006 | |
1863 | 1863 | 2017-09-28 | Kwok | Eugene Jin Liang | 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 | |
12602 | 12602 | 2020-04-01 | 2017-09-28 | Coen | Mary Lisbeth | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 1627 I Street, NW | Suite 825 | Washington | DC | 20006 |
12603 | 12603 | 2020-04-01 | 2017-09-28 | Cummins | Harry | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 1627 I Street, NW | Suite 825 | Washington | DC | 20006 |
12604 | 12604 | 2020-04-01 | 2017-09-28 | Estopinan | Arturo A. | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 1627 I Street, NW | Suite 825 | Washington | DC | 20006 |
24118 | 24118 | 2019-07-26 | 2017-09-28 | Cpin | John | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 1627 I Street, NW | Suite 825 | Washington | DC | 20006 |
32646 | 32646 | 2021-10-11 | 2017-09-28 | Joshi | Saurabh | 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 |
38188 | 38188 | 2017-12-12 | 2017-09-28 | Gittleman | Richard | RMG Africa Advisors, LLC 6470 | 2017-09-28 | RMG Africa Advisors, LLC | P.O. Box 1 | Newton Upper Falls | MA | 02464 |
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]) );