ooc_interests
3,833,993 rows sorted by _link descending
This data as json, CSV (advanced)
_link ▲ | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | startdate | details |
---|---|---|---|---|---|---|
999908.interests.0 | 999908 | other-influence-or-control | direct | false | A controlling interest. | |
999907.interests.0 | 999907 | other-influence-or-control | direct | false | A controlling interest. | |
999906.interests.0 | 999906 | other-influence-or-control | direct | false | A controlling interest. | |
999905.interests.0 | 999905 | other-influence-or-control | direct | false | A controlling interest. | |
999904.interests.0 | 999904 | other-influence-or-control | direct | false | A controlling interest. | |
999903.interests.0 | 999903 | other-influence-or-control | direct | false | A controlling interest. | |
999902.interests.0 | 999902 | other-influence-or-control | direct | false | A controlling interest. | |
999901.interests.0 | 999901 | other-influence-or-control | direct | false | A controlling interest. | |
999900.interests.0 | 999900 | other-influence-or-control | direct | false | A controlling interest. | |
99990.interests.0 | 99990 | other-influence-or-control | direct | false | 1987-12-18T18:30:00.001Z | |
9999.interests.0 | 9999 | other-influence-or-control | indirect | false | 2018-05-10T18:30:00.001Z | |
999899.interests.0 | 999899 | other-influence-or-control | direct | false | A controlling interest. | |
999898.interests.0 | 999898 | other-influence-or-control | direct | false | A controlling interest. | |
999897.interests.0 | 999897 | other-influence-or-control | direct | false | A controlling interest. | |
999896.interests.0 | 999896 | other-influence-or-control | direct | false | A controlling interest. | |
999895.interests.0 | 999895 | other-influence-or-control | direct | false | A controlling interest. | |
999894.interests.0 | 999894 | other-influence-or-control | direct | false | A controlling interest. | |
999893.interests.0 | 999893 | other-influence-or-control | direct | false | A controlling interest. | |
999892.interests.0 | 999892 | other-influence-or-control | direct | false | A controlling interest. | |
999891.interests.0 | 999891 | other-influence-or-control | direct | false | A controlling interest. | |
999890.interests.0 | 999890 | other-influence-or-control | direct | false | A controlling interest. | |
99989.interests.0 | 99989 | other-influence-or-control | indirect | false | 2018-04-08T18:30:00.001Z | |
999889.interests.0 | 999889 | other-influence-or-control | direct | false | A controlling interest. | |
999888.interests.0 | 999888 | other-influence-or-control | direct | false | A controlling interest. | |
999887.interests.0 | 999887 | other-influence-or-control | direct | false | A controlling interest. | |
999886.interests.0 | 999886 | other-influence-or-control | direct | false | A controlling interest. | |
999885.interests.0 | 999885 | other-influence-or-control | direct | false | A controlling interest. | |
999884.interests.0 | 999884 | other-influence-or-control | direct | false | A controlling interest. | |
999883.interests.0 | 999883 | other-influence-or-control | direct | false | A controlling interest. | |
999882.interests.0 | 999882 | other-influence-or-control | direct | false | A controlling interest. | |
999881.interests.0 | 999881 | other-influence-or-control | direct | false | A controlling interest. | |
999880.interests.0 | 999880 | other-influence-or-control | direct | false | A controlling interest. | |
99988.interests.0 | 99988 | other-influence-or-control | direct | false | 2018-04-08T18:30:00.001Z | |
999879.interests.0 | 999879 | other-influence-or-control | direct | false | A controlling interest. | |
999878.interests.0 | 999878 | other-influence-or-control | direct | false | A controlling interest. | |
999877.interests.0 | 999877 | other-influence-or-control | direct | false | A controlling interest. | |
999876.interests.0 | 999876 | other-influence-or-control | direct | false | A controlling interest. | |
999875.interests.0 | 999875 | other-influence-or-control | direct | false | A controlling interest. | |
999874.interests.0 | 999874 | other-influence-or-control | direct | false | A controlling interest. | |
999873.interests.0 | 999873 | other-influence-or-control | direct | false | A controlling interest. | |
999872.interests.0 | 999872 | other-influence-or-control | direct | false | A controlling interest. | |
999871.interests.0 | 999871 | other-influence-or-control | direct | false | A controlling interest. | |
999870.interests.0 | 999870 | other-influence-or-control | direct | false | A controlling interest. | |
99987.interests.0 | 99987 | other-influence-or-control | direct | false | 2012-08-30T18:30:00.001Z | |
999869.interests.0 | 999869 | other-influence-or-control | direct | false | A controlling interest. | |
999868.interests.0 | 999868 | other-influence-or-control | direct | false | A controlling interest. | |
999867.interests.0 | 999867 | other-influence-or-control | direct | false | A controlling interest. | |
999866.interests.0 | 999866 | other-influence-or-control | direct | false | A controlling interest. | |
999865.interests.0 | 999865 | other-influence-or-control | direct | false | A controlling interest. | |
999864.interests.0 | 999864 | other-influence-or-control | direct | false | A controlling interest. | |
999863.interests.0 | 999863 | other-influence-or-control | direct | false | A controlling interest. | |
999862.interests.0 | 999862 | other-influence-or-control | direct | false | A controlling interest. | |
999861.interests.0 | 999861 | other-influence-or-control | direct | false | A controlling interest. | |
999860.interests.0 | 999860 | other-influence-or-control | direct | false | A controlling interest. | |
99986.interests.0 | 99986 | other-influence-or-control | direct | false | 2023-02-28T18:30:00.001Z | |
999859.interests.0 | 999859 | other-influence-or-control | direct | false | A controlling interest. | |
999858.interests.0 | 999858 | other-influence-or-control | direct | false | A controlling interest. | |
999857.interests.0 | 999857 | other-influence-or-control | direct | false | A controlling interest. | |
999856.interests.0 | 999856 | other-influence-or-control | direct | false | A controlling interest. | |
999855.interests.0 | 999855 | other-influence-or-control | direct | false | A controlling interest. | |
999854.interests.0 | 999854 | other-influence-or-control | direct | false | A controlling interest. | |
999853.interests.0 | 999853 | other-influence-or-control | direct | false | A controlling interest. | |
999852.interests.0 | 999852 | other-influence-or-control | direct | false | A controlling interest. | |
999851.interests.0 | 999851 | other-influence-or-control | direct | false | A controlling interest. | |
999850.interests.0 | 999850 | other-influence-or-control | direct | false | A controlling interest. | |
99985.interests.0 | 99985 | other-influence-or-control | indirect | false | 2017-04-05T18:30:00.001Z | |
999849.interests.0 | 999849 | other-influence-or-control | direct | false | A controlling interest. | |
999848.interests.0 | 999848 | other-influence-or-control | direct | false | A controlling interest. | |
999847.interests.0 | 999847 | other-influence-or-control | direct | false | A controlling interest. | |
999846.interests.0 | 999846 | other-influence-or-control | direct | false | A controlling interest. | |
999845.interests.0 | 999845 | other-influence-or-control | direct | false | A controlling interest. | |
999844.interests.0 | 999844 | other-influence-or-control | direct | false | A controlling interest. | |
999843.interests.0 | 999843 | other-influence-or-control | direct | false | A controlling interest. | |
999842.interests.0 | 999842 | other-influence-or-control | direct | false | A controlling interest. | |
999841.interests.0 | 999841 | other-influence-or-control | direct | false | A controlling interest. | |
999840.interests.0 | 999840 | other-influence-or-control | direct | false | A controlling interest. | |
99984.interests.0 | 99984 | other-influence-or-control | direct | false | 2017-04-05T18:30:00.001Z | |
999839.interests.0 | 999839 | other-influence-or-control | direct | false | A controlling interest. | |
999838.interests.0 | 999838 | other-influence-or-control | direct | false | A controlling interest. | |
999837.interests.0 | 999837 | other-influence-or-control | direct | false | A controlling interest. | |
999836.interests.0 | 999836 | other-influence-or-control | direct | false | A controlling interest. | |
999835.interests.0 | 999835 | other-influence-or-control | direct | false | A controlling interest. | |
999834.interests.0 | 999834 | other-influence-or-control | direct | false | A controlling interest. | |
999833.interests.0 | 999833 | other-influence-or-control | direct | false | A controlling interest. | |
999832.interests.0 | 999832 | other-influence-or-control | direct | false | A controlling interest. | |
999831.interests.0 | 999831 | other-influence-or-control | direct | false | A controlling interest. | |
999830.interests.0 | 999830 | other-influence-or-control | direct | false | A controlling interest. | |
99983.interests.0 | 99983 | other-influence-or-control | indirect | false | 2006-10-17T00:00:00+00:00 | |
999829.interests.0 | 999829 | other-influence-or-control | direct | false | A controlling interest. | |
999828.interests.0 | 999828 | other-influence-or-control | direct | false | A controlling interest. | |
999827.interests.0 | 999827 | other-influence-or-control | direct | false | A controlling interest. | |
999826.interests.0 | 999826 | other-influence-or-control | direct | false | A controlling interest. | |
999825.interests.0 | 999825 | other-influence-or-control | direct | false | A controlling interest. | |
999824.interests.0 | 999824 | other-influence-or-control | direct | false | A controlling interest. | |
999823.interests.0 | 999823 | other-influence-or-control | direct | false | A controlling interest. | |
999822.interests.0 | 999822 | other-influence-or-control | direct | false | A controlling interest. | |
999821.interests.0 | 999821 | other-influence-or-control | direct | false | A controlling interest. | |
999820.interests.0 | 999820 | other-influence-or-control | direct | false | A controlling interest. | |
99982.interests.0 | 99982 | other-influence-or-control | direct | false | 2006-10-17T00:00:00+00:00 | |
999819.interests.0 | 999819 | 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]) );