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

83 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 · 83
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
438   2015-03-12 Reid Mark 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
679   2006-04-14 Kingham Niahm 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1026   2020-05-29 Hendrix Caroline 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1027   2020-05-29 Howard Khalig 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1034   2020-05-29 Werken Don van de 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1128   2012-06-14 Conlon Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1306   2010-07-13 Mallaghan Aine 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1806   2018-09-27 Conness Devan 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1808   2018-09-27 Gray Jillian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1809   2018-09-27 Hunter Kevin 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1810   2018-09-27 Lynn Suzanne 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1811   2018-09-27 McCrossan Patrick 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1812   2018-09-27 McGrath Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1814   2018-09-27 Serpa Michelle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1815   2018-09-27 Trengrove Christopher 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2077   2018-11-12 O'Rourke Matthew 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2165   2019-11-26 Donovan Cecily 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2166   2019-11-26 Emhardt Kathryn 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2169   2019-11-26 Glassner Danielle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2170   2019-11-26 Guy Leslie Barner 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2339   2008-12-18 Johnston Mark Andrew 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2397   2007-12-31 Haughian Andrea 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3152 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
3242 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
7900 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
9850 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
11293 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
11443 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
11453 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
11499 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
11589 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
12160 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
12484 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
12981 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
12983 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
12985 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
14629 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
17065 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
17110 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
17121 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
17140 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
17150 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
17860 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
18242 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
18828 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
18941 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
20003 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
20677 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
20704 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
22649 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
23217 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
23567 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
23587 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
23815 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
23831 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
23843 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
24252 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
24628 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
24841 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
25019 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
25745 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
27155 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
28020 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
28443 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
29021 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
29022 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
29744 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
29822 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
29904 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
30816 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
32784 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
33784 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
34173 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
35193 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
35662 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
36623 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
37383 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
38595 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
38887 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
39240 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
39410 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
39577 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
39905 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 359.247ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history