Publications
List publications with common citation information
...
| Code Block |
|---|
| title | List publications with common citation information |
|---|
| linenumbers | true |
|---|
|
SELECT ?doi ?pub_label ?type_label ?venue_label ?issn ?issue ?startPage ?endPage ?volume ?year
WHERE{
?pub vivo:hasPublicationVenue ?venue .
?venue rdf:type bibo:Journal .
?venue bibo:issn ?issn .
?venue rdfs:label ?venue_label .
?pub rdfs:label $pub_label .
?pub vitro:mostSpecificType ?type .
?type rdfs:label ?type_label .
?pub vivo:dateTimeValue ?dtv .
?dtv vivo:dateTime ?dt .
BIND(SUBSTR(str(?dt),1,4) AS ?year)
OPTIONAL { ?pub bibo:doi ?doi . }
OPTIONAL { ?pub bibo:pageStart ?startPage . }
OPTIONAL { ?pub bibo:pageEnd ?endPage . }
OPTIONAL { ?pub bibo:volume ?volume . }
OPTIONAL { ?pub bibo:issue ?issue . }
} |
Count Publications by Year
The query creates a year variable for each publication and uses it to count publications by year. It uses the same selection criteria as the query above.
| Code Block |
|---|
| title | Count publications by year |
|---|
| linenumbers | true |
|---|
|
SELECT ?year (COUNT(DISTINCT ?pub) AS ?count)
WHERE{
?pub vivo:hasPublicationVenue ?venue .
?venue rdf:type bibo:Journal .
?venue bibo:issn ?issn .
?venue rdfs:label ?venue_label .
?pub rdfs:label $pub_label .
?pub vivo:dateTimeValue ?dtv .
?dtv vivo:dateTime ?dt .
BIND(SUBSTR(str(?dt),1,4) AS ?year)
}
GROUP BY ?year
ORDER BY DESC(?year) |
Authors
List authors by number of publications
...