ooc_interests

3,411,077 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: startdate (date)

_link ▼ _link_ooc_statement type interestlevel beneficialownershiporcontrol startdate details
0.interests.0 0 other-influence-or-control direct false 2012-11-29T00:00:00.000Z  
1.interests.0 1 other-influence-or-control direct false 2012-11-29T00:00:00.000Z  
10.interests.0 10 other-influence-or-control direct false 2012-03-20T00:00:00.000Z  
100.interests.0 100 other-influence-or-control direct false 2017-10-17T00:00:00.000Z  
1000.interests.0 1000 other-influence-or-control indirect false 2021-02-12T00:00:00Z  
10000.interests.0 10000 other-influence-or-control direct false 2018-02-23T00:00:00Z  
100000.interests.0 100000 other-influence-or-control direct false 2017-10-31T00:00:00+00:00  
1000000.interests.0 1000000 other-influence-or-control direct false   A controlling interest.
1000001.interests.0 1000001 other-influence-or-control direct false   A controlling interest.
1000002.interests.0 1000002 other-influence-or-control direct false   A controlling interest.
1000003.interests.0 1000003 other-influence-or-control direct false   A controlling interest.
1000004.interests.0 1000004 other-influence-or-control direct false   A controlling interest.
1000005.interests.0 1000005 other-influence-or-control direct false   A controlling interest.
1000006.interests.0 1000006 other-influence-or-control direct false   A controlling interest.
1000007.interests.0 1000007 other-influence-or-control direct false   A controlling interest.
1000008.interests.0 1000008 other-influence-or-control direct false   A controlling interest.
1000009.interests.0 1000009 other-influence-or-control direct false   A controlling interest.
100001.interests.0 100001 other-influence-or-control direct false 2017-12-21T00:00:00+00:00  
1000010.interests.0 1000010 other-influence-or-control direct false   A controlling interest.
1000011.interests.0 1000011 other-influence-or-control direct false   A controlling interest.
1000012.interests.0 1000012 other-influence-or-control direct false   A controlling interest.
1000013.interests.0 1000013 other-influence-or-control direct false   A controlling interest.
1000014.interests.0 1000014 other-influence-or-control direct false   A controlling interest.
1000015.interests.0 1000015 other-influence-or-control direct false   A controlling interest.
1000016.interests.0 1000016 other-influence-or-control direct false   A controlling interest.
1000017.interests.0 1000017 other-influence-or-control direct false   A controlling interest.
1000018.interests.0 1000018 other-influence-or-control direct false   A controlling interest.
1000019.interests.0 1000019 other-influence-or-control direct false   A controlling interest.
100002.interests.0 100002 other-influence-or-control direct false 2014-08-12T00:00:00+00:00  
1000020.interests.0 1000020 other-influence-or-control direct false   A controlling interest.
1000021.interests.0 1000021 other-influence-or-control direct false   A controlling interest.
1000022.interests.0 1000022 other-influence-or-control direct false   A controlling interest.
1000023.interests.0 1000023 other-influence-or-control direct false   A controlling interest.
1000024.interests.0 1000024 other-influence-or-control direct false   A controlling interest.
1000025.interests.0 1000025 other-influence-or-control direct false   A controlling interest.
1000026.interests.0 1000026 other-influence-or-control direct false   A controlling interest.
1000027.interests.0 1000027 other-influence-or-control direct false   A controlling interest.
1000028.interests.0 1000028 other-influence-or-control direct false   A controlling interest.
1000029.interests.0 1000029 other-influence-or-control direct false   A controlling interest.
100003.interests.0 100003 other-influence-or-control direct false 2017-08-30T00:00:00+00:00  
1000030.interests.0 1000030 other-influence-or-control direct false   A controlling interest.
1000031.interests.0 1000031 other-influence-or-control direct false   A controlling interest.
1000032.interests.0 1000032 other-influence-or-control direct false   A controlling interest.
1000033.interests.0 1000033 other-influence-or-control direct false   A controlling interest.
1000034.interests.0 1000034 other-influence-or-control direct false   A controlling interest.
1000035.interests.0 1000035 other-influence-or-control direct false   A controlling interest.
1000036.interests.0 1000036 other-influence-or-control direct false   A controlling interest.
1000037.interests.0 1000037 other-influence-or-control direct false   A controlling interest.
1000038.interests.0 1000038 other-influence-or-control direct false   A controlling interest.
1000039.interests.0 1000039 other-influence-or-control direct false   A controlling interest.
100004.interests.0 100004 other-influence-or-control direct false 2017-12-25T00:00:00+00:00  
1000040.interests.0 1000040 other-influence-or-control direct false   A controlling interest.
1000041.interests.0 1000041 other-influence-or-control direct false   A controlling interest.
1000042.interests.0 1000042 other-influence-or-control direct false   A controlling interest.
1000043.interests.0 1000043 other-influence-or-control direct false   A controlling interest.
1000044.interests.0 1000044 other-influence-or-control direct false   A controlling interest.
1000045.interests.0 1000045 other-influence-or-control direct false   A controlling interest.
1000046.interests.0 1000046 other-influence-or-control direct false   A controlling interest.
1000047.interests.0 1000047 other-influence-or-control direct false   A controlling interest.
1000048.interests.0 1000048 other-influence-or-control direct false   A controlling interest.
1000049.interests.0 1000049 other-influence-or-control direct false   A controlling interest.
100005.interests.0 100005 other-influence-or-control direct false 2020-04-08T00:00:00+00:00  
1000050.interests.0 1000050 other-influence-or-control direct false   A controlling interest.
1000051.interests.0 1000051 other-influence-or-control direct false   A controlling interest.
1000052.interests.0 1000052 other-influence-or-control direct false   A controlling interest.
1000053.interests.0 1000053 other-influence-or-control direct false   A controlling interest.
1000054.interests.0 1000054 other-influence-or-control direct false   A controlling interest.
1000055.interests.0 1000055 other-influence-or-control direct false   A controlling interest.
1000056.interests.0 1000056 other-influence-or-control direct false   A controlling interest.
1000057.interests.0 1000057 other-influence-or-control direct false   A controlling interest.
1000058.interests.0 1000058 other-influence-or-control direct false   A controlling interest.
1000059.interests.0 1000059 other-influence-or-control direct false   A controlling interest.
100006.interests.0 100006 other-influence-or-control direct false 2019-12-05T00:00:00+00:00  
1000060.interests.0 1000060 other-influence-or-control direct false   A controlling interest.
1000061.interests.0 1000061 other-influence-or-control direct false   A controlling interest.
1000062.interests.0 1000062 other-influence-or-control direct false   A controlling interest.
1000063.interests.0 1000063 other-influence-or-control direct false   A controlling interest.
1000064.interests.0 1000064 other-influence-or-control direct false   A controlling interest.
1000065.interests.0 1000065 other-influence-or-control direct false   A controlling interest.
1000066.interests.0 1000066 other-influence-or-control direct false   A controlling interest.
1000067.interests.0 1000067 other-influence-or-control direct false   A controlling interest.
1000068.interests.0 1000068 other-influence-or-control direct false   A controlling interest.
1000069.interests.0 1000069 other-influence-or-control direct false   A controlling interest.
100007.interests.0 100007 other-influence-or-control direct false 2017-11-27T00:00:00+00:00  
1000070.interests.0 1000070 other-influence-or-control direct false   A controlling interest.
1000071.interests.0 1000071 other-influence-or-control direct false   A controlling interest.
1000072.interests.0 1000072 other-influence-or-control direct false   A controlling interest.
1000073.interests.0 1000073 other-influence-or-control direct false   A controlling interest.
1000074.interests.0 1000074 other-influence-or-control direct false   A controlling interest.
1000075.interests.0 1000075 other-influence-or-control direct false   A controlling interest.
1000076.interests.0 1000076 other-influence-or-control direct false   A controlling interest.
1000077.interests.0 1000077 other-influence-or-control direct false   A controlling interest.
1000078.interests.0 1000078 other-influence-or-control direct false   A controlling interest.
1000079.interests.0 1000079 other-influence-or-control direct false   A controlling interest.
100008.interests.0 100008 other-influence-or-control direct false 2017-04-01T00:00:00+00:00  
1000080.interests.0 1000080 other-influence-or-control direct false   A controlling interest.
1000081.interests.0 1000081 other-influence-or-control direct false   A controlling interest.
1000082.interests.0 1000082 other-influence-or-control direct false   A controlling interest.
1000083.interests.0 1000083 other-influence-or-control direct false   A controlling interest.
1000084.interests.0 1000084 other-influence-or-control direct false   A controlling interest.

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]) 
   );