List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

1,487 rows where State = "IL"

View and edit SQL

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

  • IL · 1,487
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
17     Murtha Chelsea 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
21     Reiss Kokja Alexander 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
26     Sorini Ronald 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
116   2017-01-17 Jalaludin Faizal 2331 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1515 Chicago IL 60611
178   2020-01-27 Love Michael 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
179   2020-01-27 Singh Nirmala 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
181   2020-01-27 Yohannan Calvin 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
203   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
333   2020-02-14 Lamb Megan Josephine 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
404   2021-02-26 Millard Rachel Louise 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
405   2021-02-26 Sofo Julia 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
410   2016-02-28 David Alex 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
411   2016-02-28 Patto Susan 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
412   2016-02-28 Yaco Yacob G. 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
413   2016-02-28 Youash Michael 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
425   2021-03-02 Shutler Mackenzie 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
486   2020-03-11 McBrayer Kaitlyn Jane 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
488   2020-03-11 Sullivan Jr Jere Jerome 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
492   2015-03-12 Reid Mark 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
515   2021-03-16 Bledsoe Paul W. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
548   2020-03-20 Pervazova Iana Andrianova 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
560   2020-03-23 Faunce Alexis Falon 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
577   2013-03-26 Stevenson Naoko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
584   2018-03-27 Hashimoto Tsubasa 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
606   2020-03-30 Nishizawa Tomofumi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
642   2000-04-05 Inforzato Ralph 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
696   2006-04-14 Kingham Niahm 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
719   2020-04-16 Naik Ojas 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
754   2019-04-22 Insinga Mary 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
755   2019-04-22 Thiele Tracey 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
756   2019-04-22 Tovar Jesus Salvador 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
811   2020-04-29 Corlies Charissa 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
971   2019-05-28 Cook Meghan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
973   2019-05-28 Morley Jason 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
974   2019-05-28 Nook Emma 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
996   2020-05-29 Hendrix Caroline 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
997   2020-05-29 Howard Khalig 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1004   2020-05-29 Werken Don van de 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1039   2015-06-08 Sedlmayer Peter D. 6193 6193 2013-11-04 Austrian Trade Commission, Chicago 500 N. Michigan Avenue Suite 1950 Chicago IL 60611
1052   2020-06-09 Vakili Aryan Zandieh 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
1068   2019-06-12 Condon Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1072   2012-06-14 Conlon Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1100   2020-06-23 Restieri Jenna 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1203   2010-07-13 Mallaghan Aine 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1281   2020-07-29 Gustafson Christopher 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1294   2020-07-30 Busch Patricia 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1295   2020-07-30 Hainline Ian Adrian 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1296   2020-07-30 Holland Kent 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1297   2020-07-30 Reese Joel 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1298   2020-07-30 Scherrman Molly 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1299   2020-07-30 Sedler Eric 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1350   2017-08-13 Siddiqui Adnan M. 6454 6454 2017-08-13 MQM International, Inc. (Muttahida Quami Movement) 433 W Harrison Street Box #6720 Chicago IL 60699
1377   2020-08-19 Dingwell Makena 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1382   2020-08-20 Riffat Mustafa 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1387   2020-08-21 Roesler Carolina Leighton 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1388   2020-08-21 Tendler Chad 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1400   2019-08-26 Salerno Laura 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1465   2019-09-10 Ortiz Mileska 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1475   2017-09-12 Jamali Wakel A 6454 6454 2017-08-13 MQM International, Inc. (Muttahida Quami Movement) 433 W Harrison Street Box #6720 Chicago IL 60699
1482   2020-09-14 Abi Saleh Doreen Antoine 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1483   2020-09-14 De Pauw Kenneth Jean Jules 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1484   2020-09-14 Hand Seth Michael 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1485   2020-09-14 Melissa Leung On Ki 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1487   2020-09-14 Qirem Omar 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1493   2020-09-16 Simmons Alex 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1529   2019-09-23 Buehler Kai 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
1530   2020-09-23 AL Daqqaq Mohammed Moneer Mahmoud 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1536   2020-09-24 Bowen Matthew 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1539   2018-09-25 Kamimura Makoto 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1540   2018-09-25 Ogawa Yumeko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1550   2016-09-27 Kawachi Akira 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1551   2018-09-27 Conness Devan 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1553   2018-09-27 Hunter Kevin 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1554   2018-09-27 McCrossan Patrick 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1555   2018-09-27 McGrath Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1557   2018-09-27 Serpa Michelle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1558   2018-09-27 Trengrove Christopher 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1560   2019-09-27 Platz Eva 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
1577   2019-09-30 Fujimoto Fujio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1585   2020-10-01 Krishnamoorthy Vinod 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1586   2020-10-01 Panicker Siddharth Prakash 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1587   2020-10-01 Sinha Deepshikha 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1595   2020-10-02 Rangarajan Vasudevan 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1608   2019-10-07 Calabro Renee 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1682   2019-10-17 Neary Sean 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1704   2019-10-22 Hamilton Casey 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1721   2017-10-23 Sattar Muhammad Farooq 6454 6454 2017-08-13 MQM International, Inc. (Muttahida Quami Movement) 433 W Harrison Street Box #6720 Chicago IL 60699
1725   2019-10-24 Salazar Mia 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1752   2019-10-28 Blodgett John Monroe 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1753   2019-10-28 Sanchez Mercedes 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1825   2020-11-06 Esparza Blanco Yazmine M. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1827   2019-11-07 Cruz Shileen 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1829   2019-11-07 Pomatto Hannah 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1837   2020-11-10 Connolly Kathy 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1839   2020-11-10 McKeown Claire 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1850   2018-11-12 O'Rourke Matthew 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1863   2018-11-13 Murray Debora Comenalli 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1936   2020-11-23 Willner Sean Thomas 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1944   2019-11-26 Donovan Cecily 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1945   2019-11-26 Emhardt Kathryn 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);