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
151. 740.25 MKD P02 2 MK
152. 734.137 NOK N03 174 NO
153. 733.745 NOK N05 360 NO
154. 731.571 EGP J02 7 EG
155. 725.94 SVN C02 34 SI
156. 717.62 MKD V07 4 MK
157. 715.498 ZAR P02 22 ZA
158. 700.59 EUR H01 1 SK
159. 688.451 ZAR A14 5 ZA
160. 687.75 ZAR LOI 2 ZA
161. 686.736 NOK R05 14 NO
162. 684.53 ZAR J02 74 ZA
163. 682.593 MKD D10 3 MK
164. 681.793 NOK D05 15 NO
165. 676.295 SVN N07 20 SI
166. 668.325 ZAR V01 2 ZA
167. 668.242 ZAR D05 12 ZA
168. 660.465 NOK G04 121 NO
169. 644.026 ZAR A05 4 ZA
170. 641.296 AUD J05 240 AU
171. 632.634 ZAR C01 78 ZA
172. 596.155 NOK A11 20 NO
173. 593.02 NOK N02 376 NO
174. 584.625 NOK A10 160 NO
175. 583.812 AUD J02 15 AU
176. 583.499 MKD N02 39 MK
177. 583.49 MKD AA0 2 MK
178. 577.794 SVN J07 7 SI
179. 569.736 EUR L03 5 EE
180. 567.496 SVN J06 13 SI
181. 564.048 ZAR N04 59 ZA
182. 560.607 MKD B05 97 MK
183. 559.338 MKD C04 11 MK
184. 558.655 ZAR N4A 3 ZA
185. 554.877 EUR V03 63 CY
186. 551.437 EUR B02 15 CY
187. 551.28 EUR J05 3 SK
188. 539.3 AUD C02 26 AU
189. 532.567 MKD C01 30 MK
190. 530.017 NOK A06 24 NO
191. 529.998 MKD A11 13 MK
192. 529.507 EUR B03 46 CY
193. 520.217 NOK H02 59 NO
194. 519.348 EUR R07 4 CY
195. 518.909 ZAR C04 7 ZA
196. 518.496 EUR C02 27 CY
197. 515.108 EUR N07 32 CY
198. 510.497 MKD H02 24 MK
199. 508.725 ZAR J05 289 ZA
200. 506.255 ZAR A09 6 ZA