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
101. 434 R03 ES
102. 431 B05 SK
103. 421 B05 ES
104. 417 L01 NO
105. 413 L01 ZA
106. 409 C09 EE
107. 409 M01 NZ
108. 408 N05 ZA
109. 406 A02 NL
110. 403 L01 SK
111. 402 L04 RO
112. 402 J05 RU
113. 397 J01 NO
114. 395 A10 IE
115. 389 N03 IE
116. 386 J01 SK
117. 385 J01 CY
118. 384 G04 NL
119. 382 C10 SK
120. 380 C09 ZA
121. 380 R05 ES
122. 376 M05 RO
123. 376 C03 US
124. 375 S01 NL
125. 374 N02 ZA
126. 373 A01 NZ
127. 367 S01 ES
128. 365 N04 NL
129. 364 D07 US
130. 361 A07 NZ
131. 360 C09 US
132. 357 J05 RO
133. 354 J01 UA
134. 351 R06 ES
135. 350 C07 RU
136. 347 B01 ES
137. 346 C07 NL
138. 345 S01 RU
139. 335 J05 ES
140. 335 N06 EE
141. 335 J04 RU
142. 334 C10 RU
143. 331 N03 RU
144. 329 A10 RU
145. 328 J01 MK
146. 325 B01 NL
147. 325 R03 US
148. 321 B05 NO
149. 320 N07 NO
150. 320 R05 NZ