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: about 1 year ago Run Now

Results:

Total: 2000

count atc country
201. 250 C07 NZ
202. 249 L03 NL
203. 248 R03 RU
204. 247 R06 RU
205. 247 R01 NL
206. 246 A05 RU
207. 246 A10 RS
208. 244 A01 US
209. 243 N07 NL
210. 242 J01 AU
211. 240 R02 RU
212. 240 L04 ES
213. 240 J05 AU
214. 239 N03 NO
215. 237 L01 MT
216. 237 C07 US
217. 237 R03 NO
218. 235 A10 ZA
219. 235 N06 MT
220. 235 B05 NL
221. 234 R06 NZ
222. 233 R03 NZ
223. 233 M03 US
224. 233 N06 NZ
225. 231 A02 ZA
226. 231 B03 RU
227. 230 B02 RU
228. 229 L02 ES
229. 229 N06 RS
230. 228 R03 ZA
231. 228 C01 NL
232. 227 R01 NZ
233. 227 V03 RO
234. 227 L03 RO
235. 224 A06 RU
236. 223 N02 MT
237. 223 QP5 NO
238. 221 R01 RU
239. 221 A02 RS
240. 220 G03 NZ
241. 220 M01 EE
242. 219 G04 IE
243. 219 N01 NL
244. 218 C07 SK
245. 218 C09 NZ
246. 217 N06 CY
247. 217 A02 NO
248. 216 C08 NL
249. 215 S01 IE
250. 215 J01 NG