Skip to content

Instantly share code, notes, and snippets.

@cosmin-marginean

cosmin-marginean/query.sparql

Last active February 10, 2023 13:24
Show Gist options
  • Save cosmin-marginean/c05b882bf57f5c1b0a38c221bee67a00 to your computer and use it in GitHub Desktop.
Save cosmin-marginean/c05b882bf57f5c1b0a38c221bee67a00 to your computer and use it in GitHub Desktop.
Download ZIP
BODS RDF - People with direct or indirect control over a company, along with the entities that these people control directly.
Raw
query.sparql
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bods-res: <http://bods.openownership.org/resource/>
SELECT DISTINCT ?personName ?directControl (GROUP_CONCAT(?directControlCompanyName;SEPARATOR="; ") as ?companiesControlledDirectly)
WHERE {
?person bods:ownsOrControls+ bods-res:openownership-register-12337862642105981237 .
?person rdf:type bods:Person .
?person foaf:name ?personName .
BIND(EXISTS{?person bods:ownsOrControls bods-res:openownership-register-12337862642105981237} AS ?directControl)
OPTIONAL {
?person bods:ownsOrControls ?directControlCompany .
?directControlCompany foaf:name ?directControlCompanyName .
?directControlCompany bods:ownsOrControls+ bods-res:openownership-register-12337862642105981237 .
}
}
GROUP BY ?personName ?directControl
ORDER BY ?personName
Raw
results.csv
personName directControl companiesControlledDirectly
Emma Simons false EMENSE INVESTMENTS LIMITED; CROWNGLEN LIMITED
Peter John Leuzzi false WELLPOND INVESTMENT HOLDINGS LTD; GUARDIAN REAL ESTATE MANAGEMENT LIMITED; CCK PROPERTY INVESTMENTS LTD
Ross Kemp false K CAPITAL LTD
Sarah Louise Leuzzi false WELLPOND INVESTMENT HOLDINGS LTD
Spencer Howard Simons false EMENSE INVESTMENTS LIMITED; CROWNGLEN LIMITED; CCK PROPERTY INVESTMENTS LTD
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment