Table 3 SPARQL query generated by ODS for a dashboard

PREFIX ods: 〈http://www.imib.es/ontologies/disease-times 〉

SELECT count(DISTINCT ?s), ?t WHERE

{{?s rdf:type ?t FILTER (?t IN (ods:DrugTherapy, ods:Anti-hormoneTherapy,

ods:Anti-hormonal_anti-androgens, ods:Anti-hormonal_anti-estrogens,

ods:Anti-hormone_therapy_aromatase, ods:Other_Anti-hormoneTherapy,

ods:Chemotherapy, ods:Immunotherapy, ods:OtherdrugTherapy,

ods:Bisphosphonates, ods:Other_med_therapy,

ods:NuclearMedicineTherapy, ods:OpenRadionuclides,

ods:Other_nuclear_medicine_therapy, ods:RadioiodineTherapy,

ods:OtherTherapy, ods:Hyperthermia, ods:Locoregional_hyperthermia,

ods:Part-body_hyperthermia, ods:LightTherapy, ods:OtherLightTherapy,

ods:Selective_ultraviolet_phototherapy, ods:Wait_and_see,

ods:Radiotherapy, ods:Brachytherapy, ods:Interstitial_brachytherapy,

ods:Other_brachytherapy, ods:OtherHigh-voltageRadiotherapy,

ods:High-voltage_radiotherapy_n.n.bez.,

ods:Other_high-voltage_radiotherapy, ods:Whole-body_irradiation,

ods:Teletherapy, ods:OtherTeletherapy, ods:Teletherapy_n.n.bez.,

ods:Teletherapy_with_linear_accelerator, ods:StemCellTransplantation,

ods:AllogeneicSCT, ods:AutologousSCT, ods:SurgicalTreatment,

ods:Therapy))}.

{{?s ods:hasDiagnosis ?a0.

{?a0 rdf:type ?ta0 FILTER (?ta0 IN (ods:Diagnosis))} }.

{?a0 ods:hasPathologicalStructure ?a01.

{?a01 rdf:type ?ta01 FILTER (?ta01 IN (ods:Colorectal_cancer))} }.

{?s ods:hasPatient ?a1. {?a1 rdf:type ?ta1 FILTER (?ta1 IN (ods:Patient))} }.

{?a1 ods:age ?a12. FILTER (?a12 〉= 60)} }} group by ?t}