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
51. 4220.9 NOK V08 131 NO
52. 3864.8 NOK J02 49 NO
53. 3704.82 ZAR LO1 13 ZA
54. 3629.16 MKD R05 11 MK
55. 3461.41 NOK J05 99 NO
56. 3359.17 MKD A05 7 MK
57. 3300.55 MKD J02 15 MK
58. 3097.31 ZAR V08 115 ZA
59. 2973.34 ZAR VO3 1 ZA
60. 2787.28 ZAR BO3 5 ZA
61. 2583.08 NOK H05 17 NO
62. 2439.44 NOK L02 82 NO
63. 2425.0 AUD B06 1 AU
64. 2387.53 MKD A07 23 MK
65. 2331.18 ZAR H05 5 ZA
66. 2273.43 MKD G03 42 MK
67. 2259.23 NOK V01 10 NO
68. 2248.84 MKD M09 1 MK
69. 2242.65 ZAR L02 58 ZA
70. 2132.56 EUR L04 61 CY
71. 2072.89 MKD N01 35 MK
72. 1916.17 ZAR JO6 15 ZA
73. 1892.54 ZAR V03 29 ZA
74. 1791.28 ZAR B03 51 ZA
75. 1741.46 NOK B03 17 NO
76. 1730.86 MKD A04 18 MK
77. 1712.26 MKD J01 297 MK
78. 1709.91 ZAR J06 26 ZA
79. 1687.99 MKD S01 43 MK
80. 1668.66 MKD N04 31 MK
81. 1656.1 ZAR L1X 2 ZA
82. 1600.19 MKD N07 24 MK
83. 1579.52 ZAR B01 76 ZA
84. 1566.4 EGP L01 27 EG
85. 1564.14 NOK C03 63 NO
86. 1526.25 AUD L04 72 AU
87. 1464.01 ZAR JO2 1 ZA
88. 1452.84 ZAR BO5 93 ZA
89. 1399.42 ZAR M09 2 ZA
90. 1394.81 SVN L01 127 SI
91. 1387.03 MKD N03 69 MK
92. 1359.46 MKD H05 1 MK
93. 1306.78 ZAR V04 2 ZA
94. 1294.16 MKD R03 43 MK
95. 1277.1 NOK M03 26 NO
96. 1269.22 SVN A16 14 SI
97. 1227.05 AUD B02 6 AU
98. 1223.56 EUR H01 27 CY
99. 1192.5 EUR L01 271 CY
100. 1160.13 NOK J07 70 NO