Skip to content

Instantly share code, notes, and snippets.

@cosmin-marginean

cosmin-marginean/query.sparql

Created February 17, 2023 13:33
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/1e12c0f260e7d562419856767d553a2a to your computer and use it in GitHub Desktop.
Save cosmin-marginean/1e12c0f260e7d562419856767d553a2a to your computer and use it in GitHub Desktop.
Download ZIP
BODS RDF - All the companies that an individual controls directly
Raw
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 bods-res: <http://bods.openownership.org/resource/>
SELECT ?companyName ?interestType ?minShares
WHERE {
?ctrlStatement bods:hasInterestedParty bods-res:openownership-register-13699371219421575920 .
?ctrlStatement bods:hasSubject ?company .
?ctrlStatement bods:statesInterest ?interest .
?interest bods:sharesMin ?minShares .
?interest bods:interestType ?interestType .
?company foaf:name ?companyName .
}
ORDER BY ?companyName
Raw
results.csv
companyName interestType minShares
CROWN COAST (PLANTAGENET ROAD) LIMITED shareholding 25.0
CROWN COAST (PLANTAGENET ROAD) LIMITED voting-rights 25.0
CROWN COAST PROPERTY LIMITED shareholding 25.0
CROWN COAST PROPERTY LIMITED voting-rights 25.0
MAITLAND ROAD LIMITED shareholding 25.0
MAITLAND ROAD LIMITED voting-rights 25.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment