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

80 rows where City = "Bannockburn"

View and edit SQL

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

State

Registration_Number

Registrant_Name

City

  • Bannockburn · 80
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
459   2015-03-12 Chesney Daniel 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
460   2015-03-12 Reid Mark 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
639   2006-04-14 Kingham Niahm 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
962   2019-05-29 Hanley Gary 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1048   2012-06-14 Conlon Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1191   2010-07-13 Mallaghan Aine 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1650   2018-09-27 Conness Devan 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1652   2018-09-27 Gray Jillian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1653   2018-09-27 Henderson Barry 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1654   2018-09-27 Hunter Kevin 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1655   2018-09-27 Lynn Suzanne 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1656   2018-09-27 McCrossan Patrick 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1657   2018-09-27 McGrath Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1658   2018-09-27 Murphy Michaela 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1660   2018-09-27 Serpa Michelle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1661   2018-09-27 Severs Florence 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1662   2018-09-27 Trengrove Christopher 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1886   2018-10-27 Breakey Rachel 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1978   2018-11-12 O'Rourke Matthew 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2079   2019-11-26 Donovan Cecily 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2080   2019-11-26 Emhardt Kathryn 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2083   2019-11-26 Glassner Danielle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2084   2019-11-26 Guy Leslie Barner 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2165   2010-12-01 Seddon Paul 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2278   2008-12-18 Johnston Mark Andrew 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2343   2007-12-31 Haughian Andrea 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3103 2011-01-05 2008-12-18 Stevenson Alan Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3193 2011-01-07 2010-07-13 Aherne Barry 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
7792 2015-02-28 2010-07-13 Hughes Sarah-Anne 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
9718 2018-03-20 2010-07-13 Jones John Henry 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11150 2001-03-31 1999-08-24 Doherty Brian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11300 2007-03-31 2006-05-30 McBurney Janet 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11310 2008-03-31 2006-04-14 Scullion Kiera 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11356 2010-03-31 2008-12-18 Ardis Jeffrey Graham 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11446 2015-03-31 2013-01-08 Hendrie Karen 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11992 2001-04-06 1990-04-13 McVeigh Grainne 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12316 2007-04-11 2006-04-14 Harvey Laura 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12809 1995-04-18 1990-04-13 Reilly Terry 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12811 1995-04-18 1990-06-14 Duffy Francis Joseph 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12813 1995-04-18 1990-10-09 Mannion Kieran 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
14400 2008-05-01 2006-05-30 Crawford Louise 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
16807 2008-05-31 2007-06-06 Frazer Andrea 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
16852 2011-05-31 2009-05-22 Murray Aengus 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
16863 2013-05-31 2010-01-19 Crossan Marguerite 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
16882 2013-05-31 2007-12-31 Healy Michelle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
16892 2014-05-31 2013-07-31 McCIay Christina 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18551 2008-06-20 2006-11-30 Murray Lisa 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18664 2017-06-22 2012-03-21 Glynn Brian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
19725 1990-06-30 1990-05-15 Ritchie John Noel 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
20399 2014-06-30 2010-07-13 McKenna Aidan 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
20426 2015-06-30 2012-06-14 Brolly Aine 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
22343 2000-07-24 1995-12-18 Murphy Ian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
22908 2001-07-30 1999-08-24 Webb David 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23257 1998-07-31 1995-06-15 Robinson Neil Edward Thomas 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23277 1999-07-31 1997-06-12 Jackson Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23505 2010-07-31 2007-12-31 Mulhern Lisa Marie 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23521 2013-07-31 2009-05-22 McCurdy John 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23533 2013-07-31 2007-12-31 Dawson Jane 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23927 2008-08-01 2007-12-31 Howe Louise 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
24510 2008-08-08 2006-04-14 Quinn Roisin 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
24674 2006-08-11 2006-04-14 O'Neill Sarah 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
25398 2017-08-22 2017-08-22 O'Rourke Gillian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
27656 2019-09-11 2018-09-27 Kriske Daniel 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
28077 2019-09-18 2012-03-21 Hunter Ian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
29372 2006-09-30 2006-04-14 Walsh Tracey 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
29450 2009-09-30 2006-04-14 Bradley Martin 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
29532 2011-09-30 2010-01-19 McKeown David 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
30432 2009-10-09 2008-12-18 Sproule George Stuart John 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
32394 2008-10-31 2006-05-30 Kildunne Annette 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
33379 2018-11-12 2007-12-31 Hanley Gary 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
33767 2002-11-19 2000-06-23 Teague Deirdre 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
35237 1998-12-03 1995-04-18 Robinson Trevor 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
36189 2006-12-18 2006-04-14 McKeown Jenny 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
36944 2017-12-30 2012-03-21 Campbell Stuart 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
38155 1991-12-31 1990-04-13 O'Hare Declan 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
38447 1996-12-31 1990-04-13 Gray David James 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
38800 2003-12-31 2001-08-02 Mc Erlean Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
38970 2006-12-31 2006-04-14 O'Doherty Corina 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
39137 2009-12-31 2006-05-30 Greer John 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
39462 2014-12-31 2007-12-31 Logan John 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015

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 402.868ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history