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
1. 5362 C09 RO
2. 3444 N06 RO
3. 2563 N05 RO
4. 2399 C10 RO
5. 2152 C09 ES
6. 1856 A10 RO
7. 1773 N02 RO
8. 1725 L01 RO
9. 1651 N03 RO
10. 1602 N06 ES
11. 1557 N05 ES
12. 1536 J01 RU
13. 1488 C09 NL
14. 1439 J01 ES
15. 1391 J01 RO
16. 1270 N05 US
17. 1221 A02 RO
18. 1032 N05 NL
19. 1024 N04 RO
20. 1001 M01 RO
21. 982 N03 ES
22. 976 J01 ZA
23. 954 N02 ES
24. 954 N05 RU
25. 905 N06 NL
26. 901 B05 RO
27. 881 C10 ES
28. 873 N03 US
29. 867 C09 RU
30. 864 D08 RU
31. 862 L01 NL
32. 862 A02 ES
33. 860 C07 RO
34. 853 L01 RU
35. 847 R03 RO
36. 843 N02 NL
37. 786 R05 RU
38. 771 J01 NL
39. 762 L01 ES
40. 758 C09 IE
41. 739 G04 RO
42. 709 C09 SK
43. 707 N02 NZ
44. 692 J01 US
45. 687 M01 ES
46. 654 R06 RO
47. 653 B01 RO
48. 646 C01 RU
49. 634 J01 NZ
50. 628 N03 NL