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
251. 301.88 ZAR N06 271 ZA
252. 301.114 EUR J02 26 CY
253. 299.16 MKD C09 145 MK
254. 297.745 AUD J07 2 AU
255. 295.069 NOK A03 13 NO
256. 291.004 ZAR C03 92 ZA
257. 290.46 NOK C05 5 NO
258. 283.443 EUR H05 10 CY
259. 270.931 MKD A03 14 MK
260. 269.112 MKD G01 14 MK
261. 268.813 ZAR AO4 5 ZA
262. 268.591 SVN J02 14 SI
263. 266.75 MKD C05 5 MK
264. 265.671 ZAR C3A 1 ZA
265. 264.328 ZAR JO5 4 ZA
266. 264.268 ZAR A11 21 ZA
267. 262.66 EUR L03 1 SK
268. 258.079 ZAR A12 15 ZA
269. 254.9 EUR J05 9 EE
270. 253.911 ZAR D08 16 ZA
271. 248.69 NOK D10 21 NO
272. 247.047 NOK M01 123 NO
273. 246.157 EUR L02 54 CY
274. 242.383 ZAR R03 228 ZA
275. 240.719 ZAR D10 32 ZA
276. 239.0 EGP V09 5 EG
277. 232.691 ZAR NO6 3 ZA
278. 229.24 ZAR C02 43 ZA
279. 229.009 NOK A02 171 NO
280. 228.936 ZAR H02 61 ZA
281. 228.775 ZAR A07 46 ZA
282. 227.074 MKD G02 5 MK
283. 226.74 ZAR JOS 4 ZA
284. 225.754 ZAR V06 1 ZA
285. 224.048 EGP V03 6 EG
286. 222.278 ZAR N02 373 ZA
287. 221.38 ZAR MO5 2 ZA
288. 220.692 ZAR RO1 4 ZA
289. 218.806 NOK C07 84 NO
290. 218.425 ZAR J1D 1 ZA
291. 216.086 ZAR SO1 5 ZA
292. 214.45 ZAR A10 235 ZA
293. 212.397 ZAR A08 31 ZA
294. 210.927 NOK R06 48 NO
295. 210.509 ZAR J04 61 ZA
296. 209.709 AUD V03 27 AU
297. 209.7 EUR B02 1 SK
298. 209.481 MKD D01 12 MK
299. 208.633 NOK A12 6 NO
300. 208.51 ZAR A01 17 ZA