home / register

entity_identifiers

28,893,794 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_entity_statement id scheme schemename uri
100002.identifiers.1 FGDC LIMITED 100002 https://opencorporates.com/companies/gb/09694505   OpenCorporates https://opencorporates.com/companies/gb/09694505
100002.identifiers.2 FGDC LIMITED 100002 /entities/7537221971883089647   OpenOwnership Register /entities/7537221971883089647
1000020.identifiers.0 MADE BY BEN LTD 1000020 11326829 GB-COH Companies House  
1000020.identifiers.1 MADE BY BEN LTD 1000020 https://opencorporates.com/companies/gb/11326829   OpenCorporates https://opencorporates.com/companies/gb/11326829
1000020.identifiers.2 MADE BY BEN LTD 1000020 /entities/4141296710708346848   OpenOwnership Register /entities/4141296710708346848
1000021.identifiers.0 UNIVERSALS SHIPPING (UK) LTD. 1000021 03664630 GB-COH Companies House  
1000021.identifiers.1 UNIVERSALS SHIPPING (UK) LTD. 1000021 https://opencorporates.com/companies/gb/03664630   OpenCorporates https://opencorporates.com/companies/gb/03664630
1000021.identifiers.2 UNIVERSALS SHIPPING (UK) LTD. 1000021 /entities/15450898102744738798   OpenOwnership Register /entities/15450898102744738798
1000022.identifiers.0 JKL SOLUTIONS LIMITED 1000022 06874834 GB-COH Companies House  
1000022.identifiers.1 JKL SOLUTIONS LIMITED 1000022 https://opencorporates.com/companies/gb/06874834   OpenCorporates https://opencorporates.com/companies/gb/06874834
1000022.identifiers.2 JKL SOLUTIONS LIMITED 1000022 /entities/1453127024857418162   OpenOwnership Register /entities/1453127024857418162
1000023.identifiers.0 FENESTRA GLAZING LTD 1000023 10725924 GB-COH Companies House  
1000023.identifiers.1 FENESTRA GLAZING LTD 1000023 https://opencorporates.com/companies/gb/10725924   OpenCorporates https://opencorporates.com/companies/gb/10725924
1000023.identifiers.2 FENESTRA GLAZING LTD 1000023 /entities/2186608349870569915   OpenOwnership Register /entities/2186608349870569915
1000024.identifiers.0 ZAKA HOLDINGS LIMITED 1000024 11326367 GB-COH Companies House  
1000024.identifiers.1 ZAKA HOLDINGS LIMITED 1000024 https://opencorporates.com/companies/gb/11326367   OpenCorporates https://opencorporates.com/companies/gb/11326367
1000024.identifiers.2 ZAKA HOLDINGS LIMITED 1000024 /entities/12298766552808437189   OpenOwnership Register /entities/12298766552808437189
1000025.identifiers.0 RAPALAN LTD 1000025 SC565843 GB-COH Companies House  
1000025.identifiers.1 RAPALAN LTD 1000025 https://opencorporates.com/companies/gb/SC565843   OpenCorporates https://opencorporates.com/companies/gb/SC565843
1000025.identifiers.2 RAPALAN LTD 1000025 /entities/6515553472177540969   OpenOwnership Register /entities/6515553472177540969
1000026.identifiers.0 PHONE LOCKER LTD 1000026 11326372 GB-COH Companies House  
1000026.identifiers.1 PHONE LOCKER LTD 1000026 https://opencorporates.com/companies/gb/11326372   OpenCorporates https://opencorporates.com/companies/gb/11326372
1000026.identifiers.2 PHONE LOCKER LTD 1000026 /entities/9258624292939618497   OpenOwnership Register /entities/9258624292939618497
1000027.identifiers.0 LISA CHANG LEE STUDIO LTD 1000027 11326375 GB-COH Companies House  
1000027.identifiers.1 LISA CHANG LEE STUDIO LTD 1000027 https://opencorporates.com/companies/gb/11326375   OpenCorporates https://opencorporates.com/companies/gb/11326375
1000027.identifiers.2 LISA CHANG LEE STUDIO LTD 1000027 /entities/4989068019152584957   OpenOwnership Register /entities/4989068019152584957
1000028.identifiers.0 Jkl Business Holdings Limited 1000028 https://opencorporates.com/companies/gb/06870419   OpenCorporates https://opencorporates.com/companies/gb/06870419
1000028.identifiers.1 Jkl Business Holdings Limited 1000028 /entities/6891682764162317833   OpenOwnership Register /entities/6891682764162317833
1000029.identifiers.0 ROCK BANK WEST (BRIXHAM) LIMITED 1000029 11272649 GB-COH Companies House  
1000029.identifiers.1 ROCK BANK WEST (BRIXHAM) LIMITED 1000029 https://opencorporates.com/companies/gb/11272649   OpenCorporates https://opencorporates.com/companies/gb/11272649
1000029.identifiers.2 ROCK BANK WEST (BRIXHAM) LIMITED 1000029 /entities/2423561101339791589   OpenOwnership Register /entities/2423561101339791589
100003.identifiers.0 NEXUS (NW) LIMITED 100003 08821322 GB-COH Companies House  
100003.identifiers.1 NEXUS (NW) LIMITED 100003 https://opencorporates.com/companies/gb/08821322   OpenCorporates https://opencorporates.com/companies/gb/08821322
100003.identifiers.2 NEXUS (NW) LIMITED 100003 /entities/3915737042394481317   OpenOwnership Register /entities/3915737042394481317
1000030.identifiers.0 EVENT FEST PRO LIMITED 1000030 11272650 GB-COH Companies House  
1000030.identifiers.1 EVENT FEST PRO LIMITED 1000030 https://opencorporates.com/companies/gb/11272650   OpenCorporates https://opencorporates.com/companies/gb/11272650
1000030.identifiers.2 EVENT FEST PRO LIMITED 1000030 /entities/13694295852311537664   OpenOwnership Register /entities/13694295852311537664
1000031.identifiers.0 TURKISH TWIGGS LIMITED 1000031 11272673 GB-COH Companies House  
1000031.identifiers.1 TURKISH TWIGGS LIMITED 1000031 https://opencorporates.com/companies/gb/11272673   OpenCorporates https://opencorporates.com/companies/gb/11272673
1000031.identifiers.2 TURKISH TWIGGS LIMITED 1000031 /entities/10335924368705454280   OpenOwnership Register /entities/10335924368705454280
1000032.identifiers.0 SPENCER COATINGS GROUP LIMITED 1000032 SC123258 GB-COH Companies House  
1000032.identifiers.1 SPENCER COATINGS GROUP LIMITED 1000032 https://opencorporates.com/companies/gb/SC123258   OpenCorporates https://opencorporates.com/companies/gb/SC123258
1000032.identifiers.2 SPENCER COATINGS GROUP LIMITED 1000032 /entities/14839384983428615802   OpenOwnership Register /entities/14839384983428615802
1000033.identifiers.0 ADM TRANSPORT SERVICES LTD 1000033 11272693 GB-COH Companies House  
1000033.identifiers.1 ADM TRANSPORT SERVICES LTD 1000033 https://opencorporates.com/companies/gb/11272693   OpenCorporates https://opencorporates.com/companies/gb/11272693
1000033.identifiers.2 ADM TRANSPORT SERVICES LTD 1000033 /entities/14265470545412803132   OpenOwnership Register /entities/14265470545412803132
1000034.identifiers.0 GT CARS LONDON LTD 1000034 11272695 GB-COH Companies House  
1000034.identifiers.1 GT CARS LONDON LTD 1000034 https://opencorporates.com/companies/gb/11272695   OpenCorporates https://opencorporates.com/companies/gb/11272695
1000034.identifiers.2 GT CARS LONDON LTD 1000034 /entities/9292526089363562461   OpenOwnership Register /entities/9292526089363562461
1000035.identifiers.0 LDT CREATIVE LIMITED 1000035 10977357 GB-COH Companies House  
1000035.identifiers.1 LDT CREATIVE LIMITED 1000035 https://opencorporates.com/companies/gb/10977357   OpenCorporates https://opencorporates.com/companies/gb/10977357
1000035.identifiers.2 LDT CREATIVE LIMITED 1000035 /entities/2085778377276028699   OpenOwnership Register /entities/2085778377276028699
1000036.identifiers.0 MAC-GAVER LTD 1000036 11272648 GB-COH Companies House  
1000036.identifiers.1 MAC-GAVER LTD 1000036 https://opencorporates.com/companies/gb/11272648   OpenCorporates https://opencorporates.com/companies/gb/11272648
1000036.identifiers.2 MAC-GAVER LTD 1000036 /entities/12749895479391604206   OpenOwnership Register /entities/12749895479391604206
1000037.identifiers.0 BENHAM ASSOCIATES LIMITED 1000037 05751088 GB-COH Companies House  
1000037.identifiers.1 BENHAM ASSOCIATES LIMITED 1000037 https://opencorporates.com/companies/gb/05751088   OpenCorporates https://opencorporates.com/companies/gb/05751088
1000037.identifiers.2 BENHAM ASSOCIATES LIMITED 1000037 /entities/9560814992298908917   OpenOwnership Register /entities/9560814992298908917
1000038.identifiers.0 ULAN UK LTD 1000038 11272677 GB-COH Companies House  
1000038.identifiers.1 ULAN UK LTD 1000038 https://opencorporates.com/companies/gb/11272677   OpenCorporates https://opencorporates.com/companies/gb/11272677
1000038.identifiers.2 ULAN UK LTD 1000038 /entities/10476424137056964515   OpenOwnership Register /entities/10476424137056964515
1000039.identifiers.0 R.G.D. BUILDING SERVICES LIMITED 1000039 04604785 GB-COH Companies House  
1000039.identifiers.1 R.G.D. BUILDING SERVICES LIMITED 1000039 https://opencorporates.com/companies/gb/04604785   OpenCorporates https://opencorporates.com/companies/gb/04604785
1000039.identifiers.2 R.G.D. BUILDING SERVICES LIMITED 1000039 /entities/12835821107273340470   OpenOwnership Register /entities/12835821107273340470
100004.identifiers.0 EYE FOR FINANCE LIMITED 100004 07327012 GB-COH Companies House  
100004.identifiers.1 EYE FOR FINANCE LIMITED 100004 https://opencorporates.com/companies/gb/07327012   OpenCorporates https://opencorporates.com/companies/gb/07327012
100004.identifiers.2 EYE FOR FINANCE LIMITED 100004 /entities/16036394983233364406   OpenOwnership Register /entities/16036394983233364406
1000040.identifiers.0 JACK COLLINS PROPERTY LTD 1000040 11272684 GB-COH Companies House  
1000040.identifiers.1 JACK COLLINS PROPERTY LTD 1000040 https://opencorporates.com/companies/gb/11272684   OpenCorporates https://opencorporates.com/companies/gb/11272684
1000040.identifiers.2 JACK COLLINS PROPERTY LTD 1000040 /entities/15178381024679187838   OpenOwnership Register /entities/15178381024679187838
1000041.identifiers.0 D F CATERERS (WAKEFIELD) LTD 1000041 11272686 GB-COH Companies House  
1000041.identifiers.1 D F CATERERS (WAKEFIELD) LTD 1000041 https://opencorporates.com/companies/gb/11272686   OpenCorporates https://opencorporates.com/companies/gb/11272686
1000041.identifiers.2 D F CATERERS (WAKEFIELD) LTD 1000041 /entities/9283004652413299800   OpenOwnership Register /entities/9283004652413299800
1000042.identifiers.0 MOBILIZED CONSTRUCTION LTD 1000042 11272647 GB-COH Companies House  
1000042.identifiers.1 MOBILIZED CONSTRUCTION LTD 1000042 https://opencorporates.com/companies/gb/11272647   OpenCorporates https://opencorporates.com/companies/gb/11272647
1000042.identifiers.2 MOBILIZED CONSTRUCTION LTD 1000042 /entities/7435188615989498353   OpenOwnership Register /entities/7435188615989498353
1000043.identifiers.0 JEREMY TANKARD TYPOGRAPHY LIMITED 1000043 04706912 GB-COH Companies House  
1000043.identifiers.1 JEREMY TANKARD TYPOGRAPHY LIMITED 1000043 https://opencorporates.com/companies/gb/04706912   OpenCorporates https://opencorporates.com/companies/gb/04706912
1000043.identifiers.2 JEREMY TANKARD TYPOGRAPHY LIMITED 1000043 /entities/9139149577285971033   OpenOwnership Register /entities/9139149577285971033
1000044.identifiers.0 360 FOTO LTD 1000044 11272651 GB-COH Companies House  
1000044.identifiers.1 360 FOTO LTD 1000044 https://opencorporates.com/companies/gb/11272651   OpenCorporates https://opencorporates.com/companies/gb/11272651
1000044.identifiers.2 360 FOTO LTD 1000044 /entities/18427902945628029792   OpenOwnership Register /entities/18427902945628029792
1000045.identifiers.0 OAK POINT COURT (HILLINGDON) MANAGEMENT LIMITED 1000045 11272655 GB-COH Companies House  
1000045.identifiers.1 OAK POINT COURT (HILLINGDON) MANAGEMENT LIMITED 1000045 https://opencorporates.com/companies/gb/11272655   OpenCorporates https://opencorporates.com/companies/gb/11272655
1000045.identifiers.2 OAK POINT COURT (HILLINGDON) MANAGEMENT LIMITED 1000045 /entities/157494599437074310   OpenOwnership Register /entities/157494599437074310
1000046.identifiers.0 A A BUILDING & RENOVATIONS LTD 1000046 11272663 GB-COH Companies House  
1000046.identifiers.1 A A BUILDING & RENOVATIONS LTD 1000046 https://opencorporates.com/companies/gb/11272663   OpenCorporates https://opencorporates.com/companies/gb/11272663
1000046.identifiers.2 A A BUILDING & RENOVATIONS LTD 1000046 /entities/16777164118558791479   OpenOwnership Register /entities/16777164118558791479
1000047.identifiers.0 AYLESTONE ELECTRICAL LIMITED 1000047 11272667 GB-COH Companies House  
1000047.identifiers.1 AYLESTONE ELECTRICAL LIMITED 1000047 https://opencorporates.com/companies/gb/11272667   OpenCorporates https://opencorporates.com/companies/gb/11272667
1000047.identifiers.2 AYLESTONE ELECTRICAL LIMITED 1000047 /entities/6582853252288562723   OpenOwnership Register /entities/6582853252288562723
1000048.identifiers.0 Ag124 Plc 1000048 11272454 GB-COH Companies House  
1000048.identifiers.1 Ag124 Plc 1000048 https://opencorporates.com/companies/gb/11272454   OpenCorporates https://opencorporates.com/companies/gb/11272454
1000048.identifiers.2 Ag124 Plc 1000048 /entities/6117860920053700604   OpenOwnership Register /entities/6117860920053700604
1000049.identifiers.0 Equitix Holdings Ltd 1000049 https://opencorporates.com/companies/gb/05972500   OpenCorporates https://opencorporates.com/companies/gb/05972500
1000049.identifiers.1 Equitix Holdings Ltd 1000049 /entities/16176831661352346442   OpenOwnership Register /entities/16176831661352346442
100005.identifiers.0 HORSES HELPING PEOPLE C.I.C. 100005 05879727 GB-COH Companies House  
100005.identifiers.1 HORSES HELPING PEOPLE C.I.C. 100005 https://opencorporates.com/companies/gb/05879727   OpenCorporates https://opencorporates.com/companies/gb/05879727
100005.identifiers.2 HORSES HELPING PEOPLE C.I.C. 100005 /entities/1261359102642733360   OpenOwnership Register /entities/1261359102642733360
1000050.identifiers.0 ORIGINAL NAWAB SPICE LTD 1000050 11272713 GB-COH Companies House  

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