Publications

List publications with common citation information

The query returns a list of all publications along with common citation information.  The publication must have a venue type of bibo:Journal, and the journal must have a label and an issn, otherwise the publication will not be included in the results.  The publication may be of any type (AcademicArticle, Editorial, etc).  The most specific type of the article is identified and its label is included in the results.  The publication must have a date.  The three lines get the VIVO date time value, and its date string, and then parses the date string to return the first four characters of the date string, which is included in the results as year.  Five additional attributes are considered optional.  Publications will be included in the results regardless of whether these attributes (doi, start page, end page, volume, and issue) have values.

Publications

SELECT ?doi ?infoResourcepub_label ?pmid $typetype_label ?journalvenue_label ?issn ?pubVenue ?issue ?startPage ?endPage ?volume ?dateTimeyear
WHERE{
    ?infoResourcepub vivo:hasPublicationVenue ?pubVenuevenue .
    
    ?pubVenuevenue rdf:type bibo:Journal .
    ?infoResourcevenue rdfbibo:typeissn $anyType?issn .
    ?infoResourcevenue bibo:doi ?doirdfs:label ?venue_label .

    ?pub rdfs:label $pub_label .
    ?infoResourcepub bibovitro:pmidmostSpecificType ?pmidtype .
    ?infoResourcetype bibordfs:pageStartlabel ?startPagetype_label .
?infoResource bibo:pageEnd ?endPage .
?pubVenue bibo:issn ?issn .
  
    ?pub vivo:dateTimeValue ?dtv . 
    ?dtv vivo:dateTime ?dt .
    BIND(SUBSTR(str(?dt),1,4) AS ?year)
    
    OPTIONAL { ?pubVenuepub bibo:volumedoi ?volumedoi . }
  .
  OPTIONAL { ?pubVenuepub vivobibo:DateTimeValuepageStart ?dateTimestartPage . }
    .
OPTIONAL { ?pubVenuepub bibo:issuepageEnd ?issueendPage . } .
?pubVenue rdfs:label ?journal .
?anyType rdfs:label ?type .
?infoResource rdfs:label $infoResource_label .
}

Authors

   
    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.

SELECT ?year (COUNT(DISTINCT ?pub) AS ?count)
WHERE{
    ?pub

SELECT ?infoResource_label ?type ?author ?firstName ?lastName ?position_label ?department ?pemail
WHERE {
?infoResource vivo:hasPublicationVenue ?pubVenuevenue .
    
    ?pubVenuevenue rdf:type bibo:Journal .
    ?infoResourcevenue rdfbibo:typeissn ?anyTypeissn .
    ?anyTypevenue rdfs:label ?typevenue_label .

    ?infoResourcepub vivordfs:informationResourceInAuthorship ?authorshiplabel $pub_label .
?authorship rdf:type vivo:Authorship .
?authorship vivo:linkedAuthor ?authorURI .
?authorURI rdfs:label ?author .
?infoResource rdfs:label ?infoResource_label .
OPTIONAL { $authorURI foaf:firstName ?firstName } .
OPTIONAL { $authorURI foaf:lastName ?lastName } .
OPTIONAL { $authorURI vivo:primaryEmail ?pemail } .
?authorURI vivo:personInPosition ?position .
?position vivo:positionInOrganization $organization .
?organization rdfs:label ?department .
?position rdfs:label ?position_label .
}

Find Authors with less than 5 publications

Useful for finding good test cases, for example. This is a Vivo 1.5 example, but could be updated pretty easily.

  
    ?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

The WHERE clause begins by finding people who have one or more authorships.  Each person in the result must have an rdfs:label.  The query then groups by author.  A COUNT aggregation is used to get the publication count.  The results are ordered by descending publication count – the authors with the highest number of publications will be listed first.  Some people have more than one rdfs:label – they may have name variations and/or they may have names with or without various language tags.  An aggregation on the author label returns a single author name.  In this query we use STR to remove any language tags, and then use MIN to get the first name variant in alphabetical order.  If the person has just one rdfs:label, that label is returned as the name.

Note:  When GROUP BY is used, aggregations must be used in the SELECT statement to indicate what will be done with multiple values of each attribute to appear in the result.

Note:  The use of the COUNT aggregation with a GROUP BY is a standard SPARQL pattern for generating a frequency table.  In this query we are creating a frequency table of publications by author.

SELECT (MIN(STR(?author_label)) AS ?author_name) (COUNT(DISTINCT ?authorship) AS ?pub_count)
WHERE {
    ?author vivo:relatedBy ?authorship .
    ?author a foaf:Person .
    ?authorship a vivo:Authorship .
    
    ?author rdfs:label ?author_label .
}
GROUP BY ?author
ORDER BY DESC(?pub_count)

People with less than five publications

In the query below we select people that have at least one publication, but less than five.  VIVO uses "relatedBy" to associate people with authorships that indicate that the person is an author of the paper.  Note that the query insures that ?person is a foaf:Person and ?a is a vivo:Authorship.  relatedBy is used in other contexts so it is very important that we clarify which relatedBy assertions we are interested in.

SELECT ?person
WHERE
{
    ?person vivo:relatedBy ?a .
    ?person a foaf:Person .
    ?a a vivo:authorInAuthorshipAuthorship ?authorship. 
}
GROUP BY ?person
HAVING (COUNT(?authorshipa) < 5)
LIMIT 1