query.sparql

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 ?sic (GROUP_CONCAT(?companyName;SEPARATOR="; ") as ?companies)
WHERE {
    bodsr:openownership-register-14662912447190623115 bods:ownsOrControls+ ?company .
    ?company cht:SicText ?sic .
    ?company foaf:name ?companyName .
}
GROUP BY ?sic
ORDER BY ?sic

results.csv