Example queries

All the queries suppose this set of prefixes:

    PREFIX mus: <http://data.doremus.org/ontology#>
    PREFIX ecrm: <http://erlangen-crm.org/current/>
    PREFIX efrbroo: <http://erlangen-crm.org/efrbroo/>
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
    

#1: Work listing

Which works have been composed by Mozart? - results

    SELECT DISTINCT ?expression SAMPLE(?title) as ?title
    WHERE {
      ?expression a efrbroo:F22_Self-Contained_Expression ;
              rdfs:label ?title .
      ?expCreation efrbroo:R17_created ?expression ;
              ecrm:P9_consists_of / ecrm:P14_carried_out_by ?composer .
      ?composer foaf:name "Wolfgang Amadeus Mozart"
    } ORDER BY ?title
    

Which symphonies have been composed in 19th century? - results

SELECT DISTINCT ?expression, SAMPLE(?title) as ?title, SAMPLE(?composerName) as ?composerName, ?date
WHERE {
  ?expression a efrbroo:F22_Self-Contained_Expression ;
          rdfs:label ?title ;
          mus:U12_has_genre / skos:exactMatch* .

  ?expCreation efrbroo:R17_created ?expression ;
          ecrm:P4_has_time-span / time:hasBeginning / time:inXSDDate ?date ;
          ecrm:P9_consists_of / ecrm:P14_carried_out_by ?composer .
  ?composer foaf:name ?composerName

  FILTER (?date >= "1800"^^xsd:gYear AND ?date < "1900"^^xsd:gYear)
} ORDER BY ?date

#2: Work detail

Retrieve all the information about Beethoven’s Sonata for Cello and Piano - results

SELECT DISTINCT *
WHERE {
    VALUES ?expression { <http://data.doremus.org/expression/614925f2-1da7-39c1-8fb7-4866b1d39fc7> }
    ?expression a efrbroo:F22_Self-Contained_Expression ;
            rdfs:label ?title .
    OPTIONAL{?expression ecrm:P3_has_note ?note .}
    OPTIONAL {
      ?expression mus:U13_has_casting / mus:U23_has_casting_detail / mus:U2_foresees_use_of_medium_of_performance ?mop .
    }
    OPTIONAL{
      ?expression mus:U12_has_genre ?genre .
    }
    OPTIONAL{?expression mus:U17_has_opus_statement / ecrm:P3_has_note ?opus}
    OPTIONAL{?expression mus:U10_has_order_number ?order .}
    OPTIONAL{?expression mus:U11_has_key ?key . }
    OPTIONAL{?expression mus:U16_has_catalogue_statement / rdfs:label ?catalogue }
    OPTIONAL{
      ?expCreation efrbroo:R17_created ?expression .
      OPTIONAL {
        ?expCreation ecrm:P9_consists_of ?activity ;
                     ecrm:P4_has_time-span / time:hasBeginning / time:inXSDDate ?creationStart .
        ?activity ecrm:P14_carried_out_by ?composerUri ;
                  mus:U31_had_function  .
      }
    }
}
    

#3: Artist listing

List all composers - results

      SELECT DISTINCT ?artist SAMPLE(?name) as ?name
      WHERE {
          [] mus:U31_had_function  ;
              ecrm:P14_carried_out_by ?artist .
          ?artist foaf:name ?name
      }
    

List all performers - results

    SELECT DISTINCT ?artist SAMPLE(?name) as ?name
    WHERE {
        [] a mus:M28_Individual_Performance;
            ecrm:P14_carried_out_by ?artist .
        ?artist foaf:name ?name
    }
    

List all singers - results

    SELECT DISTINCT ?artist, SAMPLE(?name) as ?name, ?mop
    WHERE {
        [] a mus:M28_Individual_Performance;
            mus:U1_used_medium_of_performance ?mop;
            ecrm:P14_carried_out_by ?artist .
        ?artist foaf:name ?name.

        ?mop skos:broader 
    }
    

#4: Performances

List all performance of Bizet's Carmen - results

    SELECT DISTINCT *
    WHERE {
        ?performance efrbroo:R66_included_performed_version_of  .

        OPTIONAL { ?performance ecrm:P4_has_time-span / time:hasBeginning / time:inXSDDate ?time }
        OPTIONAL { ?performance ecrm:P7_took_place_at / (rdfs:label | geonames:name) ?place }
        OPTIONAL { ?performance ecrm:P3_has_note ?note }

     }
    

List all the concerts at Maison de la Radio - results

    SELECT DISTINCT *
    WHERE {
        ?performance a efrbroo:F31_Performance ;
                ecrm:P7_took_place_at <http://data.doremus.org/place/687896c9-0db7-31cf-8b20-5fa73dc268d6>
    }
    

#5: Foreseen Events

List all the performances forseen at the Philharmonie de Paris on January 2017 - results

    SELECT DISTINCT *
    WHERE {
      ?event a mus:M26_Foreseen_Performance ;
             rdfs:label ?title ;
             mus:U7_foresees_place_at <http://data.doremus.org/place/9e051b68-16bd-3371-8ee5-ab5c5ebc8455> ;
             mus:U8_foresees_time_span / time:hasBeginning / time:inXSDDate ?date .

       FILTER(year(?date) = 2017 AND month(?date) = 1)
    } ORDER BY ?date