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
251. 214 B01 NZ
252. 212 B01 RU
253. 211 C02 US
254. 210 N02 AU
255. 210 R05 RO
256. 209 C10 NO
257. 208 A06 ES
258. 206 C10 MT
259. 206 R05 NL
260. 205 C07 ES
261. 203 C03 ES
262. 202 N03 CY
263. 201 J02 ES
264. 200 R06 IE
265. 200 L02 NL
266. 199 S01 NO
267. 199 N01 RO
268. 199 G03 SK
269. 199 J05 IE
270. 198 C08 RU
271. 198 N01 RU
272. 198 B05 IE
273. 197 J05 US
274. 195 C10 AU
275. 195 G03 RU
276. 195 C09 MK
277. 194 N04 IE
278. 194 L03 IE
279. 193 J07 RU
280. 192 J05 NZ
281. 192 A02 NZ
282. 192 A13 RU
283. 192 B03 ES
284. 190 D01 RU
285. 189 C03 AU
286. 189 A10 NO
287. 188 N07 ES
288. 187 N05 SI
289. 186 M01 MT
290. 186 N06 US
291. 186 A07 RU
292. 185 N03 ZA
293. 185 N03 RS
294. 185 D07 NZ
295. 184 C10 ZA
296. 184 G04 RS
297. 184 N03 AU
298. 183 C08 AU
299. 182 R01 ZA
300. 181 B03 IE