FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

95 rows where City = "Bannockburn"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

State 1

Registration_Number 1

Registrant_Name 1

City 1

  • Bannockburn · 95 ✖
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
563 563   2015-03-12 Reid Mark Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
781 781   2006-04-14 Shuman Niahm Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1155 1155   2023-05-30 Dempsey Rhett Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1156 1156   2023-05-30 Herron Rory Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1232 1232   2012-06-14 Conlon Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1855 1855   2018-09-27 McCrossan Patrick Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2131 2131   2020-11-10 Connolly Kathy Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2133 2133   2020-11-10 McKeown Claire Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2154 2154   2021-11-12 O'Neill Dearbhla Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2155 2155   2021-11-12 Casey Orla Triona Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2156 2156   2021-11-12 Cox Julianne Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2158 2158   2021-11-12 Dolan James Leonard Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2159 2159   2021-11-12 Eves Samantha Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2229 2229   2019-11-26 Emhardt Kathryn Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2231 2231   2019-11-26 Glassner Danielle Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2232 2232   2019-11-26 Guy Leslie Barner Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2241 2241   2022-11-28 O'Dowd Jane Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2242 2242   2022-11-28 Burnham Christina Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2486 2486   2007-12-31 Haughian Andrea Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3253 3253 2011-01-05 2008-12-18 Stevenson Alan Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3377 3377 2011-01-07 2010-07-13 Aherne Barry Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3639 3639 2023-01-12 2022-11-28 Fleming Katie Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3721 3721 2022-01-14 2018-09-27 Serpa Michelle Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
6092 6092 2021-02-03 2020-05-29 Werken Don van de Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
8293 8293 2015-02-28 2010-07-13 Hughes Sarah-Anne Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
9674 9674 2022-03-11 2020-05-29 Hendrix Caroline Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
10407 10407 2018-03-20 2010-07-13 Jones John Henry Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
11868 11868 2001-03-31 1999-08-24 Doherty Brian Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12018 12018 2007-03-31 2006-05-30 McBurney Janet Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12028 12028 2008-03-31 2006-04-14 Scullion Kiera Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12074 12074 2010-03-31 2008-12-18 Ardis Jeffrey Graham Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12164 12164 2015-03-31 2013-01-08 Hendrie Karen Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12282 12282 2021-03-31 2020-05-29 Howard Khalig Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
12846 12846 2001-04-06 1990-04-13 McVeigh Grainne Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
13185 13185 2007-04-11 2006-04-14 Harvey Laura Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
13700 13700 1995-04-18 1990-04-13 Reilly Terry Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
13702 13702 1995-04-18 1990-06-14 Duffy Francis Joseph Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
13704 13704 1995-04-18 1990-10-09 Mannion Kieran Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
13821 13821 2021-04-20 2018-11-12 O'Rourke Matthew Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
14016 14016 2021-04-23 2018-09-27 Hunter Kevin Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
15472 15472 2008-05-01 2006-05-30 Crawford Louise Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
15771 15771 2021-05-05 2018-09-27 Conness Devan Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
16280 16280 2022-05-13 2018-09-27 Trengrove Christopher Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18043 18043 2008-05-31 2007-06-06 Frazer Andrea Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18088 18088 2011-05-31 2009-05-22 Murray Aengus Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18099 18099 2013-05-31 2010-01-19 Crossan Marguerite Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18118 18118 2013-05-31 2007-12-31 Healy Michelle Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18128 18128 2014-05-31 2013-07-31 McCIay Christina Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18604 18604 2021-06-01 2010-07-13 Mallaghan Aine Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18616 18616 2022-06-01 2019-11-26 Donovan Cecily Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
18926 18926 2015-06-05 2015-03-12 Chesney Daniel Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
19326 19326 2018-06-12 2010-12-01 Seddon Paul Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
19944 19944 2008-06-20 2006-11-30 Murray Lisa Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
20057 20057 2017-06-22 2012-03-21 Glynn Brian Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
21135 21135 1990-06-30 1990-05-15 Ritchie John Noel Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
21809 21809 2014-06-30 2010-07-13 McKenna Aidan Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
21836 21836 2015-06-30 2012-06-14 Brolly Aine Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
22497 22497 2021-07-02 2018-09-27 McGrath Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
23967 23967 2000-07-24 1995-12-18 Murphy Ian Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
24570 24570 2001-07-30 1999-08-24 Webb David Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
24609 24609 2021-07-30 2008-12-18 Johnston Mark Andrew Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
24923 24923 1998-07-31 1995-06-15 Robinson Neil Edward Thomas Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
24943 24943 1999-07-31 1997-06-12 Jackson Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
25171 25171 2010-07-31 2007-12-31 Mulhern Lisa Marie Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
25187 25187 2013-07-31 2009-05-22 McCurdy John Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
25199 25199 2013-07-31 2007-12-31 Dawson Jane Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
25661 25661 2008-08-01 2007-12-31 Howe Louise Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
26067 26067 2019-08-05 2018-10-27 Breakey Rachel Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
26283 26283 2008-08-08 2006-04-14 Quinn Roisin Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
26462 26462 2006-08-11 2006-04-14 O'Neill Sarah Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
27234 27234 2017-08-22 2017-08-22 O'Rourke Gillian Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
28675 28675 2019-08-31 2018-09-27 Murphy Michaela Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
29598 29598 2019-09-11 2018-09-27 Kriske Daniel Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
30034 30034 2019-09-18 2012-03-21 Hunter Ian Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
30633 30633 2018-09-27 2018-09-27 Henderson Barry Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
30634 30634 2018-09-27 2018-09-27 Severs Florence Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
31361 31361 2006-09-30 2006-04-14 Walsh Tracey Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
31439 31439 2009-09-30 2006-04-14 Bradley Martin Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
31520 31520 2011-09-30 2010-01-19 McKeown David Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
32527 32527 2009-10-09 2008-12-18 Sproule George Stuart John Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
34120 34120 2020-10-30 2018-09-27 Gray Jillian Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
34121 34121 2020-10-30 2018-09-27 Lynn Suzanne Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
34572 34572 2008-10-31 2006-05-30 Kildunne Annette Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
35672 35672 2018-11-12 2007-12-31 Hanley Gary Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
36067 36067 2002-11-19 2000-06-23 Teague Deirdre Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
37132 37132 2019-11-30 2019-05-29 Hanley Gary Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
37696 37696 1998-12-03 1995-04-18 Robinson Trevor Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
38692 38692 2006-12-18 2006-04-14 McKeown Jenny Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
39463 39463 2017-12-30 2012-03-21 Campbell Stuart Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
40680 40680 1991-12-31 1990-04-13 O'Hare Declan Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
40972 40972 1996-12-31 1990-04-13 Gray David James Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
41326 41326 2003-12-31 2001-08-02 Mc Erlean Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
41496 41496 2006-12-31 2006-04-14 O'Doherty Corina Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
41662 41662 2009-12-31 2006-05-30 Greer John Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
41993 41993 2014-12-31 2007-12-31 Logan John Invest Northern Ireland 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])
);