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
10000022.identifiers.2 LEONARD JAMES & CO LTD 10000022 /entities/6616819863609019139   OpenOwnership Register /entities/6616819863609019139
10000023.identifiers.0 GREENER TAXIS LTD 10000023 08845787 GB-COH Companies House  
10000023.identifiers.1 GREENER TAXIS LTD 10000023 https://opencorporates.com/companies/gb/08845787   OpenCorporates https://opencorporates.com/companies/gb/08845787
10000023.identifiers.2 GREENER TAXIS LTD 10000023 /entities/9721493772304764936   OpenOwnership Register /entities/9721493772304764936
10000024.identifiers.0 CITILIVIN LIMITED 10000024 SC362529 GB-COH Companies House  
10000024.identifiers.1 CITILIVIN LIMITED 10000024 https://opencorporates.com/companies/gb/SC362529   OpenCorporates https://opencorporates.com/companies/gb/SC362529
10000024.identifiers.2 CITILIVIN LIMITED 10000024 /entities/12256252855480613736   OpenOwnership Register /entities/12256252855480613736
10000025.identifiers.0 A5 PROPERTY LIMITED 10000025 08893246 GB-COH Companies House  
10000025.identifiers.1 A5 PROPERTY LIMITED 10000025 https://opencorporates.com/companies/gb/08893246   OpenCorporates https://opencorporates.com/companies/gb/08893246
10000025.identifiers.2 A5 PROPERTY LIMITED 10000025 /entities/15994673120448537755   OpenOwnership Register /entities/15994673120448537755
10000026.identifiers.0 N C BARBERING LTD 10000026 09463345 GB-COH Companies House  
10000026.identifiers.1 N C BARBERING LTD 10000026 https://opencorporates.com/companies/gb/09463345   OpenCorporates https://opencorporates.com/companies/gb/09463345
10000026.identifiers.2 N C BARBERING LTD 10000026 /entities/1499972729823155788   OpenOwnership Register /entities/1499972729823155788
10000027.identifiers.0 ASHBYS NATIONAL STOCKTAKERS LIMITED 10000027 10681385 GB-COH Companies House  
10000027.identifiers.1 ASHBYS NATIONAL STOCKTAKERS LIMITED 10000027 https://opencorporates.com/companies/gb/10681385   OpenCorporates https://opencorporates.com/companies/gb/10681385
10000027.identifiers.2 ASHBYS NATIONAL STOCKTAKERS LIMITED 10000027 /entities/11662564180338124602   OpenOwnership Register /entities/11662564180338124602
10000028.identifiers.0 DIAS ENTERPRISES LIMITED 10000028 09454380 GB-COH Companies House  
10000028.identifiers.1 DIAS ENTERPRISES LIMITED 10000028 https://opencorporates.com/companies/gb/09454380   OpenCorporates https://opencorporates.com/companies/gb/09454380
10000028.identifiers.2 DIAS ENTERPRISES LIMITED 10000028 /entities/17728641430897515511   OpenOwnership Register /entities/17728641430897515511
10000029.identifiers.0 FEGO CAFFE GERRARDS CROSS LIMITED 10000029 06173268 GB-COH Companies House  
10000029.identifiers.1 FEGO CAFFE GERRARDS CROSS LIMITED 10000029 https://opencorporates.com/companies/gb/06173268   OpenCorporates https://opencorporates.com/companies/gb/06173268
10000029.identifiers.2 FEGO CAFFE GERRARDS CROSS LIMITED 10000029 /entities/9970888871617290661   OpenOwnership Register /entities/9970888871617290661
1000003.identifiers.0 SMM LEGAL LTD 1000003 11325765 GB-COH Companies House  
1000003.identifiers.1 SMM LEGAL LTD 1000003 https://opencorporates.com/companies/gb/11325765   OpenCorporates https://opencorporates.com/companies/gb/11325765
1000003.identifiers.2 SMM LEGAL LTD 1000003 /entities/15217619326161252731   OpenOwnership Register /entities/15217619326161252731
10000030.identifiers.0 FUTURE ENERGY PARTNERS LIMITED 10000030 07922441 GB-COH Companies House  
10000030.identifiers.1 FUTURE ENERGY PARTNERS LIMITED 10000030 07922441   GB Persons Of Significant Control Register - Registration numbers  
10000030.identifiers.2 FUTURE ENERGY PARTNERS LIMITED 10000030 https://opencorporates.com/companies/gb/07922441   OpenCorporates https://opencorporates.com/companies/gb/07922441
10000030.identifiers.3 FUTURE ENERGY PARTNERS LIMITED 10000030 /entities/18177132756516390234   OpenOwnership Register /entities/18177132756516390234
10000031.identifiers.0 EVISA LIMITED 10000031 06529019 GB-COH Companies House  
10000031.identifiers.1 EVISA LIMITED 10000031 https://opencorporates.com/companies/gb/06529019   OpenCorporates https://opencorporates.com/companies/gb/06529019
10000031.identifiers.2 EVISA LIMITED 10000031 /entities/17072017269513999752   OpenOwnership Register /entities/17072017269513999752
10000032.identifiers.0 EVOLUTION PT LIMITED 10000032 05055846 GB-COH Companies House  
10000032.identifiers.1 EVOLUTION PT LIMITED 10000032 https://opencorporates.com/companies/gb/05055846   OpenCorporates https://opencorporates.com/companies/gb/05055846
10000032.identifiers.2 EVOLUTION PT LIMITED 10000032 /entities/7582964689422931813   OpenOwnership Register /entities/7582964689422931813
10000033.identifiers.0 VIDLEARN LTD 10000033 05732487 GB-COH Companies House  
10000033.identifiers.1 VIDLEARN LTD 10000033 https://opencorporates.com/companies/gb/05732487   OpenCorporates https://opencorporates.com/companies/gb/05732487
10000033.identifiers.2 VIDLEARN LTD 10000033 /entities/2674795505866442742   OpenOwnership Register /entities/2674795505866442742
10000034.identifiers.0 BAYTON BUILDING COMPANY LIMITED 10000034 07167068 GB-COH Companies House  
10000034.identifiers.1 BAYTON BUILDING COMPANY LIMITED 10000034 https://opencorporates.com/companies/gb/07167068   OpenCorporates https://opencorporates.com/companies/gb/07167068
10000034.identifiers.2 BAYTON BUILDING COMPANY LIMITED 10000034 /entities/7142883826525612892   OpenOwnership Register /entities/7142883826525612892
10000035.identifiers.0 HOLLYBANK CHASE MANAGEMENT COMPANY LIMITED 10000035 04684593 GB-COH Companies House  
10000035.identifiers.1 HOLLYBANK CHASE MANAGEMENT COMPANY LIMITED 10000035 https://opencorporates.com/companies/gb/04684593   OpenCorporates https://opencorporates.com/companies/gb/04684593
10000035.identifiers.2 HOLLYBANK CHASE MANAGEMENT COMPANY LIMITED 10000035 /entities/12802168387366978720   OpenOwnership Register /entities/12802168387366978720
10000036.identifiers.0 CELLAR SUPPLIES LIMITED 10000036 10061310 GB-COH Companies House  
10000036.identifiers.1 CELLAR SUPPLIES LIMITED 10000036 https://opencorporates.com/companies/gb/10061310   OpenCorporates https://opencorporates.com/companies/gb/10061310
10000036.identifiers.2 CELLAR SUPPLIES LIMITED 10000036 /entities/15420217565660880473   OpenOwnership Register /entities/15420217565660880473
10000037.identifiers.0 ISCREAM OXFORD LIMITED 10000037 08971038 GB-COH Companies House  
10000037.identifiers.1 ISCREAM OXFORD LIMITED 10000037 https://opencorporates.com/companies/gb/08971038   OpenCorporates https://opencorporates.com/companies/gb/08971038
10000037.identifiers.2 ISCREAM OXFORD LIMITED 10000037 /entities/9510835487790416805   OpenOwnership Register /entities/9510835487790416805
10000038.identifiers.0 Kingston Property Services Limited 10000038 04032016 GB-COH Companies House  
10000038.identifiers.1 Kingston Property Services Limited 10000038 04032016   GB Persons Of Significant Control Register - Registration numbers  
10000038.identifiers.2 Kingston Property Services Limited 10000038 https://opencorporates.com/companies/gb/04032016   OpenCorporates https://opencorporates.com/companies/gb/04032016
10000038.identifiers.3 Kingston Property Services Limited 10000038 /entities/13079713361979345832   OpenOwnership Register /entities/13079713361979345832
10000039.identifiers.0 COW TO CONE LIMITED 10000039 06520251 GB-COH Companies House  
10000039.identifiers.1 COW TO CONE LIMITED 10000039 https://opencorporates.com/companies/gb/06520251   OpenCorporates https://opencorporates.com/companies/gb/06520251
10000039.identifiers.2 COW TO CONE LIMITED 10000039 /entities/9748799168446867441   OpenOwnership Register /entities/9748799168446867441
1000004.identifiers.0 HARLEY STREET EYESTHETICS LTD. 1000004 10080930 GB-COH Companies House  
1000004.identifiers.1 HARLEY STREET EYESTHETICS LTD. 1000004 https://opencorporates.com/companies/gb/10080930   OpenCorporates https://opencorporates.com/companies/gb/10080930
1000004.identifiers.2 HARLEY STREET EYESTHETICS LTD. 1000004 /entities/12661570094320554622   OpenOwnership Register /entities/12661570094320554622
10000040.identifiers.0 BEXLEY CAR SALES LIMITED 10000040 06230230 GB-COH Companies House  
10000040.identifiers.1 BEXLEY CAR SALES LIMITED 10000040 https://opencorporates.com/companies/gb/06230230   OpenCorporates https://opencorporates.com/companies/gb/06230230
10000040.identifiers.2 BEXLEY CAR SALES LIMITED 10000040 /entities/7295742866068415678   OpenOwnership Register /entities/7295742866068415678
10000041.identifiers.0 BAYSTAR DEVELOPMENTS LIMITED 10000041 09408968 GB-COH Companies House  
10000041.identifiers.1 BAYSTAR DEVELOPMENTS LIMITED 10000041 https://opencorporates.com/companies/gb/09408968   OpenCorporates https://opencorporates.com/companies/gb/09408968
10000041.identifiers.2 BAYSTAR DEVELOPMENTS LIMITED 10000041 /entities/403387554117548991   OpenOwnership Register /entities/403387554117548991
10000042.identifiers.0 WNWN ENERGY LIMITED 10000042 06851909 GB-COH Companies House  
10000042.identifiers.1 WNWN ENERGY LIMITED 10000042 https://opencorporates.com/companies/gb/06851909   OpenCorporates https://opencorporates.com/companies/gb/06851909
10000042.identifiers.2 WNWN ENERGY LIMITED 10000042 /entities/7275812710190892615   OpenOwnership Register /entities/7275812710190892615
10000043.identifiers.0 FUTURE PROTECT LIMITED 10000043 06160237 GB-COH Companies House  
10000043.identifiers.1 FUTURE PROTECT LIMITED 10000043 https://opencorporates.com/companies/gb/06160237   OpenCorporates https://opencorporates.com/companies/gb/06160237
10000043.identifiers.2 FUTURE PROTECT LIMITED 10000043 /entities/12240800116352859884   OpenOwnership Register /entities/12240800116352859884
10000044.identifiers.0 SELECT PROPERTIES (SCUNTHORPE) LTD 10000044 08823665 GB-COH Companies House  
10000044.identifiers.1 SELECT PROPERTIES (SCUNTHORPE) LTD 10000044 https://opencorporates.com/companies/gb/08823665   OpenCorporates https://opencorporates.com/companies/gb/08823665
10000044.identifiers.2 SELECT PROPERTIES (SCUNTHORPE) LTD 10000044 /entities/15116874775864324488   OpenOwnership Register /entities/15116874775864324488
10000045.identifiers.0 BLACK ONYX PARTNERSHIP LTD 10000045 06836403 GB-COH Companies House  
10000045.identifiers.1 BLACK ONYX PARTNERSHIP LTD 10000045 https://opencorporates.com/companies/gb/06836403   OpenCorporates https://opencorporates.com/companies/gb/06836403
10000045.identifiers.2 BLACK ONYX PARTNERSHIP LTD 10000045 /entities/2690040498343943076   OpenOwnership Register /entities/2690040498343943076
10000046.identifiers.0 CRAFTY FOX MARKET LIMITED 10000046 10055928 GB-COH Companies House  
10000046.identifiers.1 CRAFTY FOX MARKET LIMITED 10000046 https://opencorporates.com/companies/gb/10055928   OpenCorporates https://opencorporates.com/companies/gb/10055928
10000046.identifiers.2 CRAFTY FOX MARKET LIMITED 10000046 /entities/12103439146024443615   OpenOwnership Register /entities/12103439146024443615
10000047.identifiers.0 MOTION 7 LIMITED 10000047 06112117 GB-COH Companies House  
10000047.identifiers.1 MOTION 7 LIMITED 10000047 https://opencorporates.com/companies/gb/06112117   OpenCorporates https://opencorporates.com/companies/gb/06112117
10000047.identifiers.2 MOTION 7 LIMITED 10000047 /entities/2045202636794440253   OpenOwnership Register /entities/2045202636794440253
10000048.identifiers.0 PROCO COATINGS & LAMINATES LIMITED 10000048 06846362 GB-COH Companies House  
10000048.identifiers.1 PROCO COATINGS & LAMINATES LIMITED 10000048 https://opencorporates.com/companies/gb/06846362   OpenCorporates https://opencorporates.com/companies/gb/06846362
10000048.identifiers.2 PROCO COATINGS & LAMINATES LIMITED 10000048 /entities/12216598292170376449   OpenOwnership Register /entities/12216598292170376449
10000049.identifiers.0 WEYBOURNE MANAGEMENT LIMITED 10000049 08445136 GB-COH Companies House  
10000049.identifiers.1 WEYBOURNE MANAGEMENT LIMITED 10000049 08445136   GB Persons Of Significant Control Register - Registration numbers  
10000049.identifiers.2 WEYBOURNE MANAGEMENT LIMITED 10000049 https://opencorporates.com/companies/gb/08445136   OpenCorporates https://opencorporates.com/companies/gb/08445136
10000049.identifiers.3 WEYBOURNE MANAGEMENT LIMITED 10000049 /entities/15834349775655091460   OpenOwnership Register /entities/15834349775655091460
1000005.identifiers.0 A&J SPEEDITION LTD 1000005 11384749 GB-COH Companies House  
1000005.identifiers.1 A&J SPEEDITION LTD 1000005 https://opencorporates.com/companies/gb/11384749   OpenCorporates https://opencorporates.com/companies/gb/11384749
1000005.identifiers.2 A&J SPEEDITION LTD 1000005 /entities/11503943528828460710   OpenOwnership Register /entities/11503943528828460710
10000050.identifiers.0 PECULIUM PROPERTY HOLDINGS LTD 10000050 10676897 GB-COH Companies House  
10000050.identifiers.1 PECULIUM PROPERTY HOLDINGS LTD 10000050 https://opencorporates.com/companies/gb/10676897   OpenCorporates https://opencorporates.com/companies/gb/10676897
10000050.identifiers.2 PECULIUM PROPERTY HOLDINGS LTD 10000050 /entities/3261564007771654167   OpenOwnership Register /entities/3261564007771654167
10000051.identifiers.0 AFYA NUTRITION LIMITED 10000051 09687145 GB-COH Companies House  
10000051.identifiers.1 AFYA NUTRITION LIMITED 10000051 https://opencorporates.com/companies/gb/09687145   OpenCorporates https://opencorporates.com/companies/gb/09687145
10000051.identifiers.2 AFYA NUTRITION LIMITED 10000051 /entities/9804033692512884522   OpenOwnership Register /entities/9804033692512884522

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 1759.553ms