Skip to content

Instantly share code, notes, and snippets.

@cosmin-marginean
Created February 19, 2023 21:32
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/d368b6ec926b49ca907e915d1305bdf6 to your computer and use it in GitHub Desktop.
Save cosmin-marginean/d368b6ec926b49ca907e915d1305bdf6 to your computer and use it in GitHub Desktop.
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 bodsr: <http://bods.openownership.org/resource/>
PREFIX cht: <http://www.companieshouse.gov.uk/terms/>
SELECT DISTINCT ?companyName ?accountsDueDate
WHERE {
bodsr:openownership-register-11417256786033716182 bods:ownsOrControls+ ?company .
?company cht:AccountsNextDueDate ?accountsDueDate .
?company foaf:name ?companyName .
FILTER(?accountsDueDate < now())
}
companyName accountsDueDate
GFLE FRADDON LIMITED 2022-12-31
GFLE COSTON O&M LIMITED 2022-12-31
GFLE ENFIELD O & M LIMITED 2022-12-31
GFLE FROGMARY O&M LIMITED 2022-12-31
GFLE HARTNOLL O&M LIMITED 2022-12-31
GFLE RUSHYWOOD O&M LIMITED 2022-12-31
GFLE EDGEWORTHY O&M LIMITED 2022-12-31
GFLE GREAT HELE O&M LIMITED 2022-12-31
GFLE WILLAND O&M LIMITED 2022-12-31
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment