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,292 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,292

City

  • Chicago · 1,292
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
94   2017-01-17 Jalaludin Faizal 2331 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1515 Chicago IL 60611
146   2020-01-27 Carbonara Kristina 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
149   2020-01-27 Love Michael 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
150   2020-01-27 Singh Nirmala 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
152   2020-01-27 Yohannan Calvin 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
157   2020-01-28 Garry Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
163   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
279   2020-02-14 Alvarez Jessica 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
280   2020-02-14 Lamb Megan Josephine 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
281   2020-02-14 Newson Alana 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
307   2020-02-20 Streit Matthew Alan 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
308   2020-02-20 Thompson Jeremy Solomon 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
341   2020-02-26 Cheung Wing Sze 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
342   2020-02-26 Ching Lou Sek 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
344   2020-02-26 Mansfield Adalie Joy 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
345   2020-02-26 Xi Choo Traceline Cui 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
351   2016-02-28 Abbo Elmer 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
352   2016-02-28 David Alex 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
353   2016-02-28 Patto Susan 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
354   2016-02-28 Yaco Yacob G. 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
355   2016-02-28 Youash Michael 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
356   2020-02-28 Martin Mary Elizabeth 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
409   2014-03-10 Schwegier Peri Alex 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
418   2020-03-11 Coughlan William R. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
419   2020-03-11 De Jesus Jessica Joy Sayson 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
422   2020-03-11 McBrayer Kaitlyn Jane 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
423   2020-03-11 Ryan Conor Patrick 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
424   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
425   2020-03-11 Zenatti Ana Paula De Assis 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
426   2020-03-11 de Vlaming Lauren 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
434   2019-03-13 Jungen Stephan 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
441   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
465   2019-03-18 Blocksom Shara Lindsey 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
467   2019-03-18 Murray Maureen 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
474   2020-03-18 Valeriano Bubick Julio Mauricio 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
494   2020-03-20 Gosbee Jeremy 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
495   2020-03-20 Pervazova Iana Andrianova 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
497   2020-03-20 Stokes Benjamin Noel 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
506   2020-03-23 Faunce Alexis Falon 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
523   2013-03-26 Stevenson Naoko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
528   2020-03-26 Kohn Darcy 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
533   2018-03-27 Hashimoto Tsubasa 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
572   2020-03-30 Chaquette Margaret 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
573   2020-03-30 Conci Maria Del Pilar 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
575   2020-03-30 Nishizawa Tomofumi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
592   2020-04-02 Edelman Amanda 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
593   2020-04-02 Holsan-Kana Holli Lynn 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
594   2020-04-02 Laws George Benjamin 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
618   2000-04-05 Inforzato Ralph 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
685   2020-04-16 Naik Ojas 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
708   2019-04-22 Insinga Mary 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
709   2019-04-22 Rie Katherine 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
710   2019-04-22 Thiele Tracey 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
711   2019-04-22 Tovar Jesus Salvador 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
719   2019-04-24 Hanisch OIiver 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
739   2017-04-26 Schmitz Joseph E. 6339 6339 2016-02-28 Nineveh Plain Defense Fund 6241 N. Talman Avenue   Chicago IL 60659
778   2020-04-29 Corlies Charissa 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
847   2019-05-07 Cummings Brittany 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
848   2019-05-07 Furth Isabelle 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
849   2019-05-07 Kaplan Emily Rebecca 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1004   2019-05-28 Cook Meghan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1006   2019-05-28 Manzo John 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1007   2019-05-28 Morley Jason 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1008   2019-05-28 Nook Emma 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1031   2019-05-29 McKinney Christopher 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1033   2019-05-29 Patza Ellesyn 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1061   2019-05-31 Caffrey Samantha 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1097   2015-06-08 Sedlmayer Peter D. 6193 6193 2013-11-04 Austrian Trade Commission, Chicago 500 N. Michigan Avenue Suite 1950 Chicago IL 60611
1111   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
1123   2019-06-11 Camp Lucas 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1125   2019-06-11 Gordon Claire 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1127   2019-06-11 Manzoor Mustafa 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1130   2019-06-11 Wang Danruo 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1133   2019-06-12 Condon Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1189   2020-06-23 Restieri Jenna 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1328   2020-07-13 Rayden Max 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1434   2020-07-29 Gustafson Christopher 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1451   2020-07-30 Busch Patricia 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1452   2020-07-30 Chacon Kelly Penton 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1453   2020-07-30 Farrell Maura 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1454   2020-07-30 Frerichs Colleen 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1455   2020-07-30 Hainline Ian Adrian 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1456   2020-07-30 Holland Kent 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1457   2020-07-30 Kisling Alexander 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1458   2020-07-30 Klingeberger Anne 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1459   2020-07-30 Lydgate Annie 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1460   2020-07-30 Meara Tom 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1461   2020-07-30 Paguaga Fernanda 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1462   2020-07-30 Reese Joel 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1463   2020-07-30 Roseneck Rachel 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1464   2020-07-30 Scherrman Molly 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1465   2020-07-30 Schmaler Tracy 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1466   2020-07-30 Sedler Eric 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1467   2020-07-30 Shutler Mackenzie 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1468   2020-07-30 Terenzio Rosemarie 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1469   2020-07-30 Turco Catherine 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1476   2020-07-31 DeAngelis Bryan 6839 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1482   2019-08-01 Arsalla Zareen 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1483   2019-08-01 Gentles Laura Morris 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1487   2019-08-02 McDonough Megan Mary 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 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 382.846ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history