FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Registrant_Name = "Daniel J. Edelman, Inc.", "Short_Form_Termination_Date" is on date 2019-04-30 and State = "IL" sorted by Registrant_Name
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Date (date), Registration_Date (date)
State 1
- IL · 16 ✖
Registration_Number 1
Registrant_Name 1
- Daniel J. Edelman, Inc. · 16 ✖
City 1
- Chicago 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15141 | 15141 | 2019-04-30 | 2019-01-31 | Dhanaphatana | Sarah Kelly | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15142 | 15142 | 2019-04-30 | 2019-01-31 | Sklad | Amanda | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15149 | 15149 | 2019-04-30 | 2019-04-09 | Shepherd | Margaret | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15150 | 15150 | 2019-04-30 | 2019-04-18 | Nelson | Anna | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15151 | 15151 | 2019-04-30 | 2019-04-18 | Salloum | Amy | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15152 | 15152 | 2019-04-30 | 2019-04-23 | Pressler | Sarah | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15153 | 15153 | 2019-04-30 | 2018-04-27 | Walton | Laura | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15154 | 15154 | 2019-04-30 | 2018-04-27 | Workman | Daniel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15158 | 15158 | 2019-04-30 | 2019-05-07 | Bradley | Braden Todd | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15159 | 15159 | 2019-04-30 | 2019-05-14 | Mitra | Sujata | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15160 | 15160 | 2019-04-30 | 2019-05-14 | Williams | Lynnette Johnson | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15168 | 15168 | 2019-04-30 | 2019-08-01 | Sheffield III | Ralph Harrison | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15169 | 15169 | 2019-04-30 | 2019-08-01 | Warpinski | Joseph | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15170 | 15170 | 2019-04-30 | 2018-08-29 | Zuniga | Diane | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15176 | 15176 | 2019-04-30 | 2018-11-15 | Cloud | Bridget | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15177 | 15177 | 2019-04-30 | 2018-11-15 | Niadna | Kimberly Marie | 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]) );