FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Registrant_Name = "Daniel J. Edelman, Inc." and "Short_Form_Date" is on date 2010-09-24 sorted by Short_Form_Last_Name
This data as json, CSV (advanced)
Suggested facets: Registration_Date (date)
State 1
- IL 10
Registration_Number 1
Registrant_Name 1
- Daniel J. Edelman, Inc. · 10 ✖
City 1
- Chicago 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25725 | 25725 | 2015-08-01 | 2010-09-24 | Bailey | Nathan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
34603 | 34603 | 2010-10-31 | 2010-09-24 | Capps | Jennifer | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25726 | 25726 | 2015-08-01 | 2010-09-24 | Church | Andrew | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25727 | 25727 | 2015-08-01 | 2010-09-24 | Gosbee | Jeremy K. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
31518 | 31518 | 2010-09-30 | 2010-09-24 | Kos | Abbey | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25728 | 25728 | 2015-08-01 | 2010-09-24 | McConville | Colin | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25729 | 25729 | 2015-08-01 | 2010-09-24 | McIntyre | William | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25249 | 25249 | 2014-07-31 | 2010-09-24 | Naim | Claudia | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
41720 | 41720 | 2010-12-31 | 2010-09-24 | O'Neill | Kevin | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25730 | 25730 | 2015-08-01 | 2010-09-24 | Tilley | Amy | 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]) );