# events.csv: dates as the committee writes them (06/09/2025) and prices with a pound sign. PREFIX bt: PREFIX bs: PREFIX rdfs: PREFIX xsd: CONSTRUCT { ?event_iri a bs:Event ; rdfs:label ?label ; bs:heldAt ?shop_iri ; bs:eventKind ?kind ; bs:eventDate ?day ; bs:featuring ?author_iri ; bs:attendance ?people ; bs:ticketPrice ?ticket_price_value . } WHERE { BIND(IRI(CONCAT(STR(bt:), "event-", ?event)) AS ?event_iri) BIND(IRI(CONCAT(STR(bt:), "shop-", ?shop)) AS ?shop_iri) BIND(IRI(CONCAT(STR(bt:), "author-", ?featuring)) AS ?author_iri) BIND(STRLANG(?title, "en") AS ?label) # dd/mm/yyyy to yyyy-mm-dd, then cast: a date that is not one leaves ?day unbound BIND(xsd:date(CONCAT(SUBSTR(?date, 7, 4), "-", SUBSTR(?date, 4, 2), "-", SUBSTR(?date, 1, 2))) AS ?day) BIND(xsd:integer(?attendance) AS ?people) BIND(xsd:decimal(REPLACE(?ticket, "^£", "")) AS ?ticket_price_value) }