This repo contains training material for the project.
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