List of all short form registrants (active and terminated)

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

85 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 · 85
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
492   2015-03-12 Reid Mark 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
696   2006-04-14 Kingham Niahm 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
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
1072   2012-06-14 Conlon Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1203   2010-07-13 Mallaghan Aine 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
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
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
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
1947   2019-11-26 Glassner Danielle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1948   2019-11-26 Guy Leslie Barner 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2126   2008-12-18 Johnston Mark Andrew 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2204   2007-12-31 Haughian Andrea 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2956 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
3047 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
7826 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
9836 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
11284 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
11434 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
11444 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
11490 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
11580 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
12180 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
12507 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
13011 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
13013 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
13015 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
14686 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
17150 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
17195 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
17206 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
17225 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
17235 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
17951 2015-06-05 2015-03-12 Chesney Daniel 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18339 2018-06-12 2010-12-01 Seddon Paul 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18927 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
19040 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
20107 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
20781 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
20808 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
22808 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
23377 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
23728 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
23748 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
23976 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
23992 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
24004 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
24436 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
24821 2019-08-05 2018-10-27 Breakey Rachel 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
25035 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
25213 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
25963 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
27378 2019-08-31 2018-09-27 Murphy Michaela 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
28259 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
28683 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
29267 2018-09-27 2018-09-27 Henderson Barry 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
29268 2018-09-27 2018-09-27 Severs Florence 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
29991 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
30069 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
30151 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
31087 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
32636 2020-10-30 2018-09-27 Gray Jillian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
32637 2020-10-30 2018-09-27 Lynn Suzanne 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
33088 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
34118 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
34511 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
35547 2019-11-30 2019-05-29 Hanley Gary 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
36050 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
37016 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
37779 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
38993 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
39285 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
39638 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
39808 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
39975 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
40306 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)
);