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

402 rows where Registration_Number = 3634

View and edit SQL

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

State

Registration_Number

  • 3634 · 402

Registrant_Name

City

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
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
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
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
660   2019-04-23 Pressler Sarah 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
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
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
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
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
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
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
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
1676   2019-09-30 Endale Yemiserach 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1680   2019-09-30 Starkey Amaya Michelle 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1695   2019-10-02 McCabe Ian Richard 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1726   2019-10-07 Calabro Renee 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1788   2019-10-17 Donahoe Christopher Rayburn 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1789   2019-10-17 Moyle Eliza Rose 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1790   2019-10-17 Neary Sean 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1792   2019-10-17 Stamp Melissa 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1887   2019-10-29 Kuchman Emily 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1899   2018-10-30 Winstel Samuel Lynn 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1953   2019-11-07 Young Maxwell Harvey 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1972   2018-11-13 Bubick Julio M. Valeriano 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1973   2018-11-13 Stieber Dorothee Christiane 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1986   2018-11-14 Feingold Martha 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1993   2018-11-15 Cloud Bridget 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1996   2018-11-15 Niadna Kimberly Marie 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1998   2019-11-15 Jayasinghe Tamani Neshika 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
1999   2019-11-15 Platz Jesse 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
2050   2019-11-22 Roddy Katherine 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
2762 2012-01-01 2010-07-20 Walsh Monica 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
2765 2012-01-01 2011-07-22 Bennett Taylor R. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
2860 2017-01-01 2013-03-15 Holland Michael 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
3611 2010-01-15 2004-11-10 Segal J. Peter 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
3675 2009-01-16 2007-12-07 Wallace David Eaton 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
3835 1990-01-19 1986-08-07 Birrell Jeffrey Clarke 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
3962 2000-01-21 1992-07-31 Crosson David 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
4040 1987-01-23 1986-12-23 Housman Damian Patrick 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5059 2006-01-31 2005-07-19 Hartt Michael MacDonald 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5124 2009-01-31 2008-11-17 Fenwick Ryan 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5125 2009-01-31 2008-11-17 Naguib Amgad 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5140 2010-01-31 2009-10-06 Hartt Michael M. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5143 2011-01-31 2010-03-08 Dischen Robert 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5144 2011-01-31 2010-03-08 Randall Christine Ann 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5150 2011-01-31 2010-07-20 Dolezal Ashley 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5151 2011-01-31 2010-07-20 Kupiecki Kimberly 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5154 2011-01-31 2010-09-01 Wallace Monica 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5155 2011-01-31 2009-10-06 Fontanez Mary B. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5156 2011-01-31 2009-10-06 Myers Richard B. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5157 2011-01-31 2009-10-06 Sheridan Kevin R. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5158 2011-01-31 2010-11-29 Keiser Tracy 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5159 2011-01-31 2010-11-29 Moran Robert P. 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5160 2011-01-31 2010-11-29 Zivin Aaron Sparky"" 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5218 2017-01-31 2015-08-31 Sternby Elizabeth 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5247 2019-01-31 2018-06-26 Brown Rebecca 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5252 2019-01-31 2018-09-19 Pidcock Louise 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 200 East Randolph Drive Suite 900 Chicago IL 60601
5255 2019-01-31 2018-11-13 Fisher Nicholas 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 424.171ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history