Created
February 19, 2023 20:39
-
-
Save cosmin-marginean/56e470e1ac842676a0c94840d9515b1d to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | |
PREFIX foaf: <http://xmlns.com/foaf/0.1/> | |
PREFIX bods: <http://bods.openownership.org/vocabulary/> | |
PREFIX bodsr: <http://bods.openownership.org/resource/> | |
PREFIX cht: <http://www.companieshouse.gov.uk/terms/> | |
SELECT DISTINCT ?companyName (GROUP_CONCAT(?sic;SEPARATOR=",") as ?sicData) | |
WHERE { | |
bodsr:openownership-register-14662912447190623115 bods:ownsOrControls+ ?company . | |
?company foaf:name ?companyName . | |
?company cht:SicText ?sic . | |
} | |
GROUP BY ?companyName |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
companyName | sicData | |
---|---|---|
BIFFA GROUP LIMITED | 70100 - Activities of head offices,70100 - Activities of head offices,70100 - Activities of head offices | |
BIFFA GROUP HOLDINGS (UK) LIMITED | 70100 - Activities of head offices,70100 - Activities of head offices,70100 - Activities of head offices | |
GS ACQUISITIONS LIMITED | 70100 - Activities of head offices,70100 - Activities of head offices,70100 - Activities of head offices | |
BIFFA CORPORATE HOLDINGS LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
BIFFA CORPORATE SERVICES LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
BIFFA GS HOLDINGS LIMITED | 38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste | |
RECLAMATION AND DISPOSAL LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
BIFFA WASTE LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
BIFFA WEST SUSSEX HOLDCO LIMITED | 70100 - Activities of head offices,70100 - Activities of head offices,70100 - Activities of head offices | |
WHITE CROSS LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
BIFFA LEICESTER LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
CRESSEX INSURANCE SERVICES LIMITED | 65120 - Non-life insurance,65120 - Non-life insurance,65120 - Non-life insurance | |
NEWHURST ERF HOLDING LIMITED | 35110 - Production of electricity,35110 - Production of electricity,35110 - Production of electricity | |
COMPANY SHOP HOLDCO LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
MATERIALS RECOVERY NOMINEES LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
BIFFA GS UK HOLDINGS LIMITED | 38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste | |
BIFFA HOLDINGS LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
BIFFA UK GROUP LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
BIFFA WEST SUSSEX LIMITED | 38210 - Treatment and disposal of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste | |
WASTEDRIVE LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
NEWHURST ERF LIMITED | 35110 - Production of electricity,35110 - Production of electricity,35110 - Production of electricity | |
BIFFA GS ENVIRONMENTAL LIMITED | 38320 - Recovery of sorted materials,38320 - Recovery of sorted materials,38320 - Recovery of sorted materials | |
BIFFA GS (LPP) LIMITED | 38320 - Recovery of sorted materials,38320 - Recovery of sorted materials,38320 - Recovery of sorted materials | |
BIFFA GS (FC) LIMITED | 38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials | |
BIFFA MUNICIPAL LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
BIFFA (WES) LIMITED | 38320 - Recovery of sorted materials,38320 - Recovery of sorted materials,38320 - Recovery of sorted materials | |
BIFFA GS ENVIRONMENTAL RECYCLING LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
BIFFA GS (M&B) LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
BIFFA WASTE SERVICES LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
M. JOSEPH & SON (BIRMINGHAM) LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
RICHARD BIFFA (RECLAMATION) LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
ISLAND WASTE SERVICES LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
POPLARS RESOURCE MANAGEMENT COMPANY LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
BARGE WASTE MANAGEMENT LIMITED | 96090 - Other service activities n.e.c.,96090 - Other service activities n.e.c.,96090 - Other service activities n.e.c. | |
BIFFA UK LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
WITHNELL BRICK AND TERRA COTTA COMPANY(1912)LIMITED(THE) | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
WASTEDRIVE (MANCHESTER) LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
BIFFA GS (RUR) LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
SPECIALIST WASTE RECYCLING LIMITED | 38320 - Recovery of sorted materials,38320 - Recovery of sorted materials,38320 - Recovery of sorted materials | |
SYRACUSE WASTE LIMITED | 96090 - Other service activities n.e.c.,96090 - Other service activities n.e.c.,96090 - Other service activities n.e.c. | |
BIFFA ENVIRONMENTAL MUNICIPAL SERVICES LIMITED | 38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38120 - Collection of hazardous waste | |
AMBER ENGINEERING LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
BIFFA PENSION SCHEME TRUSTEES LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
WEIR WASTE SERVICES LIMITED | 38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38320 - Recovery of sorted materials,38210 - Treatment and disposal of non-hazardous waste | |
O'BRIEN WASTE RECYCLING SOLUTIONS HOLDINGS LIMITED | 64209 - Activities of other holding companies n.e.c.,64209 - Activities of other holding companies n.e.c.,64209 - Activities of other holding companies n.e.c. | |
CAMO LTD | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
COMPANY SHOP LIMITED | 47110 - Retail sale in non-specialised stores with food, beverages or tobacco predominating,47110 - Retail sale in non-specialised stores with food, beverages or tobacco predominating,47110 - Retail sale in non-specialised stores with food, beverages or tobacco predominating | |
FORGE RECYCLING (HOLDINGS) LIMITED | 64209 - Activities of other holding companies n.e.c.,64209 - Activities of other holding companies n.e.c.,64209 - Activities of other holding companies n.e.c. | |
BIFFA (UK) HOLDINGS LIMITED | 70100 - Activities of head offices,70100 - Activities of head offices,70100 - Activities of head offices | |
RUR3 ENVIRONMENTAL LIMITED | 74901 - Environmental consulting activities,74901 - Environmental consulting activities,74901 - Environmental consulting activities | |
SWR SMASH & GRAB LIMITED | 28990 - Manufacture of other special-purpose machinery n.e.c.,28990 - Manufacture of other special-purpose machinery n.e.c.,28990 - Manufacture of other special-purpose machinery n.e.c. | |
NEW STAR ENVIRONMENTAL LIMITED | 39000 - Remediation activities and other waste management services,39000 - Remediation activities and other waste management services,39000 - Remediation activities and other waste management services | |
SWRNEWSTAR LIMITED | 38320 - Recovery of sorted materials,38320 - Recovery of sorted materials,38320 - Recovery of sorted materials | |
LAVELLE & SONS LIMITED | 46770 - Wholesale of waste and scrap,46770 - Wholesale of waste and scrap,46770 - Wholesale of waste and scrap | |
BIFFA (CORBY) LIMITED | 77390 - Renting and leasing of other machinery, equipment and tangible goods n.e.c.,38320 - Recovery of sorted materials,77390 - Renting and leasing of other machinery, equipment and tangible goods n.e.c.,38320 - Recovery of sorted materials,77390 - Renting and leasing of other machinery, equipment and tangible goods n.e.c.,38320 - Recovery of sorted materials | |
BIFFA (WEST SUSSEX) RECYCLING LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
O'BRIEN WASTE RECYCLING SOLUTIONS LTD | 38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste | |
WEIR RECYCLING SERVICES LIMITED | 78300 - Human resources provision and management of human resources functions,78300 - Human resources provision and management of human resources functions,78300 - Human resources provision and management of human resources functions | |
CO-CRE8 SYSTEMS LIMITED | 46900 - Non-specialised wholesale trade,46900 - Non-specialised wholesale trade,46900 - Non-specialised wholesale trade | |
SIMPLY WASTE SOLUTIONS LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
COMMUNITY SHOP C.I.C. | 47190 - Other retail sale in non-specialised stores,47190 - Other retail sale in non-specialised stores,47190 - Other retail sale in non-specialised stores | |
FORGE RECYCLING (UK) LIMITED | 38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste,38110 - Collection of non-hazardous waste | |
UK WASTE MANAGEMENT HOLDINGS LIMITED | 70100 - Activities of head offices,70100 - Activities of head offices,70100 - Activities of head offices | |
BIFFA (EARLS BARTON) LIMITED | 46900 - Non-specialised wholesale trade,46770 - Wholesale of waste and scrap,38320 - Recovery of sorted materials,46900 - Non-specialised wholesale trade,46770 - Wholesale of waste and scrap,38320 - Recovery of sorted materials,46900 - Non-specialised wholesale trade,46770 - Wholesale of waste and scrap,38320 - Recovery of sorted materials | |
BIFFA WASTE MANAGEMENT LIMITED | 38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38110 - Collection of non-hazardous waste,38210 - Treatment and disposal of non-hazardous waste | |
UK WASTE MANAGEMENT LIMITED | 38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste,38110 - Collection of non-hazardous waste,38220 - Treatment and disposal of hazardous waste,38210 - Treatment and disposal of non-hazardous waste,38120 - Collection of hazardous waste | |
NORWASTE LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
BIFFA (ROXBY) LIMITED | 99999 - Dormant Company,99999 - Dormant Company,99999 - Dormant Company | |
LORISTAN SERVICES LIMITED | 74990 - Non-trading company,74990 - Non-trading company,74990 - Non-trading company |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment