FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Short_Form_Date" is on date 2019-12-20
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_2, Short_Form_Date (date)
Registration_Number 5
Registrant_Name 5
City 5
- Arlington 2
- New York 2
- Washington 2
- Des Moines 1
- Houston 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6640 | 6640 | 2020-02-11 | 2019-12-20 | Cafiero | Giorgio | Gulf State Analytics 6773 | 2019-12-20 | Gulf State Analytics | 1112 M Street, NW | Suite 208 | Washington | DC | 20005 |
6641 | 6641 | 2020-02-11 | 2019-12-20 | Karasik | Theodore | Gulf State Analytics 6773 | 2019-12-20 | Gulf State Analytics | 1112 M Street, NW | Suite 208 | Washington | DC | 20005 |
14161 | 14161 | 2022-04-26 | 2019-12-20 | Slaven | Quinn | Larson Shannahan Slifka Group, LLC 6749 | 2019-11-12 | Larson Shannahan Slifka Group, LLC | 510 E. Locust Street | Suite 200 | Des Moines | IA | 50309 |
15546 | 15546 | 2021-05-01 | 2019-12-20 | Hutton | Michael | Hutton-Transcon Joint Venture 6774 | 2019-12-20 | Hutton-Transcon Joint Venture | 1001 19th Street N | Suite 2000 | Arlington | VA | 22209 |
35392 | 35392 | 2020-11-07 | 2019-12-20 | Siddique | Osman | Hutton-Transcon Joint Venture 6774 | 2019-12-20 | Hutton-Transcon Joint Venture | 1001 19th Street N | Suite 2000 | Arlington | VA | 22209 |
38533 | 38533 | 2020-12-16 | 2019-12-20 | Alshammari | Mohammad S. | Aramco Affiliated Services Company (AASC) 6390 | 2016-11-14 | Aramco Affiliated Services Company (AASC) | Two Allen Center | 1200 Smith Street, 36th Floor | Houston | TX | 77002 |
42363 | 42363 | 2020-12-31 | 2019-12-20 | Levin | Lori | Rubenstein Public Relations, Inc. 6691 | 2019-06-14 | Rubenstein Public Relations, Inc. | 1301 Avenue of the Americas | New York | NY | 10019 | |
42364 | 42364 | 2020-12-31 | 2019-12-20 | Mclaughlin | Christina Levin | Rubenstein Public Relations, Inc. 6691 | 2019-06-14 | Rubenstein Public Relations, Inc. | 1301 Avenue of the Americas | New York | NY | 10019 |
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]) );