Get average drug price per ATC category, per country (GODD)

Get average drug price per ATC category, per country (GODD)

Endpoint: FINKI

Added by milos.jovanovik

Query:

prefix schema: <http://schema.org/> prefix drugbank: <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/> SELECT (?totalCost / ?drugCount as ?averageCost) ?costCurrency ?atc ?drugCount ?country WHERE { SELECT count (distinct ?drug) as ?drugCount sum (xsd:float(?cost)) as ?totalCost ?costCurrency ?atc ?country FROM <http://linkeddata.finki.ukim.mk/lod/data/godd#> WHERE { ?drug a schema:Drug ; schema:addressCountry ?country ; drugbank:atcCode ?atcCode ; schema:cost ?costEntity . ?costEntity schema:costPerUnit ?costPerUnit ; schema:costCurrency ?costCurrency . FILTER (strlen(?atcCode) > 3) BIND(SUBSTR(xsd:string(?atcCode), 1, 3) AS ?atc) FILTER (?costPerUnit != "0"^^xsd:double) BIND(REPLACE(?costPerUnit, ",", ".") AS ?cost) } } GROUP BY ?country ?atc ?costCurrency ORDER BY DESC (?averageCost)

Last run: about 1 year ago Run Now

Results:

Total: 717

averageCost costCurrency atc drugCount country
701. 3.97619 SVN C07 42 SI
702. 3.8 SVN D02 1 SI
703. 3.6475 EUR P02 8 CY
704. 3.614 EUR H03 5 SK
705. 3.57 EUR S03 1 SK
706. 3.55 SVN A12 5 SI
707. 3.55 EUR P03 1 CY
708. 3.42 EUR P02 2 EE
709. 3.36429 SVN H03 7 SI
710. 3.36 EUR D07 2 SK
711. 3.328 EUR A11 5 SK
712. 2.98333 EGP D04 6 EG
713. 2.78 SVN P01 1 SI
714. 2.71667 EUR D07 3 EE
715. 2.68 SVN D03 5 SI
716. 2.05 EGP A09 1 EG
717. 1.94 SVN D09 3 SI