ooc_interests
3,833,993 rows
This data as json, CSV (advanced)
_link ▼ | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | startdate | details |
---|---|---|---|---|---|---|
1000085.interests.0 | 1000085 | other-influence-or-control | direct | false | A controlling interest. | |
1000086.interests.0 | 1000086 | other-influence-or-control | direct | false | A controlling interest. | |
1000087.interests.0 | 1000087 | other-influence-or-control | direct | false | A controlling interest. | |
1000088.interests.0 | 1000088 | other-influence-or-control | direct | false | A controlling interest. | |
1000089.interests.0 | 1000089 | other-influence-or-control | direct | false | A controlling interest. | |
100009.interests.0 | 100009 | other-influence-or-control | direct | false | 2013-04-24T18:30:00.001Z | |
1000090.interests.0 | 1000090 | other-influence-or-control | direct | false | A controlling interest. | |
1000091.interests.0 | 1000091 | other-influence-or-control | direct | false | A controlling interest. | |
1000092.interests.0 | 1000092 | other-influence-or-control | direct | false | A controlling interest. | |
1000093.interests.0 | 1000093 | other-influence-or-control | direct | false | A controlling interest. | |
1000094.interests.0 | 1000094 | other-influence-or-control | direct | false | A controlling interest. | |
1000095.interests.0 | 1000095 | other-influence-or-control | direct | false | A controlling interest. | |
1000096.interests.0 | 1000096 | other-influence-or-control | direct | false | A controlling interest. | |
1000097.interests.0 | 1000097 | other-influence-or-control | direct | false | A controlling interest. | |
1000098.interests.0 | 1000098 | other-influence-or-control | direct | false | A controlling interest. | |
1000099.interests.0 | 1000099 | other-influence-or-control | direct | false | A controlling interest. | |
10001.interests.0 | 10001 | other-influence-or-control | direct | false | 2012-06-19T18:30:00.001Z | |
100010.interests.0 | 100010 | other-influence-or-control | indirect | false | 2013-04-24T18:30:00.001Z | |
1000100.interests.0 | 1000100 | other-influence-or-control | direct | false | A controlling interest. | |
1000101.interests.0 | 1000101 | other-influence-or-control | direct | false | A controlling interest. | |
1000102.interests.0 | 1000102 | other-influence-or-control | direct | false | A controlling interest. | |
1000103.interests.0 | 1000103 | other-influence-or-control | direct | false | A controlling interest. | |
1000104.interests.0 | 1000104 | other-influence-or-control | direct | false | A controlling interest. | |
1000105.interests.0 | 1000105 | other-influence-or-control | direct | false | A controlling interest. | |
1000106.interests.0 | 1000106 | other-influence-or-control | direct | false | A controlling interest. | |
1000107.interests.0 | 1000107 | other-influence-or-control | direct | false | A controlling interest. | |
1000108.interests.0 | 1000108 | other-influence-or-control | direct | false | A controlling interest. | |
1000109.interests.0 | 1000109 | other-influence-or-control | direct | false | A controlling interest. | |
100011.interests.0 | 100011 | other-influence-or-control | direct | false | 2016-04-21T18:30:00.001Z | |
1000110.interests.0 | 1000110 | other-influence-or-control | direct | false | A controlling interest. | |
1000111.interests.0 | 1000111 | other-influence-or-control | direct | false | A controlling interest. | |
1000112.interests.0 | 1000112 | other-influence-or-control | direct | false | A controlling interest. | |
1000113.interests.0 | 1000113 | other-influence-or-control | direct | false | A controlling interest. | |
1000114.interests.0 | 1000114 | other-influence-or-control | direct | false | A controlling interest. | |
1000115.interests.0 | 1000115 | other-influence-or-control | direct | false | A controlling interest. | |
1000116.interests.0 | 1000116 | other-influence-or-control | direct | false | A controlling interest. | |
1000117.interests.0 | 1000117 | other-influence-or-control | direct | false | A controlling interest. | |
1000118.interests.0 | 1000118 | other-influence-or-control | direct | false | A controlling interest. | |
1000119.interests.0 | 1000119 | other-influence-or-control | direct | false | A controlling interest. | |
100012.interests.0 | 100012 | other-influence-or-control | indirect | false | 2016-04-21T18:30:00.001Z | |
1000120.interests.0 | 1000120 | other-influence-or-control | direct | false | A controlling interest. | |
1000121.interests.0 | 1000121 | other-influence-or-control | direct | false | A controlling interest. | |
1000122.interests.0 | 1000122 | other-influence-or-control | direct | false | A controlling interest. | |
1000123.interests.0 | 1000123 | other-influence-or-control | direct | false | A controlling interest. | |
1000124.interests.0 | 1000124 | other-influence-or-control | direct | false | A controlling interest. | |
1000125.interests.0 | 1000125 | other-influence-or-control | direct | false | A controlling interest. | |
1000126.interests.0 | 1000126 | other-influence-or-control | direct | false | A controlling interest. | |
1000127.interests.0 | 1000127 | other-influence-or-control | direct | false | A controlling interest. | |
1000128.interests.0 | 1000128 | other-influence-or-control | direct | false | A controlling interest. | |
1000129.interests.0 | 1000129 | other-influence-or-control | direct | false | A controlling interest. | |
100013.interests.0 | 100013 | other-influence-or-control | direct | false | 2012-10-16T18:30:00.001Z | |
1000130.interests.0 | 1000130 | other-influence-or-control | direct | false | A controlling interest. | |
1000131.interests.0 | 1000131 | other-influence-or-control | direct | false | A controlling interest. | |
1000132.interests.0 | 1000132 | other-influence-or-control | direct | false | A controlling interest. | |
1000133.interests.0 | 1000133 | other-influence-or-control | direct | false | A controlling interest. | |
1000134.interests.0 | 1000134 | other-influence-or-control | direct | false | A controlling interest. | |
1000135.interests.0 | 1000135 | other-influence-or-control | direct | false | A controlling interest. | |
1000136.interests.0 | 1000136 | other-influence-or-control | direct | false | A controlling interest. | |
1000137.interests.0 | 1000137 | other-influence-or-control | direct | false | A controlling interest. | |
1000138.interests.0 | 1000138 | other-influence-or-control | direct | false | A controlling interest. | |
1000139.interests.0 | 1000139 | other-influence-or-control | direct | false | A controlling interest. | |
100014.interests.0 | 100014 | other-influence-or-control | indirect | false | 2012-10-16T18:30:00.001Z | |
1000140.interests.0 | 1000140 | other-influence-or-control | direct | false | A controlling interest. | |
1000141.interests.0 | 1000141 | other-influence-or-control | direct | false | A controlling interest. | |
1000142.interests.0 | 1000142 | other-influence-or-control | direct | false | A controlling interest. | |
1000143.interests.0 | 1000143 | other-influence-or-control | direct | false | A controlling interest. | |
1000144.interests.0 | 1000144 | other-influence-or-control | direct | false | A controlling interest. | |
1000145.interests.0 | 1000145 | other-influence-or-control | direct | false | A controlling interest. | |
1000146.interests.0 | 1000146 | other-influence-or-control | direct | false | A controlling interest. | |
1000147.interests.0 | 1000147 | other-influence-or-control | direct | false | A controlling interest. | |
1000148.interests.0 | 1000148 | other-influence-or-control | direct | false | A controlling interest. | |
1000149.interests.0 | 1000149 | other-influence-or-control | direct | false | A controlling interest. | |
100015.interests.0 | 100015 | other-influence-or-control | direct | false | 2017-03-09T18:30:00.001Z | |
1000150.interests.0 | 1000150 | other-influence-or-control | direct | false | A controlling interest. | |
1000151.interests.0 | 1000151 | other-influence-or-control | direct | false | A controlling interest. | |
1000152.interests.0 | 1000152 | other-influence-or-control | direct | false | A controlling interest. | |
1000153.interests.0 | 1000153 | other-influence-or-control | direct | false | A controlling interest. | |
1000154.interests.0 | 1000154 | other-influence-or-control | direct | false | A controlling interest. | |
1000155.interests.0 | 1000155 | other-influence-or-control | direct | false | A controlling interest. | |
1000156.interests.0 | 1000156 | other-influence-or-control | direct | false | A controlling interest. | |
1000157.interests.0 | 1000157 | other-influence-or-control | direct | false | A controlling interest. | |
1000158.interests.0 | 1000158 | other-influence-or-control | direct | false | A controlling interest. | |
1000159.interests.0 | 1000159 | other-influence-or-control | direct | false | A controlling interest. | |
100016.interests.0 | 100016 | other-influence-or-control | indirect | false | 2017-03-09T18:30:00.001Z | |
1000160.interests.0 | 1000160 | other-influence-or-control | direct | false | A controlling interest. | |
1000161.interests.0 | 1000161 | other-influence-or-control | direct | false | A controlling interest. | |
1000162.interests.0 | 1000162 | other-influence-or-control | direct | false | A controlling interest. | |
1000163.interests.0 | 1000163 | other-influence-or-control | direct | false | A controlling interest. | |
1000164.interests.0 | 1000164 | other-influence-or-control | direct | false | A controlling interest. | |
1000165.interests.0 | 1000165 | other-influence-or-control | direct | false | A controlling interest. | |
1000166.interests.0 | 1000166 | other-influence-or-control | direct | false | A controlling interest. | |
1000167.interests.0 | 1000167 | other-influence-or-control | direct | false | A controlling interest. | |
1000168.interests.0 | 1000168 | other-influence-or-control | direct | false | A controlling interest. | |
1000169.interests.0 | 1000169 | other-influence-or-control | direct | false | A controlling interest. | |
100017.interests.0 | 100017 | other-influence-or-control | direct | false | 2018-06-27T18:30:00.001Z | |
1000170.interests.0 | 1000170 | other-influence-or-control | direct | false | A controlling interest. | |
1000171.interests.0 | 1000171 | other-influence-or-control | direct | false | A controlling interest. | |
1000172.interests.0 | 1000172 | other-influence-or-control | direct | false | A controlling interest. | |
1000173.interests.0 | 1000173 | other-influence-or-control | direct | false | A controlling interest. | |
1000174.interests.0 | 1000174 | 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]) );