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

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

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/drugs#> 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) LIMIT 100

Last run: about 1 year ago Run Now

Results:

Total: 100

count atc country
51. 617 V03 RU
52. 615 A10 NL
53. 614 N06 RU
54. 613 J01 EG
55. 599 N02 RU
56. 593 L01 US
57. 589 N02 SK
58. 588 J02 RO
59. 585 B05 RU
60. 576 N03 SK
61. 572 C01 NZ
62. 569 N06 IE
63. 564 G04 ES
64. 563 N05 IE
65. 562 G04 RU
66. 537 L01 RS
67. 526 C09 RS
68. 520 B05 ZA
69. 520 A10 ES
70. 518 N06 SK
71. 517 J07 RO
72. 508 C09 AU
73. 507 J01 UG
74. 502 L02 RO
75. 499 J01 IE
76. 497 M01 NL
77. 490 C08 RO
78. 485 L01 NZ
79. 483 R03 NL
80. 482 N05 SK
81. 481 C10 NL
82. 478 N04 ES
83. 477 C01 US
84. 476 N05 NO
85. 473 L01 IE
86. 470 M01 RU
87. 470 G03 NL
88. 466 N02 IE
89. 464 N05 NZ
90. 459 N04 SK
91. 458 G03 ES
92. 455 N02 NO
93. 455 A03 RU
94. 452 J01 MT
95. 447 C09 NO
96. 445 J01 RS
97. 445 G03 RO
98. 443 G04 SK
99. 439 N06 NO
100. 434 R03 ES