training

This repo contains training material for the project.

Example request

Représentations réalisées et prévisionnelles d'une oeuvre donnée

SELECT ?title, ?lieu, ?date, ?event, ?performing_plan, ?expression, ?graphe 
WHERE
{GRAPH ?graphe {
{ SELECT DISTINCT * WHERE {      
?event a mus:M26_Foreseen_Performance ;
         mus:U7_foresees_place_at ?place ;
         mus:U8_foresees_time_span / time:hasBeginning / time:inXSDDate ?date ;
         mus:U77_foresees_performing_plan ?performing_plan .
?place rdfs:label ?lieu .
?performing_plan ecrm:P165_incorporates ?expression .
?expression a efrbroo:F22_Self-Contained_Expression ;
rdfs:label ?title .
FILTER contains(?title,"Symphonie fantastique")
}}
UNION
{ SELECT DISTINCT * WHERE {
?expression rdfs:label ?title.
?performance efrbroo:R66_included_performed_version_of ?expression ;
             ecrm:P7_took_place_at ?place ;
             ecrm:P4_has_time-span / time:hasBeginning / time:inXSDDate ?date.
?place rdfs:label ?lieu .
FILTER contains(?title,"Symphonie fantastique")
}}}}
ORDER BY ?date

Représentations à venir d'une oeuvre donnée.rtf

SELECT DISTINCT ?title, ?lieu, ?date, ?event, ?performing_plan, ?expression, ?graphe 
WHERE {   
GRAPH ?graphe {
    ?event a mus:M26_Foreseen_Performance ;
             mus:U7_foresees_place_at ?place ;
             mus:U8_foresees_time_span / time:hasBeginning / time:inXSDDate ?date ;
             mus:U77_foresees_performing_plan ?performing_plan .
    ?place rdfs:label ?lieu .
    ?performing_plan ecrm:P165_incorporates ?expression .
    ?expression a efrbroo:F22_Self-Contained_Expression ;
                  rdfs:label ?title .
    FILTER (contains(?title,"Symphonie fantastique") && ?date >= now() )
    }
}
ORDER BY ?date

Représentations à venir des oeuvres d'un compositeur donné (à la Philharmonie)

SELECT DISTINCT ?title, ?lieu, ?date, ?compositeur, ?event, ?performing_plan, ?expression, ?expCreation, ?graphe WHERE
{   
GRAPH ?graphe {
    ?event a mus:M26_Foreseen_Performance ;
             mus:U7_foresees_place_at ?place ;
             mus:U8_foresees_time_span / time:hasBeginning / time:inXSDDate ?date ;
             mus:U77_foresees_performing_plan ?performing_plan .
    ?place rdfs:label ?lieu .
    ?performing_plan ecrm:P165_incorporates ?expression .
    ?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 rdfs:label ?compositeur .
    FILTER (contains(?compositeur,"Fauré") && ?date >= now() && (contains(?lieu,"Boulez") || contains(?lieu,"Cité") || contains(?lieu,"Amphi")))
    }
}
ORDER BY ?date

Evolution of clavecin in timing (for each decade)

select ?year COUNT(?expression) where {
?expression mus:U13_has_casting / mus:U23_has_casting_detail / mus:U2_foresees_use_of_medium_of_performance_of_type  <http://data.doremus.org/vocabulary/iaml/mop/khp> .
?expCreation efrbroo:R17_created ?expression ;
             ecrm:P4_has_time-span / time:hasBeginning / time:inXSDDate ?time
BIND (SUBSTR(str(?time),1,3) as ?year)
} GROUP BY ?year
ORDER BY ?year