home / UK_PSC

UK_PSC

Custom SQL query returning 101 rows (hide)

This data as json, CSV

_link_link_entity_statementidschemeschemenameuri
0.identifiers.0 0 10283530 GB-COH Companies House  
0.identifiers.1 0 https://opencorporates.com/companies/gb/10283530   OpenCorporates https://opencorporates.com/companies/gb/10283530
0.identifiers.2 0 /entities/6284625598405600606   OpenOwnership Register /entities/6284625598405600606
1.identifiers.0 1 09141094 GB-COH Companies House  
1.identifiers.1 1 https://opencorporates.com/companies/gb/09141094   OpenCorporates https://opencorporates.com/companies/gb/09141094
1.identifiers.2 1 /entities/14311124524810383541   OpenOwnership Register /entities/14311124524810383541
10.identifiers.0 10 07686204 GB-COH Companies House  
10.identifiers.1 10 https://opencorporates.com/companies/gb/07686204   OpenCorporates https://opencorporates.com/companies/gb/07686204
10.identifiers.2 10 /entities/12068474801721424895   OpenOwnership Register /entities/12068474801721424895
100.identifiers.0 100 10283752 GB-COH Companies House  
100.identifiers.1 100 https://opencorporates.com/companies/gb/10283752   OpenCorporates https://opencorporates.com/companies/gb/10283752
100.identifiers.2 100 /entities/7921540168153168996   OpenOwnership Register /entities/7921540168153168996
1000.identifiers.0 1000 07307852 GB-COH Companies House  
1000.identifiers.1 1000 https://opencorporates.com/companies/gb/07307852   OpenCorporates https://opencorporates.com/companies/gb/07307852
1000.identifiers.2 1000 /entities/4838398765801984206   OpenOwnership Register /entities/4838398765801984206
10000.identifiers.0 10000 05493027 GB-COH Companies House  
10000.identifiers.1 10000 https://opencorporates.com/companies/gb/05493027   OpenCorporates https://opencorporates.com/companies/gb/05493027
10000.identifiers.2 10000 /entities/6805258184172977607   OpenOwnership Register /entities/6805258184172977607
100000.identifiers.0 100000 10304772 GB-COH Companies House  
100000.identifiers.1 100000 https://opencorporates.com/companies/gb/10304772   OpenCorporates https://opencorporates.com/companies/gb/10304772
100000.identifiers.2 100000 /entities/12870591944866923901   OpenOwnership Register /entities/12870591944866923901
1000000.identifiers.0 1000000 10646061 GB-COH Companies House  
1000000.identifiers.1 1000000 https://opencorporates.com/companies/gb/10646061   OpenCorporates https://opencorporates.com/companies/gb/10646061
1000000.identifiers.2 1000000 /entities/2356588113015721212   OpenOwnership Register /entities/2356588113015721212
10000000.identifiers.0 10000000 06827794 GB-COH Companies House  
10000000.identifiers.1 10000000 https://opencorporates.com/companies/gb/06827794   OpenCorporates https://opencorporates.com/companies/gb/06827794
10000000.identifiers.2 10000000 /entities/11639805358023843728   OpenOwnership Register /entities/11639805358023843728
10000001.identifiers.0 10000001 10673859 GB-COH Companies House  
10000001.identifiers.1 10000001 https://opencorporates.com/companies/gb/10673859   OpenCorporates https://opencorporates.com/companies/gb/10673859
10000001.identifiers.2 10000001 /entities/8791503110390503048   OpenOwnership Register /entities/8791503110390503048
10000002.identifiers.0 10000002 04680017 GB-COH Companies House  
10000002.identifiers.1 10000002 https://opencorporates.com/companies/gb/04680017   OpenCorporates https://opencorporates.com/companies/gb/04680017
10000002.identifiers.2 10000002 /entities/470483073159422780   OpenOwnership Register /entities/470483073159422780
10000003.identifiers.0 10000003 00030397   GB Persons Of Significant Control Register - Registration numbers  
10000003.identifiers.1 10000003 2138006E39QX7XV6PP21 XI-LEI Global Legal Entity Identifier Index https://search.gleif.org/#/record/2138006E39QX7XV6PP21
10000003.identifiers.2 10000003 https://opencorporates.com/companies/gb/00030397   OpenCorporates https://opencorporates.com/companies/gb/00030397
10000003.identifiers.3 10000003 /entities/4097646490681983754   OpenOwnership Register /entities/4097646490681983754
10000004.identifiers.0 10000004 09470309 GB-COH Companies House  
10000004.identifiers.1 10000004 https://opencorporates.com/companies/gb/09470309   OpenCorporates https://opencorporates.com/companies/gb/09470309
10000004.identifiers.2 10000004 /entities/8463003950375468448   OpenOwnership Register /entities/8463003950375468448
10000005.identifiers.0 10000005 03946793 GB-COH Companies House  
10000005.identifiers.1 10000005 https://opencorporates.com/companies/gb/03946793   OpenCorporates https://opencorporates.com/companies/gb/03946793
10000005.identifiers.2 10000005 /entities/5363181104694266843   OpenOwnership Register /entities/5363181104694266843
10000006.identifiers.0 10000006 10637366 GB-COH Companies House  
10000006.identifiers.1 10000006 https://opencorporates.com/companies/gb/10637366   OpenCorporates https://opencorporates.com/companies/gb/10637366
10000006.identifiers.2 10000006 /entities/10660701265754647428   OpenOwnership Register /entities/10660701265754647428
10000007.identifiers.0 10000007 03521479 GB-COH Companies House  
10000007.identifiers.1 10000007 https://opencorporates.com/companies/gb/03521479   OpenCorporates https://opencorporates.com/companies/gb/03521479
10000007.identifiers.2 10000007 /entities/7575182046651160557   OpenOwnership Register /entities/7575182046651160557
10000008.identifiers.0 10000008 01386289 GB-COH Companies House  
10000008.identifiers.1 10000008 https://opencorporates.com/companies/gb/01386289   OpenCorporates https://opencorporates.com/companies/gb/01386289
10000008.identifiers.2 10000008 /entities/14547081055739969337   OpenOwnership Register /entities/14547081055739969337
10000009.identifiers.0 10000009 02902378 GB-COH Companies House  
10000009.identifiers.1 10000009 https://opencorporates.com/companies/gb/02902378   OpenCorporates https://opencorporates.com/companies/gb/02902378
10000009.identifiers.2 10000009 /entities/1383764374665506196   OpenOwnership Register /entities/1383764374665506196
1000001.identifiers.0 1000001 11326414 GB-COH Companies House  
1000001.identifiers.1 1000001 https://opencorporates.com/companies/gb/11326414   OpenCorporates https://opencorporates.com/companies/gb/11326414
1000001.identifiers.2 1000001 /entities/6101993023671739718   OpenOwnership Register /entities/6101993023671739718
10000010.identifiers.0 10000010 07983988 GB-COH Companies House  
10000010.identifiers.1 10000010 https://opencorporates.com/companies/gb/07983988   OpenCorporates https://opencorporates.com/companies/gb/07983988
10000010.identifiers.2 10000010 /entities/8598014965373657310   OpenOwnership Register /entities/8598014965373657310
10000011.identifiers.0 10000011 07988861 GB-COH Companies House  
10000011.identifiers.1 10000011 https://opencorporates.com/companies/gb/07988861   OpenCorporates https://opencorporates.com/companies/gb/07988861
10000011.identifiers.2 10000011 /entities/2635343864757708151   OpenOwnership Register /entities/2635343864757708151
10000012.identifiers.0 10000012 NI609585 GB-COH Companies House  
10000012.identifiers.1 10000012 Ni609585   GB Persons Of Significant Control Register - Registration numbers  
10000012.identifiers.2 10000012 https://opencorporates.com/companies/gb/NI609585   OpenCorporates https://opencorporates.com/companies/gb/NI609585
10000012.identifiers.3 10000012 /entities/3499780785102226632   OpenOwnership Register /entities/3499780785102226632
10000013.identifiers.0 10000013 03728919 GB-COH Companies House  
10000013.identifiers.1 10000013 https://opencorporates.com/companies/gb/03728919   OpenCorporates https://opencorporates.com/companies/gb/03728919
10000013.identifiers.2 10000013 /entities/17921561877882901369   OpenOwnership Register /entities/17921561877882901369
10000014.identifiers.0 10000014 10006406 GB-COH Companies House  
10000014.identifiers.1 10000014 https://opencorporates.com/companies/gb/10006406   OpenCorporates https://opencorporates.com/companies/gb/10006406
10000014.identifiers.2 10000014 /entities/15273700870510427996   OpenOwnership Register /entities/15273700870510427996
10000015.identifiers.0 10000015 09461851 GB-COH Companies House  
10000015.identifiers.1 10000015 https://opencorporates.com/companies/gb/09461851   OpenCorporates https://opencorporates.com/companies/gb/09461851
10000015.identifiers.2 10000015 /entities/7825311309877649169   OpenOwnership Register /entities/7825311309877649169
10000016.identifiers.0 10000016 09471941 GB-COH Companies House  
10000016.identifiers.1 10000016 https://opencorporates.com/companies/gb/09471941   OpenCorporates https://opencorporates.com/companies/gb/09471941
10000016.identifiers.2 10000016 /entities/14662236115081807900   OpenOwnership Register /entities/14662236115081807900
10000017.identifiers.0 10000017 02296380 GB-COH Companies House  
10000017.identifiers.1 10000017 https://opencorporates.com/companies/gb/02296380   OpenCorporates https://opencorporates.com/companies/gb/02296380
10000017.identifiers.2 10000017 /entities/11725810274637943528   OpenOwnership Register /entities/11725810274637943528
10000018.identifiers.0 10000018 07169381 GB-COH Companies House  
10000018.identifiers.1 10000018 https://opencorporates.com/companies/gb/07169381   OpenCorporates https://opencorporates.com/companies/gb/07169381
10000018.identifiers.2 10000018 /entities/17601887676266417638   OpenOwnership Register /entities/17601887676266417638
10000019.identifiers.0 10000019 07989318 GB-COH Companies House  
10000019.identifiers.1 10000019 https://opencorporates.com/companies/gb/07989318   OpenCorporates https://opencorporates.com/companies/gb/07989318
10000019.identifiers.2 10000019 /entities/9284039523169841675   OpenOwnership Register /entities/9284039523169841675
1000002.identifiers.0 1000002 11239766 GB-COH Companies House  
1000002.identifiers.1 1000002 https://opencorporates.com/companies/gb/11239766   OpenCorporates https://opencorporates.com/companies/gb/11239766
1000002.identifiers.2 1000002 /entities/6673402302975911999   OpenOwnership Register /entities/6673402302975911999
10000020.identifiers.0 10000020 03728548 GB-COH Companies House  
10000020.identifiers.1 10000020 https://opencorporates.com/companies/gb/03728548   OpenCorporates https://opencorporates.com/companies/gb/03728548
10000020.identifiers.2 10000020 /entities/16367288093101554946   OpenOwnership Register /entities/16367288093101554946
10000021.identifiers.0 10000021 OC318260 GB-COH Companies House  
10000021.identifiers.1 10000021 https://opencorporates.com/companies/gb/OC318260   OpenCorporates https://opencorporates.com/companies/gb/OC318260
10000021.identifiers.2 10000021 /entities/17534306380471981222   OpenOwnership Register /entities/17534306380471981222
10000022.identifiers.0 10000022 06823911 GB-COH Companies House  
10000022.identifiers.1 10000022 https://opencorporates.com/companies/gb/06823911   OpenCorporates https://opencorporates.com/companies/gb/06823911
10000022.identifiers.2 10000022 /entities/6616819863609019139   OpenOwnership Register /entities/6616819863609019139
Powered by Datasette · Queries took 14.869ms