Get number of drugs per ATC category, per country (GODD)

Get number of drugs 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 count (distinct ?drug) as ?count ?atc ?country FROM <http://linkeddata.finki.ukim.mk/lod/data/godd#> WHERE { ?drug a schema:Drug ; schema:addressCountry ?country ; drugbank:atcCode ?atcCode . FILTER (strlen(?atcCode) > 3) BIND(SUBSTR(xsd:string(?atcCode), 1, 3) AS ?atc) } GROUP BY ?country ?atc ORDER BY DESC (?count)

Last run: over 1 year ago Run Now

Results:

Total: 2000

count atc country
151. 317 A07 US
152. 315 A02 IE
153. 313 L01 AU
154. 313 C10 IE
155. 312 C08 ES
156. 312 L03 RU
157. 307 C10 EE
158. 297 R03 IE
159. 297 M01 ZA
160. 296 N06 AU
161. 295 J01 AZ
162. 295 M02 RU
163. 295 J05 NL
164. 293 N05 MT
165. 291 A02 RU
166. 290 J05 ZA
167. 288 N05 AU
168. 287 C09 SI
169. 286 C10 US
170. 285 B03 RO
171. 284 A10 US
172. 282 L04 NL
173. 282 M01 US
174. 282 A02 US
175. 280 C09 MT
176. 279 G03 US
177. 277 N05 CY
178. 277 D11 RU
179. 275 N05 RS
180. 274 V08 RO
181. 274 G03 IE
182. 273 N07 RO
183. 273 B05 RS
184. 271 L01 CY
185. 271 N06 ZA
186. 268 J07 NL
187. 268 C09 CY
188. 266 M05 ES
189. 262 C01 RO
190. 259 M01 SK
191. 259 L01 MK
192. 259 R06 NL
193. 258 M05 NL
194. 257 S01 RO
195. 257 N07 RU
196. 256 A02 CY
197. 255 R06 ZA
198. 255 N01 ES
199. 252 M01 IE
200. 250 B03 NL