SPARQL Endpoint IRI： https://ogura.mirko.jp/

SPARQL test form

PREFIX : <https://www.mirko.jp/ogura/LOD?> SELECT * FROM <https://www.mirko.jp/ogura/LOD/ogura> WHERE{ :ogura_001 ?p ?o } ORDER BY ?p ?o

Definition of metadata

Named Graph IRI :

https://www.mirko.jp/ogura/LOD/ogura	Dataset about works
https://www.mirko.jp/ogura/LOD/kajin	Dataset about creators
https://www.mirko.jp/ogura/LOD/translator	English translation data of works
https://www.mirko.jp/ogura/LOD/hishikawa	Dataset about works drawn by "Moronobu Hishikawa"
https://www.mirko.jp/ogura/LOD/izumiya	Dataset about works published by "Izumiya"
https://www.mirko.jp/ogura/LOD/shikishi_yomi	Dataset about works in "Ogura Sanso". (Cards for read)
https://www.mirko.jp/ogura/LOD/shikishi_tori	Dataset about works in "Ogura Sanso". (Cards for take)
https://www.mirko.jp/ogura/LOD/osakaml_utena	Dataset about works by "Toukou Sawada (Utena)"
https://www.mirko.jp/ogura/LOD/ndl_nazorae	Dataset about works drawn with traditional "Nishiki-e"

Base IRI (Common to all data) :
https://www.mirko.jp/ogura/LOD?

Prefix :

karuta	https://github.com/tnanako/karutalod#
xsd	http://www.w3.org/2001/XMLSchema#
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
rdfs	http://www.w3.org/2000/01/rdf-schema#
dc	http://purl.org/dc/elements/1.1/
dcterms	http://purl.org/dc/terms/
dcat	http://www.w3.org/ns/dcat#
geo	http://www.w3.org/2003/01/geo/wgs84_pos#
schema	http://schema.org/
foaf	http://xmlns.com/foaf/0.1/
owl	http://www.w3.org/2002/07/owl#
cc	http://creativecommons.org/ns#
bf	http://id.loc.gov/ontologies/bibframe/
bibo	http://bibliographic-ontology.org/bibo/
mads	http://www.loc.gov/standards/mads/rdf/v1#
dcndl	http://ndl.go.jp/dcndl/terms/

For the vocabulary used in the data, see "Ogura Hyakunin Isshu LOD". (Japanese only)

Sample queries

Get all data about Emperor Tenchi .

PREFIX : <https://www.mirko.jp/ogura/LOD?>
SELECT *
FROM <https://www.mirko.jp/ogura/LOD/kajin>
WHERE{ :kajin_001 ?p ?o } 
ORDER BY ?p ?o

Get a list of all authors.

PREFIX : <https://www.mirko.jp/ogura/LOD?>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX karuta: <https://github.com/tnanako/karutalod#>
PREFIX mads: <http://www.loc.gov/standards/mads/rdf/v1#>
SELECT ?s ?identifier ?name_ja ?name_roman ?name_en
FROM <https://www.mirko.jp/ogura/LOD/kajin>
WHERE {
 ?s dc:identifier ?identifier ;
    foaf:name ?name_ja ;
    karuta:romanTranscription ?name_roman ;
    mads:hasTranslationVariant ?name_en .
} ORDER BY ?s

Get all the data about the poem written by Emperor Tenchi.

PREFIX : <https://www.mirko.jp/ogura/LOD?>
SELECT *
FROM <https://www.mirko.jp/ogura/LOD/ogura>
WHERE{ :ogura_001 ?p ?o } 
ORDER BY ?p ?o

Get translations of Emperor Tenchi's poems by four translators.

PREFIX : <https://www.mirko.jp/ogura/LOD?>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX karuta: <https://github.com/tnanako/karutalod#>
PREFIX bibo: <http://bibliographic-ontology.org/bibo/>
SELECT ?translator ?creator ?description
FROM <https://www.mirko.jp/ogura/LOD/translator>
WHERE
{
 {
  :porter_001 dc:creator ?creator ;
              karuta:text ?description ;
              bibo:translator ?translator .
 }UNION{
  :clay_001 dc:creator ?creator ;
              karuta:text ?description ;
              bibo:translator ?translator .
 }UNION{
  :dickins_001 dc:creator ?creator ;
              karuta:text ?description ;
              bibo:translator ?translator .
 }UNION{
  :noguchi_001 dc:creator ?creator ;
              karuta:text ?description ;
              bibo:translator ?translator .
 }
} ORDER BY ?translator

Get information about 6 pictures depicting Emperor Tenchi's poems.

PREFIX : <https://www.mirko.jp/ogura/LOD?>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX bibo: <http://bibliographic-ontology.org/bibo/>
SELECT *
WHERE {
 {
  :ndl_hishikawa_001 dc:identifier ?identifier ;
                     dc:contributor ?contributor ;
                     dc:publisher ?publisher ;
                     bibo:owner ?owner ;
                     dcterms:extent ?extent .
 }UNION{
  :nijl_izumiya_001 dc:identifier ?identifier ;
                    dc:contributor ?contributor ;
                    dc:publisher ?publisher ;
                    bibo:owner ?owner ;
                    dcterms:extent ?extent .
 }UNION{
  :ndl_shikishi_yomi_001 dc:identifier ?identifier ;
                         dc:contributor ?contributor ;
                         dc:publisher ?publisher ;
                         bibo:owner ?owner ;
                         dcterms:extent ?extent .
 }UNION{
  :ndl_shikishi_tori_001 dc:identifier ?identifier ;
                         dc:contributor ?contributor ;
                         dc:publisher ?publisher ;
                         bibo:owner ?owner ;
                         dcterms:extent ?extent .
 }UNION{
  :osakaml_utena_001 dc:identifier ?identifier ;
                     dc:contributor ?contributor ;
                     dc:publisher ?publisher ;
                     bibo:owner ?owner ;
                     dcterms:extent ?extent .
 }UNION{
  :ndl_nazorae_001 dc:identifier ?identifier ;
                    dc:contributor ?contributor ;
                    dc:publisher ?publisher ;
                    bibo:owner ?owner ;
                    dcterms:extent ?extent .
 }
filter(LANG(?contributor) = 'en' && LANG(?publisher) = 'en' && LANG(?owner) = 'en' && LANG(?extent) = 'en')
} ORDER BY ?identifier