Skip to content

Instantly share code, notes, and snippets.

@cosmin-marginean

cosmin-marginean/query.sparql

Created February 17, 2023 13:28
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/5a1946d2e531579650788d191c122305 to your computer and use it in GitHub Desktop.
Save cosmin-marginean/5a1946d2e531579650788d191c122305 to your computer and use it in GitHub Desktop.
Download ZIP
BODS RDF - Other companies controlled by the same individuals
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 ?personName ?companyName
WHERE {
?person rdf:type bods:Person .
?person foaf:name ?personName .
?person bods:ownsOrControls bods-res:openownership-register-227513236687367494 .
?person bods:ownsOrControls ?company .
?company foaf:name ?companyName .
FILTER (!sameTerm(?company, bods-res:openownership-register-227513236687367494))
}
ORDER BY ?personName
Raw
results.csv
personName companyName
Peter John Leuzzi CROWN COAST PROPERTY LIMITED
Peter John Leuzzi MAITLAND ROAD LIMITED
Peter John Leuzzi KENBUILD LIMITED
Spencer Howard Simons CROWN COAST PROPERTY LIMITED
Spencer Howard Simons EMENSE INVESTMENTS LIMITED
Spencer Howard Simons MILLMORE PROPERTIES LIMITED
Spencer Howard Simons CROWNGLEN LIMITED
Spencer Howard Simons CCK PROPERTY INVESTMENTS LTD
Spencer Howard Simons MAITLAND ROAD LIMITED
Spencer Howard Simons CROWN COAST LIVING (HEAD STREET) LIMITED
Spencer Howard Simons CROWN COAST LIVING (COMMERCIAL ROAD) LIMITED
Spencer Howard Simons CROWN HOLLAND DEVELOPMENTS LIMITED
Spencer Howard Simons HOWARD SIMONS LIMITED
Spencer Howard Simons CROWNGLEN COMMERCIAL LIMITED
Spencer Howard Simons DELATE LIMITED
Spencer Howard Simons COOPERS ROAD LTD
Spencer Howard Simons CROWN COAST (WOODFORD) LIMITED
Spencer Howard Simons CROWN COAST NORBURY LIMITED
Spencer Howard Simons KENBUILD LIMITED
Spencer Howard Simons THORNSTAND LIMITED
Spencer Howard Simons CROWNCOAST PROPERTIES LLP
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment