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
1951. 1 Сел UA
1952. 1 M03 NG
1953. 1 P03 CY
1954. 1 H05 AZ
1955. 1 R1A ZA
1956. 1 P53 EG
1957. 1 QM0 EE
1958. 1 V06 MT
1959. 1 C04 CY
1960. 1 EVE UA
1961. 1 Ces UA
1962. 1 G01 NG
1963. 1 H02 NG
1964. 1 V06 NO
1965. 1 H04 UA
1966. 1 J1D ZA
1967. 1 V10 CY
1968. 1 Энз UA
1969. 1 Ant UA
1970. 1 QG0 EE
1971. 1 QH0 EE
1972. 1 D08 AU
1973. 1 D09 RS
1974. 1 A 1 ZA
1975. 1 D09 MT
1976. 1 GO3 MK
1977. 1 M09 CY
1978. 1 A08 AU
1979. 1 M04 SI
1980. 1 A04 NG
1981. 1 A09 AU
1982. 1 M02 US
1983. 1 V10 US
1984. 1 M09 RS
1985. 1 A08 MT
1986. 1 PO1 ZA
1987. 1 S03 ZA
1988. 1 QG0 RS
1989. 1 V10 SI
1990. 1 D03 UG
1991. 1 Y01 ZA
1992. 1 H04 RU
1993. 1 J4A ZA
1994. 1 non NZ
1995. 1 M05 NG
1996. 1 R ZA
1997. 1 H04 SI
1998. 1 JO4 ZA
1999. 1 Эрс UA
2000. 1 QS0 EE