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: over 1 year ago Run Now

Results:

Total: 717

averageCost costCurrency atc drugCount country
201. 502.977 NOK R03 220 NO
202. 497.818 NOK N07 213 NO
203. 495.0 NOK A08 3 NO
204. 493.79 MKD GO3 1 MK
205. 474.762 ZAR P01 22 ZA
206. 472.1 EUR L01 37 SK
207. 470.134 ZAR AO7 4 ZA
208. 468.44 ZAR N05 408 ZA
209. 467.536 AUD H01 29 AU
210. 439.431 SVN B01 56 SI
211. 431.819 ZAR S01 152 ZA
212. 426.404 MKD C07 50 MK
213. 426.19 MKD C10 70 MK
214. 421.81 NOK A05 10 NO
215. 421.267 NOK D01 24 NO
216. 420.14 AUD L02 73 AU
217. 417.701 ZAR D11 12 ZA
218. 417.586 ZAR A04 66 ZA
219. 408.454 MKD C02 12 MK
220. 406.865 ZAR LO2 1 ZA
221. 405.827 ZAR N5A 3 ZA
222. 398.917 EGP J05 15 EG
223. 395.436 ZAR N30 4 ZA
224. 391.606 ZAR N0 4 ZA
225. 387.218 ZAR NO3 5 ZA
226. 386.793 EUR L01 27 EE
227. 383.878 SVN D06 11 SI
228. 376.607 ZAR N03 185 ZA
229. 373.465 ZAR N07 64 ZA
230. 373.459 MKD A02 66 MK
231. 372.147 NOK C09 355 NO
232. 371.2 ZAR H04 1 ZA
233. 370.506 EUR M05 25 CY
234. 365.75 AUD H05 1 AU
235. 365.0 EGP H05 2 EG
236. 360.166 ZAR J07 68 ZA
237. 357.978 ZAR G03 162 ZA
238. 352.315 SVN L03 21 SI
239. 349.306 MKD R01 8 MK
240. 343.36 ZAR J01 975 ZA
241. 342.341 AUD M05 12 AU
242. 336.901 ZAR A2B 3 ZA
243. 333.016 SVN L02 34 SI
244. 328.968 NOK D06 28 NO
245. 327.333 EGP L02 6 EG
246. 326.733 MKD A06 6 MK
247. 321.081 ZAR PO1 1 ZA
248. 321.03 SVN H05 5 SI
249. 320.377 NOK C08 84 NO
250. 302.662 ZAR NO5 9 ZA