Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing Performances - Query help? #12

Open
samfsmith opened this issue Jan 22, 2019 · 1 comment
Open

Missing Performances - Query help? #12

samfsmith opened this issue Jan 22, 2019 · 1 comment

Comments

@samfsmith
Copy link

I am an undergraduate piano performance major doing research on piano performances at Carnegie. I constructed the following query:

This should return all performances of works that involve piano

PREFIX dcterms: http://purl.org/dc/terms/
PREFIX mo: http://purl.org/ontology/mo/
PREFIX event: http://purl.org/NET/c4dm/event.owl#
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
PREFIX xsd: http://www.w3.org/2001/XMLSchema#
PREFIX foaf: http://xmlns.com/foaf/0.1/
PREFIX gndo: http://d-nb.info/standards/elementset/gnd#

select ?date ?label ?composername ?title ?performername where {
?event a event:Event ;
dcterms:date ?date ;
rdfs:label ?label ;
event:product ?workPerformance .
?workPerformance event:product ?work ;
mo:performer ?performer .
?work dcterms:creator ?composer ;
rdfs:label ?title .
?composer foaf:name ?composername .
?performer gndo:playedInstrument ?instrument ;
foaf:name ?performername .
?instrument rdfs:label "piano" .
FILTER (?date > "1958-01-01"^^xsd:dateTime && ?date < "1959-01-01"^^xsd:dateTime)
}
ORDER BY ?date

Unfortunately, I am not getting all the piano performances. I know there was a solo piano recital on 1958-02-04 by Robert Muczynski, but my query does not return it. If I use the "Performance History Search" page, I can find it: https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&v=Carnegie%20Recital%20Hall_&start=-375735600&end=-375649200

But I can't seem to construct a query that will find that particular performance. If I am missing that performance, I am probably missing many others.

Any help in fixing my query would be appreciated.

Thanks!

@kgrons
Copy link
Member

kgrons commented Jan 22, 2019

Hi @samfsmith ! Thanks for your question and for sharing your query.

The reason you weren’t finding that particular performance is that at the time we published the data in June of 2017, this event was not part of the dataset. It was subsequently added to the PHS, which updates weekly. A procedure to update the RDF dataset on a weekly basis is in-progress, which you can track in Issue #13!

Another reason an event may not appear on data.carnegiehall.org (or the Performance History Search): since our archives weren’t established until 1986, we are missing some earlier documentation. We’re continually filling in the gaps when we come upon information for events we didn’t know took place. So it's always best to ask and we'd be happy to investigate.

To help answer your specific question, @robertmhudson added triples for the 1958 Robert Muczynski recital to the endpoint, so it will now be returned as part of the result set for your query when you run it again.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants