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

This data as json, CSV (advanced)

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 438   2015-03-12 Reid Mark 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
679 679   2006-04-14 Kingham Niahm 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1026 1026   2020-05-29 Hendrix Caroline 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1027 1027   2020-05-29 Howard Khalig 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1034 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 1128   2012-06-14 Conlon Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1306 1306   2010-07-13 Mallaghan Aine 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1806 1806   2018-09-27 Conness Devan 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1808 1808   2018-09-27 Gray Jillian 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1809 1809   2018-09-27 Hunter Kevin 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1810 1810   2018-09-27 Lynn Suzanne 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1811 1811   2018-09-27 McCrossan Patrick 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1812 1812   2018-09-27 McGrath Michael 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1814 1814   2018-09-27 Serpa Michelle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1815 1815   2018-09-27 Trengrove Christopher 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2077 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 2165   2019-11-26 Donovan Cecily 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2166 2166   2019-11-26 Emhardt Kathryn 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2169 2169   2019-11-26 Glassner Danielle 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2170 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 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 2397   2007-12-31 Haughian Andrea 4364 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3152 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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