home / UK_PSC

entity_identifiers

30,527,459 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_entity_statement id scheme schemename uri
0.identifiers.0 STAR TUTORS LTD 0 10283530 GB-COH Companies House  
0.identifiers.1 STAR TUTORS LTD 0 https://opencorporates.com/companies/gb/10283530   OpenCorporates https://opencorporates.com/companies/gb/10283530
0.identifiers.2 STAR TUTORS LTD 0 /entities/6284625598405600606   OpenOwnership Register /entities/6284625598405600606
1.identifiers.0 M.HAYTON BUILDERS LIMITED 1 09141094 GB-COH Companies House  
1.identifiers.1 M.HAYTON BUILDERS LIMITED 1 https://opencorporates.com/companies/gb/09141094   OpenCorporates https://opencorporates.com/companies/gb/09141094
1.identifiers.2 M.HAYTON BUILDERS LIMITED 1 /entities/14311124524810383541   OpenOwnership Register /entities/14311124524810383541
10.identifiers.0 COLD BATH DESIGNS LTD 10 07686204 GB-COH Companies House  
10.identifiers.1 COLD BATH DESIGNS LTD 10 https://opencorporates.com/companies/gb/07686204   OpenCorporates https://opencorporates.com/companies/gb/07686204
10.identifiers.2 COLD BATH DESIGNS LTD 10 /entities/12068474801721424895   OpenOwnership Register /entities/12068474801721424895
100.identifiers.0 ENGAGE MORTGAGE SOLUTIONS LTD 100 10283752 GB-COH Companies House  
100.identifiers.1 ENGAGE MORTGAGE SOLUTIONS LTD 100 https://opencorporates.com/companies/gb/10283752   OpenCorporates https://opencorporates.com/companies/gb/10283752
100.identifiers.2 ENGAGE MORTGAGE SOLUTIONS LTD 100 /entities/7921540168153168996   OpenOwnership Register /entities/7921540168153168996
1000.identifiers.0 MZ SYSTEMS LTD 1000 07307852 GB-COH Companies House  
1000.identifiers.1 MZ SYSTEMS LTD 1000 https://opencorporates.com/companies/gb/07307852   OpenCorporates https://opencorporates.com/companies/gb/07307852
1000.identifiers.2 MZ SYSTEMS LTD 1000 /entities/4838398765801984206   OpenOwnership Register /entities/4838398765801984206
10000.identifiers.0 MAGIC HAPPENS HERE LIMITED 10000 05493027 GB-COH Companies House  
10000.identifiers.1 MAGIC HAPPENS HERE LIMITED 10000 https://opencorporates.com/companies/gb/05493027   OpenCorporates https://opencorporates.com/companies/gb/05493027
10000.identifiers.2 MAGIC HAPPENS HERE LIMITED 10000 /entities/6805258184172977607   OpenOwnership Register /entities/6805258184172977607
100000.identifiers.0 LUCIDANT LIMITED 100000 10304772 GB-COH Companies House  
100000.identifiers.1 LUCIDANT LIMITED 100000 https://opencorporates.com/companies/gb/10304772   OpenCorporates https://opencorporates.com/companies/gb/10304772
100000.identifiers.2 LUCIDANT LIMITED 100000 /entities/12870591944866923901   OpenOwnership Register /entities/12870591944866923901
1000000.identifiers.0 CROSSBOW PARTNERS LTD 1000000 10646061 GB-COH Companies House  
1000000.identifiers.1 CROSSBOW PARTNERS LTD 1000000 https://opencorporates.com/companies/gb/10646061   OpenCorporates https://opencorporates.com/companies/gb/10646061
1000000.identifiers.2 CROSSBOW PARTNERS LTD 1000000 /entities/2356588113015721212   OpenOwnership Register /entities/2356588113015721212
10000000.identifiers.0 TATM LIMITED 10000000 06827794 GB-COH Companies House  
10000000.identifiers.1 TATM LIMITED 10000000 https://opencorporates.com/companies/gb/06827794   OpenCorporates https://opencorporates.com/companies/gb/06827794
10000000.identifiers.2 TATM LIMITED 10000000 /entities/11639805358023843728   OpenOwnership Register /entities/11639805358023843728
10000001.identifiers.0 CAFE 7 & PIZZERIA LTD 10000001 10673859 GB-COH Companies House  
10000001.identifiers.1 CAFE 7 & PIZZERIA LTD 10000001 https://opencorporates.com/companies/gb/10673859   OpenCorporates https://opencorporates.com/companies/gb/10673859
10000001.identifiers.2 CAFE 7 & PIZZERIA LTD 10000001 /entities/8791503110390503048   OpenOwnership Register /entities/8791503110390503048
10000002.identifiers.0 CALA SONA LIMITED 10000002 04680017 GB-COH Companies House  
10000002.identifiers.1 CALA SONA LIMITED 10000002 https://opencorporates.com/companies/gb/04680017   OpenCorporates https://opencorporates.com/companies/gb/04680017
10000002.identifiers.2 CALA SONA LIMITED 10000002 /entities/470483073159422780   OpenOwnership Register /entities/470483073159422780
10000003.identifiers.0 The Law Debenture Corporation P.L.C. 10000003 00030397   GB Persons Of Significant Control Register - Registration numbers  
10000003.identifiers.1 The Law Debenture Corporation P.L.C. 10000003 2138006E39QX7XV6PP21 XI-LEI Global Legal Entity Identifier Index https://search.gleif.org/#/record/2138006E39QX7XV6PP21
10000003.identifiers.2 The Law Debenture Corporation P.L.C. 10000003 https://opencorporates.com/companies/gb/00030397   OpenCorporates https://opencorporates.com/companies/gb/00030397
10000003.identifiers.3 The Law Debenture Corporation P.L.C. 10000003 /entities/4097646490681983754   OpenOwnership Register /entities/4097646490681983754
10000004.identifiers.0 CW WOOD WHARF D1/D2 T1 LIMITED 10000004 09470309 GB-COH Companies House  
10000004.identifiers.1 CW WOOD WHARF D1/D2 T1 LIMITED 10000004 https://opencorporates.com/companies/gb/09470309   OpenCorporates https://opencorporates.com/companies/gb/09470309
10000004.identifiers.2 CW WOOD WHARF D1/D2 T1 LIMITED 10000004 /entities/8463003950375468448   OpenOwnership Register /entities/8463003950375468448
10000005.identifiers.0 INDEPENDENT LIVING SOLUTIONS LIMITED 10000005 03946793 GB-COH Companies House  
10000005.identifiers.1 INDEPENDENT LIVING SOLUTIONS LIMITED 10000005 https://opencorporates.com/companies/gb/03946793   OpenCorporates https://opencorporates.com/companies/gb/03946793
10000005.identifiers.2 INDEPENDENT LIVING SOLUTIONS LIMITED 10000005 /entities/5363181104694266843   OpenOwnership Register /entities/5363181104694266843
10000006.identifiers.0 SOUTHWICK NEWSAGENT LTD 10000006 10637366 GB-COH Companies House  
10000006.identifiers.1 SOUTHWICK NEWSAGENT LTD 10000006 https://opencorporates.com/companies/gb/10637366   OpenCorporates https://opencorporates.com/companies/gb/10637366
10000006.identifiers.2 SOUTHWICK NEWSAGENT LTD 10000006 /entities/10660701265754647428   OpenOwnership Register /entities/10660701265754647428
10000007.identifiers.0 OAKTREE INVESTMENTS (MANCHESTER) LTD 10000007 03521479 GB-COH Companies House  
10000007.identifiers.1 OAKTREE INVESTMENTS (MANCHESTER) LTD 10000007 https://opencorporates.com/companies/gb/03521479   OpenCorporates https://opencorporates.com/companies/gb/03521479
10000007.identifiers.2 OAKTREE INVESTMENTS (MANCHESTER) LTD 10000007 /entities/7575182046651160557   OpenOwnership Register /entities/7575182046651160557
10000008.identifiers.0 KEN HOVERS (PENSION CONSULTANTS) LIMITED 10000008 01386289 GB-COH Companies House  
10000008.identifiers.1 KEN HOVERS (PENSION CONSULTANTS) LIMITED 10000008 https://opencorporates.com/companies/gb/01386289   OpenCorporates https://opencorporates.com/companies/gb/01386289
10000008.identifiers.2 KEN HOVERS (PENSION CONSULTANTS) LIMITED 10000008 /entities/14547081055739969337   OpenOwnership Register /entities/14547081055739969337
10000009.identifiers.0 ENGWARE DYNAMICS LIMITED 10000009 02902378 GB-COH Companies House  
10000009.identifiers.1 ENGWARE DYNAMICS LIMITED 10000009 https://opencorporates.com/companies/gb/02902378   OpenCorporates https://opencorporates.com/companies/gb/02902378
10000009.identifiers.2 ENGWARE DYNAMICS LIMITED 10000009 /entities/1383764374665506196   OpenOwnership Register /entities/1383764374665506196
1000001.identifiers.0 THOMAS COOK BRANDS LIMITED 1000001 11326414 GB-COH Companies House  
1000001.identifiers.1 THOMAS COOK BRANDS LIMITED 1000001 https://opencorporates.com/companies/gb/11326414   OpenCorporates https://opencorporates.com/companies/gb/11326414
1000001.identifiers.2 THOMAS COOK BRANDS LIMITED 1000001 /entities/6101993023671739718   OpenOwnership Register /entities/6101993023671739718
10000010.identifiers.0 GD HEALTH LTD 10000010 07983988 GB-COH Companies House  
10000010.identifiers.1 GD HEALTH LTD 10000010 https://opencorporates.com/companies/gb/07983988   OpenCorporates https://opencorporates.com/companies/gb/07983988
10000010.identifiers.2 GD HEALTH LTD 10000010 /entities/8598014965373657310   OpenOwnership Register /entities/8598014965373657310
10000011.identifiers.0 TWIST FACILITIES MANAGEMENT LIMITED 10000011 07988861 GB-COH Companies House  
10000011.identifiers.1 TWIST FACILITIES MANAGEMENT LIMITED 10000011 https://opencorporates.com/companies/gb/07988861   OpenCorporates https://opencorporates.com/companies/gb/07988861
10000011.identifiers.2 TWIST FACILITIES MANAGEMENT LIMITED 10000011 /entities/2635343864757708151   OpenOwnership Register /entities/2635343864757708151
10000012.identifiers.0 Boyd Estates Ltd 10000012 NI609585 GB-COH Companies House  
10000012.identifiers.1 Boyd Estates Ltd 10000012 Ni609585   GB Persons Of Significant Control Register - Registration numbers  
10000012.identifiers.2 Boyd Estates Ltd 10000012 https://opencorporates.com/companies/gb/NI609585   OpenCorporates https://opencorporates.com/companies/gb/NI609585
10000012.identifiers.3 Boyd Estates Ltd 10000012 /entities/3499780785102226632   OpenOwnership Register /entities/3499780785102226632
10000013.identifiers.0 BURTON SKIP HIRE LIMITED 10000013 03728919 GB-COH Companies House  
10000013.identifiers.1 BURTON SKIP HIRE LIMITED 10000013 https://opencorporates.com/companies/gb/03728919   OpenCorporates https://opencorporates.com/companies/gb/03728919
10000013.identifiers.2 BURTON SKIP HIRE LIMITED 10000013 /entities/17921561877882901369   OpenOwnership Register /entities/17921561877882901369
10000014.identifiers.0 MEDX GROUP LIMITED 10000014 10006406 GB-COH Companies House  
10000014.identifiers.1 MEDX GROUP LIMITED 10000014 https://opencorporates.com/companies/gb/10006406   OpenCorporates https://opencorporates.com/companies/gb/10006406
10000014.identifiers.2 MEDX GROUP LIMITED 10000014 /entities/15273700870510427996   OpenOwnership Register /entities/15273700870510427996
10000015.identifiers.0 EVATION LTD 10000015 09461851 GB-COH Companies House  
10000015.identifiers.1 EVATION LTD 10000015 https://opencorporates.com/companies/gb/09461851   OpenCorporates https://opencorporates.com/companies/gb/09461851
10000015.identifiers.2 EVATION LTD 10000015 /entities/7825311309877649169   OpenOwnership Register /entities/7825311309877649169
10000016.identifiers.0 LOVE TIPIS LIMITED 10000016 09471941 GB-COH Companies House  
10000016.identifiers.1 LOVE TIPIS LIMITED 10000016 https://opencorporates.com/companies/gb/09471941   OpenCorporates https://opencorporates.com/companies/gb/09471941
10000016.identifiers.2 LOVE TIPIS LIMITED 10000016 /entities/14662236115081807900   OpenOwnership Register /entities/14662236115081807900
10000017.identifiers.0 32/36 CITY ROAD LIMITED 10000017 02296380 GB-COH Companies House  
10000017.identifiers.1 32/36 CITY ROAD LIMITED 10000017 https://opencorporates.com/companies/gb/02296380   OpenCorporates https://opencorporates.com/companies/gb/02296380
10000017.identifiers.2 32/36 CITY ROAD LIMITED 10000017 /entities/11725810274637943528   OpenOwnership Register /entities/11725810274637943528
10000018.identifiers.0 R & D WATER ENGINEERS LIMITED 10000018 07169381 GB-COH Companies House  
10000018.identifiers.1 R & D WATER ENGINEERS LIMITED 10000018 https://opencorporates.com/companies/gb/07169381   OpenCorporates https://opencorporates.com/companies/gb/07169381
10000018.identifiers.2 R & D WATER ENGINEERS LIMITED 10000018 /entities/17601887676266417638   OpenOwnership Register /entities/17601887676266417638
10000019.identifiers.0 SIMULANT SYSTEMS LTD 10000019 07989318 GB-COH Companies House  
10000019.identifiers.1 SIMULANT SYSTEMS LTD 10000019 https://opencorporates.com/companies/gb/07989318   OpenCorporates https://opencorporates.com/companies/gb/07989318
10000019.identifiers.2 SIMULANT SYSTEMS LTD 10000019 /entities/9284039523169841675   OpenOwnership Register /entities/9284039523169841675
1000002.identifiers.0 Radsense Imaging Technologies Limited 1000002 11239766 GB-COH Companies House  
1000002.identifiers.1 Radsense Imaging Technologies Limited 1000002 https://opencorporates.com/companies/gb/11239766   OpenCorporates https://opencorporates.com/companies/gb/11239766
1000002.identifiers.2 Radsense Imaging Technologies Limited 1000002 /entities/6673402302975911999   OpenOwnership Register /entities/6673402302975911999
10000020.identifiers.0 WALTON LOGGING LIMITED 10000020 03728548 GB-COH Companies House  
10000020.identifiers.1 WALTON LOGGING LIMITED 10000020 https://opencorporates.com/companies/gb/03728548   OpenCorporates https://opencorporates.com/companies/gb/03728548
10000020.identifiers.2 WALTON LOGGING LIMITED 10000020 /entities/16367288093101554946   OpenOwnership Register /entities/16367288093101554946
10000021.identifiers.0 TRAIMARK PROPERTIES LLP 10000021 OC318260 GB-COH Companies House  
10000021.identifiers.1 TRAIMARK PROPERTIES LLP 10000021 https://opencorporates.com/companies/gb/OC318260   OpenCorporates https://opencorporates.com/companies/gb/OC318260
10000021.identifiers.2 TRAIMARK PROPERTIES LLP 10000021 /entities/17534306380471981222   OpenOwnership Register /entities/17534306380471981222
10000022.identifiers.0 LEONARD JAMES & CO LTD 10000022 06823911 GB-COH Companies House  
10000022.identifiers.1 LEONARD JAMES & CO LTD 10000022 https://opencorporates.com/companies/gb/06823911   OpenCorporates https://opencorporates.com/companies/gb/06823911

Next page

Advanced export

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

CSV options:

CREATE TABLE [entity_identifiers] ( [_link] TEXT 
 , [_link_entity_statement] TEXT 
 , [id] TEXT 
 , [scheme] TEXT 
 , [schemename] TEXT 
 , [uri] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) 
   );
Powered by Datasette · Queries took 647.596ms