ooc_interests
3,833,993 rows sorted by interestlevel
This data as json, CSV (advanced)
_link | _link_ooc_statement | type | interestlevel ▼ | beneficialownershiporcontrol | startdate | details |
---|---|---|---|---|---|---|
1320.interests.0 | 1320 | other-influence-or-control | direct | false | 2014-07-29T00:00:00.000Z | |
132000.interests.0 | 132000 | other-influence-or-control | direct | false | 2015-03-06T00:00:00-06:00 | |
1320000.interests.0 | 1320000 | other-influence-or-control | direct | false | A controlling interest. | |
1320001.interests.0 | 1320001 | other-influence-or-control | direct | false | A controlling interest. | |
1320002.interests.0 | 1320002 | other-influence-or-control | direct | false | A controlling interest. | |
1320003.interests.0 | 1320003 | other-influence-or-control | direct | false | A controlling interest. | |
1320004.interests.0 | 1320004 | other-influence-or-control | direct | false | A controlling interest. | |
1320005.interests.0 | 1320005 | other-influence-or-control | direct | false | A controlling interest. | |
1320006.interests.0 | 1320006 | other-influence-or-control | direct | false | A controlling interest. | |
1320007.interests.0 | 1320007 | other-influence-or-control | direct | false | A controlling interest. | |
1320008.interests.0 | 1320008 | other-influence-or-control | direct | false | A controlling interest. | |
1320009.interests.0 | 1320009 | other-influence-or-control | direct | false | A controlling interest. | |
1320010.interests.0 | 1320010 | other-influence-or-control | direct | false | A controlling interest. | |
1320011.interests.0 | 1320011 | other-influence-or-control | direct | false | A controlling interest. | |
1320012.interests.0 | 1320012 | other-influence-or-control | direct | false | A controlling interest. | |
1320013.interests.0 | 1320013 | other-influence-or-control | direct | false | A controlling interest. | |
1320014.interests.0 | 1320014 | other-influence-or-control | direct | false | A controlling interest. | |
1320015.interests.0 | 1320015 | other-influence-or-control | direct | false | A controlling interest. | |
1320016.interests.0 | 1320016 | other-influence-or-control | direct | false | A controlling interest. | |
1320017.interests.0 | 1320017 | other-influence-or-control | direct | false | A controlling interest. | |
1320018.interests.0 | 1320018 | other-influence-or-control | direct | false | A controlling interest. | |
1320019.interests.0 | 1320019 | other-influence-or-control | direct | false | A controlling interest. | |
132002.interests.0 | 132002 | other-influence-or-control | direct | false | 2002-05-17T00:00:00-05:00 | |
1320020.interests.0 | 1320020 | other-influence-or-control | direct | false | A controlling interest. | |
1320021.interests.0 | 1320021 | other-influence-or-control | direct | false | A controlling interest. | |
1320022.interests.0 | 1320022 | other-influence-or-control | direct | false | A controlling interest. | |
1320023.interests.0 | 1320023 | other-influence-or-control | direct | false | A controlling interest. | |
1320024.interests.0 | 1320024 | other-influence-or-control | direct | false | A controlling interest. | |
1320025.interests.0 | 1320025 | other-influence-or-control | direct | false | A controlling interest. | |
1320026.interests.0 | 1320026 | other-influence-or-control | direct | false | A controlling interest. | |
1320027.interests.0 | 1320027 | other-influence-or-control | direct | false | A controlling interest. | |
1320028.interests.0 | 1320028 | other-influence-or-control | direct | false | A controlling interest. | |
1320029.interests.0 | 1320029 | other-influence-or-control | direct | false | A controlling interest. | |
132003.interests.0 | 132003 | other-influence-or-control | direct | false | 2021-06-14T00:00:00-05:00 | |
1320030.interests.0 | 1320030 | other-influence-or-control | direct | false | A controlling interest. | |
1320031.interests.0 | 1320031 | other-influence-or-control | direct | false | A controlling interest. | |
1320032.interests.0 | 1320032 | other-influence-or-control | direct | false | A controlling interest. | |
1320033.interests.0 | 1320033 | other-influence-or-control | direct | false | A controlling interest. | |
1320034.interests.0 | 1320034 | other-influence-or-control | direct | false | A controlling interest. | |
1320035.interests.0 | 1320035 | other-influence-or-control | direct | false | A controlling interest. | |
1320036.interests.0 | 1320036 | other-influence-or-control | direct | false | A controlling interest. | |
1320037.interests.0 | 1320037 | other-influence-or-control | direct | false | A controlling interest. | |
1320038.interests.0 | 1320038 | other-influence-or-control | direct | false | A controlling interest. | |
1320039.interests.0 | 1320039 | other-influence-or-control | direct | false | A controlling interest. | |
1320040.interests.0 | 1320040 | other-influence-or-control | direct | false | A controlling interest. | |
1320041.interests.0 | 1320041 | other-influence-or-control | direct | false | A controlling interest. | |
1320042.interests.0 | 1320042 | other-influence-or-control | direct | false | A controlling interest. | |
1320043.interests.0 | 1320043 | other-influence-or-control | direct | false | A controlling interest. | |
1320044.interests.0 | 1320044 | other-influence-or-control | direct | false | A controlling interest. | |
1320045.interests.0 | 1320045 | other-influence-or-control | direct | false | A controlling interest. | |
1320046.interests.0 | 1320046 | other-influence-or-control | direct | false | A controlling interest. | |
1320047.interests.0 | 1320047 | other-influence-or-control | direct | false | A controlling interest. | |
1320048.interests.0 | 1320048 | other-influence-or-control | direct | false | A controlling interest. | |
1320049.interests.0 | 1320049 | other-influence-or-control | direct | false | A controlling interest. | |
132005.interests.0 | 132005 | other-influence-or-control | direct | false | 2002-04-11T00:00:00-05:00 | |
1320050.interests.0 | 1320050 | other-influence-or-control | direct | false | A controlling interest. | |
1320051.interests.0 | 1320051 | other-influence-or-control | direct | false | A controlling interest. | |
1320052.interests.0 | 1320052 | other-influence-or-control | direct | false | A controlling interest. | |
1320053.interests.0 | 1320053 | other-influence-or-control | direct | false | A controlling interest. | |
1320054.interests.0 | 1320054 | other-influence-or-control | direct | false | A controlling interest. | |
1320055.interests.0 | 1320055 | other-influence-or-control | direct | false | A controlling interest. | |
1320056.interests.0 | 1320056 | other-influence-or-control | direct | false | A controlling interest. | |
1320057.interests.0 | 1320057 | other-influence-or-control | direct | false | A controlling interest. | |
1320058.interests.0 | 1320058 | other-influence-or-control | direct | false | A controlling interest. | |
1320059.interests.0 | 1320059 | other-influence-or-control | direct | false | A controlling interest. | |
132006.interests.0 | 132006 | other-influence-or-control | direct | false | 2021-03-12T00:00:00-06:00 | |
1320060.interests.0 | 1320060 | other-influence-or-control | direct | false | A controlling interest. | |
1320061.interests.0 | 1320061 | other-influence-or-control | direct | false | A controlling interest. | |
1320062.interests.0 | 1320062 | other-influence-or-control | direct | false | A controlling interest. | |
1320063.interests.0 | 1320063 | other-influence-or-control | direct | false | A controlling interest. | |
1320064.interests.0 | 1320064 | other-influence-or-control | direct | false | A controlling interest. | |
1320065.interests.0 | 1320065 | other-influence-or-control | direct | false | A controlling interest. | |
1320066.interests.0 | 1320066 | other-influence-or-control | direct | false | A controlling interest. | |
1320067.interests.0 | 1320067 | other-influence-or-control | direct | false | A controlling interest. | |
1320068.interests.0 | 1320068 | other-influence-or-control | direct | false | A controlling interest. | |
1320069.interests.0 | 1320069 | other-influence-or-control | direct | false | A controlling interest. | |
1320070.interests.0 | 1320070 | other-influence-or-control | direct | false | A controlling interest. | |
1320071.interests.0 | 1320071 | other-influence-or-control | direct | false | A controlling interest. | |
1320072.interests.0 | 1320072 | other-influence-or-control | direct | false | A controlling interest. | |
1320073.interests.0 | 1320073 | other-influence-or-control | direct | false | A controlling interest. | |
1320074.interests.0 | 1320074 | other-influence-or-control | direct | false | A controlling interest. | |
1320075.interests.0 | 1320075 | other-influence-or-control | direct | false | A controlling interest. | |
1320076.interests.0 | 1320076 | other-influence-or-control | direct | false | A controlling interest. | |
1320077.interests.0 | 1320077 | other-influence-or-control | direct | false | A controlling interest. | |
1320078.interests.0 | 1320078 | other-influence-or-control | direct | false | A controlling interest. | |
1320079.interests.0 | 1320079 | other-influence-or-control | direct | false | A controlling interest. | |
132008.interests.0 | 132008 | other-influence-or-control | direct | false | 2011-03-11T00:00:00-06:00 | |
1320080.interests.0 | 1320080 | other-influence-or-control | direct | false | A controlling interest. | |
1320081.interests.0 | 1320081 | other-influence-or-control | direct | false | A controlling interest. | |
1320082.interests.0 | 1320082 | other-influence-or-control | direct | false | A controlling interest. | |
1320083.interests.0 | 1320083 | other-influence-or-control | direct | false | A controlling interest. | |
1320084.interests.0 | 1320084 | other-influence-or-control | direct | false | A controlling interest. | |
1320085.interests.0 | 1320085 | other-influence-or-control | direct | false | A controlling interest. | |
1320086.interests.0 | 1320086 | other-influence-or-control | direct | false | A controlling interest. | |
1320087.interests.0 | 1320087 | other-influence-or-control | direct | false | A controlling interest. | |
1320088.interests.0 | 1320088 | other-influence-or-control | direct | false | A controlling interest. | |
1320089.interests.0 | 1320089 | other-influence-or-control | direct | false | A controlling interest. | |
132009.interests.0 | 132009 | other-influence-or-control | direct | false | 2018-01-01T00:00:00-06:00 | |
1320090.interests.0 | 1320090 | other-influence-or-control | direct | false | A controlling interest. | |
1320091.interests.0 | 1320091 | other-influence-or-control | direct | false | A controlling interest. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_interests] ( [_link] TEXT , [_link_ooc_statement] TEXT , [type] TEXT , [interestlevel] TEXT , [beneficialownershiporcontrol] BOOL , [startdate] TIMESTAMP , [details] TEXT , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_ooc_statement]) REFERENCES [ooc_statement]([_link]) );