FARA_All_ShortForms

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,236 rows where City = "Chicago"

View and edit SQL

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

Registration_Number

State

  • IL 1,236

City

  • Chicago · 1,236
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
115   2017-01-17 Jalaludin Faizal 2331 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1515 Chicago IL 60611
176   2020-01-27 Carbonara Kristina 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
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
188   2020-01-28 Garry Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
196   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
197   2020-01-29 Tahan Julie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
224   2019-01-31 Dhanaphatana Sarah Kelly 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
225   2019-01-31 Pienkos Anna Veronica 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
226   2019-01-31 Sklad Amanda 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
360   2019-02-26 Edelman Margot 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
363   2019-02-26 Stroud Jennifer Christine 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
371   2016-02-28 Abbo Elmer 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
372   2016-02-28 David Alex 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
373   2016-02-28 Patto Susan 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
374   2016-02-28 Yaco Yacob G. 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
375   2016-02-28 Youash Michael 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
426   2014-03-10 Schwegier Peri Alex 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
442   2019-03-13 Jungen Stephan 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
444   2019-03-14 Rubin Ginta Rose 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
467   2019-03-18 Blocksom Shara Lindsey 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
469   2019-03-18 Murray Maureen 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
500   2013-03-26 Stevenson Naoko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
505   2018-03-27 Hashimoto Tsubasa 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
574   2000-04-05 Inforzato Ralph 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
599   2019-04-09 Shepherd Margaret 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
639   2019-04-18 Salvatore Matthew 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
651   2019-04-22 Insinga Mary 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
652   2019-04-22 Rie Katherine 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
653   2019-04-22 Thiele Tracey 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
654   2019-04-22 Tovar Jesus Salvador 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
660   2019-04-23 Pressler Sarah 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
664   2019-04-24 Hanisch OIiver 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
691   2017-04-26 Schmitz Joseph E. 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
706   2018-04-27 Dingwell Makena 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
709   2018-04-27 Walton Laura 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
710   2018-04-27 Workman Daniel 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
790   2019-05-07 Bradley Braden Todd 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
791   2019-05-07 Burce Myriha 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
793   2019-05-07 Cummings Brittany 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
794   2019-05-07 Furth Isabelle 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
795   2019-05-07 Jordan Sameera 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
796   2019-05-07 Kaplan Emily Rebecca 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
797   2019-05-07 Lehner Tyler Joseph 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
840   2019-05-14 Mitra Sujata 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
841   2019-05-14 Williams Lynnette Johnson 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
902   2019-05-24 Arndt Michael 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
904   2019-05-24 Ianni Theresa 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
905   2019-05-24 Parrillo Thomas Jacobe 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
932   2019-05-28 Cook Meghan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
934   2019-05-28 Manzo John 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
935   2019-05-28 Morley Jason 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
936   2019-05-28 Nook Emma 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
942   2019-05-29 McKinney Christopher 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
944   2019-05-29 Patza Ellesyn 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
964   2019-05-31 Caffrey Samantha 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
995   2015-06-08 Sedlmayer Peter D. 6193 6193 2013-11-04 Austrian Trade Commission, Chicago 500 N. Michigan Avenue Suite 1950 Chicago IL 60611
1013   2019-06-11 Camp Lucas 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1017   2019-06-11 Gordon Claire 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1019   2019-06-11 Manzoor Mustafa 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1022   2019-06-11 Wang Danruo 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1023   2019-06-12 Condon Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1044   2018-06-21 Sullivan Jr. Jere J. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1155   2019-07-09 Karnbach Danielle 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1290   2018-08-01 Valeriano Julio M. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1291   2019-08-01 Arsalla Zareen 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1292   2019-08-01 Gentles Laura Morris 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1293   2019-08-01 Rayden Max 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1294   2019-08-01 Sheffield III Ralph Harrison 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1295   2019-08-01 Warpinski Joseph 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1299   2019-08-02 Garvey Alex Edward 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1302   2019-08-02 McDonough Megan Mary 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1303   2019-08-02 Sayson De Jesus Jessica Joy 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1317   2019-08-06 McDermott Evie Violet 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1318   2019-08-06 Yun Woomi 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1327   2019-08-08 Deepak Kumar 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1329   2019-08-08 Imogen Kathryn Long 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1346   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
1415   2019-08-26 McMahon Anna Patricia 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1416   2019-08-26 Ontiveros-Oberg Adam 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1417   2019-08-26 Salerno Laura 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1418   2019-08-26 Shante Randolph De'Osha 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1461   2017-09-01 Mochizuki Hannah DeLetto 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1462   2017-09-01 Wagner Allie 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1498   2019-09-10 Ortiz Mileska 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1502   2019-09-11 Almeleh Shira Eloise 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1504   2019-09-11 Chan Simon Si Ho 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1506   2019-09-11 Lau Yin Ting Tiffany 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1507   2019-09-11 Warr Adrian Hedley 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1510   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
1525   2019-09-13 Yan Chong Vivian Lok 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1541   2019-09-17 Lee Jonathan 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1588   2019-09-23 Broad Christine Hardman 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1589   2019-09-23 Buehler Kai 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
1590   2019-09-23 Comenalli Murray Debora 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1591   2019-09-23 Delgado Ober 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1593   2019-09-23 Lamin Kadrie 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1608   2018-09-25 Kamimura Makoto 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1609   2018-09-25 Ogawa Yumeko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601

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)
);
Powered by Datasette · Query took 372.456ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history