FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Short_Form_Termination_Date = "2020-11-30" and State = "IL"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37141 | 37141 | 2020-11-30 | 2020-02-26 | Xi Choo | Traceline Cui | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37142 | 37142 | 2020-11-30 | 2020-03-20 | Gosbee | Jeremy | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37143 | 37143 | 2020-11-30 | 2018-03-26 | Murtha | Chelsea | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 540 North Lincoln Street | Hinsdale | IL | 60521 | |
37144 | 37144 | 2020-11-30 | 2020-03-30 | Chaquette | Margaret | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37145 | 37145 | 2020-11-30 | 2020-04-02 | Laws | George Benjamin | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37149 | 37149 | 2020-11-30 | 2014-04-18 | Neumann | Daniel | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 540 North Lincoln Street | Hinsdale | IL | 60521 | |
37150 | 37150 | 2020-11-30 | 2008-04-25 | Sorini | Ronald J. | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 540 North Lincoln Street | Hinsdale | IL | 60521 | |
37154 | 37154 | 2020-11-30 | 2020-07-13 | Rayden | Max | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37157 | 37157 | 2020-11-30 | 2019-09-11 | Chan | Simon Si Ho | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37158 | 37158 | 2020-11-30 | 2019-09-11 | Lau | Yin Ting Tiffany | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37159 | 37159 | 2020-11-30 | 2019-09-11 | Warr | Adrian Hedley | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37160 | 37160 | 2020-11-30 | 2019-09-13 | Yan Chong | Vivian Lok | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37161 | 37161 | 2020-11-30 | 2020-09-14 | Yu | Andrea | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37162 | 37162 | 2020-11-30 | 2020-09-16 | Sing | Chan Chee | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37163 | 37163 | 2020-11-30 | 2019-10-02 | McCabe | Ian Richard | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37164 | 37164 | 2020-11-30 | 2019-10-17 | Donahoe | Christopher Rayburn | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37165 | 37165 | 2020-11-30 | 2019-11-07 | Young | Maxwell Harvey | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37166 | 37166 | 2020-11-30 | 2019-11-15 | Jayasinghe | Tamani Neshika | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37167 | 37167 | 2020-11-30 | 2019-11-15 | Platz | Jesse | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
37168 | 37168 | 2020-11-30 | 2019-11-22 | Roddy | Katherine | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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]) );