Skip to content

Instantly share code, notes, and snippets.

@cosmin-marginean
Created February 17, 2023 13:29
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/77b03c35f492acc23323706fdef5f3a8 to your computer and use it in GitHub Desktop.
Save cosmin-marginean/77b03c35f492acc23323706fdef5f3a8 to your computer and use it in GitHub Desktop.
BODS RDF - Control details for other companies
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 ?personName ?companyName ?interestType ?minShares
WHERE {
?person rdf:type bods:Person .
?person foaf:name ?personName .
?person bods:ownsOrControls bods-res:openownership-register-227513236687367494 .
?ctrlStatement bods:hasInterestedParty ?person .
?ctrlStatement bods:hasSubject ?company .
?ctrlStatement bods:statesInterest ?interest .
?interest bods:sharesMin ?minShares .
?interest bods:interestType ?interestType .
?company foaf:name ?companyName .
FILTER (!sameTerm(?company, bods-res:openownership-register-227513236687367494))
}
ORDER BY ?personName
personName companyName interestType minShares
Peter John Leuzzi CROWN COAST PROPERTY LIMITED shareholding 25.0
Peter John Leuzzi CROWN COAST PROPERTY LIMITED voting-rights 25.0
Peter John Leuzzi MAITLAND ROAD LIMITED shareholding 25.0
Peter John Leuzzi MAITLAND ROAD LIMITED voting-rights 25.0
Spencer Howard Simons CROWN COAST PROPERTY LIMITED shareholding 25.0
Spencer Howard Simons CROWN COAST PROPERTY LIMITED voting-rights 25.0
Spencer Howard Simons EMENSE INVESTMENTS LIMITED shareholding 50.0
Spencer Howard Simons EMENSE INVESTMENTS LIMITED voting-rights 50.0
Spencer Howard Simons MILLMORE PROPERTIES LIMITED shareholding 25.0
Spencer Howard Simons MILLMORE PROPERTIES LIMITED voting-rights 25.0
Spencer Howard Simons CROWNGLEN LIMITED shareholding 50.0
Spencer Howard Simons CROWNGLEN LIMITED voting-rights 50.0
Spencer Howard Simons CROWN COAST LIVING (COMMERCIAL ROAD) LIMITED shareholding 25.0
Spencer Howard Simons CROWN COAST LIVING (COMMERCIAL ROAD) LIMITED voting-rights 25.0
Spencer Howard Simons CROWN COAST LIVING (HEAD STREET) LIMITED shareholding 25.0
Spencer Howard Simons CROWN COAST LIVING (HEAD STREET) LIMITED voting-rights 25.0
Spencer Howard Simons DELATE LIMITED shareholding 75.0
Spencer Howard Simons DELATE LIMITED voting-rights 75.0
Spencer Howard Simons COOPERS ROAD LTD shareholding 25.0
Spencer Howard Simons COOPERS ROAD LTD voting-rights 25.0
Spencer Howard Simons CROWN COAST (WOODFORD) LIMITED shareholding 25.0
Spencer Howard Simons CROWN COAST (WOODFORD) LIMITED voting-rights 25.0
Spencer Howard Simons CROWN COAST NORBURY LIMITED shareholding 25.0
Spencer Howard Simons CROWN COAST NORBURY LIMITED voting-rights 25.0
Spencer Howard Simons CROWN HOLLAND DEVELOPMENTS LIMITED shareholding 25.0
Spencer Howard Simons CROWN HOLLAND DEVELOPMENTS LIMITED voting-rights 25.0
Spencer Howard Simons MAITLAND ROAD LIMITED shareholding 25.0
Spencer Howard Simons MAITLAND ROAD LIMITED voting-rights 25.0
Spencer Howard Simons CROWNGLEN COMMERCIAL LIMITED shareholding 75.0
Spencer Howard Simons CROWNGLEN COMMERCIAL LIMITED voting-rights 75.0
Spencer Howard Simons HOWARD SIMONS LIMITED shareholding 50.0
Spencer Howard Simons HOWARD SIMONS LIMITED voting-rights 50.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment