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
101. 1147.44 MKD A10 99 MK
102. 1141.44 MKD A08 1 MK
103. 1121.17 AUD L03 42 AU
104. 1111.03 NOK J01 376 NO
105. 1105.69 NOK C01 90 NO
106. 1104.52 SVN B06 2 SI
107. 1100.34 MKD M04 4 MK
108. 1100.0 EGP J06 1 EG
109. 1086.75 MKD H04 1 MK
110. 1031.71 NOK M05 34 NO
111. 1015.37 NOK D11 12 NO
112. 1015.02 EUR V09 3 CY
113. 1009.43 NOK V04 10 NO
114. 998.03 EUR M09 1 CY
115. 995.285 EUR J06 2 CY
116. 994.425 ZAR M05 38 ZA
117. 976.388 MKD A09 5 MK
118. 971.941 NOK G02 17 NO
119. 962.74 ZAR T02 1 ZA
120. 958.828 SVN B02 32 SI
121. 952.576 EUR A16 11 CY
122. 951.3 NOK V06 1 NO
123. 941.823 SVN H01 37 SI
124. 938.982 EUR J05 98 CY
125. 926.123 ZAR M03 41 ZA
126. 922.909 NOK C10 172 NO
127. 909.245 NOK N04 101 NO
128. 907.896 EUR L03 38 CY
129. 896.143 ZAR N01 108 ZA
130. 884.652 NOK A04 44 NO
131. 869.971 ZAR JOI 5 ZA
132. 861.075 NOK B05 318 NO
133. 860.0 AUD A16 1 AU
134. 854.474 SVN L04 81 SI
135. 848.235 AUD L01 313 AU
136. 845.05 NOK H04 2 NO
137. 822.978 NOK A07 60 NO
138. 803.182 ZAR G04 91 ZA
139. 800.624 NOK N06 345 NO
140. 799.106 NOK S01 166 NO
141. 794.945 NOK G03 134 NO
142. 792.108 AUD B03 40 AU
143. 788.057 NOK N01 94 NO
144. 786.613 MKD N05 155 MK
145. 777.623 MKD N06 106 MK
146. 775.132 ZAR G02 21 ZA
147. 760.067 AUD C04 3 AU
148. 754.862 SVN J05 36 SI
149. 752.959 ZAR B05 519 ZA
150. 742.87 MKD G04 36 MK