FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_First_Name = "Michael" and State = "IL"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Registration_Date, Address_2, Short_Form_Date (date)
Registration_Number 8
Registrant_Name 8
City 3
- Chicago 11
- Bannockburn 4
- River Forest 1
State 1
- IL · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1232 | 1232 | 2012-06-14 | Conlon | Michael | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 | |
2993 | 2993 | 2017-01-01 | 2013-03-15 | Holland | Michael | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3491 | 3491 | 1996-01-09 | 1993-12-17 | Palaich | Michael | Global Enterprises Group, Inc. 4877 | 1993-12-17 | Global Enterprises Group, Inc. | 551 William Street | River Forest | IL | 60305 | |
6211 | 6211 | 2022-02-05 | 2020-01-27 | Love | Michael | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
9395 | 9395 | 1986-03-07 | 1983-08-10 | Kahn | Michael | Mandaback & Simms, Inc. 3507 | 1983-08-10 | Mandaback & Simms, Inc. | 111 North Canal Street | Chicago | IL | 60606 | |
12081 | 12081 | 2011-03-31 | 2011-03-24 | Holloway | Michael | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
20132 | 20132 | 1972-06-24 | 1971-07-16 | Howard | Michael | Jamaica Tourist Board, Chicago 2118 | 1968-12-16 | Jamaica Tourist Board, Chicago | 4655 S. Dr. Martin Luther King Drive | Suite 201 | Chicago | IL | 60653 |
21846 | 21846 | 2015-06-30 | 2020-08-06 | Johnston | Michael | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
21928 | 21928 | 2019-06-30 | 2019-05-24 | Arndt | Michael | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
22497 | 22497 | 2021-07-02 | 2018-09-27 | McGrath | Michael | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
24943 | 24943 | 1999-07-31 | 1997-06-12 | Jackson | Michael | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
25690 | 25690 | 2015-08-01 | 2013-03-15 | Marolla | Michael | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25697 | 25697 | 2015-08-01 | 2012-06-06 | Holloway | Michael | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
33278 | 33278 | 2020-10-20 | 2016-02-28 | Youash | Michael | Nineveh Plain Defense Fund 6339 | 2016-02-28 | Nineveh Plain Defense Fund | 6241 N. Talman Avenue | Chicago | IL | 60659 | |
41326 | 41326 | 2003-12-31 | 2001-08-02 | Mc Erlean | Michael | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
42432 | 42432 | 2022-12-31 | 2022-01-31 | Ford | Michael | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
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]) );