View YouTube videos, sorted by date (latest first).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX yt: <http://data.open.ac.uk/youtube/ontology/> | |
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
PREFIX dct: <http://purl.org/dc/terms/> | |
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> | |
PREFIX schema: <http://schema.org/> | |
SELECT | |
?code ?label (max(?published) as ?date) | |
FROM <http://data.open.ac.uk/context/youtube> | |
WHERE |
View Podcast tracks
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT ?download ?published | |
FROM <http://data.open.ac.uk/context/podcast> | |
WHERE { | |
?podcast <http://purl.org/dc/terms/published> ?published . | |
?podcast <http://digitalbazaar.com/media/download> ?download . | |
?podcast <http://purl.org/dc/terms/isPartOf> <http://data.open.ac.uk/podcast/collection/58dbd5be4f01f4b1eec1df1e8f97eaad> . | |
} order by desc (?published) |
View Properties of OpenLearn units
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select distinct ?property | |
from <http://data.open.ac.uk/context/openlearn> | |
where { | |
?subject a <http://data.open.ac.uk/openlearn/ontology/OpenLearnUnit> . | |
?subject ?property ?x | |
} |
View People names
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select distinct ?x | |
from <http://data.open.ac.uk/context/oro> { | |
?x <http://xmlns.com/foaf/0.1/familyName> ?y . | |
?x <http://xmlns.com/foaf/0.1/familyName> ?z . | |
filter(?z!=?y) | |
} |
View Course topic and avaibility
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
SELECT ?c ?l WHERE { | |
?c <http://purl.org/dc/terms/subject> <http://data.open.ac.uk/topic/spanish> . | |
?c rdfs:label ?l . | |
?c <http://data.open.ac.uk/saou/ontology#isAvailableIn> <http://sws.geonames.org/2921044/> | |
} |
View Course offers and prices
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select ?course ?price ?cur | |
from <http://data.open.ac.uk/context/course> | |
where { | |
?course <http://data.open.ac.uk/saou/ontology#OUCourseLevel> "1"^^<http://www.w3.org/2001/XMLSchema#string>. | |
?course <http://purl.org/dc/terms/subject> <http://data.open.ac.uk/topic/arts_and_humanities>. | |
?off <http://purl.org/goodrelations/v1#includes> ?course. | |
?off <http://purl.org/goodrelations/v1#hasPriceSpecification> ?ps. | |
?course <http://purl.org/net/mlo/location> <http://sws.geonames.org/3017382/>. | |
?off <http://purl.org/goodrelations/v1#availableAtOrFrom> <http://sws.geonames.org/3017382/>. | |
?ps <http://purl.org/goodrelations/v1#hasCurrencyValue> ?price. |
View Subject headings used to describe all podcasts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | |
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> | |
PREFIX dcterms: <http://purl.org/dc/terms/> | |
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | |
SELECT DISTINCT ?tlabel | |
FROM <http://data.open.ac.uk/context/podcast> | |
FROM <http://data.open.ac.uk/context/topic> | |
WHERE { |
View Subjects of Podcasts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX dct: <http://purl.org/dc/terms/> | |
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
select ?s ?y { | |
<http://data.open.ac.uk/podcast/9687b84ab18c389aace5b9fecdb42457> dct:isPartOf ?c . | |
?c dct:subject ?s . ?s rdfs:label ?y | |
} |
View Podcasts, OpenLearn units and the term “earthquake”
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX mlo: <http://purl.org/net/mlo/> | |
SELECT ?thing ?description | |
FROM <http://data.open.ac.uk/context/openlearn> | |
FROM <http://data.open.ac.uk/context/podcast> | |
where { | |
?thing <http://purl.org/dc/terms/description> ?description . | |
FILTER EXISTS { | |
{ ?thing a <http://data.open.ac.uk/openlearn/ontology/OpenLearnUnit> } | |
UNION |
NewerOlder