Skip to content

Instantly share code, notes, and snippets.

@cosmin-marginean

cosmin-marginean/query.sparql

Created February 9, 2023 22:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cosmin-marginean/69bf5e9a8e7a77e5a025c44aa4a9b98c to your computer and use it in GitHub Desktop.
Save cosmin-marginean/69bf5e9a8e7a77e5a025c44aa4a9b98c to your computer and use it in GitHub Desktop.
Download ZIP
BODS RDF - Ownership chain between a UBO and a company with intermediate shares percentage
Raw
query.sparql
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT ?parentName ?minShares ?childName
WHERE {
?ctrlStatement bods:hasInterestedParty ?parent .
?ctrlStatement bods:hasSubject ?child .
?ctrlStatement bods:statesInterest ?interest .
?interest bods:sharesMin ?minShares .
?parent foaf:name ?parentName .
?child foaf:name ?childName .
bods-res:openownership-register-1956793153964962452 bods:ownsOrControls* ?parent .
?child bods:ownsOrControls* bods-res:openownership-register-6295574063848670981 .
}
Raw
results.csv
parentName minShares childName
David John Darsey 25.0 ERITH HOLDINGS TRUSTEE LIMITED
ERITH HOLDINGS TRUSTEE LIMITED 75.0 ERITH HOLDINGS LIMITED
ERITH HOLDINGS LIMITED 75.0 ERITH CONTRACTORS LIMITED
ERITH CONTRACTORS LIMITED 25.0 LAND REMEDIATION LIMITED
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment