home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

95 rows where City = "Bannockburn"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • IL 95

Registration_Number 1

  • Invest Northern Ireland 95

Registrant_Name 1

  • Invest Northern Ireland 95

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
576 576   2015-03-12 Reid Mark Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
797 797   2006-04-14 Shuman Niahm Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1184 1184   2023-05-30 Dempsey Rhett Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1185 1185   2023-05-30 Herron Rory Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1267 1267   2012-06-14 Conlon Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1823 1823   2018-09-27 McCrossan Patrick Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2105 2105   2020-11-10 Connolly Kathy Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2107 2107   2020-11-10 McKeown Claire Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2130 2130   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
2131 2131   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
2132 2132   2021-11-12 Cox Julianne Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2134 2134   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
2135 2135   2021-11-12 Eves Samantha Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2208 2208   2019-11-26 Emhardt Kathryn Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2210 2210   2019-11-26 Glassner Danielle Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2211 2211   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
2220 2220   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
2221 2221   2022-11-28 Burnham Christina Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
2480 2480   2007-12-31 Haughian Andrea Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
3242 3242 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
3366 3366 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
3628 3628 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
3710 3710 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
6074 6074 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
8260 8260 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
9633 9633 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
10365 10365 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
11824 11824 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
11974 11974 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
11984 11984 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
12030 12030 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
12120 12120 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
12238 12238 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
12799 12799 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
13137 13137 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
13650 13650 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
13652 13652 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
13654 13654 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
13771 13771 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
13966 13966 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
15421 15421 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
15718 15718 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
16224 16224 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
17986 17986 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
18031 18031 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
18042 18042 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
18061 18061 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
18071 18071 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
18539 18539 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
18551 18551 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
18860 18860 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
19258 19258 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
19871 19871 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
19984 19984 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
21061 21061 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
21735 21735 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
21762 21762 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
22415 22415 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
23883 23883 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
24486 24486 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
24525 24525 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
24839 24839 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
24859 24859 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
25087 25087 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
25103 25103 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
25115 25115 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
25575 25575 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
25981 25981 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
26197 26197 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
26376 26376 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
27148 27148 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
28589 28589 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
29511 29511 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
29947 29947 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
30546 30546 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
30547 30547 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
31274 31274 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
31352 31352 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
31433 31433 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
32438 32438 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
34031 34031 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
34032 34032 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
34483 34483 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
35580 35580 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
35975 35975 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
37040 37040 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
37603 37603 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
38599 38599 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
39370 39370 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
40586 40586 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
40878 40878 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
41232 41232 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
41402 41402 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
41568 41568 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
41899 41899 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])
);
Powered by Datasette · Queries took 297.779ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history