ooc_interests
3,833,993 rows sorted by _link descending
This data as json, CSV (advanced)
Suggested facets: startdate (date)
_link ▲ | _link_ooc_statement | type | interestlevel | beneficialownershiporcontrol | startdate | details |
---|---|---|---|---|---|---|
999999.interests.0 | 999999 | other-influence-or-control | direct | false | A controlling interest. | |
999998.interests.0 | 999998 | other-influence-or-control | direct | false | A controlling interest. | |
999997.interests.0 | 999997 | other-influence-or-control | direct | false | A controlling interest. | |
999996.interests.0 | 999996 | other-influence-or-control | direct | false | A controlling interest. | |
999995.interests.0 | 999995 | other-influence-or-control | direct | false | A controlling interest. | |
999994.interests.0 | 999994 | other-influence-or-control | direct | false | A controlling interest. | |
999993.interests.0 | 999993 | other-influence-or-control | direct | false | A controlling interest. | |
999992.interests.0 | 999992 | other-influence-or-control | direct | false | A controlling interest. | |
999991.interests.0 | 999991 | other-influence-or-control | direct | false | A controlling interest. | |
999990.interests.0 | 999990 | other-influence-or-control | direct | false | A controlling interest. | |
99999.interests.0 | 99999 | other-influence-or-control | direct | false | 2022-01-09T18:30:00.001Z | |
999989.interests.0 | 999989 | other-influence-or-control | direct | false | A controlling interest. | |
999988.interests.0 | 999988 | other-influence-or-control | direct | false | A controlling interest. | |
999987.interests.0 | 999987 | other-influence-or-control | direct | false | A controlling interest. | |
999986.interests.0 | 999986 | other-influence-or-control | direct | false | A controlling interest. | |
999985.interests.0 | 999985 | other-influence-or-control | direct | false | A controlling interest. | |
999984.interests.0 | 999984 | other-influence-or-control | direct | false | A controlling interest. | |
999983.interests.0 | 999983 | other-influence-or-control | direct | false | A controlling interest. | |
999982.interests.0 | 999982 | other-influence-or-control | direct | false | A controlling interest. | |
999981.interests.0 | 999981 | other-influence-or-control | direct | false | A controlling interest. | |
999980.interests.0 | 999980 | other-influence-or-control | direct | false | A controlling interest. | |
99998.interests.0 | 99998 | other-influence-or-control | direct | false | 2005-03-10T18:30:00.001Z | |
999979.interests.0 | 999979 | other-influence-or-control | direct | false | A controlling interest. | |
999978.interests.0 | 999978 | other-influence-or-control | direct | false | A controlling interest. | |
999977.interests.0 | 999977 | other-influence-or-control | direct | false | A controlling interest. | |
999976.interests.0 | 999976 | other-influence-or-control | direct | false | A controlling interest. | |
999975.interests.0 | 999975 | other-influence-or-control | direct | false | A controlling interest. | |
999974.interests.0 | 999974 | other-influence-or-control | direct | false | A controlling interest. | |
999973.interests.0 | 999973 | other-influence-or-control | direct | false | A controlling interest. | |
999972.interests.0 | 999972 | other-influence-or-control | direct | false | A controlling interest. | |
999971.interests.0 | 999971 | other-influence-or-control | direct | false | A controlling interest. | |
999970.interests.0 | 999970 | other-influence-or-control | direct | false | A controlling interest. | |
99997.interests.0 | 99997 | other-influence-or-control | direct | false | 2005-03-10T18:30:00.001Z | |
999969.interests.0 | 999969 | other-influence-or-control | direct | false | A controlling interest. | |
999968.interests.0 | 999968 | other-influence-or-control | direct | false | A controlling interest. | |
999967.interests.0 | 999967 | other-influence-or-control | direct | false | A controlling interest. | |
999966.interests.0 | 999966 | other-influence-or-control | direct | false | A controlling interest. | |
999965.interests.0 | 999965 | other-influence-or-control | direct | false | A controlling interest. | |
999964.interests.0 | 999964 | other-influence-or-control | direct | false | A controlling interest. | |
999963.interests.0 | 999963 | other-influence-or-control | direct | false | A controlling interest. | |
999962.interests.0 | 999962 | other-influence-or-control | direct | false | A controlling interest. | |
999961.interests.0 | 999961 | other-influence-or-control | direct | false | A controlling interest. | |
999960.interests.0 | 999960 | other-influence-or-control | direct | false | A controlling interest. | |
99996.interests.0 | 99996 | other-influence-or-control | indirect | false | 2007-04-01T18:30:00.001Z | |
999959.interests.0 | 999959 | other-influence-or-control | direct | false | A controlling interest. | |
999958.interests.0 | 999958 | other-influence-or-control | direct | false | A controlling interest. | |
999957.interests.0 | 999957 | other-influence-or-control | direct | false | A controlling interest. | |
999956.interests.0 | 999956 | other-influence-or-control | direct | false | A controlling interest. | |
999955.interests.0 | 999955 | other-influence-or-control | direct | false | A controlling interest. | |
999954.interests.0 | 999954 | other-influence-or-control | direct | false | A controlling interest. | |
999953.interests.0 | 999953 | other-influence-or-control | direct | false | A controlling interest. | |
999952.interests.0 | 999952 | other-influence-or-control | direct | false | A controlling interest. | |
999951.interests.0 | 999951 | other-influence-or-control | direct | false | A controlling interest. | |
999950.interests.0 | 999950 | other-influence-or-control | direct | false | A controlling interest. | |
99995.interests.0 | 99995 | other-influence-or-control | direct | false | 2007-04-01T18:30:00.001Z | |
999949.interests.0 | 999949 | other-influence-or-control | direct | false | A controlling interest. | |
999948.interests.0 | 999948 | other-influence-or-control | direct | false | A controlling interest. | |
999947.interests.0 | 999947 | other-influence-or-control | direct | false | A controlling interest. | |
999946.interests.0 | 999946 | other-influence-or-control | direct | false | A controlling interest. | |
999945.interests.0 | 999945 | other-influence-or-control | direct | false | A controlling interest. | |
999944.interests.0 | 999944 | other-influence-or-control | direct | false | A controlling interest. | |
999943.interests.0 | 999943 | other-influence-or-control | direct | false | A controlling interest. | |
999942.interests.0 | 999942 | other-influence-or-control | direct | false | A controlling interest. | |
999941.interests.0 | 999941 | other-influence-or-control | direct | false | A controlling interest. | |
999940.interests.0 | 999940 | other-influence-or-control | direct | false | A controlling interest. | |
99994.interests.0 | 99994 | other-influence-or-control | indirect | false | 2007-09-30T18:30:00.001Z | |
999939.interests.0 | 999939 | other-influence-or-control | direct | false | A controlling interest. | |
999938.interests.0 | 999938 | other-influence-or-control | direct | false | A controlling interest. | |
999937.interests.0 | 999937 | other-influence-or-control | direct | false | A controlling interest. | |
999936.interests.0 | 999936 | other-influence-or-control | direct | false | A controlling interest. | |
999935.interests.0 | 999935 | other-influence-or-control | direct | false | A controlling interest. | |
999934.interests.0 | 999934 | other-influence-or-control | direct | false | A controlling interest. | |
999933.interests.0 | 999933 | other-influence-or-control | direct | false | A controlling interest. | |
999932.interests.0 | 999932 | other-influence-or-control | direct | false | A controlling interest. | |
999931.interests.0 | 999931 | other-influence-or-control | direct | false | A controlling interest. | |
999930.interests.0 | 999930 | other-influence-or-control | direct | false | A controlling interest. | |
99993.interests.0 | 99993 | other-influence-or-control | direct | false | 2007-09-30T18:30:00.001Z | |
999929.interests.0 | 999929 | other-influence-or-control | direct | false | A controlling interest. | |
999928.interests.0 | 999928 | other-influence-or-control | direct | false | A controlling interest. | |
999927.interests.0 | 999927 | other-influence-or-control | direct | false | A controlling interest. | |
999926.interests.0 | 999926 | other-influence-or-control | direct | false | A controlling interest. | |
999925.interests.0 | 999925 | other-influence-or-control | direct | false | A controlling interest. | |
999924.interests.0 | 999924 | other-influence-or-control | direct | false | A controlling interest. | |
999923.interests.0 | 999923 | other-influence-or-control | direct | false | A controlling interest. | |
999922.interests.0 | 999922 | other-influence-or-control | direct | false | A controlling interest. | |
999921.interests.0 | 999921 | other-influence-or-control | direct | false | A controlling interest. | |
999920.interests.0 | 999920 | other-influence-or-control | direct | false | A controlling interest. | |
99992.interests.0 | 99992 | other-influence-or-control | indirect | false | 2015-01-22T18:30:00.001Z | |
999919.interests.0 | 999919 | other-influence-or-control | direct | false | A controlling interest. | |
999918.interests.0 | 999918 | other-influence-or-control | direct | false | A controlling interest. | |
999917.interests.0 | 999917 | other-influence-or-control | direct | false | A controlling interest. | |
999916.interests.0 | 999916 | other-influence-or-control | direct | false | A controlling interest. | |
999915.interests.0 | 999915 | other-influence-or-control | direct | false | A controlling interest. | |
999914.interests.0 | 999914 | other-influence-or-control | direct | false | A controlling interest. | |
999913.interests.0 | 999913 | other-influence-or-control | direct | false | A controlling interest. | |
999912.interests.0 | 999912 | other-influence-or-control | direct | false | A controlling interest. | |
999911.interests.0 | 999911 | other-influence-or-control | direct | false | A controlling interest. | |
999910.interests.0 | 999910 | other-influence-or-control | direct | false | A controlling interest. | |
99991.interests.0 | 99991 | other-influence-or-control | direct | false | 2015-01-22T18:30:00.001Z | |
999909.interests.0 | 999909 | 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]) );